Google Merchant Center Performance Table schema
Performance Table schema
The Performance Table contains a high number of columns that you can use to understand the distribution of the following metrics at different levels:
Clicks: The total number of clicks on your products on Google. This report only counts visits to your product detail pages.
Impressions: Impressions count how often your products were shown on Google. We only count impressions where customers had the option to visit your product detail pages. If your products show zero impressions, you should verify that the products are approved and wait a few days for impressions to appear. Impressions may also not show if they are below a minimum threshold.
Note that Performance data might get updated up to 3 days in the past in order to account for corrections. We don't expect that the data will change drastically.
When you select Performance
as one of the reports that are relevant to your transfer, the following table is created:
ProductPerformance_merchant_id
The ProductPerformance_
table has the following schema:
Column | BigQuery data type | Description | Example data |
---|---|---|---|
merchant_id |
INTEGER |
Google Merchant Center account ID. | |
aggregator_id |
INTEGER |
ID of the Multi Client Account (MCA) if the merchant center account ID is managed by an MCA. Null otherwise. | |
offer_id |
STRING |
Merchant provided offer_id of the product at the time the interaction happened. | |
title |
STRING |
Title of the product at the time the interaction happened. | |
brand |
STRING |
Brand of the product at the time the interaction happened. | |
category_l1 |
STRING |
Google product category of the product at the time the interaction happened. | |
category_l2 |
STRING |
Google product category of the product at the time the interaction happened. | |
category_l3 |
STRING |
Google product category of the product at the time the interaction happened. | |
category_l4 |
STRING |
Google product category of the product at the time the interaction happened. | |
category_l5 |
STRING |
Google product category of the product at the time the interaction happened. | |
product_type_l1 |
STRING |
Product type attribute of the product at the time the interaction happened. | |
product_type_l2 |
STRING |
Product type attribute of the product at the time the interaction happened. | |
product_type_l3 |
STRING |
Product type attribute of the product at the time the interaction happened. | |
product_type_l4 |
STRING |
Product type attribute of the product at the time the interaction happened. | |
product_type_l5 |
STRING |
Product type attribute of the product at the time the interaction happened. | |
custom_label0 |
STRING |
Custom label attribute of the product at the time the interaction happened. | |
custom_label1 |
STRING |
Custom label attribute of the product at the time the interaction happened. | |
custom_label2 |
STRING |
Custom label attribute of the product at the time the interaction happened. | |
custom_label3 |
STRING |
Custom label attribute of the product at the time the interaction happened. | |
custom_label4 |
STRING |
Custom label attribute of the product at the time the interaction happened. | |
customer_country_code |
STRING |
Country of the customer clicking or seeing the product. | |
clicks |
INTEGER |
Total number of clicks on your products on Google that led to visits to your product detail pages. | |
impressions |
INTEGER |
Impressions count how often your products were shown on Google. This report only counts impressions where customers had the option to visit your product detail pages. If your products show zero impressions, you should verify that the products are approved and wait for a few days for impressions to appear. Impressions may also not show if they are below a minimum threshold. | |
destination |
STRING |
Whether the interaction happened on Shopping Ads or Free Listings. | shopping_ads, free_listings |