Connect sticky.io
In the client’s workspace, open Sources, add sticky.io and choose the account to sync. If you don’t have access to the account, send the client a connect link where the platform supports one.
Billing & revenue integration
Turn limeLight CRM customers, orders, products, recurring purchases, refunds, and attribution fields into 133 governed metrics for dashboards, agent answers, and cross-channel reporting.
What you can do with sticky.io in Maven
Maven models sticky.io into 133 governed metrics from the semantic layer. Track AOV, Cancelled Orders, Completed Orders, Ecommerce Discounts and Gross Revenue, break results down by Order Number, Source Timezone, Cancel Reason and Financial status, and report sticky.io alongside HubSpot CRM, Shopify and Google Analytics 4 without rebuilding exports or metric logic for every report.
What you can measure
Maven keeps sticky.io numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.
Average order value from orders
Orders marked cancelled in the canonical order fact
Orders not marked cancelled in the canonical order fact
Discounts from orders
Gross revenue from orders
Net revenue from orders
Refunds from orders
Order subtotal before tax shipping discounts and refunds
Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.
Orders represented by the order-level ecommerce fact
Gross revenue at order grain
Net revenue at order grain
Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.
Refund amount at order grain
Shipping amount charged on order-level ecommerce rows.
Tax amount collected on order-level ecommerce rows.
Units sold at order grain
Count of orders
Platform-funded discounts on TikTok Shop orders
Seller-funded discounts on TikTok Shop orders
Shopify order value after returns, sourced from currentTotalPriceSet.
Distinct SKU counts reported on TikTok Shop orders
Order subtotal before tax shipping discounts and refunds
Items represented on TikTok Shop orders
Gross revenue on TikTok Shop orders
Line items represented across canonical orders
Units sold from orders
Order value after post-purchase edits and returns (Shopify currentTotalPriceSet). Only Shopify reports this value, so the formula is limited to Shopify orders; other platforms' order totals are in ecommerce_gross_revenue
Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.
Orders represented by the order-level ecommerce fact
Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.
Units sold at order grain
Line-level product discounts.
Net product revenue after line-level discounts.
Product revenue after discounts and line-linked refunds; group or filter by currency
Distinct orders containing this product.
Gross product revenue across commerce and shopping product rows
Units sold for the product at daily grain.
Product-listing clicks reported by Google Merchant Center
Product-listing conversions reported by Google Merchant Center
Product-listing impressions reported by Google Merchant Center
Product-listing conversion revenue reported by Google Merchant Center
Paying users with active subscriptions reported by Paddle; excludes trialing users
Chargebacks received excluding alerts and reversals
Paddle checkouts that completed a successful payment
Official historical daily monthly recurring revenue reported by Paddle Billing
Latest monthly recurring revenue snapshot per platform, account, and currency. Stripe includes active and past-due fixed recurring items normalized monthly; excludes trials, free prices, metered usage, taxes, and one-time charges. Discounts are not yet netted from Stripe item prices.
Paddle MRR change compared with the same interval one month earlier
Completed Paddle checkouts divided by all checkouts
Checkouts opened during the selected period
Latest active subscription count per platform account and currency across connected billing platforms
Paddle completed-payment revenue after tax and fees and before refunds or chargebacks
Latest subscribed seat or unit quantity per platform account and currency
Paddle refunded product subtotal excluding chargebacks
Completed transactions represented in Paddle net revenue
Checkouts opened during the selected period (Paddle today)
Recurring charges at charge grain across connected billing platforms
Discount applied to the recurring charge.
Total recurring charge amount.
Shipping charged on the recurring charge.
Charge subtotal before tax, shipping, and discounts.
Tax charged on the recurring charge.
Fractional conversion credit under the first-touch model by conversion touchpoint
Fractional conversion credit under the last-touch model by conversion touchpoint
Fractional conversion credit under the linear model by conversion touchpoint
Fractional conversion credit under the data-driven Markov removal-effect model by conversion touchpoint
Fractional conversion credit under the position-based model by conversion touchpoint
Fractional conversion credit under the data-driven Shapley-value model by conversion touchpoint
Fractional conversion credit under the time-decay model by conversion touchpoint
Canonical conversion/lead events counted through normalized last-touch weights
Source-neutral interactions that were answered
Average duration in seconds among answered interactions
Average session duration in seconds with each session counted once
Touchpoints that opened a session
Share of represented interactions that were answered
Source-neutral interactions represented as attribution touchpoints
Touchpoints that closed a session
Phone interactions that were neither answered nor sent to voicemail
Total interaction duration in seconds
Journey touchpoint events recorded before conversion credit allocation
Source-neutral interactions that reached voicemail
Average native lead score across CRM leads that provide a score
CRM leads or contacts marked converted by native or inferred lifecycle evidence
CRM leads or contacts that resolve to ecommerce customer identity
Converted CRM leads divided by all CRM leads
CRM leads or contacts at lead/contact grain
CRM leads matched to ecommerce customers divided by all CRM leads
Qualified CRM leads divided by all CRM leads
CRM leads or contacts whose conformed lifecycle stage is marketing-qualified lead
Marketing-qualified CRM leads divided by all CRM leads
CRM leads or contacts marked qualified by native or inferred lifecycle evidence
CRM leads or contacts whose conformed lifecycle stage is sales-qualified lead
Sales-qualified CRM leads divided by all CRM leads
Average configured offer-product price within the selected catalog slice (Konnektive configured price, Sticky.io offer-product price); group or filter by platform
Current offer-catalog configurations: one valid source configuration of a sellable offer (Konnektive campaign x product, Sticky.io campaign x offer x product x billing model). Group or filter by platform
Payment operational records
Signed gross amount on processor balance-ledger activity
Credit amount applied to invoices
Credits applied to invoices
Disputed amount
Dispute records
Failed charge and terminal attempt records
Processing fees on balance activity
Successful gross charge amount
Net balance activity after fees
Amount settled to external accounts
Payout records
Successful refund activity amount
Successful refund records
Successful charge records
Dispute records
Payment-processor activity records of every type (charge attempts, refunds, disputes, balance-ledger entries, payouts); filter activity_type for one lifecycle stage
Payout records
Average configured Sticky.io offer-product price within the selected catalog slice.
Current Sticky.io campaign-offer-product-billing configurations
Current subscription item count
Current fixed recurring amount normalized monthly at subscription-item grain
Current subscription item quantity
Customers with starting MRR and zero ending MRR
Starting MRR lost from customers ending the month inactive
Negative MRR movement among customers that remain active
Customers with positive MRR at the end of the month
MRR at the end of the month; group or filter by currency and inspect history_method
Positive MRR movement among existing customers
Recurring revenue retained before expansion and reactivation
Share of starting subscriber logos that churned during the month
MRR from customers first active in the month
Net recurring revenue retained including expansion and reactivation
MRR from customers returning after an inactive month
Customers with positive MRR at the start of the month
MRR at the start of the month; group or filter by currency and inspect history_method
Questions you can ask
Maven’s agent answers in plain language with the right metric definitions applied automatically. These are real, verified questions it can run today.
What is our current MRR?
How many ecommerce orders did we get per week over the last 12 weeks?
Show ecommerce refunds by platform
Show cancelled orders by financial status
Show order discounts by customer type
Compare linear attribution weights by channel
Show attribution touchpoints by source
Connection and sync
You connect sticky.io with API username, API password and API URL from the sticky.io account. Maven stores them encrypted. The first sticky.io sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 3 years in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.
Tenant identity and the last fully completed catalog snapshot, including source currency, timezone, resource counts, and capability gaps.
Fields: account name, API host, default currency, timezone, currencies json, resource counts json, missing resources json
Account-scoped customer identity, geography, custom fields, lifecycle timestamps, and order counts discovered from customer and order updates.
Fields: account name, first name, last name, email, phone, city, state, postal code, country, created at, and 3 more
Account-scoped order, payment state, campaign/gateway, promotion, revenue/refund/chargeback, attribution, customer, and update fields; payment instruments are excluded.
Fields: account name, campaign name, gateway name, status code, status, is successful, is recurring, has recurring product, is refund, is void, and 38 more
Account-scoped latest product-line representation for each mutable order response, including recurring, trial, terminal, and refund state.
Fields: account name, item index, sku, name, quantity, unit price, refund amount, is recurring, is terminal, is trial, and 3 more
Account-scoped current or last-known subscription status, customer/order/product hierarchy, billing cadence, forecasted revenue, next bill, credit, and discount state.
Fields: account name, product name, next product name, billing model name, billing model type, status, quantity, unit price, forecasted revenue, next product price, and 12 more
Per-customer completed subscription snapshot markers; an empty current response retires superseded subscription rows without deleting other customers or accounts.
Fields: account name, subscription count
Completed account-scoped product catalog with price, cost, category, vertical, physical/bundle/variant flags, extensible attributes, and lifecycle timestamps.
Fields: account name, sku, name, description, price, cost of goods, declared value, restocking fee, weight, category name, and 17 more
Completed campaign dimension with channel, gateway, currency, countries, payment methods, status, and lifecycle timestamps.
Fields: account name, campaign name, description, channel name, gateway name, currency, is active, is archived, is collections enabled, is custom price allowed, and 7 more
Completed many-to-many campaign-to-offer bridge.
Completed offer dimension with recurring/prepaid/trial/seasonal configuration and lifecycle state.
Fields: account name, offer name, offer type, recurring type, terminating cycle type, recurring product name, expire cycles, is prepaid, is trial, trial days, and 6 more
Completed offer-to-product relationship bridge, including available, recurring, cycle, and seasonal positions and configured prices.
Fields: account name, product name, relationship type, position, price
Completed offer-to-billing-model bridge with offer-specific discount configuration.
Fields: account name, billing model name, discount amount, discount percent
Completed billing cadence dimension with human-readable type, normalized interval, expiry, buffer, schedule, and lifecycle state.
Fields: account name, billing model name, billing model type, description, recurring interval, recurring interval count, expire cycles, buffer days, preserve quantity, is default, and 6 more
Completed coupon profile dimension with discount, lifetime/free-shipping/BOGO flags, usage limits, products, and lifecycle state.
Fields: account name, coupon name, description, use count, discount amount, discount percent, minimum purchase, is lifetime, is active, is free shipping, and 10 more
Completed promo-code dimension with coupon relationship, usage, status, and creation context.
Fields: account name, code, use count, is active, is deleted, created at, timezone, source data
How it works
No SQL or warehouse setup. Connect the source, then build the client’s report by asking Claude or ChatGPT.
In the client’s workspace, open Sources, add sticky.io and choose the account to sync. If you don’t have access to the account, send the client a connect link where the platform supports one.
Maven pulls the client’s sticky.io data (5 objects) and models it into documented tables. No SQL, warehouse or pipeline setup.
Build the client’s report or deck by asking Claude or ChatGPT through the MCP, set alerts on what matters, and publish to the client’s portal once you approve it.
Works well with
FAQ
Maven exposes 133 governed sticky.io metrics, including AOV, Cancelled Orders, Completed Orders, Ecommerce Discounts, Gross Revenue and Net Revenue — each defined once so it means the same thing in every report.
You can break sticky.io metrics down by Order Number, Source Timezone, Cancel Reason, Financial status, Fulfillment status, Is Test, Taxes Included and Payment Gateway Names, and more.
Yes. sticky.io sits in the same client workspace as sources like HubSpot, Shopify, Google Analytics 4 and Google Ads, so one report or question can use them together.
Maven syncs customer identity and order counts, orders, refunds, risk, and attribution, order product and subscription lines, recurring product and next-billing state and product catalog from sticky.io.
Maven refreshes sticky.io on a schedule after the source is connected, and shows each source’s last sync time in the client’s workspace, so you can check the data is current before a report goes out.
Yes. Maven encrypts integration credentials and tokens, scopes access to the workspace, and uses the connection only to sync the reporting data needed for governed analytics.
Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.
Nothing is charged unless you subscribe.