
Figure 1 - Breakdown of iPhone auction listings that were successful (48%), and those that were unsuccessful (52%)
Figure 2 - Breakdown between the 4GB iPhone model (13%) and the 8GB (87%) auction listings.
Figure 3 - Breakdown of the profit margins for iPhone listings on eBay
In case you've been under a rock, Apple launched their much-hyped iPhone over the weekend. Across the nation local news stations reported on the long lines forming at Apple and AT&T stores up to 12 hours before doors opened. Some just wanted the new toy, others were hoping to take advantage of demand and resell the gadgets on eBay at a hefty profit.
Imagine the surprise of those thriving entrepreneurs when the hordes of people flocking to eBay to pick up an iPhone failed to materialize.
I was curious at how well iPhone sales were doing on eBay after having heard several news stories about people who waited in line all day just to sell an iPhone or two on eBay. After browsing a couple pages on eBay the informal results were about what I expected - many of the overpriced iPhones were not selling. Of course, 1-2 pages of eBay listings represents nothing in the grand scheme of things, maybe 10-20 minutes depending on the frequency of the listings. I needed more data.
So, pleased to present my analysis of eBay iPhone auctions following Apple's hottest new product launch.
Data was compiled on all completed auction listings for the iPhone at eBay from 12:49am EST -- 09:26am EST on Sunday (July 1st). The analysis included 993 auctions and lasted for 8 hours and 37 minutes... just over a third of a day. 'Buy It Now' items were included, and data was compiled for both the 4GB and 8GB versions of the iPhone. Given that all of the devices were purchased from retail stores, an average 7% sales tax was also factored in.
Immediately, some trends were obvious - the most obvious of them being that users were largely selling just the 8GB model, with only 13% of listings being devoted to the 4GB model.
The other obvious (and more substantial trend) was that many of the iPhone auctions weren't selling, slightly over half came and went without a single bidder (52% to be exact).
Among those auctions that did close successfully, few were having the large markup that many expected to see the iPhone go for from third-party sellers... and a significant amount were only making their money back, even closing at a loss. In fact, the average profit on the iPhone (including the ones that didn't sell at all) during the analysis was $54.43; the median profit was even lower at $34.16.
So wait a minute, what's going on here... wasn't the iPhone supposed to be the most anticipated product since the Nintendo Wii?
Well, as Ken Fisher notes, iPhones are iPlenty. When Apple's own iPhone locater was last updated, most Apple retail stores still had the phone in stock, sans lines.
Of course this isn't to say that iPhone sales aren't going well - far from it. Carl Howe is estimating that sales of the iPhone could have been as high as 30,000 an hour during the peak of the launch.
Those that are still looking to get their iPhone need no longer turn to eBay or a line at the store: Apple just added the gadget to their online store... and with free shipping to boot.
...and just to prove I'm not @!$%#ting you on the massive data compilation, here it is in a 620k HTML file along with every corresponding auction number, should you feel like verifying 1,000 eBay listings.
...and just to prove I'm not @!$%#ting you on the massive data compilation, here it is in a 620k HTML file along with every corresponding auction number, should you feel like verifying 1,000 eBay listings.
You got so much respect from me for that footnote alone. :-)
Thanks for this, Corey.
I appreciate the effort involved in this -- and I suspect you'll get the Kudos you deserve for the Citizen Journalism you're providing.
My kudos aren't really for the information, or whatever, because I think everyone can do it and I wish everyone WOULD do it. My kudos are because you are doing it. If Newsvine hurts for content, it's because a lot of people are too busy complaining about the lack of content rather than CREATING the content. Being part of the problem means they aren't being part of the solution.
Here's hoping even one other Viner sees your efforts and puts forth some original content with some informative information. In many cases, info like this is just sitting out there, and waiting to be collected into an article by someone like you or me.
I still say that seeding links is easy, and presenting links is easy -- putting them into an an article like this with analysis and straight-forward presentation is far more important. Thanks for being part of the solution. It's good to see you posting more lately.
So, you're saying that Corey Spring is in stock, you're just looking for the demand?
What a bunch of fools...
thanks for the analysis
Nice analysis. I was thinking about this when I read the other day that only a few stores were actually sold out of the iPhone. It seems a lot of people were banking (no pun intended) on a shortage.
Between this and the PlayStation 3, I'm hoping people are getting the message and deciding to be more cautious and less brazen with these hair-brained get-rich-quick schemes.
I'm not hoping that. I'm hoping they get stuck with a bunch of technology they can't afford.
:)
Still can't find a Wii, though.
Why just yesterday I blogged (apologies for shameless self promotion) a story I found on Digg about a woman in Texas who spent $800 to be the first in line at an AT&T store hoping to buy $16,000 worth of iPhones to sell on eBay. She was not aware that there was a 1 per customer limit at AT&T stores, and unfortunately the TV news crew didn't get any footage of her reaction.
They probably did, but she most likely didn't let them use that bit of footage.
I was reminded of that story too, I thought that was just precious. The guy who was first in line got a free iPhone out of it =)
I call it the yPhone, as in, "y is everyone making such a big frickin deal about a phone"?
Daring Fireball -- the holy grail of linkage for any self-respecting mac user.
Damn, I got the DF linkage for my Zune satire piece, but no other major blog…
You winz! ;-)
So a phone locked to one provider (ATT) and with low-end iPod capacity and costing a fortune for those two main things is not selling big on eBay or elsewhere? Gee, I wonder why not.
Just to add to this a bit more, because I was watching this pretty much all weekend, the morning of June 30th iPhones were selling on eBay at a pretty high clip actually. I watched several phones go for $1,500+ early Saturday morning. But it was interesting to watch because we are so accustomed to shortages these days that people were adding iPhones all day long on Saturday, there were literally around 6,000 of them listed on eBay Saturday mid-morning, and that carried through Sunday. By Saturday evening they had slowed to going about $850-$1,000 and by Sunday is was a massacre of overabundance, as you pointed out, phones were going for barely retail and people where pulling their items out right and left.
And in the interest of full disclosure, I will admit I was obsessively watching it because I did try to dip my toe into the pool on this. It was an interesting and stressful experience, and it was something about being caught up in the moment. I never thought I'd do that, but when I saw a chance to maybe get myself a free iPhone, I was to tempted to not try. I am happy to report though that both myself and my buyer on eBay came to our senses and we mutually agreed to cancel the transaction and I can't say I'll ever try it again. In the end I didn't lose anything but some time and maybe added some gray hairs.
I am though, quite curious to see if we'll see revised sales numbers after thousands of them are returned this week from not selling on eBay. :D
I was quite pleased to see Apple was on the ball with production. Scarce product numbers does not translate into cool gadgets as far as I am concerned, it translates into poor planning on the companies end. While I do feel it is everyone's right to grab a first in line and throw it on eBay, I admit to feeling quite smug about the gougers who are not going to have any luck this time.
CBS news -> now That deserves a Congrats from me, for sure :-)
Congrats!
Forbes and CBS? Wow.
I am not nearly as talented of a statistician as the Corey, but it appears that the margins of Nintendo Wii (not sure how to pluralize) on Ebay is significantly higher almost 8 months after the product launch.
My feelings regarding this is that Apples / Steve Job's unbearable self confidence had them in a position to be ready to meet demand while still making an unheard of Profit Margin. Granted there was a significant risk of producing "New Coke"! Kudos must be given where deserved.
FJKB
Mentioned here too...
ebaygoldmine.org
Holy freaking crap. Nice analysis Corey. This is the kind of stuff I eat up, and especially after reading Freakonomics, I'm in love with data mining. Again, incredible analysis. You're the man.
You're in Easy Mode. If you prefer, you can use XHTML Mode instead. |