If you're only looking at total revenue, you're missing the real story. True sales by product reporting isn't just a nice-to-have; it's a core component of a high-performing RevOps strategy that reveals which offerings are driving scalable growth. For B2B companies using Salesforce or HubSpot, this analysis is the key to engineering a more efficient Go-to-Market (GTM) motion.
Why You Need to Go Deeper Than Total Revenue
Most companies can state their top-line revenue. But that single metric obscures critical operational insights. When you analyze sales by product, you transform reporting from a simple accounting exercise into a strategic GTM engineering tool. It’s how RevOps, sales operations, and marketing operations leaders using platforms like Salesforce or HubSpot get precise answers to their most pressing questions.
This analysis tells you:
- Which products have the highest win rates and shortest sales cycles.
- Which offerings are most effective for new logo acquisition versus expansion revenue.
- How different customer segments or industries adopt specific products.
Here's a scenario I’ve seen firsthand. A B2B SaaS company believed its expensive, all-in-one flagship product was its primary growth engine. Once we implemented proper product-level reporting in their CRM, the data told a different story. A much cheaper, simpler offering actually had a 50% shorter sales cycle and a significantly higher win rate with net-new logos. That single insight was a complete game-changer.
They re-engineered their GTM strategy, shifting marketing spend and sales training. The data reshaped everything from sales compensation to resource allocation, creating a far more efficient machine for winning new business.
This level of clarity is essential, especially as markets tighten. Recent benchmarks in Canada's B2B SaaS space show a stark drop in efficiency. Sales and marketing dollars that once generated a 6.08x revenue multiple now only bring in a median of 3.19x. You can read more about these startup benchmarks on LighterCapital.com.
In this environment, precise pipeline visibility and optimized operations are what separate market leaders from the rest. Without granular sales by product data, you’re making critical strategic decisions with incomplete information. It’s the foundation you need to build a predictable, optimized revenue engine.
Building a Rock-Solid CRM Data Foundation
Accurate sales by product reporting starts with a clean, well-structured data model. Think of your CRM as the architectural blueprint for your revenue engine; if the foundation is cracked, the entire structure is unstable. For any RevOps or sales operations leader, this means auditing your Salesforce or HubSpot instance to ensure it is configured to capture product-level details with absolute precision.
Before you can build a useful dashboard, it's worth taking a step back and truly understanding what a Sales CRM entails and how it should centralize this information. Get this wrong, and every report you pull will be based on guesswork, not data.
The Core Objects for Product-Level Tracking
Success here depends on using a few essential objects correctly and ensuring they’re properly linked. Let's break down the key components in both Salesforce Sales Cloud and HubSpot Sales Hub.
To get a clear picture of how this works, here's a look at the essential CRM objects and their roles in both platforms.
Essential CRM Objects for Product Sales Reporting
| Object | Salesforce Name | HubSpot Name | Core Function |
|---|---|---|---|
| Product Catalog | Product | Product Library | The master list of every SKU you sell. A clean, standardized catalog is non-negotiable. |
| Pricing | Price Books | Price | Defines the cost of each product. Salesforce's Price Books are ideal for managing different price lists. |
| Deals | Opportunity | Deal | Represents the sales opportunity. This is the container for the entire transaction. |
| Deal Components | Opportunity Products | Line Items | The individual products or services being sold within a single deal. This is where the magic happens. |
These objects are the building blocks of granular reporting. The relationship between an Opportunity/Deal and its associated Opportunity Products/Line Items is what unlocks everything. A deal’s total value should always be the sum of its line items—not a number entered manually.
Preventing Common Data Entry Pitfalls
The most common point of failure is when a sales rep manually enters a total deal value on the Opportunity or Deal record but skips adding the individual products that comprise that total. This one bad habit completely torpedoes any chance of accurate product performance analysis.
The most effective way to enforce data hygiene is to make the system work for you. Your goal should be to make it impossible for a rep to close a deal without specifying which products were sold.
Fortunately, you can engineer your CRM to prevent this.
In Salesforce, you can use a validation rule that prevents a user from moving an Opportunity stage to "Closed Won" if there are no associated Opportunity Products. It’s a simple but powerful guardrail.
In HubSpot, you can achieve the same result by making Line Items a required association for Deals in certain pipeline stages. This can be managed through workflow automation or pipeline settings, effectively forcing reps to add products before a deal can be considered closed.
We've found that improving your CRM's underlying data structure is a critical first step. For a deeper dive, you can learn how to improve data quality in our detailed guide. Implementing these guardrails is essential for building a data foundation you can trust.
Creating Your Core Sales by Product Dashboards
With your data foundation solid, it's time to turn those numbers into dashboards that guide strategy. This is where the effort in data hygiene pays off, enabling you to build clear, actionable views for leadership, sales, and product teams.
We’ll walk through building these essential reports in both Salesforce and HubSpot. The goal isn't just to display data, but to construct a narrative that answers critical business questions at a glance.
Building Your Salesforce Product Report
Within Salesforce, the "Opportunities with Products" report type is your primary tool. This report type joins the Opportunity object with the individual Product records attached to it, which is exactly what we need.
To get started, create a new report using that report type. The setup is straightforward but powerful.
- Group rows by Product Name. This is the fundamental step that organizes the entire report around your offerings.
- Add key metrics. I always recommend pulling in the Sum of Quantity and the Sum of Total Price to see not just revenue but also sales volume for each product.
- Apply filters. This step makes the report truly useful. Always filter for Opportunity Status equals Closed Won and set a relevant Close Date range, like "Current Fiscal Quarter."
Once the report is built, add a chart for visualization. A horizontal bar chart is perfect for spotting your top-selling products by revenue instantly. To show revenue mix as a percentage, a pie or donut chart works well.
Creating a Custom Report in HubSpot
If you're operating in HubSpot, your journey starts in the custom report builder. For maximum control, build a custom report from scratch using Line Items.
You'll work with two primary data sources: Deals and Line Items. Joining these two allows you to pull details from both the high-level deal and the specific products sold within it.
Here’s a practical approach:
- Choose your data sources: Start a new custom report and select both Deals and Line Items.
- Configure the data: Set your X-axis to Product Name (from the Line Item properties). For the Y-axis, use Amount (also from Line Items) to measure revenue.
- Filter your data: Just as in Salesforce, this is crucial. Filter the Deal Stage to your equivalent of 'Closed Won' and set a Create Date or Close Date to define the timeframe.
Visualization is equally important here. HubSpot offers plenty of chart options; a column chart is a fantastic choice for comparing product performance side-by-side, giving you an immediate, clear picture of your revenue drivers.
For a deeper look into effective dashboard design principles, review our guide on how to create dashboards in Salesforce; many of the core concepts are universal and apply perfectly to HubSpot as well.
The best dashboards tell a story. Don't just show 'what' happened; arrange reports to explain the 'why.' A great dashboard might place top products by revenue next to a report on average deal size per product. This instantly reveals if you're winning with high-volume, low-cost sales or a few massive, strategic deals.
By pulling these reports together onto a single dashboard, you provide decision-makers with a command center for product performance. This is the first step in turning your sales by product data from a simple metric into a genuine go-to-market asset.
Unlocking Advanced Reporting and Automation
With basic reports running and dashboards live, the next step is to make that data work for you. Moving beyond simple tracking is where a sharp RevOps team gains a competitive edge. This involves dissecting revenue in ways that guide everything from the product roadmap to your GTM strategy.
A critical next step for any SaaS business is to segment renewal versus new business revenue for each product. This typically requires adding a custom field like “Opportunity Type” (e.g., New Business, Renewal, Upsell) to your opportunity or deal records. Once implemented, you can filter your product reports with incredible focus.
Attributing Revenue in Complex Deals
This is where many reporting initiatives falter: multi-product deals. A customer buys a bundle of three products for one price—how do you attribute that revenue? Without a clear, consistent method, your product-level reporting becomes unreliable.
Here are a few solid approaches:
- Even Split Allocation: The simplest method is to divide the total deal value evenly across all products. It's quick but rarely reflects the true value of each item.
- List Price Weighting: A much better approach. You allocate revenue based on each product’s individual list price. In a bundle, a $10,000 product gets twice the revenue credit as a $5,000 product, reflecting its perceived value.
- Custom Allocation: For maximum accuracy, add custom fields on the Opportunity Product or Line Item object. Reps can then manually enter the revenue for each item, as long as it sums to the total deal amount. This offers ultimate control.
The specific method you choose is less important than having a documented, consistent process that everyone follows. In Salesforce, you can build this logic with custom formula fields or a Flow to automate calculations, ensuring data integrity and saving reps time.
Automating Intelligence and Enriching Data
Your CRM should be more than a system of record; it should be an active intelligence partner. Using the automation tools in Salesforce or HubSpot, you can transform product sales data into real-time alerts. Imagine your product manager getting an automated Slack message the instant a new product’s monthly sales drop below a critical threshold. That’s intelligence you can act on.
This is also a perfect opportunity for data enrichment. A platform like Clay.com can take your customer data and layer on firmographic and technographic details. Suddenly, you're not just seeing what is selling; you're building a clear profile of who buys each product. That's a massive advantage for refining your GTM targeting.
This proactive analysis is crucial. Consider how product complexity can dramatically affect the sales process. Recent analysis showed that a high-complexity product (like a difficult software integration) can have a sales cycle of 110 days from a cold call. A low-complexity product, however, can close in just 28 days from an SEO lead. For any sales ops leader, that stat is a wake-up call, showing how directing the right leads to the right products can slash your sales cycle. You can dig deeper into how different channels impact the sales cycle length on Focus-Digital.co.
Putting Your Product Data to Work
Reports are useless until you act on them. The real value is realized when your sales by product analysis stops being a static dashboard and starts shaping your entire Go-To-Market (GTM) strategy. This is how you build a powerful feedback loop that aligns marketing, sales, and product, guided by what the market is actually telling you.
This is where a sharp RevOps function moves from a back-office support role to a strategic driver of the business. By turning raw data into concrete actions, you’re making calculated decisions based on what customers are buying.
Fine-Tuning Your Marketing and Sales Engines
With a clear picture of product sales, your marketing team can stop casting a wide net and start fishing with a spear. If reports show "Product A" is a top performer while "Product B" is languishing, the next actions become clear.
- Double down on winners: Shift ad budget and campaign efforts toward promoting your top-performing products to lookalike audiences.
- Create laser-focused content: Develop case studies, webinars, and blog posts that speak directly to the problems your most popular products solve.
- Rethink underperformers: For products that aren't selling, marketing operations can work with sales ops to determine if the product is being pitched to the wrong customer profile or if its value proposition is unclear.
For sales leaders, this data is pure gold. It offers a direct view into what’s resonating in the field, allowing for quick, precise adjustments to the sales motion. You can refine sales training to focus on discovery questions for top products, tweak commission plans to incentivize strategic offerings, or rebalance territories based on regional product demand.
An effective GTM strategy doesn’t treat every product the same. It funnels resources with precision, guided by what the sales data is telling you right now. This keeps the entire revenue team focused on activities that drive results.
This strategic focus is more critical than ever. Consider that the Canadian B2B technology reseller market was forecasted to hit $65.8 billion in 2026. Within that, software and services were projected to surge to $31.4 billion, with cloud platform services expected to see over 14% growth thanks to demand for data analytics and AI. These numbers highlight the opportunity for companies that can sharpen their GTM strategy around their most in-demand products.
Shaping Product Strategy and Your Roadmap
Perhaps the greatest benefit of solid product reporting is the direct feedback loop it creates with your product team. This data isn't a survey or a focus group—it’s unfiltered evidence of what customers are willing to pay for.
When you see certain products consistently outperforming others, it might spark a bigger conversation about adopting Product-Led Growth (PLG) strategies. In a PLG model, the product itself becomes the main engine for acquiring, converting, and retaining customers.
Product managers can use this sales data to make informed decisions. It helps them prioritize features for popular products or investigate why other offerings aren't gaining traction. It is also invaluable for optimizing pricing and packaging. When you connect sales data to strategy, you build a cohesive revenue machine. To see how these pieces fit together, review our guide on building a Go-To-Market strategy framework.
Common Questions About Product Reporting
Even the best-laid plans encounter challenges. As you build out sales by product reporting, you're bound to hit a few common snags. Let's address some of the questions we hear most often so your GTM teams get data they can trust.
Dodging the Most Common Reporting Pitfall
So, what's the biggest mistake we see? It's when sales reps don't consistently add individual products to their deals. They will enter a total deal value on an Opportunity but leave the line items blank. This single habit completely torpedoes any chance of reporting on what's actually selling.
The only real fix is to enforce data hygiene at the source. In Salesforce, this means using validation rules. In HubSpot, you can use required field settings or a workflow. These tools will prevent a deal from being moved to "Closed Won" if no products are attached. A quick data audit to assess the scope of the problem, followed by clear team training on why it matters, is the best path forward.
The most reliable reporting comes from systems that make it easy to do the right thing and hard to do the wrong thing. Don't rely on manual processes alone; build guardrails directly into your CRM to guarantee compliance and data integrity.
How Should I Handle Discounts in My Reports?
Discounts are a critical part of the story if you want to understand true product profitability. Thankfully, both Salesforce and HubSpot have standard fields for List Price, Sales Price, and Discount. Your reports need all three to paint a full picture.
I always recommend creating a custom formula field for "Discount Percentage" ((List Price - Sales Price) / List Price). With that, you can analyze which products are discounted most often and ask important questions:
- Are certain reps leaning too heavily on discounts to close deals?
- Is one product constantly sold below its value, suggesting a pricing or positioning issue?
- Do some sales regions have much higher discount rates than others?
This is exactly the kind of insight that helps fine-tune your pricing strategy and gives sales managers concrete data for coaching.
How Do I Report on Subscription-Based Products?
If you're a SaaS or subscription-based B2B company, one-time revenue is only part of the story. Tracking recurring revenue is paramount. The first step is to define your North Star metric: is it Annual Recurring Revenue (ARR), Monthly Recurring Revenue (MRR), or Total Contract Value (TCV)?
Once decided, build custom fields on the Opportunity Product (Salesforce) or Line Item (HubSpot) to capture that revenue type. For instance, you could create a "Product MRR" field that calculates its value based on quantity, price, and subscription term. This setup lets you build separate reports for new business ARR by product versus renewal revenue, giving you a much sharper view of your company’s sustainable growth.
At MarTech Do, we specialize in designing and implementing the robust CRM structures and RevOps strategies needed for this level of reporting. If you're ready to turn your data into a strategic asset, learn how our team can help you at https://www.martechdo.com.
