---
title: "ActiveCampaign data warehouse table groups"
slug: "activecampaign-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for ActiveCampaign. See all the tables and the fields included in them."
updated: 2026-03-05T14:17:06Z
published: 2026-03-05T14:17:06Z
canonical: "docs.supermetrics.com/activecampaign-data-warehouse-table-groups"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ActiveCampaign data warehouse table groups

Search fields

### Table: CAMPAIGN

| \| campaigns__analytics_campaign_name \| \| --- \| \| \\| Display name \\| Analytics campaign name \\| \\| --- \\| --- \\| \\| Description \\| Google Analytics campaign name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Analytics campaign name \| \| Description \| Google Analytics campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| campaigns__analytics_campaign_name |
| \| Display name \| Analytics campaign name \| \| --- \| --- \| \| Description \| Google Analytics campaign name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Analytics campaign name |
| Description | Google Analytics campaign name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaigns__campaign_id \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Description \| ID of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaigns__campaign_id |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Description \| ID of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Description | ID of the campaign |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaigns__campaign_message__sender_email \| \| --- \| \| \\| Display name \\| Sender email \\| \\| --- \\| --- \\| \\| Description \\| The email of the sender of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Sender email \| \| Description \| The email of the sender of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaigns__campaign_message__sender_email |
| \| Display name \| Sender email \| \| --- \| --- \| \| Description \| The email of the sender of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Sender email |
| Description | The email of the sender of the campaign |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaigns__campaign_message__subject \| \| --- \| \| \\| Display name \\| Subject \\| \\| --- \\| --- \\| \\| Description \\| Subject of the campaign message \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Subject \| \| Description \| Subject of the campaign message \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaigns__campaign_message__subject |
| \| Display name \| Subject \| \| --- \| --- \| \| Description \| Subject of the campaign message \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Subject |
| Description | Subject of the campaign message |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaigns__created_date \| \| --- \| \| \\| Display name \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| Date when the campaign was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date \| \| Description \| Date when the campaign was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| campaigns__created_date |
| \| Display name \| Created date \| \| --- \| --- \| \| Description \| Date when the campaign was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Created date |
| Description | Date when the campaign was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| campaigns__created_datetime \| \| --- \| \| \\| Display name \\| Created date & time \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the campaign was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date & time \| \| Description \| Date and time when the campaign was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| campaigns__created_datetime |
| \| Display name \| Created date & time \| \| --- \| --- \| \| Description \| Date and time when the campaign was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Created date & time |
| Description | Date and time when the campaign was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| campaigns__facebook_shares \| \| --- \| \| \\| Display name \\| Facebook shares \\| \\| --- \\| --- \\| \\| Description \\| Number of Facebook shares \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Facebook shares \| \| Description \| Number of Facebook shares \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__facebook_shares |
| \| Display name \| Facebook shares \| \| --- \| --- \| \| Description \| Number of Facebook shares \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Facebook shares |
| Description | Number of Facebook shares |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__forwards \| \| --- \| \| \\| Display name \\| Forwards \\| \\| --- \\| --- \\| \\| Description \\| Number of forwards \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Forwards \| \| Description \| Number of forwards \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__forwards |
| \| Display name \| Forwards \| \| --- \| --- \| \| Description \| Number of forwards \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Forwards |
| Description | Number of forwards |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__hard_bounces \| \| --- \| \| \\| Display name \\| Hard bounces \\| \\| --- \\| --- \\| \\| Description \\| Number of hard bounces \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Hard bounces \| \| Description \| Number of hard bounces \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__hard_bounces |
| \| Display name \| Hard bounces \| \| --- \| --- \| \| Description \| Number of hard bounces \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Hard bounces |
| Description | Number of hard bounces |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__modified_date \| \| --- \| \| \\| Display name \\| Last modified date \\| \\| --- \\| --- \\| \\| Description \\| Date when the campaign was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Last modified date \| \| Description \| Date when the campaign was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| campaigns__modified_date |
| \| Display name \| Last modified date \| \| --- \| --- \| \| Description \| Date when the campaign was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Last modified date |
| Description | Date when the campaign was last modified |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| campaigns__modified_datetime \| \| --- \| \| \\| Display name \\| Last modified date & time \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the campaign was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Last modified date & time \| \| Description \| Date and time when the campaign was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| campaigns__modified_datetime |
| \| Display name \| Last modified date & time \| \| --- \| --- \| \| Description \| Date and time when the campaign was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Last modified date & time |
| Description | Date and time when the campaign was last modified |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| campaigns__name \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Name of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaigns__name |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Name of the campaign |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaigns__segment_id \| \| --- \| \| \\| Display name \\| Segment ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the campaign segment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Segment ID \| \| Description \| ID of the campaign segment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaigns__segment_id |
| \| Display name \| Segment ID \| \| --- \| --- \| \| Description \| ID of the campaign segment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Segment ID |
| Description | ID of the campaign segment |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaigns__segment_name \| \| --- \| \| \\| Display name \\| Segment name \\| \\| --- \\| --- \\| \\| Description \\| Name of the campaign segment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Segment name \| \| Description \| Name of the campaign segment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaigns__segment_name |
| \| Display name \| Segment name \| \| --- \| --- \| \| Description \| Name of the campaign segment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Segment name |
| Description | Name of the campaign segment |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaigns__sends \| \| --- \| \| \\| Display name \\| Sends \\| \\| --- \\| --- \\| \\| Description \\| The total number of campaign sends \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Sends \| \| Description \| The total number of campaign sends \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__sends |
| \| Display name \| Sends \| \| --- \| --- \| \| Description \| The total number of campaign sends \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Sends |
| Description | The total number of campaign sends |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__sent_date \| \| --- \| \| \\| Display name \\| Last sent date \\| \\| --- \\| --- \\| \\| Description \\| Date when the campaign was last sent \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Last sent date \| \| Description \| Date when the campaign was last sent \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| campaigns__sent_date |
| \| Display name \| Last sent date \| \| --- \| --- \| \| Description \| Date when the campaign was last sent \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Last sent date |
| Description | Date when the campaign was last sent |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| campaigns__sent_datetime \| \| --- \| \| \\| Display name \\| Last sent date & time \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the campaign was last sent \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Last sent date & time \| \| Description \| Date and time when the campaign was last sent \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| campaigns__sent_datetime |
| \| Display name \| Last sent date & time \| \| --- \| --- \| \| Description \| Date and time when the campaign was last sent \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Last sent date & time |
| Description | Date and time when the campaign was last sent |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| campaigns__soft_bounces \| \| --- \| \| \\| Display name \\| Soft bounces \\| \\| --- \\| --- \\| \\| Description \\| Number of soft bounces \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Soft bounces \| \| Description \| Number of soft bounces \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__soft_bounces |
| \| Display name \| Soft bounces \| \| --- \| --- \| \| Description \| Number of soft bounces \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Soft bounces |
| Description | Number of soft bounces |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__total_bounces \| \| --- \| \| \\| Display name \\| Total bounces \\| \\| --- \\| --- \\| \\| Description \\| Total number of bounces (including hard and soft) \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Total bounces \| \| Description \| Total number of bounces (including hard and soft) \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__total_bounces |
| \| Display name \| Total bounces \| \| --- \| --- \| \| Description \| Total number of bounces (including hard and soft) \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Total bounces |
| Description | Total number of bounces (including hard and soft) |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__total_link_clicks \| \| --- \| \| \\| Display name \\| Total link clicks \\| \\| --- \\| --- \\| \\| Description \\| Total number of link clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Total link clicks \| \| Description \| Total number of link clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__total_link_clicks |
| \| Display name \| Total link clicks \| \| --- \| --- \| \| Description \| Total number of link clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Total link clicks |
| Description | Total number of link clicks |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__total_opens \| \| --- \| \| \\| Display name \\| Total opens/reads \\| \\| --- \\| --- \\| \\| Description \\| Total number of opens/reads \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Total opens/reads \| \| Description \| Total number of opens/reads \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__total_opens |
| \| Display name \| Total opens/reads \| \| --- \| --- \| \| Description \| Total number of opens/reads \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Total opens/reads |
| Description | Total number of opens/reads |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__twitter_mentions \| \| --- \| \| \\| Display name \\| Twitter mentions \\| \\| --- \\| --- \\| \\| Description \\| Number of mentions on Twitter \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Twitter mentions \| \| Description \| Number of mentions on Twitter \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__twitter_mentions |
| \| Display name \| Twitter mentions \| \| --- \| --- \| \| Description \| Number of mentions on Twitter \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Twitter mentions |
| Description | Number of mentions on Twitter |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__type \| \| --- \| \| \\| Display name \\| Type \\| \\| --- \\| --- \\| \\| Description \\| Type of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Type \| \| Description \| Type of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaigns__type |
| \| Display name \| Type \| \| --- \| --- \| \| Description \| Type of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Type |
| Description | Type of the campaign |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaigns__unique_link_clicks \| \| --- \| \| \\| Display name \\| Unique link clicks \\| \\| --- \\| --- \\| \\| Description \\| Total number of unique link clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Unique link clicks \| \| Description \| Total number of unique link clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__unique_link_clicks |
| \| Display name \| Unique link clicks \| \| --- \| --- \| \| Description \| Total number of unique link clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Unique link clicks |
| Description | Total number of unique link clicks |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__unique_opens \| \| --- \| \| \\| Display name \\| Unique opens/reads \\| \\| --- \\| --- \\| \\| Description \\| Number of unique opens/reads \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Unique opens/reads \| \| Description \| Number of unique opens/reads \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__unique_opens |
| \| Display name \| Unique opens/reads \| \| --- \| --- \| \| Description \| Number of unique opens/reads \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Unique opens/reads |
| Description | Number of unique opens/reads |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| campaigns__unsubscribes \| \| --- \| \| \\| Display name \\| Unsubscribes \\| \\| --- \\| --- \\| \\| Description \\| Total number of unsubscribes \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Unsubscribes \| \| Description \| Total number of unsubscribes \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| campaigns__unsubscribes |
| \| Display name \| Unsubscribes \| \| --- \| --- \| \| Description \| Total number of unsubscribes \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Unsubscribes |
| Description | Total number of unsubscribes |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| dataSourceName |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### Table: CONTACT

| \| contacts__contact_id \| \| --- \| \| \\| Display name \\| Contact ID \\| \\| --- \\| --- \\| \\| Description \\| Contact ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Contact ID \| \| Description \| Contact ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| contacts__contact_id |
| \| Display name \| Contact ID \| \| --- \| --- \| \| Description \| Contact ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Contact ID |
| Description | Contact ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| contacts__created_date \| \| --- \| \| \\| Display name \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| Date when the contact was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date \| \| Description \| Date when the contact was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| contacts__created_date |
| \| Display name \| Created date \| \| --- \| --- \| \| Description \| Date when the contact was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Created date |
| Description | Date when the contact was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| contacts__created_datetime \| \| --- \| \| \\| Display name \\| Created date & time \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the contact was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date & time \| \| Description \| Date and time when the contact was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| contacts__created_datetime |
| \| Display name \| Created date & time \| \| --- \| --- \| \| Description \| Date and time when the contact was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Created date & time |
| Description | Date and time when the contact was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| contacts__email \| \| --- \| \| \\| Display name \\| Email \\| \\| --- \\| --- \\| \\| Description \\| Email of the contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Email \| \| Description \| Email of the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| contacts__email |
| \| Display name \| Email \| \| --- \| --- \| \| Description \| Email of the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Email |
| Description | Email of the contact |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| contacts__email_domain \| \| --- \| \| \\| Display name \\| Email domain \\| \\| --- \\| --- \\| \\| Description \\| Email domain \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Email domain \| \| Description \| Email domain \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| contacts__email_domain |
| \| Display name \| Email domain \| \| --- \| --- \| \| Description \| Email domain \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Email domain |
| Description | Email domain |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| contacts__email_local \| \| --- \| \| \\| Display name \\| Email local \\| \\| --- \\| --- \\| \\| Description \\| Email local \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Email local \| \| Description \| Email local \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| contacts__email_local |
| \| Display name \| Email local \| \| --- \| --- \| \| Description \| Email local \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Email local |
| Description | Email local |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| contacts__first_name \| \| --- \| \| \\| Display name \\| First name \\| \\| --- \\| --- \\| \\| Description \\| First name of the contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| First name \| \| Description \| First name of the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| contacts__first_name |
| \| Display name \| First name \| \| --- \| --- \| \| Description \| First name of the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | First name |
| Description | First name of the contact |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| contacts__hard_bounces \| \| --- \| \| \\| Display name \\| Hard bounces \\| \\| --- \\| --- \\| \\| Description \\| Number of hard bounces \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Hard bounces \| \| Description \| Number of hard bounces \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| contacts__hard_bounces |
| \| Display name \| Hard bounces \| \| --- \| --- \| \| Description \| Number of hard bounces \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Hard bounces |
| Description | Number of hard bounces |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| contacts__last_name \| \| --- \| \| \\| Display name \\| Last name \\| \\| --- \\| --- \\| \\| Description \\| Last name of the contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Last name \| \| Description \| Last name of the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| contacts__last_name |
| \| Display name \| Last name \| \| --- \| --- \| \| Description \| Last name of the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Last name |
| Description | Last name of the contact |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| contacts__organization_id \| \| --- \| \| \\| Display name \\| Organization ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the organization \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Organization ID \| \| Description \| ID of the organization \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| contacts__organization_id |
| \| Display name \| Organization ID \| \| --- \| --- \| \| Description \| ID of the organization \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Organization ID |
| Description | ID of the organization |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| contacts__organization_name \| \| --- \| \| \\| Display name \\| Organization name \\| \\| --- \\| --- \\| \\| Description \\| Name of the organization \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Organization name \| \| Description \| Name of the organization \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| contacts__organization_name |
| \| Display name \| Organization name \| \| --- \| --- \| \| Description \| Name of the organization \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Organization name |
| Description | Name of the organization |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| contacts__phone \| \| --- \| \| \\| Display name \\| Phone \\| \\| --- \\| --- \\| \\| Description \\| Phone number of the contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Phone \| \| Description \| Phone number of the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| contacts__phone |
| \| Display name \| Phone \| \| --- \| --- \| \| Description \| Phone number of the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Phone |
| Description | Phone number of the contact |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| contacts__soft_bounces \| \| --- \| \| \\| Display name \\| Soft bounces \\| \\| --- \\| --- \\| \\| Description \\| Number of soft bounces \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Soft bounces \| \| Description \| Number of soft bounces \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| contacts__soft_bounces |
| \| Display name \| Soft bounces \| \| --- \| --- \| \| Description \| Number of soft bounces \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Soft bounces |
| Description | Number of soft bounces |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| contacts__updated_date \| \| --- \| \| \\| Display name \\| Updated date \\| \\| --- \\| --- \\| \\| Description \\| Date when the contact was updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Updated date \| \| Description \| Date when the contact was updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| contacts__updated_date |
| \| Display name \| Updated date \| \| --- \| --- \| \| Description \| Date when the contact was updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Updated date |
| Description | Date when the contact was updated |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| contacts__updated_datetime \| \| --- \| \| \\| Display name \\| Updated date & time \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the contact was updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Updated date & time \| \| Description \| Date and time when the contact was updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| contacts__updated_datetime |
| \| Display name \| Updated date & time \| \| --- \| --- \| \| Description \| Date and time when the contact was updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Updated date & time |
| Description | Date and time when the contact was updated |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| dataSourceName |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### Table: DEAL

| \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__contact__contact_email \| \| --- \| \| \\| Display name \\| Contact email \\| \\| --- \\| --- \\| \\| Description \\| Email address of deal contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Contact email \| \| Description \| Email address of deal contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__contact__contact_email |
| \| Display name \| Contact email \| \| --- \| --- \| \| Description \| Email address of deal contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Contact email |
| Description | Email address of deal contact |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__contact__contact_first_name \| \| --- \| \| \\| Display name \\| Contact first name \\| \\| --- \\| --- \\| \\| Description \\| First name of deal contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Contact first name \| \| Description \| First name of deal contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__contact__contact_first_name |
| \| Display name \| Contact first name \| \| --- \| --- \| \| Description \| First name of deal contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Contact first name |
| Description | First name of deal contact |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__contact__contact_id \| \| --- \| \| \\| Display name \\| Contact ID \\| \\| --- \\| --- \\| \\| Description \\| ID of deal contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Contact ID \| \| Description \| ID of deal contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__contact__contact_id |
| \| Display name \| Contact ID \| \| --- \| --- \| \| Description \| ID of deal contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Contact ID |
| Description | ID of deal contact |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__contact__contact_last_name \| \| --- \| \| \\| Display name \\| Contact last name \\| \\| --- \\| --- \\| \\| Description \\| Last name of deal contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Contact last name \| \| Description \| Last name of deal contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__contact__contact_last_name |
| \| Display name \| Contact last name \| \| --- \| --- \| \| Description \| Last name of deal contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Contact last name |
| Description | Last name of deal contact |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__contact__contact_phone \| \| --- \| \| \\| Display name \\| Contact phone \\| \\| --- \\| --- \\| \\| Description \\| Phone number of deal contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Contact phone \| \| Description \| Phone number of deal contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__contact__contact_phone |
| \| Display name \| Contact phone \| \| --- \| --- \| \| Description \| Phone number of deal contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Contact phone |
| Description | Phone number of deal contact |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__created_date \| \| --- \| \| \\| Display name \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| Date when the deal was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date \| \| Description \| Date when the deal was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| deals__created_date |
| \| Display name \| Created date \| \| --- \| --- \| \| Description \| Date when the deal was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Created date |
| Description | Date when the deal was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| deals__created_datetime \| \| --- \| \| \\| Display name \\| Created date & time \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the deal was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date & time \| \| Description \| Date and time when the deal was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| deals__created_datetime |
| \| Display name \| Created date & time \| \| --- \| --- \| \| Description \| Date and time when the deal was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Created date & time |
| Description | Date and time when the deal was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| deals__currency \| \| --- \| \| \\| Display name \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| Currency of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Currency \| \| Description \| Currency of the deal \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| deals__currency |
| \| Display name \| Currency \| \| --- \| --- \| \| Description \| Currency of the deal \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Currency |
| Description | Currency of the deal |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| deals__deal_id \| \| --- \| \| \\| Display name \\| Deal ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal ID \| \| Description \| ID of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__deal_id |
| \| Display name \| Deal ID \| \| --- \| --- \| \| Description \| ID of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Deal ID |
| Description | ID of the deal |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__deal_value \| \| --- \| \| \\| Display name \\| Total deal value \\| \\| --- \\| --- \\| \\| Description \\| Total value of deals \\| \\| Field type \\| metric \\| \\| Data type \\| [int.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Total deal value \| \| Description \| Total value of deals \| \| Field type \| metric \| \| Data type \| [int.currency.value](/apidocs/field-data-types#currency) \| |
| deals__deal_value |
| \| Display name \| Total deal value \| \| --- \| --- \| \| Description \| Total value of deals \| \| Field type \| metric \| \| Data type \| [int.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Total deal value |
| Description | Total value of deals |
| Field type | metric |
| Data type | [int.currency.value](/apidocs/field-data-types#currency) |
| \| deals__description \| \| --- \| \| \\| Display name \\| Description \\| \\| --- \\| --- \\| \\| Description \\| Description of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Description \| \| Description \| Description of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__description |
| \| Display name \| Description \| \| --- \| --- \| \| Description \| Description of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Description |
| Description | Description of the deal |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__modified_date \| \| --- \| \| \\| Display name \\| Last modified date \\| \\| --- \\| --- \\| \\| Description \\| Date when the deal was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Last modified date \| \| Description \| Date when the deal was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| deals__modified_date |
| \| Display name \| Last modified date \| \| --- \| --- \| \| Description \| Date when the deal was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Last modified date |
| Description | Date when the deal was last modified |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| deals__modified_datetime \| \| --- \| \| \\| Display name \\| Last modified date & time \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the deal was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Last modified date & time \| \| Description \| Date and time when the deal was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| deals__modified_datetime |
| \| Display name \| Last modified date & time \| \| --- \| --- \| \| Description \| Date and time when the deal was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Last modified date & time |
| Description | Date and time when the deal was last modified |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| deals__organization__organization_id \| \| --- \| \| \\| Display name \\| Organization ID \\| \\| --- \\| --- \\| \\| Description \\| ID of deal organization \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Organization ID \| \| Description \| ID of deal organization \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__organization__organization_id |
| \| Display name \| Organization ID \| \| --- \| --- \| \| Description \| ID of deal organization \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Organization ID |
| Description | ID of deal organization |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__organization__organization_name \| \| --- \| \| \\| Display name \\| Organization name \\| \\| --- \\| --- \\| \\| Description \\| Name of deal organization \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Organization name \| \| Description \| Name of deal organization \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__organization__organization_name |
| \| Display name \| Organization name \| \| --- \| --- \| \| Description \| Name of deal organization \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Organization name |
| Description | Name of deal organization |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__owner__owner_email \| \| --- \| \| \\| Display name \\| Owner email \\| \\| --- \\| --- \\| \\| Description \\| Email of deal owner \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Owner email \| \| Description \| Email of deal owner \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__owner__owner_email |
| \| Display name \| Owner email \| \| --- \| --- \| \| Description \| Email of deal owner \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Owner email |
| Description | Email of deal owner |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__owner__owner_first_name \| \| --- \| \| \\| Display name \\| Owner first name \\| \\| --- \\| --- \\| \\| Description \\| First name of deal owner \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Owner first name \| \| Description \| First name of deal owner \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__owner__owner_first_name |
| \| Display name \| Owner first name \| \| --- \| --- \| \| Description \| First name of deal owner \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Owner first name |
| Description | First name of deal owner |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__owner__owner_id \| \| --- \| \| \\| Display name \\| Owner ID \\| \\| --- \\| --- \\| \\| Description \\| ID of deal owner \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Owner ID \| \| Description \| ID of deal owner \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__owner__owner_id |
| \| Display name \| Owner ID \| \| --- \| --- \| \| Description \| ID of deal owner \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Owner ID |
| Description | ID of deal owner |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__owner__owner_last_name \| \| --- \| \| \\| Display name \\| Owner last name \\| \\| --- \\| --- \\| \\| Description \\| Owner last name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Owner last name \| \| Description \| Owner last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__owner__owner_last_name |
| \| Display name \| Owner last name \| \| --- \| --- \| \| Description \| Owner last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Owner last name |
| Description | Owner last name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__pipeline__pipeline_id \| \| --- \| \| \\| Display name \\| Pipeline ID \\| \\| --- \\| --- \\| \\| Description \\| ID of deal pipeline \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Pipeline ID \| \| Description \| ID of deal pipeline \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__pipeline__pipeline_id |
| \| Display name \| Pipeline ID \| \| --- \| --- \| \| Description \| ID of deal pipeline \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Pipeline ID |
| Description | ID of deal pipeline |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__pipeline__pipeline_title \| \| --- \| \| \\| Display name \\| Pipeline title \\| \\| --- \\| --- \\| \\| Description \\| Title of deal pipeline \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Pipeline title \| \| Description \| Title of deal pipeline \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__pipeline__pipeline_title |
| \| Display name \| Pipeline title \| \| --- \| --- \| \| Description \| Title of deal pipeline \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Pipeline title |
| Description | Title of deal pipeline |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__stage__stage_id \| \| --- \| \| \\| Display name \\| Stage ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the deal's stage \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Stage ID \| \| Description \| ID of the deal's stage \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__stage__stage_id |
| \| Display name \| Stage ID \| \| --- \| --- \| \| Description \| ID of the deal's stage \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Stage ID |
| Description | ID of the deal's stage |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__stage__stage_title \| \| --- \| \| \\| Display name \\| Stage title \\| \\| --- \\| --- \\| \\| Description \\| Title of the deal's stage \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Stage title \| \| Description \| Title of the deal's stage \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__stage__stage_title |
| \| Display name \| Stage title \| \| --- \| --- \| \| Description \| Title of the deal's stage \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Stage title |
| Description | Title of the deal's stage |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__status \| \| --- \| \| \\| Display name \\| Deal status \\| \\| --- \\| --- \\| \\| Description \\| Status of the deal, 0 = Open, 1 = Won, 2 = Lost \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal status \| \| Description \| Status of the deal, 0 = Open, 1 = Won, 2 = Lost \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__status |
| \| Display name \| Deal status \| \| --- \| --- \| \| Description \| Status of the deal, 0 = Open, 1 = Won, 2 = Lost \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Deal status |
| Description | Status of the deal, 0 = Open, 1 = Won, 2 = Lost |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__title \| \| --- \| \| \\| Display name \\| Deal title \\| \\| --- \\| --- \\| \\| Description \\| Title of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal title \| \| Description \| Title of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__title |
| \| Display name \| Deal title \| \| --- \| --- \| \| Description \| Title of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Deal title |
| Description | Title of the deal |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__win_probability \| \| --- \| \| \\| Display name \\| Win probability \\| \\| --- \\| --- \\| \\| Description \\| Probability to win the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Win probability \| \| Description \| Probability to win the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| deals__win_probability |
| \| Display name \| Win probability \| \| --- \| --- \| \| Description \| Probability to win the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Win probability |
| Description | Probability to win the deal |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| deals__win_probability_modified_date \| \| --- \| \| \\| Display name \\| Win probability last modified date \\| \\| --- \\| --- \\| \\| Description \\| Date when win probability was modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Win probability last modified date \| \| Description \| Date when win probability was modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| deals__win_probability_modified_date |
| \| Display name \| Win probability last modified date \| \| --- \| --- \| \| Description \| Date when win probability was modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Win probability last modified date |
| Description | Date when win probability was modified |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |

### Table: ACCOUNT

| \| accounts__account_id \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| Account ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| Account ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| accounts__account_id |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| Account ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | Account ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accounts__account_name \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Account name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Account name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| accounts__account_name |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Account name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Account name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| accounts__account_url \| \| --- \| \| \\| Display name \\| Account URL \\| \\| --- \\| --- \\| \\| Description \\| Account URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Account URL \| \| Description \| Account URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| accounts__account_url |
| \| Display name \| Account URL \| \| --- \| --- \| \| Description \| Account URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Account URL |
| Description | Account URL |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| accounts__contact_count \| \| --- \| \| \\| Display name \\| Number of contacts \\| \\| --- \\| --- \\| \\| Description \\| Total number of contacts \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Number of contacts \| \| Description \| Total number of contacts \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| accounts__contact_count |
| \| Display name \| Number of contacts \| \| --- \| --- \| \| Description \| Total number of contacts \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Number of contacts |
| Description | Total number of contacts |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| accounts__created_date \| \| --- \| \| \\| Display name \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| Date when the campaign was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date \| \| Description \| Date when the campaign was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| accounts__created_date |
| \| Display name \| Created date \| \| --- \| --- \| \| Description \| Date when the campaign was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Created date |
| Description | Date when the campaign was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| accounts__created_datetime \| \| --- \| \| \\| Display name \\| Created date & time \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the campaign was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date & time \| \| Description \| Date and time when the campaign was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| accounts__created_datetime |
| \| Display name \| Created date & time \| \| --- \| --- \| \| Description \| Date and time when the campaign was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Created date & time |
| Description | Date and time when the campaign was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| accounts__deal_count \| \| --- \| \| \\| Display name \\| Number of deals \\| \\| --- \\| --- \\| \\| Description \\| Total number of deals \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Number of deals \| \| Description \| Total number of deals \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| accounts__deal_count |
| \| Display name \| Number of deals \| \| --- \| --- \| \| Description \| Total number of deals \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Number of deals |
| Description | Total number of deals |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| accounts__updated_date \| \| --- \| \| \\| Display name \\| Updated date \\| \\| --- \\| --- \\| \\| Description \\| Date when the campaign was updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Updated date \| \| Description \| Date when the campaign was updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| accounts__updated_date |
| \| Display name \| Updated date \| \| --- \| --- \| \| Description \| Date when the campaign was updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Updated date |
| Description | Date when the campaign was updated |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| accounts__updated_datetime \| \| --- \| \| \\| Display name \\| Updated date & time \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the campaign was updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Updated date & time \| \| Description \| Date and time when the campaign was updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| accounts__updated_datetime |
| \| Display name \| Updated date & time \| \| --- \| --- \| \| Description \| Date and time when the campaign was updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Updated date & time |
| Description | Date and time when the campaign was updated |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| dataSourceName |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |