Top Search Trends

Use the Insights API to generate a daily Top Search Trends report that will allow your advertisers to gather competitive intelligence and insights into top organic search trends across Walmart.com/app and the 3 top selling items (including variant items) associated with each high performing keyword. This will help advertisers make informed decisions while optimizing campaign performance. 

The processing time range for an Insights report request is under 5 mins.

Note:

• The latest top search trends report is generated daily after 4pm PST
• The report is advertiser agnostic
• With variant bidding launch, the top search trends report will also include variant items in the top 3 selling items

 

Description: You can download Top Search Trends report using insight download link with help of this API

URL: ​GET/api/v1/insights

Query Parameters

Parameter	Description	type	Required	Possible Values
insightsType	The type of insight	string	Y	searchTrends
format	Format of the downloadable file	string	Y	zip, gzip

Headers

Header Name	Description	Required	Values
Authorization	The token will provide you the access to the API. It is same for all advertisers you access through the API.	Y	Please utilize the generated auth_token shared with you at the time of partner onboarding from the Getting Started Guide
WM_CONSUMER.ID	We will provide you the consumer ID to access the API. It is same for all advertisers you access through the API.	Y	Please use the generated ConsumerId shared with you at the time of partner onboarding. Refer to the Getting Started Guide for further explanation on this
WM_SEC.AUTH_SIGNATURE	Auth signature as an API key	Y	Use the signature generator code from Getting Started Guide to generate this value
WM_SEC.KEY_VERSION	We will provide you with the KEY VERSION to access the API. It is same for all advertisers you access through the API	Y	1
WM_CONSUMER.intimestamp	Timestamp for which the auth signature is generated. Use Unix epoch format for the timestamp	Y	Use the signature generator code (Getting Started Guide) to generate this value

Sample Request

curl -X GET \
'https://developer.api.stg.walmart.com/api-proxy/service/WPA/Api/v1/api/v1/insights?insightsType=searchTrends&format=zip' \
--header 'Authorization: Bearer <auth_token>' \ 
--header 'accept: application/json' \
--header 'WM_SEC.AUTH_SIGNATURE: ***********' \
--header 'WM_CONSUMER.ID: adfwe-v23-faasd2r-afs-asdfqeff' \
--header 'WM_CONSUMER.intimestamp: 1565309779' \

Response

Element	Description	Type
download	Get the link to download Top Search Trends Report	string

Sample Response

[
    { "download": https://advertising.walmart.com/qa/file/55 }
]

The downloadable Top Search Trends Report (CSV) file will have the following columns:

• reportDate
• searchKeyword
• searchKeywordFrequencyRank
• item1Id
• item1Name
• item1BrandName
• item1ClickShare
• item1ConversionShare
• item2Id
• item2Name
• item2BrandName
• item2ClickShare
• item2ConversionShare
• item3Id
• item3Name
• item3BrandName
• item3ClickShare
• item3ConversionShare

Column	Description	Type
reportDate	The cut-off date till when the report was generated. e.g., If the report were requested today, the cut-off date of the report would be yesterday. Hence, the reportDate would be yesterday.	date
searchKeyword	Most popular search keywords that shoppers are searching for to find items on Walmart.com/app	string
searchKeywordFrequencyRank	Numeric ranking for a search keyword based on total number of times this keyword was searched on Walmart.com/app by shoppers for a given time period.	integer
item1Id	Item ID for the no. 1 selling item for the search keyword. *With variant bidding launch, this will also include variant items	string
item1Name	Item name for the no. 1 selling item for the search keyword.	string
item1BrandName	Brand name for the no. 1 selling item for the search keyword	string
item1ClickShare	Share of the clicks that this item received for the given keyword.    Click share is a percentage determined by the number of times shoppers clicked on no. 1 selling item when searched for a given search keyword, divided by the total number of times shoppers clicked on any item when searched for the same search keyword	double
item1ConversionShare	Share of the orders that this item received for the given keyword.    Conversion share is a percentage determined by the number of times shoppers purchased (ordered) no. 1 selling item when searched for a given search keyword, divided by the total number of times shoppers purchased (ordered) any item when searched for the same search keyword	double
item2Id	Item ID for the no. 2 selling item for the search keyword   *With variant bidding launch, this will also include variant items	string
item2Name	Item name for the no. 2 selling item for the search keyword	string
item2BrandName	Brand name for the no. 2 selling item for the search keyword	string
item2ClickShare	Share of the clicks that this item received for the given keyword Click share is a percentage determined by the number of times shoppers clicked on no. 2 selling item when searched for a given search keyword, divided by the total number of times shoppers clicked on any item when searched for the same search keyword	double
item2ConversionShare	Share of the orders that this item received for the given keyword Conversion share is a percentage determined by the number of times shoppers purchased (ordered) no. 2 selling item when searched for a given search keyword, divided by the total number of times shoppers purchased (ordered) any item when searched for the same search keyword	double
item3Id	Item ID for the no. 3 selling item for the search keyword	string
item3Name	Item name for the no. 3 selling item for the search keyword *With variant bidding launch, this will also include variant items	string
item3BrandName	Brand name for the no. 3 selling item for the search keyword	string
item3ClickShare	Share of the clicks that this item received for the given keyword   Click share is a percentage determined by the number of times shoppers clicked on no. 3 selling item when searched for a given search keyword, divided by the total number of times shoppers clicked on any item when searched for the same search keyword.	double
item3ConversionShare	Share of the orders that this item received for the given keyword Conversion share is a percentage determined by the number of times shoppers purchased (ordered) no. 3 selling item when searched for a given search keyword, divided by the total number of times shoppers purchased (ordered) any item when searched for the same search keyword.	double

Once the report is generated, what specific actions can be taken to optimize existing campaigns and increase the likelihood of Sponsored Impressions? 

Keywords 

• Add the top search keywords to existing campaigns or create new campaigns to maximize performance.
• Optimize bids on top search keywords in existing campaigns to improve Ad performance and increase the likelihood of a Sponsored impressions.

Items 

• Use the report to look up specific Search Keywords that are driving Walmart shoppers to click on your own items or competitors’ items and add your top-selling items to new or existing campaigns.
• Optimize bids on top selling items in existing campaigns to improve ad performance and increase the likelihood of Sponsored impressions.

Competitive Insights 

• Use this report to gain insights into competitor standing: 
• Are your items ranking higher than your competitors’ items? 
• Gain insights into the rank of the keywords that you are using and compare them to the keywords that your competitors are using.
• Extract information about the brands associated with the items that are ranked top three for a given Search Keyword.
• Monitor the performance of your items compared to those of your competitors. Are your items maintaining their standing, falling, or rising in ranks? 

Q. How often is the Top Search Trends Report generated? 

A. The report is generated daily and contains 7 days’ worth of rolling aggregate data. 

Q. On what bases are these search keywords ranked? 

A. Search keywords are ranked based on number of searches, aggregated for a given time period (rolling 7 days). 

Q. How are the top items ranked? 

A. The items are ranked based on a decreasing order of organic units sold. 

Q. Does the Top Search Trends report include variant items? 

A. With variant bidding launch, the Top Search Trends report will also include variant items.

Q. Does the Top Search Trends report include Raw keywords Or Normalized keyword? 

A. Top Search Trends Report includes raw keywords searched by the shoppers.   

Q. What is the maximum number of row records in the Top Search Trends Report? 

A. The maximum threshold for number of rows in the Top Search Trends Report is 300K.

Q. Can there be scenarios with no selling items (1, 2, 3) for a given search keyword? 

A. For a given period when the top searched keyword(s) does not have associated selling item(s) then the corresponding item attribute columns will empty fields in the report. 

Q. Does search keywords listed in the Top Search Trends Report also include Sponsored Keywords? 

A. Yes. The search keywords in the Top Search Reports are organic search keywords searched by shoppers on Walmart.com and app. This means that both sponsored, and non-sponsored shopper search keywords are part of the report. 

Q. Does search keywords listed in the Top Search Trends Report also include Non-Sponsored Search Keywords? 

A. Yes. The search keywords in the Top Search Reports are organic search keywords searched by shoppers on Walmart.com and app. This means that both sponsored, and non-sponsored shopper search keywords are part of the report. 

Q. Does the daily report differ across advertisers? 

A. The report is advertiser agnostic, meaning that all Partners receive the same report daily. 

Q. How is click share defined for top selling items? 

A. Click share is a percentage determined by the number of times shoppers clicked on an item when searched for a given search keyword, divided by the total number of times shoppers clicked on any item when searched for the same search keyword. 

Q. How is conversion share defined for top selling items? 

A. Conversion share is a percentage determined by the number of times shoppers purchased (ordered) an item when searched for a given search keyword, divided by the total number of times shoppers purchased (ordered) any item when searched for the same search keyword. 

Q. Can the click share be greater than no. 1 top selling item for no. 2 and no.3 selling items? 

A. Yes. The click share for no. 2 and/or no. 3 selling item can be greater than no. 1 selling item. This can happen as the number of clicks an item does not correspond to units sold (quantity). 

Please note that the top 3 selling items are ranked based on decreasing order of organic units sold. 

Q. Can the conversion share be greater than no. 1 top selling item? 

A. Yes. The conversion share for no. 2 and/or no.3 selling item can be greater than no. 1 selling item. This can happen as the number of orders for an item are not directly proportional to units sold (quantity). 

Please note that the top 3 selling items are ranked based on decreasing order of organic units sold. 

Q. Can the conversion share be greater than click share for an item? 

A. The conversion share can be greater than click share for an item. Please refer definitions of Click share and Conversion share for more details. 

There is a rate limit in place on the allowed number of API operations per hour.

Operations per hour are computed as the sum of number of changes requested across all API requests during the hour.

For example, 5 keyword bid changes, creation of an ad group, adding an item, and a snapshot report request in any given hour, would be counted as 8 operations.

You will receive an HTTP 429 status error code and an error message about rule enforced in case of breaking ops limit.

To learn more about current applicable limits specific to your integration, please reach out to the API Partner Enablement team.