Calculate social media marketing ROI from campaign contribution and media, creator and production costs. Follow a spreadsheet workflow that removes cross-platform overlap and includes the labor behind organic social activity.
ROI for social media marketing is attributed campaign contribution after campaign costs, divided by those costs. Start with unique customer orders and complete spending, including organic production labor; adding platform revenue claims or using media spend alone can distort the result.
Decide whether the review covers paid acquisition, organic community activity, retargeting or the whole social program. Use the same cost boundary for each campaign. The broader marketing ROI versus ROAS guide explains why revenue divided by advertising spend is a different measure.
Attributed social ROI = (Attributed order contribution − Social campaign cost) / Social campaign cost
For this US retailer, eligible orders run from September 1 through September 30, 2026, with refunds included through October 15, 2026. Campaign costs cover the work and media serving that purchase window. Record both cutoffs in the workbook.
Export order IDs, original order dates, campaign IDs, sales after discounts, refunds and variable order costs. Keep sales tax out. Add the prepared campaign allocation from marketing's attribution review.
Do not add revenue dashboards together without checking the underlying orders:
| Reconciliation item | Sales before refunds (USD) |
|---|---|
| Platform A claims | 70,000 |
| Platform B claims | 74,000 |
| Sum of claims | 144,000 |
| Orders claimed by both, deducted once | (24,000) |
| Unique matched sales | 120,000 |
The check is $70,000 + $74,000 − $24,000 = $120,000. Assign each unique order to one campaign for this example. A fractional method also works if all channel shares reconcile to the whole order.
Attribution is a credit rule. Google Analytics describes how credit is distributed across purchase-path interactions. This calculation therefore reports attributed ROI; a separate comparison is needed to establish purchases caused by social activity.
Prepare a worksheet named Orders: A order ID, B campaign, C original order date, D sales after discounts, E refunds through the cutoff, F variable costs and G contribution. In G2, filled down:
=D2-E2-F2
Variable costs include products sold, customer fulfillment and payment fees, net of recoverable returned inventory. The aggregated order file gives:
| Campaign | Sales before refunds (USD) | Refunds (USD) | Variable costs (USD) | Contribution (USD) |
|---|---|---|---|---|
| Paid acquisition | 50,000 | 2,000 | 26,000 | 22,000 |
| Community | 30,000 | 1,000 | 15,000 | 14,000 |
| Retargeting | 40,000 | 3,000 | 21,000 | 16,000 |
| Total | 120,000 | 6,000 | 62,000 | 52,000 |
To populate contribution for the campaign named in summary cell A2, use:
=SUMIFS(Orders!$G$2:$G$500,Orders!$B$2:$B$500,A2,Orders!$C$2:$C$500,">="&DATE(2026,9,1),Orders!$C$2:$C$500,"<"&DATE(2026,10,1))
Microsoft's SUMIFS documentation explains the multiple-condition sum used here. The date test uses the original order date, while the refund amount is already matched back to that order. Keep the reviewed date range large enough for the entire export.
Use campaign invoices, accruals and time records. Charge production and moderation time at an agreed loaded cost. Shared creative work needs a documented allocation, with the total charged only once.
| Campaign | Media (USD) | Creator cost (USD) | Production and labor (USD) | Total campaign cost (USD) |
|---|---|---|---|---|
| Paid acquisition | 6,000 | 2,000 | 3,000 | 11,000 |
| Community | 0 | 1,000 | 4,000 | 5,000 |
| Retargeting | 5,000 | 0 | 2,000 | 7,000 |
| Total | 11,000 | 3,000 | 9,000 | 23,000 |
With this table in columns A:E, enter this in E2 and fill down:
=SUM(B2:D2)
The community campaign has no media expense, but its cost is $1,000 + $4,000 = $5,000.
Use influencer marketing ROI for creator gifts and code overlap, and content marketing ROI for reusable production-cost allocation.
| Campaign | Contribution (USD) | Campaign cost (USD) | Contribution after campaign cost (USD) | Attributed ROI |
|---|---|---|---|---|
| Paid acquisition | 22,000 | 11,000 | 11,000 | 100.0% |
| Community | 14,000 | 5,000 | 9,000 | 180.0% |
| Retargeting | 16,000 | 7,000 | 9,000 | 128.6% |
| Total | 52,000 | 23,000 | 29,000 | 126.1% |
For this summary in A:E, enter D2 and E2, then fill through row 4:
=B2-C2
=IF(C2=0,NA(),D2/C2)
The combined ROI is:
=SUM(D2:D4)/SUM(C2:C4)
It returns 126.1%, rounded to one decimal place. The proof follows the complete money trail: $120,000 − $6,000 − $62,000 − $23,000 = $29,000. Divide that by $23,000. Do not average campaign percentages.
Social media marketing metrics covers the operating measures that help explain the financial result. Covirage is not affiliated with Google or Microsoft.
Bring your prepared order allocation, refunds, variable costs and campaign spending export. Covirage maps the columns, and its tools compute and check contribution and ROI; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See the supporting approach to customer profitability.
Yes. Include the staff time, creative production, editing and moderation used to run the activity. A campaign without media spend still consumes resources. Use a consistent labor allocation so paid and organic campaigns are compared fairly.
Only after checking overlap at the order level. Different platforms may claim the same purchase under different attribution windows. Reconcile their claims to unique orders and apply one agreed allocation rule before summing the campaign outcomes.
They describe audience response, but they are not customer contribution. Keep them as diagnostic measures alongside sales and cost. Assigning a dollar value to engagement requires a defensible business relationship, rather than an arbitrary amount per interaction.