Monday, March 21, 2011

WP7Comp Entry Statistics: Total Likes, Comments, and Reactions for all entries

WP7Comp Authors 2011MAR20I haven’t done a very good job at keeping up with the PhraseMeme blog (too busy coding :-), but the WP7Comp contest sponsored by Microsoft and Red Gate is scheduled to announce a winner at the end of March and the anticipation is killing me! I have two entries in the competition: WinFone Alpha and PhraseMeme Scanner, and I have spent a fair amount of time looking over all of the other entries to see what the competition is up to. Many of the entries are very good, and I honestly have no idea who they will choose as the winners, but I wanted to see where I was at and what my chances might be.

One of the grading criteria is generating a “social buzz” on the WP7Comp website, but the competition’s website does not make it very easy to navigate around or see which entry is getting the most buzz. Because of this I decided to modify an old Resolver One spreadsheet that I made a while back that uses WatiN to create an IronPython powered spreadsheet for simple Web page automation and testing. This lets me scrape information from websites and load it into a grid for sorting and processing, and worked perfect for generating stats for each entry on the WP7Comp website.

So after an hour or two of work I was able to get all of the entries filled into one spreadsheet, with the number of Likes, Comments, and Reactions for each. It turns out that while there are a number of entries with more likes and comments than mine, the entry for PhraseMeme Scanner is currently in the top 15 for total number of Likes, which is better than I expected considering the barrage of last minute entries. If you are interested you can see the charts above/below for more details or access the full spreadsheet on Google Docs.

WP7Comp Entries by Likes 2011MAR20


Slodge said...
This comment has been removed by the author.
Slodge said...

Thanks for the analysis - and for sharing the full spreadsheet too. I can see why you choose 15 as the answer :)

Looking down it seems like iron7 - - is in 20th on this list :( But at least I know that its developers who have liked it :)

Going to be very interesting to see how the team decide on the prizes. I guess we all find out in the next couple of weeks.

Thanks again for sharing - good work!

Good luck!

Slodge said...

Also really *love* the "[citation needed]" quote at the top of your blog - very good :)

Greg Bray said...

Thanks. I wanted to add more to the graph, but things started to get pretty crowded. I figured other WP7 devs would be interested in seeing their stats, so the spreadsheet should give you all the details. Also I <3 XKCD and tend to use it whenever I can.

Slodge said...

It really is good to see this produced - I suspect RedGate will be thankful for it too :)

How they distinguish between likes/comments from developers compared to coworkers, friends, gamers, etc is going to be a challenge!

Personally, I like your worksheet/chart more once you've added comments,likes and reactions together - gets iron7 up into 10th place ;)

Thanks again - good work and good luck!

Post a Comment