Alooma can read and replicate all of the Google Adwords report data from your Google Adwords account, as well as any children accounts. This allows you to merge ad data with other data such as customer usage data in your data warehouse.
Alooma provides a way for you to pull your Google Adwords data using Google's Adwords API. Alooma pulls the Adwords data daily for a configurable number of days back to account for attribution.
Google Adwords has "advertiser accounts" and "manager accounts." The API requires a manager account in place even if you only have one advertiser account associated. Without a managerial account Alooma cannot connect to Google Adwords. See https://support.google.com/adwords/answer/6139186 for more information about manager accounts.
When setting up this integration you can choose to import historical data, in which case Alooma will retrieve historical data from that date.
You can connect Google Adwords to Alooma in just a few steps:
Add your Adwords input from Alooma's plumbing screen.
Connect to Google and select the account which is associated with Adwords. Note this must be a manager account with at least one linked advertiser account.
Supply the following information:
Name - We’ll use the input name in the UI and to name the events that come from this input. Note that after creation, input name can’t be changed.
Customer ID - 10 digits separated by dashes, like XXX-XXX-XXXX. Learn how to find your Customer ID. We'll pull data from any children accounts that exist by default.
Report type - Defines the available report fields. Check out the Report Types Chart for help picking the right report type.
Report fields - The columns that will come back with your report. You can search by either the field label or the API name.
Choose how many days of data you'd like Alooma to pull on every connection. The default is 30 days, to account for attribution.
Indicate whether you'd like to include data which reflects zero impressions.
Choose whether you'd like to import historical events (if not, we'll pull 30 days in the past by default).
Choose whether you'd like a stopping point for the input.
Keep the mapping mode to the default of OneClick if you'd like Alooma to automatically map the Google Adwords events directly to your target data warehouse. Otherwise, they'll have to be mapped manually from the Mapper screen.
That's it! You're ready to pipe Google Adwords data into Alooma.