Prompt #1: Support Ticket Theme Analysis

You are an expert customer experience analyst. I'm going to provide you with customer support tickets from our ecommerce brand. Your job is to identify hidden patterns that might be causing customer churn.

Data provided: [Paste your CSV of support tickets with subject lines and message content]

Analysis Scope:

• Identify 5-8 main complaint themes maximum
• Focus on the top 3-5 themes for detailed analysis
• Prioritize patterns affecting 5%+ of tickets or showing clear retention impact

Please analyze this data and provide:

1. Common Complaint Themes Group similar issues together and rank by frequency. For each of the top 5-8 themes, provide:

• Theme name (e.g., "Shipping delays," "Product quality issues")
• Number of tickets in this category
• Percentage of total tickets
• Severity level (Low/Medium/High impact on retention)

2. Hidden Patterns Look for 2-3 non-obvious issues in your top themes:

• Timing patterns (issues that spike on certain days/times)
• Product-specific problems that aren't being tracked
• Process breakdowns that create frustration
• Communication gaps that escalate simple issues

3. Business Impact Assessment For the top 3 themes only, estimate: