Wauvel

What does a sales analyst do?

Measure the revenue engine and explain it: the funnel, the pipeline, the forecast, the quotas, the comp plan, and the economics of every deal. This is the whole of it, topic by topic, from an entry analyst's first conversion rate to the capacity plan a CRO signs.

Take the rated skills test →1,011 questions · 85 topics · rated from entry sales analyst to VP Sales Ops / CRO

Pipeline & funnel · 14

  1. The sales funnel

    Entry sales analyst

    The stages a prospect passes through from first contact to closed deal — lead, qualified, opportunity, proposal, negotiation, won — with fewer surviving each step.

    Read · 4 practice questions →

  2. Stage conversion rate

    Entry sales analyst

    The share of opportunities that move from one stage to the next. Multiplied along the funnel, the stage rates give the overall lead-to-close rate.

    Read · 30 practice questions →

  3. Win rate

    Entry sales analyst

    Deals won as a share of deals closed (won plus lost). The single most-used measure of how well the sales motion converts.

    Read · 17 practice questions →

  4. Sales cycle length

    Entry sales analyst

    The average number of days from an opportunity's creation to its close, won deals only. How long the motion takes.

    Read · 17 practice questions →

  5. Pipeline hygiene

    Entry sales analyst

    Keeping the CRM honest: close dates in the future, stages current, dead deals closed-lost, amounts real. Everything downstream — forecast, coverage, velocity — depends on it.

    Read · 4 practice questions →

  6. Pipeline coverage

    Sales analyst

    Open pipeline for a period divided by the quota or target for that period. How many dollars of opportunity sit behind each dollar of target.

    Read · 94 practice questions →

  7. Weighted pipeline

    Sales analyst

    Each open opportunity's value multiplied by its stage's historical win probability, summed. An expected value of the pipeline rather than its face value.

    Read · 49 practice questions →

  8. Lead-to-opportunity conversion

    Sales analyst

    The share of leads that become qualified opportunities — the handoff from marketing to sales, and the first place funnel math breaks.

    Read · 4 practice questions →

  9. MQL and SQL

    Sales analyst

    A marketing-qualified lead has shown enough interest or fit by marketing's definition; a sales-qualified lead is one sales has accepted as worth pursuing. The two definitions are where marketing and sales argue.

    Read · 4 practice questions →

  10. Deal slippage

    Sales analyst

    Deals whose close date moved out of the period they were forecast in. The share of a forecast that was real but late.

    Read · 17 practice questions →

  11. Stage aging

    Sales analyst

    How long each open deal has sat in its current stage compared with the typical time at that stage. Old deals are stuck deals.

    Read · 36 practice questions →

  12. Pipeline velocity

    Senior sales analyst

    How fast the pipeline turns into revenue: opportunities × average deal value × win rate, divided by sales cycle length. Dollars per day the motion produces.

    Read · 18 practice questions →

  13. Closed-lost analysis

    Senior sales analyst

    Studying the deals that were lost — to whom, at what stage, for what stated reason — to find the fixable patterns.

    Read · 4 practice questions →

  14. Lead scoring

    Senior sales analyst

    Ranking leads by fit (industry, size, role) and intent (visits, downloads, demo requests) so sales works the likeliest first.

    Read · 3 practice questions →

Forecasting · 7

  1. Forecast categories

    Sales analyst

    Labels reps and managers put on open deals — commit, best case, pipeline, omitted — that say how confident they are the deal closes this period.

    Read · 4 practice questions →

  2. Sales seasonality

    Sales analyst

    Regular within-year patterns in bookings — a Q4 surge, a summer slowdown, month-end spikes — that repeat and should be planned for, not explained away.

    Read · 4 practice questions →

  3. Forecast accuracy

    Senior sales analyst

    How close the forecast called at a point in the quarter came to what actually closed. Measured week by week so the process can improve.

    Read · 18 practice questions →

  4. The forecast roll-up

    Senior sales analyst

    The weekly process that aggregates rep-level calls through managers to the company number, with a finance or ops view beside it.

    Read · 3 practice questions →

  5. Run-rate forecasting

    Senior sales analyst

    Projecting the period from what has closed so far and the historical pattern of when deals land — the share usually closed by week six, and so on.

    Read · 16 practice questions →

  6. Bookings versus revenue forecast

    Senior sales analyst

    Bookings are signed contracts; revenue is recognised as delivered. The bookings forecast is what sales calls; the revenue forecast is what finance reports. They differ by timing.

    Read · 3 practice questions →

  7. Snapshot versus cohort views

    Senior sales analyst

    A snapshot counts what is in the pipeline today; a cohort follows the deals created in a period until they resolve. Only cohorts give true conversion rates and cycle times.

    Read · 4 practice questions →

Bookings & revenue · 8

  1. Bookings

    Entry sales analyst

    The total value of contracts signed in a period. The sales team's output measure, before any revenue is recognised.

    Read · 4 practice questions →

  2. Average deal size

    Entry sales analyst

    Bookings divided by the number of deals won. One of the four velocity levers, and the one most affected by mix.

    Read · 33 practice questions →

  3. ACV and TCV

    Sales analyst

    Annual contract value is a contract's value normalised to one year; total contract value is everything over the full term, including one-time fees.

    Read · 29 practice questions →

  4. New, expansion, and renewal

    Sales analyst

    Splitting bookings by source: new logos, expansion of existing customers (upsell, cross-sell), and renewals of existing contracts. Each has different economics and usually different owners.

    Read · 4 practice questions →

  5. ARR from bookings

    Senior sales analyst

    How signed contracts change annual recurring revenue: new ACV adds, expansion adds, churn and downgrades subtract; one-time fees never count.

    Read · 17 practice questions →

  6. Revenue recognition for sales

    Senior sales analyst

    Revenue is recorded as the service is delivered, not when signed or paid. A subscription is spread over its term; an implementation is recognised when done.

    Read · 4 practice questions →

  7. Billings

    Senior sales analyst

    What is invoiced in a period. It sits between bookings (signed) and revenue (recognised), and drives cash.

    Read · 4 practice questions →

  8. Ramped and unramped deals

    Sales ops manager

    Contracts whose value steps up over the term — a discounted first year, seats added on a schedule. Bookings, ACV, and ARR each treat the ramp differently.

    Read · 3 practice questions →

Quotas & compensation · 9

  1. Quota attainment

    Entry sales analyst

    A rep's bookings as a share of their quota. The distribution across the team says as much as the average.

    Read · 18 practice questions →

  2. On-target earnings

    Sales analyst

    A rep's total pay at exactly 100% of quota: base salary plus target variable. The pay mix is the split between the two.

    Read · 17 practice questions →

  3. Commission rate

    Sales analyst

    The share of each booked dollar paid to the rep: target variable divided by quota gives the base rate.

    Read · 17 practice questions →

  4. Quota setting

    Senior sales analyst

    Assigning each rep a bookings target from the company plan, territory potential, ramp, and history, so the sum of quotas covers the plan with a margin for misses.

    Read · 16 practice questions →

  5. Accelerators and decelerators

    Senior sales analyst

    Higher commission rates above quota (accelerators) and lower rates below a threshold (decelerators), so overachievement pays disproportionately.

    Read · 16 practice questions →

  6. Ramp time

    Senior sales analyst

    How long a new rep takes to reach full productivity, and the reduced quota (a ramped quota) they carry in the meantime.

    Read · 16 practice questions →

  7. SPIFs

    Senior sales analyst

    Short-term sales incentives — a bonus for selling a product, closing before a date, or hitting an activity target — layered on top of the comp plan.

    Read · 3 practice questions →

  8. Clawbacks

    Sales ops manager

    Recovering commission already paid when the deal it was paid on churns, cancels, or never pays, within a defined window.

    Read · 4 practice questions →

  9. Comp plan design

    VP Sales Ops / CRO

    The full set of rules — mix, rate, accelerators, thresholds, SPIFs, clawbacks, payment timing — that decides what reps are paid for and therefore what they do.

    Read · 5 practice questions →

Territories & segmentation · 7

  1. Segmentation

    Sales analyst

    Splitting the market and the sales motion by size or type — SMB, mid-market, enterprise — because each has a different cycle, deal size, and cost to serve.

    Read · 4 practice questions →

  2. Ideal customer profile

    Senior sales analyst

    The description of the accounts that buy fastest, pay most, and stay longest — industry, size, tooling, trigger events — derived from the customers you already have.

    Read · 4 practice questions →

  3. Territory design

    Senior sales analyst

    Dividing accounts among reps — by geography, industry, size, or named list — so potential is balanced and coverage has no gaps or overlaps.

    Read · 4 practice questions →

  4. TAM, SAM, and SOM

    Senior sales analyst

    Total addressable market is everyone who could buy; serviceable addressable market is the part you can reach; serviceable obtainable market is what you can realistically win.

    Read · 3 practice questions →

  5. Account scoring

    Senior sales analyst

    Ranking accounts by fit and potential so territories are balanced and reps prioritise, using firmographics, install base, and intent.

    Read · 3 practice questions →

  6. Whitespace analysis

    Senior sales analyst

    Mapping which products each existing customer has and has not bought, to find expansion opportunity inside the base.

    Read · 4 practice questions →

  7. The coverage model

    Sales ops manager

    Which motion covers which accounts — field, inside, partner, self-serve — matched to deal size and cost of sale.

    Read · 16 practice questions →

Pricing & deals · 8

  1. Discount analysis

    Sales analyst

    Measuring the gap between list price and what deals actually close at, by rep, segment, and quarter, and what the discount bought.

    Read · 18 practice questions →

  2. Average selling price

    Sales analyst

    The average realised price per unit or seat, after discounts. Falling ASP with rising volume is a mix shift or a discounting problem — find out which.

    Read · 17 practice questions →

  3. Discount impact on margin

    Sales analyst

    A discount comes straight off the margin: 10% off a 40%-margin sale removes a quarter of the profit and needs about 33% more volume to compensate.

    Read · 17 practice questions →

  4. Price realization

    Senior sales analyst

    Net price achieved as a share of list. The mirror of discount, aggregated: how much of the price book the team actually collects.

    Read · 17 practice questions →

  5. Price, volume, and mix in bookings

    Senior sales analyst

    Splitting a change in bookings into more units, higher prices, and a different blend of products or segments.

    Read · 3 practice questions →

  6. Payment terms in deals

    Senior sales analyst

    Annual up front, quarterly, monthly, net 30, net 60 — the billing and payment terms in a contract, which decide when the cash arrives and how much working capital the deal consumes.

    Read · 4 practice questions →

  7. The deal desk

    Sales ops manager

    A review point for non-standard deals — discounts above a threshold, unusual terms, custom contracts — so pricing discipline holds without slowing every deal.

    Read · 4 practice questions →

  8. Multi-year deals

    Sales ops manager

    Contracts longer than a year, usually with a discount for the commitment. They lock in revenue, reduce churn risk, and complicate ACV, quota credit, and cash.

    Read · 4 practice questions →

Customer economics · 9

  1. Customer acquisition cost

    Sales analyst

    Total sales and marketing cost in a period divided by new customers won in it. What it costs to buy a customer, fully loaded.

    Read · 17 practice questions →

  2. Churn and retention

    Sales analyst

    The share of customers or revenue lost in a period. Logo churn counts customers; revenue churn counts dollars; gross revenue retention excludes expansion.

    Read · 18 practice questions →

  3. Customer lifetime value

    Senior sales analyst

    The gross profit a customer generates over their whole relationship: revenue per period, times gross margin, divided by churn.

    Read · 16 practice questions →

  4. LTV to CAC

    Senior sales analyst

    Lifetime value divided by acquisition cost — the return on each dollar spent winning a customer. Three is the usual healthy line.

    Read · 5 practice questions →

  5. CAC payback

    Senior sales analyst

    Months of a customer's gross profit needed to earn back the cost of acquiring them. The cash question the LTV ratio ignores.

    Read · 17 practice questions →

  6. Net revenue retention

    Senior sales analyst

    Revenue from last year's customers as a share of what they paid then, after churn, downgrades, and expansion. Above 100% means the base grows without new logos.

    Read · 16 practice questions →

  7. Cohort retention

    Senior sales analyst

    Following the customers won in each period and measuring how many, and how much revenue, remain over time — the only honest view of whether customers stay.

    Read · 4 practice questions →

  8. Expansion revenue

    Senior sales analyst

    Additional revenue from existing customers — more seats, higher tiers, added products — measured as a share of starting ARR.

    Read · 16 practice questions →

  9. Customer concentration

    Sales ops manager

    How much of revenue comes from the largest customers. One at 20% or more of revenue is a risk to the whole business, not just a big account.

    Read · 33 practice questions →

Productivity & capacity · 7

  1. Activity metrics

    Entry sales analyst

    Calls, emails, meetings, demos, and proposals per rep per period — the inputs that precede pipeline.

    Read · 4 practice questions →

  2. Rep productivity

    Sales analyst

    Bookings per fully ramped rep per period — the yield of the sales machine per unit of capacity.

    Read · 17 practice questions →

  3. Deals per rep

    Sales analyst

    The number of deals a rep closes in a period. With average deal size, it explains productivity; with pipeline, it explains coverage.

    Read · 4 practice questions →

  4. Rep attrition

    Senior sales analyst

    The share of reps who leave in a year, voluntary and not. Each departure costs the ramp time of the replacement plus the pipeline that goes with them.

    Read · 16 practice questions →

  5. SDR to AE ratio

    Senior sales analyst

    How many sales development reps support each account executive with qualified meetings. The ratio sets how much pipeline is sourced versus self-generated.

    Read · 16 practice questions →

  6. Sales capacity planning

    Sales ops manager

    Working out how many reps, hired when, at what ramp and attrition, produce the bookings plan. The bridge from the revenue target to the hiring plan.

    Read · 18 practice questions →

  7. The sales hiring plan

    Sales ops manager

    When to hire each rep so that, after ramp, capacity meets the plan — with the cost landing months before the bookings do.

    Read · 4 practice questions →

Data & reporting · 8

  1. CRM data quality

    Entry sales analyst

    Whether the fields the reports depend on — stage, amount, close date, source, owner — are complete, current, and mean the same thing to everyone.

    Read · 4 practice questions →

  2. The sales dashboard

    Sales analyst

    The standing view for a sales leader: bookings versus target, pipeline coverage, conversion by stage, forecast versus actual, and rep attainment.

    Read · 4 practice questions →

  3. Bookings variance to plan

    Sales analyst

    The gap between planned and actual bookings, explained by its drivers — deal count, deal size, win rate, slippage — rather than just reported.

    Read · 16 practice questions →

  4. Funnel metrics by source

    Sales analyst

    Conversion, cycle, deal size, and win rate broken out by where the lead came from — inbound, outbound, partner, event.

    Read · 4 practice questions →

  5. Choosing sales KPIs

    Sales analyst

    The handful of metrics that actually drive bookings — coverage, conversion, cycle, deal size, attainment — each with an owner and a target.

    Read · 4 practice questions →

  6. The rep scorecard

    Senior sales analyst

    A per-rep view of attainment, pipeline, conversion, activity, and forecast accuracy, used for coaching and for spotting who needs help before the quarter is lost.

    Read · 4 practice questions →

  7. Attribution

    Senior sales analyst

    Assigning credit for a deal to the marketing and sales touches that produced it — first touch, last touch, or multi-touch.

    Read · 4 practice questions →

  8. Churn attributed to the seller

    Sales ops manager

    Tracking whether the customers a rep sold stay, so the comp plan rewards deals that last rather than deals that sign.

    Read · 4 practice questions →

Leadership · 8

  1. Revenue operations

    Sales ops manager

    One function owning the systems, data, process, and planning across marketing, sales, and customer success, so the funnel is measured end to end by one set of definitions.

    Read · 5 practice questions →

  2. The forecast call

    Sales ops manager

    The weekly meeting where the sales leader reviews the number with managers: what is committed, what slipped, what is at risk, and what has to happen this week.

    Read · 4 practice questions →

  3. Pipeline generation planning

    Sales ops manager

    Working backward from the bookings target through win rate and coverage to the pipeline that must be created each month, and where it comes from.

    Read · 18 practice questions →

  4. Sales and marketing alignment

    Sales ops manager

    Shared definitions, a shared funnel, and shared targets between the team that generates demand and the team that closes it.

    Read · 4 practice questions →

  5. The sales tech stack

    Sales ops manager

    CRM, engagement, enablement, forecasting, and CPQ tools — and the integrations between them — that the sales motion runs on.

    Read · 4 practice questions →

  6. Annual sales planning

    VP Sales Ops / CRO

    Turning the revenue target into segments, territories, quotas, hiring, and comp — with the capacity model as the spine that connects them.

    Read · 5 practice questions →

  7. Sales metrics for the board

    VP Sales Ops / CRO

    The few numbers a board needs on sales: bookings versus plan, pipeline coverage for next quarter, win rate and cycle trends, rep productivity, and the capacity plan.

    Read · 4 practice questions →

  8. Go-to-market efficiency

    VP Sales Ops / CRO

    How much new ARR a dollar of sales and marketing spend produces — the magic number and its cousins. Whether growth spend earns its keep.

    Read · 17 practice questions →

Learn the job here — or connect Shopify and QuickBooks and let Wauvel read your actual sales every day.

Meet your AI CFO →