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 setup instructions 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 docid\ jvybwq5ydjrq3ajxuqghs how to find customer id 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 supported account types 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 issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com conversion window 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 zero impression 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 replicated entities 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