# Why ad revenue and ad profit need separate columns

Follow a fictional campaign from attributed revenue to contribution after advertising. Learn what ROAS includes here and what your business still has to pay.

By Ryan Nichols | The LeadFlow Pro | Published 2026-09-06

Current guide: https://www.theleadflowpro.com/articles/why-ad-revenue-and-ad-profit-need-separate-columns

An ad dashboard can show a big revenue number while the bank balance tells a more complicated story. The missing step is often simple: the revenue and the cost of serving those customers were never put on the same page.

You do not need a complicated report to start. You need clear definitions, matching dates, and separate columns for revenue, delivery costs, marketing costs, and what remains.

## Decide what belongs in the comparison

Choose a campaign or a clearly defined group of campaigns. Use one reporting period. Write down whether the revenue figure represents signed work, completed work, or money actually collected.

Those figures can all be useful, but they answer different questions. A signed project that will be paid over several months should not be described as cash already available today. Refunds and cancellations also need a consistent treatment.

Attribution needs a definition as well. If two systems each take credit for the same sale, adding their claimed revenue together can count that sale twice. Keep the order or job references available for reconciliation without putting private customer details into a public worksheet.

## Work through these fictional numbers

Imagine $1,000 in advertising spend and $200 in agency or other marketing fees. The campaign has $4,000 in attributed revenue. The gross margin before those marketing costs is assumed to be 40 percent.

This calculator combines the spending and fees into a $1,200 marketing cost. Its ROAS is $4,000 divided by $1,200, or about 3.33 times.

An advertising platform using only the $1,000 ad spend as its denominator could show 4.00 times for the same revenue. Neither display tells the full story by itself. First check what each one includes.

At a 40 percent gross margin, the $4,000 revenue leaves $1,600 before marketing costs. Subtracting the $1,200 marketing total leaves $400 in modeled contribution.
## Try the Ad Spend & ROAS Calculator

Start with the illustrative example, then use clearly defined figures from your own records. The tool is free; the notes below explain what its outputs do and do not mean.

Open the working tool: https://www.theleadflowpro.com/tools/roas-calculator

1. **Choose matching records.** Use ad spending, attributed revenue, and fees from the same campaign scope and period. Note whether revenue is booked, collected, or adjusted for refunds.

2. **Enter a margin before advertising.** Gross margin should reflect the delivery costs included in your calculation before the marketing costs entered separately. Avoid subtracting the same expense twice.

3. **Inspect the denominator.** This tool includes the entered agency or other fees with ad spend when calculating ROAS. A platform that uses ad spend alone will show a different ratio.

4. **Read contribution carefully.** Subtract total marketing costs from modeled gross profit. Then list overhead, timing, and other costs excluded before calling anything net profit.

### How to read your result

- The ROAS ratio here is attributed revenue divided by ad spend plus fees. It is not necessarily the same ratio shown in your ad account.

- The contribution result is what remains after the entered delivery margin and marketing costs. It does not include every business expense or prove the campaign caused the sales.
## Name the remaining money honestly

The $400 result is not automatically the business's net profit. It still depends on which costs were included in the margin and which expenses remain outside the calculation.

Rent, office staff, financing costs, taxes, and other overhead may not be covered. Some delivery expenses may change with job size or volume. Write down the exclusions instead of allowing a label to make the estimate sound more complete than it is.

The calculator also shows a break-even ROAS of 2.5 times at a 40 percent gross margin. That follows from one divided by 0.40. It is the ratio needed for modeled gross profit to equal the entered marketing costs, before excluded expenses. It is not a universal target for your business.

## Change one assumption before changing a budget

Keep revenue and marketing costs the same, then lower the assumed margin to 30 percent. Gross profit becomes $1,200 and modeled contribution becomes zero. The headline revenue has not changed, but the amount left after these costs has.

That is a useful sensitivity check. It shows why a sales promotion with different fulfillment costs should not automatically inherit the margin from ordinary jobs.

Use your own historical range rather than a convenient best case. If you do not yet know the delivery margin, mark it as an estimate and make confirming it the next step.

```text
CAMPAIGN CONTRIBUTION CHECK
Campaign and date range:
Revenue definition:
Attribution method and possible overlaps:
Attributed revenue:
Ad spend:
Additional marketing fees:
Gross margin before marketing:
Costs included in that margin:
Modeled contribution after marketing:
Expenses still excluded:
Refunds, collections, or timing issues:
Records to reconcile and review date:
```

## Turn the result into a better question

If the result disappoints, identify which part deserves investigation: acquisition cost, job value, delivery margin, or the reliability of attribution. Changing everything at once makes it harder to learn what helped.

If the result looks strong, check whether the same assumptions would hold at a different volume. A calculator cannot establish that future leads will arrive at the same cost or that the team can serve them without extra expense.

[Use the ROAS Calculator](https://www.theleadflowpro.com/tools/roas-calculator) to create a comparison you can explain in plain English. Keep the revenue number. Just give it the cost columns it needs.

## Questions people ask

### Why is this ROAS different from my advertising dashboard?

The denominator may differ because this calculator includes fees. Attribution windows, revenue definitions, refunds, and campaign dates can also differ.

### Does a positive result mean I should increase spending?

No. Check actual attribution, collected revenue, capacity, cash timing, and how costs may change before making that decision.

### Can I use revenue from every customer that month?

Only if that matches the scope you are deliberately measuring. Mixing all business revenue with one campaign's spending can make the campaign look stronger than the records support.

---

Created by The LeadFlow Pro. When sharing this guide, keep the source link so the next person can find the working tool and latest updates.

https://www.theleadflowpro.com/articles/why-ad-revenue-and-ad-profit-need-separate-columns