SATI Dashboard - The Zero Phuket

The Zero Phuket — Performance Dashboard

Campaign status: Strong ↑ · SATI spam down to 31% this week (from 60% at peak) · 12 SATI prospects actively in motion · 263 total SATI leads · 36.1% spam rate (improving)

Spam Rate — This Week

31%

SATI Google Ads leads, May 11–17

↓ From 60% at campaign peak · up vs last 2 days

SATI Active Pipeline

106

Leads not yet lost — still in play

~50% of all 263 SATI leads alive

Prospects in Motion

SATI leads at Prospect+ stage

All created <20 days ago

Ever Qualified — All Time

Leads that reached Prospect+ (incl. Closed-Lost)

CPL denominator · 7.2% of 263 SATI leads

Cost Per Qualified Lead

15,980

THB · 303,619 spend ÷ 19 qualified leads

Apr 1–May 18, 2026 · all SATI campaigns

The biggest win

Spam Rate Journey — SATI Campaigns Since Launch

Apr 14–20

57%

14 leads

Apr 21–27

60%

35 leads

Apr 28–May 4

20%

15 leads

May 4–10

35%

71 leads

May 11–17

31%

117 leads

reCAPTCHA v3 + honeypot deployed Week 17. Spam at 31% this week vs 60% at peak — 48% reduction. Volume surge (117 leads May 11–17) reflects PMax scale-up.

Pipeline Aliveness by Source

% of all-time leads still active (not lost or won)

Lead → Prospect Conversion Rate

% of all leads that reached Prospect or beyond

Period Snapshot — New Leads by Source

Source	May 4–10	May 11–17	Spam Rate (this wk)	Prospects (this wk)	Status
SATI (Google Ads)	71	117	31%	8 (8.9%)	↑ Volume surge
Nestopa	51	0	33%	2 (4%)	Review Quality
WebConnect / Form	8	6	25%	3 (38%)	Good
Agent Referral	6	0	0%	6 (100%)	Best quality
Tablet Registration	17	10	10%	0 (0%)	Steady
Other / Direct	50	15	27%	4 (27%)	—
Total	138	145	—	12 prospects	—

All-time wins

Closed-Won Deals — Full History

Total Won

Bangtao

Nai Yang

via Agent

Direct / Other

WebConnect

SATI campaigns launched April 2026 — still too early for closed-won attribution. Typical luxury real estate sales cycle is 3–12 months. The 9 live SATI prospects (Prospect → Meeting stage) represent the active SATI closing pipeline.

Google Ads

Campaign Performance — SATI Managed Campaigns

Bangtao + Nai Yang pipelines · All data as of May 18, 2026

SATI Campaign Breakdown — All-Time Quality Metrics (CRM Ground Truth)

Campaign	Type	Total Leads	Qualified (ever)	Qual %	Spam	Spam %	Active
PMax_Bangtao_TH	PMax	99	13	13.1%	34	34.3%	52
Search_Generic_Intl	CPC	32	0	0.0%	9	28.1%	22
Search_Brand_All	CPC	14	2	14.3%	2	14.3%	3
PMax_Intl	PMax	25	0	0.0%	8	32.0%	16
Search_Generic_RU	CPC	3	0	0.0%	1	33.3%	2
Search_Generic_TH	CPC	41	1	2.4%	30	73.2% ⚠	3
Search_Generic_HE	CPC	0	0	—	0	—	0
PMax_Silhouette_TH	PMax	3	1	33.3%	0	0.0%	2
(no UTM — pre-form)	—	9	2	22.2%	2	22.2%	3
TOTAL		263	19	7.2%	95	36.1%	130

Source: Kommo CRM (tag=SATI or form URL contains -sati/). Campaign attribution: parsed from Note fields (Tags line) + UTM Source URL — 240/263 leads attributed. Qualified = Prospect field=Yes OR currently at Prospect+ stage. Spend columns: paste from Google Ads → Reports → Campaigns export.

Lead Volume by Week — SATI

Spam Rate Trend — SATI (% per week)

Source Quality Comparison — All Sources Ranked by Prospect Rate

Cost Per Qualified Lead — Apr 1–May 18, 2026 (paste spend from Google Ads to complete)

Campaign	Qualified Leads (CRM truth)	Total Leads	Spam	Spam %	Signal
PMax_Bangtao_TH	13	99	34	35%	Best performer — 13 qualified
Search_Brand_All	2	14	2	14%	Good quality, needs volume
PMax_Intl	0	25	8	32%	New — ramp phase
Search_Generic_TH	1	41	30	73% ⚠	Paused — replaced
Search_Generic_HE	0	0	0	—	New campaign — no data yet
PMax_Silhouette_TH	1	3	0	0%	Early — 33% qual rate
Search_Generic_Intl	0	32	9	28%	Volume building
Search_Generic_RU	0	3	1	33%	Scaling
TOTAL	19	263	95	36.1%

Qualified = Prospect field=Yes in Kommo (captures leads that qualified then went Closed-Lost). To calculate CPL: Google Ads → Reports → Predefined → Campaigns, set date Apr 1–May 18, export Cost column.

CRM Intelligence

Full Funnel Analysis — Both Pipelines

6,968 total leads · Bangtao (5,915) + Nai Yang (1,053)

CRM expertise insight: 280 leads are currently active in the pipeline but have not been touched in over 14 days — representing potential deals going cold. SATI-managed leads: 0 at risk. Every SATI lead has been recently engaged.

Full Funnel — Combined Pipelines (Prospect Conversion at Each Step)

Total Leads

6,968

100%

Attempted

300

4.4%

Prospect

136

2.0%

Qualified

0.26%

Meeting

0.46%

Nego / Res.

0.15%

Closed Won

0.99%

Step conversion: Lead→Prospect 2.0% · Prospect→Qualified 10% · Qualified→Meeting 57% · Meeting→Won 63%

⚠️ At-Risk Leads — Active But Not Touched in 14+ Days

By Source

Source	At Risk	% of active
SATI (Google Ads)	0	0% — perfect
Other / Direct	101	72%
WebConnect	64	64%
Facebook	43	88%
Other / Direct	166	76%
Agent Referral	23	66%
Tablet Reg.	8	19%
Total	280	—

By Stage (what's at risk)

Stage	Count	Impact
Attempted Contact	183	Needs follow-up
Prospect	78	High priority
Qualified	9	Urgent
Meeting Scheduled	8	Urgent
Nego / Reservation	1	Critical
Total	280

Recommendation: 78 leads stuck at Prospect stage + 9 at Qualified + 8 at Meeting have had zero activity in 14+ days. This represents the highest-probability lost revenue in the CRM. A re-engagement campaign targeting these leads should be prioritised.

Pipeline Comparison — Bangtao vs Nai Yang

Metric	Bangtao	Nai Yang	Combined
Total Leads	5,915	1,053	6,968
Prospects	87	49	136
Prospect Rate	1.5%	4.8%	2.0%
Qualified+	48	8	56
Won Deals	47	20	67
Win Rate (vs leads)	0.81%	2.0%	0.98%
Prospect → Win Rate	~57%	~43%	~52%
Avg. Stage Velocity	Won deals: ~266 days from lead creation

Nai Yang punches above its weight — 2.5× higher prospect rate and higher win rate despite being a smaller pipeline. Nai Yang leads convert faster and close more reliably.

Stage Velocity — Avg. Days in Current Stage

Avg days between creation date and last modification (proxy for time active in current stage). Won deals average 266 days total lifecycle — consistent with luxury real estate sales cycles.

Lost Lead Autopsy — Why Leads Are Lost

Live pipeline

Active SATI Prospects — May 18, 2026

12 leads at Prospect or above · All created within last 20 days · 0 gone cold

Every SATI lead at Prospect+ has been contacted within the last 6 days. This is active, well-managed pipeline.

Meeting Sched.

Aldo Popolani

📍 Bangtao 🕐 Age: 3 days ✅ Last contact: 1 day ago

Meeting Sched.

Ray Bouwer

📍 Bangtao 🕐 Age: 3 days ✅ Last contact: 1 day ago

Meeting Sched.

Goldie A

📍 Bangtao 🕐 Age: 8 days ✅ Last contact: 2 days ago

Qualified

Kunall Kohli

📍 Nai Yang 🕐 Age: 10 days ✅ Last contact: 3 days ago

Qualified

Andrew David

📍 Nai Yang 🕐 Age: 13 days ✅ Last contact: 2 days ago

Prospect

James Hui

📍 Bangtao 🕐 Age: 3 days ✅ Last contact: 1 day ago

Prospect

Elbaze Rsofia

📍 Bangtao 🕐 Age: 6 days ✅ Last contact: 1 day ago

Prospect

Bernard S.W.

📍 Nai Yang 🕐 Age: 9 days ✅ Last contact: 1 day ago

Prospect

Rasshme Mehtta

📍 Bangtao 🕐 Age: 9 days ✅ Last contact: 2 days ago

Prospect

Nicholas A.H.

📍 Bangtao 🕐 Age: 10 days ✅ Last contact: 1 day ago

Prospect

Russell Lipton

📍 Nai Yang 🕐 Age: 4 days ✅ Last contact: 1 day ago

Prospect

Mark Hynes

📍 Bangtao 🕐 Age: 3 days ✅ Last contact: 1 day ago

Prospect

Rojan Gautam

📍 Bangtao 🕐 Age: 18 days ✅ Last contact: 1 day ago

Prospect

Jc Mobile

📍 Bangtao 🕐 Age: 1 day ✅ Last contact: 1 day ago

Prospect

Tejas Mutha

📍 Bangtao 🕐 Age: 2 days ✅ Last contact: 1 day ago

Full Active Pipeline — All Sources

Leads at any active stage (not lost, not won) as of May 18, 2026

Active Pipeline Breakdown by Source

Source	Active Leads	% of Source Total	Prospect+	Cold (>14d)	Health
SATI (Google Ads)	106	47%	15	0	★★★★★
Agent Referral	27	34%	20	19	★★★☆☆
Tablet Reg.	43	29%	14	8	★★★★☆
Nestopa	15	39%	3	0	★★★☆☆
WhatsApp	67	8%	23	45	★★☆☆☆
WebConnect	100	6%	42	64	★★☆☆☆
Other / Direct	141	11%	82	101	★★☆☆☆
Facebook / Insta	49	2%	18	43	★☆☆☆☆
Total	539	—	215	280	—

Campaign Performance — SATI Managed Campaigns

Full Funnel Analysis — Both Pipelines

Active SATI Prospects — May 18, 2026

Full Active Pipeline — All Sources

Prices and Layouts