Google Ads (v1)
Last updated: 9/15/2026This integration is powered by Singer's Google Ads tap and certified by Stitch. Check out and contribute to the repo on GitHub.
For support, contact Support.
Google Ads integration summary
Stitch’s Google Ads integration replicates data using the Google Ads API (v18). Refer to the Schema section for a list of objects available for replication.
This integration replaces the Google Ads (Adwords) integration.
Note: To use the Ads API, an Ads account must be connected to a manager account.
Google Ads feature snapshot
A high-level look at Stitch's Google Ads (v1) integration, including release status, useful links, and the features supported in Stitch.
| STITCH | |||
| Release status |
Deprecated on August 20, 2025 |
Supported by
Indicates if the integration is supported by Stitch or the Singer community. |
|
|
Stitch plan
The type of Stitch plan required to use the integration. |
Standard |
API availability
Indicates if the integration is available as a source in Stitch Connect. |
This version of the integration isn't available via the API. |
| Singer GitHub repository | |||
| REPLICATION SETTINGS | |||
|
Anchor Scheduling
A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. |
This feature is supported for this version of the integration. |
Advanced Scheduling
A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. |
This feature is supported for this version of the integration. |
|
Table-level reset
Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. |
Table-level resets are not supported for this integration. Resets are only supported at the integration level. |
Configurable Replication Methods
Indicates if Replication Methods can be defined by you for tables in the integration. |
Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate. |
| DATA SELECTION | |||
|
Table selection
The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. |
This feature is supported for this version of the integration. |
Column selection
The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. |
This feature is supported for this version of the integration. |
|
Select all
Indicates if the integration supports selecting all available tables and columns. |
The API used by this integration (Google Ads API (v18)) doesn't support selecting all fields due to compatibility rules. |
||
| TRANSPARENCY | |||
|
Extraction Logs
Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. |
This feature is supported for this version of the integration. |
Loading Reports
Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. |
This feature is supported for this version of the integration. |
Connecting Google Ads
Google Ads setup requirements
To set up Google Ads in Stitch, you need:
-
To pause any ad-blocking software. Ad blockers can interfere with pop-ups, which are used in Google authorization and may prevent authorization from successfully completing.
-
Access to the Google Ads data you want to replicate. Before beginning, verify that the user creating the integration has access to the reports you want to replicate.
-
To connect your Ads account to a manager account. This will ensure your account has access to the Ads API, thereby allowing Stitch to query for and extract data.
An manager account is an Ads account type that enables you to manage several Ads accounts under a single login. Think of manager accounts as trees: they can branch out to individual accounts or even other manager accounts. Read more about manager accounts here.
By default, regular advertiser accounts - that is, individual Ads accounts - don’t have access to the Ads API. To gain access, they must be linked to an manager account. If you don’t have an manager account, create one using these instructions and then link it to your Ads account by following these steps.
Step 1: Add Google Ads as a Stitch data source
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the Google Ads icon.
-
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch Google Ads” would create a schema called
stitch_google_adsin 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:
-
Advanced Scheduling using Cron (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 5: Authorize Stitch & Select Google Ads Profiles
- Next, you’ll be prompted to log into your Google account and to approve Stitch’s access to your Google Ads data. Note: We will only ever read your data.
- Click Authorize to continue.
-
After your credentials are validated, you’ll be prompted to select the Google Ads profile(s) you want to connect to Stitch.
If you don’t see the profile(s) you want to connect, verify that you have completed the setup requirements.
-
When selecting profiles, keep the following in mind:
- You cannot select more than 1000 profiles per Google Ads integration. Selecting a large number of profiles can reduce performance, so it is recommended to select fewer profiles if possible. You can select more profiles by adding additional Google Ads integrations in your Stitch account.
- Selecting a subprofile will also select the parent, or top-level profile. If you de-select the top-level profile, you will be unable to select any subprofiles.
- If multiple profiles are selected, data for all the selected profiles will map to the same table in your destination. For example: If two profiles are selected and the
accountstable is tracked, account data for both profiles will be replicated into theaccountstable. This is applicable to every table selected in the next step. To distinguish different profiles, make sure to select thecustomer_idfield in your tables.
- When finished selecting profiles, click Continue.
Step 6: Set objects to replicate
Column selection and Google compatibility rules
Because of Google’s compatibility rules, some columns (metrics and segments) can’t be tracked together. As you select columns to track, incompatible fields will automatically be greyed out.
You can create additional Google Ads integrations if you need to track incompatible columns. The resulting table names will still be the same (ex: account_performance_report) but the data will reside in different schemas in your data warehouse.
Initial and historical replication jobs
After you finish setting up Google Ads, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Google Ads replication
There are two types of tables in Stitch’s Google Ads integration: Core Object and Report.
- Core Object tables contain foundational data that’s useful for analysis. These are the following tables:
accountsad_groupsadscampaignsaccessible_bidding_strategiesbidding_strategiescampaign_budgetscall_detailsad_group_criterioncampaign_criterioncampaign_labelscarrier_constantfeedfeed_itemlabelslanguage_constantmobile_app_category_constantmobile_device_constantoperating_system_verison_constanttopic_constantuser_interestuser_list
These tables are replicated using Full Table Replication.
- Report tables are the various Google Ads reports. The replication process for these tables is a bit unlike that of other tables:
- Extraction: Data is extracted using a Conversion Window. A Conversion Window is a period of time after a customer clicks an ad that a conversion (ex: a purchase) is recorded in Google Ads.
The Conversion Window can be configured when creating the integration and can be edited in the integration settings at any time.
- Loading: Data is loaded into your data warehouse using Upsert Replication.
Each part of the replication process for Report tables is explained below.
Report tables: Data extraction and conversion windows
For historical and full re-replications of Google Ads data, Stitch will query for and extract data newer than or equal to the date defined in the Start Date field in the Integration Settings page.
The Start Date, in conjunction with the Conversion Window, defines the minimum date Stitch should query for when extracting historical data. This is calculated as:
Start Date - Conversion Window = Minimum Extraction Date
Example
During the initial set up, the Start Date field is set to July 3, 2017, or 2017-07-03 00:00:00.
To account for the Conversion Window, Stitch would calculate the Minimum Extraction Date value as: 2017-07-03 00:00:00 - 30 days = 2017-06-03 00:00:00
If you were to write a SQL query using this date for the ad_performance_report table, it might look like this:
SELECT *
FROM google_ads.ad_performance_report
WHERE date >= '2017-06-03 00:00:00' /* Min. Extraction Date */
ORDER BY date
For ongoing replication jobs, Stitch will query for and extract data using the last saved maximum value in the table’s Replication Key column and the Conversion Window for the table.
Note: This applies to every replication job that takes place after the historical replication job.
Example
The last maximum saved Replication Key value for the ad_performance_report table is 2017-10-01 00:00:00.
To account for the Conversion Window of 30 days, we’d subtract this from the last maximum saved Replication Key value:
2017-10-01 00:00:00 - 30 days = 2017-09-01 00:00:00
In this case, Stitch would query for and extract data that is newer than or equal to 2017-09-01 00:00:00 and older than or equal to 2017-10-01 00:00:00.
If this were a SQL query, it might look like this:
SELECT *
FROM ad_performance_report
WHERE date >= '2017-09-01 00:00:00'
/* max Replication Key value - Conversion Window */
AND date <= '2017-10-01 00:00:00'
/* max Replication Key value from previous job */
ORDER BY date
Report tables: Edit report segments and attributes
In report tables, a Primary Key _sdc_record_hash is built using the segments and attributes selected when creating the report.
Modifying segments and attributes after the report is created and data has already been replicated may cause data quality issues. To avoid this, it is recommended to truncate your destination table before editing a report. You can then replicate the historical data from the updated report by resetting it from its Table Settings page.
Google Ads table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 1 of this integration.
Report tables: Values for money fields
When conducting analyses on Report tables, you might notice that values in money fields - like a cost field, for example - look higher than usual. This is because Google Ads’ API sends Stitch money data in micro currency units. Micro amounts always refer to your account’s local currency.
For example: The value of $2.25USD will be recorded as 2250000. To represent this value as 2.25 in a report, divide by one million: 2250000 / 1000000 = 2.25.
Report tables: Column selection and statistic aggregation
The dimension columns selected for replication in Report tables can impact how performance statistics are aggregated. Additionally, this can also affect the number of rows replicated and loaded into your destination.
For example: if date, customer_id, campaign_id, device, and impressions were selected, the impressions column would contain the total number of impressions for the device type for that date:
| date | customer_id | campaign_id | device | impressions |
|---|---|---|---|---|
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | DESKTOP | 4 |
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | HIGH_END_MOBILE | 3 |
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | TABLET | 3 |
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | UNKNOWN | 1 |
If the ad_network_type column were also selected, a row for every unique combination of device and ad_network_type would be created and impressions would be aggregated accordingly:
| date | customer_id | campaign_id | device | ad_network_type | impressions |
|---|---|---|---|---|---|
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | DESKTOP | YOUTUBE_SEARCH | 3 |
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | HIGH_END_MOBILE | YOUTUBE_SEARCH | 1 |
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | TABLET | YOUTUBE_SEARCH | 0 |
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | UNKNOWN | YOUTUBE_SEARCH | 0 |
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | DESKTOP | SEARCH | 1 |
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | HIGH_END_MOBILE | SEARCH | 2 |
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | TABLET | SEARCH | 3 |
| 2018-01-05 00:00:00 | 1585293495 | 240531207 | UNKNOWN | SEARCH | 1 |
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.
accessible_bidding_strategies
The accessible_bidding_strategies table contains info about accessible bidding strategies in your Google Ads account.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
customer_id INTEGER |
|||
|
id INTEGER |
|||
|
maximize_conversion_value OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
maximize_conversions OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
name STRING |
|||
|
owner_customer_id INTEGER |
|||
|
owner_descriptive_name STRING |
|||
|
resource_name OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||
|
target_cpa OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
target_impression_share OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
target_roas OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
target_spend OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
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.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
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.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
autoTaggingEnabled BOOLEAN |
|||||||||
|
callReportingSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||
|
conversionTrackingSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||
|
currencyCode STRING |
|||||||||
|
definitions OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||
|
descriptiveName STRING |
|||||||||
|
finalUrlSuffix STRING |
|||||||||
|
hasPartnersBadge BOOLEAN |
|||||||||
|
id INTEGER |
|||||||||
|
manager BOOLEAN |
|||||||||
|
optimizationScore NUMBER |
|||||||||
|
optimizationScoreWeight NUMBER |
|||||||||
|
payPerConversionEligibilityFailureReasons ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||||||
|
remarketingSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||
|
resourceName STRING |
|||||||||
|
testAccount BOOLEAN |
|||||||||
|
timeZone STRING |
|||||||||
|
trackingUrlTemplate STRING |
ad_group_criterion
The ad_group_criterion table contains info about ad group criteria.
|
Full Table |
|
|
Primary Keys |
criterion_id ad_group_id |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
criterion_id INTEGER |
|||||
|
customer_id INTEGER |
|||||
|
disapproval_reasons ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
final_url_suffix STRING |
|||||
|
final_urls ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
labels ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
negative BOOLEAN |
|||||
|
percent_cpc_bid_micros INTEGER |
|||||
|
position_estimates OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
quality_info OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
resource_name STRING |
|||||
|
status STRING |
|||||
|
system_serving_status STRING |
|||||
|
tracking_url_template STRING |
|||||
|
type STRING |
|||||
|
url_custom_parameters ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
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.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_bidding_strategy OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_bidding_strategy_type STRING |
|
|
campaign_id INTEGER |
|
|
campaign_labels STRING |
|
|
campaign_manual_cpc OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
campaign_name STRING |
|
|
campaign_percent_cpc OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
campaign_status STRING |
|
|
click_type STRING |
|
|
clicks INTEGER |
|
|
content_impression_share SINGER.DECIMAL |
|
|
content_rank_lost_impression_share SINGER.DECIMAL |
|
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
adRotationMode STRING |
||||||||||||||||||
|
baseAdGroup STRING |
||||||||||||||||||
|
campaign STRING |
||||||||||||||||||
|
cpcBidMicros INTEGER |
||||||||||||||||||
|
cpmBidMicros INTEGER |
||||||||||||||||||
|
cpvBidMicros INTEGER |
||||||||||||||||||
|
definitions OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||
|
displayCustomBidDimension STRING |
||||||||||||||||||
|
effectiveTargetCpaMicros INTEGER |
||||||||||||||||||
|
effectiveTargetCpaSource STRING |
||||||||||||||||||
|
effectiveTargetRoas NUMBER |
||||||||||||||||||
|
effectiveTargetRoasSource STRING |
||||||||||||||||||
|
excludedParentAssetFieldTypes ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||
|
explorerAutoOptimizerSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||
|
finalUrlSuffix STRING |
||||||||||||||||||
|
id INTEGER |
||||||||||||||||||
|
labels ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||
|
name STRING |
||||||||||||||||||
|
percentCpcBidMicros INTEGER |
||||||||||||||||||
|
resourceName STRING |
||||||||||||||||||
|
status STRING |
||||||||||||||||||
|
targetCpaMicros INTEGER |
||||||||||||||||||
|
targetCpmMicros INTEGER |
||||||||||||||||||
|
targetRoas NUMBER |
||||||||||||||||||
|
targetingSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||
|
trackingUrlTemplate STRING |
||||||||||||||||||
|
type STRING |
||||||||||||||||||
|
urlCustomParameters ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
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.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
ad_group_ad_status STRING |
|||||||||||||||||||||
|
ad_group_base_ad_group OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||||||||||||||||||
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
campaign_base_campaign OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||||||||||||||||||
|
campaign_id INTEGER |
|||||||||||||||||||||
|
campaign_labels STRING |
|||||||||||||||||||||
|
campaign_name STRING |
|||||||||||||||||||||
|
campaign_status STRING |
|||||||||||||||||||||
|
click_type STRING |
|||||||||||||||||||||
|
clicks INTEGER |
|||||||||||||||||||||
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||||||||||||||||||
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
expanded_text_ad OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
impressions INTEGER |
|||||||||||||||||||||
|
interaction_event_types STRING |
|||||||||||||||||||||
|
interaction_rate SINGER.DECIMAL |
|||||||||||||||||||||
|
interactions INTEGER |
|||||||||||||||||||||
|
keyword OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
legacy_responsive_display_ad OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
month DATE-TIME |
|||||||||||||||||||||
|
month_of_year STRING |
|||||||||||||||||||||
|
percent_new_visitors SINGER.DECIMAL |
|||||||||||||||||||||
|
quarter DATE-TIME |
|||||||||||||||||||||
|
responsive_display_ad OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
responsive_search_ad OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
slot STRING |
|||||||||||||||||||||
|
system_managed_resource_source STRING |
|||||||||||||||||||||
|
text_ad OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||||||||||||||||
|
top_impression_percentage SINGER.DECIMAL |
|||||||||||||||||||||
|
tracking_url_template STRING |
|||||||||||||||||||||
|
type STRING |
|||||||||||||||||||||
|
url_custom_parameters OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||||||||||||||||||
|
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.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
addedByGoogleAds BOOLEAN |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
appAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
appEngagementAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
appPreRegistrationAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
callAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
definitions OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
devicePreference STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
displayUploadAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
displayUrl STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
expandedDynamicSearchAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
expandedTextAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
finalAppUrls ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
finalMobileUrls ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
finalUrlSuffix STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
finalUrls ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
gmailAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
hotelAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
id INTEGER |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
imageAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
legacyAppInstallAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
legacyResponsiveDisplayAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
localAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
name STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
resourceName STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
responsiveDisplayAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
responsiveSearchAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
shoppingComparisonListingAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
shoppingProductAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
shoppingSmartAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
smartCampaignAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
systemManagedResourceSource STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
textAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
trackingUrlTemplate STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
type STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
urlCollections ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
urlCustomParameters ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
videoAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
videoResponsiveAd OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
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.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
ad_group_criterion_age_range OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
ad_group_id INTEGER |
|
|
ad_group_name STRING |
|
|
ad_group_status STRING |
|
|
ad_group_targeting_setting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_bidding_strategy OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_bidding_strategy_type STRING |
|
|
campaign_id INTEGER |
|
|
campaign_name STRING |
|
|
campaign_status STRING |
|
|
click_type STRING |
|
|
clicks INTEGER |
|
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
campaign_count INTEGER |
|||
|
currency_code STRING |
|||
|
customer_id INTEGER |
|||
|
effective_currency_code STRING |
|||
|
enhanced_cpc OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||
|
id INTEGER |
|||
|
maximize_conversion_value OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
maximize_conversions OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
name STRING |
|||
|
non_removed_campaign_count INTEGER |
|||
|
resource_name OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||
|
status STRING |
|||
|
target_cpa OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
target_impression_share OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
target_roas OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
target_spend OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
type STRING |
call_details
The call_details table contains info about call tracking of call-only ads or call extensions.
|
Full Table |
|
|
Primary Key |
resource_name |
| Useful links |
|
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.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_bidding_strategy OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
campaign_maximize_conversion_value OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
campaign_name STRING |
|
|
campaign_percent_cpc OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
campaign_serving_status STRING |
|
|
campaign_start_date DATE-TIME |
|
|
campaign_status STRING |
|
|
campaign_tracking_url_template STRING |
|
|
campaign_url_custom_parameters OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
status STRING |
|
total_amount_micros INTEGER |
|
type STRING |
campaign_criterion
The campaign_criterion table contains info about campaign criteria.
|
Full Table |
|
|
Primary Key |
criterion_id |
| Useful links |
|
bid_modifier FLOAT |
|
campaign STRING |
|
campaign_id INTEGER |
|
criterion OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
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.
|
Full Table |
|
|
Primary Key |
resource_name |
| Useful links |
|
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.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_bidding_strategy OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_end_date DATE-TIME |
|
|
campaign_experiment_type STRING |
|
|
campaign_final_url_suffix STRING |
|
|
campaign_id INTEGER |
|
|
campaign_labels STRING |
|
|
campaign_manual_cpc OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
campaign_maximize_conversion_value OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
campaign_name STRING |
|
|
campaign_percent_cpc OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
campaign_serving_status STRING |
|
|
campaign_start_date DATE-TIME |
|
|
campaign_status STRING |
|
|
campaign_tracking_url_template STRING |
|
|
campaign_url_custom_parameters OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
accessibleBiddingStrategy STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
adServingOptimizationStatus STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
advertisingChannelSubType STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
advertisingChannelType STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
appCampaignSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
baseCampaign STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
biddingStrategy STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
biddingStrategyType STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
campaignBudget STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
commission OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
definitions OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
dynamicSearchAdsSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
endDate DATE-TIME |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
excludedParentAssetFieldTypes ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
experimentType STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
finalUrlSuffix STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
frequencyCaps ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
geoTargetTypeSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
hotelSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
id INTEGER |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
labels ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
localCampaignSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
manualCpc OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
manualCpm OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
manualCpv OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
maximizeConversionValue OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
maximizeConversions OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
name STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
networkSettings OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
optimizationGoalSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
optimizationScore NUMBER |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
paymentMode STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
percentCpc OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
realTimeBiddingSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
resourceName STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
selectiveOptimization OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
servingStatus STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
shoppingSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
startDate DATE-TIME |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
status STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
targetCpa OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
targetCpm OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
targetImpressionShare OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
targetRoas OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
targetSpend OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
targetingSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
trackingSetting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
trackingUrlTemplate STRING |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
urlCustomParameters ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
urlExpansionOptOut BOOLEAN |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
vanityPharma OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
videoBrandSafetySuitability STRING |
carrier_constant
The carrier_constant table contains info about carrier criteria that can be used in campaign targeting.
Note: In order to replicate this table, you must also set the campaign_criterion table to replicate.
|
Full Table |
|
|
campaign_criterion |
|
| Useful links |
|
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.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
click_view_area_of_interest OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
click_view_campaign_location_target OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
click_view_gclid STRING |
|||||
|
click_view_location_of_presence OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
click_view_page_number INTEGER |
|||||
|
click_view_user_list OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
clicks INTEGER |
|||||
|
customer_descriptive_name STRING |
|||||
|
customer_id INTEGER |
|||||
|
date DATE-TIME |
|||||
|
device STRING |
|||||
|
month_of_year STRING |
|||||
|
slot STRING |
|||||
|
{{ system-column.record-hash }} STRING |
display_keyword_performance_report
The display_keyword_performance_report table contains all Display Network and YouTube Network statistics aggregated at the keyword level.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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_effective_cpv_bid_micros INTEGER |
|
|
ad_group_criterion_effective_cpv_bid_source STRING |
|
|
ad_group_criterion_final_mobile_urls STRING |
|
|
ad_group_criterion_final_urls STRING |
|
|
ad_group_criterion_keyword OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
ad_group_id INTEGER |
|
|
ad_group_name STRING |
|
|
ad_group_status STRING |
|
|
ad_group_targeting_setting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_bidding_strategy OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_bidding_strategy_type STRING |
|
|
campaign_id INTEGER |
|
|
campaign_labels STRING |
|
|
campaign_name STRING |
|
|
campaign_status STRING |
|
|
click_type STRING |
|
|
clicks INTEGER |
|
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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 |
display_topics_performance_report
The display_topics_performance_report table contains all Display Network and YouTube Network statistics aggregated at the topic level.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||
|
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_topic OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||
|
ad_group_criterion_tracking_url_template STRING |
||
|
ad_group_criterion_url_custom_parameters OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||
|
ad_group_id INTEGER |
||
|
ad_group_name STRING |
||
|
ad_group_status STRING |
||
|
ad_group_targeting_setting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||
|
campaign_bidding_strategy OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||
|
campaign_bidding_strategy_type STRING |
||
|
campaign_id INTEGER |
||
|
campaign_labels STRING |
||
|
campaign_name STRING |
||
|
campaign_status STRING |
||
|
click_type STRING |
||
|
clicks INTEGER |
||
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
||
|
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 |
expanded_landing_page_report
The expanded_landing_page_report table contains
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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_id INTEGER |
|
ad_group_name STRING |
|
ad_group_status STRING |
|
ad_network_type STRING |
|
all_conversions SINGER.DECIMAL |
|
average_cost SINGER.DECIMAL |
|
average_cpc SINGER.DECIMAL |
|
average_cpe SINGER.DECIMAL |
|
average_cpm SINGER.DECIMAL |
|
average_cpv SINGER.DECIMAL |
|
campaign_advertising_channel_type STRING |
|
campaign_id INTEGER |
|
campaign_labels STRING |
|
campaign_name STRING |
|
campaign_status STRING |
|
click_type STRING |
|
clicks INTEGER |
|
conversions SINGER.DECIMAL |
|
conversions_from_interactions_rate SINGER.DECIMAL |
|
conversions_value SINGER.DECIMAL |
|
cost_micros INTEGER |
|
cost_per_conversion SINGER.DECIMAL |
|
cross_device_conversions SINGER.DECIMAL |
|
ctr SINGER.DECIMAL |
|
date DATE-TIME |
|
day_of_week STRING |
|
device STRING |
|
engagement_rate SINGER.DECIMAL |
|
engagements INTEGER |
|
expanded_landing_page_view_expanded_final_url STRING |
|
impressions INTEGER |
|
interaction_event_types STRING |
|
interaction_rate SINGER.DECIMAL |
|
interactions INTEGER |
|
mobile_friendly_clicks_percentage SINGER.DECIMAL |
|
month DATE-TIME |
|
month_of_year STRING |
|
quarter DATE-TIME |
|
slot STRING |
|
speed_score INTEGER |
|
valid_accelerated_mobile_pages_clicks_percentage SINGER.DECIMAL |
|
value_per_conversion SINGER.DECIMAL |
|
video_view_rate SINGER.DECIMAL |
|
video_views INTEGER |
|
week DATE-TIME |
|
year INTEGER |
|
{{ system-column.record-hash }} STRING |
feed
The feed table contains info about feeds.
Note: In order to replicate this table, you must also set the campaign_criterion table to replicate.
|
Full Table |
|
|
Primary Key |
id |
|
campaign_criterion |
|
| Useful links |
|
attribute_operations ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||
|
attributes ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||||
|
customer_id INTEGER |
|||||||
|
id INTEGER |
|||||||
|
name STRING |
|||||||
|
origin STRING |
|||||||
|
resource_name STRING |
|||||||
|
status STRING |
|||||||
|
system_feed_generation_data OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
feed_item
The feed_item table contains infor about a feed item.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
attribute_values ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||
|
customer_id INTEGER |
||||||||||||||||||||||||
|
end_date_time STRING |
||||||||||||||||||||||||
|
feed STRING |
||||||||||||||||||||||||
|
feed_id INTEGER |
||||||||||||||||||||||||
|
geo_targeting_restriction STRING |
||||||||||||||||||||||||
|
id INTEGER |
||||||||||||||||||||||||
|
policy_infos ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||||||||||||||
|
resource_name STRING |
||||||||||||||||||||||||
|
start_date_time STRING |
||||||||||||||||||||||||
|
status STRING |
||||||||||||||||||||||||
|
url_custom_parameters ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
gender_performance_report
The gender_performance_report table contains all statistics aggregated by gender.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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_gender OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
ad_group_id INTEGER |
|
|
ad_group_name STRING |
|
|
ad_group_status STRING |
|
|
ad_group_targeting_setting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
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 |
|
|
bidding_strategy_type STRING |
|
|
campaign_base_campaign OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_bidding_strategy OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_id INTEGER |
|
|
campaign_labels STRING |
|
|
campaign_name STRING |
|
|
campaign_status STRING |
|
|
click_type STRING |
|
|
clicks INTEGER |
|
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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 |
geo_performance_report
The geo_performance_report table contains all statistics aggregated at the country/territory level.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
ad_group_id INTEGER |
|
ad_group_name STRING |
|
ad_group_status 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_cpm SINGER.DECIMAL |
|
average_cpv SINGER.DECIMAL |
|
campaign_id INTEGER |
|
campaign_labels STRING |
|
campaign_name STRING |
|
campaign_status STRING |
|
clicks INTEGER |
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
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 |
|
external_conversion_source STRING |
|
geo_target_city OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
geo_target_metro OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
geo_target_most_specific_location OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
geo_target_region OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
geographic_view_country_criterion_id INTEGER |
|
geographic_view_location_type STRING |
|
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_view_rate SINGER.DECIMAL |
|
video_views INTEGER |
|
view_through_conversions INTEGER |
|
week DATE-TIME |
|
year INTEGER |
|
{{ system-column.record-hash }} STRING |
keywordless_query_report
The keywordless_query_report includes keywordless ads (dynamic search ads) statistics based on search terms.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
ad_group_id INTEGER |
|
ad_group_name STRING |
|
ad_group_status STRING |
|
all_conversions SINGER.DECIMAL |
|
all_conversions_from_interactions_rate SINGER.DECIMAL |
|
all_conversions_value SINGER.DECIMAL |
|
average_cpc SINGER.DECIMAL |
|
average_cpm SINGER.DECIMAL |
|
campaign_id INTEGER |
|
campaign_labels STRING |
|
campaign_name STRING |
|
campaign_status STRING |
|
clicks INTEGER |
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
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 |
|
dynamic_search_ads_search_term_view_headline STRING |
|
dynamic_search_ads_search_term_view_landing_page STRING |
|
dynamic_search_ads_search_term_view_page_url STRING |
|
dynamic_search_ads_search_term_view_search_term STRING |
|
external_conversion_source STRING |
|
impressions INTEGER |
|
month DATE-TIME |
|
month_of_year STRING |
|
quarter DATE-TIME |
|
value_per_all_conversions SINGER.DECIMAL |
|
value_per_conversion SINGER.DECIMAL |
|
webpage OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
week DATE-TIME |
|
year INTEGER |
|
{{ system-column.record-hash }} STRING |
keywords_performance_report
The keywords_performance_report table contains all statistics aggregated at the keyword level.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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_base_ad_group OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
ad_group_criterion_approval_status STRING |
|||||
|
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_final_mobile_urls STRING |
|||||
|
ad_group_criterion_final_url_suffix STRING |
|||||
|
ad_group_criterion_final_urls STRING |
|||||
|
ad_group_criterion_keyword OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
ad_group_criterion_negative BOOLEAN |
|||||
|
ad_group_criterion_position_estimates OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
ad_group_criterion_quality_info OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
ad_group_criterion_status STRING |
|||||
|
ad_group_criterion_system_serving_status STRING |
|||||
|
ad_group_criterion_topic OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
ad_group_criterion_tracking_url_template STRING |
|||||
|
ad_group_criterion_url_custom_parameters OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
ad_group_id INTEGER |
|||||
|
ad_group_name STRING |
|||||
|
ad_group_status 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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
campaign_bidding_strategy OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
campaign_bidding_strategy_type STRING |
|||||
|
campaign_id INTEGER |
|||||
|
campaign_labels STRING |
|||||
|
campaign_manual_cpc OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
campaign_name STRING |
|||||
|
campaign_percent_cpc OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
campaign_status STRING |
|||||
|
click_type STRING |
|||||
|
clicks INTEGER |
|||||
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
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 |
|||||
|
historical_creative_quality_score STRING |
|||||
|
historical_landing_page_quality_score STRING |
|||||
|
historical_quality_score INTEGER |
|||||
|
historical_search_predicted_ctr STRING |
|||||
|
impressions INTEGER |
|||||
|
interaction_event_types STRING |
|||||
|
interaction_rate SINGER.DECIMAL |
|||||
|
interactions INTEGER |
|||||
|
month DATE-TIME |
|||||
|
month_of_year STRING |
|||||
|
percent_new_visitors SINGER.DECIMAL |
|||||
|
quarter DATE-TIME |
|||||
|
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 |
labels
The labels table contains info about labels.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
id INTEGER |
||
|
name STRING |
||
|
resource_name STRING |
||
|
status STRING |
||
|
text_label OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
landing_page_report
The landing_page_report table contains
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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_id INTEGER |
|
ad_group_name STRING |
|
ad_group_status STRING |
|
ad_network_type STRING |
|
all_conversions SINGER.DECIMAL |
|
average_cost SINGER.DECIMAL |
|
average_cpc SINGER.DECIMAL |
|
average_cpe SINGER.DECIMAL |
|
average_cpm SINGER.DECIMAL |
|
average_cpv SINGER.DECIMAL |
|
campaign_advertising_channel_type STRING |
|
campaign_id INTEGER |
|
campaign_labels STRING |
|
campaign_name STRING |
|
campaign_status STRING |
|
click_type STRING |
|
clicks INTEGER |
|
conversions SINGER.DECIMAL |
|
conversions_from_interactions_rate SINGER.DECIMAL |
|
conversions_value SINGER.DECIMAL |
|
cost_micros INTEGER |
|
cost_per_conversion SINGER.DECIMAL |
|
cross_device_conversions SINGER.DECIMAL |
|
ctr SINGER.DECIMAL |
|
date DATE-TIME |
|
day_of_week STRING |
|
device STRING |
|
engagement_rate SINGER.DECIMAL |
|
engagements INTEGER |
|
impressions INTEGER |
|
interaction_event_types STRING |
|
interaction_rate SINGER.DECIMAL |
|
interactions INTEGER |
|
landing_page_view_unexpanded_final_url STRING |
|
mobile_friendly_clicks_percentage SINGER.DECIMAL |
|
month DATE-TIME |
|
month_of_year STRING |
|
quarter DATE-TIME |
|
slot STRING |
|
speed_score INTEGER |
|
valid_accelerated_mobile_pages_clicks_percentage SINGER.DECIMAL |
|
value_per_conversion SINGER.DECIMAL |
|
video_view_rate SINGER.DECIMAL |
|
video_views INTEGER |
|
week DATE-TIME |
|
year INTEGER |
|
{{ system-column.record-hash }} STRING |
language_constant
The language_constant table contains info about about languages.
Note: In order to replicate this table, you must also set the campaign_criterion table to replicate.
|
Full Table |
|
|
Primary Key |
id |
|
campaign_criterion |
|
| Useful links |
|
code STRING |
|
id INTEGER |
|
name STRING |
|
resouce_name STRING |
|
targetable BOOLEAN |
mobile_app_category_constant
The mobile_app_category_constant table contains info about mobile application categories.
Note: In order to replicate this table, you must also set the following tables to replicate:
|
Full Table |
|
|
Primary Key |
id |
|
campaign_criterion ad_group_criterion |
|
| Useful links |
|
id INTEGER |
|
name STRING |
|
resource_name STRING |
mobile_device_constant
The mobile_device_constant table contains info about mobile devices.
Note: In order to replicate this table, you must also set the campaign_criterion table to replicate.
|
Full Table |
|
|
Primary Key |
id |
|
campaign_criterion |
|
| Useful links |
|
id INTEGER |
|
manufacturer_name STRING |
|
name STRING |
|
operating_system_name STRING |
|
resource_name STRING |
|
type STRING |
operating_system_verison_constant
The operating_system_verison_constant table contains info about mobile operating system versions.
Note: In order to replicate this table, you must also set the campaign_criterion table to replicate.
|
Full Table |
|
|
Primary Key |
id |
|
campaign_criterion |
|
| Useful links |
|
id INTEGER |
|
name STRING |
|
operator_type STRING |
|
os_major_version INTEGER |
|
os_minor_version INTEGER |
|
resource_name STRING |
placeholder_feed_item_report
The placeholder_feed_item_report table contains
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
ad_group_ad_resource_name OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
ad_group_id INTEGER |
|||||
|
ad_group_name STRING |
|||||
|
ad_group_status 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 |
|||||
|
campaign_id INTEGER |
|||||
|
campaign_labels STRING |
|||||
|
campaign_name STRING |
|||||
|
campaign_status STRING |
|||||
|
click_type STRING |
|||||
|
clicks INTEGER |
|||||
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
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 |
|||||
|
feed_attributes ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||||
|
feed_id INTEGER |
|||||
|
feed_item_attribute_values OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
feed_item_end_date_time DATE-TIME |
|||||
|
feed_item_feed OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
feed_item_geo_targeting_restriction STRING |
|||||
|
feed_item_id INTEGER |
|||||
|
feed_item_policy_infos OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
feed_item_start_date_time DATE-TIME |
|||||
|
feed_item_status STRING |
|||||
|
feed_item_url_custom_parameters OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||||
|
feed_name STRING |
|||||
|
feed_origin STRING |
|||||
|
feed_status STRING |
|||||
|
impressions INTEGER |
|||||
|
interaction_event_types STRING |
|||||
|
interaction_on_this_extension BOOLEAN |
|||||
|
interaction_rate SINGER.DECIMAL |
|||||
|
interactions INTEGER |
|||||
|
month DATE-TIME |
|||||
|
month_of_year STRING |
|||||
|
placeholder_type STRING |
|||||
|
quarter DATE-TIME |
|||||
|
slot STRING |
|||||
|
value_per_all_conversions SINGER.DECIMAL |
|||||
|
value_per_conversion SINGER.DECIMAL |
|||||
|
video_view_rate SINGER.DECIMAL |
|||||
|
video_views INTEGER |
|||||
|
week DATE-TIME |
|||||
|
year INTEGER |
|||||
|
{{ system-column.record-hash }} STRING |
placeholder_report
The placeholder_report table contains
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
ad_group_ad_resource_name OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
ad_group_id INTEGER |
|
ad_group_name STRING |
|
ad_group_status 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 |
|
campaign_id INTEGER |
|
campaign_labels STRING |
|
campaign_name STRING |
|
campaign_status STRING |
|
click_type STRING |
|
clicks INTEGER |
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
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_descriptive_name STRING |
|
customer_id INTEGER |
|
date DATE-TIME |
|
day_of_week STRING |
|
device STRING |
|
engagement_rate SINGER.DECIMAL |
|
engagements INTEGER |
|
external_conversion_source STRING |
|
feed_placeholder_view_placeholder_type STRING |
|
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_view_rate SINGER.DECIMAL |
|
video_views INTEGER |
|
view_through_conversions INTEGER |
|
week DATE-TIME |
|
year INTEGER |
|
{{ system-column.record-hash }} STRING |
placement_performance_report
The placement_performance_report table contains
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
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 This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
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_placement OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
ad_group_criterion_status STRING |
|
|
ad_group_criterion_tracking_url_template STRING |
|
|
ad_group_criterion_url_custom_parameters OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
ad_group_id INTEGER |
|
|
ad_group_name STRING |
|
|
ad_group_status STRING |
|
|
ad_group_targeting_setting OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
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 |
|
|
bidding_strategy_type STRING |
|
|
campaign_base_campaign OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_bidding_strategy OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
campaign_id INTEGER |
|
|
campaign_labels STRING |
|
|
campaign_name STRING |
|
|
campaign_status STRING |
|
|
click_type STRING |
|
|
clicks INTEGER |
|
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
|
conversion_action_category STRING |
|
|
conversion_action_name STRING |
|
|
conversions 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 |
search_query_performance_report
The search_query_performance_report table contains all statistics aggregated at the search term level.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
absolute_top_impression_percentage SINGER.DECIMAL |
|||
|
ad_group_id INTEGER |
|||
|
ad_group_name STRING |
|||
|
ad_group_status 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 |
|||
|
campaign_id INTEGER |
|||
|
campaign_labels STRING |
|||
|
campaign_name STRING |
|||
|
campaign_status STRING |
|||
|
clicks INTEGER |
|||
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|||
|
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 |
|||
|
final_urls STRING |
|||
|
id INTEGER |
|||
|
impressions INTEGER |
|||
|
interaction_event_types STRING |
|||
|
interaction_rate SINGER.DECIMAL |
|||
|
interactions INTEGER |
|||
|
keyword OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|||
|
month DATE-TIME |
|||
|
month_of_year STRING |
|||
|
quarter DATE-TIME |
|||
|
search_term_match_type STRING |
|||
|
search_term_view_search_term STRING |
|||
|
search_term_view_status STRING |
|||
|
top_impression_percentage SINGER.DECIMAL |
|||
|
tracking_url_template 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 |
|||
|
{{ system-column.record-hash }} STRING |
shopping_performance_report
The shopping_performance_report table contains
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
ad_group_id INTEGER |
|
ad_group_name STRING |
|
ad_group_status STRING |
|
ad_network_type STRING |
|
all_conversions SINGER.DECIMAL |
|
all_conversions_from_interactions_rate SINGER.DECIMAL |
|
all_conversions_value SINGER.DECIMAL |
|
average_cpc SINGER.DECIMAL |
|
campaign_id INTEGER |
|
campaign_labels STRING |
|
campaign_name STRING |
|
campaign_status STRING |
|
click_type STRING |
|
clicks INTEGER |
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
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_descriptive_name STRING |
|
customer_id INTEGER |
|
date DATE-TIME |
|
day_of_week STRING |
|
device STRING |
|
external_conversion_source STRING |
|
impressions INTEGER |
|
month DATE-TIME |
|
product_aggregator_id INTEGER |
|
product_category_level1 OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
product_category_level2 OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
product_category_level3 OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
product_category_level4 OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
product_category_level5 OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
product_brand STRING |
|
product_channel STRING |
|
product_channel_exclusivity STRING |
|
product_condition STRING |
|
product_country OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
product_custom_attribute0 STRING |
|
product_custom_attribute1 STRING |
|
product_custom_attribute2 STRING |
|
product_custom_attribute3 STRING |
|
product_custom_attribute4 STRING |
|
product_item_id STRING |
|
product_language OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
product_merchant_id INTEGER |
|
product_store_id STRING |
|
product_title STRING |
|
product_type_l1 STRING |
|
product_type_l2 STRING |
|
product_type_l3 STRING |
|
product_type_l4 STRING |
|
product_type_l5 STRING |
|
quarter DATE-TIME |
|
search_absolute_top_impression_share SINGER.DECIMAL |
|
search_click_share SINGER.DECIMAL |
|
search_impression_share SINGER.DECIMAL |
|
value_per_all_conversions SINGER.DECIMAL |
|
value_per_conversion SINGER.DECIMAL |
|
week DATE-TIME |
|
year INTEGER |
|
{{ system-column.record-hash }} STRING |
topic_constant
The topic_constant table contains info about topics.
Note: In order to replicate this table, you must also set the following tables to replicate:
|
Full Table |
|
|
Primary Key |
id |
|
campaign_criterion ad_group_criterion |
|
| Useful links |
|
id INTEGER |
|
|
path ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
|
|
resource_name STRING |
|
|
topic_constant_parent STRING |
user_interest
The user_interest table contains info about user interests to be targeted.
Note: In order to replicate this table, you must also set the following tables to replicate:
|
Full Table |
|
|
Primary Key |
id |
|
campaign_criterion ad_group_criterion |
|
| Useful links |
|
availabilities ARRAY This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
|
||||||||||||
|
id INTEGER |
||||||||||||
|
launched_to_all BOOLEAN |
||||||||||||
|
name STRING |
||||||||||||
|
resource_name STRING |
||||||||||||
|
taxonomy_type STRING |
||||||||||||
|
user_interest_parent STRING |
user_list
The user_list table contains info about lists of user that can be targeted.
Note: In order to replicate this table, you must also set the following tables to replicate:
|
Full Table |
|
|
Primary Key |
id |
|
campaign_criterion ad_group_criterion |
|
| Useful links |
|
access_reason STRING |
|
account_user_list_status STRING |
|
closing_reason STRING |
|
customer_id INTEGER |
|
description STRING |
|
eligible_for_display BOOLEAN |
|
eligible_for_search BOOLEAN |
|
id INTEGER |
|
integration_code STRING |
|
match_rate_percentage INTEGER |
|
membership_life_span INTEGER |
|
membership_status STRING |
|
name STRING |
|
read_only BOOLEAN |
|
resource_name STRING |
|
size_for_display INTEGER |
|
size_for_search INTEGER |
|
size_range_for_display STRING |
|
size_range_for_search STRING |
|
type STRING |
|
user_list OBJECT This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
user_location_performance_report
The user_location_performance_report table contains
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
ad_group_id INTEGER |
|
ad_group_name STRING |
|
ad_group_status 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_cpm SINGER.DECIMAL |
|
average_cpv SINGER.DECIMAL |
|
campaign_id INTEGER |
|
campaign_labels STRING |
|
campaign_name STRING |
|
campaign_status STRING |
|
clicks INTEGER |
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
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 |
|
external_conversion_source STRING |
|
geo_target_city OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
geo_target_metro OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
geo_target_most_specific_location OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
geo_target_region OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
impressions INTEGER |
|
interaction_event_types STRING |
|
interaction_rate SINGER.DECIMAL |
|
interactions INTEGER |
|
month DATE-TIME |
|
month_of_year STRING |
|
quarter DATE-TIME |
|
user_location_view_country_criterion_id INTEGER |
|
user_location_view_targeting_location BOOLEAN |
|
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 |
video_performance_report
The video_performance_report table contains statistics for your account’s videos.
This is a Report table. See the Replication section for information on how data is replicated and loaded for this table.
|
Key-based Incremental |
|
|
Primary Key |
_sdc_record_hash |
|
Replication Key |
date |
| Useful links |
|
ad_group_ad_status STRING |
|
ad_group_id INTEGER |
|
ad_group_name STRING |
|
ad_group_status STRING |
|
ad_network_type STRING |
|
all_conversions SINGER.DECIMAL |
|
all_conversions_from_interactions_rate SINGER.DECIMAL |
|
all_conversions_value SINGER.DECIMAL |
|
average_cpm SINGER.DECIMAL |
|
average_cpv SINGER.DECIMAL |
|
campaign_id INTEGER |
|
campaign_labels STRING |
|
campaign_name STRING |
|
campaign_status STRING |
|
click_type STRING |
|
clicks INTEGER |
|
conversion_action OBJECT, STRING This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
|
conversion_action_category STRING |
|
conversion_action_name STRING |
|
conversions 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 |
|
id INTEGER |
|
impressions INTEGER |
|
month DATE-TIME |
|
month_of_year STRING |
|
quarter DATE-TIME |
|
value_per_all_conversions SINGER.DECIMAL |
|
video_channel_id STRING |
|
video_duration_millis INTEGER |
|
video_id STRING |
|
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_title STRING |
|
video_view_rate SINGER.DECIMAL |
|
video_views INTEGER |
|
view_through_conversions INTEGER |
|
week DATE-TIME |
|
year INTEGER |
|
{{ system-column.record-hash }} STRING |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!