A clean energy platform that connects residents, businesses, and other consumers with clean energy facilities that lower their electric costs, centralized data from CRM and billing systems in BigQuery for churn analysis. Historically, account managers manually reviewed cancellation cases, parsing emails and call transcripts to categorize reasons using a complex 65-category system, later condensed into 16 actionable insights. By leveraging Google Gemini, we automated this process, training the LLM to analyze customer interactions and assign accurate categories, streamlining operations and enhancing retention strategies.