Data Source - Google Ad Manager

constraints

Error in execution of ETL Job due to compatibility of items to be acquired

Dimensiondimension attributecolumns have compatible and incompatible relationships. If an incompatible combination is set, an error will occur during Run Preview and Job Setting.
For example, if the UNIQUE_REACH_IMPRESSIONS column is incompatible with the dimension being specified, the following statement will be printed in the error log
ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'UNIQUE_REACH_IMPRESSIONS'

Please refer to the links below for compatibility information on each.
「Compatible with ...」The compatible report types are listed in the " Report Type " section.

Dimension: enum Dimension (v202311)
Dimension Attribute: enum DimensionAttribute (v202311)
Column: enum Column (v202311)

Setting items

STEP1 Basic settings

item name	indispensable	default value	Contents
Google Ad Manager Connection Configuration	Yes	-	Select the preregistered Google Ad Manager Connection Configuration that has the necessary permissions for this ETL Configuration.
network code	Yes	-	Enter the trailing number that appears when you log in to Google Ad Manager. (e.g., `1234` at URL `https://admanager.google.com/1234#home` when logged in)
Data acquisition period	Yes	-	Enter the starting and ending periods of the data you wish to retrieve in the "YYYY-MM-DD" format.
dimension	Yes	-	Enter the fields for grouping the results. For more information, please refer to the official documentation.
dimension attribute	No	-	Items can be added according to dimensions. For more information, please refer to the official documentation.
column (esp. in chemistry, file, equipment, etc.)	Yes	-	Enter the column name of the data you wish to display. For more information, please refer to the official documentation.
Ad unit hierarchy to be acquired	Yes	Only the highest-level ad units are displayed	Only the highest-level ad units are displayed Select this option if you wish to display only the highest-level ad in the ad unit. The metrics will output a total value that includes ad units other than the highest ranked. Hierarchical display of all ad units Select this option if you wish to display ad units in a hierarchical manner. When AD_UNIT_NAME and``AD_UNIT_ID are specified as dimensions, data for 5 levels is output.

item name

indispensable

default value

Contents

Google Ad Manager Connection Configuration

Yes

Select the preregistered Google Ad Manager Connection Configuration that has the necessary permissions for this ETL Configuration.

network code

Yes

Enter the trailing number that appears when you log in to Google Ad Manager.
(e.g., 1234 at URL https://admanager.google.com/1234#home when logged in)

Data acquisition period

Yes

Enter the starting and ending periods of the data you wish to retrieve in the "YYYY-MM-DD" format.

dimension

Yes

Enter the fields for grouping the results.
For more information, please refer to the official documentation.

dimension attribute

Items can be added according to dimensions.
For more information, please refer to the official documentation.

column (esp. in chemistry, file, equipment, etc.)

Yes

Enter the column name of the data you wish to display.
For more information, please refer to the official documentation.

Ad unit hierarchy to be acquired

Yes

Only the highest-level ad units are displayed

Only the highest-level ad units are displayed
- Select this option if you wish to display only the highest-level ad in the ad unit.
- The metrics will output a total value that includes ad units other than the highest ranked.
Hierarchical display of all ad units
- Select this option if you wish to display ad units in a hierarchical manner.
- When AD_UNIT_NAME and``AD_UNIT_ID are specified as dimensions, data for 5 levels is output.

Data Source - Google Ad Manager

summary

constraints

Setting items

STEP1 Basic settings

What's Next