Use the AdRoll data source connector to combine data with your other marketing channels to have cross-channel reports and full visibility of your campaign success and spending. Track your campaigns and ads by automating your reporting to the desired destination.
For a full list of metrics and dimensions available in our AdRoll data source connector, take a look at our AdRoll documentation.
Once you've connected to AdRoll, you're ready to create your first queries!
Try these queries
See the following use cases for examples on how to use the metrics and dimensions.
See advertising cost
Take a look at your advertising cost for last month. In this example, we fetch the data by advertiser details.
The "Cost (USD)" metric shows the advertising cost in US dollars.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last month.
- Select the Cost (USD) metric.
- Select the Advertiser EID and Advertiser dimensions to split the query results by advertiser.
See user actions and cost
Explore how your audience has interacted with your ads, and how much it has cost. In this example, we view the data for the past 12 months and split the data by month and campaign.
The "Clicks" metric shows the number of times an ad was clicked over the date range selected.
The "Conversions" metric shows the conversions (count) = View Conversions + Click Conversions.
The "Impressions" metric shows the sum of the number of ad impressions and the number of unique-by-session email opens collected.
The "Cost (USD)" metric shows the advertising cost in US dollars.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last 12 months.
- Select the Clicks, Conversions, Impressions, and Cost (USD) metrics.
- Select the Campaign and Year & Month dimensions to split the query results by campaign and month.
See revenue and cost
View the revenue and cost of your ad campaigns for the ongoing year. In this example, we split the results by week.
The "Revenue (account currency)" metric shows the revenue (amount) in your campaign currency.
The "Cost (account currency)" shows the cost amount in your campaign currency.
For best results in Looker Studio, use the time series chart type.
- Set the date range to Year to date.
- Select the Revenue (account currency) and Cost (account currency) metrics.
- Select the Year & week dimension to split the query results by year and week.
More resources
You might also be interested in: