About Services Tools Blog Contact us

Directory Contact Enrichment

Reads a school or shop website, picks a real contact address, rejects shared inboxes and fake addresses, and can look separately for a parents' association address.

  • Data Merge & Cleaning
  • Education
  • Pipeline
  • Productised
  • Local/private
  • 2025

The problem

Many directory emails are missing, generic or unsafe to mail, so outreach and claim invites fail. Role accounts and automated addresses get treated as if they were a real contact. Mail sent to them goes unread.

What it does

The job fetches the site and its likely contact pages and collects the email addresses. It asks a locally run model (Gemma through Ollama) to choose the best office address. A second pass looks for parents' association addresses. Fake and automated addresses are marked, and tracking codes are removed from stored web links.

Outcomes

  • Blank entries gain a chosen contact address.
  • Shared inboxes and fake addresses are rejected and not mailed.
  • Parents' association addresses can be filled on their own pass.
  • Each entry shows whether it worked.

Simplified mockup

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

Directory queue

Still queued
6
Chosen
0
Rejected
0
Association
0
Six schools and shops
OrganisationEmailStatus
Oakmere Primary School · Frome
oakmere.example/contact?utm_source=dir&utm_campaign=spring chapel row, frome
Blank
Queued
Hearth & Sole Shop · York
hearthandsole.example 18 lantern yard
Blank Queued
Millhaven School School · Totnes
millhaven.example Harbour Hill
[email protected] Queued
Cobblers Yard Shop · Exeter
cobblersyard.example fore street
Blank Queued
Wrenfield Academy School · Hexham
wrenfield.example Address blank
[email protected] Queued
Pebblewick Stores Shop · Cromer
pebblewick.example/home?utm_medium=cpc&fbclid=sample
Blank Queued

Choice rules

Local model
Choose

Prefer an office or enquiries address on the same domain as the organisation. Title-case the postal address and keep the website only when the model agrees.

Reject

Traps and automated mail: noreply, donotreply, mailer-daemon. Role accounts held, not mailed: webmaster, postmaster, accounts.

Association pass

A separate pass looks only for a parents’ association address, such as friends@ or chair@, and writes it beside the office address.

Flags this month
Earlier decisions
OrganisationAddress keptFlagWhen
Aldergate Infants[email protected]Success8 Oct
Sableford Stores[email protected]Trap8 Oct
Kestrel Holt School[email protected]Role7 Oct
North Lantern Shoes[email protected]Success7 Oct
Bramble Primary[email protected]Association6 Oct

Stored URLs

Tracking stripped on save
Before

oakmere.example/contact?utm_source=dir&utm_campaign=spring

Fetched from the directory row. Campaign parameters are not part of the official site.

After

oakmere.example/contact

Path kept. Query parameters on the strip list are dropped before the row is saved.

Parameters removed
ParameterWhy it goesExample row
utm_sourceCampaign tagOakmere Primary
utm_mediumCampaign tagPebblewick Stores
utm_campaignCampaign tagOakmere Primary
utm_contentCampaign tagNot in this queue
gclidAdvert click idNot in this queue
fbclidAdvert click idPebblewick Stores

How it works

  1. Fetch the site and the likely contact pages.
  2. Collect the email addresses and compare their domain with the organisation name.
  3. Ask the model to choose the best office address, or the parents' association address on that pass.
  4. Mark fake, shared-inbox and automated addresses as rejected.
  5. Fill in email, address and website when the model agrees, and remove tracking codes from web links.
  6. Mark the entry as a success or a failure.

Pipeline

flowchart LR
  A[Website] --> B[Pages]
  B --> C[Addresses]
  C --> D[Choose]
  D --> E[Reject]
  D --> F[Fill]
  F --> G[Status]