Prestige Football Schools · Paid Acquisition

PPC Performance Dashboard

Pride In Education, Passion For Football

Page Loaded

—

Loading sync state…

v4-public · Live from Supabase · Read-only

Time Period Use header ↻ to reload data

📊 Data Health · All Sources

Loading sync state across every source…

🔌 Source Connections · Capture Readiness

Status of every external data source

Multi-Touch Attribution

🎯 Attribution Models · Side by Side

How channel credit shifts with each model

Channel	Last-Click	First-Click	Linear	Time-Decay	Position-Based	Unique Contacts

Models: Last-Click 100% credit to last touch (current default). First-Click 100% to first touch. Linear equal share per touch. Time-Decay half-life 7 days. Position-Based 40% first + 40% last + 20% middle.

Sample Converter Journeys

Top 5 customers, full touch timeline

Total Paid Spend

—

Meta + Google · attributed

Blended CPL

—

Spend ÷ attributed leads

Blended CPQL

—

Spend ÷ qualified leads · what really matters

Cost Per Customer

—

Spend ÷ converted leads · vs £4,330 deal value

Impressions

—

Clicks

—

Paid Leads

—

Qualified

—

Customers

—

Paid Pipeline £

—

Channel Comparison

Meta (Paid Social)

Live

Spend

—

Last 30d

CPL

—

attributed

Leads

—

HubSpot

CPQL

—

qualified

Google (Paid Search)

—

Spend

—

Source TBD

CPL

—

attributed

Leads

—

HubSpot

CPQL

—

qualified

Verdict

Calculating…

Comparing channel efficiency on CPL and CPQL.

⚠

Attribution gap detected Loading attribution health…

Deals Created → Closed · Time to Convert

Deal Pipeline · Created & Won

Spans paid + offline · HubSpot

Created

—

in period

Won

—

Deposit Paid + at school

Pipeline £

—

all open

Won £

—

closed value

Stage distribution

AI Insight

Generating…

Time to Convert

Lead → Opportunity → Customer

Lead → Opportunity

—

avg days, all sources

Lead → Customer

—

avg days · vs PFS benchmark

By source (days to customer)

AI Insight

Generating…

Performance Funnel · At a Glance

Impressions → Clicks → Leads → Qualified

Visual trapezoid · drop-off at every stage

—

Impressions

—

Clicks

—

Leads

—

Qualified

Total Spend—

CPM (cost per 1k impressions)—

CPC (cost per click)—

CTR (click-through rate)—

CPL (cost per lead)—

CPQL (cost per qualified lead)—

Full Funnel · Cost Per Stage

Spend → Customer · Cumulative Cost Model

Volume + drop-off + cumulative £ per stage

Stage

Volume

Conv %

Cost / unit

PFS benchmark: Visit → MQL 17.8% · MQL → SQL 7% · SQL → Deposit 47% · Deposit → Placed 93.5% (source: Master Reporting · Conversion Funnel tab)

AI Insight

Generating…

Deal Attribution

Where deals come from (HubSpot)

Daily Spend & CPL Trend · Meta

Live daily series · spotting drift

AI Insight

Generating…

Impressions & CPM

Clicks & CPC

Spend & CTR

Context Markers · Why Did Things Move?

Events & Changes in This Period

Business events, budget shifts, targeting changes, algorithm updates

Anomaly Detector

Unusual months · auto-flagged

Logic: A month is anomalous if its value is >2× the rolling 3-month average. Each anomaly is checked against the annotations table — explained anomalies show in green, unexplained in red (signal to add an annotation).

Seasonality · 18 Months

Monthly Leads & Deals Created

Spot the spring spike (September intake planning)

Computing seasonality patterns…

AI Insight

Generating…

Regional Opportunity · "Did we miss a trick?"

Where Money Worked · Where It Could Work

Meta spend (now) vs historical conversion rate (HubSpot, 18m)

Gulf / current investment Other regions UK

Investment Verdict

Computing regional ROI analysis with Haiku…

Geo Performance Table

Sortable · 18m HubSpot data · click any column

Country	Leads	Qualified	Conv %	Meta £ (30d)	Effective CPL	Opportunity

Opportunity score = conversion% × (leads ÷ max leads) × (1 − Meta spend ÷ max spend). High score = under-invested but converting.

Meta · Live Diagnostics

Meta Opportunity Score

Meta's own diagnostic

Anomaly Signals

Auto-detected issues

Meta Campaigns · Live

Last 30 days · spend desc

Top Creatives

Top 10 by spend · Adaptive Ranking Model fuel

Meta Geographic Delivery

Where Meta is actually showing ads (live) — reconcile with HubSpot lead origin

AI Insight

Generating…

Google · Manual + Sheet

Google Ads — Account 9507142630

Loading…

Resolving spend source…

Override Google spend (£/period): Saves locally. Sheet wins when populated.

Snapshot from 29 March 2026 audit — kept as reference until the Sheet's PPC Performance tab is populated. Open Google Ads ↗

Campaign	Budget/day	30d Cost	Conv	Cost/Conv	Impr Share	Status
Europe_Search_BOF	£35	£1,105	23	£48	<10%	BUDGET-LIMITED
North_America_Search_BOF	£40	£978	7	£140	11%	RANK-LIMITED
ROW_Search_BOF	£45	£171	3	£57	13%	RANK-LIMITED
England_Search_BOF	£20	£26	0	—	<10%	LOW VOL
ROW_Demand_Gen_Mof	£2.50	£72	0	—	—	AWARENESS

Budget Allocation · AI Recommendation

Where to Shift £ Next

Live-generated from current Meta + HubSpot data

Recommendation

Computing optimal allocation…

Priority Actions This Week

Top 4 Moves

Live-generated

Prestige Football Schools · BBSN-accredited · prestigefootballschools.com
Data: HubSpot (Supabase), Meta Graph API (live), Google Sheet (Master Reporting), Haiku (insights). Reload from header.