CRM Blueprint · October 2026

Gorsewick Compressed Air Ltd

Sale, installation and servicing of industrial compressed air systems from depots in Telford and Stoke-on-Trent. 72 staff; 8 users in 5 roles.

Worked example. Gorsewick Compressed Air and its figures are fictional. All figures come from the worked-example spreadsheet: ALL CHECKS PASSED (with 2 notes).
The headline

One meaning for every stage, a field for every report, and an owner for every record

Key-field completion now
53%
9 key fields, counted from the stage each is needed; target 95% (assumed)
Stage-age compliance now
53%
open opportunities created in the last 90 days; target 80% (assumed)
Spot-check
7 of 20
records that don’t match their source document
Catalogue products unlocked
4 of 9
the other 5 run off the ledger, phone logs or a tally: not counted

Verdict: Today the key fields are 53% complete, counted from the stage each is needed, and 53% of open opportunities created in the last 90 days are within their stage's most days; on accounts and contacts 31% of records have no owner, and 7 of 20 records spot-checked don't match their source. The blueprint turns 15 stages now into 12 stage names across 4 motions, 19 of 19 with entry and exit criteria; it defines 60 fields, 47 required and each used by a report, decision or process; and sets 6 hand-off rules, 6 validation rules and 9 automations, each with an owner, with no contradictions. It makes 4 catalogue products possible or reliable from go-live; 5 more run off other records or are already possible, and aren't counted. Early read on 11 Apr 2027; measure again on 11 Jul 2027, from the same export: key-field completion (target 95%, assumed), stage-age compliance (target 80%, assumed) and validity.

Current state

From one export on 9 October 2026: the reports couldn’t be trusted, and the export shows why

Object or spreadsheetLive recordsNo ownerDuplicatesNo activity for 12 months
Accounts accounts and contacts4,18029%10%63%
Contacts accounts and contacts6,92032%9%65%
Opportunities2,1215%2%50%
Activities21,4000%0%0%
Renewals spreadsheet2120%2%0%
Tenders spreadsheet64100%5%34%

34,897 live records in 6 objects or spreadsheets. On the 11,100 accounts and contacts: no owner 31%; duplicates 9%; no activity for 12 months 64%.

Outcome (calls only) (activities)18% of 2,240Next step (records that reached a site visit or later) (opportunities)25% of 150Reason lost (lost records only) (opportunities)27% of 71Lead source (opportunities)34% of 188Close date (records that reached a site visit or later) (opportunities)59% of 150Account manager (accounts)63% of 140Type (new or repeat) (opportunities)64% of 188Value (records that reached a quotation) (opportunities)93% of 121Account category (customers only) (accounts)97% of 31

Key fields on records created in the 90 days before the export; red under 50%. The dashed line is the average, 53%: each field counts once.

Validity measure (lower is better)CheckedFailingShare
Open opportunities with an expected decision date in the past
Open opportunities with an expected decision date, at the export date
21413161%
Contacts with marketing consent given but no evidence of it
Contacts with the opt-in ticked; none has a date or source recorded
3434100%
Picklist entries recorded as "Other"
Industry, competitor and reason-lost entries on records created in the window
1032928%
Blind spot-check: records that don't match their source document
20 records drawn at random by the sales director, checked by the finance assistant against quotations, orders and emails without seeing who entered them
20735%
Stages now

15 stages, taken to mean different things, become the new ones

Stage now, and what people say it meansNowRecordsMedian daysBecomesCreated in the window: over the limit
Lead
Sales: any name on a list. Internal sales: anyone who has phoned
Open312148Enquiry38 of 61
Enquiry
A price request, though some log it only once a visit is booked
Open4119Enquiry11 of 22
Site visit
Visit booked or done; area engineers use it, internal sales don't
Open5834Qualified7 of 19
Quoting
Working on a quotation; often left here after it has gone
Open3726Qualified5 of 14
Quoted
Quotation sent
Open16462Quotation sent19 of 43
Follow up
Quotation chased at least once; some use it to mean 'hot'
Open4944Quotation sent6 of 15
Hot
Likely to close this month, by gut feel
Open2235Negotiating2 of 6
Verbal yes
Customer said yes; no order yet
Open918Negotiating1 of 4
Repeat quotation
A price for an existing customer
Open276Quotation sent1 of 17
Renewal (spreadsheet)
Contract ends in the next three months
Open3140Renewal due6 of 12
Tender live (spreadsheet)
Anything from a notice spotted to a bid submitted
Open1127Bidding1 of 5
On hold
Customer went quiet; nobody closes these
Open96210Lost9 of 9
Won
Order received (some mark it at the verbal yes)
Closed486–Won–
Lost
Closed lost; the reason is seldom given
Closed702–Lost–
Dead
Same as lost; used by two people
Closed118–Lost–

Days in stage come from the last change date (any edit resets it), so the figures flatter the pipeline. Stage ages are counted on opportunities created in the 90 days before the export; at the re-measure, on those created after go-live, so closing old records can’t flatter it. 53% of 227 open opportunities created in the window within their stage's most days (days taken from the last change date).

The stages, by motion

Every stage has entry and exit criteria and a forecast category; Won and Lost belong to the record owner

New business

#StageEntry criteriaExit criteriaMost daysOwner
1Enquiry
Pipeline
A named contact at a business has asked for a price, a visit or advice; logged within one working dayNeed, site and decision date confirmed (move to Qualified), or closed as Lost if not a fit10Internal sales
2Qualified
Pipeline
Need, site, rough budget and decision date confirmed with the contactQuotation sent to the customer21Record owner
3Quotation sent
Best case
Quotation issued, with its value and expected decision date recordedCustomer has said yes (in principle or with an order), or the opportunity is closed as Lost30Record owner
4Negotiating
Commit
Customer has said yes in principle; terms, price or start date under discussionOrder or signed contract received, or closed as Lost21Record owner
5Won Won
Closed won
Order, signed contract, award notice or renewal confirmed in writingHand-off to service planning complete and the account's customer status set to Active customer–Record owner
6Lost Lost
Omitted
The customer said no, chose someone else, gave notice, or hasn't replied for 30 days after the expected decision date; or we decided not to bidLoss reason recorded; reviewed at the quarterly win-loss analysis–Record owner

Repeat orders

#StageEntry criteriaExit criteriaMost daysOwner
1Quotation requested
Pipeline
An existing customer has asked for a price for parts, a unit or a jobQuotation sent3Internal sales
2Quotation sent
Best case
Quotation issued, with its value and expected decision date recordedCustomer has said yes (in principle or with an order), or the opportunity is closed as Lost30Record owner
3Won Won
Closed won
Order, signed contract, award notice or renewal confirmed in writingHand-off to service planning complete and the account's customer status set to Active customer–Record owner
4Lost Lost
Omitted
The customer said no, chose someone else, gave notice, or hasn't replied for 30 days after the expected decision date; or we decided not to bidLoss reason recorded; reviewed at the quarterly win-loss analysis–Record owner

Renewals

#StageEntry criteriaExit criteriaMost daysOwner
1Renewal due
Best case
Service contract ends within 90 days (opportunity created automatically)Renewal quotation sent with the new annual value21Service contracts coordinator
2Renewal quotation sent
Commit
Renewal quotation issued with the new annual valueRenewal confirmed in writing (Won) or notice received (Lost)45Service contracts coordinator
3Won Won
Closed won
Order, signed contract, award notice or renewal confirmed in writingHand-off to service planning complete and the account's customer status set to Active customer–Record owner
4Lost Lost
Omitted
The customer said no, chose someone else, gave notice, or hasn't replied for 30 days after the expected decision date; or we decided not to bidLoss reason recorded; reviewed at the quarterly win-loss analysis–Record owner

Tenders

#StageEntry criteriaExit criteriaMost daysOwner
1Tender identified
Pipeline
Invitation to tender, framework call-off or published notice found, with its deadline recordedBid or no-bid decision recorded by the sales director5Bids and marketing coordinator
2Bidding
Pipeline
Decision to bid recorded, with the reasonTender submitted before the deadline30Bids and marketing coordinator
3Tender submitted
Best case
Tender submitted; value and expected award date recordedAward or rejection notice received60Sales director
4Won Won
Closed won
Order, signed contract, award notice or renewal confirmed in writingHand-off to service planning complete and the account's customer status set to Active customer–Record owner
5Lost Lost
Omitted
The customer said no, chose someone else, gave notice, or hasn't replied for 30 days after the expected decision date; or we decided not to bidLoss reason recorded; reviewed at the quarterly win-loss analysis–Record owner
The field dictionary

47 required fields, each used by a report, decision or process, required from the stage it’s first known in each motion

ObjectFieldType, values, links and defaultRequired fromOwner and edit rightsUsed by
AccountAccount nameTextAt creationInternal sales
edit: all users
Data quality review
AccountAccount owner Rename
replaces: Account manager
UserAt creationSales director
edit: field owner only
Weekly pipeline review
AccountCustomer status New
replaces: Customer? tick box
Picklist
Prospect; Active customer; Lapsed customer; Lost customer
default: Prospect
At creationInternal sales
edit: automation only
Customer status review
AccountAccount tier Rename
replaces: Account category (A, B, C)
Picklist
A; B; C
By ruleSales director
edit: field owner only
Account reviews with key customers
AccountPostcodeTextAt creationInternal sales
edit: all users
Enquiry response
ContactFirst nameTextAt creationInternal sales
edit: all users
Data quality review
ContactLast nameTextAt creationInternal sales
edit: all users
Data quality review
ContactContact accountLookup
links to Account
At creationInternal sales
edit: all users
Account reviews with key customers
ContactEmailEmailBy ruleInternal sales
edit: all users
Marketing email lists
ContactLawful basis: sales contact NewPicklist
Legitimate interests; Contract (sole traders only)
default: Legitimate interests
At creationBids and marketing coordinator
edit: field owner only
Outbound call lists
ContactLawful basis: marketing NewPicklist
Legitimate interests; Consent
default: Legitimate interests
At creationBids and marketing coordinator
edit: field owner only
Marketing email lists
ContactSubscriber type NewPicklist
Corporate; Sole trader or partnership; Unknown
default: Unknown
At creationBids and marketing coordinator
edit: field owner only
Marketing email lists
ContactMarketing consent Rename
replaces: Marketing opt-in
Picklist
Not asked; Given; Refused; Withdrawn
default: Not asked
At creationBids and marketing coordinator
edit: all users
Marketing email lists
ContactConsent date and source NewTextBy ruleBids and marketing coordinator
edit: all users
Marketing email lists
ContactTPS/CTPS checked on NewDateBy ruleBids and marketing coordinator
edit: field owner only
Outbound call lists
OpportunityOpportunity nameTextAt creationInternal sales
edit: record owner
Weekly pipeline review
OpportunityOpportunity accountLookup
links to Account
At creationInternal sales
edit: record owner
Weekly pipeline review
OpportunityMain contact NewLookup
links to Contact
New: At creation
Rep: At creation
Ren: At creation
Ten: Bidding
Internal sales
edit: record owner
Account reviews with key customers
OpportunityMotion Rename
replaces: Type (new or repeat)
Picklist
New business; Repeat orders; Renewals; Tenders
At creationInternal sales
edit: record owner
Monthly sales forecast
OpportunityOpportunity ownerUser
default: Per ownership rule (automation)
At creationSales director
edit: field owner only
Weekly pipeline review
OpportunityStageStage
default: First stage of its motion
At creationSales director
edit: record owner
Weekly pipeline review
OpportunityStage entry date NewDateAt creationBids and marketing coordinator
edit: automation only
Weekly pipeline review
OpportunityEnquiry source Rename
replaces: Lead source
Picklist
Website; Phone in; Existing customer; Referral; Trade show; Tender portal; Outbound
New: At creation
Rep: At creation
Ten: At creation
Internal sales
edit: record owner
Enquiries by source
OpportunityValue (£ ex VAT) Rename
replaces: Value
£New: Quotation sent
Rep: Quotation sent
Ren: Renewal quotation sent
Ten: Tender submitted
Area sales engineer
edit: record owner
Monthly sales forecast
OpportunityExpected decision date Rename
replaces: Close date
DateNew: Qualified
Rep: Quotation sent
Ren: Renewal quotation sent
Ten: Tender submitted
Area sales engineer
edit: record owner
Monthly sales forecast
OpportunityNext step and date Rename
replaces: Next step
TextNew: Qualified
Rep: Quotation sent
Ren: Renewal due
Ten: Bidding
Area sales engineer
edit: record owner
Weekly pipeline review
OpportunityQuotation number NewTextNew: Quotation sent
Rep: Quotation sent
Ren: Renewal quotation sent
Ten: Tender submitted
Internal sales
edit: record owner
Hand-off of won jobs
OpportunityLoss reason Rename
replaces: Reason lost
Picklist
Price; Lost to a rival; Timing or budget; No decision; Specification not met; No bid; Other
LostSales director
edit: record owner
Win-loss analysis
OpportunityBid decision and reason NewTextTen: BiddingSales director
edit: field owner only
Bid or no-bid decision
OpportunityTender deadline NewDateTen: Tender identifiedBids and marketing coordinator
edit: record owner
Bid or no-bid decision
OpportunityIncumbent supplier NewPicklist
Us; Rival A; Rival B; Rival C; Another firm; Not known
default: Not known
Ten: Tender identifiedBids and marketing coordinator
edit: record owner
Bid or no-bid decision
OpportunityBuyer contact before the tender NewYes/NoTen: Tender identifiedBids and marketing coordinator
edit: record owner
Bid or no-bid decision
OpportunityBid hours NewNumberTen: Tender submittedBids and marketing coordinator
edit: record owner
Bid or no-bid decision
OpportunityService contract NewLookup
links to Service contract
Ren: At creationService contracts coordinator
edit: record owner
Renewals due list
OpportunityHand-off complete NewYes/No
default: No
WonService contracts coordinator
edit: field owner only
Hand-off of won jobs
ActivityActivity type Rename
replaces: Type
Picklist
Call; Visit; Email; Video meeting
At creationInternal sales
edit: record owner
Activity and outcomes report
ActivityActivity dateDateAt creationInternal sales
edit: record owner
Activity and outcomes report
ActivityActivity account NewLookup
links to Account
At creationInternal sales
edit: record owner
Activity and outcomes report
ActivityCall outcome Rename
replaces: Outcome
Picklist
Spoke: next step agreed; Spoke: not interested; Left a message; No answer; Meeting booked
By ruleInternal sales
edit: record owner
Activity and outcomes report
Service contractContract number New
replaces: Renewals spreadsheet: contract ref
TextAt creationService contracts coordinator
edit: field owner only
Renewals due list
Service contractContract account NewLookup
links to Account
At creationService contracts coordinator
edit: field owner only
Renewals due list
Service contractContract end date New
replaces: Renewals spreadsheet: end date
DateAt creationService contracts coordinator
edit: field owner only
Renewals due list
Service contractContract length (years) NewNumberAt creationService contracts coordinator
edit: field owner only
Customer status review
Service contractAnnual value (£ ex VAT) New
replaces: Renewals spreadsheet: value
£At creationService contracts coordinator
edit: field owner only
Renewals due list
Stage historyHistory opportunity NewLookup
links to Opportunity
At creationBids and marketing coordinator
edit: automation only
Monthly sales forecast
Stage historyStage entered NewTextAt creationBids and marketing coordinator
edit: automation only
Monthly sales forecast
Stage historyStage entered on NewDateAt creationBids and marketing coordinator
edit: automation only
Monthly sales forecast

Optional: Sector, Last invoice date, Annual spend last 12 months (£), Company registration number, Phone, Job title, Contact role, Do not contact, Last activity date, Site visited, Rival quoted, Activity opportunity, Objection heard. 16 picklists; 0 over 12 values; 3 with "Other"; the share under “Other” is a validity measure.

Validation ruleConditionMessageOwner
Decision date not in the past
Opportunity · Expected decision date
On an open opportunity, the expected decision date can't be earlier than todayMove the decision date, or close the opportunitySales director
Evidence when consent is given
Contact · Consent date and source
If Marketing consent is Given, Consent date and source must be filled inRecord when and how the contact agreed, and what they were toldBids and marketing coordinator
Email or phone
Contact · Email
A contact needs an email or a phone number; leave the email blank only if it isn't known and a phone number is givenAdd an email, or a phone number if the email isn't knownInternal sales
Call outcome on calls
Activity · Call outcome
When Activity type is Call, Call outcome is required (not for visits, emails or meetings)Pick what happened on the callInternal sales
Tier once a customer
Account · Account tier
When Customer status isn't Prospect, Account tier is requiredSet the tier with the sales directorSales director
Screen before an outbound call
Contact · TPS/CTPS checked on
Before an outbound sales call is logged, the number must have been checked against the TPS and CTPS within the last 28 daysScreen the number first (registrations take up to 28 days to apply)Bids and marketing coordinator
Ownership and hand-offs

Every record has an owner; every hand-off says what must be complete first

ObjectWho owns each recordDuplicate rule
Account
A customer or prospect business: one per legal entity, sites held as addresses
The area sales engineer for the postcode; internal sales for accounts spending under £10,000 a yearCompany registration number; else name and postcode
Contact
A named person at an account
Follows the account's ownerEmail address; else first name, last name and account
Opportunity
One quotation, renewal or tender we are trying to win
The account's owner; renewals the service contracts coordinator; tenders the bids and marketing coordinator until submitted, then the sales directorAccount, motion and quotation number
Activity
A call, visit, email or meeting logged against an account and, where there is one, an opportunity
Whoever made the call or visitNone: each activity is a separate event
Service contract
A live service contract with its end date, length and annual value
The service contracts coordinatorContract number
Stage history
One stage an opportunity entered, and when (kept, never overwritten)
Created by automation; nobody edits itNone: one record per stage change
WhenFrom → toWhat must be completeWorking days
New enquiry loggedInternal sales → Area sales engineerAccount, contact, enquiry source, and the next step with its date1
Quotation over £25,000 reaches Negotiating (only some)Area sales engineer → Sales directorValue, expected decision date, rival quoted and the terms asked for2
Opportunity wonRecord owner → Service contracts coordinatorQuotation number, the order or contract, the site contact; Hand-off complete ticked on receipt2
Tender identifiedBids and marketing coordinator → Sales directorTender deadline, incumbent, buyer contact and likely value, for the bid or no-bid decision1
Opportunity lost over £10,000 (only some)Area sales engineer → Sales directorLoss reason and rival quoted, for the win-loss analysis2
An account owner leaves or changes territorySales director → Area sales engineerEvery open opportunity and account reassigned; none left without an owner5
Automations

9 that matter, each with an owner, none contradicting the ownership rules

AutomationActionOwnerServes
Stamp the stage entry date and keep the history
When: Stage changes
Set Stage entry date to today and add a Stage history record (opportunity, stage, date)Bids and marketing coordinatorMonthly sales forecast
Stage-age alert
When: An opportunity has been in its stage longer than the stage's most days
Task to the opportunity owner; listed at the weekly pipeline reviewSales directorWeekly pipeline review
Assign new enquiries
When: Opportunity created at Enquiry
Assign to the account's owner: the area sales engineer for the postcode, or internal sales for accounts spending under £10,000 a year; follow-up task due next working daySales directorEnquiry response
Create renewal opportunities
When: Service contract end date is 90 days away
Create a Renewals opportunity at Renewal due, owned per the ownership rule (the service contracts coordinator)Service contracts coordinatorRenewals due list
Loss reason before closing
When: Opportunity moved to Lost
Block the move until Loss reason is filled inSales directorWin-loss analysis
Won hand-off
When: Opportunity moved to Won
Task to the service contracts coordinator; set the account's Customer status to Active customerService contracts coordinatorHand-off of won jobs
Flag lapsed customers
When: An Active customer has no sales invoice for 18 months (Last invoice date, from the accounting package) and no live service contract of any length
Set Customer status to Lapsed customer; task to the account ownerSales directorCustomer status review
Consent withdrawn
When: Marketing consent set to Withdrawn, or Do not contact ticked
Remove from every marketing and call list and keep on the suppression listBids and marketing coordinatorMarketing email lists
Duplicate warning
When: An account or contact is created
Warn if the registration number, email, or name and postcode match an existing recordBids and marketing coordinatorData quality review
Data rules

UK GDPR and PECR basics on every contact (not legal advice)

Lawful basis set per purpose by its owner, marketing consent with evidence, subscriber type, TPS and CTPS screening and do not contact on Contact; contacts with no activity for 36 months deleted or anonymised, suppression records kept; reviewed by Bids and marketing coordinator, every six months.

The lawful basis is decided per purpose and documented (ICO, a guide to lawful basis, updated 2 April 2026): legitimate interests for B2B sales contact and marketing, set by the bids and marketing coordinator, not chosen per contact; “contract” only for sole traders. Marketing consent is its own field, with who, when and how (ICO, how to record consent). Subscriber type decides the email rule: PECR’s email rule doesn’t apply to companies, but sole traders and some partnerships need consent or the soft opt-in, and an unknown type is treated as an individual. Numbers are screened against the TPS and CTPS before outbound calls (registrations take up to 28 days to apply). Objectors stay on the suppression list, which retention never deletes (ICO, business-to-business marketing).

How the value is shown

Unlocks: what the other products’ own kits ask the CRM for

Catalogue productWhat it needs, and what its own kit asks forStatus
Sales Forecast and Pipeline ReviewEach stage an opportunity entered, and when (Stage entered on, not recorded now)
A value on every quoted opportunity (Value (£ ex VAT), 93% now)
An expected decision date on every qualified opportunity (Expected decision date, 59% now)
Its own kit asks for: Open deals with stage, value, expected close and created date; closed deals by the furthest stage reached (its SKILL.md)
Unlocked at go-live
Win-Loss ReviewA loss reason on every lost opportunity (Loss reason, 27% now)
Where each enquiry came from (Enquiry source, 34% now)
Its own kit asks for: Every quotation sent in 12 months with source and outcome, and the reason recorded for each loss (its SKILL.md)
Unlocked at go-live
Stalled Deal RescueWhen each opportunity last really moved (Stage entered on, not recorded now)
Its own kit asks for: Open deals with value, stage and when each last really moved; a year of closed deals with how long each sat (its SKILL.md)
Unlocked at go-live
Tender Bid DecisionEach bid or no-bid decision with its reason (Bid decision and reason, not recorded now)
Who holds the contract now (Incumbent supplier, not recorded now)
Whether we knew the buyer before the tender (Buyer contact before the tender, not recorded now)
Hours spent on each bid (Bid hours, not recorded now)
Its own kit asks for: Past bids, results and values; bid hours; whether you knew the buyer or shaped the specification (its SKILL.md)
Unlocked at go-live
Customer Retention ReviewCustomer status helps, but the review runs off revenue by customer
Its own kit asks for: Revenue by customer for two 12-month periods, from the sales ledger (its SKILL.md)
Runs off other records: not counted
Account Review PackContacts by role help, but the pack runs off sales by customer
Its own kit asks for: Sales by customer for 24 months, from the sales ledger; contracts file; diaries (its SKILL.md)
Runs off other records: not counted
Call and Appointment ScriptsCall outcomes help, but the product runs off dial records
Its own kit asks for: Up to 500 dials with outcome: phone-system outcome codes, CRM call notes or a two-week tally (its SKILL.md)
Runs off other records: not counted
Objection Handling LibraryObjections heard help, but the best source is a tally
Its own kit asks for: The objections: a two-week tally by the team is the best source (its SKILL.md)
Runs off other records: not counted
Key Account Growth PlanAccount tier helps, but the plan runs off sales by product line
Its own kit asks for: Sales by key account and product line, from the sales or accounting system (its SKILL.md)
Runs off other records: not counted

Measure later. Key-field completion 53% now → 95% target; stage-age compliance 53% now → 80% target; validity measures taken again alongside. Early read on 11 Apr 2027; re-measure on 11 Jul 2027 (six months after go-live), from the same export: the same fields, a window of the same length, days in stage taken the same way, stage ages on opportunities created after go-live, and a fresh blind spot-check of 20. Completion and stage ages count every record, so chance isn’t the issue; a bulk import, a season or one large tender can still move them. No £ is put on these: the money is made in the products it unlocks. Cost in full: £9,580: fee £3,500, team time £1,280, configuration £4,800.

How confident are we?

What this rests on

The current state comes from one export taken on 9 Oct 2026 (Report-builder export of accounts, contacts, opportunities and activities from the CRM, plus the renewals and tenders spreadsheets, taken by the bids and marketing coordinator); completion is counted on records created in the 90 days before it, from the stage the blueprint requires each field, each key field counting once; stage ages on open opportunities created in the same window, taken from the last change date, which any edit resets, so today's figure flatters the pipeline. The validity measures are counted from the same export, and the spot-check is a sample of 20 records checked blind against source documents, so it shows direction only. The stages, criteria, fields, owners, hand-offs, rules and automations are the design agreed with the users; whether the team follows them is what the re-measure shows. Products count only where their own kit takes its figures from the CRM; those that run off the sales ledger, phone logs or a tally aren't counted, nor is a product whose field is already at least 90% complete (assumed). The mix (a bulk import, a season, one large tender) can move the measures without the work, so the re-measure uses the same export, fields and window length, on opportunities created after go-live. The targets are the owner's, assumed. No £ is put on the measures: the money is made in the products it unlocks, each valued from the business's own records in its own workbook.

The blueprint is finished when it is handed over; configuring the CRM is the next job. Whoever configures it works from the blueprint document, and the team gets the one-page “how we use the CRM”.

The months after

What the agent flagged, and what was decided

Gorsewick chose the guided route. The agent was set up in the final working session, in an AI assistant the business already uses, with read-only access to the CRM and this workbook (its IT confirmed this before it committed); its first run was the Monday after go-live on 11 January. Every Monday it takes the export the way Inputs describes, checks the records against the stages, fields and rules agreed here, counts the measures the same way as the current state, and sends the managing director a short note listing breaks by owner role. It uses the targets on Inputs (95% key-field completion, 80% stage-age compliance), flagged from the early read on. Nothing left Gorsewick, and no decision changed, without one of its own people approving it. These events continue the fictional example.

DateWhat the agent foundWhat was decided
18 Jan 2027
No flag
First run after go-live: 88% key-field completion and 96% stage-age compliance, both on fewer than 30 records, so marked as small. Three records over their most days were listed for their owners.Nothing needed. The managing director read the note.
1 Feb 2027
Flag
A stage that isn't in the blueprint, On hold, had been added to New business, and four opportunities moved into it.The managing director hadn't agreed it. The set-up was put back, and the owners returned the four records to their earlier stages: a paused deal keeps its stage with a next-step date.
22 Feb 2027
Flag
Two new contacts from a trade show list had marketing consent without evidence.The bids and marketing coordinator removed the consent until evidence is found.
8 Mar 2027
Flag
An edit had left a stage row on the Stages sheet with no most days, so Checks showed CHECK. The note said so, named the check and gave no figures.The sales director had meant to change it; with the managing director, 3 days was kept, and Checks passed the same morning.
12 Apr 2027
Flag
Early read: key-field completion 91% (target 95%) and stage-age compliance 74% (target 80%), on 162 and 118 records.Not judged yet, as the method says. The 31 records over their most days went through with their owners, and the two fields most often empty joined the Monday pipeline meeting.
12 Jul 2027
Flag
Re-measure: the export taken the same way gave 96% key-field completion and 83% stage-age compliance. The re-measure copy waits for the blind spot-check.The bids and marketing coordinator does the spot-check that week; the sales director confirms the export method.

The check-in was held on 10 February, 30 days after go-live rather than after handover, when Geoff and the managing director read the first log together. No rule needed changing. Geoff's upkeep ended there; after that the agent and its log were Gorsewick's.

What the agent added. The method is unchanged: same blueprint, same measures, same rules. The agent made sure the records were checked against the agreed rules every week, so a stage added without agreement was caught within a week, and the early read and re-measure were taken the same way as the baseline. The measures in these events are fictional readings; the value case above (Unlocks, with the measure-later line) is unchanged, and no £ figure is put on them.

Fictional and labelled: these events continue the worked example. The same six events are the sample rows in the Agent log of the worked-example spreadsheet. The agent is part of the guided and done-for-you routes; the self-implement kit does not include it. Not legal advice.