Stay organized with collectionsSave 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 thetargeting_status, we only consider advertiser
accounts that are accessible to the user who owns the
BigQuery export. For more information, seeManage access to
your Google Ads
account.
Table name
If you choose theProduct Targetingreport option when youset up a Google Merchant Center transfer,
BigQuery creates a table for the data during the transfer. The
table name starts with theProductTargeting_prefix:
If you configured the transfer with an individual merchant ID, the table
name isProductTargeting_MERCHANT_ID.
If you configured the transfer with an MCA account, the table name isProductTargeting_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-09-04 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,["# Google Merchant Center Product Targeting table\n==============================================\n\nOverview\n--------\n\nProduct targeting data helps merchants understand which products are targeted by\nthe Shopping and Performance Max campaigns in each linked advertiser account\nthat they can access.\n\n- All campaign targeting parameters are considered, such as [listing groups](https://support.google.com/google-ads/answer/11596074), [product groups](https://support.google.com/google-ads/answer/6275317), and [feed labels](https://support.google.com/merchants/answer/14994087).\n- Only active campaigns with active ad groups or asset groups are considered.\n- 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\n your Google Ads\n account](https://support.google.com/google-ads/answer/6372672).\n\nTable name\n----------\n\nIf you choose the **Product Targeting** report option when you\n[set up a Google Merchant Center transfer](/bigquery/docs/merchant-center-transfer-schedule-transfers#set_up_a_google_merchant_center_transfer),\nBigQuery creates a table for the data during the transfer. The\ntable name starts with the `ProductTargeting_` prefix:\n\n- If you configured the transfer with an individual merchant ID, the table name is `ProductTargeting_`\u003cvar label=\"merchant ID\" translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e.\n- If you configured the transfer with an MCA account, the table name is `ProductTargeting_`\u003cvar label=\"aggregator\n ID\" translate=\"no\"\u003eAGGREGATOR_ID\u003c/var\u003e.\n\nSchema\n------\n\nThe Product Targeting table has the following schema:"]]
