# Keap datasets and fields

> The 12 datasets Maven lands from Keap, every field in them, and how the connection syncs.

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

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

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