ActiveCampaign fields

29 metrics130 dimensions

Search fields

ACCOUNTS

accounts__account_name

Field label	Account name
Description	Account name
Field type	dimension
Data type	string.text.value

accounts__account_id

Field label	Account ID
Description	Account ID
Field type	dimension
Data type	string.text.value

accounts__account_url

Field label	Account URL
Description	Account URL
Field type	dimension
Data type	string.text.url

accounts__created_datetime

Field label	Created date & time
Description	Date and time when the campaign was created
Field type	dimension
Data type	string.time.datetime

accounts__created_date

Field label	Created date
Description	Date when the campaign was created
Field type	dimension
Data type	string.time.date

accounts__updated_datetime

Field label	Updated date & time
Description	Date and time when the campaign was updated
Field type	dimension
Data type	string.time.datetime

accounts__updated_date

Field label	Updated date
Description	Date when the campaign was updated
Field type	dimension
Data type	string.time.date

accounts__contact_count

Field label	Number of contacts
Description	Total number of contacts
Field type	metric
Data type	int.number.value

accounts__deal_count

Field label	Number of deals
Description	Total number of deals
Field type	metric
Data type	int.number.value

accounts__number_of_accounts

Field label	Number of accounts
Description	Total number of accounts
Field type	metric
Data type	int.number.value

CAMPAIGNS

campaigns__campaign_id

Field label	Campaign ID
Description	ID of the campaign
Field type	dimension
Data type	string.text.value

campaigns__name

Field label	Campaign name
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

campaigns__analytics_campaign_name

Field label	Analytics campaign name
Description	Google Analytics campaign name
Field type	dimension
Data type	string.text.value

campaigns__type

Field label	Type
Description	Type of the campaign
Field type	dimension
Data type	string.text.value

campaigns__segment_id

Field label	Segment ID
Description	ID of the campaign segment
Field type	dimension
Data type	string.text.value

campaigns__segment_name

Field label	Segment name
Description	Name of the campaign segment
Field type	dimension
Data type	string.text.value

campaigns__automation_id

Field label	Automation ID
Description	ID of the automation
Field type	dimension
Data type	string.text.value

campaigns__created_datetime

Field label	Created date & time
Description	Date and time when the campaign was created
Field type	dimension
Data type	string.time.datetime

campaigns__created_date

Field label	Created date
Description	Date when the campaign was created
Field type	dimension
Data type	string.time.date

campaigns__modified_datetime

Field label	Last modified date & time
Description	Date and time when the campaign was last modified
Field type	dimension
Data type	string.time.datetime

campaigns__modified_date

Field label	Last modified date
Description	Date when the campaign was last modified
Field type	dimension
Data type	string.time.date

campaigns__sent_datetime

Field label	Last sent date & time
Description	Date and time when the campaign was last sent
Field type	dimension
Data type	string.time.datetime

campaigns__sent_date

Field label	Last sent date
Description	Date when the campaign was last sent
Field type	dimension
Data type	string.time.date

campaigns__campaign_message__sender_email

Field label	Sender email
Description	The email of the sender of the campaign
Field type	dimension
Data type	string.text.value

campaigns__campaign_message__subject

Field label	Subject
Description	Subject of the campaign message
Field type	dimension
Data type	string.text.value

campaigns__sends

Field label	Sends
Description	The total number of campaign sends
Field type	metric
Data type	int.number.value

campaigns__total_opens

Field label	Total opens/reads
Description	Total number of opens/reads
Field type	metric
Data type	int.number.value

campaigns__unique_opens

Field label	Unique opens/reads
Description	Number of unique opens/reads
Field type	metric
Data type	int.number.value

campaigns__open_rate

Field label	Open rate
Description	Unique opens / Sends
Field type	metric
Data type	float.number.ratio

campaigns__total_link_clicks

Field label	Total link clicks
Description	Total number of link clicks
Field type	metric
Data type	int.number.value

campaigns__unique_link_clicks

Field label	Unique link clicks
Description	Total number of unique link clicks
Field type	metric
Data type	int.number.value

campaigns__unique_subscriber_clicks

Field label	Unique subscriber clicks
Description	Total number of unique subscriber clicks
Field type	metric
Data type	int.number.value

campaigns__click_rate

Field label	Click rate
Description	Unique link clicks / Sends
Field type	metric
Data type	float.number.ratio

campaigns__click_to_open_rate

Field label	Click to open rate
Description	Unique link clicks / Unique opens/reads
Field type	metric
Data type	float.number.ratio

campaigns__forwards

Field label	Forwards
Description	Number of forwards
Field type	metric
Data type	int.number.value

campaigns__forward_rate

Field label	Forward rate
Description	Forwards / Sends
Field type	metric
Data type	float.number.ratio

campaigns__unsubscribes

Field label	Unsubscribes
Description	Total number of unsubscribes
Field type	metric
Data type	int.number.value

campaigns__unsubscribe_rate

Field label	Unsubscribe rate
Description	Unsubscribes / Sends
Field type	metric
Data type	float.number.ratio

campaigns__hard_bounces

Field label	Hard bounces
Description	Number of hard bounces
Field type	metric
Data type	int.number.value

campaigns__soft_bounces

Field label	Soft bounces
Description	Number of soft bounces
Field type	metric
Data type	int.number.value

campaigns__total_bounces

Field label	Total bounces
Description	Total number of bounces (including hard and soft)
Field type	metric
Data type	int.number.value

campaigns__twitter_mentions

Field label	Twitter mentions
Description	Number of mentions on Twitter
Field type	metric
Data type	int.number.value

campaigns__facebook_shares

Field label	Facebook shares
Description	Number of Facebook shares
Field type	metric
Data type	int.number.value

campaigns__number_of_campaigns

Field label	Number of campaigns
Description	Total number of campaigns sent
Field type	metric
Data type	int.number.value

CONTACTS

contacts__contact_id

Field label	Contact ID
Description	Contact ID
Field type	dimension
Data type	string.text.value

contacts__email

Field label	Email
Description	Email of the contact
Field type	dimension
Data type	string.text.value

contacts__phone

Field label	Phone
Description	Phone number of the contact
Field type	dimension
Data type	string.text.value

contacts__first_name

Field label	First name
Description	First name of the contact
Field type	dimension
Data type	string.text.value

contacts__last_name

Field label	Last name
Description	Last name of the contact
Field type	dimension
Data type	string.text.value

contacts__organization_id

Field label	Organization ID
Description	ID of the organization
Field type	dimension
Data type	string.text.value

contacts__organization_name

Field label	Organization name
Description	Name of the organization
Field type	dimension
Data type	string.text.value

contacts__email_local

Field label	Email local
Description	Email local
Field type	dimension
Data type	string.text.value

contacts__email_domain

Field label	Email domain
Description	Email domain
Field type	dimension
Data type	string.text.value

contacts__created_datetime

Field label	Created date & time
Description	Date and time when the contact was created
Field type	dimension
Data type	string.time.datetime

contacts__created_date

Field label	Created date
Description	Date when the contact was created
Field type	dimension
Data type	string.time.date

contacts__updated_datetime

Field label	Updated date & time
Description	Date and time when the contact was updated
Field type	dimension
Data type	string.time.datetime

contacts__updated_date

Field label	Updated date
Description	Date when the contact was updated
Field type	dimension
Data type	string.time.date

contacts__number_of_contacts

Field label	Number of contacts
Description	Total number of contacts
Field type	metric
Data type	int.number.value

contacts__hard_bounces

Field label	Hard bounces
Description	Number of hard bounces
Field type	metric
Data type	int.number.value

contacts__soft_bounces

Field label	Soft bounces
Description	Number of soft bounces
Field type	metric
Data type	int.number.value

DATASOURCE

dataSourceName

Field label	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
Destinations	API, Data warehouse

system_metadata.data_source_logins

Field label	Data source logins
Description	The data source login accounts that were used to authenticate against the data source
Field type	dimension
Data type	string.text.json

system_metadata.data_source_login_owners

Field label	Data source login owners
Description	The Supermetrics users that created the data source login connections
Field type	dimension
Data type	string.text.json

DEALS

deals__deal_id

Field label	Deal ID
Description	ID of the deal
Field type	dimension
Data type	string.text.value

deals__title

Field label	Deal title
Description	Title of the deal
Field type	dimension
Data type	string.text.value

deals__description

Field label	Description
Description	Description of the deal
Field type	dimension
Data type	string.text.value

deals__status_id

Field label	Status ID
Description	Status of the deal, 0 = Open, 1 = Won, 2 = Lost
Field type	dimension
Data type	string.text.value

deals__status

Field label	Deal status
Description	Status of the deal, 0 = Open, 1 = Won, 2 = Lost
Field type	dimension
Data type	string.text.value

deals__created_date

Field label	Created date
Description	Date when the deal was created
Field type	dimension
Data type	string.time.date

deals__created_datetime

Field label	Created date & time
Description	Date and time when the deal was created
Field type	dimension
Data type	string.time.datetime

deals__modified_date

Field label	Last modified date
Description	Date when the deal was last modified
Field type	dimension
Data type	string.time.date

deals__modified_datetime

Field label	Last modified date & time
Description	Date and time when the deal was last modified
Field type	dimension
Data type	string.time.datetime

deals__win_probability

Field label	Win probability
Description	Probability to win the deal
Field type	dimension
Data type	string.text.value

deals__win_probability_modified_date

Field label	Win probability last modified date
Description	Date when win probability was modified
Field type	dimension
Data type	string.time.date

deals__currency

Field label	Currency
Description	Currency of the deal
Field type	dimension
Data type	string.currency.code

deals__contact__contact_id

Field label	Contact ID
Description	ID of deal contact
Field type	dimension
Data type	string.text.value

deals__contact__contact_first_name

Field label	Contact first name
Description	First name of deal contact
Field type	dimension
Data type	string.text.value

deals__contact__contact_last_name

Field label	Contact last name
Description	Last name of deal contact
Field type	dimension
Data type	string.text.value

deals__contact__contact_email

Field label	Contact email
Description	Email address of deal contact
Field type	dimension
Data type	string.text.value

deals__contact__contact_phone

Field label	Contact phone
Description	Phone number of deal contact
Field type	dimension
Data type	string.text.value

deals__organization__organization_id

Field label	Organization ID
Description	ID of deal organization
Field type	dimension
Data type	string.text.value

deals__organization__organization_name

Field label	Organization name
Description	Name of deal organization
Field type	dimension
Data type	string.text.value

deals__owner__owner_id

Field label	Owner ID
Description	ID of deal owner
Field type	dimension
Data type	string.text.value

deals__owner__owner_email

Field label	Owner email
Description	Email of deal owner
Field type	dimension
Data type	string.text.value

deals__owner__owner_first_name

Field label	Owner first name
Description	First name of deal owner
Field type	dimension
Data type	string.text.value

deals__owner__owner_last_name

Field label	Owner last name
Description	Owner last name
Field type	dimension
Data type	string.text.value

deals__pipeline__pipeline_id

Field label	Pipeline ID
Description	ID of deal pipeline
Field type	dimension
Data type	string.text.value

deals__pipeline__pipeline_title

Field label	Pipeline title
Description	Title of deal pipeline
Field type	dimension
Data type	string.text.value

deals__stage__stage_id

Field label	Stage ID
Description	ID of the deal's stage
Field type	dimension
Data type	string.text.value

deals__stage__stage_title

Field label	Stage title
Description	Title of the deal's stage
Field type	dimension
Data type	string.text.value

deals__number_of_deals

Field label	Number of deals
Description	Total number of deals
Field type	metric
Data type	int.number.value

deals__deal_value

Field label	Total deal value
Description	Total value of deals
Field type	metric
Data type	int.currency.value

deals__average_deal_value

Field label	Average deal value
Description	Average value of deals
Field type	metric
Data type	int.currency.value

deals__average_win_probability

Field label	Average win probability
Description	Average win probability of deals
Field type	metric
Data type	float.number.ratio

QUERY

system_metadata.query_date_range_start

Field label	Start date
Description	The start date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_date_range_end

Field label	End date
Description	The end date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_timezone

Field label	Timezone
Description	The timezone that is supplied to the query
Field type	dimension
Data type	string.time.timezone

system_metadata.query_filters

Field label	Filters
Description	All filters used in the query
Field type	dimension
Data type	string.text.json

system_metadata.query_date_start

Field label	Start
Description	When the query was started
Field type	dimension
Data type	string.time.datetime

system_metadata.query_date_end

Field label	End
Description	When the query completed
Field type	dimension
Data type	string.time.datetime

system_metadata.query_duration

Field label	Duration
Description	The duration in seconds of the query
Field type	dimension
Data type	int.duration.seconds

system_metadata.query_accounts

Field label	Accounts
Description	A list of accounts of which the data was pulled from
Field type	dimension
Data type	string.text.json

TIME

today

Field label	Today
Description	Today's date, e.g. 2017-01-31
Field type	dimension
Data type	string.time.date
Destinations	API, Data warehouse

campaigns__year

Field label	Year
Field type	dimension
Data type	string.time.year

campaigns__year_of_week

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

campaigns__year_of_week_iso

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

campaigns__year_month

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

campaigns__month

Field label	Month
Field type	dimension
Data type	string.time.month

campaigns__year_week

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

campaigns__year_week_iso

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

campaigns__week

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

campaigns__week_iso

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

campaigns__day_of_month

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

campaigns__day_of_week_name

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

campaigns__day_of_week_name_iso

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

campaigns__date

Field label	Date
Field type	dimension
Data type	string.time.date

campaigns__atom

Field label	Datetime
Field type	dimension
Data type	string.time.datetime

deals__year

Field label	Year
Field type	dimension
Data type	string.time.year

deals__year_of_week

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

deals__year_of_week_iso

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

deals__year_month

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

deals__month

Field label	Month
Field type	dimension
Data type	string.time.month

deals__year_week

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

deals__year_week_iso

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

deals__week

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

deals__week_iso

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

deals__day_of_month

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

deals__day_of_week_name

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

deals__day_of_week_name_iso

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

deals__date

Field label	Date
Field type	dimension
Data type	string.time.date

deals__atom

Field label	Datetime
Field type	dimension
Data type	string.time.datetime

accounts__year

Field label	Year
Field type	dimension
Data type	string.time.year

accounts__year_of_week

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

accounts__year_of_week_iso

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

accounts__year_month

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

accounts__month

Field label	Month
Field type	dimension
Data type	string.time.month

accounts__year_week

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

accounts__year_week_iso

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

accounts__week

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

accounts__week_iso

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

accounts__day_of_month

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

accounts__day_of_week_name

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

accounts__day_of_week_name_iso

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

accounts__date

Field label	Date
Field type	dimension
Data type	string.time.date

accounts__atom

Field label	Datetime
Field type	dimension
Data type	string.time.datetime

contacts__year

Field label	Year
Field type	dimension
Data type	string.time.year

contacts__year_of_week

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

contacts__year_of_week_iso

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

contacts__year_month

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

contacts__month

Field label	Month
Field type	dimension
Data type	string.time.month

contacts__year_week

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

contacts__year_week_iso

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

contacts__week

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

contacts__week_iso

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

contacts__day_of_month

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

contacts__day_of_week_name

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

contacts__day_of_week_name_iso

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

contacts__date

Field label	Date
Field type	dimension
Data type	string.time.date

contacts__atom

Field label	Datetime
Field type	dimension
Data type	string.time.datetime