Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Ad | Ad ID | performance_ad_id | dim | ID of the Ad. |
| Ad name | performance_ad_name | dim | Name of the ad. | |
| Ad current status | performance_ad_current_status | dim | Status of the ad. | |
| Ad set | Ad set cost type | performance_ad_set_cost_type | dim | |
| Ad set ID | performance_ad_set__ad_set_id | dim | ID of the ad set. | |
| Ad set name | performance_ad_set__ad_set_name | dim | Name of the ad set. | |
| Ad set start date and time | performance_ad_set__ad_set_start_date_time | dim | The start date and time of the ad set. | |
| Ad set start date | performance_ad_set__ad_set_start_date | dim | The start date of the ad set. | |
| Ad set end date and time | performance_ad_set__ad_set_end_date_time | dim | The end date and time of the ad set. | |
| Ad set end date | performance_ad_set__ad_set_end_date | dim | The end date of the ad set. | |
| Ad set current status | performance_ad_set__ad_set_status | dim | Status of the ad set. | |
| Ad set budget | performance_ad_set__ad_set_budget_micros | dim | Budget for the ad set. | |
| Ad set currency | performance_ad_set__ad_set_currency | dim | The currency of the ad set budget. | |
| Cost model | performance_ad_set__cost_model | dim | Method used to determine how advertisers are charged for their ad campaigns. | |
| Advertiser | Advertiser ID | performance_advertiser_id | dim | |
| Advertiser name | performance_advertiser_name | dim | ||
| Currency | performance_currency | dim | ||
| Targeting | Country | performance_country | dim | |
| Region | performance_region | dim | ||
| DMA | performance_dma | dim | ||
| Platform | performance_platform | dim | ||
| Time | Year | performance_details__year | dim | |
| Year of week (Sun-Sat) | performance_details__year_of_week | dim | ||
| Year of week (Mon-Sun) | performance_details__year_of_week_iso | dim | ||
| Year & month | performance_details__year_month | dim | ||
| Month | performance_details__month | dim | ||
| Year & week (Sun-Sat) | performance_details__year_week | dim | ||
| Year & week (Mon-Sun) | performance_details__year_week_iso | dim | ||
| Week (Sun-Sat) | performance_details__week | dim | ||
| Week (Mon-Sun) | performance_details__week_iso | dim | ||
| Day of month | performance_details__day_of_month | dim | ||
| Day of week (Sun-Sat) | performance_details__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | performance_details__day_of_week_name_iso | dim | ||
| Date | performance_details__date | dim | ||
| Datetime | performance_details__atom | dim | ||
| Campaign | Campaign ID | performance_ad_set__campaign__campaign_id | dim | ID of the campaign. |
| Campaign name | performance_ad_set__campaign__campaign_name | dim | Name of the campaign. | |
| Campaign current status | performance_ad_set__campaign__campaign_current_status | dim | Status of the campaign. | |
| Spend (USD) | performance_spend_usd | met | Spend converted to USD. | |
| Spend (EUR) | performance_spend_eur | met | Spend converted to EUR. | |
| Spend (GBP) | performance_spend_gbp | met | Spend converted to GBP. | |
| Impressions | performance_details__impressions | met | The number of times an ad has been served. | |
| Spend | performance_details__spend | met | The total amount spent. | |
| Clicks | performance_details__clicks | met | The number of impressions in which your ad was clicked. | |
| Reach | performance_details__reach | met | The number of unique users who received your ad. | |
| Frequency | performance_details__frequency | met | The number of ads that were clicked (Impressions / Reach). | |
| CTR | performance_details__ctr | met | The percentage of ads that were clicked (Clicks / Impressions). | |
| CPM | performance_details__cpm | met | Cost per 1000 impressions ((Spend / Impressions) * 1000). | |
| eCPCL | performance_details__ecpcl | met | Effective cost per 1000 completed listens ((Spend / Completes) * 1000). | |
| Off Spotify impressions | performance_details__off_spotify_impressions | met | The number of ads served off of Spotify. | |
| Completes | performance_details__completes | met | The number of ads served that was played to the end. | |
| Completion rate | performance_details__completion_rate | met | The percentage of ad served that was played to the end (Completes / Impressions). | |
| Ad played to 25% | performance_details__ad_played_to_25 | met | The percentage of users who listened or viewed a given percentage of the ad (First quartiles / Impressions). | |
| Ad played to 50% | performance_details__ad_played_to_50 | met | The percentage of users who listened or viewed a given percentage of the ad (Midpoints / Impressions). | |
| Ad played to 75% | performance_details__ad_played_to_75 | met | The percentage of users who listened or viewed a given percentage of the ad (Third quartiles / Impressions). | |
| Fetches | performance_fetches | met | The number of times an ad is called from the ad server | |
| Fetch reach | performance_fetch_reach | met | ||
| Serves | performance_serves | met | The total number of ads served | |
| Serve frequency | performance_serve_freq | met | The average number of times each person heard or viewed your ad | |
| Errors | performance_errors | met | The number of times an error occurred | |
| Render ratio | performance_render_ratio | met | The percentage of impressions in which a creative is actually displayed to the user | |
| Starts | performance_details__starts | met | The number of times a user starts hearing or viewing your ad. | |
| First quartile plays | performance_details__first_quartiles | met | The number of users who listened or viewed 25% of the ad's total length. | |
| Midpoint plays | performance_details__midpoints | met | The number of users for which the ad played to the midpoint of the ad's total length. | |
| Third quartile plays | performance_details__third_quartiles | met | The number of users who listened or viewed 75% of the ad's total length. | |
| Skips | performance_details__skips | met | The number of times a user skips and ad. | |
| Paid listens | performance_details__paid_listens | met | The number of listens for a CPCL campaign where user did not skip the ad. | |
| Paid listens frequency | performance_details__paid_listen_freq | met | The frequency for listens on a CPCL campaign (Paid listens / Paid listen reach). | |
| Paid listen reach | performance_details__paid_listen_reach | met | The number of unique users who had a paid listen for this CPCL campaign. | |
| Conversion rate | performance_details__conversion_rate | met | The percentage of users who listened to the artist after seeing or hearing an ad served by the campaign (Unique listeners / Impressions). | |
| Intent rate | performance_details__intent_rate | met | The rate at which listeners indicated an intent to stream the artist again in the future. | |
| New listeners | performance_details__new_listeners | met | The total number of users who listened to the artist for the first time in at least a month after seeing or hearing the ad. | |
| New listener conversion rate | performance_details__new_listener_conversion_rate | met | The percentage of users who listened to the artist for the first time in at least a month after seeing or hearing the ad. | |
| Streams | performance_details__streams | met | The total number of streams from listeners who saw or heard the ad. | |
| Streams per listener | performance_details__streams_per_listener | met | The average number of times each listener streamed the artist after seeing or hearing the ad (Streams / Unique listeners). | |
| Streams per new listener | performance_details__streams_per_new_listener | met | The average number of times each new listener streamed the artist after seeing or hearing the ad (Streams / New listeners). | |
| Unique listeners | performance_details__unique_listeners | met | The number of users who listened to the artist after hearing or seeing an ad. |