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.
Billing & revenue integration
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
Maven keeps ClickFunnels 2.0 numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.
Average number of days open deals have remained in their current pipeline stage
Average days from creation to close
Average CRM deal amount calculated from deal amount divided by deal count
Average CRM forecast probability across deals that provide a forecast probability
Average age of currently-open deals in days (creation to today)
Average pipeline-stage probability across represented CRM deals
CRM deals whose stage outcome is won or lost
CRM deal-to-account associations where native account IDs are available
CRM deal association rows or summary counts, summed per deal
CRM deal-to-contact associations where native contact IDs are available
CRM deal amount for monetary CRM opportunities; FranConnect lead rows have no amount
CRM deals or franchise-sales leads at deal grain
Pipeline amount weighted by stage probability
Closed-won deals divided by all closed deals
Deals marked closed-won at the CRM stage outcome
CRM deal-to-account associations where native account IDs are available
CRM deal association rows or summary counts, summed per deal
CRM deal-to-contact associations where native contact IDs are available
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
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
Payment amount applied to linked invoices
QuickBooks-canonical cash collected from payments (payments union is QB-first)
Gross payment amount. Filter by direction: in is cash received from customers, out is cash paid to vendors.
Number of payment-to-document applications.
Amount of payments applied to invoices (direction in) or bills (direction out).
Number of payments.
Payment amount net of fees and refunds.
Amount refunded on payments.
Rows on the merged payments surface (payment and application rows). Canonical measure; filter by direction and payment_row_type.
Successful payment amount less refunds
Refunded amount on payment headers
Cash paid to vendors on QuickBooks bill-payment headers
Bill-payment amount allocated to linked QuickBooks bills
Count of current QuickBooks bill payments
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.
Current subscription item count
Current fixed recurring amount normalized monthly at subscription-item grain
Current subscription item quantity
Opt-ins divided by unique page views
Opt-ins attributed to ClickFunnels pages
All ClickFunnels page views
Recurring sales attributed to ClickFunnels pages
Recurring sales value attributed to ClickFunnels pages
Sales attributed to ClickFunnels pages
Sales divided by unique page views
Sales value attributed to ClickFunnels pages
Unique ClickFunnels page views
Active users by page or landing-page context
Conversions by page or landing-page context
Engaged sessions by page or landing-page context
Engagement duration by page or landing-page context
Events by page or landing-page context
New users by page or landing-page context
Sessions by page or landing-page context
Users by page or landing-page context
Re-aggregatable distinct first-time users by page or landing-page context via HLL sketch
Re-aggregatable distinct users by page or landing-page context via HLL sketch
Page views by page or landing-page context
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
Cumulative closed deal amount as of the snapshot date.
Deals in the stage as of the snapshot date.
Cumulative closed-lost deals as of each snapshot date
Open deal amount in the pipeline as of each snapshot date
Open deals in the pipeline as of each snapshot date
Probability-weighted open pipeline value as of each snapshot date
Cumulative closed-won deals as of each snapshot date
Current-stage snapshot observations in the CRM stage history surface
CRM stage/property history events plus current-stage observations
Closed CRM deals with deterministic campaign attribution matched to paid delivery
CRM deals with deterministic campaign attribution matched to paid delivery
Won CRM deals with deterministic campaign attribution matched to paid delivery
Paid-media clicks represented in the paid-to-CRM surface
Paid spend divided by attributed CRM deals
Paid spend divided by attributed won CRM deals
Attributed deals backed by a deterministic identity match
Paid-media impressions represented in the paid-to-CRM surface
Paid-media spend on campaign-day rows with CRM attribution coverage; group or filter by spend_currency
Closed CRM deals with deterministic campaign attribution matched to paid delivery
CRM deals with deterministic campaign attribution matched to paid delivery
Won CRM deals with deterministic campaign attribution matched to paid delivery
Attributed deals backed by a deterministic identity match
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
Monthly QuickBooks-canonical cash collected for workspace profitability
Monthly delivery billable amount from time tracking
Monthly delivery cost from time tracking
As-of-today open AR snapshot attributed to the current month only (not historical month-end AR)
Monthly operating expenses for workspace profitability
Monthly canonical invoice revenue for workspace profitability
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?
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
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.
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
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
Account-scoped CRM pipeline catalog with current total pipeline value.
Fields: account name, name, total value, created at, updated at
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
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, 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
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
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
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 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
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
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
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
Account-scoped fulfillment lifecycle and safe carrier/tracking-presence metadata.
Fields: account name, status, shipping provider, has tracking, fulfillment number, created at, updated at
Account-scoped bridge from fulfillment records to invoice line items and fulfilled quantities.
Fields: account name, quantity
Funnel catalog, paths, tags, live mode, and archive state.
Fields: account name, archived, created at, live mode, name, path, tags, updated at
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 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
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 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.
Maven pulls the client’s ClickFunnels 2.0 data (18 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 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.
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.
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.
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.
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.
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.