Skip to main content
Feedback

Google Ad Manager walkthrough

info

Google Ad Manager API version 202405 is currently supported.

Networks

Before you run any report, you need to choose your Network.

Click Network Refresh and select a network.

Reports

Data Integration supports three kinds of reports:

Create a new report

Select dimensions

Dimension provides the breakdown and filterable types for running a new report (report job). Aggregate and percentage columns are calculated based on these groupings.

You can choose more than one Dimension per report, but you must select at least one Dimension for the report to be valid. If you choose an invalid combination, an error occurs. Not all combinations of dimensions are valid. Make sure to select a valid combination.

Additional information about the available dimensions and UI representation is available in the dimensions information.

Select dimension attributes

Dimensions attributes provide additional fields associated with a Dimension. You can only select it with its corresponding Dimension. For example, DimensionAttribute.ORDER_PO_NUMBER can only be used if the ReportQuery.dimensions contains Dimension.ORDER_NAME.

This field is optional.

Select custom fields

You can only select Custom Fields attributes with their corresponding Dimension by type. For example, you can use a custom field with the 'ORDER' type if the 'Dimensions' input list contains a Dimension.ORDER_NAME. To learn more, refer to the topic.

Select columns

The column provides all the trafficking statistics and revenue information for the chosen Dimension objects.

Columns with INVENTORY_LEVEL should not be used with dimensions relating to line items, orders, companies, and creatives, such as Dimension.LINE_ITEM_NAME. Columns with LINE_ITEM_LEVEL can only be used if you enable line item-level dynamic allocation on your Network.

You can choose more than one column per report, but for the report to be valid, you must select at least one column.

Select ad unit view

A view for an ad unit report defines how ad metrics are displayed and which events are included.

  1. Top Level: Only the top-level ad units. Metrics include events for their descendants that are not filtered out. (The top-level ad will represent the metrics for its descendants)

  2. Flat: All the ad units. Metrics do not include events for the descendants.

  3. Hierarchical: Use the ad unit hierarchy. There will be as many ad unit columns as levels of ad units in the generated report:

The column Dimension.AD_UNIT_NAME is replaced with columns Ad unit 1, Ad unit 2, ... Ad unit n. If the level does not apply to a row, N/A is returned as the value.

The column Dimension.AD_UNIT_ID is replaced with columns Ad unit ID 1, Ad unit ID 2, ... Ad unit ID n. If the level does not apply to a row, N/A is returned as the value.

Metrics do not include events for the descendants.

If you do not choose ad unit view, the default is "Top Level". This field is not mandatory.

Select report currency

The currency for Ad Exchange revenue metrics. This field is valid only for Ad Exchange metrics; an exception shows if this field is used with non-Ad Exchange metrics. It defaults to the network currency if left empty. To view supported currencies, refer to the supported currencies.

This field is not mandatory.

Select time zone

Choose the time zone used for the report. There are three available options:

  1. ** Publisher **: Use the Publisher timezone. This time zone is compatible with all metrics for Google Ad Manager reports. However, it is not compatible with "Bids" and "Deals" metrics for Ad Exchange reports.

  2. Proposal Local: Use the proposal or proposal line item time zone. This time zone is compatible only with sales metrics and attributes.

  3. Ad Exchange: Use the Ad Exchange time zone (Pacific Time Zone). This time zone is compatible only with Ad Exchange metrics.

Defaults to Publisher if left empty.

Select time period

  1. Custom date:

  • Pulls data in the date range between the start and end date provided.

  • You must select a start date.

  • Leaving the end date empty pulls data according to the current river run time.

  • Use the Last Days Back For Each Run to expand the start date and pull data a number of days before the chosen start date.

  1. Predefined date: A date defined by the Google Ad Manager API. A list of all available dates is available here
  • Reach lifetime: The last 63 days. This date range is usable only for the column Column.REACH_FREQUENCY, Column.REACH_AVERAGE_REVENUE and Column.REACH.
  • Last 3 months: The last 3 full months. For example, if today is May 5, 2025, LAST_3_MONTHS would go from February 1 to April 30.

General notes regarding the report

  • Creating a new report does not create and save a query directly; instead, it simulates the process in the background by creating a report job.
  • The report's attributes are displayed as they are represented in the Google Ad Manager API; the links for each selection provide additional information about the UI representations corresponding to these attributes.
  • Not all combinations of dimensions and columns are valid; an error occurs if the combination chosen is invalid.

Run an existing report

An existing report is a predefined saved query in your Google Ad Manager console.

Select a predefined saved query

Select the box or the refresh button to load all the saved queries from your console and select the one you want to execute.

Some queries are not compatible with execution via the API. If a saved query is unavailable for selection, try modifying it in your console until it becomes API compatible. Alternatively, you can emulate the query using the 'Create a new report' feature.

Run an entity report

Entities provide information on your Google Ad Manager activities. These are extracted using PQL (Publisher Query Language).

Data Integration currently supports the Line items entity.

Select an Entity

Select the desired entity.

google-ad-manager-walkthrough_entity.jpg

Select the report fields

The fields represent the information you receive on the entity. This is a mandatory field; you can select more than one field.

google-ad-manager-walkthrough_entity_fields.jpg

Add conditions using the filter

The Add conditions using the filter (optional) field lets you add conditions to the Entity report. Using PQL, you can add more filtration to the Where clause of the Entity report.

google-ad-manager-walkthrough_entity_filter.jpg

Note that the conditions are appended using an AND command.

You can use any field in the Entity Fields as an additional filter.

For example,

  • Id IN (34344, 23235), filter all line items with the ids 34344 and 23235 for the Line Items entity report,

In the chosen time range.

  • LineItemType = 'Standard' and Status in ('Delivering', 'Ready') and NOT (Name LIKE '%Undertone%')

This filter applies to all line items with the type 'standard', whose status is 'Delivering' or 'Ready', and whose name does not contain 'Undertone'.

In the chosen time range. To learn more about PQL, refer to this topic

Select a time period

Entity reports support two kinds of time periods:

  1. Date range:
  • Pulls data in the date range between the start and end date provided.
  • You must select a start date.
  • Leaving the end date empty will pull data according to the current river run time.
  • Select a timezone offset to send dates based on the offset.
  • Use the Last Days Back For Each Run to expand the start date and pull data a number of days before the chosen start date.
  1. Predefined date: A date range defined by Data Integration:
  • Day: Yesterday.
  • Week (From Monday to Sunday): Week to date, Previous week, Previous week to date.
  • Month: Month to date, Previous month, Previous month to date.
  • Year: Year to date.
  • To get revenue results compatible with the Google Ad Manager UI, divide the revenue column by 1000000 in the column mapping stage.

For example, under expression, enter: STRING(Column_AD_EXCHANGE_ESTIMATED_REVENUE / 1000000)

google-ad-manager-walkthrough_reve.png

On this Page