Stay organized with collections
Save and categorize content based on your preferences.
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.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["\u003cp\u003eProduct targeting data in Google Merchant Center helps merchants identify which products are targeted by their Shopping and Performance Max campaigns across linked advertiser accounts.\u003c/p\u003e\n"],["\u003cp\u003eThe targeting analysis considers all active campaigns with active ad groups or asset groups and incorporates listing groups, product groups, and feed labels.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003etargeting_status\u003c/code\u003e in the Product Targeting table indicates whether a product is targeted by Google Ads campaigns, but does not reflect the product's eligibility to serve.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery creates a table for this data with a name prefixed by \u003ccode\u003eProductTargeting_\u003c/code\u003e, followed by either the individual merchant ID or the MCA aggregator ID.\u003c/p\u003e\n"],["\u003cp\u003eThe table contains the \u003ccode\u003eproduct_id\u003c/code\u003e and the \u003ccode\u003eadvertiser_id\u003c/code\u003e, and \u003ccode\u003etargeting_status\u003c/code\u003e for each product, with the product ID provided by the content API.\u003c/p\u003e\n"]]],[],null,[]]