Customer Acquisition Cost for Restaurants

Customer acquisition cost for restaurants divides acquisition spending by distinct identified first-time purchasing customers. Count people you can link to a completed purchase, rather than reservations, covers, or delivery transactions. Then compare the acquisition cost with contribution from the same customers' initial and repeat purchases.

Define an acquired diner before counting

Use an identified purchasing customer as the unit. A customer appears once, at their first qualifying completed purchase across the restaurant group's linked channels. The number of people seated at the table does not establish the identities of additional acquired customers.

Keep a canceled reservation or no-show out of the denominator. Exclude refunded or canceled orders under a documented policy. Decide whether the boundary is one location, one brand, or the whole restaurant group; someone new to a location may already be a group customer.

The general customer acquisition cost article explains the common formula. Here the work is proving first-time status from restaurant records and keeping channel costs consistent.

Gather purchase, customer, and spending files

Use the point-of-sale check export, customer or loyalty directory, direct-order history, delivery settlements, and acquisition spending ledger. Keep completed purchase timestamp, transaction ID, supported customer key, channel, location, net sales, and included variable costs.

Use existing supported identity links between those files. A delivery customer's first order through that platform does not establish that they have never visited the restaurant. If the platform export cannot support matching to restaurant purchase history, keep those transactions outside restaurant-wide new-diner CAC.

Also separate acquisition spending from the cost of serving orders. DoorDash describes its commissions and fees as supporting customer access, delivery logistics, support, and merchant tools. That mixed purpose is a reason to state your own measurement policy, rather than assuming every platform fee is acquisition spending.

Identify first purchases in Excel

On Orders, place the supported customer key in A, completed purchase timestamp in B, transaction ID in C, and purchase channel in D. Use all available qualifying history, sorted by timestamp and transaction ID. In H2, find the customer's earliest recorded purchase:

=IF(A2="","",MINIFS($B$2:$B$10000,$A$2:$A$10000,A2))

Microsoft's MINIFS documentation describes finding the minimum value that meets the specified conditions. With spreadsheet date values, that gives the earliest qualifying timestamp for a customer key.

In I2, flag one first-purchase row even when timestamps tie:

=IF(OR(A2="",B2<>H2),0,--(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)=1))

Fill both formulas down. With a channel label in Summary!A2, count January 2026 acquisitions:

=COUNTIFS(Orders!$D$2:$D$10000,A2,Orders!$I$2:$I$10000,1,
 Orders!$H$2:$H$10000,">="&DATE(2026,1,1),
 Orders!$H$2:$H$10000,"<"&DATE(2026,2,1))

Expand the ranges to cover the export. Customers whose first known purchase predates January are excluded even when they order during January. If history is incomplete, label the measure new to the available records. Covirage is not affiliated with Microsoft or DoorDash.

Work acquisition spending by channel

Consider an illustrative US restaurant group's January cohort. Every customer in this comparison has a supported identity across the relevant restaurant history. Channel means the first completed purchase channel, retained for all subsequent cohort purchases.

The promotion column contains acquisition-event staffing and welcome-item costs, excluded from the food and labor costs in the contribution table below. Price discounts already reduce net sales and are not added to acquisition spending again. Recurring delivery commissions are treated as variable order costs below.

For columns A:F, enter in D2 and F2, then fill down:

=SUM(B2:C2)
=IF(E2=0,NA(),D2/E2)

Total CAC is =SUM(D2:D3)/SUM(E2:E3): 3,300 / 150 = $22.00. Display dollars to two decimal places and retain full precision in calculations. Channel counts must sum to the deduplicated acquired-customer list, and spending must reconcile to the acquisition-classified ledger.

Compare contribution from initial and repeat visits

Follow each acquired customer for their first 90 days, including their first purchase. Include delivery customers' later direct purchases when the identity match supports it. Every customer must complete the observation window before this comparison is final.

Contribution in F2 is =B2-SUM(C2:E2). The final column subtracts the matching channel's acquisition spending: =F2-Summary!D2 if the acquisition table is on Summary. The total check is 14,100 - 4,230 - 2,820 - 1,650 - 3,300 = $2,100.

Delivery covers acquisition spending within this window but leaves no contribution afterward. This is an observed period result, not lifetime value. Unit economics places the measure within the customer P&L, while CAC payback addresses how long contribution takes to recover acquisition spending. Use CAC by industry before making external comparisons.

Where it goes wrong

• Orders become customers. Repeat purchases inflate the acquired-customer denominator.
• Platform identities become restaurant identities. A platform's new customer may already be your regular diner.
• Promotions are deducted twice. Discounts in net sales and acquisition spending would overstate total cost.
• Anonymous coverage is hidden. Report excluded checks and sales so channel comparisons show their limits.

Compare your restaurant files in Covirage

Upload your completed-check history, customer mapping, delivery settlement, and acquisition spending file or Google Sheet. Covirage maps the columns; its tools compute and check acquisition costs and observed contribution, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for hospitality for the industry context.