ShareChat Analytics

Synthetic event warehouse, A/B test, full pipeline.

• → 4-script automated pipeline: generate → fetch → load → DQ checks
• → 15 Redshift-compatible SQL queries with window functions, CTEs, statistical aggregates
• → Surfaced that Tier-3/4 users spend 20% more time on platform but ARPU is 5.2× lower
• → A/B test variant shipped at +6.2% session duration, p < 0.001, consistent across segments