Criteo Connector Reference

56 metrics42 dimensions

Fields Options

https://connectors.windsor.ai/criteo?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv

The Criteo connector exposes 98 fields (56 metrics, 42 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Available options

currency Currency

The currency to use for the results. Defaults to EUR.

Possible values (113)

EURUSDGBPCHFJPYBGNCZKDKKHUFLTLPLNRONSEKNOKHRKRUBTRYAUDBRLCADCNYHKDIDRINRKRWMXNMYRNZDPHPSGDTHBZARARSCOPAEDKZTSARUAHEGPMADILSBHDJODKWDLBPOMRQARNGNKESALLETBBSDBDTBAMBWPMMKAFNBTNGELGHSGIPISKKHRJMDLAKMKDMURMNTNPRNADPKRRWFLKRSZLTZSTTDUGXZMWBOBCRCDOPGTQHNLNIOPABPYGPENUYUVEFXAFXOFHTGMGADZDIQDLYDTNDYERBNDAOAMZNAMDAZNKGSTJSUZSMDLRSDXPFMOPVNDTWDCLP

Criteo Fields

Criteo Campaign fields

The Campaign report of the Criteo connector includes 80 fields.

Criteo Campaign fields (account_id to exposed_users)

ID	Type	Name	Description
account_id	TEXT	Account ID	The Advertiser ID
account_name	TEXT	Account Name	The Name of the Advertiser
ad	TEXT	Ad	The name of the ad.
ad_channel	TEXT	Ad Channel	The channel the ad belongs to.
ad_id	TEXT	Ad ID	The unique identifier of the ad.
ad_set	TEXT	Ad Set	The name of the ad set.
adnetwork_conversions	NUMERIC	Ad Network Conversions	The Ad Network Reported Conversions
adnetwork_revenue	NUMERIC	Ad Network Revenue	The Ad Network Reported Revenue
adset_id	TEXT	Ad Set ID	The unique identifier of the ad set.
advertiser	TEXT	Advertiser	The Name of the Advertiser
app_installs	NUMERIC	Number of App Installs	Number of app installs.
audience	NUMERIC	Audience	Number of distinct cookies to which Criteo had the opportunity to make a display
average_cart	NUMERIC	Average Cart	Average order value, attributed within 30 days post-click.
average_cart_all	NUMERIC	Average Cart (including cross device)	Average order value including cross-device, attributed within 30 days post-click.
bounce_rate	PERCENT	Bounce rate	Share of visits that bounced.
campaign	TEXT	Campaign	The Campaign Name
campaign_id	TEXT	Campaign ID	The unique identifier of the campaign.
category	TEXT	Category	The name of the category.
category_id	TEXT	Category ID	The unique identifier of the category.
channel	TEXT	Channel	The name of the channel.
channel_id	TEXT	Channel ID	The unique identifier of the channel.
click_through_rate	PERCENT	Click-Through Rate	Clicks divided by displays.
clicks	NUMERIC	Clicks	Number of times that your Criteo ads have been clicked
conversion_rate	PERCENT	Conversion Rate	Post-click conversion rate, attributed within 30 days.
conversion_rate_all	PERCENT	Conversion Rate (including cross device)	Post-click conversion rate including cross-device, attributed within 30 days.
cost_per_install	NUMERIC	Cost Per Install	Advertiser cost per app install.
cost_per_order	NUMERIC	Cost Per Order	Advertiser cost per order, attributed within 30 days post-click.
cost_per_order_all	NUMERIC	Cost Per Order (including cross device)	Advertiser cost per order including cross-device, attributed within 30 days post-click.
cost_per_visit	NUMERIC	Advertiser Cost Per Visit	Advertiser cost per visit.
coupon	TEXT	Coupon	The name of the coupon.
coupon_id	TEXT	Coupon ID	The unique identifier of the coupon.
cpc	NUMERIC	CPC	Cost per click.
currency	TEXT	Currency	The Criteo Account Currency
date	DATE	Date	Date
device	TEXT	Device	The Device Type
ecos	NUMERIC	eCOS	Effective cost of sale, attributed within 30 days post-click.
ecos_all	NUMERIC	eCOS (including cross device)	Effective cost of sale including cross-device, attributed within 30 days post-click.
ecpc	NUMERIC	eCPC	Effective cost per click.
ecpm	NUMERIC	eCPM	Effective cost per thousand displays.
exposed_users	NUMERIC	Exposed users	The number of users who have been served an ad.

Criteo Campaign fields (frequency to visits)

ID	Type	Name	Description
frequency	NUMERIC	Frequency	Average number of displays per user.
goal	TEXT	Goal	The goal of the campaign.
impressions	NUMERIC	Impressions	Number of times your Criteo ad is displayed to a user on publishers’ websites
install_rate	PERCENT	Install Rate	Share of clicks that resulted in an app install.
invalid_clicks	NUMERIC	Invalid Clicks	Number of invalid clicks.
invalid_displays	NUMERIC	Invalid Displays	Number of invalid displays.
marketing_objective	TEXT	Marketing Objective	The name of the marketing objective.
marketing_objective_id	TEXT	Marketing Objective ID	The unique identifier of the marketing objective.
non_viewable_displays	NUMERIC	Non-Viewable Displays	Number of non-viewable displays.
omnichannel_revenue	NUMERIC	Omnichannel Revenue	Omnichannel revenue, attributed within 30 days post-click.
omnichannel_roas	NUMERIC	Omnichannel ROAS	Omnichannel return on advertising spend, attributed within 30 days post-click.
omnichannel_sales	NUMERIC	Omnichannel Sales	Omnichannel sales, attributed within 30 days post-click.
os	TEXT	OS	The operating system of the device.
potential_displays	NUMERIC	Potential Displays	Number of potential displays.
qualified_visits	NUMERIC	Qualified Visits	Number of qualified visits to your website.
reach	NUMERIC	Reach	Share of the audience exposed to at least one Criteo display ad (percentage)
roas	PERCENT	ROAS	Return on advertising spend, attributed within 30 days post-click.
roas_all	NUMERIC	ROAS (including cross device)	Return on advertising spend including cross-device, attributed within 30 days post-click.
social_platform	TEXT	Social Platform	The social platform the ad ran on.
spend	NUMERIC	Spend	Total cost of your campaigns
totalcost	NUMERIC	Total Cost	Total cost of your campaigns (Duplicate)
transactionrevenue	NUMERIC	Revenue	The total revenue of your campaigns generated from post-click sales. Sales are attributed within 30 days after a user clicks on your Criteo ad.
transactionrevenue_all	NUMERIC	Revenue (including cross device)	The total revenue of your campaigns generated from post-click including sales and cross-device conversions. Sales are attributed within 30 days after a user clicks on your Criteo ad.
transactionrevenue_postview	NUMERIC	Post-View Revenue	The total revenue on your website generated from post-view sales within 24 hours after a user sees a Criteo ad of your campaign. Post-view sales do not include sales from users who clicked an ad, which are counted as sales
transactionrevenue_postviewpostclick	NUMERIC	Post-View and Click Revenue	Post-click + post-view revenue is the total revenue of your campaigns generated from post-click (30 days) and post-view (24 hours) sales. This number is computed based on the prices provided by your conversion trackers
transactions	NUMERIC	Transactions	The total number of purchases completed via the same device your Criteo ads were clicked. Sales are attributed within 30 days after a user clicks on your Criteo ad.
transactions_all	NUMERIC	Transactions (including cross device)	The total number of purchases completed via all devices your Criteo ads were clicked. Sales are attributed within 30 days after a user clicks on your Criteo ad.
transactions_postview	NUMERIC	Post-View Transactions	Number of transactions that occurred on your website within 24 hours after a user sees a Criteo ad of your campaign. Post-view sales do not include sales from users who clicked an ad, which are counted as sales.
transactions_postviewpostclick	NUMERIC	Post-View and Click Transactions	The total number of transactions generated both post-click (30 days) and post-view (24 hours). This number is computed based on the prices provided by your conversion trackers
video_completed	NUMERIC	Video Completed	Number of completed video views.
video_completion_rate	NUMERIC	Video Completion Rate	Share of started videos that were completed.
video_cpcv	NUMERIC	Video CPCV	Cost per completed video view.
video_cpv	NUMERIC	Video CPV	Cost per video view.
video_first_quartile	NUMERIC	Video First Quartile	Number of videos played to the first quartile.
video_midpoint	NUMERIC	Video Midpoint	Number of videos played to the midpoint.
video_start_rate	PERCENT	Video Start Rate	Share of displays that started the video.
video_started	NUMERIC	Video Started	Number of video starts.
video_third_quartile	NUMERIC	Video Third Quartile	Number of videos played to the third quartile.
viewable_displays	NUMERIC	Viewable Displays	Number of viewable displays.
visits	NUMERIC	Visits	Number of visits to your website.

Criteo other fields

The Criteo connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
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
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
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
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