LONDON 14:32— queried accounts · clients · pipedrive.deals ·669ms·100 of 1,284 rows

1,284 Facebook-sourced clients signed up in 2026 — paid social carries the entire new stream.[1]

Paid social = 100% of the stream. Every 2026 signup carries utm_medium = paid_social — there is no organic or referral leg behind the headline.

Clients1,284 ▲ 38% vs 2025

Realised rev£487k ▲ £121k

Activated41% ▼ 4pt

Avg FTT6d ▲ 1.2d faster

Paid-social share100% of new stream

Facebook · paid_social — new client signups monthly, 2026 (Jan–Jun)

Jan

142

Feb

168

Mar

205

Apr

231

May

264

Jun

274

Cumulative 1,284 clients · 100% via facebook / paid_social · 0 organic, 0 referral.

All rows share stream = Inbound utm_source = facebook utm_medium = paid_social

Sampled cohort — first 10 of 1,284 Facebook-sourced 2026 signups.
Client	Type	user_id	Created	Realised
Gauhar Abbas	Personal	111505	12 Jun 2026	£1,240
Badhon Sheikh	PLC	111515	11 Jun 2026	£0
Maria Ferreira	Personal	111498	10 Jun 2026	£3,415
Okonkwo Ltd	Ltd	111487	09 Jun 2026	£8,902
Unresolved · no CT profile	Client	111470	08 Jun 2026	£0
Dimitri Petrov	Personal	111463	07 Jun 2026	£612
Aisha Rahman	Sole tr.	111451	06 Jun 2026	£2,118
Northwind Trading	Ltd	111449	05 Jun 2026	£14,760
Lukas Novak	Personal	111432	04 Jun 2026	£0
Unresolved · no CT profile	Client	111542	03 Jun 2026	£0

SQL — generated from your question read-only · lore_ct_ro

1-- Blended: CT accounts + clients, joined to Pipedrive deals2SELECT a.user_id,3       c.display_name        AS client,4       a.client_type,5       'Inbound'             AS stream,6       a.utm_source, a.utm_medium7FROM   accounts a8LEFT JOIN clients c        ON c.account_id = a.id9LEFT JOIN pipedrive.deals d ON d.ct_user_id = a.user_id10WHERE  a.utm_source = 'facebook'11  AND  a.utm_medium = 'paid_social'12  AND  a.created_at >= DATE '2026-01-01'13ORDER BY a.created_at DESC;

validated read-only · 0 writes · executed in 669ms

Allow multiple

100 of 1,284 rows

All rows share utm_source = facebook utm_medium = paid_social

Paged evidence — 100 at a time.
Client	Type	user_id	Created	Realised
Gauhar Abbas	Personal	111505	12 Jun 2026	£1,240
Badhon Sheikh	PLC	111515	11 Jun 2026	£0
Maria Ferreira	Personal	111498	10 Jun 2026	£3,415
Okonkwo Ltd	Ltd	111487	09 Jun 2026	£8,902
Unresolved	Client	111470	08 Jun 2026	£0

paged · 100 at a time

SQL — generated from your question read-only · lore_ct_ro

1-- Blended: CT accounts + clients, joined to Pipedrive deals2SELECT a.user_id, c.display_name AS client,3       a.client_type, a.utm_source, a.utm_medium4FROM   accounts a5LEFT JOIN clients c ON c.account_id = a.id6WHERE  a.utm_source = 'facebook' AND a.utm_medium = 'paid_social'7  AND  a.created_at >= DATE '2026-01-01'8ORDER BY a.created_at DESC;

validated read-only · 0 writes · executed in 669ms

Lore made these reads to answer your question. Change any, then re-run.

1

"Facebook" interpreted as paid social

mapped utm_source = 'facebook' AND utm_medium = 'paid_social'

2

Timeframe: since 1 Jan 2026

filter accounts.created_at >= DATE '2026-01-01'

3

Revenue: realised

sum over trade_bookings where status = 'settled'

4

Client scope: blended

LEFT JOIN pipedrive.deals · keeps CT clients with no deal

5

"Signed up" measured as account created

accounts.created_at — not first deposit or first trade

0 changed · 5 assumptions

Analyst notes

41% activation lags the book. Volume is up 38% but activation slipped 4pt; a wider top is diluting quality.

FTT 6d — fast. First trade lands 1.2d quicker than 2025; the funnel converts, the gap is downstream.

~12% identity gaps. Rows resolve to client_type = Client with no name — a Pipedrive deal exists but the CT profile is still thin.