Skip to main content
Feedback

Google Ads walkthrough

info

Google Ads API version 17 is currently supported.

Google Ads helps businesses reach potential customers. Data Integration consolidates data from multiple sources into a centralized data warehouse. Integrating Google Ads with Data Integration streamlines data management and improves marketing analytics.

Connection

To connect Google Ads with your destination, follow our step-by-step tutorial. After creating a connection, choose a Source connection.

Predefined reports

Data Integration provides an entry point and recommended approach for accessing a range of predefined reports. Each report includes a data description, a list of customizable fields (if applicable), and the schema mapping.

Since these reports follow a standardized format, a few fields are locked and accessible only through Custom Reports.

Custom reports

Select a specific report to pull data from Google Ads.

You can execute Google Ads Custom Reports in one of the following options:

  • Report
  • Custom Query

Creating a report

Accounts: This shows a list of all the customers from whom data can be pulled in your Google Ads account. You can select one or more accounts, or leave them empty to pull data from all accounts.

You have two options:

  • Accounts - Auto Complete: Automatically pulls data for your entered connection.

  • Accounts—Manual: This option requires less time because you specify the account type from which to pull data.

Resource: Select a report from the list of reports.

  • To learn more about the available reports and their attributes and metrics, refer to the topGoogle Ads API reference.
  • For Migrating reports from Google Adwords.
note

When you select the Change Event resource, set a Custom Query Limit (optional) to specify the maximum number of records to retrieve.
The system defaults to 10,000 records if no value is entered.

Fields: Select fields for the chosen report. Some selections may turn off other incompatible fields.

info
  • Performance Max details are available only in Campaign reports, not Ads reports. To retrieve these, select Campaign reports and include metrics like campaign.advertising_channel_type, segments.date, and campaign_id.
  • After running the river, you can find the 'Performance Max details' in the campaign.advertising_channel_type column.

Filters: Select Add filters to apply filters. Choose a filter name, operator, and value for each filter. You can add the same filter more than once, with different values and operators as needed.

  • Selecting IN or NOT IN operators lets you insert multiple values in Filter Value field.
  • Selecting date type segments fields in Fields requires adding filters for these fields.

Extract Method: Selecting All if you want to pull the entire report (not incremental) or if there is no segment field with date type in the selected fields.

Selecting the Incremental, choose an incremental field and time period to run.

note

The reports with date type fields can only be incrementally extracted.

Time period for incremental loading

The Google Ads reports support two kinds of time period increments:

  1. Date range:
  • Pulls data in the date range between the start and end date provided, including the end date.
  • A Start Date is required.
  • Leaving the end date empty pulls 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 extend the start date backward and pull data several days before the chosen start date.
  1. Predefined date(canned date ranges):
  • 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.

The Start Date will not advance if a River run is unsuccessful. To change this default setting, click More Options and turn on the checkbox to advance the start date even if the River run is unsuccessful.

Interval chunks

Data Integration can run over the increment using chunks to make the loading efficient and precise. The chunking options are:

  1. Don't Split: Data Integration pulls the data from the chosen start date to the end date in one bulk.

  2. Daily: The run will be chunked daily from the start to the end date.

  3. Monthly: The run will be chunked monthly from the start to the end date.

  4. Yearly(Less Recommended): The run will be chunked yearly from the start to the end date.

Running a custom query

This mode pulls queries generated in the interactive Google Ads Query Builder.

note

Running a custom query can not be incremental like the Report mode. Instead, use the Query Builder to include a time filter.

Activity logs

The Activity Logs provide an inside perspective of the processes taking place in Google Ads River.

Difference between clicks and sessions

Some rows in Google Ads reports have no session data. This often happens when a Google Ads account is linked to a view that filters out specific traffic.

For example, if traffic to a specific landing page is filtered, the Google Ads information for those destination URLs is available, but basic metrics like Sessions and Bounce Rate can be missing. Learn more about the distinctions between a click and a session.

Troubleshooting errors

The HTTP Error Code 403 with the message "Permission Denied" indicates restricted access to the requested Google Ads resource.

To resolve this issue:

1. Log in to your Google Ads account

  • Ensure you are logged in to the correct Google Ads account.

2. Verify account status

  • Navigate to your Google Ads account dashboard.
  • Confirm that the account status is Active.
On this Page