« The Long, Long Tail of Facebook Causes | Main | Innovative Uses of SMS: SMS for Lunch Campaign »

Is It Worth It? An ROI Calculator for Social Network Campaigns

worthithorizontal.gifWonder if you should spend your time campaigning in social networks?

You can use this tool to calculate an estimate of cost and return on investment for the recruitment and fundraising efforts of your staff in social networking sites like Facebook or MySpace. It works sort of like an online mortgage calculator. Just enter the starting assumptions in the yellow boxes below and the tool calculates results automatically.

Need some metrics guidelines? You might check out some of the online advocacy and fundraising benchmark studies. If you don't measure results strictly by fundraising -- maybe your results are based on advocacy or branding only -- you can just look at the "cost per friend" or "cost per email name" to compare with the costs of recruiting people elsewhere. You can also see how that translates into cost per action or email viewed (opened).

If you would like to see the assumptions and equations behind the magical calculations, they are available on the original Excel spreadsheet. Email Justin Perkins to request a copy or to send feedback, and feel free to comment below.


The Social Network ROI Calculator    
   
   
STEP 1. Fill in these metrics with goals or actual results Inputs in Yellow Metric STEP 2: Resulting Revenue and Costs  
Staff/ Volunteer hours per week for social network campaigns: hours/week Total "Friends" per year  
Cost per hour of staff & volunteer(s): $ per hour Email sign-ups/ week  
Employee receives benefits? Enter a "1" adds 30% Email sign-ups /year  
Social network "Friends" recruited per week (goal or actual): friends/week Revenue per emailing  
Viral growth rate per year of your Friends: friends/year Revenue per year  
% of Friends who join your email list: % of friends signing-up Number of donors/ year from emailings  
% of Friends who donate directly from your social network: friends converted to donors Number of direct donations/week  
Average direct donation /friend from social network site: $ per friend Number of direct donations/year  
Average donation from your email appeals: $ per email subscriber Average direct donations/year from social network  
Average response rate from email appeal: email donors Total $ donated from social networking  
Direct email fundraising appeals per year: emailings/year Total new donors per year  
Net churn rate per year for your email list: churn rate Total cost per year for social network campaigns  
Average Open Rate for outreach or advocacy emailings: % open Cost per Friend  
Average Response Rate for outreach or advocacy emailings: % of emails sent taking action Cost per email name recruited to your list  
# of Advocacy or Outreach emailings/year: emailings/year Cost per direct donation from social network  
             
STEP 3: Projected Response Rates for Email Advocacy and Outreach to Social Network Recruits  
  Year 1 Year 2 Year 3 Year 4 Totals  
Total email names remaining (last year + new names - churn)  
Emails opened per mailing n/a  
Actions/ Mailing n/a  
Total emails opened / year  
Total Actions/ Year  
Total Cost of labor (assumes 75% reduction in y2-y4)  
Costs per Email Opened and Cost per Action Average Cost:  
Cost per email opened  
Cost per action  
       
STEP 4. Projected Fundraising Results  
  Year 1 Year 2 Year 3 Year 4 Totals  
Total friends  
New friends/year (viral growth only in y2-y4)  
New email names/ year (viral growth only)  
Total email names remaining (last year + new names - churn)  
Total Cost of labor (assumes 75% reduction in y2-y4)  
Direct donors from social network  
Direct Donations from social network  
Total email donors  
Total Donations from emailings  
Total Combined Donations  
Total donors from social networking activities  
Overall Profit/Loss and ROI from Social Networking  
Cumulative profit/loss from fundraising (direct donations and email)  
Overall ROI for combined results  
             
Profit / Loss and ROI for Direct Fundraising from Social Networking Sites (not including email)  
Cumulative Profit/loss if direct donations from social network site only (no email fundraising)  
ROI for direct donations  
             
Profit / Loss and ROI for Fundraising Emailings to email leads recruited from Social Networks  
Cumulative Profit/loss if only email donations  
ROI for acquired (emailing) names only