Google Ads
Google Ads enables marketers to find the right audience for their advertisements through ads across Google. Ads are shown where targeted customers are browsing and watching for highly effective marketing.
DLH.io brings your Google Ads data to your target destination of choice so that you can integrate campaign data, etc. with other data concepts in your CRM, ERP, and marketing automation tools for purposes of attribution, RevOps, or just historical tracking and storage of data outside of Google.
DataLakeHouse.io securely connects to your account. Using the form in the DataLakeHouse.io portal please complete the following basic steps:
- Enter a Name or Alias for this connection, in the Name/Alias field, that is unique from other connectors
- Enter a Target Schema Prefix, which will be the prefix for the schema at the target you will sync your data files into
- Enter a Customer Id, for your Google Ad account for which you wish to sync data
- Click the Authorize Your Account button. Once your credentials are accepted you should be able to see a successful connection, then you can Create a Sync Bridge
Your customer ID is a unique number used to identify your Google Ads account. The number is in the format of ###-###-#### and there are several ways to locate the Customer ID in your Google Ads account:
- To left of your Account Name in the navigation panel
- In the upper right corner in the navigation panel
There are two types of Google Ads accounts. Each account type has its specific access level.
1. Manager accounts
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 Google Ads's website.
2. Client accounts
The client accounts only have access to information stored within their account. Initially, when you have created a client account, it does not have access to the API. To get the API access, the client account needs to be associated with a Google Ads manager account. Once it has been done, you (and DLH.io) 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.
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 DLH.io detect it automatically.
IMPORTANT: Changing the conversion window size for the connector only changes the length of a rollback sync. It does not affect the conversion window settings in your Google Ads account.
DLH.io performs an automatic window detection before each sync. The automatic window detection finds the maximum window size across all the conversion trackers available for the specified accounts. It adds some extra time for each sync to complete which depends on the number of accounts you want to sync.
NOTE: The same conversion window applies to all reports configured in the connector.
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.
The Google Ads API returns rows with zero metric values only if the report does not contain segments. If the report contains segments, the rows with zero metric values are excluded.
ACCOUNT_HISTORY ACCOUNT_HOURLY_STATS ACCOUNT_STATS AD_GROUP_BIDDING_STRATEGY_HISTORY AD_GROUP_HISTORY AD_GROUP_HOURLY_STATS AD_GROUP_STATS AD_HISTORY AD_POLICY_TOPIC_EVIDENCE_HISTORY AD_POLICY_TOPIC_HISTORY AD_STATS AUDIENCE_STATS CAMPAIGN_BIDDING_STRATEGY_HISTORY CAMPAIGN_BUDGET_HISTORY CAMPAIGN_CRITERION_HISTORY CAMPAIGN_DYNAMIC_SEARCH_ADS_SETTING_HISTORY CAMPAIGN_GEO_TARGET_TYPE_SETTING_HISTORY CAMPAIGN_HISTORY CAMPAIGN_HOURLY_STATS CAMPAIGN_NETWORK_SETTING_HISTORY CAMPAIGN_OPTIMIZATION_GOAL_SETTING_HISTORY CAMPAIGN_STATS GEO_TARGET KEYWORD_STATS SMART_CAMPAIGN_AD_HISTORY
