Overview
Business dashboards for CLiKIN MVP1. Operational truth stays in Postgres; analytics truth lives in BigQuery and is visualized in Looker. Use this page as a “Looker-style report” summary for leadership.
Date Last 7 days
Project All
Campaign All
Channel WhatsApp + Calls + SMS
Executive KPIs
Top MVP1 analytics (funnel, ROI, speed, appointments, channels)
Streaming to BigQuery: ON
Leads
7d
—
Total leads captured from Meta Lead Forms and other sources.
Booked appointments
↑ target
—
Appointments created via Vaia (Calendar + Meet) with reminders.
Show rate
watch
—
Shows / Booked. Improved using reminders + join-check + recovery.
Time-to-first-touch
< 10 min
—
Median time from lead.created → first WA/call attempt.
Ad spend
7d
—
Total paid spend tracked to these leads (Meta).
Cost / booked
efficiency
—
Spend / booked appointments (blended).
Qualified leads
healthy
—
Leads that reached sales-qualified intent (engaged + screened).
Cost / qualified
signal
—
Blended spend per sales-qualified lead (CPLQ).
Funnel snapshot
Lead → Contacted → Engaged → Booked → Showed
Campaign leaderboard
CPL • CP Booking • CP Show
| Campaign | Leads | Booked | CP Show |
|---|---|---|---|
| — | — | — | — |
| — | — | — | — |
| — | — | — | — |
This table is sourced from fact_campaign_daily (BigQuery) and Looker blends with spend data.
Funnel conversion
View: stage drop-offs by campaign / project
Stage conversion
Computed from fact_lead_lifecycle
Looker tile
Campaign ROI
Spend → leads → booked → shows
ROI & unit economics
CPL, CP Booking, CP Show
Looker table
Response speed
Time-to-first-touch & SLA compliance
Speed-to-lead
Lead created → first WA/call attempt
MVP1 KPI
Appointment performance
Booked → showed → no-show → rescheduled
Show rate & no-show recovery
Derived from fact_appointments
Optimize
Channel effectiveness
WhatsApp engagement • Call answer rate • SMS fallback
Channel performance
What works best — automated by CIQ next best action
Looker charts