Tara, thanks for publishing this spreadsheet. I am interested in how you determined your "Value of Word of Mouth" calculations. How did you quantify the influence value of the company and customers? How does this influence the value of each post?
Quantizing these metrics makes the discussion with prospects more compelling. Thanks. @aprilmwilliams
AprilMWilliams Hi April: Thanks for reading! Word of Mouth is definately an important if variable part of quantifying social media. I use a weighting technique that I determine based on my client's needs. This allows me to stay flexible based on the program, while staying consistent to the metrics.


This spreadsheet of social media's ROI is very helpful.. very detailed I must say.. thanks for the share.
- spam
- offensive
- disagree
- off topic
Like