AdRoll report building guide

Prev Next

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. 

Before you begin

Before you build reports, you need to connect the data source to Supermetrics.

Popular queries

These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.

See advertising cost

Take a look at your advertising cost for last month. In this example, we fetch the data by advertiser details.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Last month

Metrics

Cost (USD)

Dimensions

Advertiser EID, Advertiser

Suggested visualization

Table

Understanding the data

  • Cost (USD): Shows the advertising cost in US dollars. 

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.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Last 12 months

Metrics

Clicks, Conversions, Impressions, Cost (USD)

Dimensions

Campaign, Year & Month

Suggested visualization

Table

Understanding the data

  • Clicks: Shows the number of times an ad was clicked over the date range selected.

  • Conversions: Shows the conversions (count) = View Conversions + Click Conversions.

  • Impressions: Shows the sum of the number of ad impressions and the number of unique-by-session email opens collected.

  • Cost (USD): Shows the advertising cost in US dollars.

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. 

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Year to date

Metrics

Revenue (account currency), Cost (account currency)

Dimensions

Year & week

Suggested visualization

Line chart or time series

Understanding the data

  • Revenue (account currency): Shows the revenue (amount) in your campaign currency. 

  • Cost (account currency): Shows the cost amount in your campaign currency.

More resources

You might also be interested in: