Skip to main content

​
Intro

Google will sunset the Adwords API on April 27th 2022 in favor of their Google Ads API. As a result, Domo will deprecate its Google Ads connector (com.domo.connector.adwords.oauth) which relies on the Adwords API. See Google Ads Connector Deprecation document. Google Ads, previously known as Google Adwords, is an online advertising platform developed by Google, where advertisers bid to display brief advertisements, service offerings, product listings, or videos to web users. It can place ads both in the results of search engines like Google Search and on non-search websites, mobile apps, and videos. The Domo Google Ads connector provides the statistics about your campaigns, budgets, accounts, ads, and so on. This helps you to upgrade your business performance. You can connect to your Google Ads account in the Data Center. This topic discusses the fields and menus that are specific to the Google Ads connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Data Connector.

​
Prerequisites

To connect to your Google Ads account and create a DataSet, you must have the following:
  • Developer Token
  • Client ID
  • Client Secret

​
Connecting to Your Google Ads Account

This section enumerates the options in the Credentials and Details panes in the Google Ads 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 Data Connector.

​
Credentials Pane

This pane contains fields for entering credentials to connect to your Google Ads account. The following table describes what is needed for each field:

Field

Description

Developer Token

Enter the developer token. See here for instructions. The developer token needs to be approved by Google to access the production environments.

Warning: This connector only works with the developer token approved by Google. A test token will not work.

Client ID

Enter the client ID created in the Google Developer Console.
1. Open the Google API Console’s credentials page.
2. From the project drop-down, select the project you want to use for the client ID/secret.
3. Under Application type, select Web application.
4. Under Authorized redirect URIs, add a line, https://oauth.domo.com/api/data/v1/oauth/providers/adwords/exchange.

Client Secret

Enter the client secret associated with the client ID

Once you have entered valid Google Ads credentials, you can use the same account any time to create a new Google Ads DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

​
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 Ads report you want to run. The following reports are available:

Report Name Description
Account Performance Returns the statistics aggregated at the account level.
Ad Performance Returns the statistics aggregated at the ad level.
Ad Group Performance Returns the statistics aggregated at the ad group level.
Budget Performance Returns the statistics aggregated at the budget level.
Campaign Performance Returns the statistics aggregated at the campaign level.
Keywords Performance Returns the statistics aggregated at the keyword level.
Placement Performance Returns the statistics aggregated at the placement level.
Customer ID Enter a comma-separated list of the Customer ID’s for which you want to retrieve data for. Customer IDs are for your Google Ads advertiser accounts not for a manager account.
Segments Select the segments to breakdown the data.
Metrics Select the metrics you want to retrieve.
Currency Display Select if you want to display money amounts in micro units of local currency ($100.00->100,000,000.00) or local currency.
Date Range Select the date range for which you want to run the report.
Duration Select the duration for the report (a Single Date, or a Date Range).
Report Date Select the report date using relative or specific dates. Relative indicates the number of days from today or a specific date using the date selector.
Select Specific Date Select the report date using the date selector.
Days Back The number of days back that you would like to get the data for. Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past.
Start Date Select the report start date using relative or specific dates. Relative means the number of days from today or a specific date using the date selector.
Select Specific Start Date Select the report date using the date selector.
Days back to start from The number of days back that you would like to get data from (start day). Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past.
End Date Select the report end date using relative or specific dates. Relative means the number of days from today or a specific date using the date selector.
Select Specific End Date Select the report date using the date selector.
Days back to end at The number of days back that you would like to get data to (end day). Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past.

​
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 Data Connector.