Use the Google Ad Manager data source connector to create a report to see which ads are converting the most and what is your spend across accounts. Aggregate data to your other paid media platforms to see which campaigns are converting the most.
For a full list of metrics and dimensions available in our Google Ad Manager data source connector, take a look at our Google Ad Manager documentation.
Once you've connected to Google Ad Manager, you're ready to create your first query in Google Sheets, Looker Studio (formerly Data Studio), or Excel.
Try these queries
See the following use cases for examples on how to use the metrics and dimensions.
See ad server clicks and impressions
Get data on your ad server clicks and impressions, along with creative, line item, and order details. In this example, we pull data for the month to date, and include the date information.
The "Ad server clicks" metric shows the number of clicks delivered by the ad server. The "Ad server impressions" metric shows the number of impressions delivered by the ad server.
For best results in Looker Studio, use the table chart type.
- Set the date range to This month to date.
- Select the Ad server clicks and Ad server impressions metrics.
- Select the Creative, Line item, Order, and Date dimensions to split the query results by these details.
See revenue by hour
Take a look at the revenue generated by the ad servers by hour.
The "Revenue (excluding CPD)" metric shows the total CPM and CPC revenue generated by the ad servers, including line item-level dynamic allocation.
For best results in Looker Studio, use the time series chart type.
- Set the date range to Last 7 days.
- Select the Revenue (excluding CPD) metric.
- Select the Hour dimensions to split the query results by hour.
See ad server and ad exchange impressions
Explore your ad server impressions and ad exchange impressions, ad exchange revenue and unfilled impressions. In this example, we take a look at the data from the past 28 days, and break the results by customized criteria and date.
The "Ad server impressions" metric shows the number of impressions delivered by the ad server.
The "Ad Exchange impressions" metric shows the number of impressions an Ad Exchange ad delivered for line item-level dynamic allocation.
The "Ad Exchange revenue" metric shows the revenue generated from Ad Exchange ads delivered for line item-level dynamic allocation.
The "Unfilled impressions" metric shows the total number of missed impressions due to the ad servers' inability to find ads to serve, including inventory-level dynamic allocation.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last 28 days.
- Select the Ad server impressions, Ad Exchange impressions, Ad Exchange revenue, and Unfilled impressions metrics.
- Select the Customised criteria and Date dimensions to split the query results by custom criteria ID and date.
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: