Update 5/3/2015: SharedCount now require you to use an API key with every query, so we’ve made some adjustments to the spreadsheet so that it still works. Before you can use it now, you should go to File > Make a copy… and then fill in your API key in cell B1. You can get this for free by creating a SharedCount account.
This is a very short, quick, and easy way to grab social sharing stats for URLs across Facebook likes & shares, Twitter, LinkedIn, StumbleUpon, Pinterest, Google+, Delicious, and Reddit. Basically I’m just going to give you a copy of the Google spreadsheet, which should make things super quick for you. As long as you’re signed into a Google account you can make a copy for yourself (please do this) from the file menu.
There’s lots of things you might want to use this for, we often use it for quick checks of how campaigns are progressing or for research. There are also lots of other ways of doing this using social media monitoring tools, or by using each of the social network’s own APIs to grab this data. We used SharedCount because it seemed the simplest, and it handles talking to all those other official APIs itself. They’re also nice guys and don’t throttle usage at the moment (although I have included a small courtesy delay between calls anyway) and they have a nice big 100,000 query per day limit.
A few notes – every time you open the spreadsheet it will re-load all of the data. If you export it to a CSV file, it will download the pulled in share numbers so you can manipulate them further in Excel or keep them for reference. SharedCount cache queries for 5 minutes, so if you want to re-check something you need to wait at least that long. Also, the Pinterest and Reddit columns don’t seem to do much ever.
As I wrote this, I have to say: YMMV. I’m not a coder, this was knocked up for a bit of fun and has turned out to be really useful. I should also say thanks to Tom Critchlow for his various posts on using gdocs for handy stuff like this one.
If you can see ways to improve it (I’m sure there are many) please have a go, and let us know how you get on.
Get more great stuff delivered fresh to your inbox.