Fun with Numbers, Mix Edition

By Jake • March 7th, 2008 • View Comments

numbers.pngStill feeling gravity’s pull lately, and Rich and Anthony gave me access to the Mix database this week. So, rather than review some new service (like Orgoo, for which I just got my beta invite) or wax philosophically about a New Web topic, I figured I’d dust off the SQL and crunch some numbers.

Side note: I’m wondering if anyone else has the following problem. You read about some new beta service that sounds pretty sweet. You sign up and wait. Then, months later, you get an invite, but can’t for the life of you remember what that service does or why you thought it was sweet.

I have that problem. It happened this week with Orgoo, previously with Spock, Scrybe, Bungee Labs and others. Note to startups: if you seek or get coverage from TechCrunch or ReadWriteWeb or Mashable or any other New Web outlet, open your beta round to everyone asking for an invite. Nothing kills the buzz like getting on the waiting list for some app and waiting.

Anyway, I’ve been working with several internal teams that are using Mix for groups. You’ll be seeing a lot more teams at Oracle using Mix in the coming months. Inevitably, questions about the Mix demographic arise like how many users are there, what percentage customers, etc. So, rather than continue to nag Rich and Anthony with these queries, I decided to do some actual work myself.

After getting the connection information and updating my old friend tnsnames.ora, I upgraded SQL Developer and got started. FYI, SQL Developer is an awesome tool, and I endorse it. Yes, my SQL skills are rusty, so what follows represents the low-hanging fruit.

Users

Since I ran these numbers this morning, we’ve had 27 new people join Mix. Not bad.

Groups

Miscellaneous

I would provide traffic numbers too, but we just switched over to new web analytics package. As of last week, we had more than 144,000 visits, averaging between 8,000-10,000 visits each week.

Want to see any other metrics? Let me know in comments, keeping in mind that I may give up if it’s too hard to write the SQL. And no, we’re not playing stump Jake with SQL queries.

In other Mix news, Rich and Anthony are deploying a bunch of changes soon, so stay tuned.


Possibly Related Posts

  • Jake
    @Ian: Happy to send one your way, but after checking, I don't think they gave me any invites. Must still be in private beta. If they go into public beta and I get some invites, I'll send you one.
  • Ian
    Speaking of Orgoo... what's the likelihood of you parting with one of those invites? If you have one I'd really appreciate it, thanks a million!

    AETrailblazer at gmail dot com
  • Jake
    @Venkataramanan S: I wouldn't know how to begin calculating that even for a small population like Mix. Do you know of any existing packages we could use as a starting point?
  • You don't have large data, but how about doing something like Six Degrees of Separation (http://en.wikipedia.org/wiki/Six_degrees_of_sep...)
  • Jake
    @Shishir: Demographic data will be in the web analytics package. I'll check the db tables, too, but I don't think we store any country info.

    I'll see if I can hack out the other metrics you mention.
  • - How about some demographic data ? (not sure if location information is available in mix db..)

    - No. of ideas with at least 1 comment or more than '2 want it' votes ? (2 according to me is an optimum no. for deciding if the idea has potential)

    - Most popular tags ? (couldn't find the tag cloud on mix)

    -Shishir
  • Jake
    @Alex: My point was that if you get coverage from an Arrington or Scoble, you'll get traffic. Makes sense to have the beta open to all comers vs. asking them to wait. Maybe it's just me and my short memory.

    Some of the CRM guys read here, so they may see your comment. I don't really know much about CRM, though sorry. I think you have to be a customer to use the APIs, pay-for-play.

    My advice is join <a href="https://mix.oracle.com rel=" nofollow="nofollow">Mix to reach the CRM teams more directly with your questions.
  • Jale - thanks for the advice re: beta invites. We opened up our beta a couple of weeks ago as a public beta, so this means if you sign up you'll get in straight away (just needs email verifciation step)...

    On Oracle: we're investigating some of the Oracle web APIs that might be available for Bungee devs to program against, especially CRM related stuff...if you have any pointers to hosted versions of Oracle products and over-the-web APIs provided, that would be great.

    Alex.
blog comments powered by Disqus