sticky.io logo

Billing & revenue integration

sticky.io reporting & revenue

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

133 sticky.io metrics you can use consistently

Maven keeps sticky.io numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.

AOV

Average order value from orders

Cancelled Orders

Orders marked cancelled in the canonical order fact

Completed Orders

Orders not marked cancelled in the canonical order fact

Ecommerce Discounts

Discounts from orders

Gross Revenue

Gross revenue from orders

Net Revenue

Net revenue from orders

Ecommerce Refunds

Refunds from orders

Ecommerce Subtotal Revenue

Order subtotal before tax shipping discounts and refunds

Collected Order Revenue

Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.

Show all 133 metrics

Order Count

Orders represented by the order-level ecommerce fact

Order Gross Revenue

Gross revenue at order grain

Order Net Revenue

Net revenue at order grain

Outstanding Order Revenue

Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.

Order Refunds

Refund amount at order grain

Order Shipping

Shipping amount charged on order-level ecommerce rows.

Order Tax

Tax amount collected on order-level ecommerce rows.

Order Units

Units sold at order grain

Orders

Count of orders

Platform Discount

Platform-funded discounts on TikTok Shop orders

Seller Discount

Seller-funded discounts on TikTok Shop orders

Shopify Current Order Value

Shopify order value after returns, sourced from currentTotalPriceSet.

SKU Count

Distinct SKU counts reported on TikTok Shop orders

Subtotal Price

Order subtotal before tax shipping discounts and refunds

TikTok Shop Items

Items represented on TikTok Shop orders

TikTok Shop Revenue

Gross revenue on TikTok Shop orders

Total Line Items

Line items represented across canonical orders

Total Weight

Units Sold (Ecommerce)

Units sold from orders

Current Order Value

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

Collected Order Revenue

Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.

Ecommerce Orders

Orders represented by the order-level ecommerce fact

Outstanding Order Revenue

Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.

Ecommerce Units Sold

Units sold at order grain

Ecommerce Product Discounts

Line-level product discounts.

Ecommerce Product Net Revenue

Net product revenue after line-level discounts.

Ecommerce Product Net Revenue After Refunds

Product revenue after discounts and line-linked refunds; group or filter by currency

Ecommerce Product Orders

Distinct orders containing this product.

Ecommerce Product Revenue

Gross product revenue across commerce and shopping product rows

Ecommerce Product Units Sold

Units sold for the product at daily grain.

Shopping Clicks

Product-listing clicks reported by Google Merchant Center

Shopping Conversions

Product-listing conversions reported by Google Merchant Center

Shopping Impressions

Product-listing impressions reported by Google Merchant Center

Shopping Revenue

Product-listing conversion revenue reported by Google Merchant Center

Active Subscribers

Paying users with active subscriptions reported by Paddle; excludes trialing users

Chargeback Count

Chargebacks received excluding alerts and reversals

Completed Checkouts

Paddle checkouts that completed a successful payment

Historical MRR

Official historical daily monthly recurring revenue reported by Paddle Billing

Current MRR

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.

MRR Change

Paddle MRR change compared with the same interval one month earlier

Checkout Conversion Rate

Completed Paddle checkouts divided by all checkouts

Paddle Checkouts

Checkouts opened during the selected period

Subscription Count

Latest active subscription count per platform account and currency across connected billing platforms

Subscription Net Revenue

Paddle completed-payment revenue after tax and fees and before refunds or chargebacks

Subscription Quantity

Latest subscribed seat or unit quantity per platform account and currency

Subscription Refunds

Paddle refunded product subtotal excluding chargebacks

Subscription Transaction Count

Completed transactions represented in Paddle net revenue

Checkouts

Checkouts opened during the selected period (Paddle today)

Subscription Charge Count

Recurring charges at charge grain across connected billing platforms

Subscription Charge Discount

Discount applied to the recurring charge.

Subscription Charge Revenue

Total recurring charge amount.

Subscription Charge Shipping

Shipping charged on the recurring charge.

Subscription Charge Subtotal

Charge subtotal before tax, shipping, and discounts.

Subscription Charge Tax

Tax charged on the recurring charge.

Conversion Weight (First Touch)

Fractional conversion credit under the first-touch model by conversion touchpoint

Conversion Weight (Last Touch)

Fractional conversion credit under the last-touch model by conversion touchpoint

Conversion Weight (Linear)

Fractional conversion credit under the linear model by conversion touchpoint

Conversion Weight (Markov)

Fractional conversion credit under the data-driven Markov removal-effect model by conversion touchpoint

Conversion Weight (Position Based)

Fractional conversion credit under the position-based model by conversion touchpoint

Conversion Weight (Shapley)

Fractional conversion credit under the data-driven Shapley-value model by conversion touchpoint

Conversion Weight (Time Decay)

Fractional conversion credit under the time-decay model by conversion touchpoint

Conversion Events

Canonical conversion/lead events counted through normalized last-touch weights

Answered Interactions

Source-neutral interactions that were answered

Average Answered Interaction Duration

Average duration in seconds among answered interactions

Avg Session Duration (s)

Average session duration in seconds with each session counted once

First-Touch Events

Touchpoints that opened a session

Interaction Answer Rate

Share of represented interactions that were answered

Interactions

Source-neutral interactions represented as attribution touchpoints

Last-Touch Events

Touchpoints that closed a session

Missed Interactions

Phone interactions that were neither answered nor sent to voicemail

Total Interaction Duration

Total interaction duration in seconds

Touchpoints

Journey touchpoint events recorded before conversion credit allocation

Touchpoint Order

Voicemail Interactions

Source-neutral interactions that reached voicemail

Average Lead Score

Average native lead score across CRM leads that provide a score

Converted Leads

CRM leads or contacts marked converted by native or inferred lifecycle evidence

Customer-Matched Leads

CRM leads or contacts that resolve to ecommerce customer identity

Lead Conversion Rate

Converted CRM leads divided by all CRM leads

Lead Count

CRM leads or contacts at lead/contact grain

Lead Customer Match Rate

CRM leads matched to ecommerce customers divided by all CRM leads

Lead Qualification Rate

Qualified CRM leads divided by all CRM leads

MQL Leads

CRM leads or contacts whose conformed lifecycle stage is marketing-qualified lead

MQL Rate

Marketing-qualified CRM leads divided by all CRM leads

Qualified Leads

CRM leads or contacts marked qualified by native or inferred lifecycle evidence

SQL Leads

CRM leads or contacts whose conformed lifecycle stage is sales-qualified lead

SQL Rate

Sales-qualified CRM leads divided by all CRM leads

Average Configured Product Price

Average configured offer-product price within the selected catalog slice (Konnektive configured price, Sticky.io offer-product price); group or filter by platform

Catalog Configurations

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 Activity Count

Payment operational records

Balance Ledger Amount

Signed gross amount on processor balance-ledger activity

Credit Amount

Credit amount applied to invoices

Payment Credit Count

Credits applied to invoices

Dispute Amount

Disputed amount

Payment Dispute Count

Dispute records

Failed Payment Count

Failed charge and terminal attempt records

Payment Fee Amount

Processing fees on balance activity

Gross Payment Amount

Successful gross charge amount

Net Balance Amount

Net balance activity after fees

Payout Amount

Amount settled to external accounts

Payment Payout Count

Payout records

Refund Amount

Successful refund activity amount

Payment Refund Count

Successful refund records

Successful Payment Count

Successful charge records

Dispute Count

Dispute records

Payment Events

Payment-processor activity records of every type (charge attempts, refunds, disputes, balance-ledger entries, payouts); filter activity_type for one lifecycle stage

Payout Count

Payout records

Sticky.io Average Offer Product Price

Average configured Sticky.io offer-product price within the selected catalog slice.

Sticky.io Catalog Configuration Count

Current Sticky.io campaign-offer-product-billing configurations

Subscription Item Count

Current subscription item count

Subscription Item MRR

Current fixed recurring amount normalized monthly at subscription-item grain

Subscription Item Quantity

Current subscription item quantity

Churned Subscriber Logos

Customers with starting MRR and zero ending MRR

Churned MRR

Starting MRR lost from customers ending the month inactive

Contraction MRR

Negative MRR movement among customers that remain active

Ending Subscriber Logos

Customers with positive MRR at the end of the month

Ending MRR

MRR at the end of the month; group or filter by currency and inspect history_method

Expansion MRR

Positive MRR movement among existing customers

Gross Revenue Retention

Recurring revenue retained before expansion and reactivation

Subscriber Logo Churn Rate

Share of starting subscriber logos that churned during the month

New MRR

MRR from customers first active in the month

Net Revenue Retention

Net recurring revenue retained including expansion and reactivation

Reactivation MRR

MRR from customers returning after an inactive month

Starting Subscriber Logos

Customers with positive MRR at the start of the month

Starting MRR

MRR at the start of the month; group or filter by currency and inspect history_method

Questions you can ask

Just ask Maven about sticky.io

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

What Maven pulls from sticky.io

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.

Accounts

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

Customers

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

Orders

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

Order items

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

Subscriptions

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

Subscription customers

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

Products

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

Campaigns

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

Campaign offers

Completed many-to-many campaign-to-offer bridge.

Offers

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

Offer products

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

Offer billing models

Completed offer-to-billing-model bridge with offer-specific discount configuration.

Fields: account name, billing model name, discount amount, discount percent

Billing models

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

Coupon profiles

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

Promo codes

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

Connect sticky.io to a client’s workspace

No SQL or warehouse setup. Connect the source, then build the client’s report by asking Claude or ChatGPT.

Step 1

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.

Step 2

Maven syncs and models the data

Maven pulls the client’s sticky.io data (5 objects) and models it into documented tables. No SQL, warehouse or pipeline setup.

Step 3

Report, ask and automate

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

Report sticky.io alongside the rest of your stack

FAQ

sticky.io reporting questions

What sticky.io metrics can I report on in Maven?

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.

What can I break sticky.io performance down by?

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.

Can I combine sticky.io with other data sources?

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.

What sticky.io data does Maven sync?

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.

How often does sticky.io data sync to Maven?

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.

Is my sticky.io data secure with Maven?

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.

Start your 14-day trial

Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.

  • Free for 14 days, no credit card
  • Your first client workspace and portal
  • Every report template, ready to clone
Start a 14-day trial

Nothing is charged unless you subscribe.

Prefer a walkthrough? Book a demo on one of your own clients.