Total Organic Impressions* CPM Value # clicks CPC Value Client Page A 15,276,282 $ 10.00 $ 152,762.82 44,803 $ 0.50 $ 22,401.50 Client Page B 66,030 $ 10.00 $ 660.30 73 $ 0.50 $ 36.50 15,342,312 44,876 22,438 $ 175,861.12 *Sum of Daily Total Impressions - Sum of Daily Paid Impressions Twitter Clicks number example Page Followers Tweets Retweets @Mentions Max Impressions+ View rate^ Est Impressions CPM Value # clicks CPC Value @ClientAccount 34,228 160 668 3,141 6,657,270 12% 798,872 $ 10.00 7,988.72 16,895 $ 0.50 8447.5 ^Rough estimated based on: http://adspace-pioneers.blogspot.com/2009/08/popping-twitter-reach-bubble-10-reach.html =+(Tweets*Followers*viewrate)+(RTs*310*viewrate)+(@mentions*310*viewrate) 310 Twitter followers based on: http://totalaccess.emarketer.com/Chart.aspx?R=116589&dsNav=Ntk:basic%7ctwitter+followers%7c1%7c,Ro:16,N:500 $ 16,436.22 Organic YouTube Views Brand Total organic views Cost/Promoted View Value Client Account 326,632 $ 0.20 $ 65,326.40 $ 65,326.40 Used the Social Equivalent Ad Value Model for videos developed by Tourism Ireland: http://www.scribd.com/doc/85406652/A-new-simple-way-to-measure-social-media-Return-on-Investment-Social-Equivalent-Advertising-Value Blog Pageviews Brand Pageviews Cost per Google click Value Client Blog 82,909 $ 0.50 $ 41,454.50 $ 41,454.50 Used the Social Equivalent Ad Value Model for videos developed by Tourism Ireland: http://www.scribd.com/doc/85406652/A-new-simple-way-to-measure-social-media-Return-on-Investment-Social-Equivalent-Advertising-Value Online Brand Mentions Brand Total brand mentions Cost per Google click Value Client Brand Mentions 120,411 $ 0.50 $ 60,205.50 $ 60,205.50 Used the Social Equivalent Ad Value Model for videos developed by Tourism Ireland: http://www.scribd.com/doc/85406652/A-new-simple-way-to-measure-social-media-Return-on-Investment-Social-Equivalent-Advertising-Value Total Impressions & Actions 16,732,907 Impressions 16,141,184 193,694,212.80 Monthly Value $ 359,283.74 Actions 591,723 7,100,676 Annualized 200,794,889 $ 4,311,404.93 Actions = brand mentions, organic YouTube views, blog page view, link clicks If client spends $150,000/month on social media ($3m annually) $ 1,800,000.00 ROI $ 2.40 of value for every $1 spent Download the Excel spreadsheet here: http://sdrv.ms/Q5NTvw