Google Ad Manager report building guide

Prev Next

Use the Google Ad Manager data source connector to see which ads are converting the most and what your spend looks like across accounts. Aggregate data alongside your other paid media platforms to get a full picture of campaign performance.

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.

Review ad server clicks and impressions

Get a daily breakdown of clicks and impressions delivered by the ad server this month, split by creative, line item, and order — useful for monitoring delivery performance and identifying underperforming placements.

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

Setting

Value

Date range

This month to date

Metrics

Ad server clicks, Ad server impressions

Dimensions

Creative, Line item, Order, Date

Suggested visualization

Table

Understanding the data

  • Ad server clicks: The number of clicks delivered by the ad server.

  • Ad server impressions: The number of impressions delivered by the ad server.

  • Creative: The specific ad creative associated with the delivery.

  • Line item: The line item within the order that the ad belongs to.

  • Order: The order grouping the line items.

  • Date: Splits results by day for granular trend analysis.

Track revenue by hour

See how ad server revenue is distributed across the hours of the day over the last 7 days — useful for understanding peak monetization windows and optimizing ad scheduling.

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

Setting

Value

Date range

Last 7 days

Metrics

Revenue (excluding CPD)

Dimensions

Hour

Suggested visualization

Time series chart

Understanding the data

  • Revenue (excluding CPD): The total CPM and CPC revenue generated by the ad servers, including line item-level dynamic allocation, but excluding Cost Per Day (CPD) deals.

  • Hour: Splits results by hour of the day so you can identify when revenue peaks.

Compare ad server, ad exchange, and unfilled impressions

Explore ad server impressions alongside ad exchange impressions, revenue, and unfilled impressions over the last 28 days — helping you understand how much inventory is being monetized versus going to waste.

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

Setting

Value

Date range

Last 28 days

Metrics

Ad server impressions, Ad Exchange impressions, Ad Exchange revenue, Unfilled impressions

Dimensions

Customised criteria, Date

Suggested visualization

Table

Understanding the data

  • Ad server impressions: The number of impressions delivered by the ad server.

  • Ad Exchange impressions: The number of impressions delivered by Ad Exchange ads for line item-level dynamic allocation.

  • Ad Exchange revenue: The revenue generated from Ad Exchange ads delivered for line item-level dynamic allocation.

  • Unfilled impressions: The total number of missed impressions where the ad server was unable to find an ad to serve, including inventory-level dynamic allocation.

  • Customised criteria: A custom targeting criterion used to segment results by a defined audience or inventory rule.

  • Date: Splits results by day for granular trend analysis.

More resources

You might also be interested in: