BigQuery tables behind Looker studio dashboard for the Shopping insights v3 report | Learning Center

If you want to work with the data output directly in BigQuery, getting started is straightforward. Below is an example query that retrieves the ad_spend and conversions:

SELECT
 product_type_1,
 sum(ad_spend),
 sum(conversions)
FROM `project.dataset.shopping_insights_performance_view_{table_suffix}`
WHERE date >'2023-01-01'
GROUP BY product_type_1

Below you can find detailed schemas of the output tables in BigQuery from shopping insights v3:

Table: shopping_insights_cross_sell_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
date	DATE	Date of the record.
customer_id	STRING	Unique identifier for the customer.
customer_name	STRING	Name of the customer.
currency_code	STRING	Currency code of the record.
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
offer_id	STRING	Product ID from Merchant Center.
feed_label	STRING	Feed label associated with the offer.
product_channel	STRING	Sales channel of the product.
ad_spend	FLOAT64	Advertising spend for the offer.
conversion_value	FLOAT64	Value generated from conversions.
conversions	FLOAT64	Number of conversions.
lead_cost_of_goods_sold	FLOAT64	Cost of goods sold for leads.
lead_gross_profit	FLOAT64	Gross profit from lead sales.
lead_revenue	FLOAT64	Revenue generated from lead sales.
lead_units_sold	FLOAT64	Units sold through leads.
orders	FLOAT64	Total number of orders.
units_sold	FLOAT64	Total number of units sold.
cross_sell_cost_of_goods_sold	FLOAT64	Cost of goods sold in cross sell.
cross_sell_gross_profit	FLOAT64	Gross profit from cross sell.
cross_sell_revenue	FLOAT64	Revenue from cross sell sales.
cross_sell_units_sold	FLOAT64	Units sold via cross sell channel.
total_cost_of_goods_sold	FLOAT64	Total cost of goods sold.
total_gross_profit	FLOAT64	Total gross profit.
cross_sell_revenue_share	FLOAT64	Revenue share from cross sell sales.
cross_sell_units_share	FLOAT64	Units share from cross sell.
lead_margin	FLOAT64	Margin on lead sales.
cross_sell_margin	FLOAT64	Margin on cross sell.
total_margin	FLOAT64	Overall profit margin.
content_language	STRING	Language of the content.
price	FLOAT64	Price of the product.
price_currency	STRING	Currency of the price.
sale_price_currency	STRING	Currency of the sale price.
sale_price	FLOAT64	Sale price of the product.
current_price	FLOAT64	Current price of the product.
gtin	STRING	Global Trade Item Number.
additional_image_links_1	STRING	First additional image link.
additional_image_links_2	STRING	Second additional image link.
additional_image_links_3	STRING	Third additional image link.
additional_image_links_4	STRING	Fourth additional image link.
additional_image_links_5	STRING	Fifth additional image link.
title	STRING	Title of the product.
description	STRING	Description of the product.
link	STRING	URL link to the product page.
image_link	STRING	Primary image link for the product.
adult	STRING	Indicator if the product is adult-oriented.
age_group	STRING	Target age group for the product.
availability	STRING	Availability status of the product.
brand	STRING	Brand of the product.
color	STRING	Color of the product.
condition	STRING	Product condition.
gender	STRING	Gender targeting or indication.
google_product_category	STRING	Google product category identifier.
google_product_category_name	STRING	Name of the Google product category.
item_group_id	STRING	Identifier for the product group.
material	STRING	Material of the product.
mpn	STRING	Manufacturer Part Number.
pattern	STRING	Product pattern description.
product_type	STRING	General product type classification.
product_type_1	STRING	Product subtype or classification level 1.
product_type_2	STRING	Product subtype or classification level 2.
product_type_3	STRING	Product subtype or classification level 3.
product_type_4	STRING	Product subtype or classification level 4.
product_type_5	STRING	Product subtype or classification level 5.
size	STRING	Size of the product.
size_system	STRING	Size system used (e.g., US, EU).
custom_label_0	STRING	Custom label 0 for additional segmentation.
custom_label_1	STRING	Custom label 1 for additional segmentation.
custom_label_2	STRING	Custom label 2 for additional segmentation.
custom_label_3	STRING	Custom label 3 for additional segmentation.
custom_label_4	STRING	Custom label 4 for additional segmentation.
is_bundle	STRING	Indicator if the product is a bundle.

Table: shopping_insights_competitors_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
date	DATE	Date of the record.
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
country_code	STRING	Country code associated with the merchant.
category_id	INT64	Unique identifier for the category.
category_name	STRING	Name of the category.
first_category_name	STRING	Name of the first category in the hierarchy.
last_category_name	STRING	Name of the last category in the hierarchy.
has_subcategories	BOOL	Flag indicating if the category contains subcategories.
is_your_domain	STRING	Indicates if the domain is your own.
domain	STRING	Domain name.
rank	INT64	Rank of the competitor or offer.
avg_rank	FLOAT64	Average rank across competitors.
ads_organic_ratio	FLOAT64	Ratio of ad spend to organic metrics.
page_overlap_rate	FLOAT64	Rate at which pages overlap in ranking.
higher_position_rate	FLOAT64	Frequency of higher position ranking.
relative_visibility	FLOAT64	Calculated relative visibility metric.
your_domain_visibility_trend	FLOAT64	Trend of your domain's visibility.
category_benchmark_visibility_trend	FLOAT64	Benchmark trend for the category's visibility.
ad_spend	FLOAT64	Total advertising spend.
impressions	FLOAT64	Number of impressions.
clicks	FLOAT64	Number of clicks.
conversions	FLOAT64	Number of conversions.
conversion_value	FLOAT64	Total value of conversions.
est_ad_spend	FLOAT64	Estimated advertising spend.
est_impressions	FLOAT64	Estimated number of impressions.
est_clicks	FLOAT64	Estimated number of clicks.
est_conversions	FLOAT64	Estimated number of conversions.
est_conversion_value	FLOAT64	Estimated conversion value.

Table: alvie_shopping_labeller_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
merchant_id	STRING	Unique identifier for the merchant.
offer_id	STRING	Unique identifier for the offer.
offer_id_original_capitalization	STRING	Offer ID with original capitalization.
custom_label_4	STRING	Custom label used for segmentation.
alvie_shopping_label	STRING	Final shopping label assigned to the offer.

Table: alvie_shopping_labeller_{table_suffix}_{mc_id}

Note: Generated using AI

Column Name	Data Type	Description
id	STRING	Unique identifier for the labeller record.
merchant_id	STRING	Unique identifier for the merchant.
offer_id	STRING	Unique identifier for the offer.
offer_id_original_capitalization	STRING	Offer ID with original capitalization.
custom_label_4	STRING	Custom label used for segmentation.
alvie_shopping_label	STRING	Final shopping label assigned to the offer.

Table: shopping_insights_product_potential_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
id	STRING	Unique potential record identifier.
product_channel	STRING	Channel from which product potential is evaluated.
offer_id	STRING	Product ID from Merchant Center.
language_code	STRING	Language code for the product details.
feed_label	STRING	Feed label used in potential evaluation.
aggregated_reporting_context_status	STRING	Status for aggregated reporting.
click_potential	STRING	Estimated click potential metric.
click_potential_rank	INT64	Ranking based on click potential.

Table: shopping_insights_feed_checks_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
feed_label	STRING	Label for the product feed.
product_channel	STRING	Source channel of the product feed. (Online/Local)
offer_id	STRING	Product ID from Merchant Center.
title	STRING	Title of the product.
has_identical_product_title	BOOL	Flag indicating if product title is duplicated.
description	STRING	Description of the product.
image_link	STRING	URL to the product image.
link	STRING	Direct link to the product page.
brand	STRING	Brand of the product.
product_type	STRING	Product type or category.
color	STRING	Color details of the product.
gender	STRING	Gender specification if applicable.
gtin	STRING	Global Trade Item Number.
mpn	STRING	Manufacturer Part Number.
age_group	STRING	Target age group.
product_highlights	STRING	Brief product highlights.
product_details	STRING	Detailed product information.
material	STRING	Material composition of the product.
pattern	STRING	Product pattern or design.
size	STRING	Size specifications.
first_product_type	STRING	First level product type.
last_product_type	STRING	Last level product type.
has_first_product_type_in_title	BOOL	Indicates if first product type is in the title.
has_last_product_type_in_title	BOOL	Indicates if last product type is in the title.
has_identifier	BOOL	Flag if identifier is present.
has_long_description	BOOL	Indicates if product has a long description.
has_long_title	BOOL	Indicates if product has a long title.
has_brand	BOOL	Flag if brand is present.
has_description	BOOL	Indicates if description is provided.
has_additional_images	BOOL	Flag if additional images exist.
has_color	BOOL	Indicates if color attribute is provided.
has_color_in_title	BOOL	Indicates if color appears in the title.
has_brand_in_title	BOOL	Indicates if brand appears in the title.
has_size	BOOL	Flag if size attribute is available.
has_size_in_title	BOOL	Indicates if size is mentioned in the title.
has_material	BOOL	Flag if material attribute is provided.
has_pattern	BOOL	Indicates if pattern is mentioned.
has_product_details	BOOL	Flag if additional product details provided.
has_product_highlights	BOOL	Indicates if product highlights exist.
has_impressions_30d	BOOL	Flag for 30-day impressions data.
has_clicks_30d	BOOL	Flag for 30-day clicks data.
has_conversions_30d	BOOL	Flag for 30-day conversions data.
is_approved	BOOL	Indicates if product is approved.
in_stock	BOOL	Stock availability flag.
has_gender	BOOL	Flag if gender attribute is provided.
has_age_group	BOOL	Flag if age group is provided.
alvie_shopping_label	STRING	Assigned shopping label.
click_potential	STRING	Google click potential metric.
click_potential_rank	INT64	Google click potential rank.

Table: shopping_insights_products_historical_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
date	DATE	Date of the historical record.
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
product_channel	STRING	Channel (Online/Local)
offer_id	STRING	Product ID from Merchant Center.
feed_label	STRING	Feed label associated with the record.
data_source	STRING	Source system for the historical data.
name	STRING	Name or title of the product.
content_language	STRING	Language of the product content.
item_group_id_historical	STRING	Historical item group ID.
first_item_group_id_historical	STRING	First historical item group ID.
title_historical	STRING	Historical title of the product.
first_title_historical	STRING	First recorded title historically.
brand_historical	STRING	Historical brand information.
first_brand_historical	STRING	First recorded brand historically.
color_historical	STRING	Historical color information.
first_color_historical	STRING	First recorded color historically.
material_historical	STRING	Historical material details.
first_material_historical	STRING	First recorded material historically.
mpn_historical	STRING	Historical Manufacturer Part Number.
first_mpn_historical	STRING	First recorded MPN historically.
pattern_historical	STRING	Historical product pattern.
first_pattern_historical	STRING	First recorded pattern historically.
gender_historical	STRING	Historical gender information.
first_gender_historical	STRING	First recorded gender historically.
size_historical	STRING	Historical size.
first_size_historical	STRING	First recorded size historically.
size_system_historical	STRING	Historical size system.
first_size_system_historical	STRING	First recorded size system historically.
gtin_historical	STRING	Historical Global Trade Item Number.
first_gtin_historical	STRING	First recorded GTIN historically.
adult_historical	STRING	Historical adult flag.
first_adult_historical	STRING	First recorded adult flag historically.
age_group_historical	STRING	Historical age group.
first_age_group_historical	STRING	First recorded age group historically.
availability_historical	STRING	Historical availability status.
first_availability_historical	STRING	First recorded availability historically.
condition_historical	STRING	Historical product condition.
first_condition_historical	STRING	First recorded condition historically.
product_type_historical	STRING	Historical product type.
first_product_type_historical	STRING	First recorded product type historically.
google_product_category_name_historical	STRING	Historical Google product category name.
first_google_product_category_name_historical	STRING	First recorded Google product category name historically.
price_currency_historical	STRING	Historical price currency.
first_price_currency_historical	STRING	First recorded price currency historically.
price_historical	FLOAT64	Historical price.
first_price_historical	FLOAT64	First recorded price historically.
sale_price_currency_historical	STRING	Historical sale price currency.
first_sale_price_currency_historical	STRING	First recorded sale price currency historically.
sale_price_historical	FLOAT64	Historical sale price.
first_sale_price_historical	FLOAT64	First recorded sale price historically.
sale_price_effective_date_historical	STRING	Historical sale price effective date.
first_sale_price_effective_date_historical	STRING	First recorded effective sale price date historically.
image_link_historical	STRING	Historical image link.
first_image_link_historical	STRING	First recorded image link historically.
link_historical	STRING	Historical product link.
first_link_historical	STRING	First recorded product link historically.
custom_label_0_historical	STRING	Historical custom label 0.
first_custom_label_0_historical	STRING	First recorded custom label 0 historically.
custom_label_1_historical	STRING	Historical custom label 1.
first_custom_label_1_historical	STRING	First recorded custom label 1 historically.
custom_label_2_historical	STRING	Historical custom label 2.
first_custom_label_2_historical	STRING	First recorded custom label 2 historically.
custom_label_3_historical	STRING	Historical custom label 3.
first_custom_label_3_historical	STRING	First recorded custom label 3 historically.
custom_label_4_historical	STRING	Historical custom label 4.
first_custom_label_4_historical	STRING	First recorded custom label 4 historically.
creation_date_historical	STRING	Historical creation date.
last_update_date_historical	STRING	Historical last update date.
product_approval_status_historical	STRING	Historical product approval status.
free_listings_approval_status_historical	STRING	Historical free listings approval status.
on_sale_historical	BOOL	Historical on sale flag.
listed_price_historical	FLOAT64	Historical listed price.

Table: shopping_insights_performance_180d_agg_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
merchant_id	STRING	Unique identifier for the merchant.
offer_id	STRING	Product ID from Merchant Center.
feed_label	STRING	Feed label used in performance reporting.
product_channel	STRING	Sales channel for the product.
campaign_id	STRING	Campaign identifier.
impressions	FLOAT64	Total campaign impressions.
clicks	FLOAT64	Total campaign clicks.
conversions	FLOAT64	Total campaign conversions.
impressions_30d	FLOAT64	Impressions in the past 30 days.
clicks_30d	FLOAT64	Clicks in the past 30 days.
conversions_30d	FLOAT64	Conversions in the past 30 days.
impressions_60d	FLOAT64	Impressions in the past 60 days.
clicks_60d	FLOAT64	Clicks in the past 60 days.
conversions_60d	FLOAT64	Conversions in the past 60 days.
conversion_value	FLOAT64	Total conversion value.
conversion_value_30d	FLOAT64	Conversion value in the past 30 days.
conversion_value_60d	FLOAT64	Conversion value in the past 60 days.
ad_spend	FLOAT64	Total ad spend.
ad_spend_30d	FLOAT64	Ad spend in the past 30 days.
ad_spend_60d	FLOAT64	Ad spend in the past 60 days.
impressions_90d	FLOAT64	Impressions in the past 90 days.
clicks_90d	FLOAT64	Clicks in the past 90 days.
conversions_90d	FLOAT64	Conversions in the past 90 days.
conversion_value_90d	FLOAT64	Conversion value in the past 90 days.
ad_spend_90d	FLOAT64	Ad spend in the past 90 days.
expected_value_per_day	FLOAT64	Expected daily value.
count_days_with_impressions	INT64	Number of days with impressions.
ad_spend_comparison	STRING	Comparison metric for ad spend (ABOVE/BELOW AVERAGE).
conversions_comparison	STRING	Comparison metric for conversions (ABOVE/BELOW AVERAGE).
roas_comparison	STRING	ROAS comparison metric (ABOVE/BELOW AVERAGE).

Table: shopping_insights_issues_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
name	STRING	Issue name or code description.
product_channel	STRING	Channel (e.g., feed type) where the issue was detected.
offer_id	STRING	Product ID from Merchant Center.
content_language	STRING	Language code for product content.
feed_label	STRING	Label for the feed source.
data_source	STRING	Source from which the issue was captured.
code	STRING	Issue code identifier.
severity	STRING	Severity level of the issue.
resolution	STRING	Resolution status or guidance.
attribute	STRING	Attribute associated with the issue.
reporting_context	STRING	Reporting context for the issue.
description	STRING	Detailed description of the issue.
detail	STRING	Additional detail regarding the issue.
documentation	STRING	Link to relevant documentation.
applicable_countries	STRING	Countries where the issue applies.
destination	STRING	Destination linked to the issue.
approved_countries	STRING	Countries with approval for this product.
disapproved_countries	STRING	Countries with disapproval for this product.
product_approval_status	STRING	Approval status of the product.
price	FLOAT64	Product price.
price_currency	STRING	Currency for the price.
sale_price_currency	STRING	Currency for the sale price.
sale_price	FLOAT64	Sale price if applicable.
current_price	FLOAT64	Current price of the product.
gtin	STRING	Global Trade Item Number.
additional_image_links_1	STRING	Additional image link 1.
additional_image_links_2	STRING	Additional image link 2.
additional_image_links_3	STRING	Additional image link 3.
additional_image_links_4	STRING	Additional image link 4.
additional_image_links_5	STRING	Additional image link 5.
title	STRING	Title of the product.
product_description	STRING	Detailed product description.
link	STRING	Product page link.
image_link	STRING	Primary image link.
adult	STRING	Adult content flag.
age_group	STRING	Target age group.
availability	STRING	Availability status.
brand	STRING	Product brand.
color	STRING	Color of the product.
condition	STRING	Product condition.
gender	STRING	Gender specification if applicable.
google_product_category	STRING	Google product category ID.
google_product_category_name	STRING	Name of the Google product category.
item_group_id	STRING	Identifier for the product group.
material	STRING	Material of the product.
mpn	STRING	Manufacturer Part Number.
pattern	STRING	Product pattern description.
product_type	STRING	General product type classification.
product_type_1	STRING	Product subtype classification level 1.
product_type_2	STRING	Product subtype classification level 2.
product_type_3	STRING	Product subtype classification level 3.
product_type_4	STRING	Product subtype classification level 4.
product_type_5	STRING	Product subtype classification level 5.
size	STRING	Product size.
size_system	STRING	Size system used (e.g., US, EU).
custom_label_0	STRING	Custom label 0 for additional segmentation.
custom_label_1	STRING	Custom label 1 for additional segmentation.
custom_label_2	STRING	Custom label 2 for additional segmentation.
custom_label_3	STRING	Custom label 3 for additional segmentation.
custom_label_4	STRING	Custom label 4 for additional segmentation.
is_bundle	STRING	Indicator if the product is a bundle.
alvie_shopping_label	STRING	Assigned shopping label.
click_potential	STRING	Computed click potential metric.
click_potential_rank	INT64	Ranking based on click potential evaluation.

Table: shopping_insights_products_add_attributes_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
merchant_id	STRING	Unique identifier for the merchant.
product_channel	STRING	Channel of the product.
offer_id	STRING	Product ID from Merchant Center.
feed_label	STRING	Feed label for the product.
mobile_link	STRING	Mobile URL link for the product.
canonical_link	STRING	Canonical URL link for the product.
pause	STRING	Pause status for the product feed.
expiration_date	STRING	Expiration date of the product listing.
disclosure_date	STRING	Disclosure date for the product details.
availability_date	STRING	Date when the product becomes available.
installment	STRING	Installment details if available.
subscription_cost	STRING	Subscription cost if applicable.
loyalty_points	STRING	Loyalty points offered.
loyalty_programs	STRING	Details of loyalty programs.
sale_price_effective_date	STRING	Effective date for sale price.
product_height	STRING	Height of the product.
product_length	STRING	Length of the product.
product_width	STRING	Width of the product.
product_weight	STRING	Weight of the product.
shipping	STRING	Shipping details.
free_shipping_threshold	STRING	Threshold for free shipping.
shipping_weight	STRING	Shipping weight of the product.
shipping_length	STRING	Shipping length of the product.
shipping_width	STRING	Shipping width of the product.
shipping_height	STRING	Shipping height of the product.
size_types	STRING	Types of sizes available.
taxes	STRING	Tax information.
unit_pricing_measure	STRING	Unit pricing measure.
unit_pricing_base_measure	STRING	Base measure for unit pricing.
ads_labels	JSON	JSON object with ads labels.
cost_of_goods_sold	STRING	Cost of goods sold.
product_details	STRING	Detailed product information.
product_highlights	STRING	Highlights of the product.
display_ads_similar_ids	STRING	IDs for similar products in display ads.
promotion_ids	JSON	JSON object with promotion IDs.
included_destinations	STRING	Destinations where product is included.
excluded_destinations	STRING	Destinations where product is excluded.
shopping_ads_excluded_countries	STRING	Countries excluded from shopping ads.
lifestyle_image_links	STRING	Links to lifestyle images.
cloud_export_additional_properties	STRING	Additional properties for cloud export.
certifications	STRING	Certifications of the product.
auto_pricing_min_price	STRING	Minimum price for auto pricing.
identifier_exists	STRING	Flag for identifier existence.
sell_on_google_quantity	STRING	Quantity available for sell on Google.
max_handling_time	STRING	Maximum handling time.
min_handling_time	STRING	Minimum handling time.
shipping_label	STRING	Shipping label.
transit_time_label	STRING	Transit time label.
tax_category	STRING	Tax category.
energy_efficiency_class	STRING	Energy efficiency class.
min_energy_efficiency_class	STRING	Minimum energy efficiency class.
max_energy_efficiency_class	STRING	Maximum energy efficiency class.
multipack	STRING	Multipack information.
ads_grouping	STRING	Ads grouping identifier.
ads_redirect	STRING	Ads redirect URL.
display_ads_id	STRING	Display ads ID.
display_ads_title	STRING	Title for display ads.
display_ads_link	STRING	Link for display ads.
display_ads_value	STRING	Value for display ads.
pickup_method	STRING	Pickup method information.
pickup_sla	STRING	Service level agreement for pickup.
link_template	STRING	Template for product link.
mobile_link_template	STRING	Template for mobile link.
external_seller_id	STRING	External seller identifier.
virtual_model_link	STRING	Virtual model link.
structured_title	STRING	Structured title for ads.
structured_description	STRING	Structured description for ads.
product_status__creation_date	STRING	Creation date of product status.
product_status__last_update_date	STRING	Last update date of product status.
product_status__google_expiration_date	STRING	Google expiration date for product status.

Table: shopping_insights_organic_performance_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
date	DATE	Date of the record.
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
country_code	STRING	Country code of the merchant.
offer_id	STRING	Product ID from Merchant Center.
clicks	FLOAT64	Total organic clicks.
impressions	FLOAT64	Total organic impressions.
click_through_rate	FLOAT64	Organic click-through rate.
conversions	FLOAT64	Organic conversions recorded.
conversion_value	FLOAT64	Organic conversion value.
paid_impressions	FLOAT64	Number of paid impressions.
paid_clicks	FLOAT64	Number of paid clicks.
paid_conversions	FLOAT64	Number of paid conversions.
paid_conversion_value	FLOAT64	Conversion value from paid ads.
paid_ad_spend	FLOAT64	Ad spend for paid campaigns.
content_language	STRING	Content language code.
price	FLOAT64	Product price.
price_currency	STRING	Currency for the price.
sale_price_currency	STRING	Currency for the sale price.
sale_price	FLOAT64	Sale price if available.
current_price	FLOAT64	Current price of the product.
gtin	STRING	Global Trade Item Number.
title	STRING	Product title.
description	STRING	Product description.
link	STRING	Product URL.
image_link	STRING	Link to the product image.
adult	STRING	Adult product indicator.
age_group	STRING	Target age group.
availability	STRING	Availability status.
brand	STRING	Brand name.
color	STRING	Product color.
condition	STRING	Product condition.
gender	STRING	Gender targeting.
google_product_category	STRING	Google product category ID.
google_product_category_name	STRING	Google product category name.
item_group_id	STRING	Identifier for product grouping.
material	STRING	Material information.
mpn	STRING	Manufacturer Part Number.
pattern	STRING	Product pattern.
product_type	STRING	Product type classification.
size	STRING	Size of the product.
size_system	STRING	Size system (e.g., US, EU).
custom_label_0	STRING	Custom label 0.
custom_label_1	STRING	Custom label 1.
custom_label_2	STRING	Custom label 2.
custom_label_3	STRING	Custom label 3.
custom_label_4	STRING	Custom label 4.
is_bundle	STRING	Indicates if the product is a bundle.

Table: shopping_insights_performance_view_add_attr_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
date	DATE	The date of the record.
customer_id	STRING	Unique identifier for the customer.
customer_name	STRING	The name of the customer.
currency	STRING	Currency code for transactions.
source_currency	STRING	Source currency code.
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
aggregator_id	STRING	Unique identifier for the aggregator.
market_name	STRING	Name of the market.
channel_grouping	STRING	Grouping for channel classification.
offer_id	STRING	Unique identifier for the product in merchant center.
feed_label	STRING	Label identifier for the feed.
country_code	STRING	Country code associated with the record.
product_channel	STRING	Product channel through which the offer is delivered.
campaign_id	STRING	Unique campaign identifier.
campaign_name	STRING	Name of the campaign.
campaign_serving_status	STRING	Current serving status of the campaign.
campaign_type	STRING	Type of the campaign.
campaign_sub_type	STRING	Subtype of the campaign.
campaign_status	STRING	Status of the campaign.
bidding_strategy_type	STRING	Bidding strategy employed.
is_portfolio_strategy	BOOL	Indicates if a portfolio strategy is used.
target_roas	FLOAT64	Target return on ad spend.
target_cpa	FLOAT64	Target cost per acquisition.
brand_historical	STRING	Historical brand information.
title_historical	STRING	Historical title information.
color_historical	STRING	Historical color details.
material_historical	STRING	Historical material details.
mpn_historical	STRING	Historical manufacturer part number.
pattern_historical	STRING	Historical pattern details.
gender_historical	STRING	Historical gender targeting.
size_historical	STRING	Historical size information.
size_system_historical	STRING	Historical sizing system.
gtin_historical	STRING	Historical Global Trade Item Number.
adult_historical	STRING	Historical indication of adult content.
age_group_historical	STRING	Historical age group targeting.
availability_historical	STRING	Historical availability status.
condition_historical	STRING	Historical condition of the product.
product_type_historical	STRING	Historical product type details.
on_sale_historical	BOOL	Historical indicator if the product was on sale.
price_historical	FLOAT64	Historical price of the product.
price_currency_historical	STRING	Currency code for the historical price.
sale_price_historical	FLOAT64	Historical sale price.
sale_price_currency_historical	STRING	Currency code for the historical sale price.
listed_price_historical	FLOAT64	Historical listed price.
sale_price_effective_date_historical	STRING	Effective date for the historical sale price.
image_link_historical	STRING	Historical URL for the product image.
custom_label_0_historical	STRING	Historical custom label 0.
custom_label_1_historical	STRING	Historical custom label 1.
custom_label_2_historical	STRING	Historical custom label 2.
custom_label_3_historical	STRING	Historical custom label 3.
custom_label_4_historical	STRING	Historical custom label 4.
creation_date_historical	STRING	Historical record creation date.
last_update_date_historical	STRING	Historical record last update date.
product_approval_status_historical	STRING	Historical product approval status.
free_listings_approval_status_historical	STRING	Historical free listings approval status.
ad_spend	FLOAT64	Total advertising spend.
impressions	FLOAT64	Total number of impressions.
clicks	FLOAT64	Total number of clicks.
absolute_top_impression_share	FLOAT64	Share of absolute top impressions.
click_share	FLOAT64	Share of clicks relative to total impressions.
impression_share	FLOAT64	Share of impressions relative to total opportunities.
conversions	FLOAT64	Total number of conversions.
conversion_value	FLOAT64	Total conversion value.
expected_value_per_day	FLOAT64	Expected value generated per day.
count_days_with_impressions	INT64	Number of days with recorded impressions.
ad_spend_comparison	STRING	Comparison metric for ad spend.
conversions_comparison	STRING	Comparison metric for conversions.
roas_comparison	STRING	Comparison metric for ROAS.
ad_spend_30d	FLOAT64	Advertising spend in the past 30 days.
impressions_30d	FLOAT64	Impressions in the past 30 days.
clicks_30d	FLOAT64	Clicks in the past 30 days.
conversions_30d	FLOAT64	Conversions in the past 30 days.
conversion_value_30d	FLOAT64	Conversion value in the past 30 days.
ad_spend_60d	FLOAT64	Advertising spend in the past 60 days.
impressions_60d	FLOAT64	Impressions in the past 60 days.
clicks_60d	FLOAT64	Clicks in the past 60 days.
conversions_60d	FLOAT64	Conversions in the past 60 days.
conversion_value_60d	FLOAT64	Conversion value in the past 60 days.
ad_spend_90d	FLOAT64	Advertising spend in the past 90 days.
impressions_90d	FLOAT64	Impressions in the past 90 days.
clicks_90d	FLOAT64	Clicks in the past 90 days.
conversions_90d	FLOAT64	Conversions in the past 90 days.
conversion_value_90d	FLOAT64	Conversion value in the past 90 days.
ad_spend_180d	FLOAT64	Advertising spend in the past 180 days.
impressions_180d	FLOAT64	Impressions in the past 180 days.
clicks_180d	FLOAT64	Clicks in the past 180 days.
conversions_180d	FLOAT64	Conversions in the past 180 days.
conversion_value_180d	FLOAT64	Conversion value in the past 180 days.
content_language	STRING	Language of the content.
price	FLOAT64	Current product price.
price_currency	STRING	Currency for the current price.
sale_price_currency	STRING	Currency for the sale price.
sale_price	FLOAT64	Current sale price.
listed_price	FLOAT64	Current listed price.
on_sale	BOOL	Indicator if the product is on sale.
gtin	STRING	Current Global Trade Item Number.
additional_image_links_1	STRING	First additional image link.
additional_image_links_2	STRING	Second additional image link.
additional_image_links_3	STRING	Third additional image link.
additional_image_links_4	STRING	Fourth additional image link.
additional_image_links_5	STRING	Fifth additional image link.
title	STRING	Current product title.
description	STRING	Product description details.
link	STRING	URL linking to the product page.
image_link	STRING	URL for the product's primary image.
adult	STRING	Indicator if the product is intended for adult audiences.
age_group	STRING	Target age group for the product.
availability	STRING	Current availability status.
brand	STRING	Brand name of the product.
color	STRING	Color information for the product.
condition	STRING	Current product condition.
gender	STRING	Target gender for the product.
google_product_category	STRING	Identifier for the Google product category.
google_product_category_name	STRING	Name of the Google product category.
item_group_id	STRING	Identifier for grouping similar items.
material	STRING	Material composition details.
mpn	STRING	Manufacturer part number.
pattern	STRING	Pattern details of the product.
product_type	STRING	Product type classification.
product_type_1	STRING	Primary product type classification.
product_type_2	STRING	Secondary product type classification.
product_type_3	STRING	Tertiary product type classification.
product_type_4	STRING	Quaternary product type classification.
product_type_5	STRING	Quinary product type classification.
size	STRING	Product size details.
size_system	STRING	System used for product sizing.
custom_label_0	STRING	Custom label 0 for segmentation.
custom_label_1	STRING	Custom label 1 for segmentation.
custom_label_2	STRING	Custom label 2 for segmentation.
custom_label_3	STRING	Custom label 3 for segmentation.
custom_label_4	STRING	Custom label 4 for segmentation.
is_bundle	STRING	Indicator if the product is sold as a bundle.
product_approval_status	STRING	Current product approval status.
free_listings_approval_status	STRING	Current free listings approval status.
approved_countries	STRING	List of countries where the product is approved.
disapproved_countries	STRING	List of countries where the product is disapproved.
click_potential	STRING	Estimated click potential for the product.
click_potential_rank	INT64	Ranking based on click potential.
alvie_shopping_label	STRING	Final shopping label assigned by Alvie.
mobile_link	STRING	Mobile-optimized product link.
canonical_link	STRING	Canonical product link.
pause	STRING	Indicator if the product listing is paused.
expiration_date	STRING	Expiration date of the product listing.
disclosure_date	STRING	Disclosure date for the product data.
availability_date	STRING	Date when the product is available.
installment	STRING	Installment payment details.
subscription_cost	STRING	Subscription cost information.
loyalty_points	STRING	Loyalty points earned from the purchase.
loyalty_programs	STRING	Associated loyalty programs.
sale_price_effective_date	STRING	Date when the sale price becomes effective.
product_height	STRING	Height of the product.
product_length	STRING	Length of the product.
product_width	STRING	Width of the product.
product_weight	STRING	Weight of the product.
shipping	STRING	Shipping information.
free_shipping_threshold	STRING	Threshold for free shipping eligibility.
shipping_weight	STRING	Weight used for shipping calculations.
shipping_length	STRING	Length used for shipping calculations.
shipping_width	STRING	Width used for shipping calculations.
shipping_height	STRING	Height used for shipping calculations.
size_types	STRING	Classification of size types.
taxes	STRING	Tax details and rates.
unit_pricing_measure	STRING	Measure for unit pricing.
unit_pricing_base_measure	STRING	Base measure for unit pricing.
ads_labels	JSON	JSON object containing advertising labels.
cost_of_goods_sold	STRING	Cost of goods sold.
product_details	STRING	Detailed product information.
product_highlights	STRING	Key product highlights.
display_ads_similar_ids	STRING	Similar identifiers for display ads.
promotion_ids	JSON	JSON object containing promotion IDs.
included_destinations	STRING	Advertising destinations where the product is included.
excluded_destinations	STRING	Advertising destinations where the product is excluded.
shopping_ads_excluded_countries	STRING	Countries excluded from shopping ads.
lifestyle_image_links	STRING	Links to lifestyle images for the product.
cloud_export_additional_properties	STRING	Additional properties for cloud export.
certifications	STRING	Product certifications or standards.
auto_pricing_min_price	STRING	Minimum price for auto pricing.
identifier_exists	STRING	Indicates whether an identifier exists for the product.
sell_on_google_quantity	STRING	Available quantity for selling on Google.
max_handling_time	STRING	Maximum handling time in shipping.
min_handling_time	STRING	Minimum handling time in shipping.
shipping_label	STRING	Label used for shipping.
transit_time_label	STRING	Label indicating transit time.
tax_category	STRING	Tax category for the product.
energy_efficiency_class	STRING	Energy efficiency class rating.
min_energy_efficiency_class	STRING	Minimum energy efficiency rating.
max_energy_efficiency_class	STRING	Maximum energy efficiency rating.
multipack	STRING	Information about multipack offerings.
ads_grouping	STRING	Grouping information for ads.
ads_redirect	STRING	Redirect URL for ads.
display_ads_id	STRING	Identifier used in display ads.
display_ads_title	STRING	Title used in display ads.
display_ads_link	STRING	Link used in display ads.
display_ads_value	STRING	Value related to display ads.
pickup_method	STRING	Method available for pickup.
pickup_sla	STRING	Service level agreement for pickup.
link_template	STRING	Template used for generating product links.
mobile_link_template	STRING	Template used for generating mobile links.
external_seller_id	STRING	Identifier for external sellers.
virtual_model_link	STRING	Link to a virtual model of the product.
structured_title	STRING	Structured product title.
structured_description	STRING	Structured product description.
product_statuscreation_date	STRING	Creation date of the product status.
product_statuslast_update_date	STRING	Last update date of the product status.
product_statusgoogle_expiration_date	STRING	Google expiration date of the product status.

Table: shopping_insights_performance_view_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
date	DATE	The date of the record.
customer_id	STRING	Unique identifier for the customer.
customer_name	STRING	The name of the customer.
currency	STRING	Currency code for transactions.
source_currency	STRING	Source currency code.
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
aggregator_id	STRING	Unique identifier for the aggregator.
market_name	STRING	Name of the market.
channel_grouping	STRING	Grouping for channel classification.
offer_id	STRING	Unique identifier for the product in merchant center.
feed_label	STRING	Label identifier for the feed.
country_code	STRING	Country code associated with the record.
product_channel	STRING	Product channel through which the offer is delivered.
campaign_id	STRING	Unique campaign identifier.
campaign_name	STRING	Name of the campaign.
campaign_serving_status	STRING	Current serving status of the campaign.
campaign_type	STRING	Type of the campaign.
campaign_sub_type	STRING	Subtype of the campaign.
campaign_status	STRING	Status of the campaign.
bidding_strategy_type	STRING	Bidding strategy employed.
is_portfolio_strategy	BOOL	Indicates if a portfolio strategy is used.
target_roas	FLOAT64	Target return on ad spend.
target_cpa	FLOAT64	Target cost per acquisition.
brand_historical	STRING	Historical brand information.
title_historical	STRING	Historical title information.
color_historical	STRING	Historical color details.
material_historical	STRING	Historical material details.
mpn_historical	STRING	Historical manufacturer part number.
pattern_historical	STRING	Historical pattern details.
gender_historical	STRING	Historical gender targeting.
size_historical	STRING	Historical size information.
size_system_historical	STRING	Historical sizing system.
gtin_historical	STRING	Historical Global Trade Item Number.
adult_historical	STRING	Historical indication of adult content.
age_group_historical	STRING	Historical age group targeting.
availability_historical	STRING	Historical availability status.
condition_historical	STRING	Historical condition of the product.
product_type_historical	STRING	Historical product type details.
on_sale_historical	BOOL	Historical indicator if the product was on sale.
price_historical	FLOAT64	Historical price of the product.
price_currency_historical	STRING	Currency code for the historical price.
sale_price_historical	FLOAT64	Historical sale price.
sale_price_currency_historical	STRING	Currency code for the historical sale price.
listed_price_historical	FLOAT64	Historical listed price.
sale_price_effective_date_historical	STRING	Effective date for the historical sale price.
image_link_historical	STRING	Historical URL for the product image.
custom_label_0_historical	STRING	Historical custom label 0.
custom_label_1_historical	STRING	Historical custom label 1.
custom_label_2_historical	STRING	Historical custom label 2.
custom_label_3_historical	STRING	Historical custom label 3.
custom_label_4_historical	STRING	Historical custom label 4.
creation_date_historical	STRING	Historical record creation date.
last_update_date_historical	STRING	Historical record last update date.
product_approval_status_historical	STRING	Historical product approval status.
free_listings_approval_status_historical	STRING	Historical free listings approval status.
ad_spend	FLOAT64	Total advertising spend.
impressions	FLOAT64	Total number of impressions.
clicks	FLOAT64	Total number of clicks.
absolute_top_impression_share	FLOAT64	Share of absolute top impressions.
click_share	FLOAT64	Share of clicks relative to total impressions.
impression_share	FLOAT64	Share of impressions relative to total opportunities.
conversions	FLOAT64	Total number of conversions.
conversion_value	FLOAT64	Total conversion value.
expected_value_per_day	FLOAT64	Expected value generated per day.
count_days_with_impressions	INT64	Number of days with recorded impressions.
ad_spend_comparison	STRING	Comparison metric for ad spend.
conversions_comparison	STRING	Comparison metric for conversions.
roas_comparison	STRING	Comparison metric for ROAS.
ad_spend_30d	FLOAT64	Advertising spend in the past 30 days.
impressions_30d	FLOAT64	Impressions in the past 30 days.
clicks_30d	FLOAT64	Clicks in the past 30 days.
conversions_30d	FLOAT64	Conversions in the past 30 days.
conversion_value_30d	FLOAT64	Conversion value in the past 30 days.
ad_spend_60d	FLOAT64	Advertising spend in the past 60 days.
impressions_60d	FLOAT64	Impressions in the past 60 days.
clicks_60d	FLOAT64	Clicks in the past 60 days.
conversions_60d	FLOAT64	Conversions in the past 60 days.
conversion_value_60d	FLOAT64	Conversion value in the past 60 days.
ad_spend_90d	FLOAT64	Advertising spend in the past 90 days.
impressions_90d	FLOAT64	Impressions in the past 90 days.
clicks_90d	FLOAT64	Clicks in the past 90 days.
conversions_90d	FLOAT64	Conversions in the past 90 days.
conversion_value_90d	FLOAT64	Conversion value in the past 90 days.
ad_spend_180d	FLOAT64	Advertising spend in the past 180 days.
impressions_180d	FLOAT64	Impressions in the past 180 days.
clicks_180d	FLOAT64	Clicks in the past 180 days.
conversions_180d	FLOAT64	Conversions in the past 180 days.
conversion_value_180d	FLOAT64	Conversion value in the past 180 days.
content_language	STRING	Language of the content.
price	FLOAT64	Current product price.
price_currency	STRING	Currency for the current price.
sale_price_currency	STRING	Currency for the sale price.
sale_price	FLOAT64	Current sale price.
listed_price	FLOAT64	Current listed price.
on_sale	BOOL	Indicator if the product is on sale.
gtin	STRING	Current Global Trade Item Number.
additional_image_links_1	STRING	First additional image link.
additional_image_links_2	STRING	Second additional image link.
additional_image_links_3	STRING	Third additional image link.
additional_image_links_4	STRING	Fourth additional image link.
additional_image_links_5	STRING	Fifth additional image link.
title	STRING	Current product title.
description	STRING	Product description details.
link	STRING	URL linking to the product page.
image_link	STRING	URL for the product's primary image.
adult	STRING	Indicator if the product is intended for adult audiences.
age_group	STRING	Target age group for the product.
availability	STRING	Current availability status.
brand	STRING	Brand name of the product.
color	STRING	Color information for the product.
condition	STRING	Current product condition.
gender	STRING	Target gender for the product.
google_product_category	STRING	Identifier for the Google product category.
google_product_category_name	STRING	Name of the Google product category.
item_group_id	STRING	Identifier for grouping similar items.
material	STRING	Material composition details.
mpn	STRING	Manufacturer part number.
pattern	STRING	Pattern details of the product.
product_type	STRING	Product type classification.
product_type_1	STRING	Primary product type classification.
product_type_2	STRING	Secondary product type classification.
product_type_3	STRING	Tertiary product type classification.
product_type_4	STRING	Quaternary product type classification.
product_type_5	STRING	Quinary product type classification.
size	STRING	Product size details.
size_system	STRING	System used for product sizing.
custom_label_0	STRING	Custom label 0 for segmentation.
custom_label_1	STRING	Custom label 1 for segmentation.
custom_label_2	STRING	Custom label 2 for segmentation.
custom_label_3	STRING	Custom label 3 for segmentation.
custom_label_4	STRING	Custom label 4 for segmentation.
is_bundle	STRING	Indicator if the product is sold as a bundle.
product_approval_status	STRING	Current product approval status.
free_listings_approval_status	STRING	Current free listings approval status.
approved_countries	STRING	List of countries where the product is approved.
disapproved_countries	STRING	List of countries where the product is disapproved.
click_potential	STRING	Estimated click potential for the product.
click_potential_rank	INT64	Ranking based on click potential.
alvie_shopping_label	STRING	Final shopping label assigned by Alvie.

Table: shopping_insights_price_benchmarks_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
date	DATE	The date of the record.
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
product_channel	STRING	Channel through which the product is offered.
feed_label	STRING	Label identifier for the product feed.
offer_id	STRING	Unique identifier for the offer.
ad_spend	FLOAT64	Total advertising spend.
impressions	FLOAT64	Total number of impressions.
clicks	FLOAT64	Total number of clicks.
conversions	FLOAT64	Total number of conversions.
conversion_value	FLOAT64	Total value generated from conversions.
impression_share	FLOAT64	Share of impressions relative to total available opportunities.
absolute_top_impression_share	FLOAT64	Metric indicating the absolute top impression share.
click_share	FLOAT64	Share of clicks relative to total opportunities.
benchmark_price	FLOAT64	Benchmark price used for price comparison.
has_benchmark	BOOL	Indicates if a benchmark price is available.
benchmark_price_currency_code	STRING	Currency code corresponding to the benchmark price.
content_language	STRING	Language of the product content.
price	FLOAT64	Current standard price of the product.
price_currency	STRING	Currency code for the standard price.
sale_price_currency	STRING	Currency code for the sale price.
sale_price	FLOAT64	Current sale price of the product.
listed_price	FLOAT64	Displayed price determined by using the sale price if it is lower than the standard price.
benchmark_price_with_currency	STRING	Formatted benchmark price along with its currency.
listed_price_with_currency	STRING	Formatted listed price along with its currency.
benchmark_price_difference_pct	FLOAT64	Percentage difference between the listed price and the benchmark price.
gtin	STRING	Global Trade Item Number of the product.
title	STRING	Title or name of the product.
description	STRING	Description of the product.
link	STRING	URL linking to the product page.
image_link	STRING	URL for the product's primary image.
adult	STRING	Indicator if the product is intended for adult audiences.
age_group	STRING	Target age group for the product.
availability	STRING	Availability status of the product.
brand	STRING	Brand name of the product.
color	STRING	Color information of the product.
condition	STRING	Condition of the product (e.g. new or used).
gender	STRING	Target gender for the product.
google_product_category	STRING	Identifier for the Google product category.
google_product_category_name	STRING	Name of the Google product category.
item_group_id	STRING	Identifier for grouping similar products.
material	STRING	Material composition of the product.
mpn	STRING	Manufacturer Part Number.
pattern	STRING	Pattern details of the product.
product_type	STRING	Classification of the product type.
size	STRING	Size specifications of the product.
size_system	STRING	Sizing system used (e.g. US, EU).
custom_label_0	STRING	Custom label for segmentation (0).
custom_label_1	STRING	Custom label for segmentation (1).
custom_label_2	STRING	Custom label for segmentation (2).
custom_label_3	STRING	Custom label for segmentation (3).
custom_label_4	STRING	Custom label for segmentation (4).
is_bundle	STRING	Indicates if the product is sold as a bundle.

Table: shopping_insights_price_suggestions_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Name of the merchant.
product_channel	STRING	Classification of the product channel.
feed_label	STRING	Label identifying the product feed.
offer_id	STRING	Unique identifier for the offer.
suggested_price	FLOAT64	Price recommended based on price insights.
suggested_price_currency_code	STRING	Currency code for the suggested price.
effectiveness	STRING	Effectiveness score or rating for the price suggestion.
predicted_impressions_change_fraction	FLOAT64	Predicted fraction change in impressions if the suggested price is applied.
predicted_clicks_change_fraction	FLOAT64	Predicted fraction change in clicks if the suggested price is applied.
predicted_conversions_change_fraction	FLOAT64	Predicted fraction change in conversions if the suggested price is applied.
impressions_30d	FLOAT64	Number of impressions recorded in the past 30 days.
clicks_30d	FLOAT64	Number of clicks recorded in the past 30 days.
conversions_30d	FLOAT64	Number of conversions recorded in the past 30 days.
potential_added_impressions_30d	FLOAT64	Calculated potential additional impressions in 30 days due to the suggested price.
potential_added_clicks_30d	FLOAT64	Calculated potential additional clicks in 30 days due to the suggested price.
potential_added_conversions_30d	FLOAT64	Calculated potential additional conversions in 30 days due to the suggested price.
has_price_suggestion	BOOL	Indicator whether a valid price suggestion is available.
content_language	STRING	Language code of the product content.
price	FLOAT64	Current standard price of the product.
price_currency	STRING	Currency code for the current price.
sale_price_currency	STRING	Currency code for the sale price.
sale_price	FLOAT64	Current sale price of the product if available.
listed_price	FLOAT64	Effective listed price (sale price if lower than the standard price otherwise the standard price).
suggested_price_with_currency	STRING	Formatted suggested price with its currency.
listed_price_with_currency	STRING	Formatted listed price with its currency.
gtin	STRING	Global Trade Item Number of the product.
title	STRING	Title or name of the product.
description	STRING	Product description.
link	STRING	URL linking to the product page.
image_link	STRING	URL for the product's primary image.
adult	STRING	Indicates if the product is intended for adult audiences.
age_group	STRING	Target age group for the product.
availability	STRING	Current availability status of the product.
brand	STRING	Brand of the product.
color	STRING	Color information of the product.
condition	STRING	Product condition (e.g. new, used).
gender	STRING	Target gender for the product.
google_product_category	STRING	Identifier for the Google product category.
google_product_category_name	STRING	Name of the Google product category.
item_group_id	STRING	Identifier used for grouping similar items.
material	STRING	Details on the product material composition.
mpn	STRING	Manufacturer Part Number.
pattern	STRING	Details regarding the product pattern.
product_type	STRING	Classification of the product type.
size	STRING	Product size details.
size_system	STRING	Sizing system used for the product (e.g. US, EU).
custom_label_0	STRING	Custom label field 0 for segmentation.
custom_label_1	STRING	Custom label field 1 for segmentation.
custom_label_2	STRING	Custom label field 2 for segmentation.
custom_label_3	STRING	Custom label field 3 for segmentation.
custom_label_4	STRING	Custom label field 4 for segmentation.
is_bundle	STRING	Indicator if the product is offered as a bundle.
alvie_shopping_label	STRING	Final shopping label assigned by the Alvie labeller.
click_potential	STRING	Estimated potential clicks based on product performance.
click_potential_rank	INT64	Rank based on the product's click potential.

Table: shopping_insights_products_with_first_historical_{table_suffix}

Note: Generated using AI

Column Name	Data Type	Description
merchant_id	STRING	Unique identifier for the merchant.
merchant_name	STRING	Merchant name.
product_channel	STRING	Product channel classification.
offer_id	STRING	Unique identifier for the offer.
feed_label	STRING	Identifier for the product feed.
content_language	STRING	Language code for the product content.
price	FLOAT64	Standard price from the Merchant API, if missing, falls back to historical backup (p).
price_currency	STRING	Currency code for the standard price from the Merchant API, if missing, falls back to historical backup (p).
sale_price_currency	STRING	Currency code for the sale price from the Merchant API, if missing, falls back to historical backup (p).
sale_price	FLOAT64	Sale price from the Merchant API, if missing, falls back to historical backup (p).
listed_price	FLOAT64	Effective listed price calculated as the lower of the sale price or the standard price, uses historical backup (p) if necessary.
gtin	STRING	Global Trade Item Number from the Merchant API, if missing, falls back to historical backup (p).
additional_image_links_1	STRING	URL for the first additional image.,
additional_image_links_2	STRING	URL for the second additional image.,
additional_image_links_3	STRING	URL for the third additional image.,
additional_image_links_4	STRING	URL for the fourth additional image.,
additional_image_links_5	STRING	URL for the fifth additional image.,
title	STRING	Product title from the Merchant API, if missing, uses the backup title provided by Google Ads (b).
description	STRING	Product description.,
link	STRING	Product link from the Merchant API, if missing, falls back to historical backup (p).
image_link	STRING	Primary product image URL from the Merchant API, if missing, falls back to historical backup (p).
adult	STRING	Adult content flag from the Merchant API, if missing, falls back to historical backup (p).
age_group	STRING	Target age group from the Merchant API, if missing, falls back to historical backup (p).
availability	STRING	Product availability status.,
brand	STRING	Product brand from the Merchant API (lower-cased), if missing, uses the backup brand provided by Google Ads (b).
color	STRING	Color information from the Merchant API, if missing, falls back to historical backup (p).
condition	STRING	Product condition (e.g., new or used) from the Merchant API, if missing, falls back to historical backup (p).
gender	STRING	Target gender from the Merchant API, if missing, falls back to historical backup (p).
google_product_category	STRING	Google product category identifier from the Merchant API, if missing, falls back to historical backup (p).
google_product_category_name	STRING	Google product category name (lower-cased) from the Merchant API, if missing, uses the backup provided by Google Ads (b).
item_group_id	STRING	Group identifier for related products from the Merchant API, if missing, falls back to historical backup (p).
material	STRING	Material details from the Merchant API, if missing, falls back to historical backup (p).
mpn	STRING	Manufacturer Part Number from the Merchant API, if missing, falls back to historical backup (p).
pattern	STRING	Pattern details from the Merchant API, if missing, falls back to historical backup (p).
product_type	STRING	Primary product type from the Merchant API (lower-cased), if missing, uses the backup provided by Google Ads (b).
product_type_1	STRING	Additional product type classification 1 from the Merchant API (lower-cased), if missing, uses the backup provided by Google Ads (b).
product_type_2	STRING	Additional product type classification 2 from the Merchant API (lower-cased), if missing, uses the backup provided by Google Ads (b).
product_type_3	STRING	Additional product type classification 3 from the Merchant API (lower-cased), if missing, uses the backup provided by Google Ads (b).
product_type_4	STRING	Additional product type classification 4 from the Merchant API (lower-cased), if missing, uses the backup provided by Google Ads (b).
product_type_5	STRING	Additional product type classification 5 from the Merchant API (lower-cased), if missing, uses the backup provided by Google Ads (b).
size	STRING	Size details from the Merchant API, if missing, falls back to historical backup (p).
size_system	STRING	Sizing system from the Merchant API, if missing, falls back to historical backup (p).
custom_label_0	STRING	Custom label 0 from the Merchant API, if missing, uses the backup provided by Google Ads (b).
custom_label_1	STRING	Custom label 1 from the Merchant API, if missing, uses the backup provided by Google Ads (b).
custom_label_2	STRING	Custom label 2 from the Merchant API, if missing, uses the backup provided by Google Ads (b).
custom_label_3	STRING	Custom label 3 from the Merchant API, if missing, uses the backup provided by Google Ads (b).
custom_label_4	STRING	Custom label 4 from the Merchant API, if missing, uses the backup provided by Google Ads (b).
is_bundle	STRING	Indicator if the product is sold as a bundle.
product_approval_status	STRING	Product approval status.
free_listings_approval_status	STRING	Approval status for free listings.
approved_countries	STRING	List of countries where the product is approved.
disapproved_countries	STRING	List of countries where the product is disapproved.
first_price_historical	FLOAT64	Historical backup standard price from the first matching record (sorted by date).
first_price_currency_historical	STRING	Historical backup currency for the standard price.
first_sale_price_currency_historical	STRING	Historical backup currency for the sale price.
first_sale_price_historical	FLOAT64	Historical backup sale price from the first matching record.
first_gtin_historical	STRING	Historical backup GTIN from the first matching record.
first_title_historical	STRING	Historical backup title from the first matching record.
first_link_historical	STRING	Historical backup product link from the first matching record.
first_image_link_historical	STRING	Historical backup image link from the first matching record.
first_adult_historical	STRING	Historical backup adult flag from the first matching record.
first_age_group_historical	STRING	Historical backup target age group from the first matching record.
first_brand_historical	STRING	Historical backup brand from the first matching record.
first_color_historical	STRING	Historical backup color from the first matching record.
first_condition_historical	STRING	Historical backup product condition from the first matching record.
first_gender_historical	STRING	Historical backup target gender from the first matching record.
first_google_product_category_name_historical	STRING	Historical backup Google product category name from the first matching record.
first_item_group_id_historical	STRING	Historical backup item group identifier from the first matching record.
first_material_historical	STRING	Historical backup material from the first matching record.
first_mpn_historical	STRING	Historical backup Manufacturer Part Number from the first matching record.
first_pattern_historical	STRING	Historical backup pattern from the first matching record.
first_product_type_historical	STRING	Historical backup product type from the first matching record.
first_size_historical	STRING	Historical backup size from the first matching record.
first_size_system_historical	STRING	Historical backup sizing system from the first matching record.
first_custom_label_0_historical	STRING	Historical backup custom label 0 from the first matching record.
first_custom_label_1_historical	STRING	Historical backup custom label 1 from the first matching record.
first_custom_label_2_historical	STRING	Historical backup custom label 2 from the first matching record.
first_custom_label_3_historical	STRING	Historical backup custom label 3 from the first matching record.
first_custom_label_4_historical	STRING	Historical backup custom label 4 from the first matching record.

BigQuery tables behind Looker studio for the Creative insights report

BigQuery tables behind Looker studio dashboard for the Performance Max breakdown report v2

BigQuery tables behind Looker studio dashboard for the Shopping insights report v2

BigQuery tables behind Looker studio dashboard for the Search synergies report

BigQuery tables behind Looker studio dashboard for the Precis starter report