Growth Accounting Framework AI Prompt

Apply a growth accounting framework to decompose MAU growth into its constituent components.

User activity data: {{activity_data}} (user_id, active_month)
Time period: {{period}}

1. User state classification:
   For each user in each month, classify their state:
   - New: first month of activity
   - Retained: active this month AND last month
   - Resurrected: active this month but NOT last month (but active at some prior point)
   - Churned: active last month but NOT this month (not visible in current month counts)

2. Growth accounting equation:
   MAU(t) = MAU(t-1) + New(t) + Resurrected(t) - Churned(t)
   - Verify this equation balances in the data

3. Monthly trend of each component:
   - Plot New, Retained, Resurrected, and Churned users over time
   - Quick ratio = (New + Resurrected) / Churned
     Quick ratio > 1: growing. < 1: shrinking. = 1: flat.
   - What is the trend in the quick ratio?

4. Component deep dive:
   - New users: growing or declining? What is driving acquisition?
   - Churn: is the churn count growing as MAU grows? (Structural churn problem if yes)
   - Resurrection: what brings users back? Is resurrection a meaningful growth driver?
   - Retention: what % of users are retained month over month? Is it improving?

5. Diagnosis:
   - Is this a new user problem (top of funnel), a retention problem, or both?
   - If the quick ratio < 1: which component needs improvement most?
   - If the quick ratio > 1 but slowing: is churn keeping pace with new user growth?

Return: monthly growth accounting table, quick ratio trend, component analysis, and growth diagnosis.