Google Adwords Collect Slice

Overview

Google Adwords is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web users.

The Datacoral Google AdWords slice collects data from an Google AdWords account and enables data flow from an Google AdWords API into a data warehouse, such as Redshift.

Steps to add this slice to your installation

The steps to launch your slice are:

1. Generate Google AdWords API keys
2. Contact our support team (support@datacoral.co) to add the slice to your installation

1. Generate Google AdWords API keys

Setup requirements

Before getting started please make sure to have the following information:

• Access to an active Google AdWords account

Setup instructions

The Google Adwords slice requires some api credentials to collect data. API credentials can be obtained from Google Adwords through the following steps:

1. Sign in to your Google Ads account
2. Click the help icon in the top right corner.
3. Find "Customer ID" at the bottom of the menu.
4. Copy the Customer ID.
5. Then go to the TOOLS > SETUP > API Center Note: make sure you've signed in as a Manager or you won't be able to access the API Center.
6. Copy the Developer token.
7. Open the Google API Console Credentials page.
8. From the project drop-down, select an existing project or create a new one.
9. On the Credentials page, select Create credentials, then select OAuth client ID.
10. Under Application type, choose Web application.
11. Under Authorized redirect URIs, add a line with: https://developers.google.com/oauthplayground
12. Click Create.
13. On the page that appears, copy the Client ID and Client secret to your clipboard.
14. Refresh Token can be generated on the OAuth2 Playground

Necessary input parameters:

• adwordsDeveloperToken - developer token
• adwordsClientId - OAuth2 client ID
• adwordsSecret - OAuth2 client secret
• adwordsRefreshToken - OAuth2 refresh token
• adwordsClientCustomerId - customer id
• adwordsUserAgent - your unique string, for example example.com:ReportDownloader:V7.18

2. Contact support

Currently addition of adwords slice is unavailable via CLI or UI. This means you cannot add this slice to your installation yourself. Once you have the required information (Step 1 above), contact our support team (support@datacoral.co) to add the slice.

Supported load units

The Google AdWords slice automatically collects the following loadunits from the Google AdWords API and makes them available in your warehouse for analysis.

• adwords_adgroupperformance: represents the Adgroup Performance Report
• adwords_adgroupperformance1: represents the Adgroup Performance Report
• adwords_adgroupperformance2: represents the Adgroup Performance Report
• adwords_adgroupperformance3: represents the Adgroup Performance Report
• adwords_adgroupperformance4: represents the Adgroup Performance Report
• adwords_adgroupperformance5: represents the Adgroup Performance Report
• adwords_geoperformance: represents the Geo Performance Report

Slice output

Output of this slice is stored in S3 and Redshift.

AWS S3 Data stored in AWS S3 is partitioned by date and time s3://customer_installation.datacoral/<slice-name>

AWS Redshift: Schema - schema name will be same as a slice-name. Tables produced by the slice dynamically based on the loadunits configured.

 - schema.adwords_adgroupperformance
 - schema.adwords_adgroupperformance1
 - schema.adwords_adgroupperformance2
 - schema.adwords_adgroupperformance3
 - schema.adwords_adgroupperformance4
 - schema.adwords_adgroupperformance5
 - schema.adwords_geoperformance

Questions? Interested?

If you have questions or feedback, feel free to reach out at hello@datacoral.co or Request a demo