VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Customization
 SEARCH REPORT for Keyword in Admin
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Waternsports
Starting Member

8 Posts

Posted - January 14 2006 :  22:15:25  Show Profile  Reply with Quote
Has any one got a Keyword report that will give you how many people searched for the same item listed by a date range and alpahbetical order.
The current reports really is not that helpful for future product purchasing. A report by the most popular keywords would help you decide if you need to start selling other brands, models, etc. In Example you may be displaying Products A B C, and the customer is looking for D E F . and More are looking for Product F. which means you need to get product F in your store.


Any feed back would be appreciated.

devshb
Senior Member

United Kingdom
1898 Posts

Posted - January 15 2006 :  19:02:29  Show Profile  Visit devshb's Homepage  Reply with Quote
If you set the config option:
xsearchcapture

to yes then it'll record all your searches, and you can then view them on the admin menu's "Search Report" menu. Having looked at that menu, it seems that you can get a count of searches (summary) or details of all searches (details), but there doesn't seem to be a "summary by keyword" which I think is what you're after.

To do that, go into advanced query in the admin menu, and enter this query text:

select words,categories,subcategories,count(*) as search_count from searchresults group by words,categories,subcategories order by count(*) desc

that'll show your results in popularity order.

to show by alphabetical order, try:

select words,categories,subcategories,count(*) as search_count from searchresults group by words,categories,subcategories order by words,count(*) desc

and to show a particular month, try:

select words,categories,subcategories,count(*) as search_count from searchresults where year(rdate)=2006 and month(rdate)=1 group by words,categories,subcategories order by words,count(*) desc


Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons

Edited by - devshb on January 15 2006 19:17:41
Go to Top of Page

Waternsports
Starting Member

8 Posts

Posted - January 15 2006 :  21:37:36  Show Profile  Reply with Quote
The first query was what I was looking for, It tells you a lot.

Simon thank you very much for the help & feed back.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000