AI QUERY PROMPT: 'What was our average landing page conversion rate across all paid campaigns last month?'

AI GENERATED SUMMARY:
'Last month, your paid marketing campaigns achieved an outstanding average landing page conversion rate of 12.4% across your 4 active landing pages.'

UNDERLYING DATA TABLE:
• Page A (Brand Search): 10,000 visitors, 300 conversions (Conversion Rate: 3.0%)
• Page B (Generic Search): 15,000 visitors, 375 conversions (Conversion Rate: 2.5%)
• Page C (Retargeting): 8,000 visitors, 320 conversions (Conversion Rate: 4.0%)
• Page D (Niche Influencer Test): 100 visitors, 30 conversions (Conversion Rate: 30.0%)

AI CALCULATION: (3.0% + 2.5% + 4.0% + 30.0%) / 4 = 12.375% -> Rounded to 12.4%

AI QUERY PROMPT: 'Calculate 30-day user retention for users who signed up in January 2026.'

AI GENERATED SUMMARY:
'For the January 2026 signup cohort (total 4,200 new users), 1,512 users logged into the platform between day 28 and day 30 post-signup, representing a 30-day active retention rate of 36.0%.'

UNDERLYING SQL QUERY:
```sql
WITH cohort AS (
  SELECT user_id, DATE_TRUNC('month', created_at) AS signup_month
  FROM users
  WHERE created_at >= '2026-01-01' AND created_at < '2026-02-01'
),
retained AS (
  SELECT DISTINCT c.user_id
  FROM cohort c
  JOIN events e ON c.user_id = e.user_id
  WHERE e.event_time >= c.created_at + INTERVAL '28 days'
    AND e.event_time <= c.created_at + INTERVAL '30 days'
)
SELECT 
  COUNT(DISTINCT c.user_id) AS total_users,
  COUNT(DISTINCT r.user_id) AS retained_users,
  ROUND(COUNT(DISTINCT r.user_id) * 100.0 / COUNT(DISTINCT c.user_id), 2) AS retention_pct
FROM cohort c
LEFT JOIN retained r ON c.user_id = r.user_id;
```

AI QUERY PROMPT: 'What was our total ecommerce sales revenue from email campaigns in February 2026?'

AI GENERATED SUMMARY:
'In February 2026, email marketing generated $320,000 in total sales revenue across 800 customer transactions (Average Order Value: $400).'

UNDERLYING SQL QUERY GENERATED BY AI:
```sql
SELECT 
  COUNT(o.order_id) AS transaction_count,
  SUM(o.order_total_usd) AS total_revenue
FROM orders o
JOIN order_items oi ON o.order_id = oi.order_id
WHERE o.utm_source = 'email'
  AND o.order_date >= '2026-02-01' AND o.order_date < '2026-03-01';
```

ACTUAL STORE REALITY:
• Total unique email orders: 800
• Average items per order: 2.5 items
• True total revenue in payment gateway: $128,000
• Actual Average Order Value: $160