Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | reporting_year | dim | |
| Year of week (Sun-Sat) | reporting_year_of_week | dim | ||
| Year of week (Mon-Sun) | reporting_year_of_week_iso | dim | ||
| Year & month | reporting_year_month | dim | ||
| Month | reporting_month | dim | ||
| Year & week (Sun-Sat) | reporting_year_week | dim | ||
| Year & week (Mon-Sun) | reporting_year_week_iso | dim | ||
| Week (Sun-Sat) | reporting_week | dim | ||
| Week (Mon-Sun) | reporting_week_iso | dim | ||
| Day of month | reporting_day_of_month | dim | ||
| Day of week (Sun-Sat) | reporting_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | reporting_day_of_week_name_iso | dim | ||
| Date | reporting_date | dim | ||
| Datetime | reporting_atom | dim | ||
| Account | Seat ID | reporting_ad_owner_id | dim | Teads Ad Manager Seat id. |
| Seat name | reporting_ad_owner_name | dim | Teads Ad Manager Seat name. | |
| Advertiser ID | reporting_advertiser_id | dim | Teads id of the advertiser. | |
| Advertiser name | reporting_advertiser_name | dim | Name of the advertiser. | |
| Campaign | Campaign ID | reporting_ad_id | dim | Teads id of the campaign. |
| Campaign name | reporting_ad_external_name | dim | Name of the campaign. | |
| Campaign currency | reporting_io_currency | dim | Currency of the campaign. | |
| Campaign budget | reporting_io_budget | dim | Total budget of the campaign. | |
| Line item | Line item ID | reporting_io_line_id | dim | Teads id of the line item. |
| Line item name | reporting_io_line_external_name | dim | Name of the line item. | |
| Line item budget | reporting_io_line_budget | dim | Budget of the line item. | |
| Line item billable event | reporting_price_advertiser_event | dim | Billable event for the line item. | |
| Auction has billable | reporting_auction_has_advertiser_billable | dim | Auction has billable - TRUE if the impression was billed, FALSE otherwise. | |
| Creative | Creative ID | reporting_creative_id | dim | Teads id of the creative. |
| Creative name | reporting_creative_external_name | dim | Name of the creative. | |
| Creative external integration code | reporting_creative_external_integration_code | dim | Code for integrating with another reporting system. | |
| Creative portfolio item | reporting_portfolio_item_name | dim | Commercial name of the creative type. | |
| Creative family | reporting_format_creative_type_family_name | dim | Creative family (Video, Viewable Display, etc). | |
| Creative type | reporting_format_creative_type_name | dim | Creative type (Carousel, Scroller, etc). | |
| Creative size | reporting_format_size_name | dim | Creative size: landscape, square, vertical, social. | |
| Visitor | Browser | reporting_browser | dim | Name of browser. |
| Browser version | reporting_browser_version | dim | Version of browser. | |
| Device | reporting_device | dim | Device: Desktop, SmartTV, Smartphone, Tablet. | |
| Country code | reporting_country_code | dim | Country code of the user - ISO 3166-1 alpha-2 format. | |
| Country name | reporting_country_name | dim | Country name of the user. | |
| Website domain | reporting_website_domain | dim | The domain of the website. | |
| Clicks | reporting_click | met | Number of creative clicks. | |
| Impression | reporting_impression | met | Number of impressions. | |
| CTR | reporting_ctr | met | Click-through rate. | |
| Post Click conversions | reporting_post_click_conversion | met | Number of post click conversions attributed to the campaign. | |
| Post View conversions | reporting_post_view_conversion | met | Number of post view conversions attributed to the campaign. | |
| Unique Viewers | reporting_uv_impression | met | Estimated number of unique Teads IDs exposed to the ad. | |
| Budget Spent | reporting_turnover_value | met | Budget spent (i.e. invoiced by Teads). Includes Ad Manager fee. Does not include Added Value budget nor Agency fee. It is calculated as Fee + Total ad cost | |
| Total ad cost | reporting_turnover_advertising_value | met | Budget spent on advertising cost. Does not include Added Value Budget, nor Ad Manager fee, nor Agency fee. | |
| Fee | reporting_turnover_fee_value | met | Budget spent on Ad Manager fee cost. | |
| Budget delivered | reporting_budget_delivered_value | met | Advertiser budget consumed. Includes Added Value budget, Ad Manager fee and Agency fee. | |
| Budget delivered Teads | reporting_budget_delivered_teads_value | met | Total value delivered by Teads. Includes Added Value budget and Ad Manager fee. Does not include Agency fee. | |
| Budget delivered Agency Fee | reporting_budget_delivered_agency_fee_value | met | Agency fee. Not invoiced by Teads. | |
| Budget delivered Total Ad Cost | reporting_budget_delivered_advertising_value | met | Advertising value (media & data) delivered by Teads. Includes Added Value budget. Does not include Ad Manager fee nor Agency fee. | |
| Budget delivered Fee | reporting_budget_delivered_platform_fee_value | met | Ad Manager fee. | |
| Budget spent - Cost per result | reporting_turnover_average_cost_per_result_value | met | Average price of each result, considering the budget spent (invoiced by Teads) and the total volume delivered. | |
| Budget delivered - Cost per result | reporting_budget_delivered_average_cost_per_result_value | met | Average price of each result, based on the budget_delivered. This is the cost per result paid by the advertiser, including advertising cost, Ad Manager fee and Agency fee. | |
| Budget delivered Teads - Cost per result | reporting_budget_delivered_teads_average_cost_per_result_value | met | Average price of each result, based on the budget_delivered_teads. This is the cost per result delivered by Teads, including advertising cost and Ad Manager fee. | |
| Budget delivered Total Ad Cost - Cost per result | reporting_budget_delivered_advertising_average_cost_per_result_value | met | Average price of each result, based on the budget_delivered_advertising. This is the cost per result considering only the advertising cost. | |
| Budget spent - CPM | reporting_turnover_average_cpm_value | met | Average price of a thousand impressions, considering the budget spent (invoiced by Teads) and the total volume delivered. | |
| Budget delivered - CPM | reporting_budget_delivered_average_cpm_value | met | Average price of a thousand impressions (display) or starts (video), based on the budget_delivered. This is the CPM value paid by the advertiser, including advertising cost, Ad Manager fee and Agency fee. | |
| Budget delivered Teads - CPM | reporting_budget_delivered_teads_average_cpm_value | met | Average price of a thousand impressions (display) or starts (video), based on the budget_delivered_teads. This is the CPM value delivered by Teads, including advertising cost and Ad Manager fee. | |
| Budget delivered Total Ad Cost - CPM | reporting_budget_delivered_advertising_average_cpm_value | met | Average price of a thousand impressions (display) or starts (video), based on the budget_delivered_advertising. This is the CPM value considering only the advertising cost. | |
| Budget spent - CPC | reporting_turnover_average_cpc_value | met | Average price of each click, considering the budget spent (invoiced by Teads) and the total volume delivered. | |
| Budget delivered - CPC | reporting_budget_delivered_average_cpc_value | met | Average price of a click, based on the budget_delivered. This is the CPC value paid by the Advertiser, including advertising cost, Ad Manager fee and Agency fee. | |
| Budget delivered Teads - CPC | reporting_budget_delivered_teads_average_cpc_value | met | Average price of a click, based on the budget_delivered_teads. This is the CPC value delivered by Teads, including advertising cost and Ad Manager fee. | |
| Budget delivered Total Ad Cost - CPC | reporting_budget_delivered_advertising_average_cpc_value | met | Average price of a click, based on the budget_delivered_advertising. This is the CPC value considering only the advertising cost. | |
| Billable events | reporting_advertiser_billable_volume | met | Number of results delivered. | |
| MOAT - Impressions Analyzed (unfiltered for IVT) | reporting_moat_analyzed_impression | met | ||
| MOAT - Impressions Analyzed (filtered for IVT) | reporting_moat_analyzed_impression_filtered | met | ||
| MOAT - In-View Measurable Impressions | reporting_moat_inview_measurable_impression | met | ||
| MOAT - Valid and Viewable Impressions | reporting_moat_inview_viewable_impression | met | ||
| MOAT - Valid and Viewable % | reporting_moat_viewable_rate | met | ||
| MOAT - Total In-View Time (ms) | reporting_moat_total_inview_time | met | ||
| MOAT - Average In-View Time (ms) | reporting_moat_average_inview_time | met | ||
| MOAT - Total Ad Length (ms) | reporting_moat_total_ad_length | met | ||
| MOAT - Complete In-View Impressions | reporting_moat_video_complete_inview_impression | met | ||
| MOAT - Average Ad Length (ms) | reporting_moat_video_average_ad_length | met | ||
| MOAT - 1 Sec In-View Impressions | reporting_moat_1s_inview_impression | met | ||
| MOAT - 2 Sec In-View Impressions | reporting_moat_2s_inview_impression | met | ||
| MOAT - 3 Sec In-View Impressions | reporting_moat_3s_inview_impression | met | ||
| MOAT - 4 Sec In-View Impressions | reporting_moat_4s_inview_impression | met | ||
| MOAT - 5 Sec In-View Impressions | reporting_moat_5s_inview_impression | met | ||
| MOAT - 6 Sec In-View Impressions | reporting_moat_6s_inview_impression | met | ||
| MOAT - 7 Sec In-View Impressions | reporting_moat_7s_inview_impression | met | ||
| MOAT - 8 Sec In-View Impressions | reporting_moat_8s_inview_impression | met | ||
| MOAT - 9 Sec In-View Impressions | reporting_moat_9s_inview_impression | met | ||
| MOAT - 10 Sec In-View Impressions | reporting_moat_10s_inview_impression | met | ||
| MOAT - 11 Sec In-View Impressions | reporting_moat_11s_inview_impression | met | ||
| MOAT - 12 Sec In-View Impressions | reporting_moat_12s_inview_impression | met | ||
| MOAT - 3 Sec In-View Impressions | reporting_moat_13s_inview_impression | met | ||
| MOAT - 14 Sec In-View Impressions | reporting_moat_14s_inview_impression | met | ||
| MOAT - 15 Sec In-View Impressions | reporting_moat_15s_inview_impression | met | ||
| MOAT - 16 Sec In-View Impressions | reporting_moat_16s_inview_impression | met | ||
| MOAT - 17 Sec In-View Impressions | reporting_moat_17s_inview_impression | met | ||
| MOAT - 18 Sec In-View Impressions | reporting_moat_18s_inview_impression | met | ||
| MOAT - 19 Sec In-View Impressions | reporting_moat_19s_inview_impression | met | ||
| MOAT - 20 Sec In-View Impressions | reporting_moat_20s_inview_impression | met | ||
| MOAT - 21 Sec In-View Impressions | reporting_moat_21s_inview_impression | met | ||
| MOAT - 22 Sec In-View Impressions | reporting_moat_22s_inview_impression | met | ||
| MOAT - 23 Sec In-View Impressions | reporting_moat_23s_inview_impression | met | ||
| MOAT - 24 Sec In-View Impressions | reporting_moat_24s_inview_impression | met | ||
| MOAT - 25 Sec In-View Impressions | reporting_moat_25s_inview_impression | met | ||
| MOAT - 26 Sec In-View Impressions | reporting_moat_26s_inview_impression | met | ||
| MOAT - 27 Sec In-View Impressions | reporting_moat_27s_inview_impression | met | ||
| MOAT - 28 Sec In-View Impressions | reporting_moat_28s_inview_impression | met | ||
| MOAT - 29 Sec In-View Impressions | reporting_moat_29s_inview_impression | met | ||
| MOAT - 30 Sec In-View Impressions | reporting_moat_30s_inview_impression | met | ||
| MOAT - Complete In-View Impressions | reporting_moat_complete_inview_impression | met | ||
| Video starts | reporting_video_start | met | ||
| 1 second view | reporting_progress_1 | met | ||
| 2 second view | reporting_progress_2 | met | ||
| 3 second view | reporting_progress_3 | met | ||
| 4 second view | reporting_progress_4 | met | ||
| 5 second view | reporting_progress_5 | met | ||
| 6 second view | reporting_progress_6 | met | ||
| 7 second view | reporting_progress_7 | met | ||
| 8 second view | reporting_progress_8 | met | ||
| 9 second view | reporting_progress_9 | met | ||
| 10 second view | reporting_progress_10 | met | ||
| 11 second view | reporting_progress_11 | met | ||
| 12 second view | reporting_progress_12 | met | ||
| 13 second view | reporting_progress_13 | met | ||
| 14 second view | reporting_progress_14 | met | ||
| 15 second view | reporting_progress_15 | met | ||
| 16 second view | reporting_progress_16 | met | ||
| 17 second view | reporting_progress_17 | met | ||
| 18 second view | reporting_progress_18 | met | ||
| 19 second view | reporting_progress_19 | met | ||
| 20 second view | reporting_progress_20 | met | ||
| 21 second view | reporting_progress_21 | met | ||
| 22 second view | reporting_progress_22 | met | ||
| 23 second view | reporting_progress_23 | met | ||
| 24 second view | reporting_progress_24 | met | ||
| 25 second view | reporting_progress_25 | met | ||
| 26 second view | reporting_progress_26 | met | ||
| 27 second view | reporting_progress_27 | met | ||
| 28 second view | reporting_progress_28 | met | ||
| 29 second view | reporting_progress_29 | met | ||
| 30 second view | reporting_progress_30 | met | ||
| Video first quartile | reporting_video_first_quartile | met | Video first quartile. | |
| Video midpoint | reporting_video_midpoint | met | Video midpoint. | |
| Video third quartile | reporting_video_third_quartile | met | Video third quartile. | |
| Video complete | reporting_video_complete | met | Video complete. | |
| Video completion rate | reporting_video_completion_rate | met | Video completion rate. It is calculated as Video completes / Video starts | |
| Video progress 1 second | reporting_video_progress_1 | met | ||
| Video progress 2 second | reporting_video_progress_2 | met | ||
| Video progress 3 second | reporting_video_progress_3 | met | ||
| Video progress 4 second | reporting_video_progress_4 | met | ||
| Video progress 5 second | reporting_video_progress_5 | met | ||
| Video progress 6 second | reporting_video_progress_6 | met | ||
| Video progress 7 second | reporting_video_progress_7 | met | ||
| Video progress 8 second | reporting_video_progress_8 | met | ||
| Video progress 9 second | reporting_video_progress_9 | met | ||
| Video progress 10 second | reporting_video_progress_10 | met | ||
| Video progress 11 second | reporting_video_progress_11 | met | ||
| Video progress 12 second | reporting_video_progress_12 | met | ||
| Video progress 13 second | reporting_video_progress_13 | met | ||
| Video progress 14 second | reporting_video_progress_14 | met | ||
| Video progress 15 second | reporting_video_progress_15 | met | ||
| Video progress 16 second | reporting_video_progress_16 | met | ||
| Video progress 17 second | reporting_video_progress_17 | met | ||
| Video progress 18 second | reporting_video_progress_18 | met | ||
| Video progress 19 second | reporting_video_progress_19 | met | ||
| Video progress 20 second | reporting_video_progress_20 | met | ||
| Video progress 21 second | reporting_video_progress_21 | met | ||
| Video progress 22 second | reporting_video_progress_22 | met | ||
| Video progress 23 second | reporting_video_progress_23 | met | ||
| Video progress 24 second | reporting_video_progress_24 | met | ||
| Video progress 25 second | reporting_video_progress_25 | met | ||
| Video progress 26 second | reporting_video_progress_26 | met | ||
| Video progress 27 second | reporting_video_progress_27 | met | ||
| Video progress 28 second | reporting_video_progress_28 | met | ||
| Video progress 29 second | reporting_video_progress_29 | met | ||
| Video progress 30 second | reporting_video_progress_30 | met | ||
| Display 1 second view | reporting_display_progress_1 | met | ||
| Display 2 second view | reporting_display_progress_2 | met | ||
| Display 3 second view | reporting_display_progress_3 | met | ||
| Display 4 second view | reporting_display_progress_4 | met | ||
| Display 5 second view | reporting_display_progress_5 | met | ||
| Display 6 second view | reporting_display_progress_6 | met | ||
| Display 7 second view | reporting_display_progress_7 | met | ||
| Display 8 second view | reporting_display_progress_8 | met | ||
| Display 9 second view | reporting_display_progress_9 | met | ||
| Display 10 second view | reporting_display_progress_10 | met | ||
| Display 11 second view | reporting_display_progress_11 | met | ||
| Display 12 second view | reporting_display_progress_12 | met | ||
| Display 13 second view | reporting_display_progress_13 | met | ||
| Display 14 second view | reporting_display_progress_14 | met | ||
| Display 15 second view | reporting_display_progress_15 | met | ||
| Display 16 second view | reporting_display_progress_16 | met | ||
| Display 17 second view | reporting_display_progress_17 | met | ||
| Display 18 second view | reporting_display_progress_18 | met | ||
| Display 19 second view | reporting_display_progress_19 | met | ||
| Display 20 second view | reporting_display_progress_20 | met | ||
| Display 21 second view | reporting_display_progress_21 | met | ||
| Display 22 second view | reporting_display_progress_22 | met | ||
| Display 23 second view | reporting_display_progress_23 | met | ||
| Display 24 second view | reporting_display_progress_24 | met | ||
| Display 25 second view | reporting_display_progress_25 | met | ||
| Display 26 second view | reporting_display_progress_26 | met | ||
| Display 27 second view | reporting_display_progress_27 | met | ||
| Display 28 second view | reporting_display_progress_28 | met | ||
| Display 29 second view | reporting_display_progress_29 | met | ||
| Display 30 second view | reporting_display_progress_30 | met |