Revenue Intelligence

Registrations — Free Course Signups

Users who registered for the free course on the platform (public.users), filtered by date_registered.

Top UTM Sources

SourceSignupsActivatedEngagedContacted

Top UTM Mediums

MediumSignupsActivatedEngagedContacted

Facebook Ads — Campaign / Ad Set / Ad

Parsed from utm_campaign when it follows the Meta dynamic-parameter template (8 pipe-separated fields). Spend pulled live from the Marketing API and cached locally (15-min TTL for the current day, indefinite for past ranges).

Campaign / Ad Set / Ad Signups Spend CPR Activated Contacted

Placement

Placement Site Signups Activated Engaged

Signups Over Time

Blue = signups, green = activated (ever logged in)

Recent Signups

Registered Username Name Email Source Medium Campaign Last login Streak

Top UTM Campaigns

CampaignSignupsActivatedEngagedContacted

Bookings — Sales Calls

Combined view of sales-call bookings. Old ones (through Jan 2025) come from the ycbm_sync.bookings table (YouCanBookMe / Calendly sync). New ones (Oct 2025 →) come from the Bookings sheet in FBAdsReporting. There is a Feb→Sep 2025 gap with no data either side.

Top Sources

Old rows = utm_source (lowercase, raw). New rows = last-touch attribution category (e.g., "Direct traffic", "Paid Social"). The two vocabularies don't align — that's expected and one of the things the Insights tab makes visible.

SourceBookings

Top Mediums

MediumBookings

Top Campaigns

CampaignBookings

Bookings Over Time

Stacked weekly: old DB rows + new sheet rows. The Feb→Sep 2025 gap is real, not a rendering bug.

Recent Bookings

Created Origin Name Email Source Campaign Ad Status Rep

Clients — Closed Deals & Revenue

From the Clienti + bani spreadsheet, "Clienti YYYY" tabs (2019-2020, 2023, 2024, 2025, 2026). Each year's schema is slightly different; the parser knows about all five. Per your instruction, we assume Suma totala is the revenue — we ignore partial payments / "achitat pana acum".

Revenue by Year

YearClientsRevenueAvg Deal

Revenue Over Time (monthly)

Top Closers

CloserClientsRevenue

Top Countries

CountryClientsRevenue

Top Sources of Lead

For 2025/2026 this is the captured utm_source. For 2023/2024 it's the "Source of lead" sales-team field. Vocabularies differ.

SourceClientsRevenue

Top Facebook Campaigns (2025/2026)

Only rows where the client's utm_campaign follows the Meta 8-field template are shown.

Campaign stringClientsRevenue

Recent Clients

Date Year tab Name Email Sum Closer Country Source

Insights — Registrations × Bookings

Cross-cutting view of the funnel. Bookings = combined ycbm + sheet. Cost per registration (CPR) and cost per booking (CPB) divide total Facebook spend in the date range by the count. The reg→booking match is by lowercased email.

Funnel — Registrations → Bookings → Clients

Each stage matched to the previous by lowercased email. Bookings come from DB + sheet; clients from the "Clienti YYYY" sheets.

Top Sources — Registrations vs Bookings

Same string, both columns. Registrations and bookings use different attribution vocabularies, so most rows will have data in only one column — that's the point. Watch for sources that appear on both sides.

Source Registrations Bookings Booking Rate