Migrate the price competitiveness report

This document helps you migrate from the price benchmarks report, which will be deprecated on September 1, 2025, to the new price competitiveness report.

The new price competitiveness report offers the following:

Parity with the older version of the report and improved consistency with other similar Google products—for example, the PriceCompetitivenessProductView field for the Content API for Shopping.
Additional insights about a merchant's pricing data.

Compare price benchmarks and price competitiveness table schemas

The following table helps you identify fields in the Products_PriceBenchmarks table that have equivalent replacements in the PriceCompetitiveness_ table :

Price benchmarks (old)	Price competitiveness (new)
`product_id`	`id`
`merchant_id`	`merchant_id`
`aggregator_id`	`aggregator_id`
`country_of_sale`	`report_country_code`
`price_benchmark_value`	`benchmark_price.amount_micros`
`price_benchmark_currency`	`benchmark_price.currency_code`
`price_benchmark_timestamp`	`_PARTITIONDATE` or `_PARTITIONTIME`

Moreover, the PriceCompetitiveness_ table contains additional data about inventory such as title, brand, product types and category, and the product price in a merchant's inventory. This data lets you effectively compare and analyze the benchmark prices with your own.

The following additional fields are available in the new PriceCompetitiveness_ table :

Field	Description
`title`	Title of the product.
`brand`	Brand of the product.
`offer_id`	Merchant-provided ID of the product .
`price`	Price of the product.
`price.amount_micros`	Price of the item, in micros (1 is represented as 1000000).
`price.currency_code`	Currency of the price of the item.
`product_type_l1`	Product type attribute of the product.
`product_type_l2`	Product type attribute of the product.
`product_type_l3`	Product type attribute of the product.
`product_type_l4`	Product type attribute of the product.
`product_type_l5`	Product type attribute of the product.
`category_l1`	Google product category of the product.
`category_l2`	Google product category of the product.
`category_l3`	Google product category of the product.
`category_l4`	Google product category of the product.
`category_l5`	Google product category of the product.

Price competitiveness and price benchmarks don't support backfills. They always return the current data available when you request a transfer.

Example queries

This section highlights changes in example queries that are used to retrieve price competitiveness data.

Example 1: Retrieve product price benchmarks per country

The following queries return a list of product price benchmarks per country. Note that a product can have different benchmarks in different countries.

Use the `Products_PriceBenchmarks` table (old)

  SELECT 
  
 DATE 
 ( 
 price_benchmark_timestamp 
 ) 
  
 AS 
  
 date 
 , 
  
 product_id 
 , 
  
 merchant_id 
 , 
  
 aggregator_id 
 , 
  
 country_of_sale 
 , 
  
 price_benchmark_value 
 , 
  
 price_benchmark_currency 
 FROM 
  
 ` DATASET 
.Products_PriceBenchmarks_ MERCHANT_ID 
` 
 WHERE 
  
 _PARTITIONDATE 
  
> = 
  
 ' DATE 
' 
 ;

Use the `PriceCompetitiveness` table (new)

  SELECT 
  
 _PARTITIONDATE 
  
 AS 
  
 date 
 , 
  
 id 
 , 
  
 merchant_id 
 , 
  
 aggregator_id 
 , 
  
 report_country_code 
 , 
  
 benchmark_price 
 . 
 amount_micros 
 , 
  
 benchmark_price 
 . 
 currency_code 
 FROM 
  
 ` DATASET 
.PriceCompetitiveness_ MERCHANT_ID 
` 
 WHERE 
  
 _PARTITIONDATE 
  
> = 
  
 ' DATE 
' 
 ;

Example 2: Retrieve products and associated benchmarks

The following queries retrieve products and their associated benchmarks.

Join the `Products` and `PriceBenchmarks` tables (old)

  WITH 
  
 products 
  
 AS 
  
 ( 
  
 SELECT 
  
 _PARTITIONDATE 
  
 AS 
  
 date 
 , 
  
 * 
  
 FROM 
  
 ` DATASET 
.Products_ MERCHANT_ID 
` 
  
 WHERE 
  
 _PARTITIONDATE 
  
> = 
  
 ' DATE 
' 
 ), 
  
 benchmarks 
  
 AS 
  
 ( 
  
 SELECT 
  
 _PARTITIONDATE 
  
 AS 
  
 date 
 , 
  
 * 
  
 FROM 
  
 ` DATASET 
.Products_PriceBenchmarks_ MERCHANT_ID 
` 
  
 WHERE 
  
 _PARTITIONDATE 
  
> = 
  
 ' DATE 
' 
 ) 
 SELECT 
  
 products 
 . 
 date 
 , 
  
 products 
 . 
 product_id 
 , 
  
 products 
 . 
 merchant_id 
 , 
  
 products 
 . 
 aggregator_id 
 , 
  
 products 
 . 
 price 
 , 
  
 benchmarks 
 . 
 price_benchmark_value 
 , 
  
 benchmarks 
 . 
 price_benchmark_currency 
 , 
  
 benchmarks 
 . 
 country_of_sale 
 FROM 
  
 products 
 INNER 
  
 JOIN 
  
 benchmarks 
 ON 
  
 products 
 . 
 product_id 
  
 = 
  
 benchmarks 
 . 
 product_id 
  
 AND 
  
 products 
 . 
 merchant_id 
  
 = 
  
 benchmarks 
 . 
 merchant_id 
  
 AND 
  
 products 
 . 
 date 
  
 = 
  
 benchmarks 
 . 
 date 
 ;

Use the `PriceCompetitiveness` table (new)

  SELECT 
  
 _PARTITIONDATE 
  
 AS 
  
 date 
 , 
  
 id 
  
 AS 
  
 product_id 
 , 
  
 merchant_id 
 , 
  
 aggregator_id 
 , 
  
 price 
 . 
 amount_micros 
 , 
  
 price 
 . 
 currency_code 
 , 
  
 benchmark_price 
 . 
 amount_micros 
 , 
  
 benchmark_price 
 . 
 currency_code 
 , 
  
 report_country_code 
  
 AS 
  
 country_of_sale 
 FROM 
  
 ` DATASET 
.PriceCompetitiveness_ MERCHANT_ID 
` 
 WHERE 
  
 _PARTITIONDATE 
  
> = 
  
 ' DATE 
' 
 ;

In these queries, replace the following:

DATASET : the name of your dataset
MERCHANT_ID : the merchant account ID
DATE : the date in the YYYY-MM-DD format

What's next

For more information about the new price competitiveness report, see Google Google Merchant Center Price Competitiveness table .

Migrate the price competitiveness report

Compare price benchmarks and price competitiveness table schemas

Example queries

Example 1: Retrieve product price benchmarks per country

Use the Products_PriceBenchmarks table (old)

Use the PriceCompetitiveness table (new)

Example 2: Retrieve products and associated benchmarks

Join the Products and PriceBenchmarks tables (old)

Use the PriceCompetitiveness table (new)

What's next

Use the `Products_PriceBenchmarks` table (old)

Use the `PriceCompetitiveness` table (new)

Join the `Products` and `PriceBenchmarks` tables (old)

Use the `PriceCompetitiveness` table (new)