Social Media ROI Calculator – What the Programme Really Cost
Social media ROI is one line of arithmetic: (return − investment) ÷ investment × 100. The tool exists because almost nobody assembles the two inputs honestly. “What it cost” is not the ad spend, and “what you got back” is not the revenue — and once both are corrected, campaigns that report as profitable frequently turn out not to be.
The social media ROI formula
Four identities do all the work:
total investment = media + fees + production + tooling + hours × ratetotal return = revenue × gross margin(plusleads × close rate × deal value × marginfor lead-gen)ROI% = (return − investment) ÷ investment × 100, andROI% = (return multiple − 1) × 100break-even revenue = total investment ÷ gross margin
One campaign, two answers
Take a campaign that spent $4,200 on ads and was credited with $10,080 of revenue from 84 orders at a $120 average order value and a 45% gross margin. A ROAS calculator reads 2.40× and a $336 contribution — an 8% return on media. Correct, on its own terms. Now add the rest of the invoice, one line at a time.
A $1,500 creator fee. $600 of video production. $250 for the scheduling tool. And the line everybody omits: one manager at 12 hours a week for four weeks — 48 hours at a loaded rate of $88,000 ÷ 2,080 × 1.3 = $55.00 an hour, or $2,640. Total investment: $9,190.
The return has not moved: $10,080 × 0.45 = $4,536 of gross profit. So $4,536 − $9,190 = −$4,654, and the ROI is −50.6% — a 0.49× return. Break-even needed $9,190 ÷ 0.45 = $20,422 of revenue, which is 171 orders. It delivered 84. Even with labour excluded entirely, the investment is $6,550 and the ROI is −30.7%: “my time is free” does not rescue it.
Percentages and multiples are not the same number
The same campaign run as lead generation — 340 leads, a 6% close rate, a $2,400 average deal and a 60% margin — returns 340 × 0.06 × 2,400 × 0.60 = $29,376. That is a 3.20× return and a 219.7% ROI, not a 320% one. Half the ROI claims online are multiples wearing a percent sign. Because ROI% = (multiple − 1) × 100, break-even is 1.00× and 0% — never 100%.
Payback, not just a percentage
An ongoing programme is better judged on when it repays itself. Separate the one-off setup from the monthly run rate: $3,000 of setup against $2,890 a month of salary and tooling returning $3,400 of gross profit gives a $510 monthly net and 3,000 ÷ 510 = 5.9 months — whole during month 6. Where the monthly net is zero or negative there is no payback at any horizon, and the honest output is a sentence saying so rather than a line extended until it crosses.
What this cannot measure
Followers, impressions and engagement are context, not return; no defensible rate converts them into money. Earned media value has no agreed definition and is usually computed by the party who benefits from it being large, so it stays out of the headline figure here. Gifted product enters at cost of goods, not retail. And brand awareness has real value that this calculator does not capture — which is worth saying plainly rather than filling the gap with an invented number. No industry average ships with this tool for the same reason: published social ROI figures span from negative to four digits, and a benchmark would be read as a target.