Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Campaign sent time | Year | campaigns_year | dim | Year. |
| Year & month | campaigns_year_month | dim | Year & month. | |
| Month | campaigns_month | dim | Month. | |
| Year & week (Mon-Sun) | campaigns_year_week_iso | dim | Year & week (Monday-Sunday). | |
| Year & week (Sun-Sat) | campaigns_year_week | dim | Year & week (Sunday-Saturday). | |
| Week (Mon-Sun) | campaigns_week_iso | dim | Week (Monday-Sunday). | |
| Week (Sun-Sat) | campaigns_week | dim | Week (Sunday-Saturday). | |
| Day of month | campaigns_day_of_month | dim | Day of month. | |
| Day of week (Mon-Sun) | campaigns_day_of_week_name_iso | dim | Day of week (Monday-Sunday). | |
| Day of week (Sun-Sat) | campaigns_day_of_week_name | dim | Day of week (Sunday-Saturday). | |
| Date | campaigns_date | dim | Date. | |
| Datetime | campaigns_atom | dim | Date and time | |
| Campaign | Campaign ID | campaigns_campaign_id | dim | ID of the campaign |
| Campaign name | campaigns_campaign_name | dim | Name of the campaign | |
| From name | campaigns_from_name | dim | From name | |
| From email | campaigns_from_email | dim | From email | |
| Subject | campaigns_subject | dim | Campaign subject | |
| Reply to | campaigns_reply_to | dim | Email for replying | |
| Web version URL | campaigns_web_version_url | dim | Link to the web version | |
| Web version text URL | campaigns_web_version_text_url | dim | Link to the web version in text | |
| Recipients | campaigns_campaign_summary__recipients | met | Number of recipients | |
| Opens | campaigns_campaign_summary__total_opened | met | Total number of opened campaigns | |
| Unique opens | campaigns_campaign_summary__unique_opened | met | Number of unique opened campaigns | |
| Open rate | campaigns_campaign_summary__open_rate | met | Percentage of opened campaigns (unique opened / (recipients - bounced)) | |
| Clicks | campaigns_campaign_summary__clicks | met | Number of clicks | |
| Click rate | campaigns_campaign_summary__click_rate | met | Percentage of campaign clicks (emails clicked / (recipients - bounced)) | |
| Unsubscribed | campaigns_campaign_summary__unsubscribed | met | Number of unsubscribed campaigns | |
| Unsubscribe rate | campaigns_campaign_summary__unsubscribe_rate | met | Percentage of unsubscribed campaigns ( unsubscribed / (recipients - bounced)) | |
| Bounces | campaigns_campaign_summary__bounced | met | Number of bounced campaigns | |
| Bounce rate | campaigns_campaign_summary__bounce_rate | met | Percentage of bounced campaigns (bounced / recipients) | |
| Spam complaints | campaigns_campaign_summary__spam_complaints | met | Number of spam complaints | |
| Forwards | campaigns_campaign_summary__forwards | met | Number of forwarded campaigns | |
| Forward rate (forwards / recipients) | campaigns_campaign_summary__forward_rate | met | Percentage of forwarded campaigns | |
| Likes | campaigns_campaign_summary__likes | met | Number of likes | |
| Mentions | campaigns_campaign_summary__mentions | met | Number of mentions |