Firefox/Projects/about:me

Overview

Sprint lead: dietrich
Sprinters: johnath, beltzner

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

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

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

Bugs

bug 480154