Google Adwords Connector Overview

Google Adwords is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web users.Click here to learn how Google Adwords manages accounts.

The Datacoral Google AdWords connector collects data from the Google AdWords account and enables data flow from the Google AdWords API into a data warehouse, such as Redshift or Snowflake.

Features & Capabilities

  • Backfill: Full historical sync of your entire data
  • Data Extraction Modes: Snapshot, incremental with pagination
  • Data Load Modes: replace, append and merge
  • Tables and Columns selection: Ability to select tables
  • Data-layout: changing the data type of your columns
  • Customizations: Update the configurations easily using the UI and CLI
  • Scheduling: Highly flexible scheduling system

Supported load units

The Google AdWords slice automatically collects the following loadunits from the Google AdWords API and makes them available in your warehouse for analysis.

LoadunitsDescriptionDefault Extract mode
accountsAll Google Ad AccountsSnapshot Paginate
ad_group_performancerepresents the Ad group Performance ReportIncremental
ad_groupsAll Ad groups in the AccountsSnapshot Paginate
ad_performancerepresents the Ad Performance ReportIncremental
adsAll Ads in the Ad groupsSnapshot Paginate
campaign_groupsAll Campaign Groups in the AccountsSnapshot Paginate
campaign_performancerepresents the Search Campaign Performance ReportIncremental
campaignsAll Campaigns from all Campaign GroupsSnapshot Paginate
geo_performancerepresents the Geo Performance ReportIncremental
keyword_performancerepresents the Keywords Performance ReportIncremental
search_query_performancerepresents the Search Query Performance ReportIncremental

Connector output

Output of this slice is stored in S3 and Redshift.

AWS S3 Data stored in AWS S3 is partitioned by date and time s3://customer_installation.datacoral/<slice-name>

Destination warehouse: Schema - schema name will be same as a slice-name. Tables produced by the slice dynamically based on the loadunits configured.

- schema.accounts
- schema.ad_group_performance
- schema.ad_groups
- schema.ad_performance
- schema.ads
- schema.campaign_groups
- schema.campaign_performance
- schema.campaigns
- schema.geo_performance
- schema.keyword_performance
- schema.search_query_performance

Questions? Interested?

If you have questions or feedback, feel free to reach out at hello@datacoral.co or Request a demo