Social Media ROI Calculator

April 24th, 2009 by
Ric Dragon

Jim Edelstein needed a Social Media ROI calculation for a client earlier this morning, so I obliged him with a nice Word doc.  He came back and said, “thats nice, but the clients now needs it in Excel”.  Ok – back to the drawing board.  Then, my new director of Social Media, Claudia D’Arcy, along with our head of SEO, Eta Ivkovic, asked that it be converted into an online tool.  With the help of a nice tool from http://www.spreadsheetconverter.com , and a bit of noodling, the result is here for your benefit.

Please let me know if you have any comments, suggested improvements, etc.

Thanks to Dag Holmboe and others who have asked questions and offered suggestions. Thanks to Social Steve for his mention and discussion at http://socialsteve.wordpress.com/2009/06/11/measuring-the-value-of-social-media

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • StumbleUpon
  • Technorati
  • Twitter

Tags: ,

Send to a Friend:





Send to a friend:

Related Posts:

Post comment as twitter logo facebook logo
Sort: Newest | Oldest

A really thorough criticism of the ROI Calculator, for sure. The author makes some excellent points. Since the calculator was submitted to the world for feedback its all welcome - but I think that the idea what I've posted is that it should be a way of looking of things... its not about the particulars that are cited. PR Stories may not have any value to your orgnanization - but what is?

Hi Koen; You're right- the difficult-to-measure social capital benefits are by far greater - the idea here is that sometimes we have to communicate monetary benefits to stakeholders. And if we try to see things through the "eyes" of the organization, we often find other places that organization is expending capital that is comprible to social media activities.

What are the drivers for value? It is expressed in money, but benefits are more on knowledge sharing and creation I think, items hard to express in numbers.

Would be most interested in your thoughts and response to the commentary shredding this calculator here: http://thebrandbuilder.wordpress.com/2009/05/29/ho...

I'm surprised no one else has left a comment about that already.

Hi Jess; The 'plugged-in' values are for example only... you can edit them to fit your needs.

Nice tool there. Anything to help entrepreneurs and investors evaluate opportunities and prepare realistic proformas and expectations is worthwhile. I look forward to the evolution of the SocMed ROI Calculator!

who determined what the "values" were in this calculator? They are already plugged in...

Great tool - thanks for developing! It's something we've all been thinking about for awhile now and it's great to actually see it done. It's always nice to have additional tools to validate our thought process for what we know is true but can't necessarily tie to a number. Kudos!!

Sarah @ GY&K

Trackbacks

  1. [...] can also check out our Social Media ROI calculator to help you get started. Hopefully these Social Media measurement points will encourage or enhance [...]