Live demo with synthetic data. Northvale Home Studio is a fictional company.
Northvale Home Studio
KPI 2.0

Loading…

Northvale Home StudioKPI 2.0
Time dimension

Spend vs revenue CRM revenue

Sale calls & chats Sale calls (> 5 min) · live chat

Weighted CPA spend / weight

Weight: paid vs organic event weights from dbt

Weight by event event count · weight · share

Weight mix share of total weight

Account changes Google Ads, Meta and Bing change history for the selected dates

Live data from BigQuery (refreshed every 15 minutes, from Jan 1, 2025) (main_kpi_with_budget, weight_distribution); Meta creatives: Meta Marketing API previews, lead forms and CRM estimates (matched by email/phone within 180 days of the lead), follow the date picker. Attribution: last non-direct session by session date; recent days are still maturing. “Exclude Local” removes Local / Showroom / store-visit / Porcelanosa campaigns by name. Channels = sourceMedium_only. Weight: some form events are kept for only the last 300 days in weight_distribution, so year-over-year weight is not like-for-like.