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.

• All campaign targeting parameters are considered, such as listing groups, product groups, and feed labels.
• Only active campaigns with active ad groups or asset groups are considered.
• To compute the targeting_status, we only consider advertiser accounts that are accessible to the user who owns the BigQuery export. For more information, see Manage access to your Google Ads account.

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