Google Merchant Center Product Targeting table
Overview
Product targeting data helps merchants understand which products are targeted bythe Shopping and Performance Max campaigns in each linked advertiser accountthat they can access.
- All campaign targeting parameters are considered, such aslisting groups,product groups, andfeed labels.
- Only active campaigns with active ad groups or asset groups are considered.
- To compute the
targeting_status, we only consider advertiseraccounts that are accessible to the user who owns theBigQuery export. For more information, seeManage access toyour Google Adsaccount.
Table name
If you choose theProduct Targeting report option when youset up a Google Merchant Center transfer,BigQuery creates a table for the data during the transfer. Thetable name starts with theProductTargeting_ prefix:
- If you configured the transfer with an individual merchant ID, the tablename 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. Note: Products targeted by Ads campaigns might not be eligible to serve. To check if your products are eligible, use the destinations.status field of the Products report. | TARGETED, NOT_TARGETED |
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-02-19 UTC.