Request a search insights SQR report

Use this endpoint to request and download the search insights search query (SQR) report. This report provides query-level insights that show how customers interact with your items in search results, such as including search terms used, product impressions share, click share, and add-to-cart share.

The SQR report is available in two time-based formats:

Monthly — Aggregated by calendar month.
Weekly — Aggregated by ISO week number.

Data availability:

Weekly data for the previous week is available Tuesday by 8 PM PST.
Monthly data for the previous month is available on the second day of the current month by 8 PM PST.

You can use the FREQUENCY INTERVAL filter to request either version. For more context, see the Search Query Report article on Marketplace Learn.

Note: This example includes only the mandatory fields for a basic report request. All other filters are optional. For advanced filtering options, see the On-request Reports API reference.

Endpoint

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

Sample request – Monthly SQR

curl -X POST "https://marketplace.walmartapis.com/v3/reports/reportRequests?reportType=SEARCH_INSIGHTS_SQR_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": "FREQUENCY INTERVAL", "type": "enumFilter", "values": ["MONTHLY"] }, { "columnName": "YEAR", "type": "multiValueFilter", "values": ["2025"] }, { "columnName": "MONTH", "type": "enumFilter", "values": ["January"] } ], "excludeColumns": [] }'

Sample request – Weekly SQR

curl -X POST "https://marketplace.walmartapis.com/v3/reports/reportRequests?reportType=SEARCH_INSIGHTS_SQR_REPORT&reportVersion=v1" \ -H "Authorization: Basic <Base64EncodedConsumerKey:ConsumerSecret>" \ -H "WM_SVC.NAME: Walmart Marketplace" \ -H "WM_QOS.CORRELATION_ID: 1234567890" \ -H "Accept: application/json" \ -H "Content-Type: application/json" \ -d '{ "rowFilters": [ { "columnName": "FREQUENCY INTERVAL", "type": "enumFilter", "values": ["WEEKLY"] }, { "columnName": "YEAR", "type": "multiValueFilter", "values": ["2025"] }, { "columnName": "WEEK", "type": "enumFilter", "values": ["1"] } ], "excludeColumns": [] }'

Request field descriptions

Field	Type	Description	Mandatory
`FREQUENCY INTERVAL`	`enumFilter`	Frequency of the report. Accepts `MONTHLY` or `WEEKLY`.	Yes
`YEAR`	`multiValueFilter`	Calendar year for which the report is generated (such as `"2025"`).	Yes
`MONTH`	`enumFilter`	Month of the year for `MONTHLY` reports. Accepts only one value (such as `"January"`).	Yes, if `FREQUENCY INTERVAL` is `MONTHLY`
`WEEK`	`enumFilter`	ISO week number for `WEEKLY` reports. Accepts only one value (such as `"1"`).	Yes, if `FREQUENCY INTERVAL` is `WEEKLY`
`SKU`	`multiValueFilter`	Optional filter to scope results to specific SKUs (up to 100).	No
`HIGHLY CLICKED`	`enumFilter`	Filters queries with high click-through rates. Accepts `true` or `false`.	No
`HIGHLY ATC`	`enumFilter`	Filters queries frequently resulting in add-to-cart actions. Accepts `true` or `false`.	No
`TRENDING`	`enumFilter`	Filters queries with a recent surge in search volume. Accepts `true` or `false`.	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.
Choose MONTHLY or WEEKLY for the FREQUENCY INTERVAL filter.
Only include one value for MONTH or WEEK.
Add optional filters such as SKU or TRENDING to refine the results.

Sample response

{ "page": 0, "totalCount": 1, "limit": 10, "nextCursor": null, "requests": [ { "requestId": "abc12345-def6-7890-ghij-klmnopqrstuv", "requestStatus": "READY", "requestSubmissionDate": "2025-04-18T12:00:00Z", "reportType": "SEARCH_INSIGHTS_SQR_REPORT", "reportVersion": "v1", "payload": { "rowFilters": [ { "columnName": "FREQUENCY INTERVAL", "type": "enumFilter", "values": ["MONTHLY"] }, { "columnName": "YEAR", "type": "multiValueFilter", "values": ["2025"] }, { "columnName": "MONTH", "type": "enumFilter", "values": ["January"] } ], "excludeColumns": [] }, "reportGenerationDate": "2025-04-18T12:05:00Z", "downloadUrl": "https://marketplace.walmartapis.com/downloads/reports/search-insights/sqr-monthly-report.csv" } ]
}

Result

When requestStatus is READY, download the CSV from the downloadUrl. The report includes query-level insights for each SKU within the selected timeframe.

Response field descriptions

Field	Description	Origin
SKU	An alphanumeric ID provided by the seller that identifies the item.	Seller
Query	Search term that led customers to this item on Walmart.com.	Walmart
Query Score	Rank based on traffic and sales from the query. Highlights top-performing queries for this item.	Walmart
Frequency Rank	Global popularity of the query across Walmart.com. Lower rank means higher search frequency.	Walmart
# of Competing Products	Number of items shown in results when the query was searched.	Walmart
Impressions Share	Percentage of total impressions for the query that were for this item.	Walmart
Clicks Share	Percentage of total clicks for the query that were for this item.	Walmart
Added to Cart Share	Percentage of add-to-cart actions after the query that were for this item.	Walmart
#1 Clicked Product URL	Walmart.com URL of the most-clicked item.	Walmart
Highly Clicked	Indicates queries with high click-through rates after a customer search.	Walmart
Highly Atc	Indicates items most likely to be added to cart after customer search.	Walmart
Trending	Indicates queries with a recent surge in search volume.	Walmart
Frequency Interval	Time grouping of the report (`MONTHLY` or `WEEKLY`).	Walmart
Year	Calendar year of the report period.	Walmart
Month	Month of the report period (for `MONTHLY` reports).	Walmart
Week	ISO week number of the report period (for `WEEKLY` reports).	Walmart

Note: Report data is static once generated for a specific week or month. Downloading the same report multiple times will return identical data unless the report is regenerated. 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.