What you can now act on
✅ New capabilities delivered this month
Work that unlocks a decision, answers a question, or enables an action that wasn't possible before March.
Leadership can now track company KPIs and OKRs in real time
KPI/OKR reporting mart is live with a glossary, prepped for Q2 planning cycles. Leadership no longer needs to ask the data team for these numbers.
Self-serve analytics is entering production via Cube
Most P1 Cube reporting assets delivered. UAT Wave 1 kicked off — the shift from request-based reporting to self-serve is underway.
Member engagement can now be tracked with greater precision
Weekly plan events and engagement metrics updated with new event logic and backfills — reducing gaps in how we measure member progression and intervention impact.
Pangea is data-ready for launch
Billing triggers, contract mapping, eligibility checkpoints, and campaign infrastructure all delivered via Data API. The data team's part of the 4/1 launch is done.
Clinical and program outcomes are now consistently measured
BAM Summary and Details marts live. Alcohol marts reworked. Advanced clinical outcomes reporting now aligned across Product, Clinical, and Growth.
LP outcomes can now be measured and iterated on
Outcome metrics for landing page improvements delivered — enabling the Growth team to measure what's working and make evidence-based decisions.
Ready for activation — data team's work is done
⏳ Delivered. Waiting on the next step.
These are complete on the data side. The next action belongs to another team — adoption, sign-off, or activation.
Product
Cube P2 + P3 dashboard design complete — UAT feedback needed
Dashboards designed and ready. UAT Wave 1 is live. Value is only realized when stakeholders use them and provide feedback to finalize before full rollout.
Growth
Iterable and campaign system infrastructure rebuilt and stabilized
Backfills completed, event fixes applied, care pathway piped into Iterable. Growth team to validate campaign logic against new event structure.
Client Ops
Eligibility gaps resolved for Family Dollar, Bimbo, Guitar Center, and others
Matching logic expanded and data corrected. Client-facing teams can now proceed with confidence on eligibility for these accounts.
Analytics
OKR/KPI glossary mart live — Q2 metric definitions are set
Mart is built and definitions are documented. Leadership and department heads need to align on which metrics are authoritative for Q2 planning.
What we caught
🛡️ Data quality — before it reached you
We run a dbt test suite that automatically validates data integrity on every pipeline run — catching bad values, duplicates, and integrity failures at the source before they reach any report or dashboard. These are tracked in Jira and actioned every sprint.
43
dbt test failures caught & resolved — never reached a dashboard
2
Issues reported externally by stakeholders
2 of 2
External issues traced to upstream vendor — not our pipelines
Duplicated DM Counts in Marketing Reporting
Iterable emitted duplicate events before reaching our pipeline. Our ingestion functioned correctly — it loaded what it received. Deduplication logic added to prevent inflation of campaign metrics going forward. Reported by Growth QA.
Missing Oura Typeform Attribution
Attribution gap identified and patched. No impact to member-facing systems. Reporting corrected and validated.
Clients served this month
🤝 Active client work in March
Every client below had specific data work completed this month — eligibility, billing, data feeds, claims, or reporting.
AT&T / Alight
CVS / ADM
BCBSNC
Aetna
Live Nation
Red Bull
3M
Lowe's
Guitar Center
Tractor Supply
Family Dollar
Dollar Tree
Bimbo
Chegg
ESI
HPE
Silgan
Always on — what runs beneath everything
⚙️ The platform your business runs on
This work doesn't ship in a sprint announcement. It runs every day, every sprint, and every time a new client or contract comes in. It's the reason the lights stay on.
dbt Pipeline — 15-min + Daily
Critical 15-minute dbt jobs power the member registration pipeline. Any failure is a P0 — resolved before business hours.
Running continuously
On-Call Rotation
One engineer holds the pager every sprint, monitoring 8+ Airflow alert channels: dbt, eligibility, billing, claims, Iterable, Airbyte, and more.
Every sprint
Release Train — Tue & Thu only
All production deploys happen on a controlled Tuesday/Thursday schedule — reducing risk and giving the business predictable delivery windows.
2× per week
Billing Engine
Custom billing logic is updated with every new client contract and every change to an existing client's billing rules. No two clients are the same.
Updated continuously
Active Integrations Maintained
Airflow, Airbyte, Iterable / Census, Typeform, Sendoso, ESI, Aetna, Redshift — all monitored, maintained, and updated as vendors change.
Always monitored
Security & Dependency Hygiene
Dependabot PRs reviewed and merged every sprint across qg-analytics and qg-airflow. Vulnerability scans remediated (ESI billing DAG, ROI QA DAG this month).
Every sprint
What's coming in April