61
edits
Places/Stats: Difference between revisions
Ideas for improving the places queries logged
m (→Code) |
(Ideas for improving the places queries logged) |
||
| Line 44: | Line 44: | ||
livemarkers <- places[places$livemark_container_cnt > 0,] | livemarkers <- places[places$livemark_container_cnt > 0,] | ||
bookmarkers <- places[places$bookmark_cnt>20,] | bookmarkers <- places[places$bookmark_cnt>20,] | ||
== Improvements to Data Collection == | |||
* Add visit_type summation to capture usage of bookmarks and overall visitation patterns (link click, bookmark, etc) | |||
** select count(*) as N, visit_type from moz_historyvisits group by visit_type | |||