The Upscoop Revolution
by Patrick Ruffini :: February 12th, 2007 10:44 pm
Auren Hoffman’s Rapleaf has recently launched Upscoop as a “fun, free service.” Upscoop is at once revolutionary… and a little bit creepy. It will poll your entire contact list from Gmail, Hotmail, Yahoo or AOL, tell you which social networks they’re on, and often provide direct links to their profiles.
I had 474 contacts in my old Gmail. It was really interesting to see the market penetration of various Web 2.0 sites (and some 1.0 sites) among my contacts. The breakdown was as follows:
Classmates 70
Flickr 69
MySpace 66
UPDATE: Facebook 40 (via Facebook’s Friend Finder tool)
Tickle 25
Friendster 20
Bebo 15
AIM 14 (only AOL.com addresses)
It’s interesting to see Classmates outpolling MySpace with 150 million members. A big part of that is age — I’d guess the average age of my contacts is 35, so it’s outside the MySpace Generation. But it shows that Classmates is probably quite a bit bigger than Facebook (not tracked by Upscoop) but doesn’t figure much in social networking discussions because of its pay model/lack of stickiness. From its extensive advertising, you have to assume that Classmates is profitable, but you wonder what kind of pressure it will face as more open sites like Facebook and MySpace start catering to alumni.
WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)]
![]()
Comments (
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='')
WHERE post_status = 'publish' AND ID IN (32)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback')
WHERE post_status = 'publish' AND ID IN (32)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback')
WHERE post_status = 'publish' AND ID IN (32)
GROUP BY ID
Trackbacks (
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='')
WHERE post_status = 'publish' AND ID IN (32)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback')
WHERE post_status = 'publish' AND ID IN (32)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback')
WHERE post_status = 'publish' AND ID IN (32)
GROUP BY ID
del.icio.us
digg it
subscribe
You can leave a response, or trackback from your own site.
WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)]
SELECT * FROM ocwp_comments WHERE comment_post_ID = '32' AND comment_approved = '1' ORDER BY comment_date




















