Integrations
Keap datasets and fields
The 12 datasets Maven lands from Keap, every field in them, and how the connection syncs.
Maven lands 12 datasets from Keap in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the Keap integration page.
Connection and sync#
You connect Keap by signing in to it and approving access, so nobody shares a password.
The first Keap sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 12 months in total. After that, each scheduled sync re-reads the last 30 days, so late changes are picked up.
Datasets#
Business profile#
Keap tenant reporting context and business dimension.
| Field | Type |
|---|---|
| business name | Text |
| website | Text |
| time zone | Text |
| currency | Text |
| language tag | Text |
| business type | Text |
| business goals | Text |
| city | Text |
| state | Text |
| country | Text |
| postal code | Text |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Contacts#
Keap contacts with account-safe identity, company, consent, geography, attribution, tags, ownership, and governed custom fields.
| Field | Type |
|---|---|
| keap contact ID | Text |
| Text | |
| email opt status | Text |
| is email opt in | True/false |
| first name | Text |
| last name | Text |
| company ID | Text |
| company | Text |
| job title | Text |
| phone | Text |
| contact type | Text |
| lead source ID | Text |
| source type | Text |
| crm owner ID | Text |
| lead score | Number |
| tag IDs | Text |
| preferred locale | Text |
| contact time zone | Text |
| website | Text |
| city | Text |
| state | Text |
| country | Text |
| postal code | Text |
| first attribution UTM source | Text |
| first attribution UTM medium | Text |
| first attribution campaign | Text |
| first attribution UTM content | Text |
| first attribution UTM term | Text |
| first attribution keap source ID | Text |
| first attribution at | Timestamp |
| last attribution UTM source | Text |
| last attribution UTM medium | Text |
| last attribution campaign | Text |
| last attribution UTM content | Text |
| last attribution UTM term | Text |
| last attribution keap source ID | Text |
| last attribution at | Timestamp |
| custom fields | Text |
| created at | Timestamp |
| updated at | Timestamp |
| date | Date |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Companies#
Keap company/account dimension with contactable identity and governed custom fields.
| Field | Type |
|---|---|
| keap company ID | Text |
| company name | Text |
| Text | |
| phone | Text |
| website | Text |
| owner ID | Text |
| tag IDs | Text |
| city | Text |
| state | Text |
| country | Text |
| postal code | Text |
| custom fields | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Users#
Keap users/owners including active and inactive states.
| Field | Type |
|---|---|
| keap user ID | Text |
| user name | Text |
| first name | Text |
| last name | Text |
| Text | |
| title | Text |
| status | Text |
| is admin | True/false |
| is partner | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Lead sources#
Keap acquisition source, vendor, medium, category, status, and active window.
| Field | Type |
|---|---|
| keap lead source ID | Text |
| name | Text |
| description | Text |
| vendor | Text |
| medium | Text |
| status | Text |
| category ID | Text |
| start at | Timestamp |
| end at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Opportunity stages#
Current Keap opportunity-stage dimension with order, probability, target days, and checklist.
| Field | Type |
|---|---|
| keap stage ID | Text |
| stage name | Text |
| stage order | Integer |
| probability | Number |
| target days | Integer |
| checklist items | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Opportunities#
Keap current opportunity/deal snapshot with owner, contact, stage, value range, forecast, and next action.
| Field | Type |
|---|---|
| keap opportunity ID | Text |
| opportunity title | Text |
| contact ID | Text |
| contact name | Text |
| contact email | Text |
| contact company name | Text |
| stage ID | Text |
| stage name | Text |
| stage order | Integer |
| stage probability | Number |
| owner ID | Text |
| owner name | Text |
| projected revenue low | Number |
| projected revenue high | Number |
| include in forecast | True/false |
| estimated close at | Timestamp |
| next action at | Timestamp |
| next action notes | Text |
| custom fields | Text |
| created at | Timestamp |
| updated at | Timestamp |
| currency | Text |
| source timezone | Text |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Tags#
Keap tag dimension for contact and company segmentation.
| Field | Type |
|---|---|
| keap tag ID | Text |
| tag name | Text |
| description | Text |
| category ID | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Tasks#
Keap CRM task activity linked to contacts, opportunities, and owners.
| Field | Type |
|---|---|
| keap task ID | Text |
| title | Text |
| task type | Text |
| priority | Text |
| is completed | True/false |
| contact ID | Text |
| opportunity ID | Text |
| assigned to user ID | Text |
| due at | Timestamp |
| completed at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
| custom fields | Text |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Orders#
Keap order/invoice summary with collected, due, refunded, source, customer, currency, and geography context.
| Field | Type |
|---|---|
| keap order ID | Text |
| order title | Text |
| status | Text |
| order type | Text |
| source type | Text |
| contact ID | Text |
| contact email | Text |
| currency | Text |
| total amount | Number |
| total paid | Number |
| total due | Number |
| refund total | Number |
| line item count | Integer |
| quantity | Integer |
| invoice number | Text |
| invoice ID | Text |
| promo code | Text |
| refund status | Text |
| shipping city | Text |
| shipping state | Text |
| shipping country | Text |
| shipping postal code | Text |
| order at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
| date | Date |
| custom fields | Text |
| source timezone | Text |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Order items#
Keap order line-item grain with product hierarchy, quantity, unit economics, discount, and revenue.
| Field | Type |
|---|---|
| keap order ID | Text |
| keap order item ID | Text |
| keap product ID | Text |
| product name | Text |
| sku | Text |
| item type | Text |
| quantity | Integer |
| price per unit | Number |
| cost per unit | Number |
| discount amount | Number |
| gross revenue | Number |
| net revenue | Number |
| currency | Text |
| subscription ID | Text |
| date | Date |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |
Products#
Keap product catalog with SKU, price, tax/shipping/subscription flags, categories, and plans.
| Field | Type |
|---|---|
| keap product ID | Text |
| product name | Text |
| sku | Text |
| description | Text |
| price | Number |
| currency | Text |
| is active | True/false |
| is taxable | True/false |
| is shippable | True/false |
| is subscription only | True/false |
| category IDs | Text |
| subscription plans | Text |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source tenant ID | Text |