Integrations

ClickFunnels 2.0 datasets and fields

The 18 datasets Maven lands from ClickFunnels 2.0, every field in them, and how the connection syncs.

Maven lands 18 datasets from ClickFunnels 2.0 in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the ClickFunnels 2.0 integration page.

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.

Datasets#

Accounts#

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

FieldType
account IDText
account nameText
public IDText
team IDText
subdomainText
default currencyText
timezoneText
currencies jsonText
resource counts jsonText
missing resources jsonText
created atTimestamp
updated atTimestamp

Contacts#

Workspace contacts with source attribution and lifecycle state.

FieldType
account IDText
account nameText
contact IDText
created atText
device typeText
emailText
first nameText
is activeText
landing pageText
last nameText
phoneText
public IDText
referrerText
tagsText
unsubscribed atText
updated atText
UTM campaignText
UTM contentText
UTM mediumText
UTM sourceText
UTM termText

Pipelines#

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

FieldType
account IDText
account nameText
pipeline IDText
public IDText
nameText
total valueNumber
created atTimestamp
updated atTimestamp

Pipeline stages#

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

FieldType
account IDText
account nameText
stage IDText
public IDText
pipeline IDText
nameText
sort orderInteger
close probabilityNumber
total valueNumber
weighted valueNumber
opportunity countInteger
created atTimestamp
updated atTimestamp

Opportunities#

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

FieldType
account IDText
account nameText
assignee IDText
close probabilityText
closed atText
contact emailText
contact IDText
created atText
nameText
opportunity IDText
pipeline IDText
pipeline nameText
public IDText
stage IDText
stage nameText
updated atText
valueText

Orders#

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

FieldType
account IDText
account nameText
activated atText
billing statusText
cancel reasonText
canceled atText
churned atText
contact emailText
contact IDText
created atText
in trialText
landing pageText
live modeText
next charge atText
order IDText
order numberText
order typeText
origination channel IDText
origination channel nameText
origination channel typeText
page IDText
page nameText
public IDText
recurring invoices paid countText
referrerText
service statusText
shipping cityText
shipping countryText
shipping postal codeText
shipping regionText
total amountText
trial end atText
updated atText
UTM campaignText
UTM contentText
UTM mediumText
UTM sourceText
UTM termText

Order items#

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

FieldType
account IDText
account nameText
amountText
created atText
currencyText
order IDText
order item IDText
price IDText
price nameText
product IDText
product nameText
proratedText
quantityText
updated atText
variant IDText
variant nameText

Transactions#

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

FieldType
account IDText
account nameText
transaction IDText
public IDText
order IDText
transaction typeText
statusText
resultText
amountNumber
currencyText
reasonText
adjusted transaction IDText
is rebillTrue/false
rebill numberInteger
is refundTrue/false
is disputeTrue/false
is successfulTrue/false
created atTimestamp
updated atTimestamp

Invoices#

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

FieldType
account IDText
account nameText
contact IDText
created atText
currencyText
discount amountText
due amountText
due atText
fulfillment statusText
invoice IDText
invoice numberText
invoice typeText
issued atText
landing pageText
order IDText
order typeText
paid atText
payment processorText
public IDText
referrerText
shipping amountText
statusText
subtotal amountText
tax amountText
total amountText
updated atText
UTM campaignText
UTM contentText
UTM mediumText
UTM sourceText
UTM termText

Invoice items#

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

FieldType
account IDText
account nameText
amountText
created atText
discount amountText
fulfillment statusText
invoice IDText
invoice item IDText
payment typeText
period end atText
period numberText
period start atText
price IDText
product IDText
product nameText
quantityText
tax amountText
updated atText
variant IDText

Products#

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

FieldType
account IDText
account nameText
archivedText
commissionableText
created atText
default variant IDText
nameText
pathText
price IDsText
product IDText
public IDText
tag IDsText
updated atText
variant IDsText
visible in customer centerText
visible in storeText

Product variants#

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

FieldType
account IDText
account nameText
variant IDText
public IDText
product IDText
nameText
skuText
product typeText
is defaultTrue/false
archivedTrue/false
visibleTrue/false
quantityInteger
track quantityTrue/false
out of stock salesText
fulfillment requiredTrue/false
weightNumber
weight unitText
properties valuesText
fulfillment location IDsText
created atTimestamp
updated atTimestamp

Product prices#

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

FieldType
account IDText
account nameText
price IDText
public IDText
product IDText
variant IDText
nameText
amountNumber
compare at amountNumber
costNumber
currencyText
payment typeText
intervalText
interval countInteger
durationInteger
trial intervalText
trial durationInteger
trial amountNumber
setup amountNumber
visibleTrue/false
archivedTrue/false
created atTimestamp
updated atTimestamp

Fulfillments#

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

FieldType
account IDText
account nameText
fulfillment IDText
public IDText
contact IDText
statusText
shipping providerText
has trackingTrue/false
location IDText
fulfillment numberText
created atTimestamp
updated atTimestamp

Fulfillment items#

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

FieldType
account IDText
account nameText
fulfillment item IDText
public IDText
fulfillment IDText
invoice item IDText
quantityInteger

Funnels#

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

FieldType
account IDText
account nameText
archivedText
created atText
funnel IDText
live modeText
nameText
pathText
public IDText
tagsText
updated atText

Pages#

Page catalog with funnel/step placement and public URL.

FieldType
account IDText
account nameText
created atText
funnel IDText
funnel nameText
nameText
page IDText
page typeText
pathText
public IDText
SEO indexText
SEO titleText
step IDText
step nameText
step sort orderText
updated atText
URLText

Page stats#

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

FieldType
account IDText
account nameText
currencyText
dateDate
funnel IDText
funnel nameText
optinsText
optin rateText
page IDText
page nameText
page stats keyText
page typeText
period endText
period startText
recurring sales countText
recurring sales valueText
sales countText
sales rateText
sales valueText
earnings per viewText
earnings per unique viewText
step nameText
unique viewsText
viewsText