Tools

Social Media ROI Calculator, Formula and Worked Example

Published by Influence

Last checked

Social media ROI compares the value credited to social activity with the cost of producing it. This calculator uses contribution: ROI = (attributed net revenue − variable fulfillment costs − social media cost) ÷ social media cost × 100. Include labor and production costs, use one currency and period, and state how revenue was attributed. The result is an estimate under those assumptions, not proof that social media caused every sale.

Download template

Calculate your social media ROI

Use the same currency and reporting period for all three amounts. The starting values are a fictional example.

Revenue assigned to social media under your chosen attribution method, after refunds. This is revenue, not profit.

Costs of delivering those sales, such as materials, transaction fees or delivery labor. Exclude social media costs entered below.

Include relevant content work, tools, agency fees and ad spend once each. Use a positive total.

Return on social media investment
100%

(6,000 − 2,400 − 1,800) ÷ 1,800 × 100

Negative ROI is a valid result. Attribution does not prove that social media caused a sale. This calculator processes amounts in your browser and does not save or send them.

Costs and outcomes sit beside a simple calculation grid.

Which numbers go into the ROI calculation?

InputIncludeAvoid
Attributed net revenueRevenue credited to social by the chosen method, after refunds and discountsTotal company revenue or sales already credited in full to another channel
Variable fulfillment costsCosts that vary with fulfilling the attributed sales; exclude the social costs entered separatelySubtracting the same production or campaign cost in both inputs
Social media costAllocated labor, production, agency fees, tools, creators and advertising for the same scopeIgnoring unpaid founder time or counting a shared cost twice
Reporting periodA clear campaign or monthly window, with a consistent attribution windowComparing current costs with unrelated lifetime revenue

Contribution is the attributed net revenue remaining after variable fulfillment costs. Contribution margin rate = contribution ÷ attributed net revenue, when revenue is greater than zero. Confirm the cost classification with whoever owns your financial reporting. If your business uses a different ROI definition, keep that definition explicit rather than mixing results. This calculator does not estimate tax, financing costs or the business’s total profit.

The social media ROI formula

Attributed contribution = attributed net revenue − variable fulfillment costs

Net contribution after social costs = attributed contribution − social media cost

Social media ROI (%) = net contribution after social costs / social media cost × 100

Break-even attributed revenue = social media cost / contribution margin rate

When using a margin rate, attributed contribution also equals attributed net revenue × margin rate. Use a fraction: 60% = 0.60. Social cost must be greater than zero for ROI. Break-even revenue assumes a constant margin greater than zero.

A 0% result means the attributed contribution covers the included social costs. A negative result means it does not. A positive result means it exceeds them under the chosen assumptions. Zero recorded cost does not make ROI infinite: the percentage is undefined, and unrecorded labor or production may need to be included. Missing inputs are unknown, not zero.

Worked example: a small workshop campaign

All facts below are fictional. Maple Workshop runs a one-month campaign for paid classes. Its existing reporting method credits USD 6,000 in net revenue to social content. Variable costs of fulfilling those bookings are USD 2,400, leaving a 60% contribution margin before campaign costs. It spends USD 900 on production labor, USD 300 on allocated software and agency costs, and USD 600 on advertising: USD 1,800 total.

Fictional example

Attributed net revenue: USD 6,000. Variable fulfillment costs: USD 2,400. Contribution margin: 60%. Social media cost: USD 1,800.

Attributed contribution: USD 6,000 − USD 2,400 = USD 3,600, also equal to USD 6,000 × 0.60.

Net contribution after social costs: USD 3,600 − USD 1,800 = USD 1,800.

ROI: USD 1,800 / USD 1,800 × 100 = 100%.

Break-even attributed revenue: USD 1,800 / 0.60 = USD 3,000.

Lower-attribution scenario: If credited revenue is only USD 3,000 with the same margin and cost, ROI is 0%. At USD 2,000, ROI is approximately −33.3%.

Interpretation: The base case estimates one dollar of net contribution after the included social costs for every dollar spent on those costs. It does not establish incremental profit caused by the campaign.

ROI is different from revenue and ROAS

Revenue is the value of sales, before the costs used in this calculation. Return on ad spend, or ROAS, usually compares revenue attributed to advertising with advertising spend alone. It can look strong while total social ROI is weak if labor, production or fulfillment costs are substantial. Keep paid-ad revenue separate from all-social revenue when calculating ROAS; the worked example above does not provide enough paid-only revenue data to calculate it.

Engagement measures interactions, not financial return. Use the engagement rate guide for likes, comments or other defined interactions, and report those alongside financial measures when they help explain the customer journey. Do not assign a made-up dollar value to every like just to produce a positive ROI.

Copy the ROI evidence worksheet

Business, campaign and period: [name, start/end dates, currency]

Outcome and revenue source: [completed purchase, paid booking or other recorded outcome]

Attribution method and window: [existing model, eligible interactions, lookback period]

Attributed net revenue: [amount; treatment of discounts, refunds and taxes]

Variable fulfillment costs: [amount, categories included and evidence owner; derive the margin when revenue is greater than zero]

Social costs: [labor + production + agency + tools + advertising + other scoped costs]

Shared-cost allocation: [method; confirm costs are counted once]

Calculation: [attributed contribution, net contribution, ROI and break-even revenue]

Uncertainty: [missing coverage, delayed sales, overlap and sensitivity range]

Decision and next review: [continue, change or investigate; owner and date]

How should you handle attribution uncertainty?

An attribution model assigns credit among interactions in a customer journey. Different rules can produce different channel totals; Google’s attribution documentation explains that distinction. Use the organization’s existing approved method and record its name and window. This worksheet does not require changing analytics tags, consent, cookies or account settings.

Cross-device visits, private sharing, offline sales, unobserved journeys and overlapping channel reports can limit attribution. Show a plausible lower and upper credited-revenue scenario when those uncertainties matter. To establish incremental impact, a separate, well-designed experiment may be needed; an ROI spreadsheet alone cannot supply it. Include these assumptions in the social media report so the decision maker sees more than a percentage.

Can you calculate ROI before revenue is known?

You can model a scenario, but label it as a forecast. Keep assumed conversion rates and revenue separate from actual results, and replace them when evidence arrives. For lead-generation work, report recorded leads or qualified opportunities first; expected pipeline value is not realized revenue. A useful report can acknowledge that financial return is not yet measurable.