How to Measure the Sales and Revenue Generated by Each Marketing Channel

Most marketing teams can tell you how many clicks, form fills, or leads a campaign generated. Yet many still struggle to answer a more important question:

How many sales and how much revenue did each channel actually generate?

This distinction is fundamental. One channel can produce many leads at a seemingly attractive cost but generate few sales. Another can generate fewer opportunities but customers with a much higher average value.

To understand the true impact of marketing, you need to connect ad spend to business results. One of the best ways to do this is with a revenue attribution and ROAS-by-channel report.

What is a sales-by-channel report?

A sales-by-channel report connects data from platforms like Google Ads or Meta Ads with the information recorded in the CRM or sales system.

Its goal is to show, for each channel or campaign:

• How much was invested
• How many deals were closed
• What the average sale value was
• How much revenue was generated
• What ROAS the investment produced
• How much potential revenue remains open

Unlike a traditional paid media report, this analysis doesn’t end at the click, the form, or the lead. It follows the journey all the way to the business result.

It may also be known as:

• Revenue Attribution Report
• Paid Media Revenue Report
• Channel Performance Report
• Channel profitability report
• Sales attribution report
• ROAS-by-channel report

When the report organizes leads according to the month in which they were acquired and shows in which month they ended up converting into sales, it also incorporates a cohort analysis.

The problem with measuring only leads

Leads are a useful metric, but not all of them have the same value.

Suppose two channels produce the following results:

Channel	Leads	Sales	Revenue
Channel A	100	5	$10,000
Channel B	60	10	$35,000

If we only analyzed lead volume, Channel A would look superior. However, Channel B generated twice the sales and more than three times the revenue.

This shows why metrics like cost per lead or conversion rate must be analyzed alongside business information.

Lead volume measures activity. Revenue measures impact.

How the connection between marketing and sales gets lost

The journey of a sale usually involves several systems.

A person clicks on an ad, visits a landing page, and fills out a form or makes a call. That information enters the CRM, where the sales team begins follow-up.

The sale may close that same day, a few weeks later, or even several months later.

The problem appears when the original source isn’t preserved correctly. The CRM may record the customer’s name and the sale value but lose information such as:

• Channel
• Source
• Medium
• Campaign
• Ad group
• Keyword
• Landing page
• Click identifier

When that happens, marketing can report leads and sales can report revenue, but neither team can accurately demonstrate which campaigns generated the results.

A sales-by-channel report helps close that gap.

Key benefits of this type of report

1. It connects spend to real revenue

The main benefit is that it lets you stop evaluating campaigns solely with intermediate metrics.

Clicks, conversions, and leads are still important, but they don’t necessarily represent an economic result.

By incorporating CRM data, the report can answer questions like:

• Which channel generated the most revenue?
• Which campaign produced higher-value customers?
• Which source had a better close rate?
• How much money did each dollar invested produce?

This turns a marketing report into a tool for making business decisions.

2. It lets you calculate a sales-based ROAS

Return on ad spend is calculated with the following formula:

ROAS = attributed revenue ÷ ad spend

For example, if a campaign invested $10,000 and produced $40,000 in sales, its ROAS would be 4.0.

This means it generated four units of revenue for every unit invested.

ROAS allows you to compare channels with different investment levels. However, it shouldn’t be analyzed in isolation.

One channel can have a very high ROAS but generate little volume. Another can have a lower ROAS but produce a considerably larger amount of revenue.

That’s why it’s best to review together:

• Total revenue
• ROAS
• Closed deals
• Average sale value
• Acquisition cost

3. It shows how long a campaign takes to generate sales

Not all leads convert immediately.

A campaign run in March can produce sales in March, April, May, or June. If you only look at sales closed during the same month the leads were generated, its performance can look worse than it really is.

A cohort report lets you follow the evolution of each group of leads over time.

For example, a March cohort could have generated:

• $5,000 in sales during March
• An additional $8,000 during April
• $4,000 during May
• $2,000 during June

The total revenue for that cohort would be $19,000, even though only a portion of it closed during the initial month.

This analysis prevents cutting budgets too soon and helps you understand the real sales cycle.

4. It distinguishes between closed revenue and potential revenue

Recent cohorts tend to show less revenue because they still contain open opportunities.

That’s why it’s useful to separate:

• Closed revenue
• Potential revenue
• Current ROAS
• Potential ROAS

Closed revenue represents confirmed sales. Potential revenue represents opportunities that could still become customers.

This distinction provides context when evaluating recent campaigns.

A campaign with a low current ROAS could have a significant amount of open pipeline. If historically a meaningful proportion of those opportunities ends up closing, its final result could be much better.

5. It makes budget allocation easier

When the report shows revenue and profitability by channel, investment decisions stop being based solely on cost per lead.

The team can identify:

• Profitable channels with room to scale
• Campaigns with cheap leads but low quality
• Sources with higher-value customers
• Channels with longer closing cycles
• Campaigns with little revenue and little pipeline
• Areas where it’s worth increasing or reducing investment

This lets you allocate budget according to business results, not just form volume.

6. It improves collaboration between marketing and sales

Marketing usually focuses on acquisition. Sales focuses on follow-up, opportunities, and closes.

When each team uses different metrics, disagreements commonly appear.

Marketing may think a campaign is working because it generates many leads. Sales may think those leads aren’t high enough quality.

A shared report lets both teams work from the same source of information and answer more useful questions:

• Which campaigns generate qualified opportunities?
• Which sources have a better close rate?
• Which channels produce higher-value sales?
• How long does each source take to convert?
• Where are opportunities lost?
• Which campaigns need adjustments?

The report doesn’t just measure performance. It can also reveal problems in the sales process.

What this type of report looks like

Below is an illustrative example of how a sales-by-channel report organized by cohorts might look. Each row represents the month in which the leads were acquired, and the sales columns show in which month those deals ended up closing.

Illustrative example. The amounts are fictional and only meant to show the structure of the report.

Reading the table from left to right, we can follow the full journey: how many deals each cohort closed, how those sales were distributed month by month, how much was invested, and what ROAS it produced.

The June cohort illustrates very well why it’s worth separating closed revenue from potential revenue. At first glance its ROAS of 1.8 looks low, but it still holds $9,700 of potential revenue in open opportunities. If a meaningful share of that pipeline ends up closing, its potential ROAS rises to 3.2 and the picture changes completely.

Why separate branded and non-branded campaigns

In Google Ads it’s especially important to separate brand campaigns from generic ones.

Branded campaigns capture searches made by people who already know the company. They typically show:

• Low cost per click
• High conversion rates
• Higher purchase intent
• Very high ROAS

Non-branded campaigns aim to reach people who are researching a solution but aren’t yet searching specifically for the brand.

They tend to have:

• More competition
• Higher costs
• Longer decision cycles
• More moderate ROAS
• Greater ability to generate new demand

If both categories are combined, the excellent performance of branded can hide weak performance in non-branded.

Separating them lets you answer two different questions:

How efficiently do we capture existing demand?

and

How efficiently do we acquire new customers?

Both functions are important, but they shouldn’t be evaluated in exactly the same way.

What information the report should include

A useful report doesn’t need to show every available metric. It should include the ones that help you make decisions.

At a minimum, it’s worth incorporating:

• Acquisition month
• Channel or platform
• Campaign type
• Ad spend
• Closed deals
• Average sale value
• Attributed revenue
• ROAS
• Potential revenue
• Potential ROAS

It can also include metrics like cost per lead, cost per opportunity, close rate, and average time to convert.

The structure should adapt to the sales cycle and the business model.

How to build it

To develop this type of report you need to connect three layers of information.

Campaign data

This comes from platforms like Google Ads, Meta Ads, or Microsoft Advertising.

It includes spend, campaigns, ad groups, clicks, and conversions.

Acquisition data

This lets you identify how each lead arrived.

It can include:

• UTM source
• UTM medium
• UTM campaign
• UTM content
• UTM term
• GCLID
• Landing page
• Acquisition date

This information must be captured on the site and sent correctly to the CRM.

Business data

This comes from the CRM or sales system.

It includes:

• Deal status
• Close date
• Sale value
• Potential revenue
• Product or service
• Loss reason

These layers can be integrated using a spreadsheet, a visualization tool, or a data warehouse like BigQuery, depending on the volume and complexity of the data.

Define attribution clearly

Before using the report, you need to define what it means for a sale to belong to a channel.

Some common models are:

• First touch: attributes the sale to the first channel recorded.
• Last touch: assigns it to the last channel before the conversion.
• Lead source: uses the source that generated the lead.
• Opportunity source: attributes the sale to the channel that generated the business opportunity.
• Multi-touch: distributes the value across several interactions.

There’s no perfect model for every company.

What matters is that the methodology is clear, consistent, and understood by marketing, sales, and leadership.

From historical report to forecasting tool

With several months of information, the report can also be used to project results.

For example, it’s possible to calculate:

• What percentage of revenue closes during the first month
• How much revenue appears after 30, 60, or 90 days
• Which channels have longer sales cycles
• What proportion of the pipeline usually converts
• What the final ROAS of a recent cohort might be

If historically a cohort generates only 60% of its revenue during the first 30 days, a month that currently shows $30,000 could end up close to $50,000 once the opportunities mature.

This lets you evaluate recent campaigns with more context.

Measure what really matters

A sales-by-channel report doesn’t replace marketing metrics. It puts them in perspective.

Clicks help measure interest. Conversions show response. Leads represent opportunities.

But revenue shows the real impact on the business.

When the ad platforms, the website, and the CRM are properly connected, marketing can stop reporting only activity and start demonstrating results.

The question stops being:

How many leads did we generate?

And becomes:

Which campaigns are generating customers, revenue, and profitable growth?