Release Notes
August 2024
We've added the following fields to the ADSET
table:
datasetId
objective
videoChannel
frequencyCappingMode
For more information, see the Criteo ERD.
We have upgraded our Criteo connector from version 2023.10 to 2024.07 of the Criteo API. For more information about the changes, see Criteo API's changelog.
July 2024
Our Criteo connector can now sync creatives and ads data. For more information, see Criteo's creatives documentation.
We've made the following schema changes to support syncing creatives and ads data:
We have added a new table,
AD
, with the following fields:id
🔑creative_id
adset_id
description
end_date
name
start_date
We have added a new table,
CREATIVE
, with the following fields:id
🔑advertiser_id
author
dataset_id
description
format
name
status
adaptive_*
dynamic_*
image_*
We have added a new table,
HTML_TAG
, with the following fields:_fivetran_id
🔑creative_id
height
html_tag
width
We have added a new table,
IMAGE_SET
, with the following fields:_fivetran_id
🔑creative_id
headline_text
We have added a new table,
IMAGE
, with the following fields:_fivetran_id
🔑image_set_id
url
shape
We have added a new table,
IMAGE_URL
, with the following fields:_fivetran_id
🔑creative_id
url
We have added a new table,
LOGO
, with the following fields:_fivetran_id
🔑creative_id
url
shape
type
We have added a new table,
VIDEO
, with the following fields:_fivetran_id
🔑creative_id
url
shape
duration
We have added a new table,
CALL_TO_ACTION
, with the following fields:_fivetran_id
🔑creative_id
text
type
We have added a new table,
LAYOUT
, with the following fields:_fivetran_id
🔑creative_id
text
For more information, see the Criteo ERD.
January 2024
We have upgraded our Criteo connector from version 2023.01 to 2023.10 of the Criteo API. For more information about the changes, see Criteo API's changelog.
We have added a new table, AUDIENCE_ADSET
, with the audienceId
and adSetId
fields.
We have removed the following fields from the AUDIENCE
table:
nbLines
nbLinesEmail
nbMatchesEmail
For more information, see the Criteo ERD.
June 2023
We have upgraded our Criteo connector from version 2022.07 to 2023.01 of the Criteo API. For more information about the changes, see Criteo API's changelog.
August 2022
We have added a new report, PLACEMENT_REPORT
.
July 2022
We have added a new report, ADSET_STATISTICS_HOURLY_REPORT
.
April 2022
We have added two new fields, campaign_id
and media_type
, to the ADSET
table.
We have added a new table, CAMPAIGN
.
December 2021
We have upgraded our Criteo connector from version 2021.01 to 2021.10 of the Criteo API.
August 2021
We now support all currencies listed in Criteo's currencies documentation. Previously, we only supported 25 currencies.
In the connector setup form, you can now select the timezone you want to use to sync the Transaction ID and Statistics reports. If you don't select a timezone, Fivetran fetches the reports using the default timezone (UTC).
In the connector setup form, you can now select the metrics you want to use to sync the Statistics reports. You can also select additional metrics to sync. In the Metrics field, click the down arrow icon and select the metrics.
Metrics list:
June 2021
We have upgraded our Criteo connector from version 2020.07 to 2021.01 of the Criteo API and handled deprecations and updates. Learn more about the deprecations and changes in Criteo's API documentation.
January 2021
The Criteo connector now supports twenty-five global currencies. You can now opt to select one of the following currency codes when you configure the connector:
EUR
USD
GBP
CHF
JPY
BGN
CZK
DKK
HUF
LTL
PLN
RON
SEK
NOK
HRK
RUB
TRY
AUD
BRL
CAD
CNY
HKD
IDR
INR
KRW
NOTE: If you don't select the currency, Fivetran will fetch the reports with the default currency that the Criteo API returns.
September 2020
The Criteo connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Criteo's priority-first syncs fetch the most recent thirty days' worth of data from the reporting tables.
To learn more, see our priority-first sync documentation.
April 2020
We have added a new table, ADVERTISER
.
October 2019
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
August 2019
We have added the campaign_id
column as an additional primary key to the CATEGORY
table to differentiate records per campaign with same category ID.
March 2019
We have added a new table, FACEBOOK_DPA_REPORT
.
We have added a new column, advertiser_id,
to the CAMPAIGN_PERFORMANCE_REPORT
and TRANSACTION_ID_REPORT
tables.
We have changed primary key to _fivetran_id
for the CAMPAIGN_PERFORMANCE_REPORT
and TRANSACTION_ID_REPORT
tables because the API is returning category_id
field values as null
.
January 2019
We have released a new version of the Criteo connector. The new version supports OAuth (Open Authorization). Criteo has deprecated basic authentication with username and password.
We have updated the schema because Criteo has changed its API implementation from SOAP to REST. We have made the following changes:
- The
CATEGORY_REPORT
table has been dropped, as Criteo no longer supports this report. - The
CATEGORY_BID
table has been dropped. The information from this table is now included in theCATEGORY
table.
Read our Criteo connector documentation.
August 2018
Criteo is a retargeted advertising platform.