Segment Comparison Guide AI Prompt

Help me compare different groups or segments in this dataset to understand what drives differences in performance.

I want to understand which groups are performing differently and why — not just that they are different.

1. Identify the segments:
   - What categories in this dataset naturally divide the data into groups? (region, product type, customer tier, age group, channel, etc.)
   - Which of these segmentations is likely to be most meaningful for the business?

2. Compare the groups on the key metric:
   - What is the average (and range) of the main metric for each group?
   - Rank the groups from best to worst
   - Which group is the biggest outlier — far above or far below the average?

3. Is the difference meaningful or just noise?
   - Is the gap between the best and worst group large enough to act on?
   - Are some groups so small that their results are unreliable? (if a group has fewer than 30 rows, its average can swing wildly by chance)
   - What would the result look like if the worst group performed as well as the average group?

4. What else is different about the groups?
   - Look beyond the main metric: do the high-performing groups share other characteristics? (different mix of products, longer customer tenure, different geography)
   - Could any of these characteristics explain why they perform better?

5. The actionable insight:
   - Based on this comparison, what is the one thing the business should investigate or act on?
   - Be specific: name the group, the gap, and the potential action.

Explain your findings in plain language. Avoid using terms like 'statistically significant' without explaining what that means.