LOCAL DEMO · NOT LIVEDated snapshot · supplied 19–20 Nov 2026
FEARNALLS INTELLIGENCE HUB — CLIENT PREVIEWDated reporting snapshots. Not connected to live operational systems.
Historical demo data — not a live feed.
Figures are from the supplied brief and prototype, with different source periods.
No Google Sheet, CRM, GA4, Rightmove, Sprift or other account is connected.
Action changes and an unauthenticated local audit trail stay in this browser’s local storage and do not update a workbook.
AIMS edits, mock Drive moves, upload receipts and synthetic import summaries also stay in this browser only.
Upload never sends or stores raw files.
Local approvals are not role-controlled.
Market signals are intelligence, not proof of homeowner intent or permission to contact.
The Friday view
Know what matters. Choose the next move.
A measured view of demand, commercial outcomes and the work that could improve valuation-to-instruction conversion.
Working price lens£350,000–£750,000Confirmation discrepancy
Five commercial questions
Every headline carries its period, source, definition and verification limit.
Dated · not live
CRM snapshot & data quality
Valuations 6 Jan–18 Nov 2026 · current stock snapshot supplied 19 Nov 2026
Raw CRM summary · not a verified funnel
270 valuation records · supplied status fields
Status
Records
Commercial journey · stages, not conversion rates
Source periods and cohort rules differ; unknown stages stay unknown.
Payment status not supplied
Do not calculate conversion across these rows: GA4 events, raw CRM statuses, completed-sale records and fees are not a matched cohort. 81 records are marked Instructed, not independently verified signed instructions. Bookings must not stand in for attended valuations.
Historical proxy context
October 2026 and earlier dated-match figures stay separate from the November CRM status summary.
Aims pulse
No AIMS workbook export was supplied; statuses await a verified baseline.
Request → attended means completed/attended appraisals linked to the same genuine-request cohort.
Booked is not attended. Attended → signed uses the same mature attended-appraisal cohort.
Open and not-yet-mature counts are shown separately when verified data is available.
Acquisition sessions are not outcomes
GA4 channel grouping · 1 Aug–19 Nov 2026 · bars share a session scale
Interpretation: channel sessions are not unique seller enquiries. CRM-linked outcomes and reliable successful-submission events are not available.
Three questions for Friday
Decision-making, not dashboard activity
Who reached us?Which source and page led to an actual, verified enquiry?
What happened next?Was it responded to, attended, qualified and won?
Who owns the next step?Approve no more than three new priorities; give each an owner, date and evidence.
Objectives · evidence · decisions
AIMS
The six business objectives, with locally recorded updates and status changes.
The AIMS OBJECTIVES and AIMS UPDATES workbook rows were not supplied. All objectives begin as “Awaiting baseline”; no status, owner, KPI baseline or November update is invented. Suggested action links are provisional demo mappings to the existing Team actions list.
AIMS update history
Append-only local records; adding an update does not mark a task complete or prove an objective is achieved.
Awareness → site visit → verified outcome
Marketing & clicks
Keep platform clicks, GA4 sessions, enquiries and instructions as separate measures.
Historical channel observations, with distinct source periods
Platform / channel
Period
Platform link clicks
GA4 sessions
Verified enquiries
Linked instructions
Evidence / limitation
Native platform clicks are not GA4 sessions. Do not add them together.
GA4 “Direct” sessions are not proof of a direct-origin seller enquiry.
A local landing page is a page/area dimension, not an exclusive original source.
Source categories for vendor outcomes
Use mutually exclusive original-source categories, with Unknown visible and completeness shown.
Historical source completeness
Raw valuation records only; not unique vendor enquiries or source-linked instructions.
Portal vs verified direct flow
Original source of genuine vendor requests and eventual signed instructions; counts were not supplied.
The 195/270 missing-source count is from raw valuation records, not a source-linked unique-request cohort. No category shares or instruction attribution can be calculated from it.
Google Business Profile
Supplied local snapshot · June–November 2026
November incomplete
Interactions are not unique prospects or confirmed valuations. Weekly profile owner and address/service-area review are not confirmed.
Operational checks to confirm
Proposed checks only; staff ownership and completion were not supplied.
Website intelligence
Top pages
Page rows retain their supplied reporting periods. Verified enquiries and instructions were not supplied.
Dated GA4 extracts
The 20 Oct–15 Nov top-pages extract and 1 Aug–19 Nov seller-page export are different periods. Upton seller-page traffic was not recorded in the supplied export; it is not shown as zero.
GA4 page views and engagement; commercial conversion is unverified
Page
Category
Source period
Views
Active users
Engagement
Verified enquiries
Linked instructions
Page category and area are secondary dimensions. A pageview does not establish a valuation request or instruction.
Genuine enquiries, distinct outcomes
Enquiry funnel
Buyer, seller/valuation, general and other enquiries should not be conflated.
From enquiry to outcome
ReceivedSuccessful form submission or genuine call/email, not a click.
ClassifiedSeller/valuation, buyer/property, general, other or unknown.
Responded toResponse and permitted next step recorded by the team.
Attended valuationAttendance must be confirmed; a booking is not an attendance.
Signed instructionUse reconciled signed dates and the same mature valuation cohort.
Completed sale → fee → paymentKeep each stage separate; receipt evidence was not supplied.
GA4 events are not submissions
Zero reported key events does not prove there were no genuine enquiries. Form starts, clicks and contact events are not unique successful submissions.
Commercial outcomes, stage by stage
Commercial pipeline
Requests, bookings, attendance, qualification, instructions, completion and fees are separate stages.
Current residential stock
Supplied current-stock snapshot · instruction years are not a sales cohort.
New property and sales activity
CRM dated records; do not infer payment or fee recognition beyond the reported summary.
Conversion measures
Evidence before prioritisation
Market radar
Initial area lens: Hoole, Upton, Newton and Vicars Cross.
Research only
Provisional supplied Sprift AI aggregate snapshot dated 19 November 2026 — not live market data.
Counts are listing observations, not Fearnalls CRM-confirmed signed instructions. This page does not identify homeowners,
imply intention to change agent, or give permission to contact anyone.
Observed supply · proposals only
Where should we win instructions?
Share of observed new resale listings, NOT verified share of signed instructions.
1 Jan–19 Nov 2026 · £350k–£750k asking prices
Data quality / How was this counted?
Shares are recalculated from supplied integer listing counts: Fearnalls listing observations divided by each area's observed local market count. The source's decimal-percentage fields were not used. Values describe a listing-share proxy only; they are not signed-instruction share, conversion, revenue attribution, or proof of demand.
Snapshot and freshness: The nominal period is 1 January–19 November 2026. Only cumulative window and since-June counts were supplied, not a month-by-month time series, so no monthly filter or trend is shown. The four analyses have different geography and source freshness. Hoole's response says its latest listing was 18 November. Upton's agent-specific latest-date field repeats 13 November for every agent; listings dated 14–19 November may be missing.
Geography: Hoole uses CH2 3 address-name matching; Upton is largely address-name matched; Newton uses a custom rectangle/polygon after excluding Upton-labelled addresses; Vicars Cross uses address locality within CH3 5. Boundaries, edge streets and overlap remain unresolved.
Deduplication and property evidence: The supplied evidence is aggregate data, not property-level listings or UPRNs. Portal references, address-level deduplication, cross-area overlap and re-listing rules cannot be verified from these extracts. Original asking price, main listing agent and property type cannot be audited from the aggregate rows.
Company aliases: “Currans” and “Currans Homes” may be one company; this has not been resolved. Do not merge or compare those names as confirmed separate firms.
Vicars Cross: 12 listings since 1 June are claimed in the area summary, but the supplied agent rows sum to 10. Post-June share is not verified and is intentionally not calculated.
Historical reconciliation: Earlier three-area Sprift totals of 87 and 103 used differing or unclear boundaries. Current Hoole + Upton + Vicars Cross arithmetic is 99, not a reconciled unique-market total. Do not sum the four area totals as a unique market.
Rightmove scope: The supplied broad CH1/CH2/CH3 Rightmove CSVs report 366 Jan–Nov rows and 186 since June, with broader property scope. These counts cannot be divided into the Sprift neighbourhood totals.
Small samples: A few listings materially change these percentages. June-onwards comparisons are descriptive counts, not a reliable trend. Area-boundary, sampling and source freshness differences limit direct comparisons.
Next evidence needed
Property-level Sprift export with UPRN, exact listing date, original asking price, property type, agent and portal reference/URL.
Re-run Vicars Cross since 1 June and reconcile 12 versus 10 observations.
Validate the Newton/Upton boundary and standardise agency-name aliases.
Tabulate Upton semis £350k–<£450k, Upton detached £550k–<£650k, and Vicars Cross semis £350k–<£450k with sample sizes.
Reconcile verified residential resale properties with 10ninety signed-instruction records before reporting any instruction outcome.
Until that work is complete, these observations support questions for research only; they do not justify contact, campaign spend or an approved action.
What verified market evidence should show
Comparable stock
Source, date, exact area/price filters and property type.
Competitive position
Listings and events compared like-for-like where evidence permits.
Actionable learning
Implications for positioning and content, not inferred homeowner prospects.
An on-market listing, reduction, withdrawal or fall-through is not proof of intent to change agent and is not permission to contact an owner.
One action list · local demo copy
Team actions
Tasks are copied from the supplied prototype, not verified against the live ACTIONS tab.
Director approval, assignment and progress edits persist only in this browser. There is no remote workbook write. Named-owner confirmation and actual evidence are required before tasks can be started or completed.
Monthly account · auditable progress
Track progress
Separate observations, proposals, implemented changes and measured outcomes.
Reported / observedProposedBuilt / retest requiredMeasured
Reported activity is not independently verified implementation; no outcome is marked measured without evidence.
Dated source observations and reporting gaps are transcribed from the supplied November update. They are not live TRACK PROGRESS LOG entries.
Statuses distinguish supplied reports, existing/built items that need retesting, and proposed work. No 30/60/90-day impact is inferred; evidence and named ownership remain unconfirmed unless stated.
The existing ACTIONS list is the sole action source in this demo. Each action can link to a historical insight; no platform adjustment is recorded unless evidenced.
Working links · mock file index
Resources
Quick links stay separate from the local mock Drive explorer.
No Drive connection is active. The static index is only a snapshot, and this synthetic nested tree is not a live inventory. Refresh and move actions affect this browser’s mock index only; no Drive files are changed.
Pinned project documents
Open the source documents directly in a new tab; access is controlled by Google.
Service bookmarks
These are direct provider links, not authenticated dashboard integrations.
Mock Drive explorer
Nested, searchable and sortable local sample records, with stable file-ID identity.
SAMPLE — SYNTHETIC — NOT REAL
Select a mock file to inspect its metadata. Files cannot be opened from this local index.
Source register · local validation wizard
Upload
Prepare source snapshots without sending files to Drive, Sheets or a server.
LOCAL DEMO · NO GOOGLE DRIVE UPLOAD
This dependency-free demo reads selected files in the browser only. Raw files and customer-level values are never written to localStorage or uploaded. Use only approved redacted exports or clearly marked synthetic files. PDF is receipt-only/manual review (no OCR); Excel parsing is unsupported; ZIP is not accepted. The workbook UPLOAD REGISTER was not supplied, so these are provisional requirements.
Source readiness
Cadence, owner and exact schemas must be confirmed against provider exports and the workbook.
Local validation wizard
Receipt → schema checks → local snapshot summary; historic dashboard figures are not changed.
Only metadata and a local summary are retained. The dashboard’s historical KPIs are unchanged.
Local receipts and versions
Append-only metadata; imported summaries remain separate from the historical dashboard.