Evaluate your products

You can use the Merchant Reports API to view performance data, filter your products by specific attributes, and improve your pricing.

Measure performance

You can retrieve performance metrics for your account with the Merchant Reports API product_performance_view.

Requirements

To retrieve this report you will need to have the Performance and insights role.

To assign the Performance and insights role to an existing user, create a patch request and assign the PERFORMANCE_REPORTING access right to the user. The following request shows how you can create a patch request for assigning the PERFORMANCE_REPORTING access right:

PATCH https://merchantapi.googleapis.com/accounts/v1beta/accounts/{ACCOUNT_ID}/users/{EMAIL_ID}

{
  "accessRights": [
    "PERFORMANCE_REPORTING"
  ]
}

Replace the following:

• {ACCOUNT_ID}: The unique identifier of the Merchant Center account.
• {EMAIL_ID}: The email address of the user to whom you want to assign the role.

Sample query

The following query retrieves the impressions, clicks, and click_through_rate for all products in your account during a specific 30-day period. To make the request, pass the following Merchant Center Query Language statement to the accounts.reports.search method:

SELECT impressions, clicks, click_through_rate
FROM product_performance_view
WHERE date BETWEEN '2020-12-01' AND '2020-12-30'

For more information about performance reports, see the Performance reports guide.

Filter products

You can use the Merchant Reports API's product_view to show a filtered view of your product data, including product statuses. For example, you can query product_view to list products that have issues, or to get a list of your new products and verify serving.

You must include the id field in the SELECT clause of your query. The id has the same value as the product's REST ID.

You can filter based on all the available fields, except item_issues. You can sort the response based on all the available fields except the following:

• gtin
• item_issues

Here's an example that returns your products with the status NOT_ELIGIBLE_OR_DISAPPROVED. To make the request, pass the following Merchant Center Query Language statement to the accounts.reports.search method:

SELECT
  id,
  offer_id,
  feed_label,
  title,
  aggregated_reporting_context_status,
  item_issues
FROM product_view
WHERE aggregated_reporting_context_status = 'NOT_ELIGIBLE_OR_DISAPPROVED'

Here's a sample response from the preceding query:

{
  "results": [
    {
      "productView": {
        "id": "online~en~US~id0"
        "offerId": "id0",
        "feedLabel": "US",
        "aggregatedReportingContextStatus": "NOT_ELIGIBLE_OR_DISAPPROVED",
        "itemIssues": [
          {
            "type": {
              "code": "invalid_string_value",
              "canonicalAttribute": "n:product_code"
            },
            "severity": {
              "severityPerReportingContext": [
                {
                  "reportingContext": "SHOPPING_ADS",
                  "disapprovedCountries": [
                    "US"
                  ]
                },
                {
                  "reportingContext": "FREE_LISTINGS",
                  "disapprovedCountries": [
                    "US"
                  ]
                }
              ],
              "aggregatedSeverity": "DISAPPROVED"
            },
            "resolution": "MERCHANT_ACTION"
          },
          {
            "type": {
              "code": "apparel_missing_brand",
              "canonicalAttribute": "n:brand"
            },
            "severity": {
              "severityPerReportingContext": [
                {
                  "reportingContext": "SHOPPING_ADS",
                  "disapprovedCountries": [
                    "US"
                  ]
                }
              ],
              "aggregatedSeverity": "DEMOTED"
            },
            "resolution": "MERCHANT_ACTION"
          }
        ]
      }
    }
  ]
}

For more information about the fields available for query, see Fields in productView table.

Improve pricing

You can use the price insights view to see suggested sale prices for your products, and predictions for the performance that you can expect if you update your products' prices. Using the price insights report can help you price your products more effectively.

For more information, see Improve product pricing with the price insights report.

Query price_insights_product_view to view suggested sale prices for your products.

Here's a sample you can use to view suggested sales prices for your products. To make the request, pass the following Merchant Center Query Language statement to the accounts.reports.search method:

SELECT
  id,
  title,
  brand,
  price,
  suggested_price,
  predicted_impressions_change_fraction,
  predicted_clicks_change_fraction,
  predicted_conversion_change_fraction
FROM price_insights_product_view

Here's a sample response from the preceding query:

{
   "results": [
    {
      "priceInsightsProductView": {
        "id": "online~en~US~12345",
        "title": "UGG Women's s Classic Mini",
        "brand": "UGG",
        "price" {
          "amountMicros": "124990000",
          "currencyCode": "USD"
        },
        "suggestedPrice" {
          "amountMicros": "135680000",
          "currencyCode": "USD"
        },
        "predictedImpressionsChangeFraction": "0.12609300017356873",
        "predictedClicksChangeFraction": "0.508745014667511",
        "predictedConversionsChangeFraction": "2.3431060314178467"
      }
    },
    {
      "priceInsightsProductView": {
        "id": "online~en~US~12346",
        "title": "Nike React Infinity Run Flyknit 2",
        "brand": "Nike",
        "price" {
          "amountMicros": "119990000"
          "currencyCode": "USD"
        },
        "suggestedPrice" {
          "amountMicros": "125440000",
          "currencyCode": "USD"
        },
        "predictedImpressionsChangeFraction": "0.1799899935722351",
        "predictedClicksChangeFraction": "0.6203680038452148",
        "predictedConversionsChangeFraction": "1.234868049621582"
      }
    },
    {
      "priceInsightsProductView": {
        "id": "online~en~US~12347",
        "title": "  New Balance 327 White Trainers",
        "brand": "New Balance",
        "price" {
          "amountMicros": "84990000"
          "currencyCode": "USD"
        },
        "suggestedPrice" {
          "amountMicros": "82000000",
          "currencyCode": "USD"
        },
        "predictedImpressionsChangeFraction": "0.11538799852132797",
        "predictedClicksChangeFraction": "0.5869849920272827",
        "predictedConversionsChangeFraction": "1.3622850179672241"
      }
    }
  ]
}

For more information about the fields available for query, see Fields in priceInsightsProductView table.