A useful marketing ROI calculation should show more than ad revenue divided by ad spend. This guide gives you a repeatable worksheet for including media, creative, software, labor, attribution, conversion, refunds, and recurring revenue so you can compare forecasted and realized campaign performance with greater consistency.
Overview
Marketing ROI measures whether the value created by a campaign justified the resources used to run it. The difficult part is not the arithmetic; it is deciding which costs and outcomes belong in the calculation.
A simple revenue-based formula is:
Revenue ROI = (Attributed revenue − total campaign cost) ÷ total campaign cost × 100
This is useful for a quick view, but it can overstate performance when a sale includes fulfillment costs, payment fees, refunds, discounts, or ongoing service costs. A more decision-ready version uses contribution profit instead of revenue:
Contribution ROI = (Attributed contribution profit − total campaign cost) ÷ total campaign cost × 100
Contribution profit is the revenue that remains after variable costs directly connected to the sale. Depending on your business, those costs may include production, fulfillment, payment processing, commissions, customer support, or usage-based infrastructure.
Keep the calculation consistent across campaigns. If one campaign uses gross revenue and another uses profit after refunds and fees, the percentages are not directly comparable. For a reusable planning workflow, pair the calculation with a consistent UTM tracking and attribution setup.
How to estimate
Start by defining the campaign, the measurement window, and the outcome you are evaluating. A campaign might be a product launch, a paid acquisition flight, a newsletter sponsorship, a creator promotion, or a waitlist campaign that later produces sales.
- Set the campaign boundary. Record the channels, dates, audience, offer, landing page, and conversion event. Do not combine unrelated activities unless you intend to evaluate them as one program.
- Choose the outcome. Use revenue for a top-line view, contribution profit for a financial view, or qualified leads and subscribers for an early-stage demand-capture view. A waitlist signup is not the same outcome as a paid customer.
- Set the attribution window. Decide how long after a click, view, signup, or exposure a conversion can be associated with the campaign. Document the rule rather than changing it after seeing the result.
- Estimate conversions. For a funnel, multiply the relevant stages: visitors × signup rate × activation rate × purchase rate. For an existing customer list, use the actual eligible audience and expected conversion rate.
- Calculate value. Multiply conversions by average order value or expected customer value, then subtract discounts, refunds, and variable costs where appropriate.
- Subtract the complete campaign cost. Include obvious expenses such as media and less visible inputs such as internal labor, production, tools, and commissions.
- Compare forecast with actuals. Keep the original estimate unchanged, then create a second version using realized spend, conversions, revenue, refunds, and costs.
For recurring products, separate first-period revenue from expected customer value. A campaign can produce positive revenue ROI immediately while taking longer to recover its acquisition cost on a contribution basis. Use a pricing and revenue scenario model when tiers, discounts, or retention assumptions materially affect the result.
Inputs and assumptions
Costs to include
Use one currency and one time period. Your worksheet should have separate lines for:
- Paid media, sponsorships, affiliate commissions, and creator fees
- Creative production, editing, design, photography, and copy development
- Landing page, email, analytics, automation, and other campaign software costs
- Internal labor, calculated from hours multiplied by an agreed hourly cost
- Freelance, contractor, agency, or production expenses where applicable
- Discounts, promotional credits, sales commissions, payment fees, refunds, and chargebacks
- Fulfillment, onboarding, customer support, or usage costs that increase with each customer
Do not hide labor inside a general overhead line if you want to understand campaign efficiency. You can maintain two views: a cash-cost ROI using money actually paid and a fully loaded ROI that includes internal time. Both can be valid, but label them clearly.
Conversion and revenue inputs
Record impressions or reach only when they help explain the funnel. The financially important inputs are usually visits, conversion rate, leads, qualified leads, customers, average order value, recurring revenue, refunds, and variable cost per customer.
For a one-time offer:
Net revenue = customers × average order value − discounts − refunds
For a subscription offer, decide whether the model uses first-period revenue, a defined number of paid periods, or expected customer value. Avoid presenting an indefinite lifetime value as realized revenue. State the retention, churn, upgrade, and billing assumptions used to create the estimate.
Attribution and measurement limits
Attribution is an allocation rule, not a complete record of causation. A person may encounter several channels before converting, use multiple devices, delete cookies, block tracking, or convert after an offline conversation. Platform-reported conversions can also differ from analytics, CRM, and payment records because each system has different identifiers, windows, and counting rules.
Choose a primary source of truth for revenue, usually the payment system or CRM, and use analytics platforms to explain the path. Record whether the result is based on first-touch, last-touch, position-based, self-reported, or another model. If uncertainty is material, show a range rather than a single precise number.
Fill-in worksheet
Copy these fields into a spreadsheet or marketing ROI calculator:
- Campaign name and dates
- Channels and attribution model
- Attribution window
- Ad and sponsorship spend
- Creative and production cost
- Software and platform cost
- Internal labor cost
- Other campaign costs
- Total campaign cost
- Audience or visitors
- Conversion rate at each funnel stage
- New customers or qualified leads
- Average order value or recurring revenue
- Discounts, refunds, and chargebacks
- Variable cost per order or customer
- Attributed revenue
- Attributed contribution profit
- Revenue ROI and contribution ROI
- Customer acquisition cost: total acquisition cost ÷ new customers
Worked examples
Product launch
Assume a launch produces 1,000 landing-page visitors and a 4% purchase rate, resulting in 40 customers. The average order value is $120, so gross sales are $4,800. Customers receive $200 in total discounts, and refunds total $240, leaving $4,360 in net revenue.
Campaign costs are $1,500 in paid media, $600 in creative production, $300 in software, and $600 in internal labor: $3,000 total. If variable costs are $20 per customer, contribution profit is $4,360 − $800 = $3,560. Contribution ROI is ($3,560 − $3,000) ÷ $3,000 × 100, or approximately 18.7%. CAC is $3,000 ÷ 40, or $75 per customer.
The revenue-only view would be higher, but the contribution view is more useful for deciding whether to repeat the launch.
Newsletter campaign
Assume a newsletter sponsorship costs $800 and produces 2,000 visits. A 3% signup rate creates 60 subscribers. If the campaign is intended only to grow a list, immediate sales ROI may be zero or incomplete. Instead, record cost per subscriber: $800 ÷ 60 = $13.33.
To evaluate financial return later, define a follow-up window and connect subscribers to a future offer. If 10 of those subscribers eventually purchase a $90 product, with $150 in refunds and discounts combined, net revenue is $750 before variable costs. You can then calculate realized ROI, while keeping the original subscriber-acquisition result separate.
Creator campaign
Suppose a creator receives $1,200 for a promotion and the campaign adds $400 in editing and landing-page costs. Total campaign cost is $1,600. It generates 25 sales at $100 each, or $2,500 in gross revenue. After $100 in discounts and $250 in refunds, net revenue is $2,150. If variable costs are $15 per order, contribution profit is $1,775. Contribution ROI is ($1,775 − $1,600) ÷ $1,600 × 100, or approximately 10.9%.
If the creator also generates qualified leads or assisted conversions that are not captured by the primary link, report those separately rather than silently adding them to attributed sales.
When to recalculate
Recalculate the model when campaign pricing, media costs, software fees, staffing, conversion rates, average order value, discount rules, refund rates, or variable costs change. Also rerun it after the attribution window closes and late conversions or refunds have been recorded.
For an active launch, review the forecast before spending, at a midpoint when enough data exists to adjust the funnel, and after the agreed measurement window. For an evergreen newsletter or creator funnel, review monthly or at each promotion cycle. For recurring products, perform a later cohort review after enough billing periods have passed to test retention and customer value assumptions.
Keep three versions in the worksheet:
- Forecast: the assumptions used to approve the campaign.
- Early read: current performance, clearly marked as incomplete.
- Realized result: final revenue, refunds, costs, and attributed conversions.
Finally, write down what changed between the versions. Was traffic lower, did the landing page convert differently, or did discounts reduce contribution profit? That short explanation turns a marketing ROI calculator from a reporting exercise into a planning tool. Before your next launch, pair the worksheet with a launch landing page copy framework and an analytics map so the inputs you need are captured from the start.