Blog ROI
Social media ROI: formula, example, and template
Calculate a campaign’s financial return from attributed sales, contribution margin, and stated costs. Includes a fictional case and a reusable CSV.
A social media campaign’s financial ROI compares the contribution credited to its sales with the full cost of that campaign. Subtract the variable costs of fulfilling those sales from attributed revenue. Then subtract the social campaign cost and divide by that same cost:
- C Attributed contribution
- Attributed revenue less variable sales costs, before deducting social costs.
- S Social campaign cost
- Paid media, production, team time, tools, and other included campaign costs.
Use the same currency and period. If S is zero, ROI is undefined.
This formula measures an economic result within a stated scope; it does not assign automatic monetary value to likes, followers, or impressions.
Define the return and investment you are comparing
Use the same scope, currency, and period in the numerator and denominator. Decide what counts as a sale, which revenue and variable costs to include, which networks or posts belong to the campaign, and what rule credits a sale. Record the conversion window and time zone as well.
| Measure | Calculation | How the scope changes |
|---|---|---|
| Campaign social ROI, the calculation in this guide | (contribution from attributed sales before social costs − total social campaign cost) ÷ total social campaign cost × 100 | Includes variable sales costs and the social campaign costs you specify. |
| Paid media ROAS | revenue attributed to ads ÷ ad spend | Compares revenue with media spend. It does not deduct product costs, team labor, or other campaign costs. |
| ROI using total included costs | (attributed revenue − variable sales costs − social campaign cost) ÷ (variable sales costs + social campaign cost) × 100 | Here, total means variable sales costs plus social costs, excluding fixed costs. The revenue and costs stay the same; state the base before comparing percentages. |
Swipe the table to see all columns.
Google Ads’ ROI example includes product production costs and ad spend in its costs. That page documents Google Ads’ scope; it does not make one formula a universal standard for social media. State your own cost base before comparing results. How Google Ads calculates ROI.
Attribution assigns credit to a sale according to a model and the touchpoints it considers. Google Analytics describes rule-based and data-driven models, which can distribute credit differently. Google Analytics attribution documentation. This article’s example uses a last tagged social click rule: that allocation does not estimate how many additional sales the campaign caused. Assessing that effect requires a suitable comparison; keep the attribution result separate from evidence of incremental impact.
A tagged link helps record where a visit came from. It does not prove that the visit caused a purchase. For consistent campaign tags, see social media UTM tracking. If you work with enquiries instead of sales, agree on a verifiable definition and keep the measure until the team confirms what happened.
Include the costs that belong to the campaign
Include ad spend and the campaign costs you decided to measure: creative production, fees, team hours, and a reasonable allocation of shared tools. Note how you assigned shared costs. If an agency invoice already includes production or labor, do not add those costs again.
Subtract the variable costs of delivering sales, such as materials, preparation, or transaction fees, from revenue. Keep the accounting basis consistent for revenue and costs. If you use an expected value for an enquiry before you know the sale, document its source and show the estimate separately from confirmed revenue.
A worked example with fictional figures
Taller Bruma is a fictional business promoting a ceramics course in August 2026. The tagged-click window runs from August 1 to 31 in the America/Santiago time zone; the report includes confirmed bookings through September 7 to complete the seven-day window. For this example, its CRM confirms 24 paid course bookings that were not cancelled. The team uses a stated rule: credit a reservation to the most recent non-direct tagged social click that occurred from August 1 through 31 and within the seven days before booking. The rule assigns credit; it does not prove social media generated additional bookings.
Each booking contributes CLP 80,000 in recognized revenue and CLP 30,000 in variable materials and transaction costs. Contribution from attributed sales before social costs is:
24 × CLP 80,000 = CLP 1,920,000 in attributed revenue
24 × CLP 30,000 = CLP 720,000 in variable costs
CLP 1,920,000 − CLP 720,000 = CLP 1,200,000 in attributed contribution
The campaign includes CLP 180,000 in paid media, CLP 120,000 in production, five team hours at CLP 20,000 per hour, and CLP 20,000 in allocated tools. Total social campaign cost is CLP 420,000. This case has no additional fees or other campaign costs; if you have them, include them in the corresponding template field.
- Before social cost
- CLP 1,200,000
- After social cost
- CLP 780,000
(CLP 1,200,000 − CLP 420,000) ÷ CLP 420,000 × 100 = 185.7%, or about 186%. Under this attribution rule and with the costs listed, CLP 780,000 of contribution remains after the campaign, before the business’s fixed costs. If the denominator also includes CLP 720,000 in variable sales costs, ROI using total included costs is (CLP 1,920,000 − CLP 720,000 − CLP 420,000) ÷ (CLP 720,000 + CLP 420,000) × 100 = 68.4%. Both percentages use the same sales; they answer different questions and should not be compared without stating the cost base. Neither is a benchmark or a forecast of future sales.
Read the result with its limits
A positive percentage means attributed contribution exceeds the costs included in this calculation. A negative result means it fell short. If a value is unavailable, leave it unknown; do not turn it into zero. If social campaign cost is zero, campaign ROI is undefined because the formula divides by zero. ROI using total included costs is also undefined if variable sales costs plus social campaign cost equal zero.
For an objective such as awareness, attention, or customer service, you may not have a reliable monetary value for the period. In that case, report the cost alongside the measured outcome and agreed indicators; do not invent a price for each interaction. The guide to choosing social media KPIs connects goals with measures. To present the findings to a client, use the social media report template.
Download the social media ROI CSV template. It has a blank row to complete and a row with the fictional example. Formulas are written as reference expressions; the CSV does not run them. When you move them into a spreadsheet, replace the variable names with the relevant cells and leave values blank until you know them.
Before comparing another campaign, write down the measurement agreement:
Prepare the social media ROI agreement
Sources and scope
The cover is an AI-generated illustration.
The Taller Bruma example and its figures are fictional; they do not describe client results or set an industry benchmark. This guide’s formula is an editorial calculation for the stated scope; Google Ads’ official page shows its own example, and Analytics documentation explains how its models assign credit.
Plan your next post in HeyMark.
Keep the idea, review the draft with your team, and see how it performed in the accounts you connected.