WootBot


quality posts: 14 Private Messages WootBot

Staff

Artist Rendering of Dave Bug in Money and Puck poolWell, two out of three ain't bad. One of my favorite SNL sketches has John Larroquette dying and going to heaven. Only, heaven, in this case, is his very own angel there to answer questions about the minutia of his life. The 200th grossest thing he accidentally ate? A dead earwig. Hey, I found a transcript.

Anyway, we’re not quite that powerful or all-knowing here, but there is a mountain of 150,000 members-worth of data to sift through. When I’m bored swimming in our twin reservoirs of cash and priority pucks, I fire up the ol’ Query Analyzer and look for some silly stats. Ever wonder how users have Fred in their username? 189. Geek? 163. Poop? 37. Yes, really.

I got to wondering what company has the most employees-that-woot. Now, we can only count people who’ve used their company email, and of course it’s pointless to count places like hotmail or gmail, but here’s what seems to be the top 10 Woot-friendly businesses:

1. Microsoft
2. U.S. Army
3. Morgan Stanley
4. State Farm
5. U.S. Navy
6. Wachovia
7. Sprint PCS
8. Intel
9. Google
10. Citigroup

And you wondered why Vista’s release date keeps slipping. (Don’t worry MSers, we’ll keep your identities private, so woot away!)

As far as top users, well, we don’t want to give out any names (lest the significant others find out where all their joint-account funds have gone). We can tell you, one super-wooter has purchased 338 products from 114 different woots. Our top spender (a different user) has handed over $16,285.62. And if you’re wondering if we eat our own dogfood, our own Galloping Cow has 94, clicking that I Want One button 52 different times.

I could go on, and if it weren’t for all of you nagging me to get an Eggplant skin together, I probably would. Got any fun things for me to query? No, I won’t give you Bill Gates’s credit card number (or even tell you if we have it), but I’ll try to satiate some of your generalized Woot curiosities. Fire away!

`

Red_Six


quality posts: 0 Private Messages Red_Six

Sounds like there are some major woot addicts out there. $16,285.62 zoinks. What is the most number of consecutive woots any one member has purchased?

Tokey666


quality posts: 0 Private Messages Tokey666

LMAO!! Poop!!! Nice one.

One thing I am currious about. How many registered wooters do we have here?

Red_Six


quality posts: 0 Private Messages Red_Six
 Tokey666 wrote:
LMAO!! Poop!!! Nice one.

One thing I am currious about. How many registered wooters do we have here?



Check the Members section at the top of this page.

157,247

poop


quality posts: 0 Private Messages poop

37 people with poop in their usernames. How many with just poop by itself? That's probably a stupid question. I'm assuming I'm the only one, but then again, I'm retarded. Poop was not what I wanted for a username. My first 3 choices were already taken. I was so pissed, I entered in poo out of frustration. Turns out that was taken too. I became even more pissed, and added a p. I'm too stupid and lazy to come up with a better name. My crappy username serves as punishment for being so stupid. I'm embarrassed every time I see it.

Snapster


quality posts: 16 Private Messages Snapster
 poop wrote:
37 people with poop in their usernames. How many with just poop by itself? That's probably a stupid question. I'm assuming I'm the only one, but then again, I'm retarded. Poop was not what I wanted for a username. My first 3 choices were already taken. I was so pissed, I entered in poo out of frustration. Turns out that was taken too. I became even more pissed, and added a p. I'm too stupid and lazy to come up with a better name. My crappy username serves as punishment for being so stupid. I'm embarrassed every time I see it.


ha - great story. you should be proud to be the original and only true poop on woot!

dave bug


quality posts: 14 Private Messages dave bug
 poop wrote:
Poop was not what I wanted for a username. My first 3 choices were already taken. I was so pissed, I entered in poo out of frustration. Turns out that was taken too. I became even more pissed, and added a p.



Think of all the people who then typed "poop" out of frustration and saw that that was taken, too. I wonder what they typed after that.

Keep suggesting other searches you want, I'll gather the best ones and do another post in the future. (Some would be pretty tricky to look up, so I'll have to work on my SQL-fu.)

j-o-h-n


quality posts: 4 Private Messages j-o-h-n

So:
1) who was the first person to buy from woot 1.0?
2) fastest sellout?
3) highest items sold per hour item?
4) highest woot wage?
5) what's the deal with ab-tilt? (worst seller ever?)
6) what's the best thing anyone ever got in a B.O.C.?

Higher prices AND crappier blanks, no thank you

tommusic


quality posts: 0 Private Messages tommusic


  • What part of the country has the most wooters? Are we mostly red-state or blue-state folks?
  • What price ranges have the highest popularity?
  • Do people usually buy qty 3, or is that item specific?

cruzer


quality posts: 0 Private Messages cruzer

-who has visited woot the most times(probably don't track that)
-how many wooters have bought something
-how many items has woot sold over the past year+?

beergut


quality posts: 0 Private Messages beergut
 cruzer wrote:
-who has visited woot the most times(probably don't track that)
-how many wooters have bought something
-how many items has woot sold over the past year+?






The second one is what I'm wondering. How many registered users have actually purchased something?

holyteach


quality posts: 0 Private Messages holyteach
 j-o-h-n wrote:
So:
2) fastest sellout?
3) highest items sold per hour item?
4) highest woot wage?



Hey, you stole my suggestions! But I'd add:

o woot with the highest gross revenue (number sold x price)

And how about a continuously-updated top-ten list of woot wages?

PJLime


quality posts: 1 Private Messages PJLime

Woot Woot Woot Woot Woot Woot Woot!!!!!!!!!

feagle814


quality posts: 0 Private Messages feagle814

Whoo! Microsoft is number 1!!!!!

I have a Windows Vista baseball hat.

cruzer


quality posts: 0 Private Messages cruzer

how many ".gov" emails are there? I wanna know how well our tax dollars are spent.


I'm not registered under a .gov email, but I still have one.


obob


quality posts: 5 Private Messages obob

how many registered wooters have yet to make their first purchase?

how many have yet to contribute their first community posting?

Of the top 100-or-so most prolific forum posters, who has gone for the longest period of time between postings? Does anyone take a vacation away from computers any more?

And you could create your own names for statistics, too, like MTBW "mean time between woots"

Which state has the highest wooter density?

How about graphics? You could have a "topographic" map with elevation replaced by number of woot shipments delivered, or whatever . . .

what, Me, sig?

XtremeDJ


quality posts: 0 Private Messages XtremeDJ

I got one... how many silly, funny and/or stupid questions can we flood our friends at W00T! with? Poor guy, what started out as pure boredom and/or curiosity may very well end up as a chore.

On a side note, I guess this would be a bad place to start bashing Microsoft's products, since I'm sure a few (thousand) of you are probably reading this.

I love W00T!

Keep up the insane, fun work!

Oh, and if you W00T folks ever need a network admin who is currently, and will probably continue to work for about half what I should be making, look me up!

Laters!

Saintless


quality posts: 0 Private Messages Saintless

Who has the most posts? The most first posts?

nickandale


quality posts: 0 Private Messages nickandale

That's a fine bunch of statistics.

My company actually blocks Woot and lists it as a banned site. No Woot, but we can get on EBay. Go figure.

Maybe all of the Microsoft guys are the tech support people in India? You figure that is must be their lunch hour when Woot fires off.

"Hey Ranjit, I got a Bag of Crap!"

peteromans11


quality posts: 0 Private Messages peteromans11

Woot bot speaks??? A first Smile

majestic


quality posts: 0 Private Messages majestic

Which active wooter has the lowest user id :)

strongsad


quality posts: 0 Private Messages strongsad

Can you outer-join your Item table with eBay's and find out what the average time gap is between midnight and whenever woot-pimps list their nightly booty?

hepcat


quality posts: 0 Private Messages hepcat

It looks like the Woot guys are users of Microsoft software since Wootbot talks about firing up ol' Query Analyzer.

Ok, here's one for you. Show me the Wooters (you can obfuscate the names somehow) that over the last year purchased at least 1 item per month or spent at least $1000 per month.

Not that that stat is particularly interesting, but it should be an interesting query, I think.

I guess I'm most curious about the average time it takes for an item to sell out. Maybe break that out into ranges like $1-$50, $51-$100, $100-$500, $500+. That way we'll know about how long we have to make a decision. :)

Mishkin


quality posts: 0 Private Messages Mishkin

hmmm, what would I like to know about wooters...

1. How many woots have there been since woot 1.0's conception?

2. How much revenue has woot.com generated in woot product sales alone?

3. Has peteromans ever actually bought a woot? =P

4. How many Brave Woman Kits actually sold?

5. How often does President Bush check woot? (I hear he's looking for WMD's in the Bags O Crap...) =D

Renny9900


quality posts: 0 Private Messages Renny9900
 cruzer wrote:
how many ".gov" emails are there? I wanna know how well our tax dollars are spent.


I'm not registered under a .gov email, but I still have one.




It's .mil formilitary email addresses. I'm to paranoid to use my Army email address. lol They watch me to much!!! I once did a Woot-off at work...luckily I was the only one there that day. I spent the whole Friday clicking refresh. Whew, what a day!

NoPoopFromU


quality posts: 0 Private Messages NoPoopFromU

[I'm so glad to hear I'm not the only user with Poop in thier name. I think the other 36 of us 'Poopers' need to join a special woot sub-culture!

ViperGuy


quality posts: 9 Private Messages ViperGuy

How many people visit woot each night?

Barrel of Cropsless since 2005
Like music and Woot! join the group and check out the crappy music I listen to.

zeek


quality posts: 0 Private Messages zeek
 majestic wrote:
Which active wooter has the lowest user id :)




i don't know where to look for mine but i have been a member for a prety long time. i actualy started cheacking woot within the first few days. i remember one of the first things they sold was a robomower. i waited several weeks to get an account.

majestic


quality posts: 0 Private Messages majestic
 zeek wrote:
 majestic wrote:
Which active wooter has the lowest user id :)




i don't know where to look for mine but i have been a member for a prety long time. i actualy started cheacking woot within the first few days. i remember one of the first things they sold was a robomower. i waited several weeks to get an account.



your user id is 3946.. (just place cursor over your name or PM)

dkaufman1


quality posts: 1 Private Messages dkaufman1

WootBot Basics

Using your initial breakdown listed in the main post, further break it down by most dollars spent and most woots per company.

What "generic" email is most popular...gmail, hotmail, aol, yahoo, etc for wooters?

How many people who have ordered BOC ordered just 1, instead of 3? Shown over time as well.

What has been the product classification frequency? # of speaker woots, # of BOC of crap woots, # of robosapiens, # of toys, # of RC products, # of PCs

Advanced WootBot fun

Map your shipping data to GoogleMaps to showcase visually wooters by state, zip.

Tweak the Current item's woot stats to be real time current stats.<br />

Change the FAQ to read orange lights, instead of purple. Discard Barney joke for bad tow truck joke.

dkaufman1


quality posts: 1 Private Messages dkaufman1
 majestic wrote:
 zeek wrote:
 majestic wrote:
Which active wooter has the lowest user id :)




i don't know where to look for mine but i have been a member for a prety long time. i actualy started cheacking woot within the first few days. i remember one of the first things they sold was a robomower. i waited several weeks to get an account.



your user id is 3946.. (just place cursor over your name or PM)


Majestic - that may be true for forum ID, but my Woot ID as identified on a certificate I was once sent was a different number. It was promotion from the early days. I actually thought it was pretty clever, and have kept it.

joshlocker


quality posts: 0 Private Messages joshlocker

Who got the most blames (last of the quantity)?

mbarchok


quality posts: 0 Private Messages mbarchok

Here's a stat I'd like to see: Most BOC's, (or mystery speakers,) sucessfully purchased by a single user.

mbarchok


quality posts: 0 Private Messages mbarchok

What about:
How many times Brave Woman's picture has been posted on Woot.
Who has won the most contests. (Sapped the most money out of Woot,) and if any have actually won more than they spent here.
How many wooters are named Harry.
How many wooters are hairy.
How many screeching monkeys woot has sent out.

misterjosh


quality posts: 0 Private Messages misterjosh

State and/or Region and/or Zip Code with the most AB-TILT purchases, cross-referenced with the list of America's Fattest Cities ! :)


reddesertbrat


quality posts: 0 Private Messages reddesertbrat

Hey wOOt, I'd like to see ages, did we have to disclose that when we initially signed up. How many college students vs. others. Got any age calculations?

mbarchok


quality posts: 0 Private Messages mbarchok

How many pucks have been sent out?

Binaural


quality posts: 1 Private Messages Binaural
 misterjosh wrote:
State and/or Region and/or Zip Code with the most AB-TILT purchases, cross-referenced with the list of America's Fattest Cities ! :)




That's a good one.

Quick, someone check my spelling and grammar for me.

Binaural


quality posts: 1 Private Messages Binaural
 Renny9900 wrote:
 cruzer wrote:
how many ".gov" emails are there? I wanna know how well our tax dollars are spent.


I'm not registered under a .gov email, but I still have one.




It's .mil formilitary email addresses. I'm to paranoid to use my Army email address. lol They watch me to much!!! I once did a Woot-off at work...luckily I was the only one there that day. I spent the whole Friday clicking refresh. Whew, what a day!



<insert joke about military readiness here>

Quick, someone check my spelling and grammar for me.