Waternsports
Starting Member
8 Posts |
Posted - January 14 2006 : 22:15:25
|
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
1904 Posts |
Posted - January 15 2006 : 19:02:29
|
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 |
|
|