Retention Metrics & Reporting API

"A self-serve reporting layer: a Retention Metrics API that auto-refreshes Google Sheets from ClickHouse (async jobs, polling, API-key access), plus automated daily funnel reporting flowing from CleverTap into MySQL and Slack — no manual SQL, no stale numbers."

Executive Summary

Retention reporting used to mean manual SQL every morning. I built an API that refreshes the team's Google Sheets directly from ClickHouse — MoM wallet events, FTB movement, D30 FTB tracker, daily cohorts — with async job triggers, polling, last-run status, and API-key access. Daily funnel data flows automatically from CleverTap into MySQL and posts to Slack, and a 24-hour data alerting pipeline watches for anomalies.

Key Outcomes

Retention reports refresh themselves — zero manual SQL in the daily loop.
MoM wallet, FTB movement, D30 tracker, and cohort tabs all automated.
Daily CleverTap funnel lands in MySQL and Slack without human touch.
24-hour data alerting pipeline catches anomalies before people do.

Next Case Study

14x Efficiency Automation Engine

Engineered a custom Google Apps Script solution that interfaced with CleverTap APIs to automate complex campaign deployments — one person now manages what previously required a 14-member team, across 100+ cities from a single sheet.