Google Adwords

Introduction

The Connector for Google AdWords provide easy access to Google AdWords data, including Campaigns, AdGroups, Performance, and more.

References: https://developers.google.com/adwords/api/docs/guides/signup https://developers.google.com/adwords/api/docs/guides/authentication

Connection String

Google AdWords uses the OAuth authentication standard. In addition to the connection string Parameters, the Callback URL also should be specified for this connector. Set the OAuth Properties (OAuth Client ID and OAuth Client Secret) ,Developer Token and ClientCustomerId. Set the CallBack URL also for this Connector. Once the Callback URL is set the OAuthAccessToken will be generated in the Connection string when you verify the Connection using the VERIFY CONNECTION option.

Connection String parameters

Parameter Description
ClientCustomerId The client customer Id of the AdWords account.
OAuth Client Id The client Id assigned when you register your application with an OAuth authorization server.
OAuth Client Secret The client secret assigned when you register your application with an OAuth authorization server.
InitiateOAuth Set this property to initiate the process to obtain or refresh the OAuth access token when you connect.
OAuthRefreshToken The OAuth refresh token for the corresponding OAuth access token.

Connecting to Google Adwords

In order to create a connection to google adwords, you must create google account for management of google ad words. If you have not, follow this links instructions before proceeding: https://support.google.com/adwords/answer/6139186?visit_id=1-636379339582387609-607013934&rd=1 Keep in mind that manager accounts cannot be created using the same email address as an existing AdWords account. You must therefore use an email address that hasn’t already been associated with an AdWords account to create your manager account.

  1. Log in to https://adwords.google.com and, with your Managed account, find your ‘Customer ID’ at the top right of the page. This will correspond to the ‘Client Customer Id’ parameter on your connection string. Each connector can only interact with a single managed account.

  2. Click the gear icon on top right. From the resulting drop down menu, click ‘Account settings’.

  3. Select the ‘AdWords API Center’ from the left tabs.

  4. Fill in the resulting form and submit it to apply for an API token. The result produces a developer token to go with your application. Copy this value and write it into your connection string as the ‘Developer Token’.

  5. The next step is to authorize your management account for basic API access. On your AdWords tab, click ‘Apply for basic access’.

    Fill in the resulting form according to your specific companies planned usage.

Data Migrations

To Check for the data migrations:

  1. Add a new connection in data governor as shown.

    • Go to tasks and click on Connections.

    • Add a new connection Using Add New Connection Option.

    • Choose GoogleAdwords Connector from the available Connector Options.

  2. Using the connection string parameters created, Verify the connection using the VERIFY CONNECTION Option in Data Governor.

    After Clicking Verify Connection the OAuth Tokens are generated in the Connection String , You will be taken to the following Window. Choose the account, and give access by clicking on allow. You will be displayed with authorization successful window.

    Once the Connection is verified, Insert the Connection Using Insert Option.

  3. Create a Job Using ADD A JOB option in data governor, add a data migration task to the job.

  4. Create a New Task by right clicking job list and then Add a New Task Option. If you want to edit an Existing Task Use Edit Task.

  5. Choose a Data Migration Task.

  6. Choose the source and the destination for the migration of data. Name the Task.

  7. Choose the Tables or the data that need to be migrated from the source to the destination. You can Copy all Tables by checking Copy all tables box.

  8. Execute the Job. Check for results and the details of the data migrated in Execution History.

Data Model

Although higher version of the schema may exist, this is the most recent data model.

Views

Views are typically read-only data sources. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Name Description
AccountPerformance The Account Performance report includes all statistics aggregated by default at the account level, one row per account.
AdCustomizersFeedItem The Ad Customizers Feed Item report provides statistics for feed items used in Ad Customizers. Statistics are aggregated at the feed item level, one row per feed item.
AdgroupPerformance The Ad Group Performance report includes all statistics aggregated by default at the ad group level, one row per ad group.
AdPerformance The Ad Performance report includes all statistics aggregated at the ad level, one row per ad.
AgeRangePerformance The Age Range Performance report includes all display network statistics aggregated by age range. It also includes automatic audience performance.
AudiencePerformance The Audience Performance report includes performance data from interests and remarketing lists for display ads, and remarketing lists for search ads (RLSA), aggregated at the audience level, one row per audience.
AutomaticPlacementsPerformance The Automatic Placements Performance report includes all statistics aggregated at the placement level, one row per placement.
BidGoalPerformance The Bid Goal Performance report includes statistics for your bid strategies.
BudgetPerformance The Budget Performance report includes all statistics aggregated by default at the budget level, one row per budget.
CallMetricsCallDetails The Call Metrics Call Details report includes call details for your call extension including call duration and the caller’s area code.
CampaignAdScheduleTarget The Campaign Ad Schedule Target report summarizes the performance of campaigns by AdSchedule criteria.
Campaign-criteria-report Retrieves Campaign-criteria-report report data.
Campaign-group-performance-report Retrieves Campaign-group-performance-report report data.
CampaignLocationTarget The Campaign Location Target Report summarizes the performance of campaigns by location-based CampaignCriterion.
CampaignNegativeKeywordsPerformance Although negative keywords do not hold statistics, you can use this structured report to efficiently retrieve attributes of keyword-based NegativeCampaignCriterion objects.
CampaignNegativeLocations Although negative locations do not hold statistics, you can use this structured report to efficiently retrieve attributes of location-based NegativeCampaignCriterion objects.
CampaignNegativePlacementsPerformance Although negative placements do not hold statistics, you can use this structured report to efficiently retrieve attributes of placement-based NegativeCampaignCriterion objects.
CampaignPerformance The Campaigns Performance report includes all statistics aggregated by default at the campaign level, one row per campaign.
CampaignSharedSet The Campaign Shared Set report includes all relationships between SharedSets and campaigns.
ClickPerformance The Click Performance report includes stats aggregated at each click level, and includes both valid and invalid clicks. The KeywordId field will return any criteria that triggered the click, not just keywords.
CreativeConversion Free clicks are interactions that take place before a clickthrough for video ads, display ads, product extensions and location extensions, interactions like a Video play or a Get directions.
CriteriaPerformance The Criteria Performance report includes statistics aggregated at the ad group criteria level, one row per ad group and criteria combination.
DestinationUrl The Destination URL report includes all statistics aggregated at the destination URL level, one row per destination URL (specified on the keyword or the ad).
DisplayKeywordPerformance The Display Keyword Performance report includes all display network statistics aggregated at the keyword level, one row per keyword.
DisplayTopicsPerformance The Display Topics Performance report includes all display network statistics aggregated at the topic level, one row per topic.
FinalUrl The Final URL report includes all statistics aggregated at the final URL level, one row per final URL. If other segment fields are used, you may get more than one row per final URL.
GenderPerformance The Gender Performance report includes all statistics aggregated by gender. It also includes automatic audience performance.
GeoPerformance The Geo Performance report includes all statistics aggregated at the country/territory level, one row per country/territory.
KeywordlessCategory The Keywordless Category Performance report includes keywordless ads (dynamic search ads) statistics aggregated by category.
KeywordlessQuery The Keywordless Query report includes keywordless ads (dynamic search ads) statistics based on search terms.
KeywordsPerformance The Keywords Performance report includes all statistics aggregated at the keyword level, one row per keyword.
Label The Label report is a structure report that lists all labels for your account.
PaidOrganicQuery The Paid and Organic Query report provides a holistic view of your search stats across ads and organic listings at the query level. This lets you analyze strengths and gaps in your overall search presence, and gives insight into how your paid and organic search listings work together to connect your business with people searching on Google.
ParentalStatusPerformance The Parental Status Performance report includes statistics aggregated at the parental status level, one row per parental status
Placeholder The Placeholder Report provides statistics for feed-based ad extensions, one row per placeholder type.
PlaceholderFeedItem The Placeholder Feed Item report includes all statistics at the feed-item level (e.g., a single sitelink).
PlacementPerformance The Placements Performance report includes all statistics aggregated at the placement level, one row per placement.
ProductPartition The Product Partition report provides shopping campaign statistics aggregated at the product partition (Id field) level.
SearchQueryPerformance The Search Terms report includes all statistics aggregated at the search terms level, one row per combination of search terms.
SharedSet The Shared Set report includes all SharedSets that can be shareable across campaigns.
SharedSetCriteria The Shared Set Criteria report includes criteria for each SharedSet.
ShoppingPerformance The Shopping Performance report provides shopping campaign statistics aggregated at the product (OfferId field) level.
TopContentPerformance Retrieves TopContentPerformance report data.
UrlPerformance The URL Performance report includes all statistics aggregated at the URL and criterion level.
UserAdDistance The User Ad Distance Report provides statistics aggregated by the user’s distance from your location extensions.
VideoPerformance The Video Performance report includes statistics for your account’s upgraded AdWords for Video campaigns.