A useful window and door sales dashboard should answer four questions: Are the right opportunities entering the business? Is the team moving them forward efficiently? Are signed contracts producing enough gross profit? Can operations deliver what sales is booking?
The minimum system therefore needs more than lead volume and revenue. It should combine acquisition, response, conversion, value, margin, cycle-time and handoff measures. Each KPI also needs a controlled definition, a named owner and a comparison period. Without those controls, two managers can report the same label and calculate different results.
This guide defines a practical KPI system for retail replacement, renovation, new-construction and dealer-oriented businesses. It does not set universal targets. Product mix, service area, seasonality, installation model, accounting policy and sales process differ too much for one benchmark to be reliable across every company.
Definition note: The formulas below are WDPro operating recommendations. Finance, sales and operations should approve the exact definitions before the dashboard is used for compensation, forecasting, hiring or capacity commitments.
Scope and Use Cases
Sales KPIs are management tools, not decorations for a report. A KPI should support a decision, show the owner what to investigate and use data that the team can collect consistently.
Use the system to:
- compare lead sources by qualified opportunities and signed work rather than raw inquiries;
- identify slow response, missed appointments, stalled quotations and weak follow-up;
- separate sales volume from margin quality;
- forecast demand using controlled pipeline stages and actual conversion history;
- detect incomplete handoffs that may create ordering, installation or service problems;
- align marketing spend and sales capacity with estimating, measurement, production and installation capacity.
Keep this article separate from channel strategy and pipeline design. Lead-generation methods belong in the acquisition plan, while stage names and exit criteria belong in the sales-pipeline standard. The KPI system measures whether those processes are producing the intended outcomes.
Requirements and Inputs
Before calculating a KPI, write its definition. The definition should state the numerator, denominator, date basis, included records, excluded records, owner, source system and review frequency.
Choose one reporting unit
Decide whether a record represents a person, household, project, opportunity, quote or contract. One homeowner may submit several forms, request both windows and doors, receive a revised quote and sign one contract. Counting every event as a separate lead can inflate volume and distort conversion.
WDPro recommends using a unique sales opportunity as the main unit for pipeline and conversion reporting. Keep raw inquiries as a separate acquisition measure, and document how duplicates, returning customers, multi-product projects and reopened opportunities are handled.
Set the date basis
A dashboard can group results by the date an inquiry arrived, the date an opportunity was qualified, the date a quote was issued or the date a contract was signed. Each view answers a different question.
Use cohort reporting when evaluating conversion: group opportunities by the period in which they entered the relevant stage and allow enough time for the normal sales cycle to mature. A current-month close rate may look weak simply because many current-month opportunities are still open.
Control statuses and loss reasons
Every active stage needs entry and exit criteria. Closed records should use controlled outcomes such as won, lost, no decision, duplicate, outside scope, outside service area, timing deferred or unable to contact. Free-text notes may add context, but they should not replace reportable categories. Stage-conversion and ageing measures are only meaningful when they refer to a clearly defined window and door sales pipeline with consistent entry criteria, exit criteria and ownership.
Reconcile source, contract and accounting data
Marketing platforms can describe traffic and advertising interactions, but the customer relationship management system should control opportunity status and the accounting or contract system should control signed value, cancellations, refunds and gross profit. Reconcile the systems on a documented schedule instead of assuming their totals will match automatically.
Google Analytics distinguishes source, medium and campaign fields, while Google Ads supports advertiser-defined qualified-lead and converted-lead stages based on offline process data. Those platform labels can support attribution, but they do not replace the company’s own qualification rules, contract records or financial results.
The Core Window and Door Sales KPIs
Track a small core set consistently before adding dozens of secondary measures. The following KPIs cover the full path from inquiry to deliverable contract.
1. Qualified opportunities
Formula:
Count of unique opportunities that meet the documented qualification standard during the reporting period
This is more useful than raw inquiry volume because it removes obvious duplicates, out-of-area requests and work the company does not offer. The qualification standard should cover service area, product or project fit, decision-maker access, realistic timing and a defined next action.
Review qualified opportunities by source, salesperson, product family, service area and project type. A source that produces fewer inquiries may still create more suitable work.
2. Qualification rate
Formula:
Qualified opportunities / unique inquiries x 100
Qualification rate shows whether marketing and intake are attracting and identifying suitable work. A falling rate may point to weak targeting, unclear landing pages, poor source quality or inconsistent screening.
Do not improve the number by quietly lowering the qualification standard. Audit a sample of accepted and rejected records whenever the rate changes materially.
3. Cost per qualified opportunity
Formula:
Attributable acquisition cost / qualified opportunities from the same source and period
Include the costs that management has chosen for the decision, such as media, agency fees, purchased leads, event costs, call tracking or landing-page production. Label the measure clearly if labour, overhead or shared brand spending is excluded.
Use the same attribution rule in the numerator and denominator. A paid-search cost divided by all qualified opportunities is not a valid source-level KPI.
4. Median first-response time
Formula:
Median elapsed time from inquiry receipt to the first meaningful human response during staffed periods
Median is usually more informative than an average because a small number of very old records can distort the average. Define staffed periods, automated acknowledgements and what counts as a meaningful response before comparing branches or representatives.
Pair speed with contact and qualification results. A fast automated message is not the same as a completed conversation or a useful next step.
5. Contact rate
Formula:
Unique inquiries with completed two-way contact / unique inquiries with valid contact details x 100
Use a defined contact window and approved outreach process. Segment the result by source and time of receipt. A low rate may reflect poor lead data, slow response, inconvenient contact attempts or a source that generates low-intent inquiries.
6. Appointment set rate and show rate
Appointment set rate formula:
Opportunities with a booked consultation, site visit or measurement / qualified opportunities eligible for that step x 100
Show rate formula:
Completed appointments / appointments scheduled to occur in the period x 100
Keep company-caused reschedules, customer reschedules, cancellations and no-shows separate. The actions are different: reminder procedures will not solve an estimator-capacity problem, and more appointments will not solve weak qualification.
7. Quote issuance rate
Formula:
Eligible opportunities receiving a formal quote / opportunities that completed the required discovery or site-review stage x 100
Define when an opportunity is eligible for quotation. Missing dimensions, unresolved product choices, technical holds or incomplete installation scope may legitimately prevent pricing. Report those holds separately so the team can distinguish disciplined control from avoidable delay.
8. Quote turnaround time
Formula:
Median elapsed time from the agreed quote-ready event to first complete quote delivery
The start event may be discovery completion, receipt of supplier pricing or completion of site measurement. Use one rule for each business model. Track complex projects separately so a custom commercial package does not distort the routine residential measure.
9. Quote acceptance rate
Formula:
Opportunities with a signed contract / opportunities with a decision-ready quote and a resolved outcome x 100
The denominator matters. Excluding open quotes too early inflates the result; leaving abandoned quotations open forever weakens it. Establish an ageing rule and preserve a separate no-decision outcome.
Segment acceptance by source, product, salesperson, price band, discount band, service area and project type. Use the segments diagnostically, not as proof that one person or channel caused the result.
10. Lead-to-sale conversion rate
Formula:
Signed contracts / unique inquiries in a mature inquiry cohort x 100
This end-to-end measure combines lead quality, intake, sales execution and offer fit. It should be read with qualification rate and quote acceptance rate. The overall rate alone cannot show where the process is failing.
Define whether cancellations remain in signed contracts. WDPro recommends reporting gross signed conversion and net retained conversion separately when cancellations are material.
11. Sales-cycle length
Formula:
Median elapsed days from the defined starting stage to signed contract, reported for won opportunities in a mature cohort
Use the median and report meaningful percentiles where volume permits. Segment by project type because a replacement-window project, custom entry system and commercial tender may follow very different timelines.
Also monitor stage ageing for open opportunities. A short cycle among wins can hide a large group of stalled records.
12. Net signed sales value
Formula:
Signed contract value less approved cancellations, refunds and scope reductions, using the company’s documented revenue basis
Separate taxes, financing charges, rebates, allowances and pass-through items according to the approved accounting definition. A sales dashboard should not invent a revenue basis that conflicts with finance.
Compare actual net signed value with target, prior period, available capacity and the value of work that can realistically be delivered.
13. Average order value
Formula:
Net signed sales value / retained signed contracts
Average order value helps explain revenue changes, but it should be segmented by product and project type. A rising average can reflect larger projects, price changes, product mix, add-ons or fewer small orders. It does not prove improved sales quality by itself.
14. Gross profit dollars and gross margin percentage
Gross profit formula:
Net sales value – direct costs included in the approved gross-profit policy
Gross margin formula:
Gross profit / net sales value x 100
Finance must define the included direct costs. Product, freight, installation labour, subcontracting, disposal, permits, commissions, warranty accruals and job-specific overhead may be treated differently by different companies.
Report both dollars and percentage. High revenue at weak margin can consume scarce installation capacity without producing the intended financial result. Estimated margin at sale should later be reconciled with actual job results. That reconciliation is central to improving window and door business profitability, because a strong quoted margin can be eroded by omitted scope, installation overruns, rework or unrecorded changes.
15. Cancellation rate
Formula:
Contracts cancelled after signing / contracts signed in a mature cohort x 100
Classify reasons such as financing, cooling-off or cancellation rights where applicable, customer decision, measurement or technical conflict, lead-time change, credit issue, price or company capacity. Legal status and contract consequences depend on the facts and jurisdiction, so the dashboard should record categories without pretending to decide a legal question.
16. Sales handoff completeness
Formula:
Signed files passing the approved handoff checklist on first review / signed files reviewed x 100
The checklist may include final product selections, dimensions or measurement status, installation scope, exclusions, access conditions, promised dates, payment terms, approvals, drawings, change records and customer contact restrictions.
This KPI connects sales quality to downstream execution. It should not be used to transfer responsibility for technical verification to sales when another qualified role owns the final check.
17. Order correction or preventable change rate
Formula:
Signed jobs requiring a documented preventable correction before order or installation / signed jobs reviewed x 100
Use a controlled cause code: data entry, product configuration, measurement, pricing, customer change, supplier change, technical review or unclear scope. Keep customer-initiated and supplier-initiated changes separate from internal preventable errors.
Segment KPIs Before Drawing Conclusions
A company-wide total can hide where the result came from. Review the core KPIs across consistent dimensions:
- source and campaign;
- branch, territory and service area;
- retail, builder, commercial, dealer or supply-only segment;
- windows, entry doors, patio doors, garage doors and mixed projects;
- new customer, repeat customer and referral;
- salesperson, estimator or team;
- project value and discount band;
- financing status where collection and use are lawful and appropriate;
- month, quarter and comparable seasonal period.
Do not create segments so small that the report exposes customer information or invites unstable conclusions from one or two projects. Combine or suppress small groups where appropriate, and keep individual-performance reporting within authorized access.
Process and Responsibilities
Sales operations or CRM owner
Maintain field definitions, stage rules, duplicate rules, loss reasons, user access and dashboard logic. Test changes before release and keep a change log so trend breaks can be explained.
Marketing owner
Maintain source and campaign naming, cost inputs and platform connections. Reconcile platform conversions with qualified opportunities and signed contracts instead of reporting platform interactions as revenue. When selecting digital marketing services for window and door companies, agree in advance how campaign costs, inquiry sources and downstream sales outcomes will be recorded and reviewed.
Sales manager
Review response, contact, appointment, quotation, conversion, cycle-time and loss-reason measures. Use record-level coaching samples to understand the cause behind the aggregate result.
Finance owner
Approve revenue, direct-cost, gross-profit, gross-margin, cancellation and refund definitions. Reconcile estimated sale values with accounting records on a controlled schedule.
Operations owner
Validate capacity assumptions and handoff requirements. Report downstream corrections, delays and service issues back to the sale or process step where prevention is possible.
Privacy or legal owner
Review the collection, use, sharing, retention and access rules for personal information, as well as any KPI-linked contact practice, recording, incentive or customer claim. The applicable private-sector privacy law can depend on the organization, province and data flow.
Build the Dashboard Around Decisions
Use different views for different management rhythms.
Daily operational view
- new inquiries without an owner;
- inquiries outside the response standard;
- appointments requiring confirmation;
- quotes awaiting required inputs;
- stale opportunities and overdue next actions;
- signed files waiting for handoff review.
Weekly sales-management view
- qualified opportunities by source and owner;
- contact, appointment, quote and acceptance rates;
- stage ageing and next-step completeness;
- quote turnaround time;
- won, lost, no-decision and deferred outcomes;
- expected near-term demand compared with sales and estimating capacity.
Monthly management view
- acquisition cost per qualified opportunity and per retained sale;
- mature-cohort lead-to-sale conversion;
- net signed value, average order value and gross margin;
- cancellations, preventable changes and handoff completeness;
- source, product, branch and salesperson segments;
- booked demand compared with production and installation capacity;
- definition changes, data-quality exceptions and unresolved reconciliation items.
Each review should end with a named action, owner and due date. A dashboard that never changes a decision is reporting activity, not a management system.
Risk and Quality Controls
KPI pressure can create bad behaviour when the measure is easier to improve than the underlying result. Review incentives and controls before using metrics for compensation or ranking.
- Do not reward lead volume without lead quality and retained-sale measures.
- Do not reward signed value without margin, cancellation and handoff quality.
- Do not treat an automated acknowledgement as a completed customer response.
- Do not count a quote as won until the approved contract event occurs.
- Do not delete or recode losses simply to improve conversion.
- Do not compare representatives who receive materially different territories, sources or project types without appropriate context.
- Do not use customer data beyond the authorized purpose or keep it indefinitely because storage is inexpensive.
- Do not let performance targets encourage unsupported savings, product-performance, certification, rebate, warranty or compliance claims.
The Office of the Privacy Commissioner of Canada’s PIPEDA guidance addresses limiting collection, limiting use and retention, accuracy and safeguards. Some organizations or activities may be governed by provincial private-sector privacy law instead of or alongside PIPEDA. The Competition Bureau advises that marketing representations must not be materially false or misleading and assesses both literal meaning and general impression.
Requirements vary by location and project. Confirm current rules with the authority having jurisdiction before ordering, selling or installing products.
Documentation
Keep a KPI dictionary and change log with:
- KPI name, purpose and decision supported;
- formula, numerator, denominator and exclusions;
- unit of analysis and cohort or date basis;
- source systems and reconciliation method;
- owner, access level and review frequency;
- current target, target rationale and effective date;
- data-quality tests and exception handling;
- dashboard version and definition-change history;
- retention, deletion and access rules for personal information;
- known limitations and unresolved issues.
Retain only the detail needed for the approved purpose and access model. Aggregated management reporting should not expose customer information that the audience does not need.
Implementation Checklist
- Select the 10 to 17 core KPIs that match the current sales process and decisions.
- Define inquiry, opportunity, qualified, quote-ready, quoted, won, lost, no decision, cancelled and retained sale.
- Choose the reporting unit, date basis, cohort rule and duplicate rule.
- Approve source and campaign naming across forms, calls, CRM and advertising platforms.
- Assign owners for marketing, CRM, sales, finance, operations and privacy controls.
- Confirm revenue, direct-cost, gross-profit and gross-margin definitions with finance.
- Create controlled loss, cancellation, hold and correction reason lists.
- Build data-quality checks for missing owners, missing next actions, impossible dates and duplicate records.
- Establish daily, weekly and monthly review routines.
- Compare initial results with underlying records before setting targets.
- Document company-specific targets from actual baseline, capacity and financial requirements.
- Review incentive effects before connecting KPIs to compensation.
- Record every definition or system change that can break trend comparability.
- Complete legal and privacy review before using customer data or contact activity in a new way.
Final Takeaway
The strongest window and door sales KPI system connects acquisition quality, sales execution, financial value and operational deliverability. Start with controlled definitions and a small core dashboard, then add detail only when it supports a real decision.
Do not copy an external benchmark and call it a target. Build targets from the company’s own mature cohorts, margin requirements, service standards and capacity, and review the underlying records whenever a KPI changes materially.
For customer-facing product education that supports better-qualified conversations, direct prospects to the Windows 101 guide. For internal management, the immediate next step is to approve a KPI dictionary and test one complete reporting cycle before using the results for compensation or forecasts.



