Google Ads offers a list of available reports and their columns/dimensions/metrics.
Through the setup wizard you're able to configure your Google Ads connection to query each account - no matter how many you have - and combine them into a single report/table within your destination.
You can also load data from different Google Ads accounts into separate schemas within your destination by selecting the relevant accounts and reports you want to load into the schema.
While configuration in the UI, many fields within Google Ads reports cannot be selected in conjunction with other fields, so rather than simply selecting all fields of a report, you may want to review the above link to figure out exactly which metrics you want to sync.
Because of this limitation, if it's imperative that you receive fields that conflict with one another, you may need to set up two Google Ads connections for the same report, syncing into two different table names (as you can't have more than one table with the same name in the same schema).
*When requesting your fields, you'll also need to add in "date" as a field, as we require this for incremental updates.
Supported Account types
There are two types of Google Ads accounts. Both determine the level of access they have.
Manager account (former MCC - My Client Center) is a Google Ads account type for advertisers or agencies who are managing multiple client accounts. You can read more about a Manager account's access levels on Google Ads's website.
Client accounts only have access to information stored within their account. A normal client account does not begin with access to the API. It needs to be associated with an Google Ads manager account, and only then does it receive API access, allowing you (and Fivetran) to query data for that original account. If you don't already have one of these accounts, you'll need to create one by following Google's instructions.
The following image illustrates the relationship between individual and manager accounts.
The following image illustrates how the accounts get mapped to your destination table:
Follow our step-by-step Google Ads setup guide to connect Google Ads with your destination using Fivetran connectors.
A conversion window is the period of time after a person interacted with your ad during which the subsequent actions, like a phone call or a purchase, are recorded in Google Ads. By default, Google Ads uses a conversion window of 30 days. If you use the default setting, your reports contain information about the actions that happened within 30 days after a person interacted with your ad.
Since you can specify custom window size for your conversion trackers, you may want to set the same conversion window size in your Google Ads connector. You can set the window size manually in the range of 1 to 90 days, or let Fivetran detect it automatically.
Fivetran performs automatic window detection before each sync. Automatic window detection finds the maximum window size across all the conversion trackers available for the specified accounts. It adds some extra time to each sync, depending on the number of accounts you want to sync.
Note: If you set your window size manually and select a window size smaller than what you set in Google Ads, you will lose some conversion data. If you select a window size bigger than you have, there will be some excessive syncs leading to an unwanted increase in your Monthly Active Rows.
We provide two types of reports:
- Prebuilt Report
- Custom Report
For either kind of report, we deliver a single table with three standard fields:
A Prebuilt Report syncs a pre-defined set of fields. See the full list of our Prebuilt Reports.
To get a Custom Report, you must select the report type and the fields you wish to sync.
Type transformations and mapping
Fivetran transforms types. If there is an important type that we are missing that you need, please reach out to support.
Because Google Ads data is delivered as a pre-defined report, changing the way that it is formatted is a little tricky. Adding or removing fields changes the way the data is aggregated and synced, which requires you to delete the existing table from your destination and perform a full resync of the data.
These steps can get complicated and increase the chances of an error, so we urge you to create an entirely new integration, perhaps syncing into a different schema.
Reports do not support deleted rows because they often record events and data chronologically, so it is impossible to delete data that has already been logged.
Syncing empty tables and columns
Fivetran can sync empty tables and columns for your Google Ads connector. For more information, see our Features documentation.