# Ontraport datasets and fields

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

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

Maven lands 8 datasets from Ontraport in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [Ontraport integration page](https://mavendata.ai/integrations/ontraport).

## Connection and sync

You connect Ontraport with API key and app ID from the Ontraport account. Maven stores them encrypted.

Each Ontraport sync takes a fresh copy of the current records, so the workspace always reflects what is in Ontraport now.

## Datasets

### Contacts

Contacts, sales stage, ownership, first/last attribution, and LTV totals.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| address | Text |
| amount spent | Text |
| bulk mail | Text |
| bulk SMS | Text |
| cell phone | Text |
| city | Text |
| company | Text |
| contact category | Text |
| country | Text |
| created at | Text |
| currency | Text |
| custom fields | Text |
| email | Text |
| first name | Text |
| home phone | Text |
| job title | Text |
| last activity at | Text |
| last name | Text |
| lead campaign first | Text |
| lead campaign last | Text |
| lead content first | Text |
| lead content last | Text |
| lead grade | Text |
| lead medium first | Text |
| lead medium last | Text |
| lead source first | Text |
| lead source last | Text |
| lead term first | Text |
| lead term last | Text |
| office phone | Text |
| ontraport ID | Text |
| owner ID | Text |
| phone | Text |
| postal code | Text |
| priority | Text |
| purchases count | Text |
| referral page | Text |
| sales stage ID | Text |
| SMS number | Text |
| state | Text |
| timezone | Text |
| unique ID | Text |
| updated at | Text |
| website | Text |

### Transactions

Invoice and refund-receipt financial transactions.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| balance | Text |
| city | Text |
| contact ID | Text |
| currency | Text |
| date | Date |
| external order ID | Text |
| form ID | Text |
| gateway ID | Text |
| invoice ID | Text |
| is hidden | Text |
| landing page ID | Text |
| ontraport ID | Text |
| order ID | Text |
| postal code | Text |
| shipping | Text |
| state | Text |
| status | Text |
| status label | Text |
| subtotal | Text |
| tax | Text |
| timezone | Text |
| total | Text |
| transaction at | Text |
| transaction type | Text |
| transaction type label | Text |

### Purchases

Product-level completed purchases, subscriptions, plans, trials, and status.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| affiliate ID | Text |
| contact ID | Text |
| coupon code | Text |
| coupon name | Text |
| currency | Text |
| custom fields | Text |
| date | Date |
| description | Text |
| discount | Text |
| invoice ID | Text |
| name | Text |
| ontraport ID | Text |
| order ID | Text |
| owner ID | Text |
| product ID | Text |
| purchase type | Text |
| purchase type label | Text |
| purchased at | Text |
| quantity | Text |
| sku | Text |
| status | Text |
| status label | Text |
| subscription ID | Text |
| timezone | Text |
| total price | Text |
| unit price | Text |
| updated at | Text |

### Open orders

Recurring subscriptions, payment plans, setup fees, and future billing state.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| billing count | Text |
| billing status | Text |
| billing unit | Text |
| canceled at | Text |
| contact ID | Text |
| created at | Text |
| currency | Text |
| gateway ID | Text |
| invoice ID | Text |
| is hidden | Text |
| next payment at | Text |
| ontraport ID | Text |
| order ID | Text |
| payment amount | Text |
| payment due amount | Text |
| payment made | Text |
| payment remaining | Text |
| payment total | Text |
| product ID | Text |
| product name | Text |
| quantity | Text |
| subscription length | Text |
| subscription type | Text |
| subscription type label | Text |
| timezone | Text |
| total price | Text |
| trial amount | Text |

### Orders

Future invoice/order schedule and current or past-due status.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| billing count | Text |
| billing unit | Text |
| canceled at | Text |
| charged | Text |
| contact ID | Text |
| currency | Text |
| gateway ID | Text |
| is hidden | Text |
| last charge at | Text |
| name | Text |
| next charge | Text |
| next payment at | Text |
| offer ID | Text |
| ontraport ID | Text |
| shipping | Text |
| shipping city | Text |
| shipping country | Text |
| shipping postal code | Text |
| shipping state | Text |
| status | Text |
| tax | Text |
| timezone | Text |
| transactions | Text |
| transactions remaining | Text |
| updated at | Text |

### Products

Product catalog, price, SKU, and lifetime purchase totals.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| created at | Text |
| currency | Text |
| description | Text |
| external ID | Text |
| is deleted | Text |
| is taxable | Text |
| name | Text |
| ontraport ID | Text |
| price | Text |
| product group | Text |
| sku | Text |
| total income | Text |
| total purchases | Text |
| timezone | Text |
| updated at | Text |

### Tasks

Contact-linked tasks with owner, status, type, assignment, due, and completion dates.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| assigned at | Text |
| call outcome ID | Text |
| completed at | Text |
| contact ID | Text |
| currency | Text |
| date | Date |
| details | Text |
| drip ID | Text |
| due at | Text |
| is hidden | Text |
| item ID | Text |
| object name | Text |
| object type ID | Text |
| ontraport ID | Text |
| owner ID | Text |
| status | Text |
| status label | Text |
| step number | Text |
| subject | Text |
| task type | Text |
| task type label | Text |
| timezone | Text |

### Accounts

Authoritative account context and last fully completed snapshot marker.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| app ID | Text |
| currency | Text |
| resource counts json | Text |
| timezone | Text |
