ClickFunnels 2.0 logo

Billing & revenue integration

ClickFunnels 2.0 reporting & revenue

Turn contacts, pipelines, opportunities, orders, payments, recurring revenue, product pricing, fulfillments, funnels, pages, and daily conversion performance into 218 governed metrics for dashboards, agent answers, and cross-channel reporting.

What you can do with ClickFunnels 2.0 in Maven

Maven models ClickFunnels 2.0 into 218 governed metrics from the semantic layer. Track Average Days in Current Stage, Avg Days to Close, Avg Deal Size, Average Forecast Probability and Avg Open Deal Age, break results down by Deal Name, Pipeline, Deal stage and Stage Probability, and report ClickFunnels 2.0 alongside HubSpot CRM, Shopify and Google Analytics 4 without rebuilding exports or metric logic for every report.

What you can measure

218 ClickFunnels 2.0 metrics you can use consistently

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

Average Days in Current Stage

Average number of days open deals have remained in their current pipeline stage

Avg Days to Close

Average days from creation to close

Avg Deal Size

Average CRM deal amount calculated from deal amount divided by deal count

Average Forecast Probability

Average CRM forecast probability across deals that provide a forecast probability

Avg Open Deal Age

Average age of currently-open deals in days (creation to today)

Average Stage Probability

Average pipeline-stage probability across represented CRM deals

Closed Deals

CRM deals whose stage outcome is won or lost

CRM Deal-Account Associations

CRM deal-to-account associations where native account IDs are available

CRM Deal Associations

CRM deal association rows or summary counts, summed per deal

Show all 218 metrics

CRM Deal-Contact Associations

CRM deal-to-contact associations where native contact IDs are available

Deal Amount

CRM deal amount for monetary CRM opportunities; FranConnect lead rows have no amount

Deal Count

CRM deals or franchise-sales leads at deal grain

Forecast Amount

Num Contacts

Stage Display Order

Weighted Pipeline

Pipeline amount weighted by stage probability

Win Rate

Closed-won deals divided by all closed deals

Won Deals

Deals marked closed-won at the CRM stage outcome

Deal-Account Associations

CRM deal-to-account associations where native account IDs are available

Deal Associations

CRM deal association rows or summary counts, summed per deal

Deal-Contact Associations

CRM deal-to-contact associations where native contact IDs are available

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.

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

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

Amount Applied

Payment amount applied to linked invoices

Cash Collected

QuickBooks-canonical cash collected from payments (payments union is QB-first)

Payment Amount

Gross payment amount. Filter by direction: in is cash received from customers, out is cash paid to vendors.

Payment Application Count

Number of payment-to-document applications.

Payment Applied Amount

Amount of payments applied to invoices (direction in) or bills (direction out).

Payment Count

Number of payments.

Payment Net Amount

Payment amount net of fees and refunds.

Payment Refunded Amount

Amount refunded on payments.

Finance Payment Row Count

Rows on the merged payments surface (payment and application rows). Canonical measure; filter by direction and payment_row_type.

Payment Net Amount

Successful payment amount less refunds

Payment Refunded Amount

Refunded amount on payment headers

Vendor Payment Amount

Cash paid to vendors on QuickBooks bill-payment headers

Vendor Payment Applied Amount

Bill-payment amount allocated to linked QuickBooks bills

Vendor Payment Count

Count of current QuickBooks bill payments

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.

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

Ecommerce Purchases

Funnel Opt-in Rate

Opt-ins divided by unique page views

Funnel Opt-ins

Opt-ins attributed to ClickFunnels pages

Funnel Page Views

All ClickFunnels page views

Funnel Recurring Sales

Recurring sales attributed to ClickFunnels pages

Funnel Recurring Sales Value

Recurring sales value attributed to ClickFunnels pages

Funnel Sales

Sales attributed to ClickFunnels pages

Funnel Sales Conversion Rate

Sales divided by unique page views

Funnel Sales Value

Sales value attributed to ClickFunnels pages

Funnel Unique Page Views

Unique ClickFunnels page views

Purchase Revenue

Total Revenue

Transactions

Page Active Users

Active users by page or landing-page context

Page Conversions

Conversions by page or landing-page context

Page Engaged Sessions

Engaged sessions by page or landing-page context

Page Engagement Duration

Engagement duration by page or landing-page context

Page Events

Events by page or landing-page context

Page New Users

New users by page or landing-page context

Page Sessions

Sessions by page or landing-page context

Page Users

Users by page or landing-page context

Page Unique New Users

Re-aggregatable distinct first-time users by page or landing-page context via HLL sketch

Page Unique Users

Re-aggregatable distinct users by page or landing-page context via HLL sketch

Page Views by Page

Page views by page or landing-page context

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

Snapshot Closed Amount

Cumulative closed deal amount as of the snapshot date.

Snapshot Deal Count

Deals in the stage as of the snapshot date.

Lost Deals (Snapshot)

Cumulative closed-lost deals as of each snapshot date

Open Pipeline Value

Open deal amount in the pipeline as of each snapshot date

Open Deals (Snapshot)

Open deals in the pipeline as of each snapshot date

Weighted Pipeline (Snapshot)

Probability-weighted open pipeline value as of each snapshot date

Won Deals (Snapshot)

Cumulative closed-won deals as of each snapshot date

CRM Current Stage Observations

Current-stage snapshot observations in the CRM stage history surface

CRM Stage Events

CRM stage/property history events plus current-stage observations

Attributed Closed CRM Deals

Closed CRM deals with deterministic campaign attribution matched to paid delivery

Attributed CRM Deals

CRM deals with deterministic campaign attribution matched to paid delivery

Attributed Won CRM Deals

Won CRM deals with deterministic campaign attribution matched to paid delivery

Paid CRM Clicks

Paid-media clicks represented in the paid-to-CRM surface

Paid CRM Cost per Deal

Paid spend divided by attributed CRM deals

Paid CRM Cost per Won Deal

Paid spend divided by attributed won CRM deals

Deterministically Matched CRM Deals

Attributed deals backed by a deterministic identity match

Paid CRM Impressions

Paid-media impressions represented in the paid-to-CRM surface

Paid CRM Spend

Paid-media spend on campaign-day rows with CRM attribution coverage; group or filter by spend_currency

Attributed Closed Deals

Closed CRM deals with deterministic campaign attribution matched to paid delivery

Attributed Deals

CRM deals with deterministic campaign attribution matched to paid delivery

Attributed Won Deals

Won CRM deals with deterministic campaign attribution matched to paid delivery

Deterministically Matched Deals

Attributed deals backed by a deterministic identity match

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

Workspace Cash Collected

Monthly QuickBooks-canonical cash collected for workspace profitability

Workspace Delivery Billable Amount

Monthly delivery billable amount from time tracking

Workspace Delivery Cost Amount

Monthly delivery cost from time tracking

Workspace Ending AR

As-of-today open AR snapshot attributed to the current month only (not historical month-end AR)

Workspace Opex Amount

Monthly operating expenses for workspace profitability

Workspace Profitability Billable Hours

Workspace Profitability Hours Logged

Workspace Revenue Issued

Monthly canonical invoice revenue for workspace profitability

Questions you can ask

Just ask Maven about ClickFunnels 2.0

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?

What is our deal pipeline value by stage for deals created in the last 90 days?

Show closed deals by stage

Show average days to close by owner

Show average open deal age by owner

Show open pipeline by stage

Show won and lost deals in the latest pipeline snapshot by stage

Show closed amount by pipeline in the latest pipeline snapshot

Connection and sync

What Maven pulls from ClickFunnels 2.0

You connect ClickFunnels 2.0 by signing in to it and approving access, so nobody shares a password. The first ClickFunnels 2.0 sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 2 years in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.

Accounts

Authoritative ClickFunnels workspace identity and completed catalog snapshot context, including configured timezone, observed currencies, resource counts, and explicit capability gaps.

Fields: account name, subdomain, default currency, timezone, currencies json, resource counts json, missing resources json, created at, updated at

Contacts

Workspace contacts with source attribution and lifecycle state.

Fields: account name, created at, device type, email, first name, is active, landing page, last name, phone, referrer, and 8 more

Pipelines

Account-scoped CRM pipeline catalog with current total pipeline value.

Fields: account name, name, total value, created at, updated at

Pipeline stages

Account-scoped pipeline stages with order, close probability, opportunity counts, and value.

Fields: account name, name, sort order, close probability, total value, weighted value, opportunity count, created at, updated at

Opportunities

Pipeline opportunities, stages, assignees, contact identity, value, and close state.

Fields: account name, close probability, closed at, contact email, created at, name, pipeline name, stage name, updated at, value

Orders

Orders, subscription state, customer identity, revenue, fulfillment, and acquisition fields.

Fields: account name, activated at, billing status, cancel reason, canceled at, churned at, contact email, created at, in trial, landing page, and 22 more

Order items

Product, variant, price, quantity, currency, and amount lines attached to orders.

Fields: account name, amount, created at, currency, price name, product name, prorated, quantity, updated at, variant name

Transactions

Account-scoped order payment activity with sale, refund, dispute, decline, and rebill economics; payment-instrument identifiers are excluded.

Fields: account name, transaction type, status, result, amount, currency, reason, is rebill, rebill number, is refund, and 4 more

Invoices

Invoice status, revenue components, processor, fulfillment, customer, and attribution fields.

Fields: account name, created at, currency, discount amount, due amount, due at, fulfillment status, invoice number, invoice type, issued at, and 16 more

Invoice items

Invoice product lines, recurring periods, discounts, taxes, and fulfillment state.

Fields: account name, amount, created at, discount amount, fulfillment status, payment type, period end at, period number, period start at, product name, and 3 more

Products

Product catalog, visibility, variants, prices, and archive state.

Fields: account name, archived, commissionable, created at, name, path, updated at, visible in customer center, visible in store

Product variants

Account-scoped sellable product variants with inventory, fulfillment, SKU, property, and archive state.

Fields: account name, name, sku, product type, is default, archived, visible, quantity, track quantity, out of stock sales, and 6 more

Product prices

Account-scoped product and variant prices with one-time/recurring cadence, trial/setup economics, currency, and visibility.

Fields: account name, name, amount, compare at amount, cost, currency, payment type, interval, interval count, duration, and 8 more

Fulfillments

Account-scoped fulfillment lifecycle and safe carrier/tracking-presence metadata.

Fields: account name, status, shipping provider, has tracking, fulfillment number, created at, updated at

Fulfillment items

Account-scoped bridge from fulfillment records to invoice line items and fulfilled quantities.

Fields: account name, quantity

Funnels

Funnel catalog, paths, tags, live mode, and archive state.

Fields: account name, archived, created at, live mode, name, path, tags, updated at

Pages

Page catalog with funnel/step placement and public URL.

Fields: account name, created at, funnel name, name, page type, path, SEO index, SEO title, step name, step sort order, and 2 more

Page stats

Page and funnel views, opt-ins, sales, and recurring-sales aggregates for each extracted timerange.

Fields: account name, currency, funnel name, optins, optin rate, page name, page type, period end, period start, recurring sales count, and 9 more

How it works

Connect ClickFunnels 2.0 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 ClickFunnels 2.0

In the client’s workspace, open Sources, add ClickFunnels 2.0 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 ClickFunnels 2.0 data (18 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 ClickFunnels 2.0 alongside the rest of your stack

FAQ

ClickFunnels 2.0 reporting questions

What ClickFunnels 2.0 metrics can I report on in Maven?

Maven exposes 218 governed ClickFunnels 2.0 metrics, including Average Days in Current Stage, Avg Days to Close, Avg Deal Size, Average Forecast Probability, Avg Open Deal Age and Average Stage Probability — each defined once so it means the same thing in every report.

What can I break ClickFunnels 2.0 performance down by?

You can break ClickFunnels 2.0 metrics down by Deal Name, Pipeline, Deal stage, Stage Probability, Stage outcome, Source Timezone, Close date and Forecast Probability, and more.

Can I combine ClickFunnels 2.0 with other data sources?

Yes. ClickFunnels 2.0 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 ClickFunnels 2.0 data does Maven sync?

Maven syncs authoritative workspace identity, currency, timezone, and freshness, contacts, lifecycle state, and acquisition fields, cRM pipeline catalog and current value, pipeline stages, ordering, probability, and current value, pipeline opportunities, stages, values, and close state and orders, customers, recurring state, and attribution, and more from ClickFunnels 2.0.

How often does ClickFunnels 2.0 data sync to Maven?

Maven refreshes ClickFunnels 2.0 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 ClickFunnels 2.0 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.