Metric Analysis

Product Analytics Query Generator

Works with ChatGPT, Claude, Gemini, and other AI assistants

Generate SQL queries to analyze [specific user behavior/metric] in our product. Assume a standard data warehouse schema with user, session, event, and conversion tables. Include queries for: 1) Overall trend analysis with week-over-week and month-over-month comparisons, 2) Cohort analysis to track retention and engagement over time, 3) Funnel analysis to identify drop-off points, 4) Segmentation analysis by user attributes (e.g., plan type, geography, acquisition channel), 5) Feature adoption correlation with key outcomes, and 6) Anomaly detection for irregular patterns. Include comments explaining each query's purpose and how to interpret results.

How to Use This Prompt

  1. Copy the prompt using the button above
  2. Replace placeholders in [brackets] with your specific details
  3. Paste into your AI assistant (ChatGPT, Claude, Gemini, etc.)
  4. Iterate as needed - ask follow-up questions to refine the output

Explore All 100+ Prompts

Browse our complete library of AI prompts designed for product managers.

Browse All Prompts