Teads Looker Studio connector by Windsor.ai
+
About the Connector
The connector pulls metrics and dimensions from Teads. The insights are retrieved at campaign, creative and line item level.
Once user successfully logs into the connector its possible to choose the metrics and dimensions to create a report on.
Prerequisites
The user should have a Teads API key in order to use this connector.
Our privacy policy and terms of use.
Available Metrics and Dimensions
| Name | Type | Description | |
|---|---|---|---|
| Campaign ID | TEXT | Teads id of the campaign | |
| Seat id | TEXT | Teads Ad Manager Seat id | |
| Seat name | TEXT | Teads Ad Manager Seat name | |
| Billable impressions | NUMERIC | Number of results delivered | |
| Advertiser ID | TEXT | Teads id of the advertiser | |
| Advertiser | TEXT | Name of the advertiser | |
| Auction has billable | TEXT | Auction has billable - TRUE if the impression was billed, FALSE otherwise. Computing if an event (impression, click, etc) was tracked as part of a billable session is based on a 30 minute window and could contain false negatives, when an event is part of a billable session but was tracked in a different time window. There are no false positives. | |
| Browser | TEXT | Name of browser | |
| Browser version | TEXT | Version of browser | |
| Budget delivered Total Ad Cost - Cost per result | NUMERIC | Average price of each result, based on the budget_delivered_advertising. This is the cost per result considering only the advertising cost. | |
| Budget delivered Total Ad Cost - CPC | NUMERIC | Average price of a click, based on the budget_delivered_advertising. This is the CPC value considering only the advertising cost. | |
| Budget delivered Total Ad Cost - CPM | NUMERIC | 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 delivered Total Ad Cost | NUMERIC | Advertising value (media & data) delivered by Teads. Includes Added Value budget. Does not include Ad Manager fee nor Agency fee. | |
| Budget delivered Agency Fee | NUMERIC | Agency fee. Not invoiced by Teads. | |
| Budget delivered - Cost per result | NUMERIC | 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 - CPC | NUMERIC | 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 - CPM | NUMERIC | 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 Fee | NUMERIC | Ad Manager fee | |
| Budget delivered Teads - Cost per result | NUMERIC | 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 Teads - CPC | NUMERIC | 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 Teads - CPM | NUMERIC | 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 Teads | NUMERIC | Total value delivered by Teads. Includes Added Value budget and Ad Manager fee. Does not include Agency fee. | |
| Budget delivered | NUMERIC | Advertiser budget consumed. Includes Added Value budget, Ad Manager fee and Agency fee. | |
| Campaign IO budget | TEXT | Total budget of the campaign | |
| Campaign name | TEXT | Name of the campaign | |
| Clickthrough rate | NUMERIC | Clickthrough rate | |
| Clicks | NUMERIC | Clicks | |
| Country code | TEXT | Country code of the user - ISO 3166-1 alpha-2 format, ex: US, FR | |
| Country name | TEXT | Country name of the user | |
| Creative external integration code | TEXT | Code for integrating with another reporting system | |
| Creative ID | TEXT | Teads id of the creative | |
| Creative name | TEXT | Name of the creative | |
| Creative size | TEXT | Creative size. Possible values: landscape, square, vertical, social. | |
| Creative type | TEXT | Creative type (Carousel, Scroller, etc) | |
| Date | DATE | Alias for Day but in %Y-%m-%d format. | |
| Day | TEXT | Day for the data | |
| Device | TEXT | Device. Possible values: Desktop, SmartTV, Smartphone, Tablet. | |
| Display 1 second view | NUMERIC | Display 1 second view | |
| Display 10 second view | NUMERIC | Display 10 second view | |
| Display 11 second view | NUMERIC | Display 11 second view | |
| Display 12 second view | NUMERIC | Display 12 second view | |
| Display 13 second view | NUMERIC | Display 13 second view | |
| Display 14 second view | NUMERIC | Display 14 second view | |
| Display 15 second view | NUMERIC | Display 15 second view | |
| Display 16 second view | NUMERIC | Display 16 second view | |
| Display 17 second view | NUMERIC | Display 17 second view | |
| Display 18 second view | NUMERIC | Display 18 second view | |
| Display 19 second view | NUMERIC | Display 19 second view | |
| Display 2 second view | NUMERIC | Display 2 second view | |
| Display 20 second view | NUMERIC | Display 20 second view | |
| Display 21 second view | NUMERIC | Display 21 second view | |
| Display 22 second view | NUMERIC | Display 22 second view | |
| Display 23 second view | NUMERIC | Display 23 second view | |
| Display 24 second view | NUMERIC | Display 24 second view | |
| Display 25 second view | NUMERIC | Display 25 second view | |
| Display 26 second view | NUMERIC | Display 26 second view | |
| Display 27 second view | NUMERIC | Display 27 second view | |
| Display 28 second view | NUMERIC | Display 28 second view | |
| Display 29 second view | NUMERIC | Display 29 second view | |
| Display 3 second view | NUMERIC | Display 3 second view | |
| Display 30 second view | NUMERIC | Display 30 second view | |
| Display 4 second view | NUMERIC | Display 4 second view | |
| Display 5 second view | NUMERIC | Display 5 second view | |
| Display 6 second view | NUMERIC | Display 6 second view | |
| Display 7 second view | NUMERIC | Display 7 second view | |
| Display 8 second view | NUMERIC | Display 8 second view | |
| Display 9 second view | NUMERIC | Display 9 second view | |
| Creative family | TEXT | Creative family (Video, Viewable Display, etc) | |
| Hour | TEXT | Hour for the data | |
| Impressions | NUMERIC | Impressions | |
| Campaign currency | TEXT | Currency of the campaign | |
| Line item budget | TEXT | Budget of the line item | |
| Line item ID | TEXT | Teads id of the line item | |
| Line item name | TEXT | Name of the line item | |
| MOAT - 10 Sec In-View Impressions | NUMERIC | MOAT - 10 Sec In-View Impressions | |
| MOAT - 11 Sec In-View Impressions | NUMERIC | MOAT - 11 Sec In-View Impressions | |
| MOAT - 12 Sec In-View Impressions | NUMERIC | MOAT - 12 Sec In-View Impressions | |
| MOAT - 13 Sec In-View Impressions | NUMERIC | MOAT - 13 Sec In-View Impressions | |
| MOAT - 14 Sec In-View Impressions | NUMERIC | MOAT - 14 Sec In-View Impressions | |
| MOAT - 15 Sec In-View Impressions | NUMERIC | MOAT - 15 Sec In-View Impressions | |
| MOAT - 16 Sec In-View Impressions | NUMERIC | MOAT - 16 Sec In-View Impressions | |
| MOAT - 17 Sec In-View Impressions | NUMERIC | MOAT - 17 Sec In-View Impressions | |
| MOAT - 18 Sec In-View Impressions | NUMERIC | MOAT - 18 Sec In-View Impressions | |
| MOAT - 19 Sec In-View Impressions | NUMERIC | MOAT - 19 Sec In-View Impressions | |
| MOAT - 1 Sec In-View Impressions | NUMERIC | MOAT - 1 Sec In-View Impressions | |
| MOAT - 20 Sec In-View Impressions | NUMERIC | MOAT - 20 Sec In-View Impressions | |
| MOAT - 21 Sec In-View Impressions | NUMERIC | MOAT - 21 Sec In-View Impressions | |
| MOAT - 22 Sec In-View Impressions | NUMERIC | MOAT - 22 Sec In-View Impressions | |
| MOAT - 23 Sec In-View Impressions | NUMERIC | MOAT - 23 Sec In-View Impressions | |
| MOAT - 24 Sec In-View Impressions | NUMERIC | MOAT - 24 Sec In-View Impressions | |
| MOAT - 25 Sec In-View Impressions | NUMERIC | MOAT - 25 Sec In-View Impressions | |
| MOAT - 26 Sec In-View Impressions | NUMERIC | MOAT - 26 Sec In-View Impressions | |
| MOAT - 27 Sec In-View Impressions | NUMERIC | MOAT - 27 Sec In-View Impressions | |
| MOAT - 28 Sec In-View Impressions | NUMERIC | MOAT - 28 Sec In-View Impressions | |
| MOAT - 29 Sec In-View Impressions | NUMERIC | MOAT - 29 Sec In-View Impressions | |
| MOAT - 2 Sec In-View Impressions | NUMERIC | MOAT - 2 Sec In-View Impressions | |
| MOAT - 30 Sec In-View Impressions | NUMERIC | MOAT - 30 Sec In-View Impressions | |
| MOAT - 3 Sec In-View Impressions | NUMERIC | MOAT - 3 Sec In-View Impressions | |
| MOAT - 4 Sec In-View Impressions | NUMERIC | MOAT - 4 Sec In-View Impressions | |
| MOAT - 5 Sec In-View Impressions | NUMERIC | MOAT - 5 Sec In-View Impressions | |
| MOAT - 6 Sec In-View Impressions | NUMERIC | MOAT - 6 Sec In-View Impressions | |
| MOAT - 7 Sec In-View Impressions | NUMERIC | MOAT - 7 Sec In-View Impressions | |
| MOAT - 8 Sec In-View Impressions | NUMERIC | MOAT - 8 Sec In-View Impressions | |
| MOAT - 9 Sec In-View Impressions | NUMERIC | MOAT - 9 Sec In-View Impressions | |
| MOAT - Impressions Analyzed (unfiltered for IVT) | NUMERIC | MOAT - Impressions Analyzed (unfiltered for IVT) | |
| MOAT - Impressions Analyzed (filtered for IVT) | NUMERIC | MOAT - Impressions Analyzed (filtered for IVT) | |
| MOAT - Average In-View Time (ms) | NUMERIC | MOAT - Average In-View Time (ms) | |
| MOAT - Complete In-View Impressions | NUMERIC | MOAT - Complete In-View Impressions | |
| MOAT - In-View Measurable Impressions | NUMERIC | MOAT - In-View Measurable Impressions | |
| MOAT - Valid and Viewable Impressions | NUMERIC | MOAT - Valid and Viewable Impressions | |
| MOAT - Total Ad Length (ms) | NUMERIC | MOAT - Total Ad Length (ms) | |
| MOAT - Total In-View Time (ms) | NUMERIC | MOAT - Total In-View Time (ms) | |
| MOAT - Average Ad Length (ms) | NUMERIC | MOAT - Average Ad Length (ms) | |
| MOAT - Valid and Viewable % | NUMERIC | MOAT - Valid and Viewable % | |
| Month | TEXT | Month for the data (ISO8601 format containing first day in month) | |
| Creative portfolio item | TEXT | Commercial name of the creative type | |
| Post click conversions | NUMERIC | Post click conversions | |
| Post view conversions | NUMERIC | Post view conversions | |
| Line item billable event | TEXT | Billable event for the line item | |
| 1 second view | NUMERIC | 1 second view | |
| 10 second view | NUMERIC | 10 second view | |
| 11 second view | NUMERIC | 11 second view | |
| 12 second view | NUMERIC | 12 second view | |
| 13 second view | NUMERIC | 13 second view | |
| 14 second view | NUMERIC | 14 second view | |
| 15 second view | NUMERIC | 15 second view | |
| 16 second view | NUMERIC | 16 second view | |
| 17 second view | NUMERIC | 17 second view | |
| 18 second view | NUMERIC | 18 second view | |
| 19 second view | NUMERIC | 19 second view | |
| 2 second view | NUMERIC | 2 second view | |
| 20 second view | NUMERIC | 20 second view | |
| 21 second view | NUMERIC | 21 second view | |
| 22 second view | NUMERIC | 22 second view | |
| 23 second view | NUMERIC | 23 second view | |
| 24 second view | NUMERIC | 24 second view | |
| 25 second view | NUMERIC | 25 second view | |
| 26 second view | NUMERIC | 26 second view | |
| 27 second view | NUMERIC | 27 second view | |
| 28 second view | NUMERIC | 28 second view | |
| 29 second view | NUMERIC | 29 second view | |
| 3 second view | NUMERIC | 3 second view | |
| 30 second view | NUMERIC | 30 second view | |
| 4 second view | NUMERIC | 4 second view | |
| 5 second view | NUMERIC | 5 second view | |
| 6 second view | NUMERIC | 6 second view | |
| 7 second view | NUMERIC | 7 second view | |
| 8 second view | NUMERIC | 8 second view | |
| 9 second view | NUMERIC | 9 second view | |
| Total ad cost | NUMERIC | Budget spent on advertising cost. Does not include Added Value Budget, nor Ad Manager fee, nor Agency fee. | |
| Budget spent - Cost per result | NUMERIC | Average price of each result, considering the budget spent (invoiced by Teads) and the total volume delivered. | |
| Budget spent - CPC | NUMERIC | Average price of each click, considering the budget spent (invoiced by Teads) and the total volume delivered. | |
| Budget spent - CPM | NUMERIC | Average price of a thousand impressions, considering the budget spent (invoiced by Teads) and the total volume delivered. | |
| Fee | NUMERIC | Budget spent on Ad Manager fee cost | |
| Budget spent | NUMERIC | Budget spent (i.e. invoiced by Teads). Includes Ad Manager fee. Does not include Added Value budget nor Agency fee. | |
| Unique Viewers impression | NUMERIC | Estimated number of unique Teads IDs exposed to the ad. | |
| Video completes | NUMERIC | Video completes | |
| Video complete rate | NUMERIC | Video completion rate | |
| Video first quartile | NUMERIC | Video first quartile | |
| Video midpoint | NUMERIC | Video midpoint | |
| Video progress 1 second | NUMERIC | Video progress 1 second | |
| Video progress 10 second | NUMERIC | Video progress 10 second | |
| Video progress 11 second | NUMERIC | Video progress 11 second | |
| Video progress 12 second | NUMERIC | Video progress 12 second | |
| Video progress 13 second | NUMERIC | Video progress 13 second | |
| Video progress 14 second | NUMERIC | Video progress 14 second | |
| Video progress 15 second | NUMERIC | Video progress 15 second | |
| Video progress 16 second | NUMERIC | Video progress 16 second | |
| Video progress 17 second | NUMERIC | Video progress 17 second | |
| Video progress 18 second | NUMERIC | Video progress 18 second | |
| Video progress 19 second | NUMERIC | Video progress 19 second | |
| Video progress 2 second | NUMERIC | Video progress 2 second | |
| Video progress 20 second | NUMERIC | Video progress 20 second | |
| Video progress 21 second | NUMERIC | Video progress 21 second | |
| Video progress 22 second | NUMERIC | Video progress 22 second | |
| Video progress 23 second | NUMERIC | Video progress 23 second | |
| Video progress 24 second | NUMERIC | Video progress 24 second | |
| Video progress 25 second | NUMERIC | Video progress 25 second | |
| Video progress 26 second | NUMERIC | Video progress 26 second | |
| Video progress 27 second | NUMERIC | Video progress 27 second | |
| Video progress 28 second | NUMERIC | Video progress 28 second | |
| Video progress 29 second | NUMERIC | Video progress 29 second | |
| Video progress 3 second | NUMERIC | Video progress 3 second | |
| Video progress 30 second | NUMERIC | Video progress 30 second | |
| Video progress 4 second | NUMERIC | Video progress 4 second | |
| Video progress 5 second | NUMERIC | Video progress 5 second | |
| Video progress 6 second | NUMERIC | Video progress 6 second | |
| Video progress 7 second | NUMERIC | Video progress 7 second | |
| Video progress 8 second | NUMERIC | Video progress 8 second | |
| Video progress 9 second | NUMERIC | Video progress 9 second | |
| Video starts | NUMERIC | Video starts | |
| Video third quartile | NUMERIC | Video third quartile | |
| Website domain | TEXT | The domain of the website | |
| Year | TEXT | Year for the data (ISO8601 format containing first day in year) |