Developers got their first glimpse at detailed statistics for their add-ons in early 2008 when we launched the Developer Statistics Dashboard for every add-on hosted on AMO. Since then, we’ve made incremental improvements to this tool, such as adding grouping and comparison options, data tables, locale usage stats, contributions, and most recently download sources.

In July, we asked developers to take a survey about how they use the Statistics Dashboard, and as part of our AMO rewrite currently underway, we’ll be revamping the dashboard.

Here’s a mockup from our designer, Chris Howse, of the overview page of the new dashboard:

A few comments on the new design:

We announced download source tracking for add-ons hosted on AMO in November, and since then have made a few improvements across the site. We reduced the number of unknown sources by half, from 22% to 11%, by scouring the site to find edge cases where tracking codes weren’t being applied. Now, every install button on the site should have a tracking code.

We’ve also added several new codes, such as on mozilla.com’s Firefox Customization page. It’s exciting to see that many add-ons have adopted the external source tracking feature to track downloads from their websites and marketing campaigns, and those downloads now make up 2% of the total.

Here’s an updated pie chart showing the source distribution of the 2.1 million downloads last Friday, the day after Firefox 3.6’s launch.

While I’m at work I pretty much always have a terminal window open with a MySQL prompt. Whether it’s helping someone troubleshoot an account problem, looking up stats, or gathering data for reports, I run a lot of queries throughout the day.

Oftentimes I want to make a chart with that data, which requires me switching database servers, looking up the MySQL CSV syntax on morgamic’s blog, and scp’ing the CSVs to my laptop.

I’ve grown tired of doing that, and tonight I finally did something about it: MySQL Output Converter

It’s a simple little page that lets you paste your MySQL results that look like this: