Sales & Revenue Performance Analytics Questions

Analysis framework
I would break the problem into four layers: territory design, market potential, account assignment, and rep execution.

1) Normalize performance
First, I would compare quota attainment after adjusting for segment, ACV mix, cycle length, and tenure. A raw attainment gap may simply reflect harder books, not weaker reps.

2) Measure territory quality
I would assess each territory’s addressable market: account count, historic win rates, average deal size, pipeline density, and whitespace. If one territory has far less opportunity, the issue is likely design rather than execution.

3) Check account assignment
I would review whether high-potential accounts are clustered unfairly, whether house accounts were distributed well, and whether book changes created instability. A frequent cause is uneven assignment, not territory labels themselves.

4) Evaluate rep execution
For equalized territories, I would compare activity quality, stage conversion, follow-up speed, deal aging, and forecast discipline. If one rep consistently underperforms after normalization, the issue is likely execution or coaching.

What I’d present
To leadership, I would show a heat map of quota attainment vs. market potential, a root-cause summary by territory, and clear recommendations: redesign territory boundaries, rebalance accounts, or coach specific reps. I would avoid a single blunt conclusion and instead separate structural issues from people issues.

Fair productivity model
I would measure representative productivity with a mix of outcome metrics and normalized leading indicators, so we do not reward raw activity or punish reps in harder territories.

Metrics I would include

• Quota attainment and attainment trend
• Pipeline created, normalized by territory potential
• Qualified opportunities advanced to late stage
• Win rate and average deal size by segment
• Ramp progress for new reps compared with cohort expectations

How I would keep it fair

• Compare reps within similar territory potential and segment, not in one global ranking.
• Use ramp-adjusted targets for new hires.
• Separate controllable activity from business outcomes.
• Give less weight to vanity metrics like calls or emails unless they correlate with conversion.

How I would avoid bad incentives
I would not overvalue activity that does not move deals forward. For example, a rep with huge meeting volume but weak conversion should not score above a rep with fewer but higher-quality opportunities. The best model rewards efficient revenue creation, not just busyness. In practice, I would use a balanced scorecard so leaders can see whether a rep has enough activity, enough pipeline, and enough conversion to justify strong performance.

Diagnosis plan
I would first verify whether the coverage metric is defined correctly: qualified pipeline for the correct period, with realistic close dates and no duplicated opportunities. Healthy coverage on paper can hide weak quality.

What I’d check next

• Funnel health: Are there enough opportunities entering the funnel, or is the issue later-stage conversion?
• Stage conversion: Are deals moving from stage to stage at historical rates, or are they stalling?
• Deal aging: Are opportunities sitting too long in key stages, especially late stage?
• Rep activity: Are reps holding meaningful meetings, advancing next steps, and creating new pipeline, or just logging activity?

How I’d isolate root cause
If early-stage conversion is fine but late-stage conversion is weak, the problem is likely deal execution, pricing, or competition. If stage aging is rising, the team may be pushing close dates or overcommitting. If activity is high but conversions are flat, the issue is not effort but effectiveness. If coverage is concentrated in a few large deals, concentration risk may explain the miss.

I would present leadership with a simple split: volume problem, quality problem, or forecast discipline problem. That makes the fix actionable instead of treating bookings misses as one vague pipeline issue.

Core funnel metrics

• Lead stage: lead volume, source mix, and lead-to-MQL rate
• Qualification stage: MQL-to-SQL rate and speed to first contact
• Opportunity stage: SQL-to-opportunity creation rate, stage conversion, and deal aging
• Closed stage: win rate, average sales cycle, and average deal size

How to interpret drop-off
If the drop-off happens at one stage but not the others, I would treat it as a localized issue rather than a full-funnel problem. For example:

• Low lead-to-MQL conversion may point to poor targeting or weak lead scoring.
• Low MQL-to-SQL conversion may indicate qualification standards are too loose or follow-up is slow.
• Low opportunity-to-close conversion may suggest messaging, pricing, competition, or deal execution problems.

I would also compare the affected stage across segments, sources, and reps before drawing conclusions. A single drop-off can be caused by mix shift, seasonality, or one bad source, not necessarily a broad sales problem. The key is to separate where the funnel weakens from why it weakens.

Analysis approach
I would start by cleaning the win/loss data and standardizing reason codes, because open-text reasons are usually noisy. Then I would segment the analysis by competitor, deal size, industry, stage duration, product line, and rep segment.

What I would look for

• Win rate by competitor and by industry
• Average stage duration for wins vs. losses
• Deal-size bands where the team performs well or poorly
• Recurring reasons for loss, such as pricing, missing features, or poor qualification
• Interactions, such as whether one competitor matters only in a specific industry or price band

Turning insights into recommendations
I would convert patterns into action items for leadership:

• If a competitor wins on a repeated objection, update messaging and battlecards.
• If large deals stall late, improve executive alignment and deal review discipline.
• If a segment has low win rates but high effort, consider tighter qualification or a different ICP.
• If a product gap shows up repeatedly, prioritize it with product management.

I would present the findings as a short list of business actions, not just charts. Leadership usually needs to know what to change in positioning, process, pricing, or enablement.