Revenue by Lead Report in Salesforce: Step-by-Step Guide (Lightning + Classic)

Have you ever wondered which leads are bringing the most revenue to your business? A large number of leads does not always mean more sales.

What really matters is how much revenue those leads generate after they are converted into opportunities and closed as deals.

The Revenue by Lead report in Salesforce helps you understand the financial value of your lead sources. It shows how much revenue is generated from converted leads, making it easier to identify which marketing campaigns, lead sources, or sales efforts are delivering the best results.

With this report, sales managers and marketers can make better decisions based on actual revenue instead of just the number of leads.

In this article, you will learn what the Revenue by Lead report is, how it works, how to create it in Salesforce, and when to use it with a real-world example.

By the end, you’ll be able to analyze lead performance and focus on the sources that generate the highest revenue for your business.

What is the Revenue by Lead Source Report in Salesforce?

The Revenue by Lead Source report in Salesforce helps you understand which lead sources are generating the most revenue for your business.

Instead of only showing how many leads came from each source, this report shows how much revenue those leads generated after they were converted into opportunities and successfully closed.

In simple words, this report answers one important business question:

“Which lead sources are generating the highest revenue for my business?”

This report helps both the Sales and Marketing teams measure the success of their lead generation efforts.

By analyzing revenue from each lead source, they can invest more in the channels that drive high-value customers and reduce spending on underperforming sources.

Real-World Example

Suppose your company receives leads from different sources, such as:

• Website
• LinkedIn Ads
• Google Ads
• Email Campaigns
• Trade Shows
• Partner Referrals

After a few months, you want to know which of these sources generated the most sales revenue. Instead of counting only the number of leads, the Revenue by Lead Source report shows the total Closed Won Opportunity Amount for each lead source.

This helps you identify the marketing channels that deliver the highest return on investment (ROI).

Important Point

Although the report is titled “Revenue by Lead Source,” it is not created using the Lead report type.

This is because revenue is stored on the Opportunity object, not on the Lead object. When a lead is converted, Salesforce copies the Lead Source value to the related Opportunity (if your conversion mapping supports it).

Therefore, you should create this report using the Opportunities report type and group the records by the Lead Source field. This gives you an accurate view of how much revenue each lead source has generated.

How Lead Source Connects Leads and Revenue in Salesforce

Before creating the Revenue by Lead Source report, it’s important to understand how Lead Source is connected to revenue in Salesforce.

Here’s the simple flow:

• A Lead represents a person or company who may be interested in your product or service.
• When the lead is qualified, it is converted into an Account, Contact, and optionally an Opportunity.
• The Opportunity is where your sales team tracks the deal, including the Amount, Stage, and Close Date.
• If the Lead Source value is copied to the Opportunity during lead conversion, Salesforce can identify the revenue source.

This is how Salesforce generates the Revenue by Lead Source report. The report groups Opportunities by the Lead Source field and sums the Opportunity Amount to show how much revenue each lead source has generated.

Example

Suppose you have the following converted leads:

The report will display:

• Website → $13,000
• Google Ads → $12,000
• LinkedIn → $7,000

This makes it easy to identify which lead source generates the most revenue.

Things to Check if Lead Source Is Not Showing Correctly

If your Revenue by Lead Source report is missing data or showing incorrect results, check the following:

• Make sure the Lead Source field is populated when new Leads are created.
• Verify that the Lead Source value is copied to the Opportunity during lead conversion. (The standard Lead Source field is automatically carried over to the Opportunity during conversion unless it is overwritten by automation or customizations.)
• Ensure your sales team uses consistent Lead Source values. For example, avoid using multiple values such as Website, Web Site, and Company Website for the same source, as they will appear as separate groups in the report.
• Confirm that your report includes the Opportunities you want to analyze, such as only Closed Won Opportunities for revenue reporting.

Following these best practices ensures that your Revenue by Lead Source report provides accurate and meaningful insights.

When Should You Use the Revenue by Lead Source Report?

The Revenue by Lead Source report is useful when you want to find out which lead sources are generating the most revenue for your business.

Instead of focusing only on the number of leads, this report helps you measure the actual sales value of each lead source.

Here are some common situations where this report is helpful.

Revenue by Lead Source Report – For Sales Managers

Sales managers often want answers to questions like:

• Which lead sources are generating the highest revenue?
• Which marketing channels should we invest more in next quarter?
• Are our paid campaigns bringing in Closed-Won Opportunities, or just creating leads?

With this report, they can make better business decisions based on revenue instead of assumptions.

Revenue by Lead Source Report – For Marketing Teams

Marketing teams can use this report to measure the success of different campaigns and lead generation channels.

For example, they can compare the revenue generated from:

• Website
• Google Ads
• LinkedIn Ads
• Email Campaigns
• Trade Shows
• Partner Referrals

This helps them understand which campaigns deliver the best return on investment (ROI) and where to allocate the marketing budget.

Revenue by Lead Source Report – For Salesforce Administrators and RevOps Teams

Salesforce Administrators and Revenue Operations (RevOps) teams use this report to provide accurate business insights to management.

Instead of showing only the number of leads from each source, they can create reports and dashboards that display the total revenue generated by each lead source. This gives leadership a clear view of which channels contribute the most to business growth.

Revenue vs Lead Volume

It’s important to choose the right report based on what you want to analyze.

• Use a Leads report when you want to know how many leads were generated from each lead source.
• Use an Opportunities report grouped by Lead Source when you want to know how much revenue each lead source has generated.

In short:

• Need to analyze lead count? → Use a Leads report.
• Need to analyze revenue by lead source? → Use an Opportunities report grouped by Lead Source.

Choosing the correct report type ensures that you get accurate data and meaningful business insights.

Step-by-Step: Create a Revenue by Lead Source Report in Salesforce Lightning

Now, let’s create the Revenue by Lead Source report in Salesforce Lightning Experience. This report will help you see how much revenue each lead source has generated by using Opportunity data.

Before we start creating the report, make sure your Salesforce org meets the following requirements.

Prerequisites

Before following the steps below, verify that you have the necessary permissions and that the required data is available.

• You have access to the Reports tab and permission to create or edit reports.
• You have access to the Opportunities object.
• The Lead Source field is available on the Opportunity object.
• Your Opportunity records contain the following information:
  • Amount
  • Close Date
  • Stage
  • Lead Source

Required Fields for the Revenue by Lead Source Report

• Amount is used to calculate the total revenue.
• Close Date allows you to filter the report by a specific time period, such as this quarter or this year.
• Stage helps you filter to only Closed Won Opportunities, so the report shows actual revenue rather than potential revenue.
• Lead Source is used to group Opportunities and identify which lead source generated the revenue.

Note: If the Lead Source field is blank on Opportunities, the report cannot calculate revenue by lead source. Make sure the Lead Source value is populated during lead conversion or when the Opportunity is created.

1. Open the Sales app and go to Reports

• Click the App Launcher (grid icon) in the top-left.
• Search for Sales and open the Sales app.
• In the navigation bar, click Reports.

2. Start a new Opportunities Report

• Click New Report.
• In the report type selector:
  • Search for Opportunities.
  • Select Opportunities as the report type.
• Click Start Report.

We’re using Opportunities because revenue (Amount) is stored there, not on Leads.

3. Apply the Filters for Revenue by Lead Source Report

In the report builder, set the filters for a standard revenue-by-lead-source view:

• Show Me: All Opportunities
• Close Date: Current Fiscal Year (or your preferred date range)
• Opportunity Status: Closed Won

You can tweak the date range depending on the question:

• Current Fiscal Year – for standard executive reporting.
• Last 12 Months – for rolling analysis.
• Last Quarter – for quarterly reviews.Common mistake:
  New admins leave Opportunity Status as “Open” or “All.” That mixes pipeline with closed deals, leading to confusing numbers in meetings.

4. Choose the Columns in the Report

Switch to the Outline tab.

Keep these columns (you can adjust based on your team’s needs):

• Opportunity Owner
• Account Name
• Opportunity Name
• Amount
• Close Date
• Stage (optional, but often helpful)

Remove noisy columns that don’t help answer “Which lead source generates revenue?”:

• Created Date
• Next Step
• Last Activity
• Type (unless your business specifically cares about it here)

5. Group by Lead Source in Report

Now we turn this into a revenue-by-lead-source view:

• In Outline, look at the left-side Fields panel.
• Drag Lead Source into the Group Rows area.

You should now see a summary row for each Lead Source value, with Opportunities listed under each group.

If Lead Source is missing or mostly blank:

• Confirm the field exists on Opportunities.
• Check if Lead Source is being mapped during Lead conversion.
• Talk to Sales/Marketing about cleaning up values and enforcing usage.

6. Check the Revenue Totals in the Report

By default, Salesforce summarizes the Amount field at the bottom and at the group level.

If you don’t see it:

• Click the dropdown on the Amount column.
• Make sure Summarize → Sum is selected.

You should now see totals like:

• Web: $450,000
• Partner Referral: $225,000
• Trade Show: $120,000

That’s your basic revenue-by-lead-source table.

7. Add a Chart in Report (recommended)

Charts turn this report into something your VP can drop straight into a slide deck.

• Click the Chart icon at the top-right of the report builder.
• Click the chart settings (gear icon).

Suggested starting point:

• Chart type: Funnel or Bar (Funnel looks good, but Bar is often easier to read.)
• Value: Sum of Amount
• Group: Lead Source
• Turn on:
  • Show Values
  • Show Percentages
  • Combine Small Groups (to avoid a long tail of tiny sources)

If your leadership prefers a different view, try:

• Bar chart for precise comparison.
• Donut chart for “share of revenue by lead source.”

8. Save and Name the Report

Click Save & Run, then fill in:

• Report Name: Revenue by Lead Source – Current Fiscal Year
• Report Unique Name: auto-filled.
• Folder: choose a shared folder your Sales/Marketing team can access, for example:
  • Public Reports
  • Sales Reports

Click Save.

You now have a working Revenue by Lead Source report in Salesforce Lightning, with a chart ready for dashboards and presentations.

Step-by-step: Revenue by Lead Source report in Salesforce Classic

If your org still uses Classic (some do, especially in legacy setups), you can build a similar report there.

1. Open the Reports Tab

• From the Classic UI, click the Reports tab.

2. Start a New Opportunities Report

• Click New Report.
• Select Opportunities as the report type.
• Click Create.

3. Apply Filters in Report

On the filter panel:

• Show: All Opportunities
• Opportunity Status: Closed Won
• Range: Current Fiscal Year (or the range your team wants)

4. Change the format to Summary

To group by Lead Source, we need a Summary format:

• Click the Tabular Format dropdown.
• Change it to Summary.

5. Group Rows by Lead Source

• In the Fields list, find Lead Source.
• Drag Lead Source into the area that says “Drop a field here to create a grouping.”

You now have groupings per Lead Source.

6. Add a Summary for Amount

If you want a custom summary column for clarity:

• In the left sidebar, under Formulas, click Add Formula.
• Drag it into the report.
• Set:
  • Column Name: Revenue
  • Formula: AMOUNT:SUM
• Click OK.

You’ll now see a Revenue column that summarizes the amount by Lead Source.

If you prefer, you can also just use the built-in summarize on the Amount column instead of a custom formula. The end result is similar for this use case.

7. Add a Chart to Report

To make the report easier to present:

• Click Add Chart.
• In the Chart Data tab:
  • Values: Revenue (or Sum of Amount)
  • Wedges/Groups: Lead Source
• In the Formatting tab, enable:
  • Show Labels
  • Show Values
  • Show Wedge %
  • Show Total

This gives you a visual breakdown of revenue by lead source, directly on the report.

8. Save and Run the Report

Click Save, then:

• Report Name: Annual Revenue by Lead Source
• Report Unique Name: auto-filled.
• Report Folder: a shared folder, like Unfiled Public Reports or a specific Sales folder.

Click Save and Run Report.

You now have a Classic version of the same insight: total revenue per lead source, chart included.

Common Mistakes and How to Avoid Them for the Revenue by Lead Source report in Salesforce

Here are the issues I see most often when helping teams in the U.S. set up this report:

• Starting from the Leads report type
  • Problem: Leads don’t store revenue, so you end up with lead counts, not revenue.
  • Fix: Always start from Opportunities for revenue reports.
• Mixing open and closed deals
  • Problem: Including open Opportunities inflates numbers and misleads leadership.
  • Fix: Filter to Opportunity Status = Closed Won for a clean revenue view.
• Inconsistent Lead Source values
  • Problem: Slight variations like “Web”, “Website”, “Website Lead” split the data.
  • Fix: Align on a standard picklist and clean up existing values.
• Missing Lead Source on Opportunities
  • Problem: Large “Unknown” bucket makes the report almost useless.
  • Fix:
    • Make Lead Source required on Leads.
    • Check field mapping during lead conversion.
    • Encourage reps to update Lead Source correctly.

Pro tips to make this report more powerful

Once the basic report is working, here are a few enhancements I often add for U.S. clients:

• Break it down by rep
  • Add Opportunity Owner as a secondary grouping.
  • You’ll see which reps perform best with which lead sources.
• Build a dashboard component
  • Add this report as a chart on a Sales or Marketing dashboard.
  • Use a bar or donut chart for exec-friendly visuals.
• Create a “Last 12 Months” version
  • Clone the report.
  • Change the Close Date filter to “Last 12 Months.”
  • You now have both a fiscal-year and a rolling view.
• Schedule email delivery
  • Subscribe your VP of Sales or Marketing Director to the report.
  • They’ll get an email every Monday morning with updated numbers.
• Compare channels year-over-year
  • Create one report for the current fiscal year, another for the previous fiscal year.
  • Put both on a single dashboard for a quick YoY revenue-by-channel comparison.

Which columns should I keep?

Here’s a simple guide I use when cleaning up the report layout:

You can always add more fields, but this keeps the report focused and readable.

Frequently Asked Questions

What to do next

If you’ve just built this report:

• Share it with your Sales and Marketing leaders.
• Ask them what additional cuts they care about:
  • By region (West Coast vs East Coast)
  • By segment (SMB vs Enterprise)
• Turn it into a dashboard component and consider scheduling a weekly email subscription so your team always has fresh numbers.

Once you’re comfortable with this, the natural next step is a Lead Conversion Rate report and a Sales Dashboard that brings both quantity (leads) and quality (revenue) into one view.

Conclusion

The Revenue by Lead Source report is one of the most valuable reports in Salesforce for understanding which lead sources generate the highest revenue. Instead of measuring success by the number of leads, this report helps you focus on the revenue those leads bring to your business.

In this article, you learned what the Revenue by Lead Source report is, how it works, why it is created using the Opportunities report type, and how to build it step by step in Salesforce Lightning.

You also learned the prerequisites, how Lead Source is connected to Opportunities, and the best practices for creating an accurate report.

If your organization relies on multiple lead-generation channels, creating a Revenue by Lead Source report is an excellent way to measure which channels contribute most to your company’s growth.

You may like to read:

• Create an Average Deal Report in Salesforce
• Create a report for weekly created opportunities in Salesforce
• Create a Lead Conversion Report in Salesforce

Bijay Kumar

I am Bijay Kumar, the founder of SalesforceFAQs.com. Having over 10 years of experience working in salesforce technologies for clients across the world (Canada, Australia, United States, United Kingdom, New Zealand, etc.). I am a certified salesforce administrator and expert with experience in developing salesforce applications and projects. My goal is to make it easy for people to learn and use salesforce technologies by providing simple and easy-to-understand solutions. Check out the complete profile on About us.