Canonical Sources — as of this build
All metrics (spend, QBC, QLC, SUR, CR, closed, impressions, clicks)
[EyeFly] Sales_Marketing Data — 2. Daily Summary. Jan 2025→May 2026. Re-synced May 8 2026.
✓ Canonical
Closed deals
public.sales_appointments — outcome='Live Call – Closed'. 59 Closed Loop false positives removed May 8 2026. Exactly 37 closed rows.
✓ Fixed May 8
Active clients (2026)
public.ad_metrics — unique clients spend>$0/month. Jan=10, Feb=16, Mar=21, Apr=31, May=24 (partial).
✓ Canonical (2026)
Active clients (2025)
public.client_active_monthly — derived from per-client spend CSV. First/last appearance = on/ch. Synced May 8 2026.
✓ Synced May 8
Week-boundary variance
sales_metrics weekly grain — monthly sums differ from calendar-month CSV by ±$200–1400 spend, ±1–5 QBC for cross-month weeks. Expected, documented.
Expected variance
Known Gaps & Artifacts
Nov–Dec 2025
Confirmed $0 spend and 0 call activity. EyeFly had no active acquisition campaigns; client pages were still running.
Confirmed gap
CR >100% (some months)
Month-level close count exceeds QLC. Timing artifact — deals closed in a different month than the call. Masked in charts.
Timing artifact
Apr/May 2026 partial
Apr 2026: pending calls + no-shows, 0 closed. May 2026: week of May 5–8 not fully captured.
Partial month