Restaurant Marketing ROI: Campaigns After Food Costs

Restaurant marketing ROI compares the additional contribution a campaign creates with what the campaign costs. Start with net sales after discounts and refunds, deduct food and other variable costs, and then deduct campaign spend. If your file only identifies attributed orders, label the result an attributed contribution return until you have evidence of incremental demand.

1. Agree on the return you can measure

Incremental marketing ROI = (Incremental contribution before campaign spend − Campaign spend) / Campaign spend

Attributed contribution return = (Contribution from attributed orders − Campaign spend) / Campaign spend

Both ratios use contribution after food and other variable costs, before campaign spend. Only the first establishes what the promotion added beyond business that would have happened anyway. The distinction between revenue multiples and contribution returns is explained in marketing ROI versus ROAS.

Set the location, campaign dates, order eligibility and refund cutoff before calculating. Keep tax and tips separate from the sales amounts used for this operating comparison. Decide who approves food costs and shared campaign allocations so a higher return cannot simply reflect omitted expenses.

2. Prepare a location summary from existing exports

Start with completed POS orders carrying the agreed campaign identifier. Retain order IDs for checking duplicates and tracing refunds. Add food consumed by those orders and other variable fulfillment costs, using approved actual costs or clearly labeled estimates.

Then summarize campaign expense by location from advertising and accounting exports. Include campaign production costs once, and allocate shared costs using a documented rule. Do not repeat a campaign invoice on every order row.

The fictional US restaurant group below has prepared this summary. Gross sales precede discounts and refunds; other variable costs include the selected payment, fulfillment and additional labor costs. All amounts are USD.

Returns and allowances reduce gross sales in determining net sales, as IRS Publication 334 explains. The operating analysis here is not a replacement for your accountant's tax or financial reporting policies.

3. Calculate net sales, contribution and return

Put North in spreadsheet row 2 and South in row 3, with the column letters shown above. These Excel formulas use Microsoft's documented arithmetic operators. In H2, I2, J2 and K2 respectively, enter:

=B2-C2-D2
=H2-E2-F2
=I2-G2
=IF(G2=0,NA(),J2/G2)

Fill the formulas down and format K as a percentage. A campaign with zero recorded spend has no defined return ratio; check for missing expense rather than reporting an infinite return. Covirage is not affiliated with Microsoft.

Dollar results are exact; percentages are rounded to one decimal. North's calculation is (10,500 − 3,675 − 1,050 − 1,500) / 1,500 = 285.0%. South sells more but leaves less contribution after both order costs and marketing costs.

4. Prove the total before ranking locations

The sales bridge is 27,000 − 4,200 − 800 = $22,000. The cost bridge is 22,000 − 8,275 − 2,775 − 4,000 = $6,950 after campaign spend. Compare these summed fields with the campaign-filtered POS report and the expense records.

Calculate the total return from total dollars:

=SUM(J2:J3)/SUM(G2:G3)

The result is 6,950 / 4,000 = 173.8%, rounded. Averaging the location percentages gives each location equal influence despite different spending, so it does not prove the company result.

This is a campaign comparison. For a broader operating review across orders, costs and locations, use restaurant marketing analytics. For acquisition specifically, customer acquisition cost uses newly acquired customers rather than all attributed orders.

5. Check whether the campaign added enough business

North needs $1,500 of incremental contribution to cover its spend. That is 1,500 / 5,775 = 26.0% of its attributed contribution, rounded. South needs $2,500, or 2,500 / 5,175 = 48.3%. These are break-even thresholds, not estimates of what the campaigns caused.

To estimate incrementality, plan a comparison that addresses purchases guests would have made anyway. A properly designed randomized holdout is one approach; NIST's experimental-design guidance explains random assignment. Have the analyst responsible for the test assess uncertainty and whether guests can share offers across groups.

Until then, use the attributed results to investigate offer economics and choose a controlled next test. Improving marketing ROI starts with the specific cause of weak contribution rather than a universal spending target.

Where restaurant marketing ROI goes wrong

• Using gross receipts as profit. Food, discounts and fulfillment costs can change the ranking substantially.
• Subtracting the discount twice. Check whether POS sales are already net of the promotion.
• Calling attributed orders incremental. An offer code records redemption, including guests who already planned to visit.
• Mixing periods and cost policies. Match refunds and expenses to the campaign, and compare locations on the same approved cost basis.

Calculate returns from your own restaurant files

Bring a sample of your own POS sales, food-cost records and campaign expense exports to Covirage. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring your files.

See Covirage for hospitality for the supporting industry context.