Google Ads integration summary

Stitch’s Google Ads integration replicates data using the Google Ads API (v15). 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 data equal to or newer than this date will be replicated to your data warehouse.

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

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

This is a Core Object table.

Replication Method

Full Table

Primary Key

id

Useful links

Google Ads documentation

customer_id

INTEGER

id

INTEGER

maximize_conversion_value

OBJECT

target_roas

SINGER.DECIMAL

maximize_conversions

OBJECT

name

STRING

owner_customer_id

INTEGER

owner_descriptive_name

STRING

resource_name

OBJECT, STRING

target_cpa

OBJECT

target_cpa_micros

INTEGER

target_impression_share

OBJECT

cpc_bid_ceiling_micros

INTEGER

location

STRING

location_fraction_micros

INTEGER

target_roas

OBJECT

target_roas

SINGER.DECIMAL

target_spend

OBJECT

cpc_bid_ceiling_micros

INTEGER

target_spend_micros

INTEGER

type

STRING

account_performance_report

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.

Replication Method

Key-based Incremental

Primary Key

_sdc_record_hash

Replication Key

date

Useful links

Google Ads documentation

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_id

INTEGER

customer_manager

BOOLEAN

customer_test_account

BOOLEAN

customer_time_zone

STRING

date

DATE-TIME

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

{{ system-column.record-hash }}

STRING

accounts

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

This is a Core Object table.

Replication Method

Full Table

Primary Key

id

Useful links

Google Ads documentation

accounts schema on GitHub

autoTaggingEnabled

BOOLEAN

callReportingSetting

OBJECT

callConversionAction

STRING

callConversionReportingEnabled

BOOLEAN

callReportingEnabled

BOOLEAN

conversionTrackingSetting

OBJECT

conversionTrackingId

INTEGER

crossAccountConversionTrackingId

INTEGER

currencyCode

STRING

definitions

OBJECT

CallReportingSetting

OBJECT

callConversionAction

STRING

callConversionReportingEnabled

BOOLEAN

callReportingEnabled

BOOLEAN

ConversionTrackingSetting

OBJECT

conversionTrackingId

INTEGER

crossAccountConversionTrackingId

INTEGER

RemarketingSetting

OBJECT

googleGlobalSiteTag

STRING

descriptiveName

STRING

finalUrlSuffix

STRING

hasPartnersBadge

BOOLEAN

id

INTEGER

manager

BOOLEAN

optimizationScore

NUMBER

optimizationScoreWeight

NUMBER

payPerConversionEligibilityFailureReasons

ARRAY

remarketingSetting

OBJECT

googleGlobalSiteTag

STRING

resourceName

STRING

testAccount

BOOLEAN

timeZone

STRING

trackingUrlTemplate

STRING

ad_group_criterion

The ad_group_criterion table contains info about ad group criteria.

This is a Core Object table.

Replication Method

Full Table

Primary Keys

criterion_id

ad_group_id

Useful links

Google Ads documentation

ad_group

STRING

ad_group_id

INTEGER

approval_status

STRING

bid_modifier

DOUBLE

campaign_id

INTEGER

cpc_bid_micros

INTEGER

cpm_bid_micros

INTEGER

cpv_bid_micros

INTEGER

criterion

OBJECT

criterion_id

INTEGER

customer_id

INTEGER

disapproval_reasons

ARRAY

display_name

STRING

effective_cpc_bid_micros

INTEGER

effective_cpc_bid_source

STRING

effective_cpm_bid_micros

INTEGER

effective_cpm_bid_source

STRING

effective_cpv_bid_micros

INTEGER

effective_cpv_bid_source

STRING

effective_percent_cpc_bid_micros

INTEGER

effective_percent_cpc_bid_source

STRING

final_mobile_urls

ARRAY

final_url_suffix

STRING

final_urls

ARRAY

labels

ARRAY

label

STRING

negative

BOOLEAN

percent_cpc_bid_micros

INTEGER

position_estimates

OBJECT

estimated_add_clicks_at_first_position_cpc

INTEGER

estimated_add_cost_at_first_position_cpc

INTEGER

first_page_cpc_micros

INTEGER

first_position_cpc_micros

INTEGER

top_of_page_cpc_micros

INTEGER

quality_info

OBJECT

creative_quality_score

STRING

post_click_quality_score

STRING

quality_score

INTEGER

search_predicted_ctr

STRING

resource_name

STRING

status

STRING

system_serving_status

STRING

tracking_url_template

STRING

type

STRING

url_custom_parameters

ARRAY

parameter

OBJECT

key

STRING

value

STRING

ad_group_performance_report

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.

Replication Method

Key-based Incremental

Primary Key

_sdc_record_hash

Replication Key

date

Useful links

Google Ads documentation

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_id

INTEGER

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

campaign_name

STRING

campaign_percent_cpc

OBJECT

enhanced_cpc_enabled

BOOLEAN

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_id

INTEGER

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

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

{{ system-column.record-hash }}

STRING

ad_groups

The ad_groups table contains detailed info about your ad groups.

This is a Core Object table.

Replication Method

Full Table

Primary Key

id

Useful links

Google Ads documentation

ad_groups schema on GitHub

adRotationMode

STRING

baseAdGroup

STRING

campaign

STRING

cpcBidMicros

INTEGER

cpmBidMicros

INTEGER

cpvBidMicros

INTEGER

definitions

OBJECT

CustomParameter

OBJECT

key

STRING

value

STRING

ExplorerAutoOptimizerSetting

OBJECT

TargetRestriction

OBJECT

bidOnly

BOOLEAN

targetingDimension

STRING

TargetRestrictionOperation

OBJECT

operator

STRING

value

OBJECT

bidOnly

BOOLEAN

targetingDimension

STRING

TargetingSetting

OBJECT

targetRestrictionOperations

ARRAY

targetRestrictions

ARRAY

bidOnly

BOOLEAN

targetingDimension

STRING

displayCustomBidDimension

STRING

effectiveTargetCpaMicros

INTEGER

effectiveTargetCpaSource

STRING

effectiveTargetRoas

NUMBER

effectiveTargetRoasSource

STRING

excludedParentAssetFieldTypes

ARRAY

explorerAutoOptimizerSetting

OBJECT

finalUrlSuffix

STRING

id

INTEGER

labels

ARRAY

name

STRING

percentCpcBidMicros

INTEGER

resourceName

STRING

status

STRING

targetCpaMicros

INTEGER

targetCpmMicros

INTEGER

targetRoas

NUMBER

targetingSetting

OBJECT

targetRestrictionOperations

ARRAY

targetRestrictions

ARRAY

bidOnly

BOOLEAN

targetingDimension

STRING

trackingUrlTemplate

STRING

type

STRING

urlCustomParameters

ARRAY

ad_performance_report

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.

Replication Method

Key-based Incremental

Primary Key

_sdc_record_hash

Replication Key

date

Useful links

Google Ads documentation

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_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

images

OBJECT, STRING

asset

OBJECT, STRING

mandatory_ad_text

OBJECT, STRING

youtube_videos

OBJECT, STRING

asset

OBJECT, STRING

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

campaign_base_campaign

OBJECT, STRING

campaign_id

INTEGER

campaign_labels

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_id

INTEGER

customer_time_zone

STRING

date

DATE-TIME

day_of_week

STRING

device

STRING

device_preference

STRING

display_url

STRING

engagement_rate

SINGER.DECIMAL

engagements

INTEGER

expanded_dynamic_search_ad

OBJECT

expanded_text_ad

OBJECT

description

STRING

description2

STRING

headline_part1

STRING

headline_part2

STRING

headline_part3

STRING

path1

STRING

path2

STRING

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

impressions

INTEGER

interaction_event_types

STRING

interaction_rate

SINGER.DECIMAL

interactions

INTEGER

keyword

OBJECT

ad_group_criterion

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

month

DATE-TIME

month_of_year

STRING

percent_new_visitors

SINGER.DECIMAL

quarter

DATE-TIME

responsive_display_ad

OBJECT

accent_color

STRING

allow_flexible_color

BOOLEAN

business_name

STRING

call_to_action_text

STRING

descriptions

OBJECT, STRING

format_setting

STRING

headlines

OBJECT, STRING

logo_images

OBJECT, STRING

asset

OBJECT, STRING

long_headline

OBJECT, STRING

main_color

STRING

marketing_images

OBJECT, STRING

asset

OBJECT, STRING

price_prefix

STRING

promo_text

STRING

square_logo_images

OBJECT, STRING

asset

OBJECT, STRING

square_marketing_images

OBJECT, STRING

youtube_videos

OBJECT, STRING

asset

OBJECT, STRING

responsive_search_ad

OBJECT

descriptions

OBJECT, STRING

headlines

OBJECT, STRING

path1

STRING

path2

STRING

slot

STRING

system_managed_resource_source

STRING

text_ad

OBJECT

description1

STRING

description2

STRING

headline

STRING

top_impression_percentage

SINGER.DECIMAL

tracking_url_template

STRING

type

STRING

url_custom_parameters

OBJECT, STRING

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

{{ system-column.record-hash }}

STRING

ads

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

This is a Core Object table.

Replication Method

Full Table

Primary Key

id

Useful links

Google Ads documentation

ads schema on GitHub

addedByGoogleAds

BOOLEAN

appAd

OBJECT

descriptions

ARRAY

headlines

ARRAY

html5MediaBundles

ARRAY

images

ARRAY

mandatoryAdText

OBJECT

assetPerformanceLabel

STRING

pinnedField

STRING

policySummaryInfo

OBJECT

approvalStatus

STRING

policyTopicEntries

ARRAY

reviewStatus

STRING

text

STRING

youtubeVideos

ARRAY

appEngagementAd

OBJECT

descriptions

ARRAY

headlines

ARRAY

images

ARRAY

videos

ARRAY

appPreRegistrationAd

OBJECT

descriptions

ARRAY

headlines

ARRAY

images

ARRAY

youtubeVideos

ARRAY

callAd

OBJECT

businessName

STRING

callTracked

BOOLEAN

conversionAction

STRING

conversionReportingState

STRING

countryCode

STRING

description1

STRING

description2

STRING

disableCallConversion

BOOLEAN

headline1

STRING

headline2

STRING

path1

STRING

path2

STRING

phoneNumber

STRING

phoneNumberVerificationUrl

STRING

definitions

OBJECT

AdAssetPolicySummary

OBJECT

approvalStatus

STRING

policyTopicEntries

ARRAY

reviewStatus

STRING

AdImageAsset

OBJECT

AdMediaBundleAsset

OBJECT

AdTextAsset

OBJECT

assetPerformanceLabel

STRING

pinnedField

STRING

policySummaryInfo

OBJECT

approvalStatus

STRING

policyTopicEntries

ARRAY

reviewStatus

STRING

text

STRING

AdVideoAsset

OBJECT

AppAdInfo

OBJECT

descriptions

ARRAY

headlines

ARRAY

html5MediaBundles

ARRAY

images

ARRAY

mandatoryAdText

OBJECT

assetPerformanceLabel

STRING

pinnedField

STRING

policySummaryInfo

OBJECT

approvalStatus

STRING

policyTopicEntries

ARRAY

reviewStatus

STRING

text

STRING

youtubeVideos

ARRAY

AppEngagementAdInfo

OBJECT

descriptions

ARRAY

headlines

ARRAY

images

ARRAY

videos

ARRAY

AppPreRegistrationAdInfo

OBJECT

descriptions

ARRAY

headlines

ARRAY

images

ARRAY

youtubeVideos

ARRAY

CallAdInfo

OBJECT

businessName

STRING

callTracked

BOOLEAN

conversionAction

STRING

conversionReportingState

STRING

countryCode

STRING

description1

STRING

description2

STRING

disableCallConversion

BOOLEAN

headline1

STRING

headline2

STRING

path1

STRING

path2

STRING

phoneNumber

STRING

phoneNumberVerificationUrl

STRING

CountryConstraint

OBJECT

countryCriterion

STRING

CountryConstraintList

OBJECT

countries

ARRAY

totalTargetedCountries

INTEGER

CustomParameter

OBJECT

key

STRING

value

STRING

DestinationMismatch

OBJECT

DestinationNotWorking

OBJECT

device

STRING

dnsErrorType

STRING

expandedUrl

STRING

httpErrorCode

INTEGER

lastCheckedDateTime

DATE-TIME

DestinationTextList

OBJECT

destinationTexts

ARRAY

DisplayCallToAction

OBJECT

text

STRING

textColor

STRING

urlCollectionId

STRING

DisplayUploadAdInfo

OBJECT

displayUploadProductType

STRING

mediaBundle

OBJECT

ExpandedDynamicSearchAdInfo

OBJECT

description

STRING

description2

STRING

ExpandedTextAdInfo

OBJECT

description

STRING

description2

STRING

headlinePart1

STRING

headlinePart2

STRING

headlinePart3

STRING

path1

STRING

path2

STRING

FinalAppUrl

OBJECT

osType

STRING

url

STRING

GmailAdInfo

OBJECT

headerImage

STRING

marketingImage

STRING

marketingImageDescription

STRING

marketingImageDisplayCallToAction

OBJECT

text

STRING

textColor

STRING

urlCollectionId

STRING

marketingImageHeadline

STRING

productImages

ARRAY

productVideos

ARRAY

teaser

OBJECT

businessName

STRING

description

STRING

headline

STRING

logoImage

STRING

GmailTeaser

OBJECT

businessName

STRING

description

STRING

headline

STRING

logoImage

STRING

HotelAdInfo

OBJECT

ImageAdInfo

OBJECT

adIdToCopyImageFrom

INTEGER

imageUrl

STRING

mediaFile

STRING

mimeType

STRING

name

STRING

pixelHeight

INTEGER

pixelWidth

INTEGER

previewImageUrl

STRING

previewPixelHeight

INTEGER

previewPixelWidth

INTEGER

LegacyAppInstallAdInfo

OBJECT

appId

STRING

appStore

STRING

description1

STRING

description2

STRING

headline

STRING

LegacyResponsiveDisplayAdInfo

OBJECT

accentColor

STRING

allowFlexibleColor

BOOLEAN

businessName

STRING

callToActionText

STRING

description

STRING

formatSetting

STRING

logoImage

STRING

longHeadline

STRING

mainColor

STRING

marketingImage

STRING

pricePrefix

STRING

promoText

STRING

shortHeadline

STRING

squareLogoImage

STRING

squareMarketingImage

STRING

LocalAdInfo

OBJECT

callToActions

ARRAY

descriptions

ARRAY

headlines

ARRAY

logoImages

ARRAY

marketingImages

ARRAY

path1

STRING

path2

STRING

videos

ARRAY

PolicyTopicConstraint

OBJECT

certificateDomainMismatchInCountryList

OBJECT

countries

ARRAY

totalTargetedCountries

INTEGER

certificateMissingInCountryList

OBJECT

countries

ARRAY

totalTargetedCountries

INTEGER

countryConstraintList

OBJECT

countries

ARRAY

totalTargetedCountries

INTEGER

resellerConstraint

OBJECT

PolicyTopicEntry

OBJECT

constraints

ARRAY

evidences

ARRAY

topic

STRING

type

STRING

PolicyTopicEvidence

OBJECT

destinationMismatch

OBJECT

destinationNotWorking

OBJECT

device

STRING

dnsErrorType

STRING

expandedUrl

STRING

httpErrorCode

INTEGER

lastCheckedDateTime

DATE-TIME

destinationTextList

OBJECT

destinationTexts

ARRAY

languageCode

STRING

textList

OBJECT

websiteList

OBJECT

ProductImage

OBJECT

description

STRING

displayCallToAction

OBJECT

text

STRING

textColor

STRING

urlCollectionId

STRING

productImage

STRING

ProductVideo

OBJECT

productVideo

STRING

ResellerConstraint

OBJECT

ResponsiveDisplayAdControlSpec

OBJECT

enableAssetEnhancements

BOOLEAN

enableAutogenVideo

BOOLEAN

ResponsiveDisplayAdInfo

OBJECT

accentColor

STRING

allowFlexibleColor

BOOLEAN

businessName

STRING

callToActionText

STRING

controlSpec

OBJECT

enableAssetEnhancements

BOOLEAN

enableAutogenVideo

BOOLEAN

descriptions

ARRAY

formatSetting

STRING

headlines

ARRAY

logoImages

ARRAY

longHeadline

OBJECT

assetPerformanceLabel

STRING

pinnedField

STRING

policySummaryInfo

OBJECT

approvalStatus

STRING

policyTopicEntries

ARRAY

reviewStatus

STRING

text

STRING

mainColor

STRING

marketingImages

ARRAY

pricePrefix

STRING

promoText

STRING

squareLogoImages

ARRAY

squareMarketingImages

ARRAY

youtubeVideos

ARRAY

ResponsiveSearchAdInfo

OBJECT

descriptions

ARRAY

headlines

ARRAY

path1

STRING

path2

STRING

ShoppingComparisonListingAdInfo

OBJECT

ShoppingProductAdInfo

OBJECT

ShoppingSmartAdInfo

OBJECT

SmartCampaignAdInfo

OBJECT

descriptions

ARRAY

headlines

ARRAY

TextAdInfo

OBJECT

description1

STRING

description2

STRING

headline

STRING

TextList

OBJECT

UrlCollection

OBJECT

finalMobileUrls

ARRAY

finalUrls

ARRAY

trackingUrlTemplate

STRING

urlCollectionId

STRING

VideoAdInfo

OBJECT

bumper

OBJECT

companionBanner

OBJECT

discovery

OBJECT

description1

STRING

description2

STRING

headline

STRING

thumbnail

STRING

inStream

OBJECT

actionButtonLabel

STRING

actionHeadline

STRING

companionBanner

OBJECT

nonSkippable

OBJECT

actionButtonLabel

STRING

actionHeadline

STRING

companionBanner

OBJECT

outStream

OBJECT

description

STRING

headline

STRING

video

OBJECT

asset

STRING

VideoBumperInStreamAdInfo

OBJECT

VideoNonSkippableInStreamAdInfo

OBJECT

actionButtonLabel

STRING

actionHeadline

STRING

companionBanner

OBJECT

VideoOutstreamAdInfo

OBJECT

description

STRING

headline

STRING

VideoResponsiveAdInfo

OBJECT

callToActions

ARRAY

companionBanners

ARRAY

descriptions

ARRAY

headlines

ARRAY

longHeadlines

ARRAY

videos

ARRAY

VideoTrueViewDiscoveryAdInfo

OBJECT

description1

STRING

description2

STRING

headline

STRING

thumbnail

STRING

VideoTrueViewInStreamAdInfo

OBJECT

actionButtonLabel

STRING

actionHeadline

STRING

companionBanner

OBJECT

WebsiteList

OBJECT

devicePreference

STRING

displayUploadAd

OBJECT

displayUploadProductType

STRING

mediaBundle

OBJECT

displayUrl

STRING

expandedDynamicSearchAd

OBJECT

description

STRING

description2

STRING

expandedTextAd

OBJECT

description

STRING

description2

STRING

headlinePart1

STRING

headlinePart2

STRING

headlinePart3

STRING

path1

STRING

path2

STRING

finalAppUrls

ARRAY

finalMobileUrls

ARRAY

finalUrlSuffix

STRING

finalUrls

ARRAY

gmailAd

OBJECT

headerImage

STRING

marketingImage

STRING

marketingImageDescription

STRING

marketingImageDisplayCallToAction

OBJECT

text

STRING

textColor

STRING

urlCollectionId

STRING

marketingImageHeadline

STRING

productImages

ARRAY

productVideos

ARRAY

teaser

OBJECT

businessName

STRING

description

STRING

headline

STRING

logoImage

STRING

hotelAd

OBJECT

id

INTEGER

imageAd

OBJECT

adIdToCopyImageFrom

INTEGER

imageUrl

STRING

mediaFile

STRING

mimeType

STRING

name

STRING

pixelHeight

INTEGER

pixelWidth

INTEGER

previewImageUrl

STRING

previewPixelHeight

INTEGER

previewPixelWidth

INTEGER

legacyAppInstallAd

OBJECT

appId

STRING

appStore

STRING

description1

STRING

description2

STRING

headline

STRING

legacyResponsiveDisplayAd

OBJECT

accentColor

STRING

allowFlexibleColor

BOOLEAN

businessName

STRING

callToActionText

STRING

description

STRING

formatSetting

STRING

logoImage

STRING

longHeadline

STRING

mainColor

STRING

marketingImage

STRING

pricePrefix

STRING

promoText

STRING

shortHeadline

STRING

squareLogoImage

STRING

squareMarketingImage

STRING

localAd

OBJECT

callToActions

ARRAY

descriptions

ARRAY

headlines

ARRAY

logoImages

ARRAY

marketingImages

ARRAY

path1

STRING

path2

STRING

videos

ARRAY

name

STRING

resourceName

STRING

responsiveDisplayAd

OBJECT

accentColor

STRING

allowFlexibleColor

BOOLEAN

businessName

STRING

callToActionText

STRING

controlSpec

OBJECT

enableAssetEnhancements

BOOLEAN

enableAutogenVideo

BOOLEAN

descriptions

ARRAY

formatSetting

STRING

headlines

ARRAY

logoImages

ARRAY

longHeadline

OBJECT

assetPerformanceLabel

STRING

pinnedField

STRING

policySummaryInfo

OBJECT

approvalStatus

STRING

policyTopicEntries

ARRAY

reviewStatus

STRING

text

STRING

mainColor

STRING

marketingImages

ARRAY

pricePrefix

STRING

promoText

STRING

squareLogoImages

ARRAY

squareMarketingImages

ARRAY

youtubeVideos

ARRAY

responsiveSearchAd

OBJECT

descriptions

ARRAY

headlines

ARRAY

path1

STRING

path2

STRING

shoppingComparisonListingAd

OBJECT

shoppingProductAd

OBJECT

shoppingSmartAd

OBJECT

smartCampaignAd

OBJECT

descriptions

ARRAY

headlines

ARRAY

systemManagedResourceSource

STRING

textAd

OBJECT

description1

STRING

description2

STRING

headline

STRING

trackingUrlTemplate

STRING

type

STRING

urlCollections

ARRAY

urlCustomParameters

ARRAY

videoAd

OBJECT

bumper

OBJECT

companionBanner

OBJECT

discovery

OBJECT

description1

STRING

description2

STRING

headline

STRING

thumbnail

STRING

inStream

OBJECT

actionButtonLabel

STRING

actionHeadline

STRING

companionBanner

OBJECT

nonSkippable

OBJECT

actionButtonLabel

STRING

actionHeadline

STRING

companionBanner

OBJECT

outStream

OBJECT

description

STRING

headline

STRING

video

OBJECT

asset

STRING

videoResponsiveAd

OBJECT

callToActions

ARRAY

companionBanners

ARRAY

descriptions

ARRAY

headlines

ARRAY

longHeadlines

ARRAY

videos

ARRAY

age_range_performance_report

The age_range_performance_report table contains all Display Network and YouTube Network statistics aggregated by age range.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method

Key-based Incremental

Primary Key

_sdc_record_hash

Replication Key

date

Useful links

Google Ads documentation

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_criterion_age_range

OBJECT

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_negative

BOOLEAN

ad_group_criterion_status

STRING

ad_group_criterion_tracking_url_template

STRING

ad_group_criterion_url_custom_parameters

OBJECT, STRING

ad_group_id

INTEGER

ad_group_name

STRING

ad_group_status

STRING

ad_group_targeting_setting

OBJECT

target_restrictions

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_id

INTEGER

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_id

INTEGER

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

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

{{ system-column.record-hash }}

STRING

bidding_strategies

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

This is a Core Object table.

Replication Method

Full Table

Primary Key

id

Useful links

Google Ads documentation

campaign_count

INTEGER

currency_code

STRING

customer_id

INTEGER

effective_currency_code

STRING

enhanced_cpc

OBJECT, STRING

id

INTEGER

maximize_conversion_value

OBJECT

cpc_bid_ceiling_micros

INTEGER

cpc_bid_floor_micros

INTEGER

target_roas

SINGER.DECIMAL

maximize_conversions

OBJECT

cpc_bid_ceiling_micros

INTEGER

cpc_bid_floor_micros

INTEGER

target_cpa

INTEGER

name

STRING

non_removed_campaign_count

INTEGER

resource_name

OBJECT, STRING

status

STRING

target_cpa

OBJECT

cpc_bid_ceiling_micros

INTEGER

cpc_bid_floor_micros

INTEGER

target_cpa_micros

INTEGER

target_impression_share

OBJECT

cpc_bid_ceiling_micros

INTEGER

location

STRING

location_fraction_micros

INTEGER

target_roas

OBJECT

cpc_bid_ceiling_micros

INTEGER

cpc_bid_floor_micros

INTEGER

target_roas

SINGER.DECIMAL

target_spend

OBJECT

cpc_bid_ceiling_micros

INTEGER

target_spend_micros

INTEGER

type

STRING

call_details

The call_details table contains info about call tracking of call-only ads or call extensions.

This is a Core Object table.

Replication Method

Full Table

Primary Key

resource_name

Useful links

Google Ads documentation

ad_group_id

INTEGER

call_duration_seconds

INTEGER

call_status

STRING

call_tracking_display_location

STRING

caller_area_code

STRING

caller_country_code

STRING

campaign_id

INTEGER

customer_id

INTEGER

end_call_date_time

STRING

resource_name

STRING

start_call_date_time

STRING

type

STRING

campaign_audience_performance_report

The campaign_audience_performance_report table contains all statistics aggregated by default at the campaign level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method

Key-based Incremental

Primary Key

_sdc_record_hash

Replication Key

date

Useful links

Google Ads documentation

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_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

bidding_strategy_name

STRING

bounce_rate

SINGER.DECIMAL

campaign_advertising_channel_sub_type

STRING

campaign_advertising_channel_type

STRING

campaign_base_campaign

OBJECT, STRING

campaign_bidding_strategy

OBJECT, STRING

campaign_bidding_strategy_type

STRING

campaign_budget_amount_micros

INTEGER

campaign_budget_explicitly_shared

BOOLEAN

campaign_budget_has_recommended_budget

BOOLEAN

campaign_budget_period

STRING

campaign_budget_recommended_budget_amount_micros

INTEGER

campaign_budget_total_amount_micros

INTEGER

campaign_campaign_budget

OBJECT, STRING

campaign_criterion_age_range_type

STRING

campaign_criterion_combined_audience_combined_audience

STRING

campaign_criterion_criterion_id

INTEGER

campaign_end_date

DATE-TIME

campaign_experiment_type

STRING

campaign_final_url_suffix

STRING

campaign_id

INTEGER

campaign_manual_cpc

OBJECT

enhanced_cpc_enabled

BOOLEAN

campaign_maximize_conversion_value

OBJECT

campaign_name

STRING

campaign_percent_cpc

OBJECT

enhanced_cpc_enabled

BOOLEAN

campaign_serving_status

STRING

campaign_start_date

DATE-TIME

campaign_status

STRING

campaign_tracking_url_template

STRING

campaign_url_custom_parameters

OBJECT, STRING

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_attribution_event_type

STRING

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_id

INTEGER

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

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

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_impression_share

SINGER.DECIMAL

search_budget_lost_top_impression_share

SINGER.DECIMAL

search_click_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

{{ system-column.record-hash }}

STRING

campaign_budgets

The campaign_budgets table contains info about campaign budgets in your Google Ads account.

This is a Core Object table.

Replication Method

Full Table

Primary Key

id

Useful links

Google Ads documentation

amount_micros

INTEGER

customer_id

INTEGER

delivery_method

STRING

explicitly_shared

BOOLEAN

has_recommended_budget

BOOLEAN

id

INTEGER

name

STRING

period

STRING

recommended_budget_amount_micros

INTEGER

recommended_budget_estimated_change_weekly_clicks

INTEGER

recommended_budget_estimated_change_weekly_cost_micros

INTEGER

recommended_budget_estimated_change_weekly_interactions

INTEGER

recommended_budget_estimated_change_weekly_views

INTEGER

reference_count

INTEGER

resource_name

OBJECT, STRING

status

STRING

total_amount_micros

INTEGER

type

STRING

campaign_criterion

The campaign_criterion table contains info about campaign criteria.

This is a Core Object table.

Replication Method

Full Table

Primary Key

criterion_id

Useful links

Google Ads documentation

bid_modifier

FLOAT

campaign

STRING

campaign_id

INTEGER

criterion

OBJECT

criterion_id

INTEGER

customer_id

INTEGER

display_name

STRING

negative

BOOLEAN

resource_name

STRING

status

STRING

campaign_labels

The campaign_labels table contains info about the relationship between campaigns and labels.

This is a Core Object table.

Replication Method

Full Table

Primary Key

resource_name

Useful links

Google Ads documentation

campaign

STRING

label

STRING

resource_name

STRING

campaign_performance_report

The campaign_performance_report table contains all statistics aggregated by default at the campaign level.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method

Key-based Incremental

Primary Key

_sdc_record_hash

Replication Key

date

Useful links

Google Ads documentation

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_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

bidding_strategy_name

STRING

bounce_rate

SINGER.DECIMAL

campaign_advertising_channel_sub_type

STRING

campaign_advertising_channel_type

STRING

campaign_base_campaign

OBJECT, STRING

campaign_bidding_strategy

OBJECT, STRING

campaign_bidding_strategy_type

STRING

campaign_budget_amount_micros

INTEGER

campaign_budget_explicitly_shared

BOOLEAN

campaign_budget_has_recommended_budget

BOOLEAN

campaign_budget_period

STRING

campaign_budget_recommended_budget_amount_micros

INTEGER

campaign_budget_total_amount_micros

INTEGER

campaign_campaign_budget

OBJECT, STRING

campaign_end_date

DATE-TIME

campaign_experiment_type

STRING

campaign_final_url_suffix

STRING

campaign_id

INTEGER

campaign_labels

STRING

campaign_manual_cpc

OBJECT

enhanced_cpc_enabled

BOOLEAN

campaign_maximize_conversion_value

OBJECT

campaign_name

STRING

campaign_percent_cpc

OBJECT

enhanced_cpc_enabled

BOOLEAN

campaign_serving_status

STRING

campaign_start_date

DATE-TIME

campaign_status

STRING

campaign_tracking_url_template

STRING

campaign_url_custom_parameters

OBJECT, STRING

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_attribution_event_type

STRING

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_id

INTEGER

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

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

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_impression_share

SINGER.DECIMAL

search_budget_lost_top_impression_share

SINGER.DECIMAL

search_click_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

{{ system-column.record-hash }}

STRING

campaigns

The campaigns table contains detailed info about your Google Ads campaigns.

This is a Core Object table.

Replication Method

Full Table

Primary Key

id

Useful links

Google Ads documentation

campaigns schema on GitHub

accessibleBiddingStrategy

STRING

adServingOptimizationStatus

STRING

advertisingChannelSubType

STRING

advertisingChannelType

STRING

appCampaignSetting

OBJECT

appId

STRING

appStore

STRING

biddingStrategyGoalType

STRING

baseCampaign

STRING

biddingStrategy

STRING

biddingStrategyType

STRING

campaignBudget

STRING

commission

OBJECT

commissionRateMicros

INTEGER

definitions

OBJECT

AppCampaignSetting

OBJECT

appId

STRING

appStore

STRING

biddingStrategyGoalType

STRING

Commission

OBJECT

commissionRateMicros

INTEGER

CustomParameter

OBJECT

key

STRING

value

STRING

DynamicSearchAdsSetting

OBJECT

domainName

STRING

feeds

ARRAY

languageCode

STRING

useSuppliedUrlsOnly

BOOLEAN

FrequencyCapEntry

OBJECT

cap

INTEGER

key

OBJECT

eventType

STRING

level

STRING

timeLength

INTEGER

timeUnit

STRING

FrequencyCapKey

OBJECT

eventType

STRING

level

STRING

timeLength

INTEGER

timeUnit

STRING

GeoTargetTypeSetting

OBJECT

negativeGeoTargetType

STRING

positiveGeoTargetType

STRING

HotelSettingInfo

OBJECT

hotelCenterId

INTEGER

LocalCampaignSetting

OBJECT

locationSourceType

STRING

ManualCpc

OBJECT

enhancedCpcEnabled

BOOLEAN

ManualCpm

OBJECT

ManualCpv

OBJECT

MaximizeConversionValue

OBJECT

cpcBidCeilingMicros

INTEGER

cpcBidFloorMicros

INTEGER

targetRoas

NUMBER

MaximizeConversions

OBJECT

cpcBidCeilingMicros

INTEGER

cpcBidFloorMicros

INTEGER

targetCpa

INTEGER

NetworkSettings

OBJECT

targetContentNetwork

BOOLEAN

targetGoogleSearch

BOOLEAN

targetPartnerSearchNetwork

BOOLEAN

targetSearchNetwork

BOOLEAN

OptimizationGoalSetting

OBJECT

optimizationGoalTypes

ARRAY

PercentCpc

OBJECT

cpcBidCeilingMicros

INTEGER

enhancedCpcEnabled

BOOLEAN

RealTimeBiddingSetting

OBJECT

SelectiveOptimization

OBJECT

conversionActions

ARRAY

ShoppingSetting

OBJECT

campaignPriority

INTEGER

enableLocal

BOOLEAN

merchantId

INTEGER

salesCountry

STRING

TargetCpa

OBJECT

cpcBidCeilingMicros

INTEGER

cpcBidFloorMicros

INTEGER

targetCpaMicros

INTEGER

TargetCpm

OBJECT

TargetImpressionShare

OBJECT

cpcBidCeilingMicros

INTEGER

location

STRING

locationFractionMicros

INTEGER

TargetRestriction

OBJECT

bidOnly

BOOLEAN

targetingDimension

STRING

TargetRestrictionOperation

OBJECT

operator

STRING

value

OBJECT

bidOnly

BOOLEAN

targetingDimension

STRING

TargetRoas

OBJECT

cpcBidCeilingMicros

INTEGER

cpcBidFloorMicros

INTEGER

targetRoas

NUMBER

TargetSpend

OBJECT

cpcBidCeilingMicros

INTEGER

targetSpendMicros

INTEGER

TargetingSetting

OBJECT

targetRestrictionOperations

ARRAY

targetRestrictions

ARRAY

bidOnly

BOOLEAN

targetingDimension

STRING

TrackingSetting

OBJECT

trackingUrl

STRING

VanityPharma

OBJECT

vanityPharmaDisplayUrlMode

STRING

vanityPharmaText

STRING

dynamicSearchAdsSetting

OBJECT

domainName

STRING

feeds

ARRAY

languageCode

STRING

useSuppliedUrlsOnly

BOOLEAN

endDate

DATE-TIME

excludedParentAssetFieldTypes

ARRAY

experimentType

STRING

finalUrlSuffix

STRING

frequencyCaps

ARRAY

geoTargetTypeSetting

OBJECT

negativeGeoTargetType

STRING

positiveGeoTargetType

STRING

hotelSetting

OBJECT

hotelCenterId

INTEGER

id

INTEGER

labels

ARRAY

localCampaignSetting

OBJECT

locationSourceType

STRING

manualCpc

OBJECT

enhancedCpcEnabled

BOOLEAN

manualCpm

OBJECT

manualCpv

OBJECT

maximizeConversionValue

OBJECT

cpcBidCeilingMicros

INTEGER

cpcBidFloorMicros

INTEGER

targetRoas

NUMBER

maximizeConversions

OBJECT

cpcBidCeilingMicros

INTEGER

cpcBidFloorMicros

INTEGER

targetCpa

INTEGER

name

STRING

networkSettings

OBJECT

targetContentNetwork

BOOLEAN

targetGoogleSearch

BOOLEAN

targetPartnerSearchNetwork

BOOLEAN

targetSearchNetwork

BOOLEAN

optimizationGoalSetting

OBJECT

optimizationGoalTypes

ARRAY

optimizationScore

NUMBER

paymentMode

STRING

percentCpc

OBJECT

cpcBidCeilingMicros

INTEGER

enhancedCpcEnabled

BOOLEAN

realTimeBiddingSetting

OBJECT

resourceName

STRING

selectiveOptimization

OBJECT

conversionActions

ARRAY

servingStatus

STRING

shoppingSetting

OBJECT

campaignPriority

INTEGER

enableLocal

BOOLEAN

merchantId

INTEGER

salesCountry

STRING

startDate

DATE-TIME

status

STRING

targetCpa

OBJECT

cpcBidCeilingMicros

INTEGER

cpcBidFloorMicros

INTEGER

targetCpaMicros

INTEGER

targetCpm

OBJECT

targetImpressionShare

OBJECT

cpcBidCeilingMicros

INTEGER

location

STRING

locationFractionMicros

INTEGER

targetRoas

OBJECT

cpcBidCeilingMicros

INTEGER

cpcBidFloorMicros

INTEGER

targetRoas

NUMBER

targetSpend

OBJECT

cpcBidCeilingMicros

INTEGER

targetSpendMicros

INTEGER

targetingSetting

OBJECT

targetRestrictionOperations

ARRAY

targetRestrictions

ARRAY

bidOnly

BOOLEAN

targetingDimension

STRING

trackingSetting

OBJECT

trackingUrl

STRING

trackingUrlTemplate

STRING

urlCustomParameters

ARRAY

urlExpansionOptOut

BOOLEAN

vanityPharma

OBJECT

vanityPharmaDisplayUrlMode

STRING

vanityPharmaText

STRING

videoBrandSafetySuitability

STRING

carrier_constant

The carrier_constant table contains info about carrier criteria that can be used in campaign targeting.

This is a Core Object table.

Note: In order to replicate this table, you must also set the campaign_criterion table to replicate.

Replication Method

Full Table

campaign_criterion

Useful links

Google Ads documentation

country_code

STRING

id

INTEGER

name

STRING

resource_name

STRING

click_performance_report

The click_performance_report table contains statistics aggregated at each click level, and includes both valid and invalid clicks.

This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.

Replication Method

Key-based Incremental

Primary Key

_sdc_record_hash

Replication Key

date

Useful links

Google Ads documentation

ad_group_id

INTEGER

ad_group_name

STRING

ad_group_status

STRING

ad_network_type

STRING

campaign_id

INTEGER

campaign_labels

STRING

campaign_name

STRING

campaign_status

STRING

click_type

STRING

click_view_ad_group_ad

OBJECT, STRING

click_view_area_of_interest

OBJECT

city

OBJECT, STRING

country

OBJECT, STRING

metro

OBJECT, STRING

most_specific

OBJECT, STRING

region

OBJECT, STRING

click_view_campaign_location_target

OBJECT, STRING

click_view_gclid

STRING