# ClickFunnels 2.0 datasets and fields

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

Source: https://mavendata.ai/docs/integrations/clickfunnels

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](https://mavendata.ai/integrations/clickfunnels).

## 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.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| public ID | Text |
| team ID | Text |
| subdomain | Text |
| default currency | Text |
| timezone | Text |
| currencies json | Text |
| resource counts json | Text |
| missing resources json | Text |
| created at | Timestamp |
| updated at | Timestamp |

### Contacts

Workspace contacts with source attribution and lifecycle state.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| contact ID | Text |
| created at | Text |
| device type | Text |
| email | Text |
| first name | Text |
| is active | Text |
| landing page | Text |
| last name | Text |
| phone | Text |
| public ID | Text |
| referrer | Text |
| tags | Text |
| unsubscribed at | Text |
| updated at | Text |
| UTM campaign | Text |
| UTM content | Text |
| UTM medium | Text |
| UTM source | Text |
| UTM term | Text |

### Pipelines

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| pipeline ID | Text |
| public ID | Text |
| name | Text |
| total value | Number |
| created at | Timestamp |
| updated at | Timestamp |

### Pipeline stages

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| stage ID | Text |
| public ID | Text |
| pipeline ID | Text |
| name | Text |
| sort order | Integer |
| close probability | Number |
| total value | Number |
| weighted value | Number |
| opportunity count | Integer |
| created at | Timestamp |
| updated at | Timestamp |

### Opportunities

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| assignee ID | Text |
| close probability | Text |
| closed at | Text |
| contact email | Text |
| contact ID | Text |
| created at | Text |
| name | Text |
| opportunity ID | Text |
| pipeline ID | Text |
| pipeline name | Text |
| public ID | Text |
| stage ID | Text |
| stage name | Text |
| updated at | Text |
| value | Text |

### Orders

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| activated at | Text |
| billing status | Text |
| cancel reason | Text |
| canceled at | Text |
| churned at | Text |
| contact email | Text |
| contact ID | Text |
| created at | Text |
| in trial | Text |
| landing page | Text |
| live mode | Text |
| next charge at | Text |
| order ID | Text |
| order number | Text |
| order type | Text |
| origination channel ID | Text |
| origination channel name | Text |
| origination channel type | Text |
| page ID | Text |
| page name | Text |
| public ID | Text |
| recurring invoices paid count | Text |
| referrer | Text |
| service status | Text |
| shipping city | Text |
| shipping country | Text |
| shipping postal code | Text |
| shipping region | Text |
| total amount | Text |
| trial end at | Text |
| updated at | Text |
| UTM campaign | Text |
| UTM content | Text |
| UTM medium | Text |
| UTM source | Text |
| UTM term | Text |

### Order items

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| amount | Text |
| created at | Text |
| currency | Text |
| order ID | Text |
| order item ID | Text |
| price ID | Text |
| price name | Text |
| product ID | Text |
| product name | Text |
| prorated | Text |
| quantity | Text |
| updated at | Text |
| variant ID | Text |
| variant name | Text |

### Transactions

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| transaction ID | Text |
| public ID | Text |
| order ID | Text |
| transaction type | Text |
| status | Text |
| result | Text |
| amount | Number |
| currency | Text |
| reason | Text |
| adjusted transaction ID | Text |
| is rebill | True/false |
| rebill number | Integer |
| is refund | True/false |
| is dispute | True/false |
| is successful | True/false |
| created at | Timestamp |
| updated at | Timestamp |

### Invoices

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| contact ID | Text |
| created at | Text |
| currency | Text |
| discount amount | Text |
| due amount | Text |
| due at | Text |
| fulfillment status | Text |
| invoice ID | Text |
| invoice number | Text |
| invoice type | Text |
| issued at | Text |
| landing page | Text |
| order ID | Text |
| order type | Text |
| paid at | Text |
| payment processor | Text |
| public ID | Text |
| referrer | Text |
| shipping amount | Text |
| status | Text |
| subtotal amount | Text |
| tax amount | Text |
| total amount | Text |
| updated at | Text |
| UTM campaign | Text |
| UTM content | Text |
| UTM medium | Text |
| UTM source | Text |
| UTM term | Text |

### Invoice items

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| amount | Text |
| created at | Text |
| discount amount | Text |
| fulfillment status | Text |
| invoice ID | Text |
| invoice item ID | Text |
| payment type | Text |
| period end at | Text |
| period number | Text |
| period start at | Text |
| price ID | Text |
| product ID | Text |
| product name | Text |
| quantity | Text |
| tax amount | Text |
| updated at | Text |
| variant ID | Text |

### Products

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| archived | Text |
| commissionable | Text |
| created at | Text |
| default variant ID | Text |
| name | Text |
| path | Text |
| price IDs | Text |
| product ID | Text |
| public ID | Text |
| tag IDs | Text |
| updated at | Text |
| variant IDs | Text |
| visible in customer center | Text |
| visible in store | Text |

### Product variants

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| variant ID | Text |
| public ID | Text |
| product ID | Text |
| name | Text |
| sku | Text |
| product type | Text |
| is default | True/false |
| archived | True/false |
| visible | True/false |
| quantity | Integer |
| track quantity | True/false |
| out of stock sales | Text |
| fulfillment required | True/false |
| weight | Number |
| weight unit | Text |
| properties values | Text |
| fulfillment location IDs | Text |
| created at | Timestamp |
| updated at | Timestamp |

### Product prices

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| price ID | Text |
| public ID | Text |
| product ID | Text |
| variant ID | Text |
| name | Text |
| amount | Number |
| compare at amount | Number |
| cost | Number |
| currency | Text |
| payment type | Text |
| interval | Text |
| interval count | Integer |
| duration | Integer |
| trial interval | Text |
| trial duration | Integer |
| trial amount | Number |
| setup amount | Number |
| visible | True/false |
| archived | True/false |
| created at | Timestamp |
| updated at | Timestamp |

### Fulfillments

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| fulfillment ID | Text |
| public ID | Text |
| contact ID | Text |
| status | Text |
| shipping provider | Text |
| has tracking | True/false |
| location ID | Text |
| fulfillment number | Text |
| created at | Timestamp |
| updated at | Timestamp |

### Fulfillment items

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| fulfillment item ID | Text |
| public ID | Text |
| fulfillment ID | Text |
| invoice item ID | Text |
| quantity | Integer |

### Funnels

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| archived | Text |
| created at | Text |
| funnel ID | Text |
| live mode | Text |
| name | Text |
| path | Text |
| public ID | Text |
| tags | Text |
| updated at | Text |

### Pages

Page catalog with funnel/step placement and public URL.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| created at | Text |
| funnel ID | Text |
| funnel name | Text |
| name | Text |
| page ID | Text |
| page type | Text |
| path | Text |
| public ID | Text |
| SEO index | Text |
| SEO title | Text |
| step ID | Text |
| step name | Text |
| step sort order | Text |
| updated at | Text |
| URL | Text |

### Page stats

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| currency | Text |
| date | Date |
| funnel ID | Text |
| funnel name | Text |
| optins | Text |
| optin rate | Text |
| page ID | Text |
| page name | Text |
| page stats key | Text |
| page type | Text |
| period end | Text |
| period start | Text |
| recurring sales count | Text |
| recurring sales value | Text |
| sales count | Text |
| sales rate | Text |
| sales value | Text |
| earnings per view | Text |
| earnings per unique view | Text |
| step name | Text |
| unique views | Text |
| views | Text |
