Measuring Sales Performance Metrics

"SQL is easy." Until someone asks you: What’s our 3-month rolling average? How did we grow year over year? What’s the best-performing weekday? Suddenly, SELECT * isn’t enough. If you're working with time-series or sales data, here are 7 SQL queries that turn raw data into real insights: 1. Time-Based Aggregation ⤷ Group your data by day, month, quarter, or year to observe trends. 2. Moving Average ⤷ Smooths short-term fluctuations to reveal the bigger picture. 3. Year-over-Year Growth ⤷ Shows how performance compares to the previous year. 4. Month-over-Month Change ⤷ Highlights recent shifts in growth or decline. 5. Cumulative Total ⤷ Tracks how sales or users are building up over time. 6. Same Day Last Year Comparison ⤷ Helps identify performance on specific dates year over year. 7. Day-of-Week Breakdown ⤷ Reveals which days consistently perform better. You don’t need a new tool. You just need to ask better questions—and know how to write the right SQL. Because in analytics, knowing when something happened matters as much as what happened. -- 👋 I’m Jayen T. , Dedicated to helping aspiring data analysts thrive in their careers. ➕ Follow MetricMinds.in for more tips, insights, and support on your data journey!

3 months ago, a CEO called me: "Our sales team isn't hitting numbers. We need better salespeople." I asked to see their CRM data before they fired anyone. What I found shocked them: → Their top performers were closing at 22% → Their "underperformers" were at 7% Seems obvious who to keep, right? But then I looked at their sales ACTIVITIES: The "underperformers" were making - 3X more calls, - sending 2X more emails, - and booking 40% more meetings. The problem wasn't the salespeople. It was the sales PROCESS. The top performers had: - Better territories - Legacy accounts - Easier products - More support The company was about to fire their hungriest, most active salespeople because of how they'd structured their sales operation. Within 60 days of fixing their: - Territory design - Lead distribution - Product packaging - Sales enablement resources The "underperformers" increased close rates to 20% while maintaining their high activity levels. Revenue jumped 134%. As a sales growth consultant, I've seen this pattern repeatedly: Companies blame salespeople when the real problem is how the sales function is built. Your team can't outwork a broken sales system. Look at your bottom performers: If they're putting in the work but not getting results, don't fire them. Fix what's standing in their way. The fastest path to sales growth isn't hiring "better" people. It's removing the barriers preventing your current team from succeeding. P.S. If you need help with your sales, send me a message

Demand Capture 101. This is actual data from a $60MM ARR SaaS company. Let’s break it down 👇   How a lead/account enters your pipeline is the biggest predictor of sales velocity metrics - win rates, sales cycle lengths, even ACVs.    Because how they enter your pipeline is a surrogate for buying intent & indicator of how far they are complete in the buying process.    Here’s how to measure it & use it to drive your revenue strategy:   1. Measure the Opportunity Source in Salesforce on the opportunity record.    Campaign Source = What campaign type did they convert on to move this opportunity into pipeline? (e.g. demo request, e-book download, cold call, trade show, etc.)   Source / Channel = What source or channel did they come from in order to convert? (e.g. LinkedIn ad, organic search, account intent data, ZoomInfo, etc.)    Using both of these data points combined will literally guide your strategy.    This shows you the optimal paths to *capture demand* and is easily measurable using software-based attribution.   2. Separate conversion sources between *Declared Intent* and *Low Intent*.    Declared Intent = The buyer declares intent to buy from you (e.g. Demo Request, Contact Sales) Low Intent = You assume the buyer has intent based on their digital behavior (e.g. ebook download, webinar attendee, trade show badge scan, intent data, etc.)    3. Calculate core sales analytics between the two sources.    Calculate conversion rates, lead-to-win rate, net new ARR, sales velocity, and more.    4. Visualize how much conversion intent matters to sales velocity and sales productivity.    149X higher lead-to-win rates for declared intent conversions   Declared intent = 26 “leads” to win 1 deal for $54k ARR Low Intent = 3,868 “leads” to win 1 deal for $130k ARR   18X greater sales velocity for declared intent conversions   Declared intent = $14.2MM annual sales velocity Low intent = $781k annual sales velocity 5. Recognize not all MQLs are created equal Measuring on MQLs incentivizes teams to get the most volume of MQLs for the lowest cost (low intent conversions), which is entirely misaligned with sales productivity and sales goals. Separate these into two Pipeline Sources (Declared Intent, Low Intent). Plan and build your goals for these two sources separately.   __   Now you know exactly HOW you want buyers to enter pipeline (capture demand) for maximum sales velocity & sales team efficiency. You also know exactly WHY buyers choose to take those paths to enter pipeline & WHAT triggers / channels / tactics move them to conversion. And with all of these insights, you can re-architect your strategy that optimizes for REVENUE. #revenue #sales #marketing #b2b #gtm p.s. Every SaaS company’s data looks like this, because it’s universal to how buyers buy. Most just don’t take the 3 hours of time to analyze their own data and see it for themselves.

Your sales team is optimizing for the wrong metric, and it's costing you millions Most sales leaders are obsessed with pipeline coverage ratios. "We need 3x coverage to hit our number." "Generate more top-of-funnel activity." "Increase prospecting activity by 40%." But coverage ratios are a vanity metric that's actually destroying your team's performance. Here's why this thinking is backwards Traditional logic is the same old… More opportunities = Higher probability of hitting quota Build massive pipeline = Insurance against deal slippage BUT in reality Bigger pipelines create cognitive overload for reps Too many opportunities = Poor qualification and deal management Reps spread thin across 50+ "opportunities" instead of focusing on 15 real ones The highest-performing sales teams I work with have completely flipped this Instead of maximizing pipeline size, they maximize pipeline quality. The Quality-First Framework looks like this 1) Ruthless Qualification Standards Only deals with documented business impact, defined evaluation processes, and accessible buying teams make it into the pipeline. 2) Rep Capacity Management Each rep can effectively manage 12-15 active opportunities. Anything beyond that diminishes focus and results. 3) Stage Velocity Tracking Measure how fast deals move through stages, not how many deals exist in each stage. 4) Elimination Before Generation Before adding new opportunities, eliminate stalled ones. Clean pipeline = clear thinking. The math is crazy Team A: 200 opportunities, 15% close rate = 30 deals Team B: 100 high-quality opportunities, 35% close rate = 35 deals Team B wins with half the pipeline stress. Your reps aren't struggling because they need more opportunities. They're struggling because they can't focus on the right ones. Share with a leader who needs to hear this ^^

Hey Salespeople: Here's a root cause analysis guide to diagnosing whether a sales teams' performance problems are due to deal quality or deal execution: 1. Understand loss reasons --> low quality: mostly no project / no budget / no pain --> poor execution: mostly loss to competitor / price 2. Identify loss stage --> low quality: higher than normal early stage loss --> poor execution: higher than normal late stage loss 3. Check win rate by source --> low quality: good win rates from partner and inbound and very poor win rates from outbound --> poor execution: consistently low win rates from all sources 4. Check win rate by account segment (ICP vs non-ICP) --> low quality: Good win rates for ICP accounts & poor win rates for non-ICP accounts --> poor execution: low win rates for both ICP and non-ICP accounts 5. Check AE performance distribution (esp. by win rate) --> low quality: reps clustered around low win rate --> poor execution: ~10%+ of reps with high win rates 6. Audit operating rhythm (esp. for deal reviews) and adherence to sales process & opp qualification/inspection methodology --> low quality: Good operating rhythm & adherence --> poor execution: Poor operating rhythm and process/methodology adherence 7. Check sales cycle (though ambiguous) --> low quality: N/A --> poor execution: closed lost opps have sales cycles that are >= closed won

Your sales team missed quota again last quarter. Your first instinct? Blame the reps. Fire the underperformers. Hire "better" salespeople. I've seen this cycle destroy hundreds of sales organizations. After analyzing 100+ revenue teams and helping clients generate $950M+ in additional revenue, here's what I've learned: 87% of sales problems aren't people problems. They're system problems. Here are 3 revenue leaks that are killing your numbers 👇 #1 Discovery theater Your reps are asking questions, but they're the wrong ones. They're focused on pain points instead of business impact. They're not quantifying problems or connecting features to financial outcomes. Result: Buyers stay unconvinced because they can't justify the investment. #2 Process chaos Every rep has their own "method." There's no repeatable playbook. Your top performer closes deals through sheer force of personality, but you can't scale that. When they leave, their numbers leave with them. #3 Coaching theater You're having weekly "check-ins" but they're just status updates. No systematic skill development. No data-driven improvement plans. You're managing activities instead of developing capabilities. The real solution is Revenue Intelligence Stop guessing what's broken. Start diagnosing systematically: → Map your actual conversion rates by stage (not your CRM fiction) → Audit what your reps really do vs. what they should do → Identify the specific skills gaps causing deal loss → Fix the systems before you blame the people A company that was a client of mine used this approach to go from $10K average deal size to $250K in 6 months. Same reps. Different system. The millions you're looking for aren't hiding in new hires. They're hiding in your current processes. P.S. Want to identify exactly where your deals are dying? Book a call here to get help: https://lnkd.in/ghh8VCaf

I analyzed 67+ outbound clients across 12 industries. Every single one falls into 1 of 3 buckets. 1. Top performers. 2. Average performers. 3. And the bottom 10% that outbound probably can’t save. Most teams think they’re one email away from their next deal. But after hundreds of campaigns, one thing’s clear: Your outbound performance mirrors your market position, not your sequence. Here’s what SalesCaptain’s data shows👇 1️⃣ Low Results (8-10 positives per 3K prospects) Usually the teams stuck in commoditized markets. They sound like everyone else, sell like everyone else, and get ignored. 🔹 No product-market fit 🔹 Weak or no offer 🔹 Basic website, no social proof 🔹 Long deal cycles, tiny TAM 🔹 Outbound quality dragged down by the offer itself What we do here: → Run a short test, confirm underperformance, then either help them reposition or pause entirely. 2️⃣ Average Results (15-25 positives per 3K prospects) The healthiest segment of the market. These teams know their ICP, have a solid offer, and play the consistency game. 🔹 Decent PMF 🔹 Clear ICP definition 🔹 Message/market fit 🔹 Entry-point offer that converts This is where most mid-market companies live. They get reliable meetings, not fireworks, but steady growth. 3️⃣ Superior Results (30-40 positives per 3K prospects) This is where we see significantly large ROIs. We see this pattern across B2B SaaS, GTM consultancies, and fast-moving service orgs. 🔹 Strong PMF 🔹 Sharp differentiation 🔹 Medium deal sizes ($10–80K) 🔹 Localized campaigns 🔹 Multi-channel execution (email + LinkedIn + data enrichment) 🔹 High in-market demand What separates these 3 isn’t the toolset, it’s that they know how to structure outbound like a system. The goal is to move up the curve, and that's what we helped 60+ teams do. If your outbound is underperforming, check which bucket you’re really in, and ask whether the problem is your campaign… or your market. DM me if you need help. #outbound #gtm #performance

I met a sales team that tracks 27 different metrics. But none of them matter. They measure: - Calls made - Emails sent - Meetings booked - Demos delivered - Talk-to-listen ratio - Response time - Pipeline coverage But they all miss the most important number: How often prospects share your content with others. This hit me yesterday. We analyzed our last 200 deals: Won deals: Champion shared content with 5+ stakeholders Lost deals: Champion shared with fewer than 2 people It wasn't about our: - Product demos - Discovery questions - Pricing strategy - Negotiation skills It was about whether our champion could effectively sell for us. Think about your current pipeline: Do you know how many people have seen your proposal? Do you know which slides your champion shared internally? Do you know who viewed your pricing? Most sales leaders have no idea. They're optimizing metrics that don't drive decisions. Look at your CRM right now. I bet it tracks: ✅ When YOU last emailed a prospect ❌ When THEY last shared your content ✅ How many calls YOU made ❌ How many stakeholders viewed your materials ✅ When YOU sent a proposal ❌ How much time they spent reviewing it We've built dashboards to measure everything except what actually matters. The real sales metric that predicts closed deals: Internal Sharing Velocity (ISV) How quickly and widely your champion distributes your content to other stakeholders. High ISV = Deals close Low ISV = Deals stall We completely rebuilt our sales process around this insight: - Redesigned all content to be shareable, not just readable - Created spaces where champions could easily distribute information - Built analytics to measure exactly who engaged with what - Trained reps to optimize for sharing, not for responses Result? Win rates up 35%. Sales cycles shortened by 42%. Forecasting accuracy improved by 60%. Stop obsessing over your activity metrics. Start measuring how effectively your champions sell for you. If your CRM can't tell you how often your content is shared internally, you're operating in the dark. And that's why your forecasts are always wrong. Your move.

Hey Medical Sales Managers, let's talk about underperforming reps. You know the drill. Numbers are down, so you do what every sales manager since the dawn of time has done - tell them to "just make more calls." Because obviously, having your rep repeatedly crash and burn in front of more prospects is exactly what your territory needs right now. When's the last time you actually went on a sales call with your rep? And no, watching them fumble through that one Zoom call doesn't count. Have you seen how they handle those value analysis committees? (Hint: If they're sweating more than a rookie covering their first OR case, there might be a problem.) The real questions you should be asking: Is your product portfolio aligned with what the market actually wants, or are you pushing a commodity that offers no real advantages over what already exists? Can your reps effectively communicate value propositions, or do they sound like they're reading from a brochure written in 2005? Are they reaching the right decision-makers, or just becoming best friends with the front desk staff? Does each rep possess the specific skills needed for medical sales success, or are they still using the same pitch that worked in their previous job selling office supplies? Here's what's worrying: Too many managers are more of an "expectation setter" than a coach or sales partner. Sure, setting targets is important, but without proper diagnosis and development, you're just yelling "jump higher" at someone who needs to learn proper jumping technique first. Action Step: Shadow your lowest-performing rep for a full day. Yes, a full day. Document specific areas where they excel or struggle. Then put together a plan to address any deficiencies that you'll work on together. When your sales team underperforms, it's as much your responsibility as theirs. Identifying any deficiencies and helping them to address and overcome them moves the needle on sales. And that's why we're all here. __________________ Want your meeting events to be more productive with an ROI? Consider incorporating a comprehensive sales skills refresher at your next national sales meeting. Because let's be honest, another "motivation speaker" talking about climbing Mount Everest isn't what your team needs right now. If you're interested in innovative approaches to sales training that don't involve trust falls or team-building exercises that make everyone cringe, maybe we should talk. DM me or find more info in my profile.

Ever wondered why despite immense potential, some SaaS companies struggle to scale and achieve profitability? I recently went deep into a compelling discussion that shed light on the vital role of business metrics in SaaS growth. One anecdote stood out: the story of Salsify, a company that enhanced its trajectory by relocating its European headquarters to Lisbon, symbolizing a strategic shift in optimizing operations. The central theme was crystal clear: "If you can't measure it, you cannot improve it." Accurate metrics are not just numbers; they shape strategies, align teams, and spark growth. But what's the secret formula? Key takeaways include: - The Rule of 40: A SaaS company's growth rate and profitability combined should exceed 40%. - Net New ARR: Monitor bookings via net new Annual Recurring Revenue (ARR), encompassing new customer ARR, expansion ARR from existing customers, and losses from churned customers. - Sales Funnel Efficiency: Deploy a holistic funnel that includes onboarding, retention, and expansion. - Sales Team Metrics: Productivity per salesperson and timely hiring are crucial to meet growth targets. - Customer Economics: Balance the Customer Acquisition Cost (CAC) against the Lifetime Value (LTV). Aim for an LTV to CAC ratio of 3:1 and recover CAC within 12-18 months. - Negative Churn: Expansion revenue should ideally outpace revenue losses from churned customers for sustainable growth. Metrics like these can transform a SaaS company from merely surviving to thriving. It's fascinating how strategic measurement and adjustment can turn potential into proven success. How do you leverage metrics to steer your SaaS business towards growth and profitability? Share your experiences and insights! #SaaSMetrics #GrowthStrategy #BusinessAnalytics #SaaS #CustomerRetention #StartupGrowth #ScaleYourBusiness