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 |