Request a search insights performance report

Use this endpoint to request and retrieve the search insights performance report. This report provides item-level search performance metrics such as impressions rank, clicks rank, add-to-cart rank, sales rank, transactability score, buy box win percentage, and keyword recommendations.

These insights help sellers improve discoverability and optimize underperforming SKUs. For more information on the Search Insights Performance report, see the Search Insights dashboard on Marketplace Learn.

Data availability: Data for the previous week is available Wednesday by 7 AM PST.

You request the report using a POST call with filter parameters. When the report status is READY, the response will include a downloadUrl to download the CSV file.

Note: This example includes optional filters to demonstrate a typical report request. All parameters for this report are optional. For additional use cases, refer to the On-request Reports API reference.

Endpoint

To initiate the request and check report status, call the following endpoint using the reportType and reportVersion query parameters. When the report is ready, the response will include a link to a downloadable file.

GET https://marketplace.walmartapis.com/v3/reports/reportRequests?reportType=SEARCH_INSIGHTS_PERF_REPORT&reportVersion=v1

Sample request

This example requests a Search Insights Performance report for two SKUs, filtered by product type and the presence of keyword recommendations and sales rank.

curl -X POST "https://marketplace.walmartapis.com/v3/reports/reportRequests?reportType=SEARCH_INSIGHTS_PERF_REPORT&reportVersion=v1" \ -H 'WM_SEC.ACCESS_TOKEN: eyJraWQiOiIzZjVhYTFmNS1hYWE5LTQzM.....' \ -H 'WM_QOS.CORRELATION_ID: b3261d2d-028a-4ef7-8602-633c23200af6' \ -H 'WM_SVC.NAME: Walmart Marketplace' \ -H 'Accept: application/json' \ -H 'Content-Type: application/json' \ -d '{ "rowFilters": [ { "columnName": "SKU", "type": "multiValueFilter", "values": ["sku1", "sku2"] }, { "columnName": "PRODUCT TYPE", "type": "multiValueFilter", "values": ["ATV Accessories"] }, { "columnName": "RECOMMENDATIONS EXISTS", "type": "enumFilter", "values": ["true"] }, { "columnName": "SALES RANK EXISTS", "type": "enumFilter", "values": ["true"] } ], "excludeColumns": [] }'

Request field descriptions

Filter FieldTypeDescriptionMandatory
SKUmultiValueFilterA unique alphanumeric ID assigned by the seller to identify each item. You can include up to 100 SKUs in a single request.No
PRODUCT TYPEmultiValueFilterFilters items by product category (such as "ATV Accessories").No
RECOMMENDATIONS EXISTSenumFilterReturns items that have (or do not have) keyword recommendations. Accepts true or false strings.No
SALES RANK EXISTSenumFilter

Returns items that have a sales rank if values is true or items that don't have a sales rank if values is false.

values accepts true or false strings.

No

Modify your code

  • Use a unique WM_QOS.CORRELATION_ID for each request.
  • Replace WM_SEC.ACCESS_TOKEN with your valid access token obtained through authentication.
  • Replace sku1 and sku2 with your own SKUs.
  • Update PRODUCT TYPE to match your catalog’s category.
  • Set true to false if you only want products that don’t have keyword or sales rank data.

Sample response

{ "page": 0, "totalCount": 1, "limit": 10, "nextCursor": null, "requests": [ { "requestId": "d7a5e7c3-1234-4b9f-a6e9-5678f9e3b1ab", "requestStatus": "READY", "requestSubmissionDate": "2025-04-18T10:15:30Z", "reportType": "SEARCH_INSIGHTS_PERF_REPORT", "reportVersion": "v1", "payload": { "rowFilters": [ { "columnName": "SKU", "type": "multiValueFilter", "values": ["sku1", "sku2"] }, { "columnName": "PRODUCT TYPE", "type": "multiValueFilter", "values": ["ATV Accessories"] }, { "columnName": "RECOMMENDATIONS EXISTS", "type": "enumFilter", "values": ["true"] }, { "columnName": "SALES RANK EXISTS", "type": "enumFilter", "values": ["true"] } ], "excludeColumns": [], "dataStartTime": "2025-03-01T00:00:00Z", "dataEndTime": "2025-03-31T23:59:59Z" }, "reportGenerationDate": "2025-04-18T10:16:42Z", "downloadUrl": "https://marketplace.walmartapis.com/downloads/reports/search-insights/performance-report.csv" } ]
}

Result

Once the report's requestStatus is READY, download the CSV using the downloadUrl. The file contains the following fields:

Response field descriptions

FieldDescriptionOrigin
Item IDWalmart-assigned numeric identifier for the item.Walmart
SKUSeller-defined unique item identifier.Seller
ConditionCondition of the item (e.g. New, Pre-Owned).Seller
Item NameName of the item as listed on Walmart.com.Seller
Item Page UrlURL to the item’s product detail page on Walmart.com.Walmart
Product TypeCategory or classification of the item.Walmart
Impressions RankRank based on the number of times the item appeared in organic search results. Lower = better.Walmart
Clicks RankRank based on how often users clicked the item in search results. Lower = better.Walmart
Added to Cart RankRank based on how often the item was added to cart from search results. Lower = better.Walmart
Sales RankRank based on orders in the past 6 months. Requires at least one order in the last six months. Lower = better.Walmart
Transactability ScorePercentage of time the item was in stock over the past 7 days.Walmart
Buy Box Win %Percentage of eligible search views in which this item won the buy box over the past 7 days.Walmart
Recommended Keywords for immediate actionSuggested keywords to improve search visibility.Walmart
Recommendations ExistsIndicates whether keyword recommendations are available for the item.Walmart
Sales Rank ExistsIndicates whether sales rank is available based on recent order data.Walmart

>

Note: Report data is static once generated for a given week. Re-downloading the same report will return identical data unless the report was regenerated due to a submission change. Avoid repeated downloads for unchanged data.

Walmart Confidential Data Disclosure for Channel Partners

By utilizing the API connection provided by Walmart and accessing the seller data derived therefrom, you, as a Channel Partner, hereby acknowledge and agree to the following:

All data accessed through this API connection, including but not limited to seller data, is considered Walmart Confidential Data. Walmart Confidential Data is proprietary and confidential to Walmart Inc. and its affiliates, as governed by the Walmart Marketplace Solution Provider Affiliate Agreement, the Walmart API Licensing Agreement.

You are strictly prohibited from commingling Walmart Confidential Data with your own data or creating a separate list or independent work product from it. The use of Walmart Confidential Data is limited solely to providing the Walmart Seller, from whom the data is derived, with insights pertaining to their Walmart business.

Furthermore, Channel Partners should not commingle individual seller's data or aggregate seller data to create any product, service, or solution that is intended to be sold back to sellers, or any third party, directly or indirectly. Your adherence to these provisions is crucial in maintaining the trust and privacy of our sellers and the integrity of our data. Any violation of this disclosure may lead to termination of your partnership with Walmart and potential legal action. By continuing with the use of this API connection, you are explicitly agreeing to these terms. Please ensure you understand these conditions in their entirety.