This integration is powered by Singer's Google Ads tap and certified by Stitch. Check out and contribute to the repo on GitHub.
For support, contact Stitch support.
Google Ads integration summary
Stitch’s Google Ads integration replicates data using the Google Ads API (v12). Refer to the Schema section for a list of objects available for replication.
This integration replaces the Google Ads (Adwords) integration.
Note: To use the Ads API, an Ads account must be connected to a manager account.
Google Ads feature snapshot
A high-level look at Stitch's Google Ads (v1) integration, including release status, useful links, and the features supported in Stitch.
STITCH | |||
Release status |
Released on April 4, 2022 |
Supported by | |
Stitch plan |
Standard |
API availability |
Available |
Singer GitHub repository | |||
REPLICATION SETTINGS | |||
Anchor Scheduling |
Supported |
Advanced Scheduling |
Supported |
Table-level reset |
Unsupported |
Configurable Replication Methods |
Unsupported |
DATA SELECTION | |||
Table selection |
Supported |
Column selection |
Supported |
Select all |
Unsupported |
||
TRANSPARENCY | |||
Extraction Logs |
Supported |
Loading Reports |
Supported |
Connecting Google Ads
Google Ads setup requirements
To set up Google Ads in Stitch, you need:
-
To pause any ad-blocking software. Ad blockers can interfere with pop-ups, which are used in Google authorization and may prevent authorization from successfully completing.
-
Access to the Google Ads data you want to replicate. Before beginning, verify that the user creating the integration has access to the reports you want to replicate.
-
To connect your Ads account to a manager account. This will ensure your account has access to the Ads API, thereby allowing Stitch to query for and extract data.
An manager account is an Ads account type that enables you to manage several Ads accounts under a single login. Think of manager accounts as trees: they can branch out to individual accounts or even other manager accounts. Read more about manager accounts here.
By default, regular advertiser accounts - that is, individual Ads accounts - don’t have access to the Ads API. To gain access, they must be linked to an manager account. If you don’t have an manager account, create one using these instructions and then link it to your Ads account by following these steps.
Step 1: Add Google Ads as a Stitch data source
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the Google Ads icon.
-
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch Google Ads” would create a schema called
stitch_google_ads
in the destination. Note: Schema names cannot be changed after you save the integration.
Step 2: Define the conversion window
The conversion window is the period of time after a customer clicks an ad that a conversion (ex: a purchase) is recorded in Google Ads.
You can configure the number of days in this window using in the Conversion Window field. The value can be any number between 1 and 30, 60 or 90. For more information about conversion windows, refer to the Google Ads documentation.
If you don’t enter a value, the conversion window is set to 30 days by default.
Step 3: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your Google Ads integration. This means that:
- For tables using Key-based Incremental Replication, data equal to or newer than this date will be replicated to your destination.
- For tables using Full Table Replication, all data - including records that are older, equal to, or newer than this date - will be replicated to your destination.
Change this setting if you want to replicate data beyond Google Ads’s default setting of 30 days. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.
Step 4: Create a replication schedule
In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
Google Ads integrations support the following replication scheduling methods:
-
Advanced Scheduling using Cron (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 5: Authorize Stitch & Select Google Ads Profiles
- Next, you’ll be prompted to log into your Google account and to approve Stitch’s access to your Google Ads data. Note: We will only ever read your data.
- Click Authorize to continue.
-
After your credentials are validated, you’ll be prompted to select the Google Ads profile(s) you want to connect to Stitch.
If you don’t see the profile(s) you want to connect, verify that you have completed the setup requirements.
-
When selecting profiles, keep the following in mind:
- You cannot select more than 1000 profiles per Google Ads integration. Selecting a large number of profiles can reduce performance, so it is recommended to select fewer profiles if possible. You can select more profiles by adding additional Google Ads integrations in your Stitch account.
- Selecting a subprofile will also select the parent, or top-level profile. If you de-select the top-level profile, you will be unable to select any subprofiles.
- If multiple profiles are selected, data for all the selected profiles will map to the same table in your destination. For example: If two profiles are selected and the
accounts
table is tracked, account data for both profiles will be replicated into theaccounts
table. This is applicable to every table selected in the next step. To distinguish different profiles, make sure to select thecustomer_id
field in your tables.
- When finished selecting profiles, click Continue.
Step 6: Set objects to replicate
Column selection and Google compatibility rules
Because of Google’s compatibility rules, some columns (metrics and segments) can’t be tracked together. As you select columns to track, incompatible fields will automatically be greyed out.
You can create additional Google Ads integrations if you need to track incompatible columns. The resulting table names will still be the same (ex: account_performance_report
) but the data will reside in different schemas in your data warehouse.
Initial and historical replication jobs
After you finish setting up Google Ads, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Google Ads replication
There are two types of tables in Stitch’s Google Ads integration: Core Object and Report.
- Core Object tables contain foundational data that’s useful for analysis. These are the following tables:
accounts
ad_groups
ads
campaigns
accessible_bidding_strategies
bidding_strategies
campaign_budgets
call_details
ad_group_criterion
campaign_criterion
campaign_labels
carrier_constant
feed
feed_item
labels
language_constant
mobile_app_category_constant
mobile_device_constant
operating_system_verison_constant
topic_constant
user_interest
user_list
These tables are replicated using Full Table Replication.
- Report tables are the various Google Ads reports. The replication process for these tables is a bit unlike that of other tables:
- Extraction: Data is extracted using a Conversion Window. A Conversion Window is a period of time after a customer clicks an ad that a conversion (ex: a purchase) is recorded in Google Ads.
The Conversion Window can be configured when creating the integration and can be edited in the integration settings at any time.
- Loading: Data is loaded into your data warehouse using Upsert Replication.
Each part of the replication process for Report tables is explained below.
Report tables: Data extraction and conversion windows
For historical and full re-replications of Google Ads data, Stitch will query for and extract data newer than or equal to the date defined in the Start Date field in the Integration Settings page.
The Start Date, in conjunction with the Conversion Window, defines the minimum date Stitch should query for when extracting historical data. This is calculated as:
Start Date - Conversion Window = Minimum Extraction Date
Example
During the initial set up, the Start Date field is set to July 3, 2017
, or 2017-07-03 00:00:00
.
To account for the Conversion Window, Stitch would calculate the Minimum Extraction Date value as: 2017-07-03 00:00:00 - 30 days = 2017-06-03 00:00:00
If you were to write a SQL query using this date for the ad_performance_report
table, it might look like this:
SELECT *
FROM google_ads.ad_performance_report
WHERE date >= '2017-06-03 00:00:00' /* Min. Extraction Date */
ORDER BY date
For ongoing replication jobs, Stitch will query for and extract data using the last saved maximum value in the table’s Replication Key column and the Conversion Window for the table.
Note: This applies to every replication job that takes place after the historical replication job.
Example
The last maximum saved Replication Key value for the ad_performance_report
table is 2017-10-01 00:00:00
.
To account for the Conversion Window of 30 days, we’d subtract this from the last maximum saved Replication Key value:
2017-10-01 00:00:00 - 30 days = 2017-09-01 00:00:00
In this case, Stitch would query for and extract data that is newer than or equal to 2017-09-01 00:00:00
and older than or equal to 2017-10-01 00:00:00
.
If this were a SQL query, it might look like this:
SELECT *
FROM ad_performance_report
WHERE date >= '2017-09-01 00:00:00'
/* max Replication Key value - Conversion Window */
AND date <= '2017-10-01 00:00:00'
/* max Replication Key value from previous job */
ORDER BY date
Report tables: Edit report segments and attributes
In report tables, a Primary Key _sdc_record_hash
is built using the segments and attributes selected when creating the report.
Modifying segments and attributes after the report is created and data has already been replicated may cause data quality issues. To avoid this, it is recommended to truncate your destination table before editing a report. You can then replicate the historical data from the updated report by resetting it from its Table Settings page.
Google Ads table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 1 of this integration.
This is the latest version of the Google Ads integration.
Report tables: Values for money fields
When conducting analyses on Report tables, you might notice that values in money fields - like a cost
field, for example - look higher than usual. This is because Google Ads’ API sends Stitch money data in micro currency units. Micro amounts always refer to your account’s local currency.
For example: The value of $2.25USD will be recorded as 2250000
. To represent this value as 2.25
in a report, divide by one million: 2250000 / 1000000 = 2.25
.
Report tables: Column selection and statistic aggregation
The dimension columns selected for replication in Report tables can impact how performance statistics are aggregated. Additionally, this can also affect the number of rows replicated and loaded into your destination.
For example: if date
, customer_id
, campaign_id
, device
, and impressions
were selected, the impressions
column would contain the total number of impressions for the device type for that date:
date | customer_id | campaign_id | device | impressions |
---|---|---|---|---|
2018-01-05 00:00:00 | 1585293495 | 240531207 | DESKTOP | 4 |
2018-01-05 00:00:00 | 1585293495 | 240531207 | HIGH_END_MOBILE | 3 |
2018-01-05 00:00:00 | 1585293495 | 240531207 | TABLET | 3 |
2018-01-05 00:00:00 | 1585293495 | 240531207 | UNKNOWN | 1 |
If the ad_network_type
column were also selected, a row for every unique combination of device
and ad_network_type
would be created and impressions
would be aggregated accordingly:
date | customer_id | campaign_id | device | ad_network_type | impressions |
---|---|---|---|---|---|
2018-01-05 00:00:00 | 1585293495 | 240531207 | DESKTOP | YOUTUBE_SEARCH | 3 |
2018-01-05 00:00:00 | 1585293495 | 240531207 | HIGH_END_MOBILE | YOUTUBE_SEARCH | 1 |
2018-01-05 00:00:00 | 1585293495 | 240531207 | TABLET | YOUTUBE_SEARCH | 0 |
2018-01-05 00:00:00 | 1585293495 | 240531207 | UNKNOWN | YOUTUBE_SEARCH | 0 |
2018-01-05 00:00:00 | 1585293495 | 240531207 | DESKTOP | SEARCH | 1 |
2018-01-05 00:00:00 | 1585293495 | 240531207 | HIGH_END_MOBILE | SEARCH | 2 |
2018-01-05 00:00:00 | 1585293495 | 240531207 | TABLET | SEARCH | 3 |
2018-01-05 00:00:00 | 1585293495 | 240531207 | UNKNOWN | SEARCH | 1 |
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs
> customers
), while case is maintained in PostgreSQL destinations (CusTomERs
> CusTomERs
). Refer to the Loading Guide for your destination for more info.
accessible_bidding_strategies
Replication Method : |
Full Table |
Primary Key |
id |
Official docs : |
The accessible_bidding_strategies
table contains info about accessible bidding strategies in your Google Ads account.
customer_id
|
||
id
|
||
maximize_conversion_value
|
||
maximize_conversions
|
||
name
|
||
owner_customer_id
|
||
owner_descriptive_name
|
||
resource_name
|
||
target_cpa
|
||
target_impression_share
|
||
target_roas
|
||
target_spend
|
||
type
|
accounts
Replication Method : |
Full Table |
Primary Key |
id |
Official docs : |
The accounts
table contains high-level info about the Google Ads account(s) you’ve connected to Stitch.
auto_tagging_enabled
|
|||||
call_reporting_setting
|
|||||
conversion_tracking_setting
|
|||||
currency_code
|
|||||
descriptive_name
|
|||||
final_url_suffix
|
|||||
has_partners_badge
|
|||||
id
|
|||||
manager
|
|||||
optimization_score
|
|||||
optimization_score_weight
|
|||||
pay_per_conversion_eligibility_failure_reasons
|
|||||
remarketing_setting
|
|||||
resource_name
|
|||||
status
|
|||||
test_account
|
|||||
time_zone
|
|||||
tracking_url_template
|
account_performance_report
Replication Method : |
Key-based Incremental |
Replication Key |
date |
Primary Key |
_sdc_record_hash |
Official docs : |
The account_performance_report
table contains all statistics aggregated by default at the account level.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
_sdc_record_hash
A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the names and values of the dimensions in the report. |
date
The day the record pertains to. |
customer_id
The ID of the Ads account that the record belongs to. |
active_view_cpm
|
active_view_ctr
|
active_view_impressions
|
active_view_measurability
|
active_view_measurable_cost_micros
|
active_view_measurable_impressions
|
active_view_viewability
|
ad_network_type
|
all_conversions
|
all_conversions_from_interactions_rate
|
all_conversions_value
|
average_cost
|
average_cpc
|
average_cpe
|
average_cpm
|
average_cpv
|
click_type
|
clicks
|
content_budget_lost_impression_share
|
content_impression_share
|
content_rank_lost_impression_share
|
conversion_action
|
conversion_action_category
|
conversion_action_name
|
conversion_adjustment
|
conversion_lag_bucket
|
conversion_or_adjustment_lag_bucket
|
conversions
|
conversions_from_interactions_rate
|
conversions_value
|
cost_micros
|
cost_per_all_conversions
|
cost_per_conversion
|
cross_device_conversions
|
ctr
|
customer_auto_tagging_enabled
|
customer_currency_code
|
customer_descriptive_name
|
customer_manager
|
customer_test_account
|
customer_time_zone
|
day_of_week
|
device
|
engagement_rate
|
engagements
|
external_conversion_source
|
hour
|
impressions
|
interaction_event_types
|
interaction_rate
|
interactions
|
invalid_click_rate
|
invalid_clicks
|
month
|
month_of_year
|
quarter
|
search_budget_lost_impression_share
|
search_exact_match_impression_share
|
search_impression_share
|
search_rank_lost_impression_share
|
slot
|
value_per_all_conversions
|
value_per_conversion
|
video_view_rate
|
video_views
|
view_through_conversions
|
week
|
year
|
Replication Method : |
Full Table |
Primary Key |
id |
Official docs : |
The ads
table contains comprehensive info about ads in ad groups in your Google Ads account.
action_items
|
||||||||||||||||||||
ad_group
|
||||||||||||||||||||
ad_group_id
|
||||||||||||||||||||
ad_strength
|
||||||||||||||||||||
added_by_google_ads
|
||||||||||||||||||||
app_ad
|
||||||||||||||||||||
app_engagement_ad
|
||||||||||||||||||||
app_pre_registration_ad
|
||||||||||||||||||||
call_ad
|
||||||||||||||||||||
campaign_id
|
||||||||||||||||||||
customer_id
|
||||||||||||||||||||
device_preference
|
||||||||||||||||||||
display_upload_ad
|
||||||||||||||||||||
display_url
|
||||||||||||||||||||
expanded_dynamic_search_ad
|
||||||||||||||||||||
expanded_text_ad
|
||||||||||||||||||||
final_app_urls
|
||||||||||||||||||||
final_mobile_urls
|
||||||||||||||||||||
final_url_suffix
|
||||||||||||||||||||
final_urls
|
||||||||||||||||||||
gmail_ad
|
||||||||||||||||||||
hotel_ad
|
||||||||||||||||||||
id
|
||||||||||||||||||||
image_ad
|
||||||||||||||||||||
labels
|
||||||||||||||||||||
legacy_app_install_ad
|
||||||||||||||||||||
legacy_responsive_display_ad
|
||||||||||||||||||||
local_ad
|
||||||||||||||||||||
name
|
||||||||||||||||||||
policy_summary
|
||||||||||||||||||||
resource_name
|
||||||||||||||||||||
responsive_display_ad
|
||||||||||||||||||||
responsive_search_ad
|
||||||||||||||||||||
shopping_comparison_listing_ad
|
||||||||||||||||||||
shopping_product_ad
|
||||||||||||||||||||
shopping_smart_ad
|
||||||||||||||||||||
smart_campaign_ad
|
||||||||||||||||||||
status
|
||||||||||||||||||||
system_managed_resource_source
|
||||||||||||||||||||
text_ad
|
||||||||||||||||||||
tracking_url_template
|
||||||||||||||||||||
type
|
||||||||||||||||||||
url_collections
|
||||||||||||||||||||
url_custom_parameters
|
||||||||||||||||||||
video_ad
|
||||||||||||||||||||
video_responsive_ad
|
ad_groups
Replication Method : |
Full Table |
Primary Key |
id |
Official docs : |
The ad_groups
table contains detailed info about your ad groups.
accessible_bidding_strategy_id
|
|
ad_rotation_mode
|
|
audience_setting
|
|
base_ad_group
|
|
bidding_strategy_id
|
|
campaign
|
|
campaign_id
|
|
cpc_bid_micros
|
|
cpm_bid_micros
|
|
cpv_bid_micros
|
|
customer_id
|
|
display_custom_bid_dimension
|
|
effective_cpc_bid_micros
|
|
effective_target_cpa_micros
|
|
effective_target_cpa_source
|
|
effective_target_roas
|
|
effective_target_roas_source
|
|
excluded_parent_asset_field_types
|
|
explorer_auto_optimizer_setting
|
|
final_url_suffix
|
|
id
|
|
labels
|
|
name
|
|
percent_cpc_bid_micros
|
|
resource_name
|
|
status
|
|
target_cpa_micros
|
|
target_cpm_micros
|
|
target_roas
|
|
targeting_setting
|
|
tracking_url_template
|
|
type
|
|
url_custom_parameters
|
ad_group_audience_performance_report
Replication Method : |
Key-based Incremental |
Replication Key |
date |
Primary Key |
_sdc_record_hash |
Official docs : |
The ad_group_audience_performance_report
table contains all statistics aggregated at the ad group level.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
_sdc_record_hash
A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the names and values of the dimensions in the report. |
|
date
The day the record pertains to. |
|
customer_id
The ID of the Ads account that the record belongs to. |
|
ad_group_id
The ID of the ad group that the record belongs to. |
|
active_view_cpm
|
|
active_view_ctr
|
|
active_view_impressions
|
|
active_view_measurability
|
|
active_view_measurable_cost_micros
|
|
active_view_measurable_impressions
|
|
active_view_viewability
|
|
ad_group_base_ad_group
|
|
ad_group_campaign
|
|
ad_group_criterion_bid_modifier
|
|
ad_group_criterion_criterion_id
|
|
ad_group_criterion_effective_cpc_bid_micros
|
|
ad_group_criterion_effective_cpc_bid_source
|
|
ad_group_criterion_effective_cpm_bid_micros
|
|
ad_group_criterion_effective_cpm_bid_source
|
|
ad_group_criterion_final_mobile_urls
|
|
ad_group_criterion_final_urls
|
|
ad_group_criterion_status
|
|
ad_group_name
|
|
ad_group_status
|
|
ad_group_targeting_setting
|
|
ad_group_tracking_url_template
|
|
ad_group_url_custom_parameters
|
|
ad_network_type
|
|
all_conversions
|
|
all_conversions_from_interactions_rate
|
|
all_conversions_value
|
|
average_cost
|
|
average_cpc
|
|
average_cpe
|
|
average_cpm
|
|
average_cpv
|
|
bidding_strategy_name
|
|
campaign_base_campaign
|
|
campaign_bidding_strategy
|
|
campaign_bidding_strategy_type
|
|
campaign_name
|
|
campaign_status
|
|
click_type
|
|
clicks
|
|
conversion_action
|
|
conversion_action_category
|
|
conversion_action_name
|
|
conversions
|
|
conversions_from_interactions_rate
|
|
conversions_value
|
|
cost_micros
|
|
cost_per_all_conversions
|
|
cost_per_conversion
|
|
cross_device_conversions
|
|
ctr
|
|
customer_currency_code
|
|
customer_descriptive_name
|
|
customer_time_zone
|
|
date
|
|
day_of_week
|
|
device
|
|
engagement_rate
|
|
engagements
|
|
external_conversion_source
|
|
gmail_forwards
|
|
gmail_saves
|
|
gmail_secondary_clicks
|
|
impressions
|
|
interaction_event_types
|
|
interaction_rate
|
|
interactions
|
|
month
|
|
month_of_year
|
|
quarter
|
|
slot
|
|
value_per_all_conversions
|
|
value_per_conversion
|
|
video_quartile_p100_rate
|
|
video_quartile_p25_rate
|
|
video_quartile_p50_rate
|
|
video_quartile_p75_rate
|
|
video_view_rate
|
|
video_views
|
|
view_through_conversions
|
|
week
|
|
year
|
ad_group_criterion
Replication Method : |
Full Table |
Primary Key |
criterion_id : ad_group_id |
Official docs : |
The ad_group_criterion
table contains info about ad group criteria.
customer_id
|
|||||
campaign_id
|
|||||
resource_name
|
|||||
display_name
|
|||||
status
|
|||||
quality_info
|
|||||
type
|
|||||
system_serving_status
|
|||||
approval_status
|
|||||
disapproval_reasons
|
|||||
labels
|
|||||
effective_cpc_bid_source
|
|||||
effective_cpm_bid_source
|
|||||
effective_cpv_bid_source
|
|||||
effective_percent_cpc_bid_source
|
|||||
position_estimates
|
|||||
final_urls
|
|||||
final_mobile_urls
|
|||||
url_custom_parameters
|
|||||
criterion_id
|
|||||
ad_group
|
|||||
ad_group_id
|
|||||
negative
|
|||||
bid_modifier
|
|||||
cpc_bid_micros
|
|||||
cpm_bid_micros
|
|||||
cpv_bid_micros
|
|||||
percent_cpc_bid_micros
|
|||||
effective_cpc_bid_micros
|
|||||
effective_cpm_bid_micros
|
|||||
effective_cpv_bid_micros
|
|||||
effective_percent_cpc_bid_micros
|
|||||
final_url_suffix
|
|||||
tracking_url_template
|
|||||
criterion
The ad group criterion. It is one of the objects listed under criterion in the Google Ads API documentation. |
ad_group_performance_report
Replication Method : |
Key-based Incremental |
Replication Key |
date |
Primary Key |
_sdc_record_hash |
Official docs : |
The ad_group_performance_report
table contains all statistics aggregated at the ad group level.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
_sdc_record_hash
A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the names and values of the dimensions in the report. |
|
date
The day the record pertains to. |
|
customer_id
The ID of the Ads account that the record belongs to. |
|
ad_group_id
The ID of the ad group that the record belongs to. |
|
absolute_top_impression_percentage
|
|
active_view_cpm
|
|
active_view_ctr
|
|
active_view_impressions
|
|
active_view_measurability
|
|
active_view_measurable_cost_micros
|
|
active_view_measurable_impressions
|
|
active_view_viewability
|
|
ad_group_ad_rotation_mode
|
|
ad_group_base_ad_group
|
|
ad_group_cpc_bid_micros
|
|
ad_group_cpm_bid_micros
|
|
ad_group_cpv_bid_micros
|
|
ad_group_display_custom_bid_dimension
|
|
ad_group_effective_target_cpa_micros
|
|
ad_group_effective_target_cpa_source
|
|
ad_group_effective_target_roas
|
|
ad_group_effective_target_roas_source
|
|
ad_group_final_url_suffix
|
|
ad_group_name
|
|
ad_group_status
|
|
ad_group_tracking_url_template
|
|
ad_group_type
|
|
ad_group_url_custom_parameters
|
|
ad_network_type
|
|
all_conversions
|
|
all_conversions_from_interactions_rate
|
|
all_conversions_value
|
|
average_cost
|
|
average_cpc
|
|
average_cpe
|
|
average_cpm
|
|
average_cpv
|
|
average_page_views
|
|
average_time_on_site
|
|
bounce_rate
|
|
campaign_base_campaign
|
|
campaign_bidding_strategy
|
|
campaign_bidding_strategy_type
|
|
campaign_id
|
|
campaign_labels
|
|
campaign_manual_cpc
|
|
campaign_name
|
|
campaign_percent_cpc
|
|
campaign_status
|
|
click_type
|
|
clicks
|
|
content_impression_share
|
|
content_rank_lost_impression_share
|
|
conversion_action
|
|
conversion_action_category
|
|
conversion_action_name
|
|
conversion_adjustment
|
|
conversion_lag_bucket
|
|
conversion_or_adjustment_lag_bucket
|
|
conversions
|
|
conversions_from_interactions_rate
|
|
conversions_value
|
|
cost_micros
|
|
cost_per_all_conversions
|
|
cost_per_conversion
|
|
cost_per_current_model_attributed_conversion
|
|
cross_device_conversions
|
|
ctr
|
|
current_model_attributed_conversions
|
|
current_model_attributed_conversions_value
|
|
customer_currency_code
|
|
customer_descriptive_name
|
|
customer_time_zone
|
|
day_of_week
|
|
device
|
|
engagement_rate
|
|
engagements
|
|
external_conversion_source
|
|
gmail_forwards
|
|
gmail_saves
|
|
gmail_secondary_clicks
|
|
hour
|
|
impressions
|
|
interaction_event_types
|
|
interaction_rate
|
|
interactions
|
|
month
|
|
month_of_year
|
|
percent_new_visitors
|
|
phone_calls
|
|
phone_impressions
|
|
phone_through_rate
|
|
quarter
|
|
relative_ctr
|
|
search_absolute_top_impression_share
|
|
search_budget_lost_absolute_top_impression_share
|
|
search_budget_lost_top_impression_share
|
|
search_exact_match_impression_share
|
|
search_impression_share
|
|
search_rank_lost_absolute_top_impression_share
|
|
search_rank_lost_impression_share
|
|
search_rank_lost_top_impression_share
|
|
search_top_impression_share
|
|
slot
|
|
top_impression_percentage
|
|
value_per_all_conversions
|
|
value_per_conversion
|
|
value_per_current_model_attributed_conversion
|
|
video_quartile_p100_rate
|
|
video_quartile_p25_rate
|
|
video_quartile_p50_rate
|
|
video_quartile_p75_rate
|
|
video_view_rate
|
|
video_views
|
|
view_through_conversions
|
|
week
|
|
year
|
ad_performance_report
Replication Method : |
Key-based Incremental |
Replication Key |
date |
Primary Key |
_sdc_record_hash |
Official docs : |
The ad_performance_report
table contains all statistics aggregated at the ad level.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
_sdc_record_hash
A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the names and values of the dimensions in the report. |
||||||||
date
The day the record pertains to. |
||||||||
customer_id
The ID of the Ads account that the record belongs to. |
||||||||
ad_group_id
The ID of the ad group that the record belongs to. |
||||||||
campaign_id
The ID of the campaign that the record belongs to. |
||||||||
campaign_labels
|
||||||||
absolute_top_impression_percentage
|
||||||||
active_view_cpm
|
||||||||
active_view_ctr
|
||||||||
active_view_impressions
|
||||||||
active_view_measurability
|
||||||||
active_view_measurable_cost_micros
|
||||||||
active_view_measurable_impressions
|
||||||||
active_view_viewability
|
||||||||
ad_group_ad_ad_strength
|
||||||||
ad_group_ad_policy_summary
|
||||||||
ad_group_ad_status
|
||||||||
ad_group_base_ad_group
|
||||||||
ad_group_id
|
||||||||
ad_group_name
|
||||||||
ad_group_status
|
||||||||
ad_network_type
|
||||||||
added_by_google_ads
|
||||||||
all_conversions
|
||||||||
all_conversions_from_interactions_rate
|
||||||||
all_conversions_value
|
||||||||
app_ad
|
||||||||
average_cost
|
||||||||
average_cpc
|
||||||||
average_cpe
|
||||||||
average_cpm
|
||||||||
average_cpv
|
||||||||
average_page_views
|
||||||||
average_time_on_site
|
||||||||
bounce_rate
|
||||||||
call_ad
|
||||||||
campaign_base_campaign
|
||||||||
campaign_name
|
||||||||
campaign_status
|
||||||||
click_type
|
||||||||
clicks
|
||||||||
conversion_action
|
||||||||
conversion_action_category
|
||||||||
conversion_action_name
|
||||||||
conversion_adjustment
|
||||||||
conversion_lag_bucket
|
||||||||
conversion_or_adjustment_lag_bucket
|
||||||||
conversions
|
||||||||
conversions_from_interactions_rate
|
||||||||
conversions_value
|
||||||||
cost_micros
|
||||||||
cost_per_all_conversions
|
||||||||
cost_per_conversion
|
||||||||
cost_per_current_model_attributed_conversion
|
||||||||
cross_device_conversions
|
||||||||
ctr
|
||||||||
current_model_attributed_conversions
|
||||||||
current_model_attributed_conversions_value
|
||||||||
customer_currency_code
|
||||||||
customer_descriptive_name
|
||||||||
customer_time_zone
|
||||||||
day_of_week
|
||||||||
device
|
||||||||
device_preference
|
||||||||
display_url
|
||||||||
engagement_rate
|
||||||||
engagements
|
||||||||
expanded_dynamic_search_ad
|
||||||||
expanded_text_ad
|
||||||||
external_conversion_source
|
||||||||
final_mobile_urls
|
||||||||
final_urls
|
||||||||
gmail_forwards
|
||||||||
gmail_saves
|
||||||||
gmail_secondary_clicks
|
||||||||
id
|
||||||||
image_ad
|
||||||||
impressions
|
||||||||
interaction_event_types
|
||||||||
interaction_rate
|
||||||||
interactions
|
||||||||
keyword
|
||||||||
legacy_responsive_display_ad
|