Google Ads

Google Ads ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

v4.2.0

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

AdWords Login Id Password

Replication Type

Key Based Incremental

Replication Key

Date

Suggested Replication Frequency

24 hrs

Tables/APIs Supported

AccountPerformanceReport

AdGroupPerformanceReport

CampaignPerformanceReport

GeoPerformanceReport

SearchQueryPerformanceReport

KeywordsPerformanceReport

CallMetricsCallDetailsReport

KeywordlessQueryReport

CriteriaPerformanceReport

ClickPerformanceReport

DisplayKeywordPerformanceReport

PlaceholderFeedItemReport

PlacementPerformanceReport

GenderPerformanceReport

AgeRangePerformanceReport

AudiencePerformanceReport

DisplayTopicsPerformanceReport

ShoppingPerformanceReport

PlaceholderReport

FinalURLReport

VideoPerformanceReport

Integrate Adwords with Daton

  1. Signin to Daton

  2. Select Adwords from Integrations page

  3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

  4. You will be redirected to Adwords login for authorizing Daton to extract data periodically

  5. Post successful authentication, you will be prompted to choose from the list of available Adwords Views

  6. Select a combination of Metrics and Dimensions

  7. Submit the integration

  8. For selecting additional combinations of Metrics and Dimensions, one has to create a new integration from step-2. One can select a maximum of 7 metrics and 10 dimensions in one combination

Workflow

  1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Adwords Data

AccountPerformanceReport

Purpose: The Account Performance report includes all statistics aggregated by default at the account level, one row per account. If other segment fields are used, you may get more than one row per account.

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/account-performance-report

Replication: Key-Based Replication

Replication Key: Date

AdGroupPerformanceReport

Purpose:The Ad Group Performance report includes all statistics aggregated by default at the ad group level, one row per ad group. If other segment fields are used, you may get more than one row per ad group

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/adgroup-performance-report

Replication: Key-Based Replication

Replication Key: Date

CampaignPerformanceReport

Purpose:The Campaigns Performance report includes all statistics aggregated by default at the campaign level, one row per campaign. If other segment fields are used, you may get more than one row per campaign.

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/campaign-performance-report

Replication: Key-Based Replication

Replication Key Date

GeoPerformanceReport

Purpose:The Geo Performance report includes all statistics aggregated at the country/territory level, one row per country/territory. If other segment fields are used, you may get more than one row per country/territory

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/geo-performance-report

Replication: Key-Based Replication

Replication Key: Date

SearchQueryPerformanceReport

Purpose:The Search Terms report includes all statistics aggregated at the search terms level, one row per combination of search terms. If other segment fields are used, you may get more than one row per combination of search terms

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/search-query-performance-report

Replication: Key-Based Replication

Replication Key: Date

KeywordsPerformanceReport

Purpose:The Keywords Performance report includes all statistics aggregated at the keyword level, one row per keyword. If other segment fields are used, you may get more than one row per keyword.

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report

Replication: Key-Based Replication

Replication Key: Date

CallMetricsCallDetailsReport

Purpose:The Call Metrics Call Details report includes data for call tracking of call-only ads or call extensions.

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/call-metrics-call-details-report

Replication: Key-Based Replication

Replication Key: Date

CriteriaPerformanceReport

Purpose:The Criteria Performance report includes statistics aggregated at the ad group criteria level, one row per ad group and criteria combination. If other segment fields are used, you may get more than one row per criteria. See segmentation for more information

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/criteria-performance-report

Replication: Key-Based Replication

Replication Key: Date

ClickPerformanceReport

Purpose:The Click Performance report includes stats aggregated at each click level, and includes both valid and invalid clicks.

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/click-performance-report

Replication: Key-Based Replication

Replication Key: Date

DisplayKeywordPerformanceReport

Purpose:The Display Keyword Performance report includes all Display Network and YouTube Network statistics aggregated at the keyword level, one row per keyword. If other segment fields are used, you may get more than one row per keyword.

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/display-keyword-performance-report

Replication: Key-Based Replication

Replication Key Date

PlaceholderFeedItemReport

Purpose:The Placeholder Feed Item report includes all statistics at the feed-item level (e.g., a single sitelink). If other segment fields are used, you may get more than one row per feed ite

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/placeholder-feed-item-report

Replication: Key-Based Replication

Replication Key: Date

PlacementPerformanceReport

Purpose:The Placements Performance report includes all statistics aggregated at the placement level, one row per placement. If other segment fields are used, you may get more than one row per placement

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/placement-performance-report

Replication: Key-Based Replication

Replication: Key Date

GenderPerformanceReport

Purpose:The Gender Performance report includes all statistics aggregated by gender. It also includes automatic audience performance. If other segment fields are used, you may get more than one row per gender

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/gender-performance-report

Replication: Key-Based Replication

Replication Key: Date

AgeRangePerformanceReport

Purpose:The Age Range Performance report includes all Display Network and YouTube Network statistics aggregated by age range. It also includes automatic audience performance. If other segment fields are used, you may get more than one row per age range

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/age-range-performance-report

Replication: Key-Based Replication

Replication Key: Date

AudiencePerformanceReport

Purpose:The Audience Performance report includes performance data from interests and remarketing lists for Display Network and YouTube Network ads, and remarketing lists for search ads (RLSA), aggregated at the audience level—one row per audience. If other segment fields are used, you may get more than one row per topic

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/audience-performance-report

Replication: Key-Based Replication

Replication Key: Date

DisplayTopicsPerformanceReport

Purpose:The Display Topics Performance report includes all Display Network and YouTube Network statistics aggregated at the topic level, one row per topic. If other segment fields are used, you may get more than one row per topic

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/display-topics-performance-report

Replication: Key-Based Replication

Replication Key: Date

ShoppingPerformanceReport

Purpose:The Shopping Performance report provides shopping campaign statistics aggregated at the product (OfferId field) level. Product dimension values from Merchant Center such as brand, category, custom attributes, product condition and product type will reflect the state of each dimension as of the date and time when AdWords recorded the corresponding event

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/shopping-performance-report

Replication: Key-Based Replication

Replication Key: Date

PlaceholderReport

Purpose:The Placeholder Report provides statistics for feed-based ad extensions, one row per placeholder type. If other segment fields are used, you may get more than one row per placeholder type

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/placeholder-report

Replication: Key-Based Replication

Replication Key: Date

FinalURLReport

Purpose: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. This report doesn't show any stats for ad extensions.

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/final-url-report

Replication: Key-Based Replication

Replication Key Date

VideoPerformanceReport

Purpose:The Video Performance report includes statistics for your account's upgraded AdWords for Video campaigns.

Source API Documentation https://developers.google.com/adwords/api/docs/appendix/reports/video-performance-report

Replication: Key-Based Replication

Replication Key: Date