Open navigation

Criteo report building guide

Use the Criteo data source connector to access your campaign data more easily and pull data such as performance, targeting, audience, bidding, device, and ad set. You can also create reports to see seasonal changes with your retargeting campaigns.


For a full list of metrics and dimensions available in our Criteo data source connector, take a look at our Criteo documentation.


Once you've connected to Criteo, you’re ready to create your first query in Google Sheets, Looker Studio, or Excel.


Try these queries

See the following use cases for examples on how to use the metrics and dimensions. 


See impressions, clicks, and cost per ad set

Explore the impressions, clicks, and costs of your ad sets. In this example, we take a look at the data for the last 7 days.


The "Impressions" metric shows the number of times the ad is displayed to a user on publishers' websites. The "Clicks" metric shows the number of times that your Criteo ads have been clicked. The "Cost" metric shows the total cost of the campaigns.


For best results in Looker Studio, use the table chart type.

  1. Set the date range to Last 7 days.
  2. Select the Impressions, Click, and Cost metrics.
  3. Select the Ad set name and Date dimensions.


See campaign cost

Take a look at how much your campaigns have cost throughout the year. In this example, we split the results by month. 


The "Cost" metric shows the total cost of the campaigns.


For best results in Looker Studio, use the time series chart type.

  1. Set the date range to This year to date.
  2. Select the Cost metric.
  3. Select the Year & Month dimension to split the query results by year and month.


See cost, revenue, and sales

Get data on how much your campaigns cost last month, and how much revenue they generated.


The "Cost" metric shows the total cost of the campaigns. The "Revenue" metric shows the amount of money generated by online sales. The "Sales" metric shows the total number of purchases completed via the same device your Criteo ads were clicked, or a different one.


For best results in Looker Studio, use the time series chart type.

  1. Set the date range to Last month.
  2. Select the Cost, Revenue, and Sales metrics.
  3. Select the Date dimension to split the query results by date.


See cost, revenue, and sales per campaign

Take a look at the cost, revenue, and sales for your campaigns and categories last week.


The "Cost" metric shows the total cost of the campaigns. The "Revenue" metric shows the amount of money generated by online sales. The "Sales" metric shows the total number of purchases completed via the same device your Criteo ads were clicked, or a different one.


For best results in Looker Studio, use the table chart type.

  1. Set the date range to Last week.
  2. Select the Cost, Revenue, and Sales metrics.
  3. Select the Campaign name and Category name dimensions to split the query results by campaign and category.


Set up scheduled refreshes for your reports

You can set up scheduled refreshes for your reports created in Google Sheets and Excel. Follow the instructions on how to create and manage scheduled reports in Google Sheets and how to set up scheduled report triggers in Excel


In Looker Studio, you can have a copy of your report emailed to you and important stakeholders at regular intervals.


More resources

You might also be interested in:

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.