Google AdWords

Step-by-step guide to ingest your Google AdWords data into RudderStack

​Google AdWords is Google's premier online advertising platform. It allows advertisers to display their advertisements, as well as service offerings and product listings to prospective customers. With AdWords, you can place your ads within Google's search results, and also on your websites, mobile apps and videos. Google Adwords offers these advertisement services under a PPC (pay per click) model.
This document guides you in setting up Google AdWords as a source in RudderStack. Once configured, RudderStack automatically ingests your specified Google AdWords data, which can then be routed to your data warehouse destination supported by RudderStack.
All the Cloud Extract sources support sending data only to a data warehouse destination.
Getting Started
To add Google AdWords as a source in RudderStack, follow these steps:
Log into your RudderStack dashboard.
From the left panel, select Sources. Then, click on Add Source, as shown:
Next, select Google Analytics from the list of Cloud Sources, and click on Next.
Assign a name to your source, and click on Next.
Setting Up the Connection
Click on Connect with Google AdWords and give RudderStack the required access permissions. Then, click on Next.
If you have already connected RudderStack to your Google AdWords account, your credentials should appear automatically under Use existing credentials.
Configuring the Source Settings
After successfully connecting RudderStack to your Google AdWords account, the customer IDs associated with this account will automatically appear in the dropdown menu of the Customer ID, where you can select one. You also need to select a Start Date for your pipeline, which specifies the earliest date that RudderStack will start importing your AdWords data from. 
Please note that this Start date is valid only for the first (historical) sync.
Setting the Data Update Schedule
Next, you will be required to set the Run Frequency to schedule the data import from your Google AdWords account to RudderStack. You can also specify the time when you want this synchronization to start, by choosing the time under the Sync Starting At option.
Specifying the Data to Sync
Next, you need to specify the data you want RudderStack to import. By default, all the data resources are selected.
That's it! Google AdWords is now successfully configured as a source on your RudderStack dashboard. 
RudderStack will start importing data from Google AdWords as per the specified frequency. You can further connect this source to your data warehouse by clicking on Connect Destinations or Add Destinations, as shown:
Use the Connect Destinations option if you have already configured a data warehouse destination in RudderStack. To configure a data warehouse destination from scratch, click on the Add Destination button.
What Google AdWords data does RudderStack Import?
Property
Table Name
Description
Ad Groups
ad_groups
This table contains information about the bounced people for your Ad Groups. The columns in this table include: Name, CampaignName, labels, BaseCampaignId with Id being the primary key.
Campaigns
campaigns
This table holds information information about your campaigns for your Google AdWords account. The columns in this table are: name, startDate, frequencyCap with id being the primary key.
Report: Keywords Performance
keywords_performance_report
This tables has information about your Google AdWords keywords' performance. The columns in this table are: ActiveViewImpressions, AverageCost, AverageCpc, CampaignName, KeywordMatchType
Report: Click Performance
click_performance_report
This table contains information about your Google AdWords' click performance. Columns include: AccountDescriptiveName, AdGroupStatus, CampaignId, Clicks, ClickType
Report: Placement Performance
placement_performance_report
This table contains the performance of your Google AdWords' placement. The columns in this table are: AverageCpc, AdGroupStatus, Clicks, Device, Ctr.
FAQs
Is it possible to have multiple Cloud Extract sources writing to the same schema?
Yes, it is. 
We have implemented a feature wherein RudderStack associates a table prefix for every Cloud Extract source writing to a warehouse schema. This way, multiple Cloud Extract sources can write to the same schema with different table prefixes.
Contact Us
If you come across any issues while configuring Google AdWords as a source on the RudderStack dashboard, please feel free to contact us. You can also start a conversation on our Slack channel; we will be happy to talk to you!

Freshdesk

Google Analytics

Last updated 1 month ago

Property	Table Name	Description
Ad Groups	`ad_groups`	This table contains information about the bounced people for your Ad Groups. The columns in this table include: `Name`, `CampaignName`, `labels`, `BaseCampaignId` with `Id` being the primary key.
Campaigns	`campaigns`	This table holds information information about your campaigns for your Google AdWords account. The columns in this table are: `name`, `startDate`, `frequencyCap` with `id` being the primary key.
Report: Keywords Performance	`keywords_performance_report`	This tables has information about your Google AdWords keywords' performance. The columns in this table are: `ActiveViewImpressions`, `AverageCost`, `AverageCpc`, `CampaignName`, `KeywordMatchType`
Report: Click Performance	`click_performance_report`	This table contains information about your Google AdWords' click performance. Columns include: `AccountDescriptiveName`, `AdGroupStatus`, `CampaignId`, `Clicks`, `ClickType`
Report: Placement Performance	`placement_performance_report`	This table contains the performance of your Google AdWords' placement. The columns in this table are: `AverageCpc`, `AdGroupStatus`, `Clicks`, `Device`, `Ctr`.