oscmax local search report mod
Introduction
This module allows you track all of the keywords used to search you website. This can be helpful because it can give you an insight into what your customers actually need.
Installation
Step 1: Import rawseo_keyword_reports.sql into your oscommerce database.
Step 2: Upload everything in the admin directory to your oscommerce admin directory.
Step 3:
open advanced search results.php at around line 50:
add the following (make sure it is before }):
$keywordQuery = sprintf("INSERT INTO rawseo_keyword_reports (keyword,timestamp) VALUES('%s',now())",mysql_escape_string($keywords));
@mysql_query($keywordQuery);
Step 4: Open admin/index.php
at line 63:
right below it add the following:
Step 5:
In the admin interface, go to Administrator->file access->reports. Click the button that says “store files” and choose “rawseo_keyword_reports.php” from the list and the click “save”.
You should now see a new item under the reports section called “search reports”.
Download
All files for this module can be download here.
