About Services Tools Blog Contact us

Territory Prospect File

Builds one prospect file per sales territory by joining a public utility register to place names, sales areas and show exhibitor lists. Uncertain matches are left for a person.

  • Data Merge & Cleaning
  • Water utilities
  • Pipeline
  • Productised
  • Hybrid
  • 2025

The problem

The public register, the sales areas and the show exhibitor lists were three separate spreadsheets. A rep could not tell who covered a works or a town without opening each file. And a company on both the register and an exhibitor list could be chased twice.

What it does

The tool adds the county enquiry contact to each place name, then matches the utility register to those places and to sales areas. It reads exhibitor lists into the same columns and checks them against Salesforce so nobody appears twice. Each rep gets one list for their territory. Names it cannot match with confidence go on a list for a person to confirm.

Outcomes

  • Each town has an enquiry contact wherever the county matched.
  • Each rep receives one list per territory.
  • Show exhibitors sit in the same columns as the register.
  • Only the uncertain matches need a person.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Build a territory file

Register sample 8 works

Public register rows for this desk. Sales areas are not on the file yet.

Merge
Ready when you are
Utility register
WorksTownCounty
Fenlock TreatmentBrindlefordKent
Ashmere CatchmentLowfordCumbria
Quayfield NetworksPebblefordDevon
Calderford PumpsNenebridgeNorfolk
Lowford MainsLowfordCumbria
Rookley WorksRookleyKent
Hestley AbstractionHestleyunsure
Whitfen StorageWhitfenunsure
Place file 22 places
CountyEnquiry contactPlaces
KentLeila Okoye6
CumbriaEwan Brodie5
DevonSaskia Venn4
NorfolkCatrin Bevan3
LancashireLowri Pugh4

Exceptions to confirm

A person still decides these
Nothing is filed until you confirm
Amber rows
WorksTown as printedWhy it is unsureProposedStatus
Hestley AbstractionHestleyThe place file has Hestley in Norfolk and in CumbriaNorfolk, Felix BrennanReview
Whitfen StorageWhitfenClosest place is Whitfen Green, Devon, and the spelling differsDevon, Maeve QuinnReview

Show exhibitors

As printed on the stand list
LineStand
SILT & VALVE LTD, Pebbleford18
Fenlock Treatment (Brindleford)14
Parse
The chip adds both lines in register columns

How it works

  1. Load the county to contact map and read the place-name file.
  2. Add the enquiry contact and count matched and unmatched places.
  3. Match the utility register to places and to sales areas.
  4. Read the exhibitor lists into the same columns.
  5. Drop rows already in Salesforce.
  6. Flag uncertain matches for a person to check.

Pipeline

flowchart LR
  A[Counties] --> B[Places]
  B --> C[Register]
  C --> D[Areas]
  D --> E[Exhibitors]
  E --> F[Dedupe]
  F --> G[Territory]
  G --> H[Exceptions]