User Search Data

We've rolled out some new functionality to the internal search system within the onlinesales database.

A new table has been created that will store various aspects of the search, including the search, the date & time, and the amount of results returned for products, galleries and brands.

DROP TABLE IF EXISTS searches_tbl;
CREATE TABLE searches_tbl (
id INT unsigned NOT NULL auto_increment,
search char(255) default NULL,
search_date DATETIME default NULL,
search_ip char(30) default NULL,
product_results INT unsigned default 0,
gallery_results INT unsigned default 0,
brand_results INT unsigned default 0,
PRIMARY KEY(id),
UNIQUE KEY id (id)
);

You'll shortly begin to see a series of new report functions within the admin section. These will report on various aspects including:

• Frequent searches (you can use that data to perhaps improve the navigation to get people to popular items)
• Searches with no results - See for market opportunity and to improve existing text and descriptions within your site