Render Positive
Get in touch

Menu

Render Positive

Get Social Sharing Stats in a Spreadsheet


By Han | 5th Mar 2015 | Posted in Data and Tools

SharedCount logo

 

A couple of years ago, we shared a spreadsheet that you can use for getting sharing stats across Facebook, Twitter, Reddit, Pinterest, LinkedIn… plus a few more. Since then, the SharedCount API that made this possible has changed a little bit, so we’ve made some updates to the Google Docs sheet so that it still works.

sharing stats

Here’s what you need to do:

  1. Sign in to Google.
  2. Open the spreadsheet.
  3. Go to File > Make a copy… to save a version to your own account.
  4. Head to sharedcount.com and sign up for a free account.
  5. Grab your API key from your account info page, and paste it into cell B1.
  6. Update column A with all the URLs you want stats for, and drag the formulas down as necessary!

As with the previous version, there are a couple of things to bear in mind: the data will reload every time you open your spreadsheet, so it’s worth exporting as a CSV or Excel file if you want to keep a snapshot. SharedCount caches its metrics and updates every five minutes, so if you want to re-check something then you’ll have to wait that long.

 

Sign up now!

Get more great stuff delivered fresh to your inbox.



2 Responses to “Get Social Sharing Stats in a Spreadsheet”

  1. Just what I was looking for guys, a free way to monitor my social shares on a Google Spreadsheet.

    Thanks!



Leave a Reply

Want to know what we could achieve for you?

View all resources Useful stuff


Meet the team

Jon Buchan
Hannah Brown
Jenny Longmuir
Tess Bowles
Lee Buchan
Asher Baker
Bree Van Zyl
Sam Reynolds
Aida Staskeviciute
Laura Reddington
Dipak Hemraj
Jess Collett
Gemma MacNaught
Laila Khan
Gary Buchan
James Hackney
Stuart Lawrence

Jon Buchan Chief Executive Officer jon@renderpositive.com
07949 283 785
Hannah Brown Creative Yet Technical Manager hannah@renderpositive.com
07453 779 030
Jenny Longmuir Content Marketing Editor jenny@renderpositive.com
Tess Bowles Social Media & Content Marketing Manager tess@renderpositive.com
Lee Buchan SEO and Social Media Executive lee@renderpositive.com
Asher Baker SEO & PPC Manager (and Lord) asher@renderpositive.com
07525 744 178
Bree Van Zyl Video Productionista briarley.vanzyl@renderpositive.com
Sam Reynolds Copywriter sam@renderpositive.com
Aida Staskeviciute Graphic Designer aida@renderpositive.com
Laura Reddington Copywriter laura.reddington@renderpositive.com
Dipak Hemraj All Rounder dipak@renderpositive.com
Jess Collett Copywriter jess@renderpositive.com
Gemma MacNaught Head of UX and Conversion Rate Optimisation gemma@renderpositive.com
Laila Khan Head of PR laila@renderpositive.com
Gary Buchan Managing Director gary@renderpositive.com
07525 839 157
James Hackney Client Services Manager james@renderpositive.com
07725 209 820
Stuart Lawrence Chief Technical Officer stuart@renderpositive.com
07725 209 819



Stalk us on social…