Skip to main content

​
Intro

Google Ad Manager (formerly DoubleClick for Publishers) offers publishers a complete ad revenue engine, helping publishers streamline operations and capture the most value for every impression. To learn more about the API, visit their page (https://developers.google.com/ad-manager/api ). You connect to your Google Ad Manager account in the Data Center. This topic discusses the fields and menus that are specific to the Google Ad Manager Connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your Google Ad Manager account and create a DataSet, you must have a Google account with a username and password.

​
Connecting to Your Google Ad Manager Account

This section enumerates the options in the Credentials and Details panes in the Google Ad Manager Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most Connector types and are discussed in greater length in Adding a DataSet Using a Connector.

​
Credentials Pane

The Domo Google Ad Manager Connector uses OAuth to connect, so there is no need to enter credentials within Domo. Click Connect (or select Add Account if you have existing Google Ad Manager accounts in Domo) to open the Google OAuth screen where you can enter your Google credentials. Once you have entered valid Google credentials, you can use the same account any time you go to create a new Google DataSet. You can manage Connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector/Adapter Accounts.
Note: If you are already logged into Google when you connect in Domo, you are authenticated automatically when you click Add account. If you want to connect to an account that is different from the one you are logged into, you must first log out of Google.

​
Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu

Description

Report

Select the Google Ad Manager report you want to run. The following reports are available:

Report Name

Description

Ad Rule By Statement

Fetches the AdRule that satisfies the given query.

AdUnit By Statement

Fetches the AdUnits that satisfies the given query.

All Networks

Returns the list of Network objects to which the current login has access.

Audience Segment By Statement

Fetches the Audience Segment that satisfies the given query.

Cms Metadata Service

Returns the list of CMS metadata keys and values.

Company By Statement

Fetches the Companies that satisfies the given query.

Contacts By Statement

Fetches the Contacts that satisfies the given query.

Contents By Statement

Fetches the Contents that satisfies the given query.

Creative By Statement

Fetches the Creatives that satisfies the given query.

Creative Set By Statement

Fetches the CreativeSet that satisfies the given query.

Creative Templates By Statement

Fetches the CreativeTemplates that satisfies the given query.

Creative Wrappers By Statement

Fetches the CreativeWrappers that satisfies the given query.

Custom Fields By Statement

Fetches the CustomFields that satisfies the given query.

Custom Targeting Keys By Statement

Fetches the CustomTargetingKeys that satisfies the given query.

Labels By Statement

Fetches the Labels that satisfies the given query.

Line Item Templates By Statement

Fetches the Line Item Templates that satisfies the given query.

Line Items By Statement

Fetches Line Items that satisfies the given query.

Line Items By Statement With Targeting Details

Fetches the Line Items that satisfies the given query.

Line Items Creative Associations By Statement

Fetches the LineItems Creative Asso. that satisfies the given query.

Live Stream Events By Statement

Fetches the Live Stream Events that satisfies the given query.

Mobile Applications By Statement

Fetches the Mobile Applications that satisfies the given query.

Native Styles By Statement

Fetches the Native Styles that satisfies the given query.

Orders By Statement

Fetches the Orders that satisfies the given query.

Placements By Statement

Fetches the Placements that satisfies the given query.

Proposal Line Items By Statement

Fetches the Proposal Line Items that satisfies the given query.

Proposals By Statement

Fetches the Proposals that satisfies the given query.

Saved Query

Using the ReportService, a saved query is run and downloaded.

Suggested AdUnits By Statement

Fetches the Suggested AdUnits that satisfies the given query.

Team By Statement

Fetches Teams that satisfies the given query.

User Team Associations By Statement

Fetches the User Team Asso. that satisfies the given query.

Users By Statement

Fetches the Users that satisfies the given query.

Network Code

Select the network you want to retrieve information for.

AdUnit ID (optional)

Enter the ID for the AdUnit object you want to retrieve information for.

AdUnit Name (optional)

Enter the name of the AdUnit object you want to retrieve information for (255-character max).

AdUnit Code (optional)

Enter the code for the AdUnit object you want to retrieve information for.

AdUnit Status (optional)

Select a status to filter by, either Any Value , Active, Archived, or Inactive .

Last Modified Date (optional)

Select a last modified date in the date picker to filter by.

Company ID (optional)

Enter the ID of the company you want to retrieve information for.

Company Name (optional)

Enter the name of the company you want to retrieve information for. This field supports % wildcard characters.

Company Type (optional)

Select the type of company you want to retrieve information for.

ID (optional)

Enter the ID of the list item you want to retrieve information for.

Group ID (optional)

Enter the ID of the group you want to retrieve information for.

Name (optional)

Enter the name of the list item you want to retrieve information for. This field supports % wildcard characters.

Order IDs (optional)

Enter a comma-separated list of order IDs to retrieve information for. For example: 1234,9876,4565

External ID (optional)

Enter the external ID of the list item you want to retrieve information for. This field supports % wildcard characters.

Is Missing Creatives (optional)

Select Yes if the content you want to retrieve information for is missing creatives.

Is Set Stop Box Enabled (optional)

Select Yes if the set stop box is enabled for the content you want to retrieve.

Delivery Rate Type (optional)

Select the delivery rate type for the content you want to retrieve.

Cost Type (optional)

Select the cost type for the content you want to retrieve.

Line Item Type (optional)

Select the line item type for the content you want to retrieve.

Status (optional)

Select the status for the content you want to retrieve.

Creation Date Time (optional)

Select the date of creation in the date picker for the content you want to retrieve.

Duration (optional)

Select whether you want to pull data for a specific date, a date range, or not at all.

Report Date (optional)

Select whether the report data is for a specific date or for a relative number of days back from today.

Select Specific Date (optional)

Select the date for the report.

Days Back (optional)

Enter the number of past days that should appear in the report.

Start Date (optional)

Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in End Date .

End Date (optional)

Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in Start Date .

Select Specific Start Date (optional)

Select the first date in your date range.

Select Specific End Date (optional)

Select the second date in your date range.

Days Back to Start From (optional)

Enter the number of the farthest day back that should be represented in the report. Combine with Days Back to End At to create a range of represented days.

For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At , the report would contain data for 10 days ago up until 5 days ago.

Days Back to End At (optional)

Enter the number of the most recent day back that should be represented in the report. Combine with Days Back to Start From to create a range of represented days.

For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At , the report would contain data for 10 days ago up until 5 days ago.

Order ID (optional)

Enter the ID of the Order object you want to retrieve information for.

Order Name (optional)

Enter the name of the Order object you want to retrieve information for. This field supports % wildcard characters.

Advertiser ID (optional)

Enter the ID of the advertiser you want to retrieve information for.

Salesperson ID (optional)

Enter the ID of the salesperson you want to retrieve information for.

Trafficker ID (optional)

Enter the ID of the trafficker you want to retrieve information for.

Order Status (optional)

Select an order status to filter by.

Saved Query (optional)

Select the saved query you want to run.

Impressions Look Back (optional)

Enter the number of days (1 to 30) for which you want to retrieve view-through conversions for users who have viewed a DFP ad.

Clicks Look Back (optional)

Enter the number of days (1 to 30) for which you want to retrieve click-through conversions for users who have clicked on a DFP ad.

Priority (optional)

Enter the priority value for which you want to retrieve data. You can enter any value between 1 and 1000, with 1 being the highest priority.

Rate Card ID (optional)

Enter the ID of the rate card you want to retrieve data for.

Master Creative ID (optional)

Enter the ID of the master creative you want to retrieve data for.

Ordering

Select how you want your wrappers to be ordered.

Entity Type

Select the type of entity you want to retrieve data for.

Visibility

Select the visibility filter you want for your data.

Refresh Rate

Select the refresh rate you want to retrieve data for.

Direction Select the direction for your data.

​
FAQs

When calling the API to retrieve all the saved queries, if any of them have start dates older than 3 years then the call will fail. If you receive an error saying “ReportError.START_DATE_MORE_THAN_THREE_YEARS_AGO” while using the Saved Query report, then delete the saved queries from your Google Ad Manager account that have the start date older than 3 years.Which endpoint(s) does each report call in this connector?
Report Name Endpoint URL(s)
Ad Rule By Statement /AdRuleService
Ad Unit By Statement /InventoryService
All Networks /NetworkService
Audience Segment By Statement /AudienceSegmentService
CMS Metadata Service /CmsMetadataService
Company By Statement /CompanyService
Contacts By Statement /ContactService
Contents By Statement /ContentService
Creatives By Statement /CreativeService
Creative Set By Statement /CreativeSetService
Creative Templates By Statement /CreativeTemplateService
Creative Wrappers By Statement /CreativeWrapperService
Custom Fields By Statement /CustomFieldService
Custom Targeting Keys By Statement /CustomTargetingService
Labels By Statement /LabelService
Line Item Templates By Statement /LineItemTemplateService
Line Items By Statement /LineItemService
Line Items By Statement With Targeting Detail /LineItemTargetingService
Line Items Creative Associations By Statement /LineItemCreativeAssociationService
Live Stream Events By Statement /LiveStreamEventService
Mobile Applications By Statement /MobileApplicationService
Native Styles By Statement /NativeStyleService
Orders By Statement /OrderService
Placements By Statement /PlacementService
Proposal Line Items By Statement /ProposalLineItemService
Proposals By Statement /ProposalService
Saved Query Download /SavedQueryDownload
Suggested AdUnits By Statement /SuggestedAdUnitService
Team By Statement /TeamService
User Team Associations By Statement /UserTeamAssociationService
Users By Statement /UserService
You need a Google account with username and password.
The login process uses the OAuth process, so your credentials are never seen or stored by Domo. This keeps your login secure. You can revoke Domo’s access to your account at any time.
Yes
As often as needed.
No
Some Google Ad Manager reports are not compatible through the API. The most common reason is that it uses dynamic date ranges. You can configure the report to use static dates and then configure the connector to use dynamic dates. See Google Ad Manager Reporting Basics for more information.

​
Other Panes

For information about the remaining sections of the Connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Connector.