Last month I posted a peek at Queen Bee, our internal unified billing, admin, and stats platform.

That post highlighted how we help our customers update their credit cards across multiple 37signals products.

Today I want to show off a bit of the stats side of Queen Bee. Now that we’ve centralized our billing, we can centralize our stats. We can get a better feel for signups, upgrades, downgrades, and cancellations across all our products.

At the top of our Queen Bee admin screen we have a stream showing the latest activity across Basecamp, Backpack, Highrise, and Campfire. It looks like this:

Note: The names and data listed are for example purposes only. These are not real customer names and this is not real data.

We use color to help us spot trends at a glance. Here’s how it works. BLUE is for a paying signup, GREEN is for an upgrade to a pay plan, PURPLE is for a downgrade, and RED is for a paying cancellation. We also use Yellow to highlight the plan name if the signup is for a paying plan.

If someone is signing up for a new plan, we also display the referrer. You’ll see that as “via…” near the end of the line. And if someone cancels we include the age of their account (“3 months old”).

Everyone at 37signals has access to this stream of signups, upgrades, downgrades, and cancellations. It’s a great way to get a feel for patterns, how things are going in general, and where people are finding out about our products.

We hope to show off more of Queen Bee down the road.