Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | email_campaigns_year | dim | |
| Year of week (Sun-Sat) | email_campaigns_year_of_week | dim | ||
| Year of week (Mon-Sun) | email_campaigns_year_of_week_iso | dim | ||
| Year & month | email_campaigns_year_month | dim | ||
| Month | email_campaigns_month | dim | ||
| Year & week (Sun-Sat) | email_campaigns_year_week | dim | ||
| Year & week (Mon-Sun) | email_campaigns_year_week_iso | dim | ||
| Week (Sun-Sat) | email_campaigns_week | dim | ||
| Week (Mon-Sun) | email_campaigns_week_iso | dim | ||
| Day of month | email_campaigns_day_of_month | dim | ||
| Day of week (Sun-Sat) | email_campaigns_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | email_campaigns_day_of_week_name_iso | dim | ||
| Date | email_campaigns_date | dim | ||
| Datetime | email_campaigns_atom | dim | ||
| Email campaigns | Campaign ID | email_campaigns_id | dim | The unique ID of the email campaign |
| Scheduled at date-time | email_campaigns_scheduled_at | dim | UTC date-time on which campaign is scheduled | |
| Campaign name | email_campaigns_campaign__name | dim | The name of the email campaign | |
| Campaign status | email_campaigns_campaign__status | dim | The status of the email campaign | |
| Campaign type | email_campaigns_campaign__type | dim | The type of the email campaign | |
| Send date | email_campaigns_campaign__send_date | dim | Date when the campaign was sent | |
| Send date-time | email_campaigns_campaign__send_datetime | dim | Date and time when the campaign was sent | |
| Send at best time | email_campaigns_campaign__send_at_best_time | dim | It is true if you have chosen to send your campaign at best time, otherwise it is false | |
| Created at date-time | email_campaigns_campaign__created_at | dim | UTC date-time on which campaign is created | |
| Modified at date-time | email_campaigns_campaign__modified_at | dim | UTC date-time of last modification of the campaign | |
| Tag | email_campaigns_campaign__tag | dim | The tag of the campaign | |
| Status of the test email sending | email_campaigns_campaign__test_sent | dim | Retrieved the status of test email sending. True means that the test email has been sent and false that the test email has not been sent. | |
| Recurring | email_campaigns_campaign__recurring | dim | FOR TRIGGER ONLY ! Type of trigger campaign.recurring = false means contact can receive the same Trigger campaign only once, & recurring = true means contact can receive the same Trigger campaign several times | |
| List ID | email_campaigns_campaign_recipient_list__list_id | dim | The unique ID of the recipient list | |
| List | Recipient lists | email_campaigns_campaign__recipient_lists | dim | Recipient lists the campaign was sent to |
| Exclusion lists | email_campaigns_campaign__exclusion_lists | dim | Exclusions lists set for the campaign | |
| Content | Sender ID | email_campaigns_campaign__sender_id | dim | The unique ID of the sender |
| Sender name | email_campaigns_campaign__sender_name | dim | The name of the sender | |
| Sender email | email_campaigns_campaign__sender_email | dim | The email address of the sender | |
| Subject | email_campaigns_campaign__subject | dim | The subject of the campaign. Only available if A/B testing flag of the campaign is false | |
| Reply to address | email_campaigns_campaign__reply_to | dim | The email defined as the reply to address of the campaign | |
| To field | email_campaigns_campaign__to_field | dim | To field customisation | |
| Campaign header | email_campaigns_campaign__header | dim | The header of the email campaign | |
| Campaign footer | email_campaigns_campaign__footer | dim | The footer of the email campaign | |
| Status of inline image | email_campaigns_campaign__inline_image_activation | dim | Status of inline image. False means image can’t be embedded and true means image can be embedded in the email | |
| Status of mirror links | email_campaigns_campaign__mirror_active | dim | Status of mirror links in campaign. False means mirror links are deactivated and true means mirror links are activated in the campaign | |
| Share link | email_campaigns_campaign__share_link | dim | Link to share the campaign on social medias | |
| A/B test | A/B testing | email_campaigns_campaign__ab_testing | dim | Status of A/B test for the campaign. False means it is disabled and true means it is enabled |
| Subject A | email_campaigns_campaign__subject_a | dim | Subject A of the ab-test campaign. Only available if abTesting flag of the campaign is true | |
| Subject B | email_campaigns_campaign__subject_b | dim | Subject B of the ab-test campaign. Only available if abTesting flag of the campaign is true | |
| Split rule | email_campaigns_campaign__split_rule | dim | The size of your ab-test groups. Only available if abTesting flag of the campaign is true | |
| Winner criteria | email_campaigns_campaign__winner_criteria | dim | Criteria for the winning version. Only available if abTesting flag of the campaign is true | |
| Email recipients | email_campaigns_campaign_recipient_list__recipients | met | Number of recipients | |
| Emails delivered | email_campaigns_campaign_recipient_list__delivered | met | Number of emails delivered | |
| Delivery rate | email_campaigns_campaign_recipient_list__list_delivery_rate | met | Delivery rate. Emails delivered / Email recipients | |
| Opens (unique) | email_campaigns_campaign_recipient_list__opens_unique | met | Number of unique openings | |
| Opens (trackable) | email_campaigns_campaign_recipient_list__opens_trackable | met | Number of unique opens by recipients without privacy protection enabled | |
| Opens (total) | email_campaigns_campaign_recipient_list__opens_total | met | Number of total openings | |
| Open rate | email_campaigns_campaign_recipient_list__open_rate | met | Open rate. Number of email opened / Number of email delivered. | |
| Clicks (unique) | email_campaigns_campaign_recipient_list__clicks_unique | met | Number of unique recipients who clicked the email | |
| Clicks (total) | email_campaigns_campaign_recipient_list__clicks_total | met | Total number of clicks on the email | |
| Click rate | email_campaigns_campaign_recipient_list__click_rate | met | Click rate. Clicks (unique) / Emails delivered | |
| Click-to-open rate | email_campaigns_campaign_recipient_list__click_to_open_rate | met | Rate of openers who clicked the emall. Clicks (unique) / Opens (trackable) | |
| Soft bounces | email_campaigns_campaign_recipient_list__soft_bounces | met | Number of soft bounced emails | |
| Hard bounces | email_campaigns_campaign_recipient_list__hard_bounces | met | Number of hard bounced emails | |
| Bounces | email_campaigns_campaign_recipient_list__bounces | met | Total number of all bounced emails. Hard bounces + Soft bounces | |
| Unsubscribes | email_campaigns_campaign_recipient_list__unsubscribes | met | Number of users who unsubscribed from this campaign | |
| Unsubscribe rate | email_campaigns_campaign_recipient_list__unsubscribe_rate | met | Unsubscribe rate. Unsubscribes / Emails delivered | |
| Complaints | email_campaigns_campaign_recipient_list__complaints | met | Number of complaints (Spam reports) | |
| Complaint rate | email_campaigns_campaign_recipient_list__complaint_rate | met | Complaint rate. Complaints / Emails delivered | |
| Deferred emails | email_campaigns_campaign_recipient_list__deferred | met | Number of deferred emails |