How to calculate advertising ROI when a lead is not yet a sale

Define the cohort and reporting cutoff

State which inquiries you are evaluating and when their outcomes were last checked. A later sale updates the original inquiry’s outcome without moving it into a different acquisition cohort.

Do not automatically divide all sales in a month by that month’s ad spend. Some sales originated earlier or through other channels. Use consistent currency, time zones and treatment of refunds and discounts. Record cash received separately from recognized sales.

Reconcile inquiries and verified sales

Use one opportunity record and an identifiable sale reference to avoid duplicates. Define qualification consistently using service fit, coverage and usable contact information. A qualified inquiry can still close without a sale.

Keep receipt date, known campaign origin, stage, close date and confirmed amount. Platform conversion values may represent revenue, margin or estimated lead value. Check the configuration before treating a form’s assigned value as revenue.

Sources: Google Ads: Conversion values

State the denominator for every return metric

Revenue ROAS divides attributed revenue by ad spend and excludes service delivery, management and production costs. ROI on included costs subtracts direct sales costs and acquisition costs, then divides the balance by their combined total.

Return on acquisition uses the same balance but divides only by included acquisition costs. Both can be useful, but they answer different questions. Neither is company-wide net profitability if overhead or taxes remain excluded.

• Revenue ROAS = attributed revenue / ad spend.
• Balance = revenue minus direct sales costs minus acquisition costs.
• ROI on included costs = balance / (direct costs + acquisition costs) × 100.
• Return on acquisition = balance / acquisition costs × 100.

Sources: Google Ads: Return on investment (ROI) · Google Ads: Conversion values

Worked example: 3.33x ROAS with no remaining balance

This example is entirely hypothetical, in USD, and does not represent client performance or market averages. Spend is $1,500 on ads, $300 on management and $200 on creative. There are 100 unique inquiries, of which 80 qualify: 10 become sales, 30 close without a sale and 40 remain open.

Ten sales at $500 produce $5,000 in revenue. Direct costs of $300 per sale total $3,000, leaving $2,000 before acquisition. Acquisition costs consume that entire $2,000. Both return measures are 0%, while revenue ROAS is $5,000 / $1,500 = 3.33x. Overhead and taxes are still excluded.

Ad cost per qualified inquiry is $18.75, while total acquisition cost per completed sale is $200. Those measures use different costs and outcomes; do not treat them as the same CPA.

Keep open opportunities separate from revenue

The 40 open opportunities need follow-up. A forecast may use a defensible historical close rate, but should remain separate from confirmed sales.

If three additional $500 sales later close, each with $300 in direct costs and no additional acquisition costs, the balance becomes $600. Return on acquisition is 30%; ROI on included costs is approximately 10.2% ($600 / $5,900). This is a hypothetical future outcome, not current revenue.

Account for conversion delay and whether platform columns use interaction dates or conversion dates. Revisit the cohort on a schedule consistent with the sales cycle.

Sources: Google Ads: Conversion lag reports · Google Ads: Understanding conversion tracking data

Explain attribution limits

Record the attribution model and lookback window. Reconcile platforms before combining their attributed sales: the same transaction may appear more than once.

Attribution assigns credit; it does not establish that a sale would not have occurred without advertising. Incremental-impact claims require an appropriate measurement design. You can still identify duplicated sales, omitted costs and neglected inquiries without solving every attribution question.

Sources: Google Analytics: Selecting attribution settings · Google Ads: About Conversion Lift

Use the calculator with a consistent cost scope

The Patagonia Paid Media ROI calculator estimates clicks, leads and sales from your inputs. Its return calculation uses gross margin and divides the remaining balance by ad spend plus management fees. This matches the acquisition-return convention for those specific costs.

It does not import actual sales or separately include creative, refunds, taxes and other operating costs. The example above needs an additional record for its $200 creative cost. Align denominators and included costs before comparing percentages. Use the calculator to explore scenarios after reconciling actual results.

Close the report with a decision

If sales outcomes are missing, fix follow-up first. If costs erase the margin, review the offer and acquisition economics. If outcomes remain provisional, set the next review date.

• Acquisition period and cutoff are documented.
• Received, qualified, open and closed inquiries have consistent definitions.
• Included sales are verified and deduplicated.
• Pipeline estimates remain separate from realized revenue.
• Costs, allocation rules and denominators are explicit.
• Currency, adjustments and exclusions are documented.
• Attribution limits and unknown origins remain visible.
• The next action has an owner and a review date.