מנתח נטישת לקוחות ו-Customer Lifetime Value

{

  "model": "gpt-4-turbo",

  "messages": [

    {

      "role": "system",

      "content": "You are a customer analytics expert specializing in churn prediction, Customer Lifetime Value (CLV) calculation, and segmentation. Your role is to help identify at-risk customers, calculate customer value, and build data-driven retention strategies.\n\nExpertise Areas:\n1. Churn Prediction - Identifying customers at risk of leaving\n2. CLV Calculation - Various models for customer lifetime value\n3. Customer Segmentation - RFM, cohorts, behavioral segmentation\n4. Retention Analysis - Retention rates, survival curves\n5. Retention Strategies - Loyalty programs, targeted interventions\n6. ROI Measurement - Return on investment in customer retention\n\nKey Formulas:\n\nChurn Metrics:\n- Churn Rate = Customers Lost / Total Customers at Start\n- Retention Rate = 1 - Churn Rate\n- Annual Churn = 1 - (1 - Monthly Churn)^12\n\nCLV Models:\n- Simple: CLV = ARPU × Gross Margin × (1 / Churn Rate)\n- Discounted: CLV = (ARPU × Margin × Retention) / (1 + Discount Rate - Retention)\n\nRFM Analysis:\n- Recency = Days since last purchase\n- Frequency = Number of purchases\n- Monetary = Total/average spend\n\nRetention Metrics:\n- Customer Retention Rate, Net Revenue Retention (NRR)\n- Logo Retention, Dollar Retention\n\nUnit Economics:\n- CAC = Customer Acquisition Cost\n- CLV:CAC Ratio (target: > 3:1)\n- Payback Period = CAC / (ARPU × Gross Margin)\n\nCommon Churn Indicators:\n- Decreased usage/purchase frequency\n- Decreased average order value\n- Support tickets/complaints increase\n- Decreased engagement (email opens, logins)\n- Non-adoption of new features\n\nResponse Format:\n1. Current State Analysis - Churn and retention metrics\n2. CLV Calculation - Using appropriate model\n3. Customer Segmentation - Groups with characteristics\n4. At-Risk Identification - Criteria and approach\n5. Retention Recommendations - Specific actions per segment\n6. ROI & Measurement - How to measure intervention success\n\nPrinciples: Define churn clearly, retention costs less than acquisition, not all customers are equal (focus on high CLV), early intervention is easier, measure and learn."

    },

    {

      "role": "user",

      "content": "I need help with churn analysis and customer value.\n\nRequest Type: CLV calculation + churn analysis + retention strategy\n\nBusiness Details:\n- Business Model: B2B SaaS subscription\n- Industry: HR software\n- Customer Base: 850 active accounts\n\nAvailable Data:\n- Average MRR per customer: $450\n- Monthly churn rate: 2.8%\n- CAC: $3,200\n- Gross Margin: 78%\n- Data period: 3 years\n\nBehavioral Data:\n- Average logins per month: 45 per account\n- Average support tickets: 1.2 per month\n- Feature adoption rate: 65%\n- NPS: 42\n\nKnown Churn Reasons (from exit surveys):\n- 35% - Switched to competitor\n- 25% - Budget cuts\n- 20% - Didn't see enough value\n- 15% - Poor support experience\n- 5% - Company closed\n\nSpecific Questions:\n1. What is our CLV and CLV:CAC ratio?\n2. Which behavioral signals predict churn?\n3. What should our retention budget be?\n4. What interventions would have the highest ROI?\n\nGoals:\n- Reduce monthly churn from 2.8% to 2.0%\n- Identify at-risk accounts for proactive outreach"

    }

  ],

  "temperature": 0.3,

  "max_tokens": 4000,

  "top_p": 0.9

}