Google Ads Account provides a history of the settings of your Google Ads Accounts, Ad Groups, Ads, Campaigns, and Labels.
Supported Account typeslink
There are two types of Google Ads accounts. Each account type has its specific access level.
A manager account 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 the Google Ads website.
A client account only has access to information stored within its account. Initially, when you create a client account, it does not have access to the API. To get API access, the client account needs to be associated with a Google Ads manager account. Once you’ve associated your client account, you (and Fivetran) can query data for your client account. If you do not already have a manager account, you need to create one by following Google’s instructions.
The following image illustrates the relationship between the client and manager accounts.
The following image illustrates how the accounts get mapped to your destination table:
Follow our step-by-step Google Ads Account setup guide to connect Google Ads Account with your destination using Fivetran connectors.
This connector uses two types of data sync:
- A historical data sync fetches all data from the customer’s Google Account using the Google Ads API. Usually, a historical sync starts automatically after the connector is created, or when a historical sync is manually triggered in your Fivetran Dashboard.
- An incremental sync runs on a customer-defined schedule and updates only data that has changed since the last sync. During the incremental sync, the connector uses the AdWords API Sync Service to retrieve the changed entities and track the last change timestamp.
The connector additionally triggers a historical sync under the following conditions:
- More than 90 days have passed since the last sync AdWords API Sync Service only supports queries for dates within the last 90 days. If, for any reason, the last sync was more than 90 days ago, the connector will trigger a historical sync.
- Too many changes in the account There are too many changed entities in the account to return. All attempts to narrow the date range and retry the request were unsuccessful. The connector assumes everything has changed and triggers a historical sync.
NOTE: The connector cannot sync video campaign data, because the Google AdWords API does not support it (see AdWords API CampaignService). Some data from video campaigns can be collected by using the Google Ads reporting connector for the Video Performance report.
This schema applies to all Google Ads Account connectors.
NOTE: The money amount field values are stored in micros for the following tables:
One million micros is equivalent to one unit of a local currency. For example, $180.00 equals 180000000 micros. For more information, see AdWords API Reference documentation.