Still 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
- 6,963 total
- 2,529 Oracle employees (36%)
- 4,434 customers (64%)
- Only 13% of profiles are public
Since I ran these numbers this morning, we’ve had 27 new people join Mix. Not bad.
Groups
- 286 total
- 230 public (80%)
- 56 private (20%)
- Average membership is 14
- 58% of groups were created by Oracle employees
Miscellaneous
- 2,631 tags exist in Mix
- 607 ideas
- 168 questions
- 1,354 comments on ideas, questions and profiles
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.
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.
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.
@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 Mix to reach the CRM teams more directly with your questions.
@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 Mix to reach the CRM teams more directly with your questions.
– 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
– 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
@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.
@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.
You don’t have large data, but how about doing something like Six Degrees of Separation (http://en.wikipedia.org/wiki/Six_degrees_of_separation)
You don’t have large data, but how about doing something like Six Degrees of Separation (http://en.wikipedia.org/wiki/Six_degrees_of_separation)
@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?
@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?
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
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
@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: 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.