This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Marketing Costs for Period
Monitoring Tools (Sysomos, Radian6)
Social Media Management Tools (Buddy Media, HootSuite, Spredfast)
Content Creation Time (hours)
Content Creation Time (cost per hour)
Engagement Time (staff time monitoring, writing and replying to consumers (hours)
Engagement Time (staff time monitoring, writing and replying to consumers (average cost per hour)
Dedicated Landing Pages costs
Miscellaneous costs
Total Marketing Costs
Returns for Period
Fan count or visitors
Conversion rate of fans / visitors to buyers
Average purchase value of buyer
Total fan / visitor purchases (transactions)
Total fan / visitor purchases (value)
Average gross margin percent on average purchase (%)
Total gross margin dollars generate
Value of a like / visitor (before marketing costs)
ROI for Period
Total Return (Gross Margin $s Generated)
Investment (Total Marketing Costs)
Total Return less Marketing Costs (RLI) (Net Profit)
ROI (RLI / Marketing Costs)
Value of a like / visitor (after marketing costs)
Reset
Print