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.

Available Metrics and Dimensions

NameTypeDescription
Campaign IDTEXTTeads id of the campaign
Seat idTEXTTeads Ad Manager Seat id
Seat nameTEXTTeads Ad Manager Seat name
Billable impressionsNUMERICNumber of results delivered
Advertiser IDTEXTTeads id of the advertiser
AdvertiserTEXTName of the advertiser
Auction has billableTEXTAuction 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.
BrowserTEXTName of browser
Browser versionTEXTVersion of browser
Budget delivered Total Ad Cost - Cost per resultNUMERICAverage 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 - CPCNUMERICAverage 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 - CPMNUMERICAverage 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 CostNUMERICAdvertising value (media & data) delivered by Teads. Includes Added Value budget. Does not include Ad Manager fee nor Agency fee.
Budget delivered Agency FeeNUMERICAgency fee. Not invoiced by Teads.
Budget delivered - Cost per resultNUMERICAverage 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 - CPCNUMERICAverage 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 - CPMNUMERICAverage 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 FeeNUMERICAd Manager fee
Budget delivered Teads - Cost per resultNUMERICAverage 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 - CPCNUMERICAverage 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 - CPMNUMERICAverage 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 TeadsNUMERICTotal value delivered by Teads. Includes Added Value budget and Ad Manager fee. Does not include Agency fee.
Budget deliveredNUMERICAdvertiser budget consumed. Includes Added Value budget, Ad Manager fee and Agency fee.
Campaign IO budgetTEXTTotal budget of the campaign
Campaign nameTEXTName of the campaign
Clickthrough rateNUMERICClickthrough rate
ClicksNUMERICClicks
Country codeTEXTCountry code of the user - ISO 3166-1 alpha-2 format, ex: US, FR
Country nameTEXTCountry name of the user
Creative external integration codeTEXTCode for integrating with another reporting system
Creative IDTEXTTeads id of the creative
Creative nameTEXTName of the creative
Creative sizeTEXTCreative size. Possible values: landscape, square, vertical, social.
Creative typeTEXTCreative type (Carousel, Scroller, etc)
DateDATEAlias for Day but in %Y-%m-%d format.
DayTEXTDay for the data
DeviceTEXTDevice. Possible values: Desktop, SmartTV, Smartphone, Tablet.
Display 1 second viewNUMERICDisplay 1 second view
Display 10 second viewNUMERICDisplay 10 second view
Display 11 second viewNUMERICDisplay 11 second view
Display 12 second viewNUMERICDisplay 12 second view
Display 13 second viewNUMERICDisplay 13 second view
Display 14 second viewNUMERICDisplay 14 second view
Display 15 second viewNUMERICDisplay 15 second view
Display 16 second viewNUMERICDisplay 16 second view
Display 17 second viewNUMERICDisplay 17 second view
Display 18 second viewNUMERICDisplay 18 second view
Display 19 second viewNUMERICDisplay 19 second view
Display 2 second viewNUMERICDisplay 2 second view
Display 20 second viewNUMERICDisplay 20 second view
Display 21 second viewNUMERICDisplay 21 second view
Display 22 second viewNUMERICDisplay 22 second view
Display 23 second viewNUMERICDisplay 23 second view
Display 24 second viewNUMERICDisplay 24 second view
Display 25 second viewNUMERICDisplay 25 second view
Display 26 second viewNUMERICDisplay 26 second view
Display 27 second viewNUMERICDisplay 27 second view
Display 28 second viewNUMERICDisplay 28 second view
Display 29 second viewNUMERICDisplay 29 second view
Display 3 second viewNUMERICDisplay 3 second view
Display 30 second viewNUMERICDisplay 30 second view
Display 4 second viewNUMERICDisplay 4 second view
Display 5 second viewNUMERICDisplay 5 second view
Display 6 second viewNUMERICDisplay 6 second view
Display 7 second viewNUMERICDisplay 7 second view
Display 8 second viewNUMERICDisplay 8 second view
Display 9 second viewNUMERICDisplay 9 second view
Creative familyTEXTCreative family (Video, Viewable Display, etc)
HourTEXTHour for the data
ImpressionsNUMERICImpressions
Campaign currencyTEXTCurrency of the campaign
Line item budgetTEXTBudget of the line item
Line item IDTEXTTeads id of the line item
Line item nameTEXTName of the line item
MOAT - 10 Sec In-View ImpressionsNUMERICMOAT - 10 Sec In-View Impressions
MOAT - 11 Sec In-View ImpressionsNUMERICMOAT - 11 Sec In-View Impressions
MOAT - 12 Sec In-View ImpressionsNUMERICMOAT - 12 Sec In-View Impressions
MOAT - 13 Sec In-View ImpressionsNUMERICMOAT - 13 Sec In-View Impressions
MOAT - 14 Sec In-View ImpressionsNUMERICMOAT - 14 Sec In-View Impressions
MOAT - 15 Sec In-View ImpressionsNUMERICMOAT - 15 Sec In-View Impressions
MOAT - 16 Sec In-View ImpressionsNUMERICMOAT - 16 Sec In-View Impressions
MOAT - 17 Sec In-View ImpressionsNUMERICMOAT - 17 Sec In-View Impressions
MOAT - 18 Sec In-View ImpressionsNUMERICMOAT - 18 Sec In-View Impressions
MOAT - 19 Sec In-View ImpressionsNUMERICMOAT - 19 Sec In-View Impressions
MOAT - 1 Sec In-View ImpressionsNUMERICMOAT - 1 Sec In-View Impressions
MOAT - 20 Sec In-View ImpressionsNUMERICMOAT - 20 Sec In-View Impressions
MOAT - 21 Sec In-View ImpressionsNUMERICMOAT - 21 Sec In-View Impressions
MOAT - 22 Sec In-View ImpressionsNUMERICMOAT - 22 Sec In-View Impressions
MOAT - 23 Sec In-View ImpressionsNUMERICMOAT - 23 Sec In-View Impressions
MOAT - 24 Sec In-View ImpressionsNUMERICMOAT - 24 Sec In-View Impressions
MOAT - 25 Sec In-View ImpressionsNUMERICMOAT - 25 Sec In-View Impressions
MOAT - 26 Sec In-View ImpressionsNUMERICMOAT - 26 Sec In-View Impressions
MOAT - 27 Sec In-View ImpressionsNUMERICMOAT - 27 Sec In-View Impressions
MOAT - 28 Sec In-View ImpressionsNUMERICMOAT - 28 Sec In-View Impressions
MOAT - 29 Sec In-View ImpressionsNUMERICMOAT - 29 Sec In-View Impressions
MOAT - 2 Sec In-View ImpressionsNUMERICMOAT - 2 Sec In-View Impressions
MOAT - 30 Sec In-View ImpressionsNUMERICMOAT - 30 Sec In-View Impressions
MOAT - 3 Sec In-View ImpressionsNUMERICMOAT - 3 Sec In-View Impressions
MOAT - 4 Sec In-View ImpressionsNUMERICMOAT - 4 Sec In-View Impressions
MOAT - 5 Sec In-View ImpressionsNUMERICMOAT - 5 Sec In-View Impressions
MOAT - 6 Sec In-View ImpressionsNUMERICMOAT - 6 Sec In-View Impressions
MOAT - 7 Sec In-View ImpressionsNUMERICMOAT - 7 Sec In-View Impressions
MOAT - 8 Sec In-View ImpressionsNUMERICMOAT - 8 Sec In-View Impressions
MOAT - 9 Sec In-View ImpressionsNUMERICMOAT - 9 Sec In-View Impressions
MOAT - Impressions Analyzed (unfiltered for IVT)NUMERICMOAT - Impressions Analyzed (unfiltered for IVT)
MOAT - Impressions Analyzed (filtered for IVT)NUMERICMOAT - Impressions Analyzed (filtered for IVT)
MOAT - Average In-View Time (ms)NUMERICMOAT - Average In-View Time (ms)
MOAT - Complete In-View ImpressionsNUMERICMOAT - Complete In-View Impressions
MOAT - In-View Measurable ImpressionsNUMERICMOAT - In-View Measurable Impressions
MOAT - Valid and Viewable ImpressionsNUMERICMOAT - Valid and Viewable Impressions
MOAT - Total Ad Length (ms)NUMERICMOAT - Total Ad Length (ms)
MOAT - Total In-View Time (ms)NUMERICMOAT - Total In-View Time (ms)
MOAT - Average Ad Length (ms)NUMERICMOAT - Average Ad Length (ms)
MOAT - Valid and Viewable %NUMERICMOAT - Valid and Viewable %
MonthTEXTMonth for the data (ISO8601 format containing first day in month)
Creative portfolio itemTEXTCommercial name of the creative type
Post click conversionsNUMERICPost click conversions
Post view conversionsNUMERICPost view conversions
Line item billable eventTEXTBillable event for the line item
1 second viewNUMERIC1 second view
10 second viewNUMERIC10 second view
11 second viewNUMERIC11 second view
12 second viewNUMERIC12 second view
13 second viewNUMERIC13 second view
14 second viewNUMERIC14 second view
15 second viewNUMERIC15 second view
16 second viewNUMERIC16 second view
17 second viewNUMERIC17 second view
18 second viewNUMERIC18 second view
19 second viewNUMERIC19 second view
2 second viewNUMERIC2 second view
20 second viewNUMERIC20 second view
21 second viewNUMERIC21 second view
22 second viewNUMERIC22 second view
23 second viewNUMERIC23 second view
24 second viewNUMERIC24 second view
25 second viewNUMERIC25 second view
26 second viewNUMERIC26 second view
27 second viewNUMERIC27 second view
28 second viewNUMERIC28 second view
29 second viewNUMERIC29 second view
3 second viewNUMERIC3 second view
30 second viewNUMERIC30 second view
4 second viewNUMERIC4 second view
5 second viewNUMERIC5 second view
6 second viewNUMERIC6 second view
7 second viewNUMERIC7 second view
8 second viewNUMERIC8 second view
9 second viewNUMERIC9 second view
Total ad costNUMERICBudget spent on advertising cost. Does not include Added Value Budget, nor Ad Manager fee, nor Agency fee.
Budget spent - Cost per resultNUMERICAverage price of each result, considering the budget spent (invoiced by Teads) and the total volume delivered.
Budget spent - CPCNUMERICAverage price of each click, considering the budget spent (invoiced by Teads) and the total volume delivered.
Budget spent - CPMNUMERICAverage price of a thousand impressions, considering the budget spent (invoiced by Teads) and the total volume delivered.
FeeNUMERICBudget spent on Ad Manager fee cost
Budget spentNUMERICBudget spent (i.e. invoiced by Teads). Includes Ad Manager fee. Does not include Added Value budget nor Agency fee.
Unique Viewers impressionNUMERICEstimated number of unique Teads IDs exposed to the ad.
Video completesNUMERICVideo completes
Video complete rateNUMERICVideo completion rate
Video first quartileNUMERICVideo first quartile
Video midpointNUMERICVideo midpoint
Video progress 1 secondNUMERICVideo progress 1 second
Video progress 10 secondNUMERICVideo progress 10 second
Video progress 11 secondNUMERICVideo progress 11 second
Video progress 12 secondNUMERICVideo progress 12 second
Video progress 13 secondNUMERICVideo progress 13 second
Video progress 14 secondNUMERICVideo progress 14 second
Video progress 15 secondNUMERICVideo progress 15 second
Video progress 16 secondNUMERICVideo progress 16 second
Video progress 17 secondNUMERICVideo progress 17 second
Video progress 18 secondNUMERICVideo progress 18 second
Video progress 19 secondNUMERICVideo progress 19 second
Video progress 2 secondNUMERICVideo progress 2 second
Video progress 20 secondNUMERICVideo progress 20 second
Video progress 21 secondNUMERICVideo progress 21 second
Video progress 22 secondNUMERICVideo progress 22 second
Video progress 23 secondNUMERICVideo progress 23 second
Video progress 24 secondNUMERICVideo progress 24 second
Video progress 25 secondNUMERICVideo progress 25 second
Video progress 26 secondNUMERICVideo progress 26 second
Video progress 27 secondNUMERICVideo progress 27 second
Video progress 28 secondNUMERICVideo progress 28 second
Video progress 29 secondNUMERICVideo progress 29 second
Video progress 3 secondNUMERICVideo progress 3 second
Video progress 30 secondNUMERICVideo progress 30 second
Video progress 4 secondNUMERICVideo progress 4 second
Video progress 5 secondNUMERICVideo progress 5 second
Video progress 6 secondNUMERICVideo progress 6 second
Video progress 7 secondNUMERICVideo progress 7 second
Video progress 8 secondNUMERICVideo progress 8 second
Video progress 9 secondNUMERICVideo progress 9 second
Video startsNUMERICVideo starts
Video third quartileNUMERICVideo third quartile
Website domainTEXTThe domain of the website
YearTEXTYear for the data (ISO8601 format containing first day in year)