Google Merchant Center Product Targeting table

Overview

Product targeting data helps merchants understand which products are targeted by the Shopping and Performance Max campaigns in each linked advertiser account that they can access.

Table name

If you choose the Product Targeting report option when you set up a Google Merchant Center transfer, BigQuery creates a table for the data during the transfer. The table name starts with the ProductTargeting_ prefix:

  • If you configured the transfer with an individual merchant ID, the table name is ProductTargeting_MERCHANT_ID.
  • If you configured the transfer with an MCA account, the table name is ProductTargeting_AGGREGATOR_ID.

Schema

The Product Targeting table has the following schema:

Name Type Description Example data
product_id STRING The Content API REST ID for the product is in the format: channel:content_language:feed_label:offer_id. This field is a primary key. online:en:AU:666840730
advertiser_id INTEGER Advertiser ID of the campaign. This field is a primary key. 4321
targeting_status STRING Whether the product is targeted by Ads campaigns.
TARGETED, NOT_TARGETED