Firefox/Projects/about:me

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

• Intalled add-ons
• Usage patterns (how much do we know about this?)

Technical

General

• IP address
• Physical location
• Internet connection
• Network usage
• Plugins
• Cookies
• Current profile name

Memory usage

• Usage for different tabs/sites

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 )

Bugs

bug 480154