← All AI ROI products
Founder pricing
AI product · Foundations

Customer Data Clean-Up

For businesses whose customer and prospect records are spread across a CRM, the accounting package, a mailing tool and spreadsheets: a profile of every source and field from your own exports, duplicates counted by stated rules, records past your retention period, and who you may contact by email, post and phone, a clean-up rulebook with who checks each decision and the hours it takes, entry rules and a 30-minute monthly routine so it stays clean, and the same counts taken again 90 days after the clean-up.

About 6–10 hours to profile and plan, then the clean-up itself (estimate)Exports from your CRM, accounting package and mailing toolRun it yourself or with Geoff
What it answers

Four questions it answers

  1. 1

    How bad is it?Every source and field profiled from your exports.

  2. 2

    What do we do about it?A written rule, a decision and a checker for each problem.

  3. 3

    Who may we contact?Retention, basis and permissions under UK GDPR and PECR.

  4. 4

    Will it stay clean?Entry rules, a monthly routine, and the same counts after 90 days.

Choose this if your CRM, accounts and mailing lists disagree, hold the same customers twice and people who left years ago, and nobody can say who you may contact. It comes before the Target Account List, Customer Retention Review and Win-Back Plan, which need clean records.

Founder pricing. The method, the calculation spreadsheet with 29 built-in checks, and a complete worked example are built and tested. The first client for this product gets the founder price, in return for permission to measure the results and, if they are good, write them up as a case study. After that, the price goes up. Book a call to take the founder place.

How the value is shown · Unlocks

What it unlocks

Unlocks: clean records will make the Target Account List, Customer Retention Review, Lapsed Customer Win-Back Plan, Automated Email and Text Flows Plan and Direct Mail Campaign Plan possible; Measure later: the duplicate rate, required fields filled, returned post, UK GDPR basis recorded, customers matched and the share you may lawfully email are recorded now and counted again, the same way, 90 days after the clean-up. Any £ comes only from your own records, such as returned post and duplicate mailings, shown beside the one-off and yearly cost of the clean-up.

A Foundations product: the groundwork the money products depend on. Its value is shown this way rather than as a single headline figure, and every number in it is labelled counted, estimated or assumed.

What you get

What you get

A data-quality report

Completion and invalid formats by source and field, counts only, and duplicates counted by stated rules: same email, same company and postcode, similar names checked on a sample first.

A clean-up rulebook

Each problem's rule, decision, who checks and the hours, in working order.

Who you may contact, and how

Basis and permission by channel, soft opt-in, TPS and CTPS; ICO guidance cited, not legal advice.

Entry rules and a monthly routine

Required fields enforced and a 30-minute check each month.

Baselines to measure again

Six measures counted the same way 90 days after the clean-up.

New records kept to the rules

Guided and done for you: an agent in your own accounts checks each week's new records against your entry and duplicate rules and prepares a fix list for the person who looks after each system. Nothing leaves your business, and no decision changes, without one of your people approving it.

Worked example

A trade supplier's customer records

A fictional 46-person plumbing and heating trade supplier held 12,010 records across its CRM, accounting package and mailing tool. 8.7% of the CRM and accounts records were extra copies, only 55% had a UK GDPR basis recorded, 64% of email addresses could lawfully be marketed to, and 318 invoiced customers weren't in the CRM at all.

The clean-up rulebook covers 24 problems: past-retention records purged first, then merges, then the UK GDPR basis, about 320 hours with the allowance. Entry rules and a 30-minute monthly routine stop it coming back. The same counts are taken again on 11 March 2027.

Read the full example

Stannerley Trade Supplies LtdFictional · Worked example
Records profiledthree sources, counted from the exports
12,010
Duplicate rateextra copies, in the sources that can hold them
8.7%
Emailable lawfullynow; measured again after 90 days
63.5%
ROI products it will unlockneed the clean data
6 of 6
IllustrativeHow the value is shown: Unlocks, with baselines measured again. All names and figures are invented.
How it works

Five stages

  1. Profile

    Every source and field, from your exports.

  2. Decide

    A rule, a decision and a checker per problem.

  3. Prevent

    Entry rules and the monthly routine.

  4. Measure

    The same counts again after 90 days.

  5. Keep

    An agent checks each week's new records against the rules.

Three ways to buy

Do it yourself, with Geoff, or done for you

The same method and the same spreadsheet in every option. You choose how much of your own time goes in.

Self-implement kit

Run it yourself

For owners comfortable with a spreadsheet and an AI assistant.

  • The AI skill
  • The calculation spreadsheet
  • A worked example
  • The buyer's guide
Book a call
Guided implementation

Run it with Geoff

For owners who want a second pair of eyes on the data and the analysis.

  • Everything in the kit
  • Working sessions with Geoff to agree the rules and decisions
  • Help setting the entry rules in your systems
  • The re-measure after 90 days
Book a call
Done for you

Geoff runs it

For owners who would rather hand over the data and get the answer.

  • Geoff profiles the exports and finds the duplicates
  • Writes the rulebook for your approval
  • Sets up the entry rules and the monthly routine
  • Takes the re-measure and reports the change
Book a call
What you'll need

Data you already have

  • Exports from each system holding customer or prospect records
  • Your consent records and returned-post, duplicate-mailing and other cost records, if you keep them
  • Someone who knows the CRM for the working sessions
  • For the agent (guided and done for you): an AI assistant your business already uses or approves, that can run a scheduled task and connect read-only to your CRM, accounting package and mailing tool; we confirm this with your IT before you commit
  • About 6–10 hours, then the clean-up itself (estimate)
Which AI?

Designed for Claude, in an open format

It is built on the open Agent Skills standard and designed for Claude (any plan, with code execution switched on). A paste-in version is included for ChatGPT, Gemini and Microsoft Copilot; it has not yet been tested on them.

The calculations live in the spreadsheet, not in the AI, so the numbers don't depend on which assistant reads them.

Customer records you can trust and use

Book a short call to talk it through.

Book a call
Geoff@fox.coach · 07770 683883 · fox.coach