Most frequent search terms on Drupal.org to inform Drupal.org redesign
Amazon - June 30, 2008 - 18:37
| Project: | Drupal.org webmasters |
| Component: | Site organization |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Amazon |
| Status: | active |
Description
Part of the Drupal.org re-design involves the creation of a UX toolkit offering better search, and using the results of searches to inform the information architecture.
This page has existed for a while: http://drupal.org/search-queries in an unpublished state. The concern was that this is a very intensive query and traffic to this page would have a serious impact on performance. We now need a subset of this information to ensure that the most popular searched topics can be found easily. Can we modify this page so it uses a cache, or has less of a performance impact?
$result = db_query("select message, count(message) as count from watchdog where type = 'search' and uid = 0 group by message order by count desc limit 300");
print '<div class="column-left"><h2>Anonymous users</h2><ul>';
while ($s = db_fetch_object($result)) {
preg_match('!<em>(.*?)</em>!', $s->message, $matches);
print '<li>'. $matches[1] .' ('. $s->count .')</li>';
}
print '</ul></div>';
$result = db_query("select message, count(message) as count from watchdog where type = 'search' and uid != 0 group by message order by count desc limit 300");
print '<div class="column-right"><h2>Authenticated users</h2><ul>';
while ($s = db_fetch_object($result)) {
preg_match('!<em>(.*?)</em>!', $s->message, $matches);
print '<li>'. $matches[1] .' ('. $s->count .')</li>';
}
print '</ul></div>';
#1
Khalid added this code into the drupalorg module. Thank-you!
http://drupal.org/authenticated-search-queries
#2
Automatically closed -- issue fixed for two weeks with no activity.
#3
I'd like to add a link to the search results beside each term. Is there a way to see which terms get clicked on from the search results?
It would be helpful to have more insight into search results to inform our IA for the redesign.
Kieran
#4
I am not sure I can visualize what you need, nor how it would work. Google does that by tracking the onmousedown event, then triggering some javascript that registers the click.
However, you can already get the info you want for d.o from the Apache log. Just filter by the referer http://drupal.org/search/node/ and you know that it was clicked from the search page. A perl script can do that for sure.
#5
Add a link to search results, so that people can see what results are provide. Thanks for the tip about search the Apache logs.