WREA Email Nurture: CEO Release Gate and Phase 2 Simulation

Later 12 July update: the one-place Email Campaign Studio has now been built and three real Test Send messages were sent only to Thomas's two approved owner addresses. No customer email was sent and production remains unchanged. Open the simpler Campaign Studio CEO release review. The detailed evidence below is preserved as the earlier Phase 1/2 snapshot.

Big TLDR

The software is built and independently reviewed, but it is still isolated from production. No production database was changed and no email was sent. The safe next step is approval, not deployment.

84 / 364relevant tests / assertions passed

GOClaude Code final delta review

0production sends or writes

1audience decision still needed from Thomas

The most important business finding: the rescue logic found 58 recent stalled enquiries, but 46 have no usable email and 12 already show staff activity. Today, zero would enter the rescue campaign. This means the immediate growth constraint is capturing a usable seller email at enquiry, not increasing sending capacity.

Phase 2 now has a safe foundation for one useful local-market issue at a time. The narrow, clearly evidenced audience produces 20 recipients and 3 known test exclusions in the current location-specific simulation. As requested, ongoing utility email has no holdout. The much larger legacy “New Articles” list is not being assumed to be equivalent consent.

What is done versus not done

Builtsuppression safety, rescue journey, previews, results, utility drafts, scheduling and help text

Verifiedatomic commits, full test suite, screenshots, production read-only simulation, Claude review

Not deployedthe production CRM does not yet contain these new screens, tables or safety checks

Not sentno customer and neither approved Thomas test address received an email

Your six decisions have been applied

Legacy workflows

Production was checked read-only: 6 Week Home Seller Plan and Home Selling Masterclass are off. Seller Guide remains on the transactional IP because the seller explicitly requests it.

Sender identity

Recommended default: Thomas at Which Real Estate Agent from and replying to thomasroberts@whichrealestateagent.com.au.

Owner approval, not an invented legal process

The release record asks for your approval and the existing terms basis. It does not require a legal team that does not exist.

Email copy

Drafts are below. They remain drafts until you approve or edit them.

Frequency cap is configurable

The pilot default is no more than 2 marketing emails in 14 days. Both numbers are visible CRM Parameters, not buried in code.

Suppression visibility

A read-only screen now shows each suppressed address, why it is suppressed, where the evidence came from, first/last occurrence and status.

Direct answers to your safety questions

Where do I see the 20% rescue holdout result?

On each rescue campaign page: treatment versus holdout for met agents, appointed an agent and listed online. Rates stay hidden until both groups have at least 20 people, preventing a tiny sample from looking conclusive. A 15-person pilot proves operations, not uplift.

Is 1,000 per hour still needed?

No as a global limit. WREA's stored SendGrid delivery events show marketing IP 149.72.200.78 delivered 7,536 events for 5,085 distinct messages across 136 active days. This proves a long-established sending identity at low volume. The configurable default is now 10,000/hour, but that is an operating ceiling, not evidence of a previous 10,000/hour burst. Its observed historical peak was 92 delivered events in one hour, so pause and review delivery health after the first scheduler batch of any first large edition.

Does rescue start after the 14-day staff block?

No. Rescue only applies from +24 hours until day 7. Any meaningful staff activity in the 14-day lookback removes the seller from this rescue permanently. It does not begin on day 15.

What counts as staff activity?

A call, SMS, direct email or working note. Generic system activity and tasks no longer count as “contact”; an open task remains a separate visible review flag. A note means staff are working the lead, not necessarily that the seller received a message.

What were the 30-day and one-click links?

They were unsubscribe links, not subscribe links. The 30-day expiry has been removed: the signed footer link remains valid, and marketing email also carries the standard one-click unsubscribe header used by Gmail and Yahoo.

Can marketing suppression stop invoices or requested guides?

No. Suppressions, newsletter settings and digest opt-outs apply to marketing. Requested guides, invoice follow-ups and other transactional/service messages stay sendable.

What happened to CC?

Explicit CCs are preserved. Each CC address is checked independently against blacklist and suppression evidence, and a CC bounce/unsubscribe cannot incorrectly suppress the main recipient. Production history had CC mainly on operational/referral/invoice templates; there was no reliable historical marketing classification to prove there were none.

What does “every 10 minutes” mean?

It is a background safety sweep, not an email every 10 minutes. Each person has an exact next-send time. The sweep only picks up due work, respects the 7am-9pm local window and hourly limit, stops after 8 minutes, and cannot overlap another run.

SendGrid basis: IP warm-up guidance, global statistics API, IP details API and required scope, send-time testing, and one-click unsubscribe headers. The current key can read global statistics but lacks ips.read; the per-IP counts above come from WREA's raw SendGrid delivery webhooks, which include the sending IP.

Production simulation: the +24h / +72h rescue

This snapshot was built from small indexed, read-only production queries and joined locally. It created no campaign, enrolment or queue row.

58recent stalled enquiries

46no usable email

12recent staff activity

0receive or holdout today

How the journey would work when an eligible seller exists: preview shows the exact person and reason; 20% are assigned to no-email holdout; the rest receive Email 1 at +24 hours within 7am-9pm local time; Email 2 is due at +72 hours only if the seller is still open, has not progressed, has not unsubscribed and has not been taken over by staff. Then the journey stops.

Show all 58 production candidates and exact decisions

Names and CRM IDs identify the exact records; email addresses are masked in this report. The ignored local evidence file retains the full values and has not been pushed.

Property	Seller	Email	Location	Enquiry created	Decision now	Next send
174904	Sally Galwey	sa***@gmail.com	Sunbury, Victoria	2026-07-06 02:20:06 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
174917	Patrick Easton	pj***@gmail.com	Clareville, NSW	2026-07-06 07:21:35 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
174932	Ghassoub mohamed	None	Vermont South, VIC	2026-07-06 21:56:58 UTC	NO EMAIL	Not scheduled
174939	Sharon	None	Junortoun, Victoria	2026-07-07 00:07:18 UTC	NO EMAIL	Not scheduled
174961	Amanda Healy	None	Malua Bay, NSW	2026-07-07 05:32:34 UTC	NO EMAIL	Not scheduled
174970	Pauline Lee	None	Wembley Downs, WA	2026-07-07 06:46:28 UTC	NO EMAIL	Not scheduled
174973	Zac Bosnich	za***@yahoo.com.au	Idalia, Queensland	2026-07-07 08:53:06 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
174978	Eric Chen	None	Castle Hill, NSW	2026-07-07 13:52:40 UTC	NO EMAIL	Not scheduled
174981	Mel Jones	None	Capel Sound, VIC	2026-07-07 21:15:24 UTC	NO EMAIL	Not scheduled
174987	Melva Wells	None	Theodore, QLD	2026-07-07 23:23:20 UTC	NO EMAIL	Not scheduled
174990	Nicole Lefkovits	le***@icloud.com	Croydon, Victoria	2026-07-07 23:44:10 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
174998	glenda chalker	None	Camden, NSW	2026-07-08 01:26:14 UTC	NO EMAIL	Not scheduled
175013	Ronelle Canavan	ro***@gmail.com	Palm Beach, New South Wales	2026-07-08 06:11:18 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
175023	Julie Compo	None	Mildura, VIC	2026-07-08 12:21:44 UTC	NO EMAIL	Not scheduled
175025	Quyen Hayes	None	Boronia Heights, QLD	2026-07-08 21:25:29 UTC	NO EMAIL	Not scheduled
175026	Roxy Marshall	mo***@brownssms.com.au	Moonta Bay, South Australia	2026-07-08 22:01:08 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
175028	Shawn	sh***@startinvestingaustralia.com.au	South Perth, WA	2026-07-08 23:43:39 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
175031	Stacee Cicchini	None	Wandi, WA	2026-07-09 00:40:53 UTC	NO EMAIL	Not scheduled
175038	Jill cCifford	cl***@gmail.com	Clayfield, QLD	2026-07-09 02:42:59 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
175040	Trevor Schneider	None	Healesville, VIC	2026-07-09 02:47:24 UTC	NO EMAIL	Not scheduled
175052	Deborah Burridge	None	Moggill, QLD	2026-07-09 04:45:03 UTC	NO EMAIL	Not scheduled
175054	Amanda	None	Bayswater, VIC	2026-07-09 04:52:37 UTC	NO EMAIL	Not scheduled
175055	Mart Emis	None	Vaucluse, NSW	2026-07-09 05:56:54 UTC	NO EMAIL	Not scheduled
175056	Melissa Ford	None	Henley Beach, SA	2026-07-09 05:58:09 UTC	NO EMAIL	Not scheduled
175057	Joanne	jo***@hotmail.com	Nundah, QLD	2026-07-09 06:09:10 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
175058	Tim Lam	None	Warrawong, NSW	2026-07-09 08:08:25 UTC	NO EMAIL	Not scheduled
175060	Jacinta allen	None	Cooran, QLD	2026-07-09 08:38:42 UTC	NO EMAIL	Not scheduled
175061	Alicis	None	Redcliffe, QLD	2026-07-09 09:06:47 UTC	NO EMAIL	Not scheduled
175062	Derek Emery	None	Murray Bridge North, SA	2026-07-09 09:43:05 UTC	NO EMAIL	Not scheduled
175064	Janet Bull	None	Townson, QLD	2026-07-09 21:35:28 UTC	NO EMAIL	Not scheduled
175070	Michelle Winduss	None	Hervey Bay, QLD	2026-07-09 23:54:03 UTC	NO EMAIL	Not scheduled
175079	a	None	Leichhardt, NSW	2026-07-10 01:46:17 UTC	NO EMAIL	Not scheduled
175080	Zenon Frontczak	None	Craigmore, SA	2026-07-10 02:06:01 UTC	NO EMAIL	Not scheduled
175082	Henrika	None	Kingaroy, QLD	2026-07-10 02:21:46 UTC	NO EMAIL	Not scheduled
175083	Kim Murphy	None	Yarram, VIC	2026-07-10 02:41:47 UTC	NO EMAIL	Not scheduled
175089	Karen Helou	None	Greystanes, NSW	2026-07-10 03:10:27 UTC	NO EMAIL	Not scheduled
175092	Loveness Matemera	None	Lynwood, WA	2026-07-10 03:52:09 UTC	NO EMAIL	Not scheduled
175093	Paul Popkowski	None	Hampton East, VIC	2026-07-10 04:38:31 UTC	NO EMAIL	Not scheduled
175094	C h	None	Killara, NSW	2026-07-10 04:53:41 UTC	NO EMAIL	Not scheduled
175097	Florian Sung	None	Doncaster, VIC	2026-07-10 05:08:34 UTC	NO EMAIL	Not scheduled
175099	Donna Topic	None	Terrigal, NSW	2026-07-10 05:59:59 UTC	NO EMAIL	Not scheduled
175100	andrew	an***@me.com.au	Ripley, QLD	2026-07-10 06:44:45 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
175102	Kirsty S	None	Banora Point, NSW	2026-07-10 06:55:10 UTC	NO EMAIL	Not scheduled
175103	Fred	None	Woodgate, QLD	2026-07-10 07:01:59 UTC	NO EMAIL	Not scheduled
175105	Jane Parry	None	Blaxland, QLD	2026-07-10 07:56:43 UTC	NO EMAIL	Not scheduled
175106	Devini Goonetilleke	None	Yeronga, QLD	2026-07-10 08:09:38 UTC	NO EMAIL	Not scheduled
175107	ggvg tytv	None	Elliott, TAS	2026-07-10 09:42:03 UTC	NO EMAIL	Not scheduled
175108	Genette Purnell	None	Kingston, ACT	2026-07-10 11:32:41 UTC	NO EMAIL	Not scheduled
175109	B Lee	bp***@gmail.com	Robina, QLD	2026-07-10 11:57:44 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
175110	Finbar Fury	te***@hotmail.com	Newmarket, QLD	2026-07-10 22:12:12 UTC	STAFF COMMUNICATION IN 14 DAYS	Not scheduled
175111	Robin	None	Kellyville, NSW	2026-07-10 23:21:11 UTC	NO EMAIL	Not scheduled
175112	Sophie	None	Carlingford, NSW	2026-07-11 01:03:22 UTC	NO EMAIL	Not scheduled
175113	Alex	None	Leura, NSW	2026-07-11 01:27:53 UTC	NO EMAIL	Not scheduled
175114	Lu	None	Weir Views, VIC	2026-07-11 01:33:15 UTC	NO EMAIL	Not scheduled
175115	Sophie	None	Epping, NSW	2026-07-11 01:51:30 UTC	NO EMAIL	Not scheduled
175116	Liliana Bosancic	None	Loch Sport, VIC	2026-07-11 02:22:41 UTC	NO EMAIL	Not scheduled
175117	Michael Edward	None	Woolloongabba, QLD	2026-07-11 03:43:59 UTC	NO EMAIL	Not scheduled
175118	Bob	None	Pakenham, VIC	2026-07-11 04:00:12 UTC	NO EMAIL	Not scheduled

Draft rescue emails for your approval

Email 1 · +24 hours

Subject: Still looking for the right agent in [Suburb]?

Hi [First name],

You asked Which Real Estate Agent for help finding an agent for your property in [Suburb]. If you are still comparing options, I can help you narrow the choice using local sales experience, fees and fit.

Review suitable agents

If you have already chosen someone or no longer need help, no action is needed.

Thomas
Which Real Estate Agent

Email 2 · +72 hours

Subject: One useful question before you choose an agent

Hi [First name],

One useful check before appointing an agent: ask each one to show the most comparable recent sales, then explain how those sales support their price and marketing recommendation.

The highest appraisal or lowest fee is not always the best result. A clear evidence-based plan is usually more useful.

Review suitable agents

Thomas
Which Real Estate Agent

Phase 2: useful ongoing emails, built to a safe first boundary

The system can now create one dated utility issue per month, preview the audience at scale, schedule for the property’s local time, record a frozen market-data date and content checksum, and send only after owner approval and internal testing are recorded. Ongoing utility email has no holdout.

1,496active contacts with direct “Subscribe to Newsletter” evidence

1,495have a nonblank CRM email before suppression checks

23have both an email and local-property evidence

Why only 23? The newsletter signup endpoint creates a contact, email, “Subscribe to Newsletter” tag and audit note, but it does not create a property. 24 of 1,496 subscribers have any property attached and 23 have a suburb and state. This is expected from an email-only signup path, not a query failure.

How old are these audiences?

CRM audience	Active contacts	First tag seen	Under 1 year	1-3 years	3-5 years	Over 5 years	What this means
Subscribe to Newsletter	1,496	2024-06-06 13:28:45	1,296 (86.6%)	200	0	0	Very recent and explicit. 1,072 contacts, or 71.7%, were added in May-June 2026.
New Articles	38,238	2020-08-11 08:43:02	5,634 (14.7%)	10,375	11,861	10,368	Older, with a large initial 2020 backfill and broader historical meaning. It needs a source/expectation audit before activation.

Can each audience support local-market content?

CRM audience	Contacts	Email before suppression	Any property	Located property	Email + location	Practical use
Subscribe to Newsletter	1,496	1,495	24	23	23	Good for general market and seller education. Only a small subset can receive suburb-specific content today.
New Articles	38,238	34,816	38,236	38,047	34,646	Technically strong for local content, but older and less explicit. Audit consent/source semantics before using it.

The real choice: direct newsletter evidence is clearer but mostly lacks property context; New Articles has 34,646 potential localised contacts before suppression and frequency checks, but is much older. Recommended: use the direct list for general useful emails, then separately audit New Articles before admitting it to localised utility campaigns.

Exact first local utility simulation

20would receive

0utility holdout, as requested

3known tests excluded

Show all 23 direct-signup records, decisions and proposed times

Contact	Subscriber	Email	Local market	Decision	Proposed send
238950	Mary Vu	mh***@yahoo.com.au	Ashmont, New South Wales	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
256615	Stephen Elworthy	st***@bigpond.com	Lilli Pilli, New South Wales	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
221607	Vinnie	bu***@gmail.com	Zetland, New South Wales	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
234037	Suresh Kumar K	su***@outlook.com	Bella Vista, NSW	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
255876	Wimal Wijeratne	wi***@gmail.com	Mascot, NSW	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
259272	Margio Cabreros	ca***@gmail.com	Moree, NSW	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
258034	FelixTestIgnore	ju***@gmail.com	Sydney, NSW	KNOWN TEST RECORD	No send
235950	Joyce Howard	jc***@yahoo.com	Yass, NSW	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
220124	Ed Lloyd	ss***@gmail.com	Cairns, QLD	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
259872	Tester DawalOgatis	re***@whichrealestateagent.com.au	Nerang, QLD	KNOWN TEST RECORD	No send
257615	Kristina Delbridge	kk***@gmail.com	Spring Mountain, Queensland	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
260619	Arjen De Regt	ar***@yahoo.com.sg	Walloon, Queensland	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
239475	Louise McCarthy	fr***@gmail.com	Belair, South Australia	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am ACST
238546	Bev Moulton	b.***@bigpond.com	Klemzig, South Australia	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am ACST
272812	Judita Nagy	ju***@live.com.au	Morphett Vale, South Australia	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am ACST
250778	Ian	ia***@gmail.com	Oakleigh, VIC	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
36065	test	te***@test.com	Point Cook, VIC	KNOWN TEST RECORD	No send
194028	Dana Tymms	da***@gmail.com	Brunswick West, Victoria	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
241040	Mark Cooke	co***@bigpond.com	Yarrawonga, Victoria	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AEST
244708	Dustin	du***@gmail.com	Iluka, WA	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AWST
239050	Ashley R Talbot	as***@gmail.com	Bentley, Western Australia	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AWST
8169	Rod Tatchell	ro***@tatchell.au	Two Rocks, Western Australia	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AWST
255347	Murray Smith	mu***@gmail.com	Warnbro, Western Australia	RECEIVE UTILITY EMAIL	Tue 21 Jul 2026, 9:07am AWST

Simple repeatable content plan

Normal monthly issue

What changed in [Suburb] this month

Three dated local facts, one plain-English interpretation, one implication for a seller, and one useful next step.

Major event replacement

What today’s rate decision may mean for [Suburb] sellers

Replaces the normal monthly issue rather than stacking another email. Facts are frozen “as at” a visible date.

Decision insight

The highest appraisal trap: what to compare instead

A practical seller lesson linked to agent comparison or the separate property-value tool when that tool is ready.

Recommended send-time control: Tuesday at 9:07am in the property’s local timezone, then compare an alternative time over several sufficiently large issues. SendGrid says there is no universal magic hour; it recommends timezone-aware testing and avoiding the exact top of the hour for high-volume delivery. The 10,000/hour ceiling remains visible and configurable in CRM Parameters.

What staff will actually see in the CRM

These are screenshots of the local build using synthetic demonstration records. They are not mock-ups and contain no production customer data.

Email campaign list — **One campaign list**Lane, status, enrolments and sends can be scanned without opening code.

Rescue campaign controls — **Rescue controls and release evidence**Sender, holdout, throttle, approved test addresses and release gates are visible.

Rescue versus holdout results — **Rescue versus no-email holdout**Business outcomes appear together; tiny samples are explicitly hidden from interpretation.

Marketing suppression list — **Read-only marketing suppression list**Staff can search who is excluded and understand why, while transactional messages remain separate.

Utility campaign controls — **One dated utility issue**Audience evidence, sender, no utility holdout, configurable 10,000/hour ceiling, issue date and excluded tests are visible.

Utility campaign schedule — **Simple schedule**One send step, local-time window and approved template. No 12-email sequence.

One audience decision needed before merge or deploy

Confirm the staged audience policy

Recommended: use direct “Subscribe to Newsletter” evidence for general useful emails; use its 23 located records only for the first local-market simulation; separately audit “New Articles” before admitting any of its 34,646 email-plus-location records. Keep the three known tests excluded. No utility holdout.

After that approval: merge and deploy the safety/database foundation; reconcile the production suppression backfill; create the approved rescue templates; send only to trpersonal@gmail.com and thomasroberts@whichrealestateagent.com.au for the internal test; verify unsubscribe, headers, workers and SendGrid delivery health; rerun the production preview; then begin a micro-cohort only if eligible sellers actually exist.

Still prohibited: no customer send, no production enrolment, no broad legacy-list activation and no 10,000-person issue until the above gates are complete.

Independent review and evidence

Claude Code’s final decision was GO for this CEO gate, with no code blocker. It confirmed utility holdout is zero, rescue remains at 20%, suppression and transactional safety are unchanged, the 10,000/hour setting is a configurable ceiling, production analysis is read-only, and the report figures reconcile to the evidence files.

Evidence snapshot: 2026-07-12 04:37:22 UTC. Full customer-level TSV evidence is stored locally under the ignored artifacts/ directory and was not committed or pushed. Checksums are stored beside the files. Product branch: codex/WREA-email-nurture-phases-0-1. Latest focused commit: 89d85cb54.