Compete Competes with Alexa
by Patrick Ruffini :: January 9th, 2007 11:19 am 
I noticed that a new Web 2.0 analytics service has risen up to compete with Alexa. It’s called (…drumroll…) Compete.
Compete says it relies on a panel of 2 million users and is more reliable than Alexa toolbar downloads. They’re probably right. Alexa, despite its addictiveness, is easily gamed. Their interface is clean and they demystify the numbers by giving you total number of uniques in a month on a site.
This is where they go wrong. By almost any measure, their total uniques number for any given site is low, like 2 and 3 times low. That’s looking at Nielsen data, internal numbers, Google Analytics, Sitemeter — for numerous sites. Does anyone really believe TechCrunch, which gets an average of 86,923 visits a day had just 52,025 unique visitors in November? Even the most viral blogs do no less than 2 to 3 times their daily uniques in a month.
Compete may be lowballing it, but I will say this: at least they lowball consistently. Their traffic curves seem to be dead on, and less herky-jerky than even Nielsen for smaller sites.
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)]
Tagged: alexa 
compete stats
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 (15)
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 (15)
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 (15)
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 (15)
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 (15)
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 (15)
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 = '15' AND comment_approved = '1' ORDER BY comment_date
