All project content is available for reading, but you need to be a member of the project for Subversion checkout of source code, or to create/modify any information.
Login if you are a member. Apply here to request membership (open to all).

Ticket #145 (new enhancement)

Opened 9 years ago

Last modified 8 years ago

Provide web search stats

Reported by: graham.moore@… Owned by: andyturl@…
Priority: major Component: EasySearch
Keywords: Cc:

Description (last modified by grenersen@…) (diff)

It would be useful to log and have an admin page for seeing most common search terms, search terms that provided no results, most used category for filtering, number of times a user clicked on a result within the first N, how many times people actually click on the second page of results.

I wonder if we can just use a specially formatted log4net appender for this?

I would rather avoid creating a new DB dependency as it removes the esay install aspects.

We could have a seperate lucene index for it as then editors / admins can search in it.

Change History

comment:1 Changed 9 years ago by grenersen@…

  • Description modified (diff)

I agree

comment:2 Changed 9 years ago by steve@…

The source:EPiCode.PerformanceLoggerModule uses a custom log4net appender for logging request information to a database. It works with SQLite and SQL Server (for bigger installations). Logging search words would not produce too much data, so SQLite would probably work well.

SQLite does not work with load balanced environments, but SQL Server does, so just run a db script and change the connectionstring.

Not sure about the need to search for search words though. Some of the stats I'd like to see:

  • Top 10 (all time)
  • Top 10 (last week)
  • Top <n> (custom timespan)
  • Candidates for synonyms (advanced stuff)
  • Searches with no (or few) results

To get really useful search statistics, some sort of click handling from the search result is needed (detecting that people actually find what they look for). This could also be used for a page plugin with information about search words that lead to the page. Perhaps for a later version though.

comment:3 Changed 8 years ago by grenersen@…

Is there any work being done on this? Together with synonyms and search suggestions this is a highly appreciated feature that could raise the overall impression. I would like to see a nice GUI and for CMS 6 a cool gadget in Site Center.

Note: See HelpUser/Tickets for help on using tickets.