Sale, installation and servicing of industrial compressed air systems from depots in Telford and Stoke-on-Trent. 72 staff; 8 users in 5 roles.
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.
| Object or spreadsheet | Live records | No owner | Duplicates | No activity for 12 months |
|---|---|---|---|---|
| Accounts accounts and contacts | 4,180 | 29% | 10% | 63% |
| Contacts accounts and contacts | 6,920 | 32% | 9% | 65% |
| Opportunities | 2,121 | 5% | 2% | 50% |
| Activities | 21,400 | 0% | 0% | 0% |
| Renewals spreadsheet | 212 | 0% | 2% | 0% |
| Tenders spreadsheet | 64 | 100% | 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%.
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) | Checked | Failing | Share |
|---|---|---|---|
| Open opportunities with an expected decision date in the past Open opportunities with an expected decision date, at the export date | 214 | 131 | 61% |
| Contacts with marketing consent given but no evidence of it Contacts with the opt-in ticked; none has a date or source recorded | 34 | 34 | 100% |
| Picklist entries recorded as "Other" Industry, competitor and reason-lost entries on records created in the window | 103 | 29 | 28% |
| 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 | 20 | 7 | 35% |
| Stage now, and what people say it means | Now | Records | Median days | Becomes | Created in the window: over the limit |
|---|---|---|---|---|---|
| Lead Sales: any name on a list. Internal sales: anyone who has phoned | Open | 312 | 148 | Enquiry | 38 of 61 |
| Enquiry A price request, though some log it only once a visit is booked | Open | 41 | 19 | Enquiry | 11 of 22 |
| Site visit Visit booked or done; area engineers use it, internal sales don't | Open | 58 | 34 | Qualified | 7 of 19 |
| Quoting Working on a quotation; often left here after it has gone | Open | 37 | 26 | Qualified | 5 of 14 |
| Quoted Quotation sent | Open | 164 | 62 | Quotation sent | 19 of 43 |
| Follow up Quotation chased at least once; some use it to mean 'hot' | Open | 49 | 44 | Quotation sent | 6 of 15 |
| Hot Likely to close this month, by gut feel | Open | 22 | 35 | Negotiating | 2 of 6 |
| Verbal yes Customer said yes; no order yet | Open | 9 | 18 | Negotiating | 1 of 4 |
| Repeat quotation A price for an existing customer | Open | 27 | 6 | Quotation sent | 1 of 17 |
| Renewal (spreadsheet) Contract ends in the next three months | Open | 31 | 40 | Renewal due | 6 of 12 |
| Tender live (spreadsheet) Anything from a notice spotted to a bid submitted | Open | 11 | 27 | Bidding | 1 of 5 |
| On hold Customer went quiet; nobody closes these | Open | 96 | 210 | Lost | 9 of 9 |
| Won Order received (some mark it at the verbal yes) | Closed | 486 | – | Won | – |
| Lost Closed lost; the reason is seldom given | Closed | 702 | – | Lost | – |
| Dead Same as lost; used by two people | Closed | 118 | – | 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).
| # | Stage | Entry criteria | Exit criteria | Most days | Owner |
|---|---|---|---|---|---|
| 1 | Enquiry Pipeline | A named contact at a business has asked for a price, a visit or advice; logged within one working day | Need, site and decision date confirmed (move to Qualified), or closed as Lost if not a fit | 10 | Internal sales |
| 2 | Qualified Pipeline | Need, site, rough budget and decision date confirmed with the contact | Quotation sent to the customer | 21 | Record owner |
| 3 | Quotation sent Best case | Quotation issued, with its value and expected decision date recorded | Customer has said yes (in principle or with an order), or the opportunity is closed as Lost | 30 | Record owner |
| 4 | Negotiating Commit | Customer has said yes in principle; terms, price or start date under discussion | Order or signed contract received, or closed as Lost | 21 | Record owner |
| 5 | Won Won Closed won | Order, signed contract, award notice or renewal confirmed in writing | Hand-off to service planning complete and the account's customer status set to Active customer | – | Record owner |
| 6 | Lost 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 bid | Loss reason recorded; reviewed at the quarterly win-loss analysis | – | Record owner |
| # | Stage | Entry criteria | Exit criteria | Most days | Owner |
|---|---|---|---|---|---|
| 1 | Quotation requested Pipeline | An existing customer has asked for a price for parts, a unit or a job | Quotation sent | 3 | Internal sales |
| 2 | Quotation sent Best case | Quotation issued, with its value and expected decision date recorded | Customer has said yes (in principle or with an order), or the opportunity is closed as Lost | 30 | Record owner |
| 3 | Won Won Closed won | Order, signed contract, award notice or renewal confirmed in writing | Hand-off to service planning complete and the account's customer status set to Active customer | – | Record owner |
| 4 | Lost 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 bid | Loss reason recorded; reviewed at the quarterly win-loss analysis | – | Record owner |
| # | Stage | Entry criteria | Exit criteria | Most days | Owner |
|---|---|---|---|---|---|
| 1 | Renewal due Best case | Service contract ends within 90 days (opportunity created automatically) | Renewal quotation sent with the new annual value | 21 | Service contracts coordinator |
| 2 | Renewal quotation sent Commit | Renewal quotation issued with the new annual value | Renewal confirmed in writing (Won) or notice received (Lost) | 45 | Service contracts coordinator |
| 3 | Won Won Closed won | Order, signed contract, award notice or renewal confirmed in writing | Hand-off to service planning complete and the account's customer status set to Active customer | – | Record owner |
| 4 | Lost 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 bid | Loss reason recorded; reviewed at the quarterly win-loss analysis | – | Record owner |
| # | Stage | Entry criteria | Exit criteria | Most days | Owner |
|---|---|---|---|---|---|
| 1 | Tender identified Pipeline | Invitation to tender, framework call-off or published notice found, with its deadline recorded | Bid or no-bid decision recorded by the sales director | 5 | Bids and marketing coordinator |
| 2 | Bidding Pipeline | Decision to bid recorded, with the reason | Tender submitted before the deadline | 30 | Bids and marketing coordinator |
| 3 | Tender submitted Best case | Tender submitted; value and expected award date recorded | Award or rejection notice received | 60 | Sales director |
| 4 | Won Won Closed won | Order, signed contract, award notice or renewal confirmed in writing | Hand-off to service planning complete and the account's customer status set to Active customer | – | Record owner |
| 5 | Lost 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 bid | Loss reason recorded; reviewed at the quarterly win-loss analysis | – | Record owner |
| Object | Field | Type, values, links and default | Required from | Owner and edit rights | Used by |
|---|---|---|---|---|---|
| Account | Account name | Text | At creation | Internal sales edit: all users | Data quality review |
| Account | Account owner Rename replaces: Account manager | User | At creation | Sales director edit: field owner only | Weekly pipeline review |
| Account | Customer status New replaces: Customer? tick box | Picklist Prospect; Active customer; Lapsed customer; Lost customer default: Prospect | At creation | Internal sales edit: automation only | Customer status review |
| Account | Account tier Rename replaces: Account category (A, B, C) | Picklist A; B; C | By rule | Sales director edit: field owner only | Account reviews with key customers |
| Account | Postcode | Text | At creation | Internal sales edit: all users | Enquiry response |
| Contact | First name | Text | At creation | Internal sales edit: all users | Data quality review |
| Contact | Last name | Text | At creation | Internal sales edit: all users | Data quality review |
| Contact | Contact account | Lookup links to Account | At creation | Internal sales edit: all users | Account reviews with key customers |
| Contact | By rule | Internal sales edit: all users | Marketing email lists | ||
| Contact | Lawful basis: sales contact New | Picklist Legitimate interests; Contract (sole traders only) default: Legitimate interests | At creation | Bids and marketing coordinator edit: field owner only | Outbound call lists |
| Contact | Lawful basis: marketing New | Picklist Legitimate interests; Consent default: Legitimate interests | At creation | Bids and marketing coordinator edit: field owner only | Marketing email lists |
| Contact | Subscriber type New | Picklist Corporate; Sole trader or partnership; Unknown default: Unknown | At creation | Bids and marketing coordinator edit: field owner only | Marketing email lists |
| Contact | Marketing consent Rename replaces: Marketing opt-in | Picklist Not asked; Given; Refused; Withdrawn default: Not asked | At creation | Bids and marketing coordinator edit: all users | Marketing email lists |
| Contact | Consent date and source New | Text | By rule | Bids and marketing coordinator edit: all users | Marketing email lists |
| Contact | TPS/CTPS checked on New | Date | By rule | Bids and marketing coordinator edit: field owner only | Outbound call lists |
| Opportunity | Opportunity name | Text | At creation | Internal sales edit: record owner | Weekly pipeline review |
| Opportunity | Opportunity account | Lookup links to Account | At creation | Internal sales edit: record owner | Weekly pipeline review |
| Opportunity | Main contact New | Lookup links to Contact | New: At creation Rep: At creation Ren: At creation Ten: Bidding | Internal sales edit: record owner | Account reviews with key customers |
| Opportunity | Motion Rename replaces: Type (new or repeat) | Picklist New business; Repeat orders; Renewals; Tenders | At creation | Internal sales edit: record owner | Monthly sales forecast |
| Opportunity | Opportunity owner | User default: Per ownership rule (automation) | At creation | Sales director edit: field owner only | Weekly pipeline review |
| Opportunity | Stage | Stage default: First stage of its motion | At creation | Sales director edit: record owner | Weekly pipeline review |
| Opportunity | Stage entry date New | Date | At creation | Bids and marketing coordinator edit: automation only | Weekly pipeline review |
| Opportunity | Enquiry 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 |
| Opportunity | Value (£ 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 |
| Opportunity | Expected decision date Rename replaces: Close date | Date | New: Qualified Rep: Quotation sent Ren: Renewal quotation sent Ten: Tender submitted | Area sales engineer edit: record owner | Monthly sales forecast |
| Opportunity | Next step and date Rename replaces: Next step | Text | New: Qualified Rep: Quotation sent Ren: Renewal due Ten: Bidding | Area sales engineer edit: record owner | Weekly pipeline review |
| Opportunity | Quotation number New | Text | New: Quotation sent Rep: Quotation sent Ren: Renewal quotation sent Ten: Tender submitted | Internal sales edit: record owner | Hand-off of won jobs |
| Opportunity | Loss reason Rename replaces: Reason lost | Picklist Price; Lost to a rival; Timing or budget; No decision; Specification not met; No bid; Other | Lost | Sales director edit: record owner | Win-loss analysis |
| Opportunity | Bid decision and reason New | Text | Ten: Bidding | Sales director edit: field owner only | Bid or no-bid decision |
| Opportunity | Tender deadline New | Date | Ten: Tender identified | Bids and marketing coordinator edit: record owner | Bid or no-bid decision |
| Opportunity | Incumbent supplier New | Picklist Us; Rival A; Rival B; Rival C; Another firm; Not known default: Not known | Ten: Tender identified | Bids and marketing coordinator edit: record owner | Bid or no-bid decision |
| Opportunity | Buyer contact before the tender New | Yes/No | Ten: Tender identified | Bids and marketing coordinator edit: record owner | Bid or no-bid decision |
| Opportunity | Bid hours New | Number | Ten: Tender submitted | Bids and marketing coordinator edit: record owner | Bid or no-bid decision |
| Opportunity | Service contract New | Lookup links to Service contract | Ren: At creation | Service contracts coordinator edit: record owner | Renewals due list |
| Opportunity | Hand-off complete New | Yes/No default: No | Won | Service contracts coordinator edit: field owner only | Hand-off of won jobs |
| Activity | Activity type Rename replaces: Type | Picklist Call; Visit; Email; Video meeting | At creation | Internal sales edit: record owner | Activity and outcomes report |
| Activity | Activity date | Date | At creation | Internal sales edit: record owner | Activity and outcomes report |
| Activity | Activity account New | Lookup links to Account | At creation | Internal sales edit: record owner | Activity and outcomes report |
| Activity | Call outcome Rename replaces: Outcome | Picklist Spoke: next step agreed; Spoke: not interested; Left a message; No answer; Meeting booked | By rule | Internal sales edit: record owner | Activity and outcomes report |
| Service contract | Contract number New replaces: Renewals spreadsheet: contract ref | Text | At creation | Service contracts coordinator edit: field owner only | Renewals due list |
| Service contract | Contract account New | Lookup links to Account | At creation | Service contracts coordinator edit: field owner only | Renewals due list |
| Service contract | Contract end date New replaces: Renewals spreadsheet: end date | Date | At creation | Service contracts coordinator edit: field owner only | Renewals due list |
| Service contract | Contract length (years) New | Number | At creation | Service contracts coordinator edit: field owner only | Customer status review |
| Service contract | Annual value (£ ex VAT) New replaces: Renewals spreadsheet: value | £ | At creation | Service contracts coordinator edit: field owner only | Renewals due list |
| Stage history | History opportunity New | Lookup links to Opportunity | At creation | Bids and marketing coordinator edit: automation only | Monthly sales forecast |
| Stage history | Stage entered New | Text | At creation | Bids and marketing coordinator edit: automation only | Monthly sales forecast |
| Stage history | Stage entered on New | Date | At creation | Bids 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 rule | Condition | Message | Owner |
|---|---|---|---|
| Decision date not in the past Opportunity · Expected decision date | On an open opportunity, the expected decision date can't be earlier than today | Move the decision date, or close the opportunity | Sales director |
| Evidence when consent is given Contact · Consent date and source | If Marketing consent is Given, Consent date and source must be filled in | Record when and how the contact agreed, and what they were told | Bids 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 given | Add an email, or a phone number if the email isn't known | Internal 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 call | Internal sales |
| Tier once a customer Account · Account tier | When Customer status isn't Prospect, Account tier is required | Set the tier with the sales director | Sales 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 days | Screen the number first (registrations take up to 28 days to apply) | Bids and marketing coordinator |
| Object | Who owns each record | Duplicate 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 year | Company registration number; else name and postcode |
| Contact A named person at an account | Follows the account's owner | Email 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 director | Account, 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 visit | None: each activity is a separate event |
| Service contract A live service contract with its end date, length and annual value | The service contracts coordinator | Contract number |
| Stage history One stage an opportunity entered, and when (kept, never overwritten) | Created by automation; nobody edits it | None: one record per stage change |
| When | From → to | What must be complete | Working days |
|---|---|---|---|
| New enquiry logged | Internal sales → Area sales engineer | Account, contact, enquiry source, and the next step with its date | 1 |
| Quotation over £25,000 reaches Negotiating (only some) | Area sales engineer → Sales director | Value, expected decision date, rival quoted and the terms asked for | 2 |
| Opportunity won | Record owner → Service contracts coordinator | Quotation number, the order or contract, the site contact; Hand-off complete ticked on receipt | 2 |
| Tender identified | Bids and marketing coordinator → Sales director | Tender deadline, incumbent, buyer contact and likely value, for the bid or no-bid decision | 1 |
| Opportunity lost over £10,000 (only some) | Area sales engineer → Sales director | Loss reason and rival quoted, for the win-loss analysis | 2 |
| An account owner leaves or changes territory | Sales director → Area sales engineer | Every open opportunity and account reassigned; none left without an owner | 5 |
| Automation | Action | Owner | Serves |
|---|---|---|---|
| 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 coordinator | Monthly 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 review | Sales director | Weekly 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 day | Sales director | Enquiry 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 coordinator | Renewals due list |
| Loss reason before closing When: Opportunity moved to Lost | Block the move until Loss reason is filled in | Sales director | Win-loss analysis |
| Won hand-off When: Opportunity moved to Won | Task to the service contracts coordinator; set the account's Customer status to Active customer | Service contracts coordinator | Hand-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 owner | Sales director | Customer 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 list | Bids and marketing coordinator | Marketing email lists |
| Duplicate warning When: An account or contact is created | Warn if the registration number, email, or name and postcode match an existing record | Bids and marketing coordinator | Data quality review |
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).
| Catalogue product | What it needs, and what its own kit asks for | Status |
|---|---|---|
| Sales Forecast and Pipeline Review | Each 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 Review | A 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 Rescue | When 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 Decision | Each 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 Review | Customer 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 Pack | Contacts 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 Scripts | Call 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 Library | Objections 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 Plan | Account 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.
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”.
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.
| Date | What the agent found | What 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.