Comparison Shopping Services Center table schema

When your Comparison Shopping Service (CSS) Center reporting data is transferredto BigQuery, the format of product and product issues datacorresponds primarily to the format of the relevant fields of the Content API'sProductViewandProductstatusesresources.

CSS Center Products Schema

The following table lists the schema for theProducts_ table. Some fields areincluded as subsets of other fields. For example, thePrice field containbothValue andCurrency fields.

Field name

Type

Description

CSS ID

INTEGER

CSS ID

Merchant ID

INTEGER

Merchant account ID who owns the offer

Product ID

STRING

A unique identifier of the item

Feed label

STRING

The feed label for the item, or "-" if not provided

Language code

STRING

The two-letter ISO 639-1 language code for the item

Channel

STRING

The item's channel, eitheronline orlocal

Title

STRING

Title of the item

Brand

STRING

Brand of the item

Category l{1-5}

INTEGER

Google Product Category of the item

Product type l{1-5}

STRING

Product type of the item

Price

RECORD

Full price of the item, prior to any discounts

    Value

INTEGER

Price value of the item

    Currency

STRING

The currency of the price

Sale Price

RECORD

Sale price of the item, if applicable

    Value

INTEGER

Sale price value of the item

    Currency

STRING

The currency of the sale price

Condition

STRING

Condition or state of the item

Availability

STRING

Availability status of the item

Shipping label

STRING

The shipping label specified in the feed

Gtin

STRING

Global Trade Item Number (GTIN) of the item

Item group ID

STRING

Shared identifier for all variants of the same product

Creation time

INTEGER

The time this item was created by the provider as timestamp microseconds

Expiration date

DATE

Date on which the item should expire, as specified upon insertion

Aggregated reporting context status

STRING

The status of the product aggregated for all reporting contexts. The supported values areELIGIBLE,ELIGIBLE_LIMITED,PENDING,NOT_ELIGIBLE_OR_DISAPPROVED,AGGREGATED_STATUS_UNSPECIFIED

Reporting context statuses

RECORD,REPEATED

The status of the product in each reporting context and region

     Reporting context

STRING

Reporting context

     Region and status

RECORD,REPEATED

Status per region

         Region

STRING

Region code represented in ISO 3166 format

         Status

STRING

Status of the product in the region, can beELIGIBLE,PENDING, orDISAPPROVED

Item issues

RECORD,REPEATED

The list of item level issues associated with the product

     Type

RECORD

Issue type

         Code

STRING

The error code of the issue, equivalent to thecode of Product issues

         Canonical attribute

STRING

Canonical attribute name for attribute-specific issues

     Severity

RECORD

How this issue affects serving of the offer

         Severity per reporting context

RECORD,REPEATED

Issue severity per reporting context

             Reporting context

STRING

Reporting context the issue applies to

             Disapproved regions

STRING,REPEATED

List of disapproved regions in the reporting context, represented in ISO 3166 format

             Demoted regions

STRING,REPEATED

List of demoted regions in the reporting context, represented in ISO 3166 format

         Aggregated severity

STRING

Aggregated severity of the issue for all reporting contexts it affects. Its values can beAGGREGATED_ISSUE_SEVERITY_UNSPECIFIED,DISAPPROVED,DEMOTED, orPENDING

     Resolution

STRING

Whether the issue can be resolved by the merchant

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 2025-12-15 UTC.