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. 1.
    Signin to Daton
  2. 2.
    Select Adwords from Integrations page
  3. 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. 4.
    You will be redirected to Adwords login for authorizing Daton to extract data periodically
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available Adwords Views
  6. 6.
    Select a combination of Metrics and Dimensions
  7. 7.
    Submit the integration
  8. 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. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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.
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
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.
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
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
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.
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.
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
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.
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.
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
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
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
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
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
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
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
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
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.
Replication: Key-Based Replication
Replication Key Date
VideoPerformanceReport
Purpose:The Video Performance report includes statistics for your account's upgraded AdWords for Video campaigns.
Replication: Key-Based Replication
Replication Key: Date
Last modified 2yr ago