Google Merchant Center Performance Table
Overview
The Performance Table contains columns that you can use to understand the distribution of the following metrics:
-
Clicks:The total number of clicks on your products on Google. Only visits to your product detail pages are counted.
-
Impressions:The total number of times your products were shown on Google. Only impressions where customers had the option to visit your product detail pages are counted. 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 for a category, which can lead to different totals than what is reported in other Google surfaces.
Note that Performance data might get updated up to 3 days in the past to account for corrections. The variations are usually small.
When you select Performance
as one of the reports that are relevant to your transfer, the following table is created:
-
ProductPerformance_ MERCHANT_ID
Schema
The ProductPerformance_
table has the following schema:
| Column | BigQuery data type | Description | Example data |
|---|---|---|---|
merchant_id
|
INTEGER
|
Google Merchant Center account ID. This field is a primary key | 1234 |
aggregator_id
|
INTEGER
|
ID of the Multi Client Account (MCA) if the merchant center account ID is managed by an MCA. Null otherwise. | 12345 |
offer_id
|
STRING
|
Merchant provided id of the product at the time the interaction happened. This field is a primary key. | tddy123uk |
title
|
STRING
|
Title of the product at the time the interaction happened. | TN2351 black USB |
brand
|
STRING
|
Brand of the product at the time the interaction happened. | Brand Name |
category_l1
|
STRING
|
Google product category of the product at the time the interaction happened. Set to an empty string when no category exists. | Animals & Pet Supplies |
category_l2
|
STRING
|
Google product category of the product at the time the interaction happened. Set to an empty string when no category exists. | Pet Supplies |
category_l3
|
STRING
|
Google product category of the product at the time the interaction happened. Set to an empty string when no category exists. | Dog Supplies |
category_l4
|
STRING
|
Google product category of the product at the time the interaction happened. Set to an empty string when no category exists. | Dog Beds |
category_l5
|
STRING
|
Google product category of the product at the time the interaction happened. Set to an empty string when no category exists. | |
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. | CH |
clicks
|
INTEGER
|
Total number of clicks on your products on Google that led to visits to your product detail pages. | 17 |
impressions
|
INTEGER
|
Total number of times your products were shown on Google. Only impressions where customers had the option to visit your product detail pages are counted. 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 for a category, which can lead to different totals than what is reported in other Google surfaces. | 601 |
destination
|
STRING
|
Whether the interaction happened on Shopping Ads or Free Listings. | FREE, ADS |
