61
edits
User talk:Andyed: Difference between revisions
Jump to navigation
Jump to search
Search Volume query & link to about:search
(Search Volume query & link to about:search) |
|||
| Line 3: | Line 3: | ||
Extracting searches and the resulting visits is not possible currently with he Places API but is achievable with raw SQL. I've noted in the [https://wiki.mozilla.org/Firefox/Sprints/about:me about:me] page that search efficacy might be an interesting thing to display, though perhaps search volume is more casually interesting. | Extracting searches and the resulting visits is not possible currently with he Places API but is achievable with raw SQL. I've noted in the [https://wiki.mozilla.org/Firefox/Sprints/about:me about:me] page that search efficacy might be an interesting thing to display, though perhaps search volume is more casually interesting. | ||
== Search Volume == | |||
Adapted from about:me | |||
SELECT rev_host as rev_host, SUM(visit_count) as visits | |||
FROM moz_places WHERE url like '%q=%' GROUP BY rev_host | |||
ORDER BY SUM(visit_count) DESC LIMIT 10 | |||
Install about:search at http://surfmind.com/lab/mozilla/aboutsearch/aboutsearch_021.xpi | |||
== Search Efficacy Metrics == | == Search Efficacy Metrics == | ||