Overview
Sprint lead: dietrich
Sprinters: johnath, beltzner, margaret
- Description
- A statistical analysis of the user's history, average tab load, etc. Like Google Zeitgeist, but based on their Places database.
- Dietrich has an add-on that does some of this already. screenshot
Prototype
The latest prototype is available as an add-on, which you can download here: https://services.forerunnerdesigns.com/extensions/get/aboutme@test.mozilla.com/0.2/.
Goals / Use Cases
- Reflective personalization: Showing users the broader patterns in their interactions with the web, thereby creating a tighter personal bond with it.
- Debugging: testers can use this page to gauge their web usage, and the amount of metadata generated by it, for feedback on bugs and feature usage.
Non Goals
- Drill-down or query-ability of the data past the basic display on the page
- Remote aggregation and analysis of this data
Brainstorming
Many of these points are mentioned below, but in a less organized fashion.
Fun
- Activity stats
- Hourly/daily/monthly trends
- Top sites visited
- Total usage over time
- Average time on a page
- How you get to pages (bookmark, link, etc)
- Novelty of Browsing (% first visits)
- Tab stats
- Lifetime
- Frequency visited
- Average number of tabs open
- Information about current tabs
- Bookmark stats
- Top used bookmarks
- Tag cloud for bookmark tags
- Hourly/daily/monthly trends
- Extensions
Technical
- IP address
- Physical location
- Internet connection
- Network usage
- Plugins
- Memory usage
- Usage for different tabs/sites
- Cookies
- Download stats
- Number of downloads
- Hourly/daily/monthly trends
Implementations of Similar Things
- Google Zeitgeist
- Google Reader Stats
- Google Web Activity Stats
- Flickr Stats
- Chrome about:stats
Design
potential sections & datapoints:
History & Bookmarks
- number of history visits
SELECT COUNT(1) FROM moz_historyvisits WHERE visit_type NOT IN (0, 4)
- number of unique URLs
SELECT COUNT(1) FROM moz_places WHERE hidden <> 1
- fav sites (top 5-10, total visits, avg visits per day)
total visits
SELECT * FROM moz_places ORDER BY visit_count LIMIT 10
avg visits per day
- day of week stats (eg: "sat broader, sun has more revisits")
would need total visits (sunday is 0)
SELECT COUNT(1)
FROM moz_historyvisits
WHERE visit_type NOT IN (0, 4)
GROUP BY strftime('%w', ROUND(visit_date / 1000000))
number of unique URLs for each day of the week (sunday is 0)
- I don't think it is possible to construct a query for this
- graph of history volume over time (visits per week since start of history accumulation)
- total browsing uptime (via history, maybe goes in App)
- % of the Web visited (out of 1,000,000,000,000 pages)
- url and date of oldest visit
- top URLs most selected from the awesomebar
- number of bookmarks
SELECT COUNT(1) FROM moz_bookmarks WHERE parent <> :tag_root AND parent <> :places_root
- url and date of oldest bookmark (oldest by what?)
- graph of bookmark activity over time
- number of tags
SELECT COUNT(1) FROM moz_bookmarks WHERE parent = :tag_root
- revisitation
- average or median visits per URL
- percentage of visits that are bookmarked or tagged pages
Downloads
- total bytes downloaded
SELECT SUM(currBytes) FROM moz_downloads
- number of saved passwords
- degree of variation between saved passwords
- number of downloads
SELECT COUNT(1) FROM moz_downloads
- date of first download
SELECT startTime FROM moz_downloads ORDER BY id ASC LIMIT 1
- average download size
SELECT AVERAGE(maxBytes) FROM moz_downloads WHERE maxBytes <> -1
- graph of download activity over time
Other
- avg num open tabs
- current tab load
- average tab load since XXX
- avg startup time
- number of cookies
- entries and total bytes of cache (or link to about:cache)
- number of extensions installed
- number of plugins installed (or link to about:plugins)
- IP address
- user's physical location
- search efficacy (original blog improved sql )