Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | campaigns_year | dim | |
| Year of week (Sun-Sat) | campaigns_year_of_week | dim | ||
| Year of week (Mon-Sun) | campaigns_year_of_week_iso | dim | ||
| Year & month | campaigns_year_month | dim | ||
| Month | campaigns_month | dim | ||
| Year & week (Sun-Sat) | campaigns_year_week | dim | ||
| Year & week (Mon-Sun) | campaigns_year_week_iso | dim | ||
| Week (Sun-Sat) | campaigns_week | dim | ||
| Week (Mon-Sun) | campaigns_week_iso | dim | ||
| Day of month | campaigns_day_of_month | dim | ||
| Day of week (Sun-Sat) | campaigns_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | campaigns_day_of_week_name_iso | dim | ||
| Date | campaigns_date | dim | ||
| Datetime | campaigns_atom | dim | ||
| Campaigns | Campaign ID | campaigns_campaign_id | dim | ID of the campaign. |
| Campaign name | campaigns_name | dim | Name of the campaign. | |
| Analytics campaign name | campaigns_analytics_campaign_name | dim | Google Analytics campaign name. | |
| Type | campaigns_type | dim | Type of the campaign. | |
| Segment ID | campaigns_segment_id | dim | ID of the campaign segment. | |
| Segment name | campaigns_segment_name | dim | Name of the campaign segment. | |
| Automation ID | campaigns_automation_id | dim | ID of the automation. | |
| Created date & time | campaigns_created_datetime | dim | Date and time when the campaign was created. | |
| Created date | campaigns_created_date | dim | Date when the campaign was created. | |
| Last modified date & time | campaigns_modified_datetime | dim | Date and time when the campaign was last modified. | |
| Last modified date | campaigns_modified_date | dim | Date when the campaign was last modified. | |
| Last sent date & time | campaigns_sent_datetime | dim | Date and time when the campaign was last sent. | |
| Last sent date | campaigns_sent_date | dim | Date when the campaign was last sent. | |
| Sender email | campaigns_campaign_message__sender_email | dim | The email of the sender of the campaign. | |
| Subject | campaigns_campaign_message__subject | dim | Subject of the campaign message. | |
| Sends | campaigns_sends | met | The total number of campaign sends. | |
| Total opens/reads | campaigns_total_opens | met | Total number of opens/reads | |
| Unique opens/reads | campaigns_unique_opens | met | Number of unique opens/reads | |
| Open rate | campaigns_open_rate | met | Unique opens / Sends | |
| Total link clicks | campaigns_total_link_clicks | met | Total number of link clicks. | |
| Unique link clicks | campaigns_unique_link_clicks | met | Total number of unique link clicks. | |
| Click rate | campaigns_click_rate | met | Unique link clicks / Sends. | |
| Click to open rate | campaigns_click_to_open_rate | met | Unique link clicks / Unique opens/reads. | |
| Forwards | campaigns_forwards | met | Number of forwards | |
| Forward rate | campaigns_forward_rate | met | Forwards / Sends | |
| Unsubscribes | campaigns_unsubscribes | met | Total number of unsubscribes. | |
| Unsubscribe rate | campaigns_unsubscribe_rate | met | Unsubscribes / Sends | |
| Hard bounces | campaigns_hard_bounces | met | Number of hard bounces. | |
| Soft bounces | campaigns_soft_bounces | met | Number of soft bounces | |
| Total bounces | campaigns_total_bounces | met | Total number of bounces (including hard and soft) | |
| Twitter mentions | campaigns_twitter_mentions | met | Number of mentions on Twitter. | |
| Facebook shares | campaigns_facebook_shares | met | Number of Facebook shares. | |
| Number of campaigns | campaigns_number_of_campaigns | met | Total number of campaigns sent. | |
| Time | Year | deals_year | dim | |
| Year of week (Sun-Sat) | deals_year_of_week | dim | ||
| Year of week (Mon-Sun) | deals_year_of_week_iso | dim | ||
| Year & month | deals_year_month | dim | ||
| Month | deals_month | dim | ||
| Year & week (Sun-Sat) | deals_year_week | dim | ||
| Year & week (Mon-Sun) | deals_year_week_iso | dim | ||
| Week (Sun-Sat) | deals_week | dim | ||
| Week (Mon-Sun) | deals_week_iso | dim | ||
| Day of month | deals_day_of_month | dim | ||
| Day of week (Sun-Sat) | deals_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | deals_day_of_week_name_iso | dim | ||
| Date | deals_date | dim | ||
| Datetime | deals_atom | dim | ||
| Deals | Deal ID | deals_deal_id | dim | ID of the deal |
| Deal title | deals_title | dim | Title of the deal | |
| Description | deals_description | dim | Description of the deal | |
| Status ID | deals_status_id | dim | Status of the deal, 0 = Open, 1 = Won, 2 = Lost | |
| Deal status | deals_status | dim | Status of the deal, 0 = Open, 1 = Won, 2 = Lost | |
| Created date | deals_created_date | dim | Date when the deal was created | |
| Created date & time | deals_created_datetime | dim | Date and time when the deal was created | |
| Last modified date | deals_modified_date | dim | Date when the deal was last modified | |
| Last modified date & time | deals_modified_datetime | dim | Date and time when the deal was last modified | |
| Win probability | deals_win_probability | dim | Probability to win the deal | |
| Win probability last modified date | deals_win_probability_modified_date | dim | Date when win probability was modified | |
| Currency | deals_currency | dim | Currency of the deal | |
| Contact ID | deals_contact__contact_id | dim | ID of deal contact | |
| Contact first name | deals_contact__contact_first_name | dim | First name of deal contact | |
| Contact last name | deals_contact__contact_last_name | dim | Last name of deal contact | |
| Contact email | deals_contact__contact_email | dim | Email address of deal contact | |
| Contact phone | deals_contact__contact_phone | dim | Phone number of deal contact | |
| Organization ID | deals_organization__organization_id | dim | ID of deal organization | |
| Organization name | deals_organization__organization_name | dim | Name of deal organization | |
| Owner ID | deals_owner__owner_id | dim | ID of deal owner | |
| Owner email | deals_owner__owner_email | dim | Email of deal owner | |
| Owner first name | deals_owner__owner_first_name | dim | First name of deal owner | |
| Owner last name | deals_owner__owner_last_name | dim | Owner last name | |
| Pipeline ID | deals_pipeline__pipeline_id | dim | ID of deal pipeline | |
| Pipeline title | deals_pipeline__pipeline_title | dim | Title of deal pipeline | |
| Stage ID | deals_stage__stage_id | dim | ID of the deal's stage | |
| Stage title | deals_stage__stage_title | dim | Title of the deal's stage | |
| Number of deals | deals_number_of_deals | met | Total number of deals | |
| Total deal value | deals_deal_value | met | Total value of deals | |
| Average deal value | deals_average_deal_value | met | Average value of deals | |
| Average win probability | deals_average_win_probability | met | Average win probability of deals | |
| Time | Year | accounts_year | dim | |
| Year of week (Sun-Sat) | accounts_year_of_week | dim | ||
| Year of week (Mon-Sun) | accounts_year_of_week_iso | dim | ||
| Year & month | accounts_year_month | dim | ||
| Month | accounts_month | dim | ||
| Year & week (Sun-Sat) | accounts_year_week | dim | ||
| Year & week (Mon-Sun) | accounts_year_week_iso | dim | ||
| Week (Sun-Sat) | accounts_week | dim | ||
| Week (Mon-Sun) | accounts_week_iso | dim | ||
| Day of month | accounts_day_of_month | dim | ||
| Day of week (Sun-Sat) | accounts_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | accounts_day_of_week_name_iso | dim | ||
| Date | accounts_date | dim | ||
| Datetime | accounts_atom | dim | ||
| Accounts | Account name | accounts_account_name | dim | Account name. |
| Account ID | accounts_account_id | dim | Account ID. | |
| Account URL | accounts_account_url | dim | Account URL. | |
| Created date & time | accounts_created_datetime | dim | Date and time when the campaign was created | |
| Created date | accounts_created_date | dim | Date when the campaign was created | |
| Updated date & time | accounts_updated_datetime | dim | Date and time when the campaign was updated | |
| Updated date | accounts_updated_date | dim | Date when the campaign was updated | |
| Number of contacts | accounts_contact_count | met | Total number of contacts. | |
| Number of deals | accounts_deal_count | met | Total number of deals. | |
| Number of accounts | accounts_number_of_accounts | met | Total number of accounts. | |
| Time | Year | contacts_year | dim | |
| Year of week (Sun-Sat) | contacts_year_of_week | dim | ||
| Year of week (Mon-Sun) | contacts_year_of_week_iso | dim | ||
| Year & month | contacts_year_month | dim | ||
| Month | contacts_month | dim | ||
| Year & week (Sun-Sat) | contacts_year_week | dim | ||
| Year & week (Mon-Sun) | contacts_year_week_iso | dim | ||
| Week (Sun-Sat) | contacts_week | dim | ||
| Week (Mon-Sun) | contacts_week_iso | dim | ||
| Day of month | contacts_day_of_month | dim | ||
| Day of week (Sun-Sat) | contacts_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | contacts_day_of_week_name_iso | dim | ||
| Date | contacts_date | dim | ||
| Datetime | contacts_atom | dim | ||
| Contacts | Contact ID | contacts_contact_id | dim | Contact ID. |
| contacts_email | dim | Email of the contact. | ||
| Phone | contacts_phone | dim | Phone number of the contact. | |
| First name | contacts_first_name | dim | First name of the contact. | |
| Last name | contacts_last_name | dim | Last name of the contact. | |
| Organization ID | contacts_organization_id | dim | ID of the organization. | |
| Organization name | contacts_organization_name | dim | Name of the organization. | |
| Email local | contacts_email_local | dim | Email local. | |
| Email domain | contacts_email_domain | dim | Email domain. | |
| Created date & time | contacts_created_datetime | dim | Date and time when the contact was created | |
| Created date | contacts_created_date | dim | Date when the contact was created | |
| Updated date & time | contacts_updated_datetime | dim | Date and time when the contact was updated | |
| Updated date | contacts_updated_date | dim | Date when the contact was updated | |
| Number of contacts | contacts_number_of_contacts | met | Total number of contacts. | |
| Hard bounces | contacts_hard_bounces | met | Number of hard bounces. | |
| Soft bounces | contacts_soft_bounces | met | Number of soft bounces. |