Quick answer: When territories are redrawn, measure outlet coverage by defined outlet-assignment windows, not by applying the new territory list to the whole period. Define eligible active outlets, assignment start and end dates, completed qualifying visits and a reporting cutoff. Restate the comparison period on the same assignment rules before judging performance. This is a reporting control, not automatic territory optimization.
When a sales territory is redrawn, outlet coverage can appear to fall or jump even if field work has not changed. The cause is usually the denominator: outlets move between territories, assignment dates differ, and visits completed before the move are counted against the wrong map.
Why territory changes break outlet coverage comparisons
Outlet coverage answers a simple question: of the outlets a territory was responsible for during the reporting period, how many received at least one completed qualifying visit before the cutoff? When territories change mid-period, three things move at once: the outlet list, the responsible salesperson and the date that responsibility began or ended.
A raw old-versus-new comparison often mixes an end-of-period outlet list with full-period visits. That can double count some outlets, drop others, or assign a visit to a territory that did not own the outlet on the visit date. It differs from outlet deduplication, which prevents the same outlet ID from being counted twice, and from visit frequency, which counts how many visits an outlet receives. Coverage asks whether the outlet was reached at least once within its responsibility window.
Define the four inputs before calculating outlet coverage
Write these definitions into the report specification before producing any territory-change comparison. The same definitions must apply to the baseline and the current period.
- Eligible active outlet: an outlet that is open, in scope for the channel and assigned to the territory for at least one day in the period. Exclude prospects, permanently closed outlets and outlets outside the channel.
- Assignment window: the dates an outlet was the territory’s responsibility. Use effective dates, not the date a list was uploaded or a report was run. One outlet can create two windows if it moves during the period.
- Completed qualifying visit: a visit with the required status, store ID, task evidence and completion time inside the assignment window and before the cutoff. A check-in alone is not enough unless your definition explicitly says so.
- Reporting cutoff: the timestamp after which visits do not count in the current report. Use the visit completion time, not the sync time, and document how late-arriving records are corrected in a later version.
A workable formula is: coverage = outlet-assignment windows with at least one completed qualifying visit / eligible outlet-assignment windows. State the numerator, denominator, period and exception policy so another analyst can reproduce the number.
Worked example: the same visits produce two different outlet coverage stories
This is a labeled hypothetical example, not a benchmark. A company starts the month with 120 active outlets in North and 80 in South. On day 16, 40 outlets move from North to South. All 40 moved outlets receive one completed qualifying visit on day 10, while they are still in North. No other qualifying visits occur before the day 30 cutoff.
| Reporting view | Denominator | Covered outlets or windows | Coverage | What the view hides |
|---|---|---|---|---|
| Old territory map, full period | North 120; South 80 | North 40; South 0 | North 33.3%; South 0% | That 40 outlets later changed territory |
| New territory map, end-of-period list applied to whole month | North 80; South 120 | North 0; South 40 | North 0%; South 33.3% | That the visits happened before the outlets moved |
| Assignment-window view | North 200 windows; South 200 windows | North 40 windows; South 0 | North 20%; South 0% | Nothing about the move, but it is not a like-for-like end-state territory score |
The raw new-map result appears to show South improving from 0% to 33.3% and North collapsing to 0%. Neither change reflects new field work. The assignment-window view removes the false South improvement and shows that the only covered windows were in North before the move. If you need a steady-state comparison, report the transition period separately and compare only full periods after the new assignment dates are stable.
Handle newly assigned, closed and temporarily inaccessible outlets explicitly
Newly assigned outlets
Start the eligibility window on the assignment effective date. Do not count a visit made before that date as coverage for the receiving territory. For the first period after a move, show the new cohort separately so a short responsibility window is not confused with poor execution.
Closed outlets
End the window on the closure date and remove the outlet from the denominator from that date. Do not count a closed outlet as a missed visit. If it reopens and is reassigned, create a new window.
Temporarily inaccessible outlets
Keep them eligible if they remain in scope, but record an exception reason and exclude them from a secondary accessible-coverage view only when the policy allows. A failed visit does not count as coverage. Report both total coverage and accessible coverage so the reader can see the effect of the exception.
Territory-change coverage checklist
- Freeze the reporting period, cutoff timestamp and source of assignment effective dates.
- Build an outlet-assignment window table with outlet ID, territory, start date, end date and status reason.
- Deduplicate visits by visit ID, then keep only completed qualifying visits inside the window and before the cutoff.
- Flag moved, newly assigned, closed, reopened and inaccessible outlets with separate reason codes.
- Calculate coverage by assignment window and reconcile the total to the visit and outlet source lists.
- Restate the baseline on the same rules, or label the comparison as transition-only rather than like-for-like.
- Document any exclusion, late data correction and manual override in the report notes.
Airpalm’s public site describes mobile visits, route planning, store audits, sales orders, inventory and promotion management. If those workflows are part of your evaluation, confirm how completed visit status and territory assignment dates are recorded in the proposed process before building a coverage comparison. For a general product overview, visit https://airpalm.com/.
Frequently asked questions (FAQ)
Should the baseline use the old or new territory list?
Neither list is enough on its own when outlets move mid-period. Restate the baseline using the same outlet-assignment window rules as the current period. If that is not possible, label the result as a transition-period view and do not present it as a like-for-like territory comparison.
How should an outlet that closes during the period be treated?
Keep the outlet in the denominator only up to its closure date, then remove it. Record the closure reason and do not count it as a missed visit. If it later reopens and is reassigned, create a new assignment window rather than reviving the old one.
Does a failed or inaccessible visit count toward outlet coverage?
No. A failed visit is not a completed qualifying visit unless your published definition explicitly treats a verified exception differently. Report inaccessible outlets separately and show both total coverage and accessible coverage so the exception does not silently change the denominator.
Put this guide into practice
This general-purpose worksheet is a starting point. Adapt its fields, responsibilities and rules to your business process.



