How to Setup Google AdWords Integration

This integration will allow you to connect with Google AdWords and start collecting your AdWords campaign data. It is a matter of minutes to send your advertisment data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting Google AdWords
  2. Set the Replication Frequency
  3. Load your Google AdWords data into your data warehouse
  4. Google AdWords expected Data Model and schema

Getting Started – Setup Google AdWords integration at Blendo

1. To add this integration, go to Blendo dashboard. Click “Add a Source”

Setup Google AdWords integration

2. In the new “Setup your Google AdWords source” screen click on Connect with Google AdWords.

Setup Google AdWords integration

3. If you’re not already logged into your Google AdWords account, you will be prompted to connect to your Google Account credentials.

Setup Google AdWords integration

4. Login to your Google account.

5. In the next page you will need to add your Customer ID from Google AdWords.

Setup Google AdWords integrationSettings you need from Google AdWords

We will need the Customer ID from Google AdWords.

6. Login to your Google AdWords campaign management dashboard from a new tab.

7. The Customer ID is on your top right side. Select it and copy it.

Setup Google AdWords integration

8. Paste the Customer ID into the relevant box provided in Blendo.

Setup Google AdWords integration

Set the Historical data sync

Select the starting date for the historical data sync of your Google AdWords integration. Data which are newer than this date will be replicated to your data warehouse.

9. At the Historical Data drop down, select the time frame of the historical ads data to get.

Setup Google AdWords integration - historical data

Set the Attribution window

10. At the Attribution Window drop down, select the attribution window of your AdWords data.

Setup Google AdWords integration - attribution window

Click Validate & Save.

11. Then you will return back to the home dashboard. Click on your new Google AdWords data source.

Setup Google AdWords integration

Set the Replication Frequency

12. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

 

13. In the next pop-up select one of the options available and click Apply.

Load your Google AdWords data into your data warehouse

Blendo will start loading your data from Google AdWords automatically according to its closest schedule. If you want to do it manually,  here is how to start loading your Google AdWords data into your data warehouse:

Load Google AdWrods data into data warehouse

Expected Google AdWords Data

Getting your Google AdWords data is one thing. What about these data, though? Let’s see:

How Blendo syncs Google AdWords data
The tables with Google AdWords data that we create in your destination data warehouse

How Blendo syncs Google AdWords data

Historical Data
When Blendo first connects to Google AdWords Data source, will pull all your historical data.
Sync Schedule
Blendo syncs Google AdWords data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process
The first time Blendo syncs your Google AdWords data performs a full replication. Then your Google AdWords data is replicated incrementally. Meaning that Blendo will replicate only new and updated rows to your destination data warehouse.

What Google AdWords data do I have available?

Bellow are some of the tables with Google AdWords data that we create in your target data warehouse.

Expected Google AdWords Data Model & Schema Information

Google AdWords Data Model & Schema

Ad Groups

Table Name: ad_groups

The table contains information about bounced people for your Ad Groups

Primary Key: Id

Columns of this table include: Name, CampaignName, labels, BaseCampaignId.

Campaigns

Table Name: campaigns

The table contains information about the Campaigns for your Google AdWords account.

Primary Key: id

Columns of this table include: name, startDate, frequencyCap.

Report: Click Performance

Table Name: click_performance_report

This table contains information about your Google AdWords Click Performance Reports.

Columns of this table include: AccountDescriptiveName, AdGroupStatus, CampaignId, Clicks, ClickType.

Report: Keywords Performance

Table Name: keywords_performance_report

This table contains information about your Google AdWords Keywords Performance Reports.

Columns of this table include: ActiveViewImpressions, AverageCost, AverageCpc, CampaignName, KeywordMatchType.

Report: Placement Performance

Table Name: placement_performance_report

This table contains information about your Google AdWords Placement Performance Reports.

Columns of this table include: AverageCpc, AdGroupStatus, Clicks, Device, Ctr.

Expected Google AdWords Data Model & Schema Information

Google AdWords Data Model & Schema

Questions? Contact us!

in Connecting SaaS Data Sources