Social Media Campaign Costs: Build a Fair ROI Worksheet

Keep three questions separate: what resources supported this campaign, what extra spending another run would require, and what cash must leave the bank. They can produce different totals without any arithmetic being wrong. Label the view you choose, preserve the evidence behind each entry, and apply the same boundary when comparing campaigns. Start with one reporting window and one currency.

Set the decision boundary before collecting receipts

The retailer wants to decide whether its two-week product promotion deserves another run. That is narrower than asking whether the entire business is profitable. Its worksheet includes preparation, distribution, campaign support, and the fulfilment costs associated with the reported sales. General business expenses remain outside this particular model unless an explicit, consistent allocation brings them in. Write that boundary at the top before anyone starts selecting convenient numbers.

Use the same currency and reporting window for every input. Photography paid for last month can support this promotion; a bill paid today can belong to next month. Record resource-use dates as well as payment dates. Include preparation before launch instead of treating the first public post as the beginning of the expense.

Also name the cost view. An allocated campaign view includes an agreed share of reusable resources and staff capacity. An incremental view asks what changes because the next promotion happens. A cash view helps schedule payments. The worked calculation uses the allocated view, with valued staff time and a share of existing assets.

Treat accepted net revenue as an input supplied by a separate sales reconciliation. This worksheet does not settle revenue attribution. It needs the revenue amount, its reporting period, and any known exclusions so costs can be matched sensibly. If the sales number is provisional, label the cost result provisional too. A carefully itemised expense sheet cannot turn an unsettled revenue figure into a reliable final return.

Build an evidence ledger that survives a handover

Use one row per cost item in a local worksheet. Useful columns are description, supplier or team owner, amount, currency, service date, invoice reference, calculator category, allocation basis, and status. Add a final column stating whether the amount is included in the variable percentage. That last field prevents a fulfilment invoice from quietly appearing once as a campaign expense and again inside the percentage applied to sales.

For the retailer, the fixed-cost rows are paid distribution of $600, creator fees of $300, production of $240, other campaign costs of $180, and staff time valued at $480. Production combines $160 of new editing with an $80 allocation of existing photography. Other costs combine a $150 landing-page adaptation with a $30 share of an existing software subscription. These descriptions explain the numbers better than a single miscellaneous total.

Attach evidence appropriate to the item: an invoice, a dated spending export, a time log, or a short allocation calculation. Mark estimates as estimates and give them an owner. A planned creator fee does not become an actual expense merely because the quote looked plausible. If scope changes, preserve the original estimate alongside the approved revision rather than replacing the history with whichever number makes the campaign look tidier.

Reconcile grouped entries before transferring them. A creator invoice might combine a fee and prop reimbursement; split entries must match its total. The sponsorship rate calculator supports a separate creator-budget discussion; this ledger records the agreed charge. Keep evidence locally. The ROI tool needs totals, not receipts or uploads.

Separate fixed campaign inputs from sales-linked costs

In this calculator, fixed means held constant within the chosen scenario. It does not mean permanently fixed for the business. The $600 distribution budget is a fixed campaign input even though the retailer could change it next week. The creator fee, production work, other campaign charges, and valued team hours also enter the fixed total. Together they describe the resources committed before applying the sales-linked fulfilment percentage.

Variable costs are modelled as a percentage of net revenue. For the retailer, the selected 35% covers the relevant product and fulfilment costs that are absent from the fixed rows. At $4,000 of net revenue, that becomes $1,400. The percentage should come from the actual product mix or a documented estimate, not from a generic claim about what a social campaign usually costs. A campaign selling different products may need a different rate.

Real expenses do not always follow revenue smoothly. Packaging depends on orders, delivery on destinations, and warehouse charges may jump at volume thresholds. Translate them into a defensible percentage for this case and document the limitation. If expected volume crosses a threshold, run a revised calculation. A constant percentage is not a supplier-price promise.

Avoid confusing a margin figure with a cost rate. A 65% contribution before campaign fixed costs corresponds to a 35% variable cost rate only when both use the same revenue base and expense boundary. Check the underlying components. If someone gives you a margin after marketing costs, converting it directly would pull campaign expenses into the model twice. Ask what the percentage includes before deciding where to enter it.

Allocate reused assets without disguising new spending

The retailer already owns a $400 photography set intended for five comparable promotions. Its agreed planning allocation is $80 per promotion. That share enters production alongside $160 of new editing, producing the $240 production input. The original $400 is not charged again to every campaign. The worksheet states the planned useful uses so another person can reproduce the allocation and challenge it if the photographs stop being useful sooner.

Allocation is a management convention, not a new payment. The next promotion might reuse the same photographs without another photography invoice. For an incremental decision, the retailer can exclude the $80 share while retaining any new editing needed. Similarly, its $30 share of an already committed subscription may disappear from the incremental view. With all other assumptions unchanged, allocated fixed costs of $1,800 become incremental economic fixed costs of $1,690.

The useful question is whether the next campaign changes the resource requirement. An extra software seat bought solely for the promotion is incremental; an unused portion of an existing subscription may not be. A reused image requiring a fresh licence can create a new cost even though the image itself is old. Record those distinctions explicitly. The label reused should never be shorthand for free, nor should allocated be shorthand for payable now.

Review the allocation periodically. If the photography supports only four promotions, show the revised basis and explain whether earlier comparisons are restated. Do not shift unused shares to the least successful campaign. For shared retainers and equipment, use a relevant allocation basis, reconcile the total, and record new cash commitments separately.

Value staff time as a resource, not a second invoice

The promotion uses 16 staff hours valued at $30 per hour, adding $480 to fixed campaign costs. Those hours include briefing, approvals, product answers, campaign coordination, and the final review. Logging only the minutes spent creating posts would miss much of the work. Use a lightweight record with task, person, date, and duration so the estimate is practical to maintain and useful when planning the next promotion.

Choose an hourly value that matches the decision. Loaded employment cost supports resource-use comparisons; a replacement rate helps estimate outsourced capacity. Opportunity cost asks what valuable work was displaced, but hypothetical lost sales are not automatically an hourly rate. Apply your documented basis consistently. The illustrative $30 is not a recommended market rate.

Do not value the same work twice. If the creator fee already pays an external editor, that editor should not also appear in internal team hours. If salaried staff time is represented through the hourly input, avoid adding the same salary share under other costs. Separate genuine overtime or another new cash charge when relevant, and document whether the hourly value already contains it. The ledger should make the treatment easy to inspect.

This distinction also explains the cash view. Removing the $110 of existing asset and software allocations plus the $480 internal time value leaves $1,210 of new fixed cash spending in this example, assuming those internal hours create no additional payroll payment. That is not the main ROI denominator. Staff capacity still matters when choosing what to repeat, especially if the campaign competes with customer service or another profitable use of the same working day.

Check refunds, fulfilment, and hidden double-counts

Enter revenue after discounts and refunds, excluding taxes collected for others. If the retailer starts from $4,500 and has $500 of relevant refunds or discounts, the accepted net input is $4,000. Do not then add the same $500 as an expense. The reduction has already lowered revenue. A refund can also leave genuine costs behind, but those are separate items: unrecovered delivery, handling, or damaged goods, for example, not the refunded selling price itself.

For this case, the documented fulfilment estimate totals $1,400 against the $4,000 net revenue base, giving 35%. Suppose a $120 packing bill is already included in that $1,400. Adding it to other campaign costs would count it twice. Either leave it in the variable pool or remove it from that pool and enter it separately, with the revised percentage. Reconcile the total rather than assuming the category names guarantee a clean separation.

Returns complicate percentage estimates because costs and net revenue move differently. A returned item may become saleable stock again while delivery remains unrecovered. Use the remaining relevant expense, not the original product cost plus returned stock value. If late returns change the relationship materially, update costs and revenue together. Retain the earlier snapshot to explain the change.

Finish with a duplicate pass across invoices and time logs. Check payment fees embedded in fulfilment, software charged directly and through an agency, or duplicated support labour. Bundled supplier invoices can also conceal omissions. Include each relevant resource once, with treatment consistent enough to compare another campaign, rather than pursuing perfect category names.

Turn the reconciled worksheet into ROI and break-even

Transfer the allocated case into the campaign ROI and break-even calculator: ads $600, creators $300, production $240, other costs $180, 16 team hours, and $30 hourly value. Fixed costs are $1,800. Enter net revenue of $4,000 and variable costs of 35%. Variable cost equals revenue multiplied by the rate: $4,000 times 0.35 is $1,400. Total modelled cost is therefore $3,200.

Modelled campaign profit is revenue minus fixed and variable costs: $4,000 minus $1,800 minus $1,400 equals $800. All-cost ROI is profit divided by total modelled cost, multiplied by 100: $800 divided by $3,200 gives 25%. It is not $800 divided by the advertising budget. ROAS uses that separate advertising denominator: $4,000 divided by the explicitly recorded $600 ad spend is about 6.67 times, a revenue ratio rather than profit.

Break-even net revenue equals fixed costs divided by one minus the variable rate. Here, $1,800 divided by 0.65 is $2,769.23, rounded for display. Each additional revenue dollar contributes 65 cents toward fixed campaign costs under these assumptions. If the reported 80 completed orders are consistent with the revenue figure, observed average order value is $50. Dividing the unrounded break-even revenue by $50 and rounding up gives 56 whole orders.

The order threshold assumes unchanged average order value and costs, not an acquisition forecast. This manual, browser-only calculator has no account scanner or analytics connection. Platform selection changes context, not formulas. Export a dated result and retain the worksheet separately. The tool does not persist your ledger or verify its evidence.

Compare the next run on a genuinely equal basis

Before ranking campaigns, align the cost view, revenue window, currency, team-time treatment, and fulfilment boundary. Comparing one campaign with all staff hours against another with invoices alone rewards missing records. The retailer can maintain allocated and incremental views side by side, but it should compare like with like within each view. A good comparison states both the result and the resource commitment needed to achieve it.

Use sensitivity to expose dependence on sales rather than manufacture a forecast. Holding fixed costs at $1,800 and the variable rate at 35%, revenue of $3,200 produces $1,120 variable cost, $280 profit, and about 9.59% ROI. At $4,800 revenue, variable cost is $1,680, profit is $1,320, and ROI is about 37.93%. These are the lower and higher arithmetic cases around $4,000, with no probability attached.

Then examine operational constraints that the percentage cannot show. The next promotion may require more approval time, a fresh licence, different delivery charges, or a creator commitment that cannot be cancelled. Update those inputs when the scope changes. Do not present the original fixed total as permanent simply because the same products are being promoted. Small, documented changes help distinguish a genuinely better workflow from a different accounting boundary.

Close with a decision and any missing evidence: repeat, revise production, reduce coordination time, or await invoices. The free tools directory provides adjacent planning utilities. Here, the useful output is a reproducible cost basis. Keep its version date and assumptions beside the exported ROI so another reviewer can understand the decision.

Questions about Campaign Costs

Continue with another campaign guide

Explore another sales context or review how you assemble costs and credit revenue. Return to the Social Media ROI Calculator to apply your inputs, or browse all free tools.