Better Living Through Technology: a blog dedicated to emerging
technology trends in hardware, software, webware, marketing and beyond
 
 
 



« Blogger Ads Blog Comment Email Subscriptions | Main | Will Google replace Microsoft Exchange? »

Crunching My Facebook Friend Stats
Ed Kohler

I have been testing out the FriendCSV application mentioned on TechCrunch yesterday. FriendCSV allows you to download a .csv file with some - but not all - of your Facebook friend's contact information.

One thing I found interesting was the comparison between Facebook UserIDs and birth dates. It looks like Facebook userIDs are handed out sequentially, so you can get a feel for when someone's joined based on their userID.

My ID number is 500910058, so you can decide for yourself whether that gives me any Facebook cred.

To find your UserID number, click the Profile link and look for it in your browser's address bar:

http://www.facebook.com/profile.php?id=500910058

I plotted Facebook UserID's against the birth dates of my Facebook friends and ended up with the following chart:

Facebook User ID Numbers by Birthdate

Birth years run from oldest on the left to youngest on the right.

The lower right quadrant makes up the early adopters. But in the case of Facebook, the early adopters were also the only people with access to the site: college students. In my friend's case, this group is mostly made up of recent college graduates.

The lower left quadrant seemed strange until I spot checked it and found friends who were in grad school over the past few years.

I don't have an explanation for the gap between Facebook UserId numbering 200-500 million. Any theories? Did Facebook arbitrarily bump up their UserID sequence at some point? It kind of looks like they may have reset it to 500,000,000 based on the line of friends at that level.

Moving to the top quadrants, the far right is pretty light, since basically anyone of college age had already joined Facebook.

Things seem fairly well dispersed among age ranges - in my case, from the 1940's through the 1980's - over the time Facebook has been open to everyone.




Comments

1. Posted by: Don Li on October 31, 2007 10:02 AM:

This is awesome observation, thank you.




2. Posted by: Guardian Angel on January 30, 2008 10:29 AM:

Please be aware or at least warn people that it is also possible to get into some areas of a persons private profile by swapping user id's in the url. To view a superwall or funwall for example, of a 'private' user, simply find someones public profile, view thier super or fun wall, then simply delete the user id and paste in the private id of the private person you wish to view. It works for a lot of the apps too. I can't belive I seem to be the only person on the web who knows about this.




3. Posted by: Jesse on May 19, 2009 3:32 AM:

How did you plot birth dates against user IDs? I should say, can you explain how I can reproduce your experiment? Thx, very interesting.

Btw found this searching google for "what does my facebook id mean?"




4. Posted by: MJI on June 16, 2009 7:05 AM:

http://apps.facebook.com/friendcsv/

This link not work now how i get FRIENDCSV and EXPORT my FACEBOOK CONTACTS.

Waiting for response

REgards.

MJI




Post a comment

Required fields marked with: *
Name*:


Email Address*:


URL:
Remember personal info?

Comments*:

HTML Tags you can use in your posts:
<b>Bold</b> = Bold
<i>Italicized</i> = Italicized
<a href="http://www.othersite.com">Link to Other Site</a> = Link to Other Site


Please keep comments on-topic. Contact authors or other commenters
directly for off-topic conversations.

Notify me of future comments via e-mail



Technology Evangelist Digest - Free Newsletter
Sign up for the free Technology Evangelist Digest to receive daily updates, editorials, and practical advice on emerging technology trends in hardware, software, webware, marketing and beyond.

Technology Evangelist Digest will keep you up to date on the technology trends that will help make you more productive and efficient both in business and your personal life.

Let's face it: If you made it to this line, you must have found something valuable on this page, right? Think about how cool it would be to have something free and interesting to read every day from Technology Evangelist by signing up today.

1. Fill in your email below,
2. Then click on the confirmation email you receive.
3. That's it. Your first Technology Evangelist Digest will arrive within 24 hours.




Previous Entries:


Tag Cloud