Teads Connector Reference

163 metrics49 dimensions

Fields

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

The Teads connector exposes 212 fields (163 metrics, 49 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Teads Fields

The Teads connector includes 212 fields.

Teads fields (ad_id to device)

ID	Type	Name	Description
ad_id	TEXT	Campaign ID	Teads id of the campaign
ad_owner_id	TEXT	Seat id	Teads Ad Manager Seat id
ad_owner_name	TEXT	Seat name	Teads Ad Manager Seat name
advertiser_billable_volume	NUMERIC	Billable impressions	Number of results delivered
advertiser_id	TEXT	Advertiser ID	Teads id of the advertiser
advertiser_name	TEXT	Advertiser	Name of the advertiser
auction_has_advertiser_billable	TEXT	Auction has billable	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	Browser	Name of browser
browser_version	TEXT	Browser version	Version of browser
budget_delivered_advertising_average_cost_per_result_value	NUMERIC	Budget delivered Total Ad Cost - Cost per result	Average 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_value	NUMERIC	Budget delivered Total Ad Cost - CPC	Average 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_value	NUMERIC	Budget delivered Total Ad Cost - CPM	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_advertising_value	NUMERIC	Budget delivered Total Ad Cost	Advertising value (media & data) delivered by Teads. Includes Added Value budget. Does not include Ad Manager fee nor Agency fee.
budget_delivered_agency_fee_value	NUMERIC	Budget delivered Agency Fee	Agency fee. Not invoiced by Teads.
budget_delivered_average_cost_per_result_value	NUMERIC	Budget delivered - Cost per result	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_average_cpc_value	NUMERIC	Budget delivered - CPC	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_average_cpm_value	NUMERIC	Budget delivered - CPM	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_platform_fee_value	NUMERIC	Budget delivered Fee	Ad Manager fee
budget_delivered_teads_average_cost_per_result_value	NUMERIC	Budget delivered Teads - Cost per result	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_average_cpc_value	NUMERIC	Budget delivered Teads - CPC	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_average_cpm_value	NUMERIC	Budget delivered Teads - CPM	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_value	NUMERIC	Budget delivered Teads	Total value delivered by Teads. Includes Added Value budget and Ad Manager fee. Does not include Agency fee.
budget_delivered_value	NUMERIC	Budget delivered	Advertiser budget consumed. Includes Added Value budget, Ad Manager fee and Agency fee.
campaign_io_budget	TEXT	Campaign IO budget	Total budget of the campaign
campaign_name	TEXT	Campaign Name	Name of the campaign
click_rate	PERCENT	Clickthrough rate	Clickthrough rate
clicks	NUMERIC	Clicks	Clicks
country_code	COUNTRY	Country code	Country code of the user - ISO 3166-1 alpha-2 format, ex: US, FR
country_name	COUNTRY	Country name	Country name of the user
creative_external_integration_code	TEXT	Creative external integration code	Code for integrating with another reporting system
creative_id	TEXT	Creative ID	Teads id of the creative
creative_name	TEXT	Creative name	Name of the creative
creative_size	TEXT	Creative size	Creative size. Possible values: landscape, square, vertical, social.
creative_type	TEXT	Creative type	Creative type (Carousel, Scroller, etc)
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	Alias for Day but in %Y-%m-%d format.
day	TEXT	Day	Day for the data
day_of_month	TEXT	Day of month	Day of the month
device	TEXT	Device	Device. Possible values: Desktop, SmartTV, Smartphone, Tablet.

Teads fields (display_progress_1 to moat_10s_inview_impression)

ID	Type	Name	Description
display_progress_1	NUMERIC	Display 1 second view	Display 1 second view
display_progress_10	NUMERIC	Display 10 second view	Display 10 second view
display_progress_11	NUMERIC	Display 11 second view	Display 11 second view
display_progress_12	NUMERIC	Display 12 second view	Display 12 second view
display_progress_13	NUMERIC	Display 13 second view	Display 13 second view
display_progress_14	NUMERIC	Display 14 second view	Display 14 second view
display_progress_15	NUMERIC	Display 15 second view	Display 15 second view
display_progress_16	NUMERIC	Display 16 second view	Display 16 second view
display_progress_17	NUMERIC	Display 17 second view	Display 17 second view
display_progress_18	NUMERIC	Display 18 second view	Display 18 second view
display_progress_19	NUMERIC	Display 19 second view	Display 19 second view
display_progress_2	NUMERIC	Display 2 second view	Display 2 second view
display_progress_20	NUMERIC	Display 20 second view	Display 20 second view
display_progress_21	NUMERIC	Display 21 second view	Display 21 second view
display_progress_22	NUMERIC	Display 22 second view	Display 22 second view
display_progress_23	NUMERIC	Display 23 second view	Display 23 second view
display_progress_24	NUMERIC	Display 24 second view	Display 24 second view
display_progress_25	NUMERIC	Display 25 second view	Display 25 second view
display_progress_26	NUMERIC	Display 26 second view	Display 26 second view
display_progress_27	NUMERIC	Display 27 second view	Display 27 second view
display_progress_28	NUMERIC	Display 28 second view	Display 28 second view
display_progress_29	NUMERIC	Display 29 second view	Display 29 second view
display_progress_3	NUMERIC	Display 3 second view	Display 3 second view
display_progress_30	NUMERIC	Display 30 second view	Display 30 second view
display_progress_4	NUMERIC	Display 4 second view	Display 4 second view
display_progress_5	NUMERIC	Display 5 second view	Display 5 second view
display_progress_6	NUMERIC	Display 6 second view	Display 6 second view
display_progress_7	NUMERIC	Display 7 second view	Display 7 second view
display_progress_8	NUMERIC	Display 8 second view	Display 8 second view
display_progress_9	NUMERIC	Display 9 second view	Display 9 second view
format_creative_type_family_name	TEXT	Creative family	Creative family (Video, Viewable Display, etc)
hour	TEXT	Hour	Hour for the data
impressions	NUMERIC	Impressions	Impressions
io_currency	TEXT	Campaign currency	Currency of the campaign
io_line_budget	TEXT	Line item budget	Total budget booked for the line item
io_line_group_id	TEXT	Line group ID	Unique identifier of the line group
io_line_group_name	TEXT	Line group name	Name of the Line Group
io_line_id	TEXT	Line item ID	Unique identifier of the line item
line_item_name	TEXT	Line item name	Name of the line item
moat_10s_inview_impression	NUMERIC	MOAT - 10 Sec In-View Impressions	MOAT - 10 Sec In-View Impressions

Teads fields (moat_11s_inview_impression to month)

Teads fields (now to turnover_average_cpc_value)

ID	Type	Name	Description
now	TIMESTAMP	Now	Current timestamp
portfolio_item_name	TEXT	Creative portfolio item	Commercial name of the creative type
post_click_conversion	NUMERIC	Post click conversions	Post click conversions
post_view_conversion	NUMERIC	Post view conversions	Post view conversions
price_advertiser_event	TEXT	Line item billable event	Billable event for the line item
progress_1	NUMERIC	1 second view	1 second view
progress_10	NUMERIC	10 second view	10 second view
progress_11	NUMERIC	11 second view	11 second view
progress_12	NUMERIC	12 second view	12 second view
progress_13	NUMERIC	13 second view	13 second view
progress_14	NUMERIC	14 second view	14 second view
progress_15	NUMERIC	15 second view	15 second view
progress_16	NUMERIC	16 second view	16 second view
progress_17	NUMERIC	17 second view	17 second view
progress_18	NUMERIC	18 second view	18 second view
progress_19	NUMERIC	19 second view	19 second view
progress_2	NUMERIC	2 second view	2 second view
progress_20	NUMERIC	20 second view	20 second view
progress_21	NUMERIC	21 second view	21 second view
progress_22	NUMERIC	22 second view	22 second view
progress_23	NUMERIC	23 second view	23 second view
progress_24	NUMERIC	24 second view	24 second view
progress_25	NUMERIC	25 second view	25 second view
progress_26	NUMERIC	26 second view	26 second view
progress_27	NUMERIC	27 second view	27 second view
progress_28	NUMERIC	28 second view	28 second view
progress_29	NUMERIC	29 second view	29 second view
progress_3	NUMERIC	3 second view	3 second view
progress_30	NUMERIC	30 second view	30 second view
progress_4	NUMERIC	4 second view	4 second view
progress_5	NUMERIC	5 second view	5 second view
progress_6	NUMERIC	6 second view	6 second view
progress_7	NUMERIC	7 second view	7 second view
progress_8	NUMERIC	8 second view	8 second view
progress_9	NUMERIC	9 second view	9 second view
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
turnover_advertising_value	NUMERIC	Total ad cost	Budget spent on advertising cost. Does not include Added Value Budget, nor Ad Manager fee, nor Agency fee.
turnover_average_cost_per_result_value	NUMERIC	Budget spent - Cost per result	Average price of each result, considering the budget spent (invoiced by Teads) and the total volume delivered.
turnover_average_cpc_value	NUMERIC	Budget spent - CPC	Average price of each click, considering the budget spent (invoiced by Teads) and the total volume delivered.

Teads fields (turnover_average_cpm_value to video_third_quartile)

ID	Type	Name	Description
turnover_average_cpm_value	NUMERIC	Budget spent - CPM	Average price of a thousand impressions, considering the budget spent (invoiced by Teads) and the total volume delivered.
turnover_fee_value	NUMERIC	Fee	Budget spent on Ad Manager fee cost
turnover_value	NUMERIC	Budget spent	Budget spent (i.e. invoiced by Teads). Includes Ad Manager fee. Does not include Added Value budget nor Agency fee.
uv_impressions	NUMERIC	Unique Viewers impression	Estimated number of unique Teads IDs exposed to the ad.
video_complete	NUMERIC	Video completes	Video completes
video_complete_rate	NUMERIC	Video complete rate	Video completion rate
video_first_quartile	NUMERIC	Video first quartile	Video first quartile
video_midpoint	NUMERIC	Video midpoint	Video midpoint
video_progress_1	NUMERIC	Video progress 1 second	Video progress 1 second
video_progress_10	NUMERIC	Video progress 10 second	Video progress 10 second
video_progress_11	NUMERIC	Video progress 11 second	Video progress 11 second
video_progress_12	NUMERIC	Video progress 12 second	Video progress 12 second
video_progress_13	NUMERIC	Video progress 13 second	Video progress 13 second
video_progress_14	NUMERIC	Video progress 14 second	Video progress 14 second
video_progress_15	NUMERIC	Video progress 15 second	Video progress 15 second
video_progress_16	NUMERIC	Video progress 16 second	Video progress 16 second
video_progress_17	NUMERIC	Video progress 17 second	Video progress 17 second
video_progress_18	NUMERIC	Video progress 18 second	Video progress 18 second
video_progress_19	NUMERIC	Video progress 19 second	Video progress 19 second
video_progress_2	NUMERIC	Video progress 2 second	Video progress 2 second
video_progress_20	NUMERIC	Video progress 20 second	Video progress 20 second
video_progress_21	NUMERIC	Video progress 21 second	Video progress 21 second
video_progress_22	NUMERIC	Video progress 22 second	Video progress 22 second
video_progress_23	NUMERIC	Video progress 23 second	Video progress 23 second
video_progress_24	NUMERIC	Video progress 24 second	Video progress 24 second
video_progress_25	NUMERIC	Video progress 25 second	Video progress 25 second
video_progress_26	NUMERIC	Video progress 26 second	Video progress 26 second
video_progress_27	NUMERIC	Video progress 27 second	Video progress 27 second
video_progress_28	NUMERIC	Video progress 28 second	Video progress 28 second
video_progress_29	NUMERIC	Video progress 29 second	Video progress 29 second
video_progress_3	NUMERIC	Video progress 3 second	Video progress 3 second
video_progress_30	NUMERIC	Video progress 30 second	Video progress 30 second
video_progress_4	NUMERIC	Video progress 4 second	Video progress 4 second
video_progress_5	NUMERIC	Video progress 5 second	Video progress 5 second
video_progress_6	NUMERIC	Video progress 6 second	Video progress 6 second
video_progress_7	NUMERIC	Video progress 7 second	Video progress 7 second
video_progress_8	NUMERIC	Video progress 8 second	Video progress 8 second
video_progress_9	NUMERIC	Video progress 9 second	Video progress 9 second
video_start	NUMERIC	Video starts	Video starts
video_third_quartile	NUMERIC	Video third quartile	Video third quartile

Teads fields (website_domain to year_week_iso)

ID	Type	Name	Description
website_domain	TEXT	Website domain	The domain of the website
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year for the data (ISO8601 format containing first day in year)
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors