If your sales pipeline leaves you with more questions than answers, you’re not alone. Many teams rely on HubSpot’s native reports, only to find they don’t reflect the specifics of how your deals actually close—or why some don’t. Whether you’re trying to track margin per product line, get a better read on rep performance, or uncover which lead sources truly convert, the default metrics rarely go far enough.
When static reports force you to juggle spreadsheets or guess at patterns, that’s when custom metrics become mission-critical. But adding them isn’t always intuitive. Between property types, filter logic, and visualization quirks, it’s easy to create data that looks right but tells the wrong story.
This guide walks you through exactly how to navigate HubSpot’s custom metric options, step-by-step. You’ll learn what custom metrics are, where they live, how to build them properly, and how to ensure your dashboards reflect real sales performance—not just data noise.
What Adding Custom Metrics to Your HubSpot Sales Pipeline Means
Think of a HubSpot custom metric as a window into data that’s unique to how your team sells. Unlike standard fields like deal amount or closed revenue, a custom metric uses your CRM’s live data to create your own formulas and filters.
You can set up these metrics in HubSpot’s custom report builder, or use them in combination with custom properties for more hands-on reporting flexibility. For example, you might build “Avg. Revenue per Subscription Renewal” or “Net Revenue from Upsells Last Quarter”, depending on your operating model.
These metrics live in the Reports and Dashboards sections of HubSpot and tie directly to CRM objects such as Deals, Contacts, or Companies. When set up correctly, they update automatically—so any changes you make to deal fields are reflected immediately in your reports.
That real-time sync with HubSpot’s CRM data model is key. It means you’re always working with the latest info, without needing manual exports, formula recalculations, or third-party tools.
How It Works Under the Hood
Behind every custom metric is a simple flow: the correct input data, a precise calculation, and real-time output in your dashboards.
Here’s what that looks like inside HubSpot:
- Input: Start with relevant properties tied to your CRM object—like Create Date, Deal Amount, or Deal Stage.
- Calculation: Use a formula to transform or filter that data. For example, calculate an average, ratio, or trend over time.
- Output: HubSpot returns this as a metric you can visualize with bar charts, line graphs, tables, or KPI summaries.
These calculations adjust automatically as your data changes. If a rep moves a deal to Closed Won or revises the deal amount, any report pulling that property updates instantly.
You can also layer filters by date, owner, or pipeline—ensuring your metrics show exactly the data slice you care about. For instance, “Average Sales Cycle Length” might be built like this:
- Input: Create Date and Close Date
- Formula: Difference between dates, averaged
- Output: Average number of days to close
If you’re running more than one pipeline (e.g., enterprise vs. SMB), you can customize metrics per pipeline. That lets you track performance in ways that align with each line of business.
Main Uses Inside HubSpot
Measure Pipeline Health
If you’ve ever guessed at why deals stall mid-funnel, custom metrics help surface the real blockers. Metrics like “Stage Conversion %” tell you how many deals move from demo to proposal—or drop off. Add a time filter, and you can track how conversion shifts month to month or quarter to quarter, pinpointing areas for coaching or process improvement.
Track Rep Performance Fairly
Comparing performance across reps isn’t always apples-to-apples. Some reps close higher-value deals but fewer of them. Others may have shorter sales cycles. A metric like “Revenue per Opportunity” helps you compare efficiency rather than just volume. Group by deal owner to get a clearer view of who’s pulling their weight relative to their pipelines.
Identify High-Value Deal Attributes
Want to know what your best deals have in common? Build a metric called “Win Rate by Industry” that uses filters for deal type and region. It’ll highlight where your team closes quickly and profitably—and where to adjust your messaging or targeting.
Align Marketing and Sales Handoffs
Marketing-qualified leads don’t always convert the same way. A custom metric, such as the “MQL-to-Won Ratio,” tracks how well marketing-sourced deals perform. Use it to bring transparency to the funnel so marketing and sales can optimize together—not work off assumptions.
Common Setup Errors and Wrong Assumptions
Custom metrics are powerful, but errors in setup can lead you straight to misleading data. Here are a few pitfalls to watch:
Error: Using Contact Properties Inside Deal Metrics
Why it happens: You’re trying to report on deal outcomes but referencing data from the contact record.
Solution: Change your report’s primary data source to “Deals.” Use cross-object joins only if needed, and understand how they affect results.
Error: Not Filtering Out Test or Dormant Records
Why it matters: Sandbox or old pipeline data can skew your averages or totals.
Solution: Add filters to exclude certain pipelines, stages, or deal types. For example, “Deal Stage is not Test” and “Pipeline is Current Year.”
Error: Choosing the Wrong Aggregation
Why it happens: “Sum” is the default, but may not reflect your actual metric intent.
Solution: If you want a true average or ratio, use the corresponding aggregation, such as “Average” or “Count Distinct.”
Error: Overloading Your Dashboard
Why it matters: One-off metrics with inconsistent names cause clutter and confusion fast.
Solution: Use a naming convention like “Sales_” or “Marketing_” as a prefix, and keep similar formulas grouped in one report.
Error: Assuming Everyone Sees the Same Data
Why it causes issues: HubSpot dashboards respect filter settings per viewer.
Solution: Set your filters and access visibility to “All users” for any organization-wide report.
Step-by-Step Setup or Use Guide
Before you start, double-check that you have either HubSpot Reporting or Sales Hub Professional, with editor or admin permissions. You’ll also want to verify that the properties you’re using are populated and consistent across your data set.
Here’s how to create a custom metric from scratch:
Step 1: Go to Reports
Navigate to Reports > Reports and click “Create Report.”
Step 2: Choose the Custom Report Builder
Select “From Scratch,” then pick your primary data object—Deals is typical for sales metrics.
Step 3: Add Your Data Fields
Drag in fields like Deal Amount, Stage, or Create Date. Make sure these are relevant to the business question you’re answering.
Step 4: Create the Metric
Click “Add Metric” and choose “Create Custom Calculation.” Input your formula. Example: Closed Revenue ÷ Number of Deals.
Step 5: Apply Filters
Define which pipeline, owner, or timeframe your metric should apply to. This keeps the report aligned with your goals.
Step 6: Pick a Visualization Style
You can choose from bar charts, summary KPIs, or line graphs. Label clearly so users know what they’re viewing.
Step 7: Save and Name
Give the report a clear, specific name, such as “Average Close Time – Enterprise Pipeline.” Save it to a designated folder or dashboard.
Step 8: Add to Dashboard
Assign the report to your Sales Dashboard or another relevant workspace for ongoing visibility.
Step 9: Share or Schedule
Use HubSpot’s scheduling to send reports weekly or monthly to managers. That way, no one has to ask “Where’s the data?”
This workflow creates a living metric—one that updates automatically as your sales activity evolves.
Measuring Results in HubSpot
Once your custom metrics are live, the next challenge is making sure they actually help. Start by integrating them into your ongoing reporting checkpoints.
Reports to analyze:
- Sales Performance Report: Add metrics next to default KPIs to compare trends and spot anomalies.
- Deal Forecast Report: Blend your own formulas (e.g., weighted pipeline by likelihood) to improve forecasting accuracy.
- Custom Funnel Report: Use custom metrics to show real movement between stages, not just counts.
What to double-check on your dashboard:
- Are timestamps showing that data is updating as expected?
- Do the same time range and pipeline filter all metrics?
- Do owner-level filters reflect each rep’s accurate pipeline?
Make it part of your monthly pulse to check:
- How many deals are contributing to this metric?
- Are we seeing a directional trend (up or down)?
- Are we acting on what the data reveals—or just watching it?
Metrics improve over time—if you track them, question them, and keep them tied to actual decisions.
Short Example That Ties It Together
Let’s say your team needs more clarity on deal margins. HubSpot tracks deal amount, but not have built-in margin data.
You start by creating a custom property called “Deal Margin %.” Reps enter this when marking a deal Closed Won.
Now, in the custom report builder:
- Select “Deals” as your source
- Add Deal Amount and Deal Margin % as fields
- Create the metric: (Deal Amount * Deal Margin % ÷ 100), averaged
Add this to a dashboard filtered to the current quarter. Now you can view “Average Deal Margin by Owner” or “By Product Line.”
Within a few reporting cycles, you’ll spot high-margin opportunities that deserve more focus. Insight your default reports would’ve never revealed.
How INSIDEA Helps
Getting real ROI from HubSpot reporting comes down to structure and strategy. A strong metric is only as valuable as the data beneath it—and many teams unknowingly build on mismatched fields or static formulas.
INSIDEA helps you solve that. Our RevOps and HubSpot specialists guide you beyond out-of-the-box reports to design metrics that make sense for how you sell, support, and scale.
Whether you’re onboarding, restructuring your pipeline, or aligning revenue teams, we ensure your CRM reflects real processes—not faulty assumptions.
Here’s how we support clients like you:
- HubSpot onboarding: Set up the right foundation
- HubSpot management: Keep data clean and workflows stable
- HubSpot automation: Connect reporting to activity-based triggers
- Reporting and CRM alignment: Define what success actually looks like
- Custom metric support: Build accurate formulas that reflect how your team performs
If your dashboards don’t tell you what’s really happening in your funnel, let’s change that.
Connect with a HubSpot consultant at INSIDEA and build a reporting strategy that delivers usable, confident insights.
Good sales decisions start with honest metrics. Let your HubSpot data reflect your reality—not just your defaults.
