Renta supports data export from Criteo to following destinations:
- Google BigQuery
- Clickhouse
- SQL Server
- Google Spreadsheets
Integration creating in data warehouse
- Go to integrations catalog;
- Select Criteo;
- Add a Criteo account that has the necessary data;
- Choose the added Criteo account;
- Specify the destination you want to import the data into;
- Go to the settings screen and set necessary configuration:
- Report type
Each Report Type has its own parameters and metrics collection.
| Report type | Description |
|---|---|
| Campaign performance |
Contains stats about Criteo Dynamic Remarketing. |
| Transaction ID |
Contains stats about all transactions |
| Facebook DPA |
Contains stats from Facebook Dynamic Ads. |
- Parameters
Parameters are the dimensions and metrics that are available in Criteo API. You should specify parameters that are necessary for inserting.
Renta will create the table, which will automatically update by the given update settings.
The order of the chosen parameters in Rentas interface will be equal to tables column sequence.
- Data range type
Choose the inserting period. You can specify any historical time interval.
In order to choose the required time, enter the date you want to start uploading data from in the “From” field, then enter the end date in the “To” field.
If you want the data in the table to update daily and be complemented by new days, you can set “yesterday” in the “To” field.
- Integration name
There is an auto generated name for your integration and here you can edit it as much as you like.
Both Cyrillic and Latin are permitted, but not more than 100 symbols.
- Table name
There is an auto generated name for your table and here you can edit it as much as you like.
Only Latin is permitted, numbers and “_” symbol.
Data Updating
Following updating settings are available for Criteo:
- Update time
You can specify any update time that you need. Users choose early morning integration updates most often, for example 5 AM.
In that case your integration will update in period from 5 AM to 6 AM.
- Overwrite period
Overwrite period means rewriting historical data for a specified period of time.
For instance you choose the overwrite period “Last 7 days” – it means that all data for the last 7 days will be deleted and inserted once again with updated data.
Note: this tab appears only if parameters like Day/Date/Time Period etc have been chosen.
Data Structure
Report type Campaign performance
| Parameters | Description | Type | Data type |
|---|---|---|---|
| Impressions |
Number of times your Criteo ad is displayed to a user on publishers’ websites. |
Dimension | INTEGER |
| Clicks | Parameters description | Dimension | String |
| cost | Parameters description | Dimension | Int |
| Currency | Parameters description | Dimension | Int |
|
Sales Pc |
Parameters description | Dimension | String |
|
Same Sales Pc |
Parameters description | Metrics | Int |
|
Sales Pc Nd |
Products identificator appropriate to ERP-system and product feed |
Dimension | Array For Google Sheets, SQL Server: string |
Report type TransactionID
| Parameters | Description | Type | Data type |
|---|---|---|---|
| Day | Parameters description | Dimension | String |
| Campaign Name | Parameters description | Dimension | String |
| Transaction date | Parameters description | Dimension | Int |
Report type Facebook DPA
| Parameters | Description | Type | Data type |
| Day | Parameters description | Dimension | String |
| Clicks | Parameters description | Dimension | Int |
Quotes and limits
Important note: Renta doesn’t provide any restrictions like amount of accounts, connectors, integrations or inserting date range.
But different resources have their own quotes and limits that don’t depend on Renta.
Limits for Criteo:
- Not more than 200 requests per minute, per client
Link to the official documentation:
https://support.criteo.com/s/article?article=360001226005-Marketing-API-details&language=en_US
_______________________________________________
If you have any questions – please contact us!