Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Description |
|---|---|---|---|
| SENT & OPENED | Emails sent | emails_sent | The total number of emails sent for this campaign |
| Emails delivered | emails_delivered | The total number of emails confirmed sent for this campaign so far | |
| Emails cancelled | emails_cancelled | The total number of emails canceled for this campaign | |
| Delivery rate (%) | delivery_rate_perc | ||
| Unique opens | unique_opens | The total number of unique opens | |
| Total opens | opens_total | The total number of opens for a campaign | |
| Open rate (%) | open_rate_perc | The number of unique opens divided by the total number of successful deliveries | |
| BOUNCES | Bounces | bounces | The bounce summary for the campaign |
| Bounce rate (%) | bounce_rate_perc | ||
| Hard bounces | hard_bounces | The total number of hard bounced email addresses | |
| Soft bounces | soft_bounces | The total number of soft bounced email addresses | |
| Hard bounce rate (%) | hard_bounce_rate_perc | ||
| Soft bounce rate (%) | soft_bounce_rate_perc | ||
| Syntax errors | syntax_errors | The total number of addresses that were syntax-related bounces | |
| FORWARDS | Forwards | forwards_count | The forwards and forward activity for the campaign |
| Forward opens | forwards_opens | How many times the forwarded campaign has been opened | |
| ABUSE REPORTS | Abuse reports | abuse_reports | The number of abuse reports generated for this campaign |
| Abuse report rate (%) | abuse_rate_perc | The industry abuse rate | |
| UNSUBSCRIPTIONS | Unsubscribes | unsubscribes | A list of members who unsubscribed from a campaign |
| Unsubscription rate (%) | unsubscription_rate_perc | The average number of unsubscriptions per month for the list | |
| CLICKS | Unique clicks | unique_clicks | The total number of unique clicks for links across a campaign |
| Total clicks | clicks_total | The total number of clicks for the campaign | |
| Unique subscriber clicks | unique_subscriber_clicks | The total number of subscribers who clicked on a campaign | |
| Click rate (%) | click_rate_perc | The number of unique clicks divided by the total number of successful deliveries | |
| LIKES | Facebook likes | facebook_likes | The number of Facebook likes for the campaign |
| Unique likes | unique_likes | The number of unique likes | |
| Recipient likes | recipient_likes | The number of recipients who liked the campaign on Facebook | |
| ECOMMERCE | Total orders | ecommerce_total_orders | The total orders for a campaign |
| Total spent | ecommerce_total_spent | The total amount the customer has spent | |
| Total revenue | ecommerce_total_revenue | The total revenue for a campaign | |
| EEPURL | Twitter tweets | eepurl_tweets | The number of tweets including a link to the campaign |
| Retweets | eepurl_reweets | The number of retweets that include a link to the campaign | |
| EepURL clicks | eepurl_clicks | The total number of clicks to the campaign's URL | |
| A/B TESTING | Unique opens A | unique_opens_a | Unique opens for Campaign A |
| Unique opens B | unique_opens_b | Unique opens for Campaign B | |
| Total opens A | opens_a | Opens for Campaign A | |
| Total opens B | opens_b | Opens for Campaign B | |
| Bounces A | bounces_a | Bounces for Campaign A | |
| Bounces B | bounces_b | Bounces for Campaign B | |
| Forwards A | forwards_a | Forwards for Campaign A | |
| Forwards B | forwards_b | Forwards for Campaign B | |
| Forward opens A | forwards_opens_a | Opens from forwards for Campaign A | |
| Forward opens B | forwards_opens_b | Opens from forwards for Campaign B | |
| Abuse reports A | abuse_reports_a | Abuse reports for Campaign A | |
| Abuse reports B | abuse_reports_b | Abuse reports for Campaign B | |
| Unsubscriptions A | unsubs_a | Unsubscribes for Campaign A | |
| Unsubscriptions B | unsubs_b | Unsubscribes for Campaign B | |
| Recipient clicks A | recipients_click_a | Recipient Clicks for Campaign A | |
| Recipient clicks B | recipients_click_b | Recipient Clicks for Campaign B | |
| LIST ALL-TIME TOTALS | Campaign count | campaign_count | The number of campaigns in the folder |
| Member count | member_count | The number of active members in the list | |
| Member count since last send | member_count_since_send | The number of active members in the list since the last campaign was sent | |
| Cleaned count | cleaned_count | The number of members cleaned from the list | |
| Cleaned count since last send | cleaned_count_since_send | The number of members cleaned from the list since the last campaign was sent | |
| List unsubscribe count | list_unsubscribe_count | The number of members who have unsubscribed from the list | |
| List unsubscribe count since last send | unsubscribe_count_since_send | The number of members who have unsubscribed since the last campaign was sent | |
| List open rate (%) | list_open_rate_perc | The average open rate per campaign for the list | |
| List click rate (%) | list_click_rate_perc | The average click rate per campaign for the list | |
| List subscription rate (%) | list_avg_sub_rate_perc | The average number of subscriptions per month for the list | |
| List unsubscription rate (%) | list_avg_unsub_rate_perc | The average number of unsubscriptions per month for the list | |
| Target subscription rate (%) | list_target_sub_rate_perc | The target number of subscriptions per month for the list to keep it growing | |
| LIST METRICS BY TIME | Opt-in members | optins | Newly opted-in members on the list for a specific month |
| Imported members | imports | Imported members on the list for a specific month | |
| Removed members | removes | ||
| Subscribed members | subscribed | Newly subscribed members on the list for a specific month | |
| Unsubscribed members | unsubscribed | Newly unsubscribed members on the list for a specific month | |
| Reconfirmed members | reconfirmed | Newly reconfirmed members on the list for a specific month | |
| Cleaned members | cleaned | Newly cleaned (hard-bounced) members on the list for a specific month | |
| Pending members | pending | Pending members on the list for a specific month | |
| Deleted members | deleted | Newly deleted members on the list for a specific month | |
| Transactional subscribers | transactional | Subscribers that have been sent transactional emails via Mandrill | |
| LIST MEMBERS | Member avg. open rate (%) | member_avg_open_rate_perc | A subscriber's average open rate |
| Member avg. click rate (%) | member_avg_click_rate_perc | A subscriber's average clickthrough rate | |
| LIST LOCATIONS | Subscriber percent in country | list_location_subspercent | The percent of subscribers in the country |
| Total subscribers in country | list_location_substotal | The total number of subscribers in the country | |
| AUTOMATION ALL-TIME TOTALS | Automation open rate (%) | automation_open_rate_perc | The number of unique opens divided by the total number of successful deliveries |
| Automation click rate (%) | automation_click_rate_perc | The number of unique clicks, divided by the total number of successful deliveries | |
| INDUSTRY | Industry open rate (%) | industry_open_rate_perc | The industry open rate |
| Industry click rate (%) | industry_click_rate_perc | The industry click rate | |
| Industry bounce rate (%) | industry_bounce_rate_perc | The industry bounce rate | |
| Industry unopen rate (%) | industry_unopen_rate_perc | The industry unopened rate | |
| Industry unsubscription rate (%) | industry_unsub_rate_perc | The industry unsubscribe rate | |
| Industry abuse report rate (%) | industry_abuse_rate_perc | The industry abuse rate | |
| DEPRECATED | Existing members | existing | Existing members on the list for a specific month. Please note that this field will be removed on 2020-03-24 |