Enterprise 2.0 2008 is going on now in Boston, and Oracle is a Diamond level sponsor. So, there are loads of Oracle people attending.
I got a request for Mix metrics on Friday for someone’s session today, so I spent several hours yesterday hacking together SQL queries. Protip: when you scope your next web app, plan for some reporting in advance and start tracking early.
I get asked for statistics all the time because numbers always lend credence to a story. This time I decided to put them into a usable form that I can reference the next time, instead of hacking around the database and dumping into an email. Hence, the protip.
Collecting web metrics is pretty straightforward; the package we use either collects data I want or it doesn’t. As with any web app, the tougher reports come out of the database. Getting data wasn’t that tough. Here are the highlights:
- More than 17,000 people have registered.
- Oracle employees represent about a third of the community.
- About 430,000 pageviews have been served in about 42,000 unique visits.
- People have created 460 groups, 76% of those are public groups.
- 1,081 ideas have been created, about 5 each day.
- People have submitted more than 140 OpenWorld session suggestions since May 2.
Mix has been live since November 11, 2007, averaging about 82 new registrants, 200 unique visits and 20,000 pageviews each day.
So, I entered all my stats into a Google Spreadsheet. I do increasingly more work in Google Docs because of the sharing and portability features. I usually don’t need the Office power user functions that people say Google Docs is lacking.
Ever since Paul pointed me to Hans Rosling’s TED talk from February 2006, which I highly recommend watching, I’ve been hoping to use the Motion Chart to graph stats. Google acquired Rosling’s Trendalyzer software in March 2007 and relaunced it as a Google Gadget you can embed in Spreadsheets back in March.
Unfortunately for me, my data aren’t complex enough for a Motion Chart. So, I muddled around with regular charts for way longer than I planned, and suffice to say that charts and graphs in Google Docs have a long way to go to catch up to Excel.
I’ll never get those hours back; Anyway, here’s what I whipped up in Excel. It’s not very snazzy, but it does show the upward trend since the Events team started promoting OpenWorld 2008.
The numbers on the X axis represent the months Mix has been live; I suppose I could have killed another hour or so figuring out how to label them correctly. Maybe next time.