SuiteCommerce Top Searches with No Results (Beta) Workbook

This topic applies to

Applies to

Commerce Web Stores

 

This workbook identifies the most frequently used shopper queries yielding zero search results. Additionally, the information provided in this workbook let's you discover what your shoppers are having trouble finding on your site as well as analyze exactly what language and terminology they are using to describe these products.

After identifying the search queries that returned zero results, merchandisers can take these actions:

  • Set up Search Synonyms to prevent shoppers from experiencing unsuccessful searches.

  • Adjust your item search settings as described in Search Settings Overview.

  • Update the product descriptions of related products to include the right keywords.

  • Add new products to your existing catalog.

From within the workbook you can view pivot tables that sort Search Queries with No Results 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 with No Results (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 with No Results (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 No Results

  • 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 with No Results workbook is equal to the number of sites configured in the account.

Note

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