Windsor brings all your Teads data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL

Teads Field Reference

Sample

The Teads connector fetches Teads data. All fields can be queried together with the exception of uv_impressions, which can only be queried in combination with selected dimensions and metrics. More information on the compatibility of fields here.

Sample URL:

https://connectors.windsor.ai/teads?api_key=<APIKEY>&date_preset=last_7d&fields=ad_id,ad_owner_id,ad_owner_name,advertiser_billable_volume,advertiser_id,advertiser_name,auction_has_advertiser_billable,browser,browser_version,budget_delivered_advertising_average_cost_per_result_value,budget_delivered_advertising_average_cpc_value,budget_delivered_advertising_average_cpm_value,budget_delivered_advertising_value,budget_delivered_agency_fee_value,budget_delivered_average_cost_per_result_value,budget_delivered_average_cpc_value,budget_delivered_average_cpm_value,budget_delivered_platform_fee_value,budget_delivered_teads_average_cost_per_result_value,budget_delivered_teads_average_cpc_value,budget_delivered_teads_average_cpm_value,budget_delivered_teads_value,budget_delivered_value,campaign_budget,campaign_name,click_rate,clicks,country_code,country_name,creative_external_integration_code,creative_id,creative_name,creative_size,creative_type,date,day,device,display_progress_1,display_progress_10,display_progress_11,display_progress_12,display_progress_13,display_progress_14,display_progress_15,display_progress_16,display_progress_17,display_progress_18,display_progress_19,display_progress_2,display_progress_20,display_progress_21,display_progress_22,display_progress_23,display_progress_24,display_progress_25,display_progress_26,display_progress_27,display_progress_28,display_progress_29,display_progress_3,display_progress_30,display_progress_4,display_progress_5,display_progress_6,display_progress_7,display_progress_8,display_progress_9,format_creative_type_family_name,hour,impressions,io_currency,io_line_budget,io_line_id,line_item_name,moat_10s_inview_impression,moat_11s_inview_impression,moat_12s_inview_impression,moat_13s_inview_impression,moat_14s_inview_impression,moat_15s_inview_impression,moat_16s_inview_impression,moat_17s_inview_impression,moat_18s_inview_impression,moat_19s_inview_impression,moat_1s_inview_impression,moat_20s_inview_impression,moat_21s_inview_impression,moat_22s_inview_impression,moat_23s_inview_impression,moat_24s_inview_impression,moat_25s_inview_impression,moat_26s_inview_impression,moat_27s_inview_impression,moat_28s_inview_impression,moat_29s_inview_impression,moat_2s_inview_impression,moat_30s_inview_impression,moat_3s_inview_impression,moat_4s_inview_impression,moat_5s_inview_impression,moat_6s_inview_impression,moat_7s_inview_impression,moat_8s_inview_impression,moat_9s_inview_impression,moat_analyzed_impression,moat_analyzed_impression_filtered,moat_average_inview_time,moat_complete_inview_impression,moat_inview_measurable_impression,moat_inview_viewable_impression,moat_total_ad_length,moat_total_inview_time,moat_video_average_ad_length,moat_viewable_rate,month,portfolio_item_name,post_click_conversion,post_view_conversion,price_advertiser_event,progress_1,progress_10,progress_11,progress_12,progress_13,progress_14,progress_15,progress_16,progress_17,progress_18,progress_19,progress_2,progress_20,progress_21,progress_22,progress_23,progress_24,progress_25,progress_26,progress_27,progress_28,progress_29,progress_3,progress_30,progress_4,progress_5,progress_6,progress_7,progress_8,progress_9,turnover_advertising_value,turnover_average_cost_per_result_value,turnover_average_cpc_value,turnover_average_cpm_value,turnover_fee_value,turnover_value,video_complete,video_complete_rate,video_first_quartile,video_midpoint,video_progress_1,video_progress_10,video_progress_11,video_progress_12,video_progress_13,video_progress_14,video_progress_15,video_progress_16,video_progress_17,video_progress_18,video_progress_19,video_progress_2,video_progress_20,video_progress_21,video_progress_22,video_progress_23,video_progress_24,video_progress_25,video_progress_26,video_progress_27,video_progress_28,video_progress_29,video_progress_3,video_progress_30,video_progress_4,video_progress_5,video_progress_6,video_progress_7,video_progress_8,video_progress_9,video_start,video_third_quartile,website_domain,year,</blockquote


Fields

IDTypeNameDescription
ad_idTEXTCampaign IDTeads id of the campaign
ad_owner_idTEXTSeat idTeads Ad Manager Seat id
ad_owner_nameTEXTSeat nameTeads Ad Manager Seat name
advertiser_billable_volumeNUMERICBillable impressionsNumber of results delivered
advertiser_idTEXTAdvertiser IDTeads id of the advertiser
advertiser_nameTEXTAdvertiserName of the advertiser
auction_has_advertiser_billableTEXTAuction has billableAuction 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.
browserTEXTBrowserName of browser
browser_versionTEXTBrowser versionVersion of browser
budget_delivered_advertising_average_cost_per_result_valueNUMERICBudget delivered Total Ad Cost - Cost per resultAverage price of each result, based on the budget_delivered_advertising. This is the cost per result considering only the advertising cost.
budget_delivered_advertising_average_cpc_valueNUMERICBudget delivered Total Ad Cost - CPCAverage price of a click, based on the budget_delivered_advertising. This is the CPC value considering only the advertising cost.
budget_delivered_advertising_average_cpm_valueNUMERICBudget delivered Total Ad Cost - CPMAverage 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_advertising_valueNUMERICBudget delivered Total Ad CostAdvertising value (media & data) delivered by Teads. Includes Added Value budget. Does not include Ad Manager fee nor Agency fee.
budget_delivered_agency_fee_valueNUMERICBudget delivered Agency FeeAgency fee. Not invoiced by Teads.
budget_delivered_average_cost_per_result_valueNUMERICBudget delivered - Cost per resultAverage 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_average_cpc_valueNUMERICBudget delivered - CPCAverage 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_average_cpm_valueNUMERICBudget delivered - CPMAverage 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_platform_fee_valueNUMERICBudget delivered FeeAd Manager fee
budget_delivered_teads_average_cost_per_result_valueNUMERICBudget delivered Teads - Cost per resultAverage 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_average_cpc_valueNUMERICBudget delivered Teads - CPCAverage 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_average_cpm_valueNUMERICBudget delivered Teads - CPMAverage 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_valueNUMERICBudget delivered TeadsTotal value delivered by Teads. Includes Added Value budget and Ad Manager fee. Does not include Agency fee.
budget_delivered_valueNUMERICBudget deliveredAdvertiser budget consumed. Includes Added Value budget, Ad Manager fee and Agency fee.
campaign_io_budgetTEXTCampaign IO budgetTotal budget of the campaign
campaign_nameTEXTCampaign NameName of the campaign
click_ratePERCENTClickthrough rateClickthrough rate
clicksNUMERICClicksClicks
country_codeCOUNTRYCountry codeCountry code of the user - ISO 3166-1 alpha-2 format, ex: US, FR
country_nameCOUNTRYCountry nameCountry name of the user
creative_external_integration_codeTEXTCreative external integration codeCode for integrating with another reporting system
creative_idTEXTCreative IDTeads id of the creative
creative_nameTEXTCreative nameName of the creative
creative_sizeTEXTCreative sizeCreative size. Possible values: landscape, square, vertical, social.
creative_typeTEXTCreative typeCreative type (Carousel, Scroller, etc)
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateAlias for Day but in %Y-%m-%d format.
dayTEXTDayDay for the data
day_of_monthTEXTDay of monthDay of the month
deviceTEXTDeviceDevice. Possible values: Desktop, SmartTV, Smartphone, Tablet.
display_progress_1NUMERICDisplay 1 second viewDisplay 1 second view
display_progress_10NUMERICDisplay 10 second viewDisplay 10 second view
display_progress_11NUMERICDisplay 11 second viewDisplay 11 second view
display_progress_12NUMERICDisplay 12 second viewDisplay 12 second view
display_progress_13NUMERICDisplay 13 second viewDisplay 13 second view
display_progress_14NUMERICDisplay 14 second viewDisplay 14 second view
display_progress_15NUMERICDisplay 15 second viewDisplay 15 second view
display_progress_16NUMERICDisplay 16 second viewDisplay 16 second view
display_progress_17NUMERICDisplay 17 second viewDisplay 17 second view
display_progress_18NUMERICDisplay 18 second viewDisplay 18 second view
display_progress_19NUMERICDisplay 19 second viewDisplay 19 second view
display_progress_2NUMERICDisplay 2 second viewDisplay 2 second view
display_progress_20NUMERICDisplay 20 second viewDisplay 20 second view
display_progress_21NUMERICDisplay 21 second viewDisplay 21 second view
display_progress_22NUMERICDisplay 22 second viewDisplay 22 second view
display_progress_23NUMERICDisplay 23 second viewDisplay 23 second view
display_progress_24NUMERICDisplay 24 second viewDisplay 24 second view
display_progress_25NUMERICDisplay 25 second viewDisplay 25 second view
display_progress_26NUMERICDisplay 26 second viewDisplay 26 second view
display_progress_27NUMERICDisplay 27 second viewDisplay 27 second view
display_progress_28NUMERICDisplay 28 second viewDisplay 28 second view
display_progress_29NUMERICDisplay 29 second viewDisplay 29 second view
display_progress_3NUMERICDisplay 3 second viewDisplay 3 second view
display_progress_30NUMERICDisplay 30 second viewDisplay 30 second view
display_progress_4NUMERICDisplay 4 second viewDisplay 4 second view
display_progress_5NUMERICDisplay 5 second viewDisplay 5 second view
display_progress_6NUMERICDisplay 6 second viewDisplay 6 second view
display_progress_7NUMERICDisplay 7 second viewDisplay 7 second view
display_progress_8NUMERICDisplay 8 second viewDisplay 8 second view
display_progress_9NUMERICDisplay 9 second viewDisplay 9 second view
format_creative_type_family_nameTEXTCreative familyCreative family (Video, Viewable Display, etc)
hourTEXTHourHour for the data
impressionsNUMERICImpressionsImpressions
io_currencyTEXTCampaign currencyCurrency of the campaign
io_line_budgetTEXTLine item budgetBudget of the line item
io_line_idTEXTLine item IDTeads id of the line item
line_item_nameTEXTLine item nameName of the line item
moat_10s_inview_impressionNUMERICMOAT - 10 Sec In-View ImpressionsMOAT - 10 Sec In-View Impressions
moat_11s_inview_impressionNUMERICMOAT - 11 Sec In-View ImpressionsMOAT - 11 Sec In-View Impressions
moat_12s_inview_impressionNUMERICMOAT - 12 Sec In-View ImpressionsMOAT - 12 Sec In-View Impressions
moat_13s_inview_impressionNUMERICMOAT - 13 Sec In-View ImpressionsMOAT - 13 Sec In-View Impressions
moat_14s_inview_impressionNUMERICMOAT - 14 Sec In-View ImpressionsMOAT - 14 Sec In-View Impressions
moat_15s_inview_impressionNUMERICMOAT - 15 Sec In-View ImpressionsMOAT - 15 Sec In-View Impressions
moat_16s_inview_impressionNUMERICMOAT - 16 Sec In-View ImpressionsMOAT - 16 Sec In-View Impressions
moat_17s_inview_impressionNUMERICMOAT - 17 Sec In-View ImpressionsMOAT - 17 Sec In-View Impressions
moat_18s_inview_impressionNUMERICMOAT - 18 Sec In-View ImpressionsMOAT - 18 Sec In-View Impressions
moat_19s_inview_impressionNUMERICMOAT - 19 Sec In-View ImpressionsMOAT - 19 Sec In-View Impressions
moat_1s_inview_impressionNUMERICMOAT - 1 Sec In-View ImpressionsMOAT - 1 Sec In-View Impressions
moat_20s_inview_impressionNUMERICMOAT - 20 Sec In-View ImpressionsMOAT - 20 Sec In-View Impressions
moat_21s_inview_impressionNUMERICMOAT - 21 Sec In-View ImpressionsMOAT - 21 Sec In-View Impressions
moat_22s_inview_impressionNUMERICMOAT - 22 Sec In-View ImpressionsMOAT - 22 Sec In-View Impressions
moat_23s_inview_impressionNUMERICMOAT - 23 Sec In-View ImpressionsMOAT - 23 Sec In-View Impressions
moat_24s_inview_impressionNUMERICMOAT - 24 Sec In-View ImpressionsMOAT - 24 Sec In-View Impressions
moat_25s_inview_impressionNUMERICMOAT - 25 Sec In-View ImpressionsMOAT - 25 Sec In-View Impressions
moat_26s_inview_impressionNUMERICMOAT - 26 Sec In-View ImpressionsMOAT - 26 Sec In-View Impressions
moat_27s_inview_impressionNUMERICMOAT - 27 Sec In-View ImpressionsMOAT - 27 Sec In-View Impressions
moat_28s_inview_impressionNUMERICMOAT - 28 Sec In-View ImpressionsMOAT - 28 Sec In-View Impressions
moat_29s_inview_impressionNUMERICMOAT - 29 Sec In-View ImpressionsMOAT - 29 Sec In-View Impressions
moat_2s_inview_impressionNUMERICMOAT - 2 Sec In-View ImpressionsMOAT - 2 Sec In-View Impressions
moat_30s_inview_impressionNUMERICMOAT - 30 Sec In-View ImpressionsMOAT - 30 Sec In-View Impressions
moat_3s_inview_impressionNUMERICMOAT - 3 Sec In-View ImpressionsMOAT - 3 Sec In-View Impressions
moat_4s_inview_impressionNUMERICMOAT - 4 Sec In-View ImpressionsMOAT - 4 Sec In-View Impressions
moat_5s_inview_impressionNUMERICMOAT - 5 Sec In-View ImpressionsMOAT - 5 Sec In-View Impressions
moat_6s_inview_impressionNUMERICMOAT - 6 Sec In-View ImpressionsMOAT - 6 Sec In-View Impressions
moat_7s_inview_impressionNUMERICMOAT - 7 Sec In-View ImpressionsMOAT - 7 Sec In-View Impressions
moat_8s_inview_impressionNUMERICMOAT - 8 Sec In-View ImpressionsMOAT - 8 Sec In-View Impressions
moat_9s_inview_impressionNUMERICMOAT - 9 Sec In-View ImpressionsMOAT - 9 Sec In-View Impressions
moat_analyzed_impressionNUMERICMOAT - Impressions Analyzed (unfiltered for IVT)MOAT - Impressions Analyzed (unfiltered for IVT)
moat_analyzed_impression_filteredNUMERICMOAT - Impressions Analyzed (filtered for IVT)MOAT - Impressions Analyzed (filtered for IVT)
moat_average_inview_timeNUMERICMOAT - Average In-View Time (ms)MOAT - Average In-View Time (ms)
moat_complete_inview_impressionNUMERICMOAT - Complete In-View ImpressionsMOAT - Complete In-View Impressions
moat_inview_measurable_impressionNUMERICMOAT - In-View Measurable ImpressionsMOAT - In-View Measurable Impressions
moat_inview_viewable_impressionNUMERICMOAT - Valid and Viewable ImpressionsMOAT - Valid and Viewable Impressions
moat_total_ad_lengthNUMERICMOAT - Total Ad Length (ms)MOAT - Total Ad Length (ms)
moat_total_inview_timeNUMERICMOAT - Total In-View Time (ms)MOAT - Total In-View Time (ms)
moat_video_average_ad_lengthNUMERICMOAT - Average Ad Length (ms)MOAT - Average Ad Length (ms)
moat_viewable_rateNUMERICMOAT - Valid and Viewable %MOAT - Valid and Viewable %
monthTEXTMonthMonth for the data (ISO8601 format containing first day in month)
portfolio_item_nameTEXTCreative portfolio itemCommercial name of the creative type
post_click_conversionNUMERICPost click conversionsPost click conversions
post_view_conversionNUMERICPost view conversionsPost view conversions
price_advertiser_eventTEXTLine item billable eventBillable event for the line item
progress_1NUMERIC1 second view1 second view
progress_10NUMERIC10 second view10 second view
progress_11NUMERIC11 second view11 second view
progress_12NUMERIC12 second view12 second view
progress_13NUMERIC13 second view13 second view
progress_14NUMERIC14 second view14 second view
progress_15NUMERIC15 second view15 second view
progress_16NUMERIC16 second view16 second view
progress_17NUMERIC17 second view17 second view
progress_18NUMERIC18 second view18 second view
progress_19NUMERIC19 second view19 second view
progress_2NUMERIC2 second view2 second view
progress_20NUMERIC20 second view20 second view
progress_21NUMERIC21 second view21 second view
progress_22NUMERIC22 second view22 second view
progress_23NUMERIC23 second view23 second view
progress_24NUMERIC24 second view24 second view
progress_25NUMERIC25 second view25 second view
progress_26NUMERIC26 second view26 second view
progress_27NUMERIC27 second view27 second view
progress_28NUMERIC28 second view28 second view
progress_29NUMERIC29 second view29 second view
progress_3NUMERIC3 second view3 second view
progress_30NUMERIC30 second view30 second view
progress_4NUMERIC4 second view4 second view
progress_5NUMERIC5 second view5 second view
progress_6NUMERIC6 second view6 second view
progress_7NUMERIC7 second view7 second view
progress_8NUMERIC8 second view8 second view
progress_9NUMERIC9 second view9 second view
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
turnover_advertising_valueNUMERICTotal ad costBudget spent on advertising cost. Does not include Added Value Budget, nor Ad Manager fee, nor Agency fee.
turnover_average_cost_per_result_valueNUMERICBudget spent - Cost per resultAverage price of each result, considering the budget spent (invoiced by Teads) and the total volume delivered.
turnover_average_cpc_valueNUMERICBudget spent - CPCAverage price of each click, considering the budget spent (invoiced by Teads) and the total volume delivered.
turnover_average_cpm_valueNUMERICBudget spent - CPMAverage price of a thousand impressions, considering the budget spent (invoiced by Teads) and the total volume delivered.
turnover_fee_valueNUMERICFeeBudget spent on Ad Manager fee cost
turnover_valueNUMERICBudget spentBudget spent (i.e. invoiced by Teads). Includes Ad Manager fee. Does not include Added Value budget nor Agency fee.
uv_impressionsNUMERICUnique Viewers impressionEstimated number of unique Teads IDs exposed to the ad.
video_completeNUMERICVideo completesVideo completes
video_complete_rateNUMERICVideo complete rateVideo completion rate
video_first_quartileNUMERICVideo first quartileVideo first quartile
video_midpointNUMERICVideo midpointVideo midpoint
video_progress_1NUMERICVideo progress 1 secondVideo progress 1 second
video_progress_10NUMERICVideo progress 10 secondVideo progress 10 second
video_progress_11NUMERICVideo progress 11 secondVideo progress 11 second
video_progress_12NUMERICVideo progress 12 secondVideo progress 12 second
video_progress_13NUMERICVideo progress 13 secondVideo progress 13 second
video_progress_14NUMERICVideo progress 14 secondVideo progress 14 second
video_progress_15NUMERICVideo progress 15 secondVideo progress 15 second
video_progress_16NUMERICVideo progress 16 secondVideo progress 16 second
video_progress_17NUMERICVideo progress 17 secondVideo progress 17 second
video_progress_18NUMERICVideo progress 18 secondVideo progress 18 second
video_progress_19NUMERICVideo progress 19 secondVideo progress 19 second
video_progress_2NUMERICVideo progress 2 secondVideo progress 2 second
video_progress_20NUMERICVideo progress 20 secondVideo progress 20 second
video_progress_21NUMERICVideo progress 21 secondVideo progress 21 second
video_progress_22NUMERICVideo progress 22 secondVideo progress 22 second
video_progress_23NUMERICVideo progress 23 secondVideo progress 23 second
video_progress_24NUMERICVideo progress 24 secondVideo progress 24 second
video_progress_25NUMERICVideo progress 25 secondVideo progress 25 second
video_progress_26NUMERICVideo progress 26 secondVideo progress 26 second
video_progress_27NUMERICVideo progress 27 secondVideo progress 27 second
video_progress_28NUMERICVideo progress 28 secondVideo progress 28 second
video_progress_29NUMERICVideo progress 29 secondVideo progress 29 second
video_progress_3NUMERICVideo progress 3 secondVideo progress 3 second
video_progress_30NUMERICVideo progress 30 secondVideo progress 30 second
video_progress_4NUMERICVideo progress 4 secondVideo progress 4 second
video_progress_5NUMERICVideo progress 5 secondVideo progress 5 second
video_progress_6NUMERICVideo progress 6 secondVideo progress 6 second
video_progress_7NUMERICVideo progress 7 secondVideo progress 7 second
video_progress_8NUMERICVideo progress 8 secondVideo progress 8 second
video_progress_9NUMERICVideo progress 9 secondVideo progress 9 second
video_startNUMERICVideo startsVideo starts
video_third_quartileNUMERICVideo third quartileVideo third quartile
website_domainTEXTWebsite domainThe domain of the website
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear for the data (ISO8601 format containing first day in year)
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20