Criteo

Creating the data source

Requirements

Administrator permissions for the Criteo ad account

Instruções

Log in to your Criteo account
If you haven’t done so yet, create your organization
Go to your profile page and, at the bottom under Products, select Developer Portal
In the top-right corner, select Create a new app
Give your app a name, such as "App Kondado", then click Create app
Under Choose an authentication method, select Client credentials
On the next page (Service), select C-Growth and Marketing Solutions
In the Authorization section, set Read for all rows and click Activate App
On the next page, go to the App credentials section, click Create new key, and save the generated file to your computer
On the same page, go to the top-right corner and click Generate new URL
A URL will appear on the page. Copy it using the button on the right
If you also have administrator access to the Criteo ad account, open this URL in a new tab. If someone else has that access, send them the URL
When the person with access opens the URL, they just need to scroll down to Portfolio access, select the accounts to grant access to, and then click Approve
Once access is approved, log in to Kondado, click CREATE + > Conector > Criteo
In the connector, under Nome, give your connector a name, and under Client ID and Client Secret, paste the values obtained in the text file from step (9)
Important:
1. The generated client ID can take up to 15 minutes to be activated by Criteo. After saving, wait this period before clicking TESTAR CONEXÃO (test connection) to start creating integrations
2. The connection test will only succeed if the generated app is authorized for at least one advertiser

Pipelines

Summary

Daily ad performance

Relationship chart

Click to expand

Daily ad performance

Campo	Tipo
metric_date	date	[en] Date of the statistic
advertiserid	text	[en] ID of the advertiser
adset	text	[en] Name of the adset
adsetid	text	[en] ID of the adset
advertiser	text	[en] Name of the advertiser
advertisercost	float	[en] Total money spent on Criteo advertising
audience	float	[en] Potential users who could be served an ad
category	text	[en] Name of the category
categoryid	text	[en] ID of the category
clicks	float	[en] The number of clicks driven by your ads.
currency	text
device	text
displays	float	[en] The number of ad impressions served on publishers via Criteo.
exposedusers	float	[en] The number of users who have been served an ad
os	text	[en] Operational System
viewabledisplays	float	[en] The number of ads that have been viewed. A display is considered viewed if at least 50% of the ad appears on the screen for at least one second
visits	float	[en] The number of users on the target website or app for which at least one event occurred within the hour following a click
nonviewabledisplays	float	[en] The number of ads that did not meet the viewability criteria.
untrackabledisplays	float	[en] The number of displays not tracked (e.g. due to certain native banner environments).
qualifiedvisits	float	[en] Visitors with at least two events or one sale event within an hour of a click.
costpervisit	float	[en] Amount of money spent per visit.
bouncerate	float	[en] Proportion of website visitors who leave after viewing only one page.
potentialdisplays	float	[en] Total display opportunities (bid requests received).
overallcompetitionwin	float	[en] Displays / PotentialDisplays (the overall win rate).
salesclientattribution	float	[en] Number of conversions using your custom attribution data.
salesallclientattribution	float	[en] Number of conversions using your custom attribution, including both post-click and post-view if applicable.
salespc30d	float	[en] Number of conversions under a 30-day post-click window. A sale is attributed when the user clicks an ad and converts within 30 days.
salesallpc30d	float	[en] Number of conversions combining 30-day post-click and other attributions. Typically sums post-click and post-view or custom data, all constrained by a 30-day click window.
salespv24h	float	[en] Number of conversions under a 24-hour post-view window. A sale is attributed when the user sees an ad and converts within 24 hours.
salesallpv24h	float	[en] Number of conversions combining 24-hour post-view and other attributions. Typically sums post-click and post-view or custom data, constrained by a 24-hour view window.
salespc30dpv24h	float	[en] Number of conversions combining post-click (30 days) and post-view (24 hours) windows.
salesallpc30dpv24h	float	[en] Number of conversions combining post-click (30 days) and post-view (24 hours), including custom data if applicable.
salespc1d	float	[en] Number of conversions under a 1-day post-click window. A sale is attributed if the user clicks and converts within 1 day. (Data not available before Jan 1, 2020.)
salesallpc1d	float	[en] Number of conversions combining a 1-day post-click window with other attributions. (Data not available before Jan 1, 2020.)
salespc7d	float	[en] Number of conversions under a 7-day post-click window. A sale is attributed if the user clicks and converts within 7 days. (Data not available before Jan 1, 2020.)
salesallpc7d	float	[en] Number of conversions combining a 7-day post-click window with other attributions. (Data not available before Jan 1, 2020.)
revenuegeneratedclientattribution	float	[en] Total revenue (online) using your custom attribution data.
revenuegeneratedallclientattribution	float	[en] Total revenue (online) using your custom attribution, including both post-click and post-view if applicable.
revenuegeneratedpc30d	float	[en] Total revenue (online) under a 30-day post-click window.
revenuegeneratedallpc30d	float	[en] Total revenue (online) combining 30-day post-click with other attributions.
revenuegeneratedpv24h	float	[en] Total revenue (online) under a 24-hour post-view window.
revenuegeneratedallpv24h	float	[en] Total revenue (online) combining 24-hour post-view with other attributions.
revenuegeneratedpc30dpv24h	float	[en] Total revenue (online) combining post-click (30 days) and post-view (24 hours).
revenuegeneratedallpc30dpv24h	float	[en] Total revenue (online) combining post-click (30 days) and post-view (24 hours) attributions, plus any custom data if applicable.
revenuegeneratedpc1d	float	[en] Total revenue (online) under a 1-day post-click window. (Not available before Jan 1, 2020.)
revenuegeneratedallpc1d	float	[en] Total revenue (online) combining a 1-day post-click window with other attributions. (Not available before Jan 1, 2020.)
revenuegeneratedpc7d	float	[en] Total revenue (online) under a 7-day post-click window. (Not available before Jan 1, 2020.)
revenuegeneratedallpc7d	float	[en] Total revenue (online) combining a 7-day post-click window with other attributions. (Not available before Jan 1, 2020.)
reach	float	[en] Share of potential users who have been served an ad.
averagecartclientattribution	float	[en] Average revenue per conversion using your custom attribution data.
averagecartallclientattribution	float	[en] Average revenue per conversion with custom attribution, including both post-click and post-view.
averagecartpc30d	float	[en] Average revenue per conversion under a 30-day post-click window.
averagecartallpc30d	float	[en] Average revenue per conversion combining a 30-day post-click window with other attributions.
averagecartpv24h	float	[en] Average revenue per conversion under a 24-hour post-view window.
averagecartallpv24h	float	[en] Average revenue per conversion combining a 24-hour post-view window with other attributions.
averagecartpc30dpv24h	float	[en] Average revenue per conversion combining post-click (30 days) and post-view (24 hours).
averagecartallpc30dpv24h	float	[en] Average revenue per conversion combining post-click (30 days) and post-view (24 hours) plus any custom data if applicable.
averagecartpc1d	float	[en] Average revenue per conversion under a 1-day post-click window. (Not available before Jan 1, 2020.)
averagecartallpc1d	float	[en] Average revenue per conversion combining a 1-day post-click window with other attributions. (Not available before Jan 1, 2020.)
averagecartpc7d	float	[en] Average revenue per conversion under a 7-day post-click window. (Not available before Jan 1, 2020.)
averagecartallpc7d	float	[en] Average revenue per conversion combining a 7-day post-click window with other attributions. (Not available before Jan 1, 2020.)
clickthroughrate	float	[en] Percentage of users who clicked after being served an ad.
conversionrateclientattribution	float	[en] Percentage of clicks that converted, using your custom attribution data.
conversionrateallclientattribution	float	[en] Percentage of clicks that converted, combining custom data for post-click and post-view if applicable.
conversionratepc30d	float	[en] Percentage of clicks that converted within a 30-day post-click window.
conversionrateallpc30d	float	[en] Percentage of clicks that converted within a 30-day post-click window, possibly including other attributions.
conversionratepv24h	float	[en] Percentage of ad views that converted within a 24-hour post-view window.
conversionrateallpv24h	float	[en] Percentage of views that converted within a 24-hour post-view window, possibly including other attributions.
conversionratepc30dpv24h	float	[en] Combined conversion rate from 30-day post-click and 24-hour post-view windows.
conversionrateallpc30dpv24h	float	[en] Combined conversion rate for post-click (30 days) and post-view (24 hours), plus any custom data if applicable.
conversionratepc1d	float	[en] Percentage of clicks that converted within a 1-day post-click window. (Not available before Jan 1, 2020.)
conversionrateallpc1d	float	[en] Percentage of clicks that converted within a 1-day post-click window, possibly with additional attributions. (Not available before Jan 1, 2020.)
conversionratepc7d	float	[en] Percentage of clicks that converted within a 7-day post-click window. (Not available before Jan 1, 2020.)
conversionrateallpc7d	float	[en] Percentage of clicks that converted within a 7-day post-click window, possibly with additional attributions. (Not available before Jan 1, 2020.)
ecosclientattribution	float	[en] Advertising cost per conversion using your custom attribution data.
ecosallclientattribution	float	[en] Advertising cost per conversion with custom attribution, possibly including post-click and post-view.
ecospc30d	float	[en] Advertising cost per conversion under a 30-day post-click window.
ecosallpc30d	float	[en] Advertising cost per conversion combining a 30-day post-click window with other attributions.
ecospv24h	float	[en] Advertising cost per conversion under a 24-hour post-view window.
ecosallpv24h	float	[en] Advertising cost per conversion combining a 24-hour post-view window with other attributions.
ecospc30dpv24h	float	[en] Advertising cost per conversion combining 30-day post-click and 24-hour post-view windows.
ecosallpc30dpv24h	float	[en] Advertising cost per conversion combining 30-day post-click and 24-hour post-view, plus custom data if applicable.
ecospc1d	float	[en] Advertising cost per conversion under a 1-day post-click window. (Not available before Jan 1, 2020.)
ecosallpc1d	float	[en] Advertising cost per conversion combining a 1-day post-click window with other attributions. (Not available before Jan 1, 2020.)
ecospc7d	float	[en] Advertising cost per conversion under a 7-day post-click window. (Not available before Jan 1, 2020.)
ecosallpc7d	float	[en] Advertising cost per conversion combining a 7-day post-click window with other attributions. (Not available before Jan 1, 2020.)
costperorderclientattribution	float	[en] Total cost divided by orders, using your custom attribution data.
costperorderallclientattribution	float	[en] Total cost divided by orders, using custom attribution for post-click and post-view if applicable.
costperorderpc30d	float	[en] Cost per order under a 30-day post-click window.
costperorderallpc30d	float	[en] Cost per order combining a 30-day post-click window with other attributions.
costperorderpv24h	float	[en] Cost per order under a 24-hour post-view window.
costperorderallpv24h	float	[en] Cost per order combining a 24-hour post-view window with other attributions.
costperorderpc30dpv24h	float	[en] Cost per order combining post-click (30 days) and post-view (24 hours) attributions.
costperorderallpc30dpv24h	float	[en] Cost per order combining post-click (30 days) and post-view (24 hours), plus custom data if applicable.
costperorderpc1d	float	[en] Cost per order under a 1-day post-click window. (Not available before Jan 1, 2020.)
costperorderallpc1d	float	[en] Cost per order combining a 1-day post-click window with other attributions. (Not available before Jan 1, 2020.)
costperorderpc7d	float	[en] Cost per order under a 7-day post-click window. (Not available before Jan 1, 2020.)
costperorderallpc7d	float	[en] Cost per order combining a 7-day post-click window with other attributions. (Not available before Jan 1, 2020.)
cpc	float	[en] Cost per click.
ecpm	float	[en] Cost per 1000 impressions.
roasclientattribution	float	[en] Return on ad spend (revenue / cost) using your custom attribution data.
roasallclientattribution	float	[en] Return on ad spend including custom attribution for both post-click and post-view.
roaspc30d	float	[en] ROAS under a 30-day post-click window (revenue / cost for clicks converting within 30 days).
roasallpc30d	float	[en] ROAS combining 30-day post-click with other attributions.
roaspv24h	float	[en] ROAS under a 24-hour post-view window (revenue / cost for views converting within 24 hours).
roasallpv24h	float	[en] ROAS combining 24-hour post-view with other attributions.
roaspc30dpv24h	float	[en] ROAS combining post-click (30 days) and post-view (24 hours).
roasallpc30dpv24h	float	[en] ROAS combining post-click (30 days) and post-view (24 hours), plus custom data if applicable.
roaspc1d	float	[en] ROAS with a 1-day post-click window. (Not available before Jan 1, 2020.)
roasallpc1d	float	[en] ROAS combining a 1-day post-click window with other attributions. (Not available before Jan 1, 2020.)
roaspc7d	float	[en] ROAS with a 7-day post-click window. (Not available before Jan 1, 2020.)
roasallpc7d	float	[en] ROAS combining a 7-day post-click window with other attributions. (Not available before Jan 1, 2020.)
advertiservalue	float	[en] The revenue generated by each product, considering margin (if provided).
advertiserallvalue	float	[en] The total advertiser value, possibly including both post-click and post-view margin-based data.
costofadvertiservalue	float	[en] The ratio (advertiser value / cost), expressed as a percentage.
costofadvertiservalueall	float	[en] Same ratio (advertiser value / cost), including all attributions.
postinstallsales	float	[en] Number of completed events after an app install.
appinstalls	float	[en] Number of app installations.
postinstallconversionrate	float	[en] Percentage of clicks that lead to post-install sales.
postinstallcostofsale	float	[en] Cost of sale for app-install-driven conversions.
postinstallordervalue	float	[en] Amount of money generated by sales after an app install.
costperinstall	float	[en] Ad cost per app install.
installrate	float	[en] Percentage of clicks that resulted in an app install.
postinstallcostperorder	float	[en] Cost per order for post-install sales.
postinstallroas	float	[en] Return on ad spend for conversions after an app install.
omnichannelroasclientattribution	float	[en] ROAS (online + offline) using your custom attribution data.
omnichannelroaspc30d	float	[en] ROAS (online + offline) under a 30-day post-click window.
omnichannelroasallpc30d	float	[en] ROAS combining a 30-day post-click window with additional or custom data (online + offline).
omnichannelroaspv24h	float	[en] ROAS (online + offline) under a 24-hour post-view window.
omnichannelroasallpv24h	float	[en] ROAS combining a 24-hour post-view window with additional or custom data (online + offline).
omnichannelrevenueclientattribution	float	[en] Revenue (online + offline) using your custom attribution data.
omnichannelrevenuepc30d	float	[en] Revenue (online + offline) under a 30-day post-click window.
omnichannelrevenueallpc30d	float	[en] Revenue combining a 30-day post-click window with additional or custom data (online + offline).
omnichannelrevenuepv24h	float	[en] Revenue (online + offline) under a 24-hour post-view window.
omnichannelrevenueallpv24h	float	[en] Revenue combining a 24-hour post-view window with additional or custom data (online + offline).
omnichannelsalesclientattribution	float	[en] Number of transactions (online + offline) using your custom attribution data.
omnichannelsalespc30d	float	[en] Transactions (online + offline) under a 30-day post-click window.
omnichannelsalesallpc30d	float	[en] Transactions combining a 30-day post-click window with additional or custom data (online + offline).
omnichannelsalespv24h	float	[en] Transactions (online + offline) under a 24-hour post-view window.
omnichannelsalesallpv24h	float	[en] Transactions combining a 24-hour post-view window with additional or custom data (online + offline).
roasofflinepc30d	float	[en] ROAS for offline revenue and cost. A sale is attributed when your customer sees an offline ad and converts within 30 days.
roasofflinepv24h	float	[en] ROAS for offline revenue and cost under a 24-hour post-view window. A sale is attributed when your customer sees an offline ad and converts within 24 hours.
salesofflinepc30d	float	[en] Offline transactions under a 30-day post-click window. A sale is attributed when your customer sees an ad offline and converts within 30 days.
salesofflinepv24h	float	[en] Offline transactions under a 24-hour post-view window. A sale is attributed when your customer sees an ad offline and converts within 24 hours.
revenuegeneratedofflinepc30d	float	[en] Offline revenue under a 30-day post-click window. A sale is attributed when your customer sees an ad offline and converts within 30 days.
revenuegeneratedofflinepv24h	float	[en] Offline revenue under a 24-hour post-view window. A sale is attributed when your customer sees an ad offline and converts within 24 hours.

Notes

Field description

The description of the fields was partially generated with the help of artificial intelligence, based on Criteo's documentation