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.

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

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-google-ads

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

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Google Ads icon.

  4. 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:

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

  1. 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.
  2. Click Authorize to continue.
  3. 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.

  4. 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 the accounts table. This is applicable to every table selected in the next step. To distinguish different profiles, make sure to select the customer_id field in your tables.
  5. When finished selecting profiles, click Continue.

Step 6: Set objects to replicate

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.

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.

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

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

accessible_bidding_strategies

Replication Method :

Full Table

Primary Key :

id

Official docs :

Official Docs

The accessible_bidding_strategies table contains info about accessible bidding strategies in your Google Ads account.

This is a Core Object table.

customer_id
INTEGER

id
INTEGER

maximize_conversion_value
OBJECT

target_roas
SINGER.DECIMAL

accessible_bidding_strategies (table), maximize_conversion_value (attribute)

maximize_conversions
OBJECT

target_cpa
INTEGER

accessible_bidding_strategies (table), maximize_conversions (attribute)

name
STRING

owner_customer_id
INTEGER

owner_descriptive_name
STRING

resource_name
OBJECT, STRING

target_cpa
OBJECT

target_cpa_micros
INTEGER

accessible_bidding_strategies (table), target_cpa (attribute)

target_impression_share
OBJECT

cpc_bid_ceiling_micros
INTEGER

location
STRING

location_fraction_micros
INTEGER

accessible_bidding_strategies (table), target_impression_share (attribute)

target_roas
OBJECT

target_roas
SINGER.DECIMAL

accessible_bidding_strategies (table), target_roas (attribute)

target_spend
OBJECT

cpc_bid_ceiling_micros
INTEGER

target_spend_micros
INTEGER

accessible_bidding_strategies (table), target_spend (attribute)

type
STRING


Replication Method :

Full Table

Primary Key :

id

Official docs :

Official Docs

The accounts table contains high-level info about the Google Ads account(s) you’ve connected to Stitch.

This is a Core Object table.

auto_tagging_enabled
BOOLEAN

call_reporting_setting
OBJECT

call_conversion_action
OBJECT, STRING

call_conversion_reporting_enabled
BOOLEAN

call_reporting_enabled
BOOLEAN

accounts (table), call_reporting_setting (attribute)

conversion_tracking_setting
OBJECT

accepted_customer_data_terms
BOOLEAN

conversion_tracking_id
INTEGER

conversion_tracking_status
STRING

cross_account_conversion_tracking_id
INTEGER

enhanced_conversions_for_leads_enabled
BOOLEAN

accounts (table), conversion_tracking_setting (attribute)

currency_code
STRING

descriptive_name
STRING

final_url_suffix
STRING

has_partners_badge
BOOLEAN

id
INTEGER

manager
BOOLEAN

optimization_score
SINGER.DECIMAL

optimization_score_weight
SINGER.DECIMAL

pay_per_conversion_eligibility_failure_reasons
STRING

remarketing_setting
OBJECT

google_global_site_tag
STRING

accounts (table), remarketing_setting (attribute)

resource_name
OBJECT, STRING

status
STRING

test_account
BOOLEAN

time_zone
STRING

tracking_url_template
STRING


account_performance_report

Replication Method :

Key-based Incremental

Replication Key :

date

Primary Key :

_sdc_record_hash

Official docs :

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
STRING

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
DATE-TIME

The day the record pertains to.

customer_id
INTEGER

The ID of the Ads account that the record belongs to.

active_view_cpm
SINGER.DECIMAL

active_view_ctr
SINGER.DECIMAL

active_view_impressions
INTEGER

active_view_measurability
SINGER.DECIMAL

active_view_measurable_cost_micros
INTEGER

active_view_measurable_impressions
INTEGER

active_view_viewability
SINGER.DECIMAL

ad_network_type
STRING

all_conversions
SINGER.DECIMAL

all_conversions_from_interactions_rate
SINGER.DECIMAL

all_conversions_value
SINGER.DECIMAL

average_cost
SINGER.DECIMAL

average_cpc
SINGER.DECIMAL

average_cpe
SINGER.DECIMAL

average_cpm
SINGER.DECIMAL

average_cpv
SINGER.DECIMAL

click_type
STRING

clicks
INTEGER

content_budget_lost_impression_share
SINGER.DECIMAL

content_impression_share
SINGER.DECIMAL

content_rank_lost_impression_share
SINGER.DECIMAL

conversion_action
OBJECT, STRING

conversion_action_category
STRING

conversion_action_name
STRING

conversion_adjustment
BOOLEAN

conversion_lag_bucket
STRING

conversion_or_adjustment_lag_bucket
STRING

conversions
SINGER.DECIMAL

conversions_from_interactions_rate
SINGER.DECIMAL

conversions_value
SINGER.DECIMAL

cost_micros
INTEGER

cost_per_all_conversions
SINGER.DECIMAL

cost_per_conversion
SINGER.DECIMAL

cross_device_conversions
SINGER.DECIMAL

ctr
SINGER.DECIMAL

customer_auto_tagging_enabled
BOOLEAN

customer_currency_code
STRING

customer_descriptive_name
STRING

customer_manager
BOOLEAN

customer_test_account
BOOLEAN

customer_time_zone
STRING

day_of_week
STRING

device
STRING

engagement_rate
SINGER.DECIMAL

engagements
INTEGER

external_conversion_source
STRING

hour
INTEGER

impressions
INTEGER

interaction_event_types
STRING

interaction_rate
SINGER.DECIMAL

interactions
INTEGER

invalid_click_rate
SINGER.DECIMAL

invalid_clicks
INTEGER

month
DATE-TIME

month_of_year
STRING

quarter
DATE-TIME

search_budget_lost_impression_share
SINGER.DECIMAL

search_exact_match_impression_share
SINGER.DECIMAL

search_impression_share
SINGER.DECIMAL

search_rank_lost_impression_share
SINGER.DECIMAL

slot
STRING

value_per_all_conversions
SINGER.DECIMAL

value_per_conversion
SINGER.DECIMAL

video_view_rate
SINGER.DECIMAL

video_views
INTEGER

view_through_conversions
INTEGER

week
DATE-TIME

year
INTEGER


Replication Method :

Full Table

Primary Key :

id

Official docs :

Official Docs

The ads table contains comprehensive info about ads in ad groups in your Google Ads account.

This is a Core Object table.

action_items
STRING

ad_group
OBJECT, STRING

ad_group_id
INTEGER

ad_strength
STRING

added_by_google_ads
BOOLEAN

app_ad
OBJECT

descriptions
OBJECT, STRING

headlines
OBJECT, STRING

html5_media_bundles
OBJECT, STRING

asset
OBJECT, STRING

ads (table), html5_media_bundles (attribute)

images
OBJECT, STRING

asset
OBJECT, STRING

ads (table), images (attribute)

mandatory_ad_text
OBJECT, STRING

youtube_videos
OBJECT, STRING

asset
OBJECT, STRING

ads (table), youtube_videos (attribute)
ads (table), app_ad (attribute)

app_engagement_ad
OBJECT

descriptions
OBJECT, STRING

headlines
OBJECT, STRING

images
OBJECT, STRING

asset
OBJECT, STRING

ads (table), images (attribute)

videos
OBJECT, STRING

asset
OBJECT, STRING

ads (table), videos (attribute)
ads (table), app_engagement_ad (attribute)

app_pre_registration_ad
OBJECT

descriptions
OBJECT, STRING

headlines
OBJECT, STRING

images
OBJECT, STRING

asset
OBJECT, STRING

ads (table), images (attribute)

youtube_videos
OBJECT, STRING

asset
OBJECT, STRING

ads (table), youtube_videos (attribute)
ads (table), app_pre_registration_ad (attribute)

call_ad
OBJECT

business_name
STRING

call_tracked
BOOLEAN

conversion_action
OBJECT, STRING

conversion_reporting_state
STRING

country_code
STRING

description1
STRING

description2
STRING

disable_call_conversion
BOOLEAN

headline1
STRING

headline2
STRING

path1
STRING

path2
STRING

phone_number
STRING

phone_number_verification_url
STRING

ads (table), call_ad (attribute)

campaign_id
INTEGER

customer_id
INTEGER

device_preference
STRING

display_upload_ad
OBJECT

display_upload_product_type
STRING

media_bundle
OBJECT, STRING

asset
OBJECT, STRING

ads (table), media_bundle (attribute)
ads (table), display_upload_ad (attribute)

display_url
STRING

expanded_dynamic_search_ad
OBJECT

description
STRING

description2
STRING

ads (table), expanded_dynamic_search_ad (attribute)

expanded_text_ad
OBJECT

description
STRING

description2
STRING

headline_part1
STRING

headline_part2
STRING

headline_part3
STRING

path1
STRING

path2
STRING

ads (table), expanded_text_ad (attribute)

final_app_urls
OBJECT, STRING

final_mobile_urls
STRING

final_url_suffix
STRING

final_urls
STRING

gmail_ad
OBJECT

header_image
OBJECT, STRING

marketing_image
OBJECT, STRING

marketing_image_description
STRING

marketing_image_display_call_to_action
OBJECT

text
STRING

text_color
STRING

url_collection_id
STRING

ads (table), marketing_image_display_call_to_action (attribute)

marketing_image_headline
STRING

product_images
OBJECT, STRING

product_image
OBJECT, STRING

ads (table), product_images (attribute)

product_videos
OBJECT, STRING

product_video
OBJECT, STRING

ads (table), product_videos (attribute)

teaser
OBJECT

business_name
STRING

description
STRING

headline
STRING

logo_image
OBJECT, STRING

ads (table), teaser (attribute)
ads (table), gmail_ad (attribute)

hotel_ad
OBJECT, STRING

id
INTEGER

image_ad
OBJECT

image_url
STRING

media_file
OBJECT, STRING

mime_type
STRING

name
STRING

pixel_height
INTEGER

pixel_width
INTEGER

preview_image_url
STRING

preview_pixel_height
INTEGER

preview_pixel_width
INTEGER

ads (table), image_ad (attribute)

labels
OBJECT, STRING

legacy_app_install_ad
OBJECT, STRING

legacy_responsive_display_ad
OBJECT

accent_color
STRING

allow_flexible_color
BOOLEAN

business_name
STRING

call_to_action_text
STRING

description
STRING

format_setting
STRING

logo_image
OBJECT, STRING

long_headline
STRING

main_color
STRING

marketing_image
OBJECT, STRING

price_prefix
STRING

promo_text
STRING

short_headline
STRING

square_logo_image
OBJECT, STRING

square_marketing_image
OBJECT, STRING

ads (table), legacy_responsive_display_ad (attribute)

local_ad
OBJECT

call_to_actions
OBJECT, STRING

descriptions
OBJECT, STRING

headlines
OBJECT, STRING

logo_images
OBJECT, STRING

asset
OBJECT, STRING

ads (table), logo_images (attribute)

marketing_images
OBJECT, STRING

asset
OBJECT, STRING

ads (table), marketing_images (attribute)

path1
STRING

path2
STRING

videos
OBJECT, STRING

asset
OBJECT, STRING

ads (table), videos (attribute)
ads (table), local_ad (attribute)

name
STRING

policy_summary
OBJECT

approval_status
STRING

policy_topic_entries
OBJECT, STRING

review_status
STRING

ads (table), policy_summary (attribute)

resource_name
OBJECT, STRING

responsive_display_ad
OBJECT

accent_color
STRING

allow_flexible_color
BOOLEAN

business_name
STRING

call_to_action_text
STRING

control_spec
OBJECT

enable_asset_enhancements
BOOLEAN

enable_autogen_video
BOOLEAN

ads (table), control_spec (attribute)

descriptions
OBJECT, STRING

format_setting
STRING

headlines
OBJECT, STRING

logo_images
OBJECT, STRING

asset
OBJECT, STRING

ads (table), logo_images (attribute)

long_headline
OBJECT, STRING

main_color
STRING

marketing_images
OBJECT, STRING

asset
OBJECT, STRING

ads (table), marketing_images (attribute)

price_prefix
STRING

promo_text
STRING

square_logo_images
OBJECT, STRING

asset
OBJECT, STRING

ads (table), square_logo_images (attribute)

square_marketing_images
OBJECT, STRING

asset
OBJECT, STRING

ads (table), square_marketing_images (attribute)

youtube_videos
OBJECT, STRING

asset
OBJECT, STRING

ads (table), youtube_videos (attribute)
ads (table), responsive_display_ad (attribute)

responsive_search_ad
OBJECT

descriptions
OBJECT, STRING

headlines
OBJECT, STRING

path1
STRING

path2
STRING

ads (table), responsive_search_ad (attribute)

shopping_comparison_listing_ad
OBJECT

headline
STRING

ads (table), shopping_comparison_listing_ad (attribute)

shopping_product_ad
OBJECT, STRING

shopping_smart_ad
OBJECT, STRING

smart_campaign_ad
OBJECT

descriptions
OBJECT, STRING

headlines
OBJECT, STRING

ads (table), smart_campaign_ad (attribute)

status
STRING

system_managed_resource_source
STRING

text_ad
OBJECT

description1
STRING

description2
STRING

headline
STRING

ads (table), text_ad (attribute)

tracking_url_template
STRING

type
STRING

url_collections
OBJECT, STRING

url_custom_parameters
OBJECT, STRING

video_ad
OBJECT

bumper
OBJECT

companion_banner
OBJECT

asset
OBJECT, STRING

ads (table), companion_banner (attribute)
ads (table), bumper (attribute)

in_feed
OBJECT

description1
STRING

description2
STRING

headline
STRING

thumbnail
STRING

ads (table), in_feed (attribute)

in_stream
OBJECT

action_button_label
STRING

action_headline
STRING

companion_banner
OBJECT

asset
OBJECT, STRING

ads (table), companion_banner (attribute)
ads (table), in_stream (attribute)

non_skippable
OBJECT

action_button_label
STRING

action_headline
STRING

companion_banner
OBJECT

asset
OBJECT, STRING

ads (table), companion_banner (attribute)
ads (table), non_skippable (attribute)

out_stream
OBJECT

description
STRING

headline
STRING

ads (table), out_stream (attribute)

video
OBJECT

asset
OBJECT, STRING

ads (table), video (attribute)
ads (table), video_ad (attribute)

video_responsive_ad
OBJECT

call_to_actions
OBJECT, STRING

companion_banners
OBJECT, STRING

asset
OBJECT, STRING

ads (table), companion_banners (attribute)

descriptions
OBJECT, STRING

headlines
OBJECT, STRING

long_headlines
OBJECT, STRING

videos
OBJECT, STRING

asset
OBJECT, STRING

ads (table), videos (attribute)
ads (table), video_responsive_ad (attribute)

Replication Method :

Full Table

Primary Key :

id

Official docs :

Official Docs

The ad_groups table contains detailed info about your ad groups.

This is a Core Object table.

accessible_bidding_strategy_id
INTEGER

ad_rotation_mode
STRING

audience_setting
OBJECT

use_audience_grouped
BOOLEAN

ad_groups (table), audience_setting (attribute)

base_ad_group
OBJECT, STRING

bidding_strategy_id
INTEGER

campaign
OBJECT, STRING

campaign_id
INTEGER

cpc_bid_micros
INTEGER

cpm_bid_micros
INTEGER

cpv_bid_micros
INTEGER

customer_id
INTEGER

display_custom_bid_dimension
STRING

effective_cpc_bid_micros
INTEGER

effective_target_cpa_micros
INTEGER

effective_target_cpa_source
STRING

effective_target_roas
SINGER.DECIMAL

effective_target_roas_source
STRING

excluded_parent_asset_field_types
STRING

explorer_auto_optimizer_setting
OBJECT

opt_in
BOOLEAN

ad_groups (table), explorer_auto_optimizer_setting (attribute)

final_url_suffix
STRING

id
INTEGER

labels
OBJECT, STRING

name
STRING

percent_cpc_bid_micros
INTEGER

resource_name
OBJECT, STRING

status
STRING

target_cpa_micros
INTEGER

target_cpm_micros
INTEGER

target_roas
SINGER.DECIMAL

targeting_setting
OBJECT

target_restrictions
OBJECT, STRING

ad_groups (table), targeting_setting (attribute)

tracking_url_template
STRING

type
STRING

url_custom_parameters
OBJECT, STRING


ad_group_audience_performance_report

Replication Method :

Key-based Incremental

Replication Key :

date

Primary Key :

_sdc_record_hash

Official docs :

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
STRING

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
DATE-TIME

The day the record pertains to.

customer_id
INTEGER

The ID of the Ads account that the record belongs to.

ad_group_id
INTEGER

The ID of the ad group that the record belongs to.

active_view_cpm
SINGER.DECIMAL

active_view_ctr
SINGER.DECIMAL

active_view_impressions
INTEGER

active_view_measurability
SINGER.DECIMAL

active_view_measurable_cost_micros
INTEGER

active_view_measurable_impressions
INTEGER

active_view_viewability
SINGER.DECIMAL

ad_group_base_ad_group
OBJECT, STRING

ad_group_campaign
OBJECT, STRING

ad_group_criterion_bid_modifier
SINGER.DECIMAL

ad_group_criterion_criterion_id
INTEGER

ad_group_criterion_effective_cpc_bid_micros
INTEGER

ad_group_criterion_effective_cpc_bid_source
STRING

ad_group_criterion_effective_cpm_bid_micros
INTEGER

ad_group_criterion_effective_cpm_bid_source
STRING

ad_group_criterion_final_mobile_urls
STRING

ad_group_criterion_final_urls
STRING

ad_group_criterion_status
STRING

ad_group_name
STRING

ad_group_status
STRING

ad_group_targeting_setting
OBJECT

target_restrictions
OBJECT, STRING

ad_group_audience_performance_report (table), ad_group_targeting_setting (attribute)

ad_group_tracking_url_template
STRING

ad_group_url_custom_parameters
OBJECT, STRING

ad_network_type
STRING

all_conversions
SINGER.DECIMAL

all_conversions_from_interactions_rate
SINGER.DECIMAL

all_conversions_value
SINGER.DECIMAL

average_cost
SINGER.DECIMAL

average_cpc
SINGER.DECIMAL

average_cpe
SINGER.DECIMAL

average_cpm
SINGER.DECIMAL

average_cpv
SINGER.DECIMAL

bidding_strategy_name
STRING

campaign_base_campaign
OBJECT, STRING

campaign_bidding_strategy
OBJECT, STRING

campaign_bidding_strategy_type
STRING

campaign_name
STRING

campaign_status
STRING

click_type
STRING

clicks
INTEGER

conversion_action
OBJECT, STRING

conversion_action_category
STRING

conversion_action_name
STRING

conversions
SINGER.DECIMAL

conversions_from_interactions_rate
SINGER.DECIMAL

conversions_value
SINGER.DECIMAL

cost_micros
INTEGER

cost_per_all_conversions
SINGER.DECIMAL

cost_per_conversion
SINGER.DECIMAL

cross_device_conversions
SINGER.DECIMAL

ctr
SINGER.DECIMAL

customer_currency_code
STRING

customer_descriptive_name
STRING

customer_time_zone
STRING

date
DATE-TIME

day_of_week
STRING

device
STRING

engagement_rate
SINGER.DECIMAL

engagements
INTEGER

external_conversion_source
STRING

gmail_forwards
INTEGER

gmail_saves
INTEGER

gmail_secondary_clicks
INTEGER

impressions
INTEGER

interaction_event_types
STRING

interaction_rate
SINGER.DECIMAL

interactions
INTEGER

month
DATE-TIME

month_of_year
STRING

quarter
DATE-TIME

slot
STRING

value_per_all_conversions
SINGER.DECIMAL

value_per_conversion
SINGER.DECIMAL

video_quartile_p100_rate
SINGER.DECIMAL

video_quartile_p25_rate
SINGER.DECIMAL

video_quartile_p50_rate
SINGER.DECIMAL

video_quartile_p75_rate
SINGER.DECIMAL

video_view_rate
SINGER.DECIMAL

video_views
INTEGER

view_through_conversions
INTEGER

week
DATE-TIME

year
INTEGER


ad_group_criterion

Replication Method :

Full Table

Primary Key :

criterion_id : ad_group_id

Official docs :

Official Docs

The ad_group_criterion table contains info about ad group criteria.

This is a Core Object table.

customer_id
INTEGER

campaign_id
INTEGER

resource_name
STRING

display_name
STRING

status
STRING

quality_info
OBJECT

creative_quality_score
STRING

post_click_quality_score
STRING

search_predicted_ctr
STRING

quality_score
INTEGER

ad_group_criterion (table), quality_info (attribute)

type
STRING

system_serving_status
STRING

approval_status
STRING

disapproval_reasons
ARRAY

reason
STRING

ad_group_criterion (table), disapproval_reasons (attribute)

labels
ARRAY

label
STRING

ad_group_criterion (table), labels (attribute)

effective_cpc_bid_source
STRING

effective_cpm_bid_source
STRING

effective_cpv_bid_source
STRING

effective_percent_cpc_bid_source
STRING

position_estimates
OBJECT

first_page_cpc_micros
INTEGER

first_position_cpc_micros
INTEGER

top_of_page_cpc_micros
INTEGER

estimated_add_clicks_at_first_position_cpc
INTEGER

estimated_add_cost_at_first_position_cpc
INTEGER

ad_group_criterion (table), position_estimates (attribute)

final_urls
ARRAY

url
STRING

ad_group_criterion (table), final_urls (attribute)

final_mobile_urls
ARRAY

url
STRING

ad_group_criterion (table), final_mobile_urls (attribute)

url_custom_parameters
ARRAY

parameter
OBJECT

key
STRING

value
STRING

ad_group_criterion (table), parameter (attribute)
ad_group_criterion (table), url_custom_parameters (attribute)

criterion_id
INTEGER

ad_group
STRING

ad_group_id
INTEGER

negative
BOOLEAN

bid_modifier
DOUBLE

cpc_bid_micros
INTEGER

cpm_bid_micros
INTEGER

cpv_bid_micros
INTEGER

percent_cpc_bid_micros
INTEGER

effective_cpc_bid_micros
INTEGER

effective_cpm_bid_micros
INTEGER

effective_cpv_bid_micros
INTEGER

effective_percent_cpc_bid_micros
INTEGER

final_url_suffix
STRING

tracking_url_template
STRING

criterion
OBJECT

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 :

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
STRING

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
DATE-TIME

The day the record pertains to.

customer_id
INTEGER

The ID of the Ads account that the record belongs to.

ad_group_id
INTEGER

The ID of the ad group that the record belongs to.

absolute_top_impression_percentage
SINGER.DECIMAL

active_view_cpm
SINGER.DECIMAL

active_view_ctr
SINGER.DECIMAL

active_view_impressions
INTEGER

active_view_measurability
SINGER.DECIMAL

active_view_measurable_cost_micros
INTEGER

active_view_measurable_impressions
INTEGER

active_view_viewability
SINGER.DECIMAL

ad_group_ad_rotation_mode
STRING

ad_group_base_ad_group
OBJECT, STRING

ad_group_cpc_bid_micros
INTEGER

ad_group_cpm_bid_micros
INTEGER

ad_group_cpv_bid_micros
INTEGER

ad_group_display_custom_bid_dimension
STRING

ad_group_effective_target_cpa_micros
INTEGER

ad_group_effective_target_cpa_source
STRING

ad_group_effective_target_roas
SINGER.DECIMAL

ad_group_effective_target_roas_source
STRING

ad_group_final_url_suffix
STRING

ad_group_name
STRING

ad_group_status
STRING

ad_group_tracking_url_template
STRING

ad_group_type
STRING

ad_group_url_custom_parameters
OBJECT, STRING

ad_network_type
STRING

all_conversions
SINGER.DECIMAL

all_conversions_from_interactions_rate
SINGER.DECIMAL

all_conversions_value
SINGER.DECIMAL

average_cost
SINGER.DECIMAL

average_cpc
SINGER.DECIMAL

average_cpe
SINGER.DECIMAL

average_cpm
SINGER.DECIMAL

average_cpv
SINGER.DECIMAL

average_page_views
SINGER.DECIMAL

average_time_on_site
SINGER.DECIMAL

bounce_rate
SINGER.DECIMAL

campaign_base_campaign
OBJECT, STRING

campaign_bidding_strategy
OBJECT, STRING

campaign_bidding_strategy_type
STRING

campaign_id
INTEGER

campaign_labels
STRING

campaign_manual_cpc
OBJECT

enhanced_cpc_enabled
BOOLEAN

ad_group_performance_report (table), campaign_manual_cpc (attribute)

campaign_name
STRING

campaign_percent_cpc
OBJECT

enhanced_cpc_enabled
BOOLEAN

ad_group_performance_report (table), campaign_percent_cpc (attribute)

campaign_status
STRING

click_type
STRING

clicks
INTEGER

content_impression_share
SINGER.DECIMAL

content_rank_lost_impression_share
SINGER.DECIMAL

conversion_action
OBJECT, STRING

conversion_action_category
STRING

conversion_action_name
STRING

conversion_adjustment
BOOLEAN

conversion_lag_bucket
STRING

conversion_or_adjustment_lag_bucket
STRING

conversions
SINGER.DECIMAL

conversions_from_interactions_rate
SINGER.DECIMAL

conversions_value
SINGER.DECIMAL

cost_micros
INTEGER

cost_per_all_conversions
SINGER.DECIMAL

cost_per_conversion
SINGER.DECIMAL

cost_per_current_model_attributed_conversion
SINGER.DECIMAL

cross_device_conversions
SINGER.DECIMAL

ctr
SINGER.DECIMAL

current_model_attributed_conversions
SINGER.DECIMAL

current_model_attributed_conversions_value
SINGER.DECIMAL

customer_currency_code
STRING

customer_descriptive_name
STRING

customer_time_zone
STRING

day_of_week
STRING

device
STRING

engagement_rate
SINGER.DECIMAL

engagements
INTEGER

external_conversion_source
STRING

gmail_forwards
INTEGER

gmail_saves
INTEGER

gmail_secondary_clicks
INTEGER

hour
INTEGER

impressions
INTEGER

interaction_event_types
STRING

interaction_rate
SINGER.DECIMAL

interactions
INTEGER

month
DATE-TIME

month_of_year
STRING

percent_new_visitors
SINGER.DECIMAL

phone_calls
INTEGER

phone_impressions
INTEGER

phone_through_rate
SINGER.DECIMAL

quarter
DATE-TIME

relative_ctr
SINGER.DECIMAL

search_absolute_top_impression_share
SINGER.DECIMAL

search_budget_lost_absolute_top_impression_share
SINGER.DECIMAL

search_budget_lost_top_impression_share
SINGER.DECIMAL

search_exact_match_impression_share
SINGER.DECIMAL

search_impression_share
SINGER.DECIMAL

search_rank_lost_absolute_top_impression_share
SINGER.DECIMAL

search_rank_lost_impression_share
SINGER.DECIMAL

search_rank_lost_top_impression_share
SINGER.DECIMAL

search_top_impression_share
SINGER.DECIMAL

slot
STRING

top_impression_percentage
SINGER.DECIMAL

value_per_all_conversions
SINGER.DECIMAL

value_per_conversion
SINGER.DECIMAL

value_per_current_model_attributed_conversion
SINGER.DECIMAL

video_quartile_p100_rate
SINGER.DECIMAL

video_quartile_p25_rate
SINGER.DECIMAL

video_quartile_p50_rate
SINGER.DECIMAL

video_quartile_p75_rate
SINGER.DECIMAL

video_view_rate
SINGER.DECIMAL

video_views
INTEGER

view_through_conversions
INTEGER

week
DATE-TIME

year
INTEGER


ad_performance_report

Replication Method :

Key-based Incremental

Replication Key :

date

Primary Key :

_sdc_record_hash

Official docs :

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
STRING

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
DATE-TIME

The day the record pertains to.

customer_id
INTEGER

The ID of the Ads account that the record belongs to.

ad_group_id
INTEGER

The ID of the ad group that the record belongs to.

campaign_id
INTEGER

The ID of the campaign that the record belongs to.

campaign_labels
STRING

absolute_top_impression_percentage
SINGER.DECIMAL

active_view_cpm
SINGER.DECIMAL

active_view_ctr
SINGER.DECIMAL

active_view_impressions
INTEGER

active_view_measurability
SINGER.DECIMAL

active_view_measurable_cost_micros
INTEGER

active_view_measurable_impressions
INTEGER

active_view_viewability
SINGER.DECIMAL

ad_group_ad_ad_strength
STRING

ad_group_ad_policy_summary
OBJECT

approval_status
STRING

policy_topic_entries
OBJECT, STRING

review_status
STRING

ad_performance_report (table), ad_group_ad_policy_summary (attribute)

ad_group_ad_status
STRING

ad_group_base_ad_group
OBJECT, STRING

ad_group_id
INTEGER

ad_group_name
STRING

ad_group_status
STRING

ad_network_type
STRING

added_by_google_ads
BOOLEAN

all_conversions
SINGER.DECIMAL

all_conversions_from_interactions_rate
SINGER.DECIMAL

all_conversions_value
SINGER.DECIMAL

app_ad
OBJECT

descriptions
OBJECT, STRING

headlines
OBJECT, STRING

html5_media_bundles
OBJECT, STRING

asset
OBJECT, STRING

ad_performance_report (table), html5_media_bundles (attribute)

images
OBJECT, STRING

asset
OBJECT, STRING

ad_performance_report (table), images (attribute)

mandatory_ad_text
OBJECT, STRING

youtube_videos
OBJECT, STRING

asset
OBJECT, STRING

ad_performance_report (table), youtube_videos (attribute)
ad_performance_report (table), app_ad (attribute)

average_cost
SINGER.DECIMAL

average_cpc
SINGER.DECIMAL

average_cpe
SINGER.DECIMAL

average_cpm
SINGER.DECIMAL

average_cpv
SINGER.DECIMAL

average_page_views
SINGER.DECIMAL

average_time_on_site
SINGER.DECIMAL

bounce_rate
SINGER.DECIMAL

call_ad
OBJECT

description1
STRING

description2
STRING

phone_number
STRING

ad_performance_report (table), call_ad (attribute)

campaign_base_campaign
OBJECT, STRING

campaign_name
STRING

campaign_status
STRING

click_type
STRING

clicks
INTEGER

conversion_action
OBJECT, STRING

conversion_action_category
STRING

conversion_action_name
STRING

conversion_adjustment
BOOLEAN

conversion_lag_bucket
STRING

conversion_or_adjustment_lag_bucket
STRING

conversions
SINGER.DECIMAL

conversions_from_interactions_rate
SINGER.DECIMAL

conversions_value
SINGER.DECIMAL

cost_micros
INTEGER

cost_per_all_conversions
SINGER.DECIMAL

cost_per_conversion
SINGER.DECIMAL

cost_per_current_model_attributed_conversion
SINGER.DECIMAL

cross_device_conversions
SINGER.DECIMAL

ctr
SINGER.DECIMAL

current_model_attributed_conversions
SINGER.DECIMAL

current_model_attributed_conversions_value
SINGER.DECIMAL

customer_currency_code
STRING

customer_descriptive_name
STRING

customer_time_zone
STRING

day_of_week
STRING

device
STRING

device_preference
STRING

display_url
STRING

engagement_rate
SINGER.DECIMAL

engagements
INTEGER

expanded_dynamic_search_ad
OBJECT

description
STRING

ad_performance_report (table), expanded_dynamic_search_ad (attribute)

expanded_text_ad
OBJECT

description
STRING

description2
STRING

headline_part1
STRING

headline_part2
STRING

headline_part3
STRING

path1
STRING

path2
STRING

ad_performance_report (table), expanded_text_ad (attribute)

external_conversion_source
STRING

final_mobile_urls
STRING

final_urls
STRING

gmail_forwards
INTEGER

gmail_saves
INTEGER

gmail_secondary_clicks
INTEGER

id
INTEGER

image_ad
OBJECT

image_url
STRING

mime_type
STRING

name
STRING

pixel_height
INTEGER

pixel_width
INTEGER

ad_performance_report (table), image_ad (attribute)

impressions
INTEGER

interaction_event_types
STRING

interaction_rate
SINGER.DECIMAL

interactions
INTEGER

keyword
OBJECT

ad_group_criterion
OBJECT, STRING

ad_performance_report (table), keyword (attribute)

legacy_responsive_display_ad
OBJECT

accent_color
STRING

allow_flexible_color
BOOLEAN

business_name
STRING

call_to_action_text
STRING

description
STRING

format_setting
STRING

logo_image
OBJECT, STRING