ActiveCampaign data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

campaigns__analytics_campaign_name
Display name Analytics campaign name
Description Google Analytics campaign name
Field type dimension
Data type string.text.value
campaigns__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
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
campaigns__campaign_message__subject
Display name Subject
Description Subject of the campaign message
Field type dimension
Data type string.text.value
campaigns__created_date
Display name Created date
Description Date when the campaign was created
Field type dimension
Data type string.time.date
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
campaigns__facebook_shares
Display name Facebook shares
Description Number of Facebook shares
Field type metric
Data type int.number.value
campaigns__forwards
Display name Forwards
Description Number of forwards
Field type metric
Data type int.number.value
campaigns__hard_bounces
Display name Hard bounces
Description Number of hard bounces
Field type metric
Data type int.number.value
campaigns__modified_date
Display name Last modified date
Description Date when the campaign was last modified
Field type dimension
Data type string.time.date
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
campaigns__name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaigns__segment_id
Display name Segment ID
Description ID of the campaign segment
Field type dimension
Data type string.text.value
campaigns__segment_name
Display name Segment name
Description Name of the campaign segment
Field type dimension
Data type string.text.value
campaigns__sends
Display name Sends
Description The total number of campaign sends
Field type metric
Data type int.number.value
campaigns__sent_date
Display name Last sent date
Description Date when the campaign was last sent
Field type dimension
Data type string.time.date
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
campaigns__soft_bounces
Display name Soft bounces
Description Number of soft bounces
Field type metric
Data type int.number.value
campaigns__total_bounces
Display name Total bounces
Description Total number of bounces (including hard and soft)
Field type metric
Data type int.number.value
campaigns__total_link_clicks
Display name Total link clicks
Description Total number of link clicks
Field type metric
Data type int.number.value
campaigns__total_opens
Display name Total opens/reads
Description Total number of opens/reads
Field type metric
Data type int.number.value
campaigns__twitter_mentions
Display name Twitter mentions
Description Number of mentions on Twitter
Field type metric
Data type int.number.value
campaigns__type
Display name Type
Description Type of the campaign
Field type dimension
Data type string.text.value
campaigns__unique_link_clicks
Display name Unique link clicks
Description Total number of unique link clicks
Field type metric
Data type int.number.value
campaigns__unique_opens
Display name Unique opens/reads
Description Number of unique opens/reads
Field type metric
Data type int.number.value
campaigns__unsubscribes
Display name Unsubscribes
Description Total number of unsubscribes
Field type metric
Data type int.number.value
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

Table: CONTACT

contacts__contact_id
Display name Contact ID
Description Contact ID
Field type dimension
Data type string.text.value
contacts__created_date
Display name Created date
Description Date when the contact was created
Field type dimension
Data type string.time.date
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
contacts__email
Display name Email
Description Email of the contact
Field type dimension
Data type string.text.value
contacts__email_domain
Display name Email domain
Description Email domain
Field type dimension
Data type string.text.value
contacts__email_local
Display name Email local
Description Email local
Field type dimension
Data type string.text.value
contacts__first_name
Display name First name
Description First name of the contact
Field type dimension
Data type string.text.value
contacts__hard_bounces
Display name Hard bounces
Description Number of hard bounces
Field type metric
Data type int.number.value
contacts__last_name
Display name Last name
Description Last name of the contact
Field type dimension
Data type string.text.value
contacts__organization_id
Display name Organization ID
Description ID of the organization
Field type dimension
Data type string.text.value
contacts__organization_name
Display name Organization name
Description Name of the organization
Field type dimension
Data type string.text.value
contacts__phone
Display name Phone
Description Phone number of the contact
Field type dimension
Data type string.text.value
contacts__soft_bounces
Display name Soft bounces
Description Number of soft bounces
Field type metric
Data type int.number.value
contacts__updated_date
Display name Updated date
Description Date when the contact was updated
Field type dimension
Data type string.time.date
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
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

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
deals__contact__contact_email
Display name Contact email
Description Email address of deal contact
Field type dimension
Data type string.text.value
deals__contact__contact_first_name
Display name Contact first name
Description First name of deal contact
Field type dimension
Data type string.text.value
deals__contact__contact_id
Display name Contact ID
Description ID of deal contact
Field type dimension
Data type string.text.value
deals__contact__contact_last_name
Display name Contact last name
Description Last name of deal contact
Field type dimension
Data type string.text.value
deals__contact__contact_phone
Display name Contact phone
Description Phone number of deal contact
Field type dimension
Data type string.text.value
deals__created_date
Display name Created date
Description Date when the deal was created
Field type dimension
Data type string.time.date
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
deals__currency
Display name Currency
Description Currency of the deal
Field type dimension
Data type string.currency.code
deals__deal_id
Display name Deal ID
Description ID of the deal
Field type dimension
Data type string.text.value
deals__deal_value
Display name Total deal value
Description Total value of deals
Field type metric
Data type int.currency.value
deals__description
Display name Description
Description Description of the deal
Field type dimension
Data type string.text.value
deals__modified_date
Display name Last modified date
Description Date when the deal was last modified
Field type dimension
Data type string.time.date
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
deals__organization__organization_id
Display name Organization ID
Description ID of deal organization
Field type dimension
Data type string.text.value
deals__organization__organization_name
Display name Organization name
Description Name of deal organization
Field type dimension
Data type string.text.value
deals__owner__owner_email
Display name Owner email
Description Email of deal owner
Field type dimension
Data type string.text.value
deals__owner__owner_first_name
Display name Owner first name
Description First name of deal owner
Field type dimension
Data type string.text.value
deals__owner__owner_id
Display name Owner ID
Description ID of deal owner
Field type dimension
Data type string.text.value
deals__owner__owner_last_name
Display name Owner last name
Description Owner last name
Field type dimension
Data type string.text.value
deals__pipeline__pipeline_id
Display name Pipeline ID
Description ID of deal pipeline
Field type dimension
Data type string.text.value
deals__pipeline__pipeline_title
Display name Pipeline title
Description Title of deal pipeline
Field type dimension
Data type string.text.value
deals__stage__stage_id
Display name Stage ID
Description ID of the deal's stage
Field type dimension
Data type string.text.value
deals__stage__stage_title
Display name Stage title
Description Title of the deal's stage
Field type dimension
Data type string.text.value
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
deals__title
Display name Deal title
Description Title of the deal
Field type dimension
Data type string.text.value
deals__win_probability
Display name Win probability
Description Probability to win the deal
Field type dimension
Data type string.text.value
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

Table: ACCOUNT

accounts__account_id
Display name Account ID
Description Account ID
Field type dimension
Data type string.text.value
accounts__account_name
Display name Account name
Description Account name
Field type dimension
Data type string.text.value
accounts__account_url
Display name Account URL
Description Account URL
Field type dimension
Data type string.text.url
accounts__contact_count
Display name Number of contacts
Description Total number of contacts
Field type metric
Data type int.number.value
accounts__created_date
Display name Created date
Description Date when the campaign was created
Field type dimension
Data type string.time.date
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
accounts__deal_count
Display name Number of deals
Description Total number of deals
Field type metric
Data type int.number.value
accounts__updated_date
Display name Updated date
Description Date when the campaign was updated
Field type dimension
Data type string.time.date
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
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