# Google Merchant Center product targeting table

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](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).
- 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](https://support.google.com/google-ads/answer/6372672).

## Table name

If you choose the **Product Targeting** report option when you
[set up a Google Merchant Center transfer](https://docs.cloud.google.com/bigquery/docs/merchant-center-transfer-schedule-transfers.md.txt#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 Google Ads campaigns. > [!NOTE] > **Note:** Products targeted by Google Ads campaigns might not be eligible to serve. To check if your products are eligible, use the `destinations.approved_countries`, `destinations.pending_countries`, and `destinations.disapproved_countries` fields of the [products report](https://docs.cloud.google.com/bigquery/docs/merchant-center-products-schema.md.txt). | TARGETED, NOT_TARGETED |