Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | ads_year | dim | |
| Year of week (Sun-Sat) | ads_year_of_week | dim | ||
| Year of week (Mon-Sun) | ads_year_of_week_iso | dim | ||
| Year & month | ads_year_month | dim | ||
| Month | ads_month | dim | ||
| Year & week (Sun-Sat) | ads_year_week | dim | ||
| Year & week (Mon-Sun) | ads_year_week_iso | dim | ||
| Week (Sun-Sat) | ads_week | dim | ||
| Week (Mon-Sun) | ads_week_iso | dim | ||
| Day of month | ads_day_of_month | dim | ||
| Day of week (Sun-Sat) | ads_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | ads_day_of_week_name_iso | dim | ||
| Date | ads_date | dim | ||
| Datetime | ads_atom | dim | ||
| Customer | Customer name | ads_customer_name | dim | Name of the customer. |
| Customer ID | ads_customer_id | dim | ID of the customer. | |
| Ads | Ad name | ads_ad_name | dim | The name of the ad. |
| Ad ID | ads_ad_id | dim | ID of the ad. | |
| Ad type | ads_details__ad_type | dim | The type of your ad. | |
| Status | ads_details__status | dim | The current status of your ad. | |
| Billing | ads_details__billing | dim | The billing model you selected for your ad. | |
| Total budget | ads_details__total_budget | dim | Your total budget for the entire campaign timeframe. | |
| Daily budget | ads_details__daily_budget | dim | Your daily budget for the campaign. | |
| Bid | ads_details__bid | dim | The amount of bid (EUR). | |
| Target URL | ads_details__target_url | dim | A link to a target. | |
| Start date | ads_details__start_date | dim | The start date of your ad. | |
| End date | ads_details__end_date | dim | The selected end date for your ad. | |
| Impressions | ads_impressions | met | Total number of ad impressions. This is a value for the selected date range. | |
| Clicks | ads_clicks | met | Total number of ad clicks. This is a value for the selected date range. | |
| Spend (EUR) | ads_spend | met | The amount of budget spend in EUR. This is a value for the selected date range. | |
| Spend (USD) | ads_spend_usd | met | The amount of budget spend in USD. This is a value for the selected date range. | |
| Spend (GBP) | ads_spend_gbp | met | The amount of budget spend in GBP. This is a value for the selected date range. | |
| CTR | ads_ctr | met | Click through rate (Clicks / Impressions). This is a value for the selected date range. | |
| CPM | ads_cpm | met | Cost per mille ((Spend / Impressions) * 1000). This is a value for the selected date range. | |
| CPC | ads_cpc | met | Cost per click (Spend / Clicks). This is a value for the selected date range. | |
| Lifetime impressions | ads_lifetime__lifetime_impressions | met | Total number of impressions. This is a value for the whole lifetime of the campaign. | |
| Lifetime reach | ads_lifetime__lifetime_reach | met | The number of people who viewed your ad at least once. This is a value for the whole lifetime of the campaign. | |
| Lifetime frequency | ads_lifetime__lifetime_frequency | met | Frequency of your ad views (Lifetime impressions / Lifetime reach). This is a value for the whole lifetime of the campaign. | |
| Video plays | ads_video_plays | met | Total number of video plays. This is a value for the selected date range. | |
| 3s plays | ads_3s_plays | met | Total number of times the video view lasted for a minimum of 3 seconds. This is a value for the selected date range. | |
| 10s plays | ads_10s_plays | met | Total number of times the video view lasted for a minimum of 10 seconds. This is a value for the selected date range. | |
| 25% plays | ads_25p_plays | met | Total number of times that minimum 25% of the video has been watched. This is a value for the selected date range. | |
| 50% plays | ads_50p_plays | met | Total number of times that minimum 50% of the video has been watched. This is a value for the selected date range. | |
| 75% plays | ads_75p_plays | met | Total number of times that minimum 75% of the video has been watched. This is a value for the selected date range. | |
| 95% plays | ads_95p_plays | met | Total number of times that minimum 95% of the video has been watched. This is a value for the selected date range. | |
| 3s plays | ads_plays_3s | met | Total number of times the video view lasted for a minimum of 3 seconds. This is a value for the selected date range. | |
| 10s plays | ads_plays_10s | met | Total number of times the video view lasted for a minimum of 10 seconds. This is a value for the selected date range. | |
| 25% plays | ads_plays_25p | met | Total number of times that minimum 25% of the video has been watched. This is a value for the selected date range. | |
| 50% plays | ads_plays_50p | met | Total number of times that minimum 50% of the video has been watched. This is a value for the selected date range. | |
| 75% plays | ads_plays_75p | met | Total number of times that minimum 75% of the video has been watched. This is a value for the selected date range. | |
| 95% plays | ads_plays_95p | met | Total number of times that minimum 95% of the video has been watched. This is a value for the selected date range. | |
| Video completes | ads_video_completes | met | Total number of times the video has been watched completely. This is a value for the selected date range. | |
| 3s watched rate | ads_3s_watched_rate | met | The percentage of the video views that lasted for a minimum of 3 seconds (3s plays / Video plays). This is a value for the selected date range. | |
| 10s watched rate | ads_10s_watched_rate | met | The percentage of the video views that lasted for a minimum of 10 seconds (10s plays / Video plays). This is a value for the selected date range. | |
| 25% watched rate | ads_25p_watched_rate | met | The percentage of the video views that watched minimum 25% of the video (25% plays / Video plays). This is a value for the selected date range. | |
| 50% watched rate | ads_50p_watched_rate | met | The percentage of the video views that watched minimum 50% of the video (50% plays / Video plays). This is a value for the selected date range. | |
| 75% watched rate | ads_75p_watched_rate | met | The percentage of the video views that watched minimum 75% of the video (75p plays / Video plays). This is a value for the selected date range. | |
| 95% watched rate | ads_95p_watched_rate | met | The percentage of the video views that watched minimum 95% of the video (95% plays / Video plays). This is a value for the selected date range. | |
| 3s watched rate | ads_watched_rate_3s | met | The percentage of the video views that lasted for a minimum of 3 seconds (3s plays / Video plays). This is a value for the selected date range. | |
| 10s watched rate | ads_watched_rate_10s | met | The percentage of the video views that lasted for a minimum of 10 seconds (10s plays / Video plays). This is a value for the selected date range. | |
| 25% watched rate | ads_watched_rate_25p | met | The percentage of the video views that watched minimum 25% of the video (25% plays / Video plays). This is a value for the selected date range. | |
| 50% watched rate | ads_watched_rate_50p | met | The percentage of the video views that watched minimum 50% of the video (50% plays / Video plays). This is a value for the selected date range. | |
| 75% watched rate | ads_watched_rate_75p | met | The percentage of the video views that watched minimum 75% of the video (75p plays / Video plays). This is a value for the selected date range. | |
| 95% watched rate | ads_watched_rate_95p | met | The percentage of the video views that watched minimum 95% of the video (95% plays / Video plays). This is a value for the selected date range. | |
| Video completion rate | ads_video_completion_rate | met | The percentage of video views that watched the video completely (Video completes / Video plays). This is a value for the selected date range. |