Method: reports.search

Retrieves merchant performance metrics matching the search query and optionally segmented by selected dimensions.

HTTP request

POST https://shoppingcontent.googleapis.com/content/v2.1/{merchantId}/reports/search

Path parameters

Parameters
merchantId

string (int64 format)

Required. Id of the merchant making the call. Must be a standalone account or an MCA subaccount.

Request body

The request body contains data with the following structure:

JSON representation 
{
  "query": string,
  "pageSize": integer,
  "pageToken": string
}
Fields
query

string

Required. Query that defines performance metrics to retrieve and dimensions according to which the metrics are to be segmented.

For details on how to construct your query, see the Query Language guide.
pageSize

integer

Number of ReportRows to retrieve in a single page. Defaults to 1000. Values above 5000 are coerced to 5000.
pageToken

string

Token of the page to retrieve. If not specified, the first page of results is returned. In order to request the next page of results, the value obtained from nextPageToken in the previous response should be used.

Response body

Response message for the ReportService.Search method.

If successful, the response body contains data with the following structure:

JSON representation 
{
  "results": [
    {
      object (ReportRow)
    }
  ],
  "nextPageToken": string
}
Fields
results[]

object (ReportRow)

Rows that matched the search query.
nextPageToken

string

Token which can be sent as pageToken to retrieve the next page. If omitted, there are no subsequent pages.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/content

For more information, see the OAuth 2.0 Overview.

ReportRow

Result row returned from the search query.

JSON representation 
{
  "segments": {
    object (Segments)
  },
  "metrics": {
    object (Metrics)
  },
  "productView": {
    object (ProductView)
  },
  "productCluster": {
    object (ProductCluster)
  },
  "brand": {
    object (Brand)
  },
  "bestSellers": {
    object (BestSellers)
  },
  "priceCompetitiveness": {
    object (PriceCompetitiveness)
  },
  "priceInsights": {
    object (PriceInsights)
  },
  "competitiveVisibility": {
    object (CompetitiveVisibility)
  },
  "topicTrends": {
    object (TopicTrends)
  }
}
Fields
segments

object (Segments)

Segmentation dimensions requested by the merchant in the query. Dimension values are only set for dimensions requested explicitly in the query.
metrics

object (Metrics)

Metrics requested by the merchant in the query. Metric values are only set for metrics requested explicitly in the query.
productView

object (ProductView)

Product fields requested by the merchant in the query. Field values are only set if the merchant queries ProductView.
productCluster

object (ProductCluster)

Product cluster fields requested by the merchant in the query. Field values are only set if the merchant queries BestSellersProductClusterView.
brand

object (Brand)

Brand fields requested by the merchant in the query. Field values are only set if the merchant queries BestSellersBrandView.
bestSellers

object (BestSellers)

Best sellers fields requested by the merchant in the query. Field values are only set if the merchant queries BestSellersProductClusterView or BestSellersBrandView.
priceCompetitiveness

object (PriceCompetitiveness)

Price competitiveness fields requested by the merchant in the query. Field values are only set if the merchant queries PriceCompetitivenessProductView.
priceInsights

object (PriceInsights)

Price insights fields requested by the merchant in the query. Field values are only set if the merchant queries PriceInsightsProductView.
competitiveVisibility

object (CompetitiveVisibility)

Competitive visibility fields requested by the merchant in the query. Field values are only set if the merchant queries CompetitiveVisibilityTopMerchantView, CompetitiveVisibilityBenchmarkView or CompetitiveVisibilityCompetitorView.

Segments

Dimensions according to which metrics are segmented in the response. Values of product dimensions, such as offerId, reflect the state of a product at the time of the corresponding event, for example, impression or order.

Segment fields cannot be selected in queries without also selecting at least one metric field.

Values are only set for dimensions requested explicitly in the request's search query.

JSON representation 
{
  "program": enum (Program),
  "date": {
    object (Date)
  },
  "week": {
    object (Date)
  },
  "customerCountryCode": string,
  "currencyCode": string,
  "offerId": string,
  "title": string,
  "brand": string,
  "categoryL1": string,
  "categoryL2": string,
  "categoryL3": string,
  "categoryL4": string,
  "categoryL5": string,
  "productTypeL1": string,
  "productTypeL2": string,
  "productTypeL3": string,
  "productTypeL4": string,
  "productTypeL5": string,
  "customLabel0": string,
  "customLabel1": string,
  "customLabel2": string,
  "customLabel3": string,
  "customLabel4": string
}
Fields
program

enum (Program)

Program to which metrics apply, for example, Free Product Listing.
date

object (Date)

Date in the merchant timezone to which metrics apply.
week

object (Date)

First day of the week (Monday) of the metrics date in the merchant timezone.
customerCountryCode

string

Code of the country where the customer is located at the time of the event. Represented in the ISO 3166 format.

If the customer country cannot be determined, a special 'ZZ' code is returned.
currencyCode

string

Currency in which price metrics are represented, for example, if you select orderedItemSalesMicros, the returned value will be represented by this currency.
offerId

string

Merchant-provided id of the product.
title

string

Title of the product.
brand

string

Brand of the product.
categoryL1

string

Product category (1st level) in Google's product taxonomy.
categoryL2

string

Product category (2nd level) in Google's product taxonomy.
categoryL3

string

Product category (3rd level) in Google's product taxonomy.
categoryL4

string

Product category (4th level) in Google's product taxonomy.
categoryL5

string

Product category (5th level) in Google's product taxonomy.
productTypeL1

string

Product type (1st level) in merchant's own product taxonomy.
productTypeL2

string

Product type (2nd level) in merchant's own product taxonomy.
productTypeL3

string

Product type (3rd level) in merchant's own product taxonomy.
productTypeL4

string

Product type (4th level) in merchant's own product taxonomy.
productTypeL5

string

Product type (5th level) in merchant's own product taxonomy.
customLabel0

string

Custom label 0 for custom grouping of products.
customLabel1

string

Custom label 1 for custom grouping of products.
customLabel2

string

Custom label 2 for custom grouping of products.
customLabel3

string

Custom label 3 for custom grouping of products.
customLabel4

string

Custom label 4 for custom grouping of products.

Program

Programs as part of which merchant's products are listed across Google.

Enums
PROGRAM_UNSPECIFIED Not specified.
SHOPPING_ADS Shopping Ads.
FREE_PRODUCT_LISTING Free Product Listing.
FREE_LOCAL_PRODUCT_LISTING Free Local Product Listing.
BUY_ON_GOOGLE_LISTING

Buy on Google Listing.

Date

Represents a whole or partial calendar date, such as a birthday. The time of day and time zone are either specified elsewhere or are insignificant. The date is relative to the Gregorian Calendar. This can represent one of the following:

  • A full date, with non-zero year, month, and day values.
  • A month and day, with a zero year (for example, an anniversary).
  • A year on its own, with a zero month and a zero day.
  • A year and month, with a zero day (for example, a credit card expiration date).

Related types:

JSON representation 
{
  "year": integer,
  "month": integer,
  "day": integer
}
Fields
year

integer

Year of the date. Must be from 1 to 9999, or 0 to specify a date without a year.
month

integer

Month of a year. Must be from 1 to 12, or 0 to specify a year without a month and day.
day

integer

Day of a month. Must be from 1 to 31 and valid for the year and month, or 0 to specify a year by itself or a year and month where the day isn't significant.

Metrics

Performance metrics. Values are only set for metrics requested explicitly in the request's search query.

JSON representation 
{
  "clicks": string,
  "impressions": string,
  "ctr": number,
  "conversions": number,
  "conversionValueMicros": string,
  "conversionRate": number,
  "orders": string,
  "shippedOrders": string,
  "unshippedOrders": number,
  "daysToShip": number,
  "aos": number,
  "aovMicros": number,
  "orderedItems": string,
  "orderedItemSalesMicros": string,
  "shippedItems": string,
  "unshippedItems": number,
  "shippedItemSalesMicros": string,
  "rejectedItems": string,
  "itemDaysToShip": number,
  "itemFillRate": number,
  "returnedItems": string,
  "returnsMicros": string,
  "returnRate": number
}
Fields
clicks

string (Int64Value format)

Number of clicks.
impressions

string (Int64Value format)

Number of times merchant's products are shown.
ctr

number

Click-through rate - the number of clicks merchant's products receive (clicks) divided by the number of times the products are shown (impressions).
conversions

number

Number of conversions attributed to the product, reported on the conversion date. Depending on the attribution model, a conversion might be distributed across multiple clicks, where each click gets its own credit assigned. This metric is a sum of all such credits.

The metric is currently available only for the FREE_PRODUCT_LISTING program.
conversionValueMicros

string (Int64Value format)

Value of conversions in micros (1 millionth of a standard unit, 1 USD = 1000000 micros) attributed to the product, reported on the conversion date.

The metric is currently available only for the FREE_PRODUCT_LISTING program.

The currency of the returned value is stored in the currencyCode segment. If this metric is selected, 'segments.currency_code' is automatically added to the SELECT clause in the search query (unless it is explicitly selected by the user) and the currencyCode segment is populated in the response.
conversionRate

number

Number of conversions divided by the number of clicks, reported on the impression date.

The metric is currently available only for the FREE_PRODUCT_LISTING program.
orders

string (Int64Value format)

Number of placed orders. Excludes customer cancellations that happened within 30 minutes of placing the order.

This metric cannot be segmented by product dimensions and customerCountryCode.
shippedOrders

string (Int64Value format)

Number of fully shipped orders, reported on the last shipment date.

This metric cannot be segmented by product dimensions and customerCountryCode.
unshippedOrders

number

Number of orders not shipped or partially shipped up until the end of the queried day. If a multi-day period is specified in the search query, the returned value is the average number of unshipped orders over the days in the queried period.

This metric cannot be segmented by product dimensions and customerCountryCode.
daysToShip

number

Average number of days between an order being placed and the order being fully shipped, reported on the last shipment date.

This metric cannot be segmented by product dimensions and customerCountryCode.
aos

number

Average order size - the average number of items in an order.

This metric cannot be segmented by product dimensions and customerCountryCode.
aovMicros

number

Average order value in micros (1 millionth of a standard unit, 1 USD = 1000000 micros) - the average value (total price of items) of all placed orders.

The currency of the returned value is stored in the currencyCode segment. If this metric is selected, 'segments.currency_code' is automatically added to the SELECT clause in the search query (unless it is explicitly selected by the user) and the currencyCode segment is populated in the response.

This metric cannot be segmented by product dimensions and customerCountryCode.
orderedItems

string (Int64Value format)

Number of ordered items. Excludes customer cancellations that happened within 30 minutes of placing the order.

This metric cannot be segmented by customerCountryCode.
orderedItemSalesMicros

string (Int64Value format)

Total price of ordered items in micros (1 millionth of a standard unit, 1 USD = 1000000 micros). Excludes shipping, taxes (US only), and customer cancellations that happened within 30 minutes of placing the order.

The currency of the returned value is stored in the currencyCode segment. If this metric is selected, 'segments.currency_code' is automatically added to the SELECT clause in the search query (unless it is explicitly selected by the user) and the currencyCode segment is populated in the response.

This metric cannot be segmented by customerCountryCode.
shippedItems

string (Int64Value format)

Number of shipped items, reported on the shipment date.

This metric cannot be segmented by customerCountryCode.
unshippedItems

number

Number of ordered items not shipped up until the end of the queried day. If a multi-day period is specified in the search query, the returned value is the average number of unshipped items over the days in the queried period.

This metric cannot be segmented by customerCountryCode.
shippedItemSalesMicros

string (Int64Value format)

Total price of shipped items in micros (1 millionth of a standard unit, 1 USD = 1000000 micros), reported on the order date. Excludes shipping and taxes (US only).

The currency of the returned value is stored in the currencyCode segment. If this metric is selected, 'segments.currency_code' is automatically added to the SELECT clause in the search query (unless it is explicitly selected by the user) and the currencyCode segment is populated in the response.

This metric cannot be segmented by customerCountryCode.
rejectedItems

string (Int64Value format)

Number of ordered items canceled by the merchant, reported on the order date.

This metric cannot be segmented by customerCountryCode.
itemDaysToShip

number

Average number of days between an item being ordered and the item being

This metric cannot be segmented by customerCountryCode.
itemFillRate

number

Percentage of shipped items in relation to all finalized items (shipped or rejected by the merchant; unshipped items are not taken into account), reported on the order date. Item fill rate is lowered by merchant rejections.

This metric cannot be segmented by customerCountryCode.
returnedItems

string (Int64Value format)

Number of ordered items sent back for return, reported on the date when the merchant accepted the return.

This metric cannot be segmented by customerCountryCode.
returnsMicros

string (Int64Value format)

Total price of ordered items sent back for return in micros (1 millionth of a standard unit, 1 USD = 1000000 micros), reported on the date when the merchant accepted the return.

The currency of the returned value is stored in the currencyCode segment. If this metric is selected, 'segments.currency_code' is automatically added to the SELECT clause in the search query (unless it is explicitly selected by the user) and the currencyCode segment is populated in the response.

This metric cannot be segmented by customerCountryCode.
returnRate

number

Total price of returned items divided by the total price of shipped items, reported on the order date.

If this metric is selected, 'segments.currency_code' is automatically added to the SELECT clause in the search query (unless it is explicitly selected by the user) and the currencyCode segment is populated in the response.

This metric cannot be segmented by customerCountryCode.

ProductView

Product fields. Values are only set for fields requested explicitly in the request's search query.

JSON representation 
{
  "id": string,
  "offerId": string,
  "title": string,
  "brand": string,
  "categoryL1": string,
  "categoryL2": string,
  "categoryL3": string,
  "categoryL4": string,
  "categoryL5": string,
  "productTypeL1": string,
  "productTypeL2": string,
  "productTypeL3": string,
  "productTypeL4": string,
  "productTypeL5": string,
  "currencyCode": string,
  "priceMicros": string,
  "languageCode": string,
  "condition": string,
  "channel": enum (Channel),
  "availability": string,
  "shippingLabel": string,
  "gtin": [
    string
  ],
  "itemGroupId": string,
  "creationTime": string,
  "expirationDate": {
    object (Date)
  },
  "aggregatedDestinationStatus": enum (AggregatedDestinationStatus),
  "itemIssues": [
    {
      object (ItemIssue)
    }
  ],
  "clickPotential": enum (ClickPotential),
  "clickPotentialRank": string
}
Fields
id

string

The REST ID of the product, in the form of channel:contentLanguage:targetCountry:offerId. Content API methods that operate on products take this as their productId parameter.

Should always be included in the SELECT clause.
offerId

string

Merchant-provided id of the product.
title

string

Title of the product.
brand

string

Brand of the product.
categoryL1

string

First level of the product category in Google's product taxonomy.
categoryL2

string

Second level of the product category in Google's product taxonomy.
categoryL3

string

Third level of the product category in Google's product taxonomy.
categoryL4

string

Fourth level of the product category in Google's product taxonomy.
categoryL5

string

Fifth level of the product category in Google's product taxonomy.
productTypeL1

string

First level of the product type in merchant's own product taxonomy.
productTypeL2

string

Second level of the product type in merchant's own product taxonomy.
productTypeL3

string

Third level of the product type in merchant's own product taxonomy.
productTypeL4

string

Fourth level of the product type in merchant's own product taxonomy.
productTypeL5

string

Fifth level of the product type in merchant's own product taxonomy.
currencyCode

string

Product price currency code (for example, ISO 4217). Absent if product price is not available.
priceMicros

string (Int64Value format)

Product price specified as micros (1 millionth of a standard unit, 1 USD = 1000000 micros) in the product currency. Absent in case the information about the price of the product is not available.
languageCode

string

Language code of the product in BCP 47 format.
condition

string

Condition of the product.
channel

enum (Channel)

Channel of the product (online versus local).
availability

string

Availability of the product.
shippingLabel

string

The normalized shipping label specified in the feed
gtin[]

string

GTIN of the product.
itemGroupId

string

Item group ID provided by the merchant for grouping variants together.
creationTime

string (Timestamp format)

The time the merchant created the product in timestamp seconds.
expirationDate

object (Date)

Expiration date for the product. Specified on insertion.
aggregatedDestinationStatus

enum (AggregatedDestinationStatus)

Aggregated destination status.
itemIssues[]

object (ItemIssue)

List of item issues for the product.
clickPotential

enum (ClickPotential)

Estimated performance potential compared to highest performing products of the merchant.
clickPotentialRank

string (Int64Value format)

Rank of the product based on its click potential. A product with clickPotentialRank 1 has the highest click potential among the merchant's products that fulfill the search query conditions.

Channel

The channel of the product.

Enums
CHANNEL_UNSPECIFIED Indicates that the channel is unspecified.
LOCAL Indicates that the channel is local.
ONLINE Indicates that the channel is online.

AggregatedDestinationStatus

The status of the product aggregated for all destinations. Here's an example of how aggregated destination status is processed:

FreeListings ShoppingAds Status
Approved Pending ELIGIBLE
Approved Disapproved ELIGIBLE_LIMITED
Disapproved Disapproved NOT_ELIGIBLE_OR_DISAPPROVED
Pending Pending PENDING
Approved Approved ELIGIBLE

Enums
AGGREGATED_STATUS_UNSPECIFIED Undefined aggregated status.
NOT_ELIGIBLE_OR_DISAPPROVED Offer isn't eligible, or is disapproved for all destinations.
PENDING Offer's status is pending in all destinations.
ELIGIBLE_LIMITED Offer is eligible for some (but not all) destinations.
ELIGIBLE Offer is eligible for all destinations.

ItemIssue

Item issue associated with the product.

JSON representation 
{
  "issueType": {
    object (ItemIssueType)
  },
  "severity": {
    object (ItemIssueSeverity)
  },
  "resolution": enum (IssueResolution)
}
Fields
issueType

object (ItemIssueType)

Item issue type.
severity

object (ItemIssueSeverity)

Item issue severity.
resolution

enum (IssueResolution)

Item issue resolution.

ItemIssueType

Type of the item issue.

JSON representation 
{
  "canonicalAttribute": string,
  "code": string
}
Fields
canonicalAttribute

string

Canonical attribute name for attribute-specific issues.
code

string

Error code of the issue.

ItemIssueSeverity

Severity of an issue per destination in a region, and aggregated severity.

JSON representation 
{
  "severityPerDestination": [
    {
      object (IssueSeverityPerDestination)
    }
  ],
  "aggregatedSeverity": enum (AggregatedIssueSeverity)
}
Fields
severityPerDestination[]

object (IssueSeverityPerDestination)

Item issue severity for every destination.
aggregatedSeverity

enum (AggregatedIssueSeverity)

Severity of an issue aggregated for destination.

IssueSeverityPerDestination

Issue severity for all affected regions in a destination.

JSON representation 
{
  "disapprovedCountries": [
    string
  ],
  "demotedCountries": [
    string
  ],
  "destination": string
}
Fields
disapprovedCountries[]

string

List of disapproved countries in the destination.
demotedCountries[]

string

List of demoted countries in the destination.
destination

string

Issue destination.

AggregatedIssueSeverity

Severity of an issue aggregated for a destination.

Enums
AGGREGATED_ISSUE_SEVERITY_UNSPECIFIED Undefined Issue severity.
DISAPPROVED Issue disapproves the product in at least one of the selected destinations.
DEMOTED Issue demotes the product in all selected destinations it affects.
PENDING Issue resolution is PENDING_PROCESSING.

IssueResolution

How to resolve the issue.

Enums
UNKNOWN Unknown resolution type.
MERCHANT_ACTION The merchant has to fix the issue.
PENDING_PROCESSING The issue will be resolved automatically (for example, image crawl), or Google review. No merchant action is required now. Resolution might lead to another issue (for example, if crawl fails).

ClickPotential

A product's click potential estimates its performance potential compared to highest performing products of the merchant. Click potential of a product helps merchants to prioritize which products to fix, and helps them understand how products are performing against their potential.

Enums
CLICK_POTENTIAL_UNSPECIFIED Unknown predicted clicks impact.
LOW Potential to receive a low number of clicks compared to the highest performing products of the merchant.
MEDIUM Potential to receive a moderate number of clicks compared to the highest performing products of the merchant.
HIGH Potential to receive a similar number of clicks as the highest performing products of the merchant.

ProductCluster

Product cluster fields. A product cluster is a grouping for different offers that represent the same product. Values are only set for fields requested explicitly in the request's search query.

JSON representation 
{
  "title": string,
  "brand": string,
  "categoryL1": string,
  "categoryL2": string,
  "categoryL3": string,
  "categoryL4": string,
  "categoryL5": string,
  "variantGtins": [
    string
  ],
  "inventoryStatus": enum (InventoryStatus),
  "brandInventoryStatus": enum (InventoryStatus)
}
Fields
title

string

Title of the product cluster.
brand

string

Brand of the product cluster.
categoryL1

string

Product category (1st level) of the product cluster, represented in Google's product taxonomy.
categoryL2

string

Product category (2nd level) of the product cluster, represented in Google's product taxonomy.
categoryL3

string

Product category (3rd level) of the product cluster, represented in Google's product taxonomy.
categoryL4

string

Product category (4th level) of the product cluster, represented in Google's product taxonomy.
categoryL5

string

Product category (5th level) of the product cluster, represented in Google's product taxonomy.
variantGtins[]

string

GTINs of example variants of the product cluster.
inventoryStatus

enum (InventoryStatus)

Tells whether the product cluster is IN_STOCK in your product feed across multiple countries, OUT_OF_STOCK in your product feed, or NOT_IN_INVENTORY at all. The field doesn't take the Best Sellers report country filter into account.
brandInventoryStatus

enum (InventoryStatus)

Tells if there is at least one product of the brand currently IN_STOCK in your product feed across multiple countries, all products are OUT_OF_STOCK in your product feed, or NOT_IN_INVENTORY. The field doesn't take the Best Sellers report country filter into account.

InventoryStatus

Status of the product cluster or brand in the merchant's inventory.

Enums
INVENTORY_STATUS_UNSPECIFIED pos.inventory status is unknown.
IN_STOCK Merchant has a product for this product cluster or brand in stock.
OUT_OF_STOCK Merchant has a product for this product cluster or brand in inventory but it is currently out of stock.
NOT_IN_INVENTORY Merchant does not have a product for this product cluster or brand in inventory.

Brand

Brand fields. Values are only set for fields requested explicitly in the request's search query.

JSON representation 
{
  "name": string
}
Fields
name

string

Name of the brand.

BestSellers

Fields related to the Best sellers reports.

JSON representation 
{
  "reportDate": {
    object (Date)
  },
  "reportGranularity": enum (ReportGranularity),
  "countryCode": string,
  "categoryId": string,
  "rank": string,
  "previousRank": string,
  "relativeDemand": enum (RelativeDemand),
  "previousRelativeDemand": enum (RelativeDemand),
  "relativeDemandChange": enum (RelativeDemandChangeType)
}
Fields
reportDate

object (Date)

Report date. The value of this field can only be one of the following: * The first day of the week (Monday) for weekly reports. * The first day of the month for monthly reports.

If a WHERE condition on bestSellers.report_date is not specified in the query, the latest available weekly or monthly report is returned.
reportGranularity

enum (ReportGranularity)

Granularity of the report. The ranking can be done over a week or a month timeframe.

A WHERE condition on bestSellers.report_granularity is required in the query.
countryCode

string

Country where the ranking is calculated.

A WHERE condition on bestSellers.country_code is required in the query.
categoryId

string (Int64Value format)

Google product category ID to calculate the ranking for, represented in Google's product taxonomy.

If a WHERE condition on bestSellers.category_id is not specified in the query, rankings for all top-level categories are returned.
rank

string (Int64Value format)

Popularity on Shopping ads and free listings, in the selected category and country, based on the estimated number of units sold.
previousRank

string (Int64Value format)

Popularity rank in the previous week or month.
relativeDemand

enum (RelativeDemand)

Estimated demand in relation to the item with the highest popularity rank in the same category and country.
previousRelativeDemand

enum (RelativeDemand)

Estimated demand in relation to the item with the highest popularity rank in the same category and country in the previous week or month.
relativeDemandChange

enum (RelativeDemandChangeType)

Change in the estimated demand. Whether it rose, sank or remained flat.

ReportGranularity

Granularity of the report. The ranking can be done over a week or a month timeframe.

Enums
REPORT_GRANULARITY_UNSPECIFIED Report granularity is unknown.
WEEKLY Ranking is done over a week timeframe.
MONTHLY Ranking is done over a month timeframe.

RelativeDemand

Relative demand of the product cluster or brand.

Enums
RELATIVE_DEMAND_UNSPECIFIED Relative demand is unknown.
VERY_LOW Demand is 0-5% of the demand of the highest ranked product clusters or brands.
LOW Demand is 6-10% of the demand of the highest ranked product clusters or brands.
MEDIUM Demand is 11-20% of the demand of the highest ranked product clusters or brands.
HIGH Demand is 21-50% of the demand of the highest ranked product clusters or brands.
VERY_HIGH Demand is 51-100% of the demand of the highest ranked product clusters or brands.

RelativeDemandChangeType

Relative demand of the product cluster or brand compared to the previous time period.

Enums
RELATIVE_DEMAND_CHANGE_TYPE_UNSPECIFIED Relative demand change is unknown.
SINKER Relative demand is lower than previous time period.
FLAT Relative demand is equal to previous time period.
RISER Relative demand is higher than the previous time period.

PriceCompetitiveness

Price competitiveness fields requested by the merchant in the query. Field values are only set if the merchant queries PriceCompetitivenessProductView. https://support.google.com/merchants/answer/9626903

JSON representation 
{
  "countryCode": string,
  "benchmarkPriceMicros": string,
  "benchmarkPriceCurrencyCode": string
}
Fields
countryCode

string

The country of the price benchmark (ISO 3166 code).
benchmarkPriceMicros

string (Int64Value format)

The latest available price benchmark in micros (1 millionth of a standard unit, 1 USD = 1000000 micros) for the product's catalog in the benchmark country.
benchmarkPriceCurrencyCode

string

The price benchmark currency (ISO 4217 code).

PriceInsights

Price insights fields requested by the merchant in the query. Field values are only set if the merchant queries PriceInsightsProductView. https://support.google.com/merchants/answer/11916926

JSON representation 
{
  "suggestedPriceMicros": string,
  "suggestedPriceCurrencyCode": string,
  "predictedImpressionsChangeFraction": number,
  "predictedClicksChangeFraction": number,
  "predictedConversionsChangeFraction": number,
  "predictedGrossProfitChangeFraction": number,
  "predictedMonthlyGrossProfitChangeMicros": string,
  "predictedMonthlyGrossProfitChangeCurrencyCode": string,
  "effectiveness": enum (Effectiveness)
}
Fields
suggestedPriceMicros

string (Int64Value format)

The latest suggested price in micros (1 millionth of a standard unit, 1 USD = 1000000 micros) for the product.
suggestedPriceCurrencyCode

string

The suggested price currency (ISO 4217 code).
predictedImpressionsChangeFraction

number

The predicted change in impressions as a fraction after introducing the suggested price compared to current active price. For example, 0.05 is a 5% predicted increase in impressions.
predictedClicksChangeFraction

number

The predicted change in clicks as a fraction after introducing the suggested price compared to current active price. For example, 0.05 is a 5% predicted increase in clicks.
predictedConversionsChangeFraction

number

The predicted change in conversions as a fraction after introducing the suggested price compared to current active price. For example, 0.05 is a 5% predicted increase in conversions).
predictedGrossProfitChangeFraction

number

The predicted change in gross profit as a fraction after introducing the suggested price compared to current active price. For example, 0.05 is a 5% predicted increase in gross profit.
predictedMonthlyGrossProfitChangeMicros

string (Int64Value format)

The predicted change in gross profit in micros (1 millionth of a standard unit, 1 USD = 1000000 micros) after introducing the suggested price for a month compared to current active price.
predictedMonthlyGrossProfitChangeCurrencyCode

string

The predicted monthly gross profit change currency (ISO 4217 code).
effectiveness

enum (Effectiveness)

The predicted effectiveness of applying the price suggestion, bucketed.

Effectiveness

Predicted effectiveness bucket.

Effectiveness indicates which products would benefit most from price changes. This rating takes into consideration the performance boost predicted by adjusting the sale price and the difference between your current price and the suggested price. Price suggestions with HIGH effectiveness are predicted to drive the largest increase in performance.

Enums
EFFECTIVENESS_UNSPECIFIED Effectiveness is unknown.
LOW Effectiveness is low.
MEDIUM Effectiveness is medium.
HIGH Effectiveness is high.

CompetitiveVisibility

Fields related to competitive visibility reports.

JSON representation 
{
  "date": {
    object (Date)
  },
  "domain": string,
  "isYourDomain": boolean,
  "countryCode": string,
  "categoryId": string,
  "trafficSource": enum (TrafficSource),
  "rank": string,
  "adsOrganicRatio": number,
  "pageOverlapRate": number,
  "higherPositionRate": number,
  "relativeVisibility": number,
  "yourDomainVisibilityTrend": number,
  "categoryBenchmarkVisibilityTrend": number
}
Fields
date

object (Date)

Date of this row.

Available only in CompetitiveVisibilityBenchmarkView and CompetitiveVisibilityCompetitorView.

Required in the SELECT clause for CompetitiveVisibilityMarketBenchmarkView.
domain

string

Domain of your competitor or your domain, if 'isYourDomain' is true.

Available only in CompetitiveVisibilityTopMerchantView and CompetitiveVisibilityCompetitorView.

Required in the SELECT clause for CompetitiveVisibilityTopMerchantView and CompetitiveVisibilityCompetitorView.

Cannot be filtered on in the 'WHERE' clause.
isYourDomain

boolean

True if this row contains data for your domain.

Available only in CompetitiveVisibilityTopMerchantView and CompetitiveVisibilityCompetitorView.

Cannot be filtered on in the 'WHERE' clause.
countryCode

string

The country where impression appeared.

Required in the SELECT clause.

A WHERE condition on competitiveVisibility.country_code is required in the query.
categoryId

string (Int64Value format)

Google product category ID to calculate the report for, represented in Google's product taxonomy.

Required in the SELECT clause.

A WHERE condition on competitiveVisibility.category_id is required in the query.
trafficSource

enum (TrafficSource)

Type of impression listing.

Required in the SELECT clause.

Cannot be filtered on in the 'WHERE' clause.
rank

string (UInt64Value format)

Position of the domain in the top merchants ranking for the selected keys (date, categoryId, countryCode, listing_type) based on impressions. 1 is the highest.

Available only in CompetitiveVisibilityTopMerchantView and CompetitiveVisibilityCompetitorView.

Cannot be filtered on in the 'WHERE' clause.
adsOrganicRatio

number

Ads / organic ratio shows how often a merchant receives impressions from Shopping ads compared to organic traffic. The number is rounded and bucketed.

Available only in CompetitiveVisibilityTopMerchantView and CompetitiveVisibilityCompetitorView.

Cannot be filtered on in the 'WHERE' clause.
pageOverlapRate

number

Page overlap rate describes how frequently competing retailers’ offers are shown together with your offers on the same page.

Available only in CompetitiveVisibilityTopMerchantView and CompetitiveVisibilityCompetitorView.

Cannot be filtered on in the 'WHERE' clause.
higherPositionRate

number

Higher position rate shows how often a competitor’s offer got placed in a higher position on the page than your offer.

Available only in CompetitiveVisibilityTopMerchantView and CompetitiveVisibilityCompetitorView.

Cannot be filtered on in the 'WHERE' clause.
relativeVisibility

number

Relative visibility shows how often your competitors’ offers are shown compared to your offers. In other words, this is the number of displayed impressions of a competitor retailer divided by the number of your displayed impressions during a selected time range for a selected product category and country.

Available only in CompetitiveVisibilityCompetitorView.

Cannot be filtered on in the 'WHERE' clause.
yourDomainVisibilityTrend

number

Change in visibility based on impressions for your domain with respect to the start of the selected time range (or first day with non-zero impressions).

Available only in CompetitiveVisibilityBenchmarkView.

Cannot be filtered on in the 'WHERE' clause.
categoryBenchmarkVisibilityTrend

number

Change in visibility based on impressions with respect to the start of the selected time range (or first day with non-zero impressions) for a combined set of merchants with highest visibility approximating the market.

Available only in CompetitiveVisibilityBenchmarkView.

Cannot be filtered on in the 'WHERE' clause.

TrafficSource

Traffic source.

Enums
UNKNOWN Traffic source is unknown.
ORGANIC Organic traffic.
ADS Traffic from Ads.
ALL Organic and Ads traffic.

TopicTrends

Topic trends fields requested by the merchant in the query. Field values are only set if the merchant queries TopicTrendsView.

Forecast data can be queried up to 13 weeks by passing a future date in the date field. Historical data is measured daily, and forecasted data is projected weekly. All data points are normalized based on the highest data points returned in the response. If you make separate queries with different date ranges, you might see different values for the same date in each response. The recommended way to get a trend score of a topic is last7DaysSearchInterest / last{$day}_days_search_interest - 1. You can view trends for up to eight topics at a time.

JSON representation 
{
  "customerCountryCode": string,
  "topic": string,
  "date": {
    object (Date)
  },
  "searchInterest": number,
  "last7DaysSearchInterest": number,
  "last30DaysSearchInterest": number,
  "last90DaysSearchInterest": number,
  "last120DaysSearchInterest": number,
  "next7DaysSearchInterest": number
}
Fields
customerCountryCode

string

Country trends are calculated for. Must be a two-letter country code (ISO 3166-1-alpha-2 code), for example, “US”.
topic

string

Google-provided topic trends are calculated for. Only top eight topics are returned. Topic is what shoppers are searching for on Google, grouped by the same concept.
date

object (Date)

Date the trend score was retrieved.
searchInterest

number

Daily search interest, normalized to the time and country to make comparisons easier, with 100 representing peak popularity (from 0 to 100) for the requested time period and location.
last7DaysSearchInterest

number

reports.search interest in the last 7 days, with the same normalization as searchInterest. This field is only present for a past date.
last30DaysSearchInterest

number

reports.search interest in the last 30 days, with the same normalization as searchInterest. This field is only present for a past date.
last90DaysSearchInterest

number

reports.search interest in the last 90 days, with the same normalization as searchInterest. This field is only present for a past date.
last120DaysSearchInterest

number

reports.search interest in the last 120 days, with the same normalization as searchInterest. This field is only present for a past date.
next7DaysSearchInterest

number

Estimated search interest in the next 7 days, with the same normalization as searchInterest. This field is only present for a future date.