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.
| Loadunits | Description | Default Extract mode |
|---|---|---|
accounts | All Google Ad Accounts | Snapshot Paginate |
ad_group_performance | represents the Ad group Performance Report | Incremental |
ad_groups | All Ad groups in the Accounts | Snapshot Paginate |
ad_performance | represents the Ad Performance Report | Incremental |
ads | All Ads in the Ad groups | Snapshot Paginate |
campaign_groups | All Campaign Groups in the Accounts | Snapshot Paginate |
campaign_performance | represents the Search Campaign Performance Report | Incremental |
campaigns | All Campaigns from all Campaign Groups | Snapshot Paginate |
geo_performance | represents the Geo Performance Report | Incremental |
keyword_performance | represents the Keywords Performance Report | Incremental |
search_query_performance | represents the Search Query Performance Report | Incremental |
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.
Questions? Interested?
If you have questions or feedback, feel free to reach out at hello@datacoral.co or Request a demo