SuiteCommerce Top Searches (Beta) Workbook

This topic applies to

Applies to

Commerce Web Stores | SuiteCommerce InStore


This workbook displays the top search queries your shoppers used to find products on your website. You can not only find the popular products that shoppers search for on your website, but also analyze the language and the terminologies that your shoppers use to describe the products they are searching for.

After identifying the popular search queries, merchandisers can take these actions to entice shoppers to purchase the products:

  • Apply promotions to the most searched products.

  • Position popular related products on the home page.

  • Boost popular products higher in the Search Results.

From within the workbook you can view pivot tables that sort Search Queries by Number of Searches in descending order. By default, a pivot table is created for each site configured in your account. To access the workbook, click the SuiteCommerce Top Searches (Beta) link from the Standard Workbooks list on the Workbook Listing Page. Click any site name tab and then click the refresh icon to load the data for that website.

Workbook Configuration

The source data used in the SuiteCommerce Top Searches (Beta) workbook combines fields from two record types and multiple criteria filters. Depending on the number of sites configured in your account, the workbook also includes predefined pivot tables for each site. You can edit each of these components on the corresponding tab of the workbook user interface. For more information, see the help topic Defining Workbook Source Data.

Root Record Type

Joined Record Type(s)

Custom Formula Field(s)

Data Grid

Criteria Filters

Pivot Tables and Charts

Commerce Search Activity Data

Web Site

Not Applicable

The following record fields are included in the workbook source data:

  • Web Site – The website where the search was recorded.

  • Search Query – The query used by the shopper to find items on your website.

  • Date – Start date and time of the period to which the Search Query relates.

  • Time Period – Length of the aggregation period to which the Search Query relates.

  • Position – The position of the Search Query in the set of aggregated results in the specified Time Period.

  • Number of Searches – The total number of searches performed by all the shopper for this Search Query in the specified Time Period.

The following criteria is used by default to filter the workbook source data:

  • Metric is Search Query

  • Start Time is 2 days ago

For each site configured in your NetSuite account, a pivot table is created by default. Therefore, the number of pivot tables predefined in the Top Searches workbook is equal to the number of sites configured in the account.


The name of the pivot table is same as the name of the site configured in your account.