PostHog Analytics Expert

Transform PostHog data into actionable product insights. This skill combines product analytics expertise with the PostHog MCP server to help discover patterns, surface opportunities, and build a data-informed product strategy.

Product Context Management

Before diving into analysis, establish product context. Store discovered knowledge in .claude/product-context.md for persistence across sessions.

First Session: Discovery

1. •Check for existing context: Read .claude/product-context.md if it exists
2. •Interview the user (if context is missing or incomplete):
   • •What does the product do? Who are the users?
   • •What are the key user actions/conversions?
   • •What business metrics matter most?
3. •Explore PostHog data:
   • •event-definitions-list - Discover tracked events
   • •properties-list - Understand available properties
   • •insights-get-all - See existing insights
   • •dashboards-get-all - Review current dashboards
4. •Save context: Write discovered knowledge to .claude/product-context.md

Context File Structure

# Product Context

## Product Overview
[What the product does, target users]

## Key Events
| Event | Meaning | Importance |
|-------|---------|------------|
| $pageview | Page visit | Navigation tracking |
| signup_completed | User registered | Core conversion |
| [custom events discovered] | | |

## Important Properties
- user_tier: free/pro/enterprise
- [other key properties]

## Key Metrics
- Primary: [e.g., Weekly Active Users, Conversion Rate]
- Secondary: [e.g., Feature Adoption, Retention]

## Funnels
- Activation: signup → onboarding_complete → first_value_action
- [other key funnels]

## Last Updated: [date]

Core Capabilities

1. Proactive Insight Discovery

When asked to "find insights" or "what's interesting", run this discovery workflow:

1. Trends Analysis
   - query-run: Total events over 30 days (spot volume changes)
   - query-run: DAU/WAU/MAU trends (engagement health)
   - query-run: Key conversion events over time

2. Funnel Health
   - query-run: Core activation funnel
   - query-run: Conversion funnel (trial → paid if SaaS)
   - Look for: Drop-off points, conversion changes

3. Retention Check
   - query-run: Cohort retention (week-over-week)
   - Look for: Retention curve shape, changes over time

4. Feature Adoption
   - query-run: Feature usage by user segment
   - Look for: Underused features, power user patterns

5. Error Impact
   - list-errors: Top errors by occurrence
   - error-details: Impact on user journeys

Insight Presentation Format:

## [Insight Title]
**Finding**: [One sentence summary]
**Evidence**: [Specific numbers/data]
**Impact**: [Why this matters]
**Recommended Action**: [What to do about it]

2. Answering Analytics Questions

Map common questions to PostHog queries:

3. Dashboard Creation

When building dashboards, follow this structure:

Executive Dashboard (high-level health):

• •Active users (DAU/WAU/MAU)
• •Core conversion rate
• •Retention (week 1, week 4)
• •Revenue metrics (if applicable)

Product Dashboard (feature-level):

• •Feature adoption rates
• •Feature engagement depth
• •User journey completion
• •Error rates by feature

Growth Dashboard (acquisition/activation):

• •Signup funnel
• •Activation funnel
• •Traffic sources (if tracked)
• •Onboarding completion

Workflow:

1. •dashboard-create with descriptive name
2. •Build insights with query-run → insight-create-from-query
3. •Add to dashboard with add-insight-to-dashboard
4. •Organize with dashboard-reorder-tiles

4. Experiment Design

When setting up A/B tests:

1. •Clarify hypothesis: What change, expected impact, and why
2. •Find existing flags: feature-flag-get-all (reuse if appropriate)
3. •Choose metrics: Use event-definitions-list to find trackable events
4. •Set up experiment: experiment-create with:
   • •Clear name and description
   • •Primary metric (what you're optimizing)
   • •Secondary metrics (guardrails)
   • •Appropriate sample size (MDE guidance)

See references/experiments.md for detailed experiment patterns.

5. Cohort & Segment Analysis

For understanding user segments:

1. Define cohort criteria (user properties, behaviors)
2. Compare cohorts on key metrics:
   - query-run with breakdownFilter by cohort property
   - Conversion rates per segment
   - Retention per segment
3. Identify highest-value segments
4. Recommend targeting strategies

Query Patterns

TrendsQuery (counts over time)

{
  "kind": "InsightVizNode",
  "source": {
    "kind": "TrendsQuery",
    "dateRange": {"date_from": "-30d"},
    "interval": "day",
    "series": [{
      "kind": "EventsNode",
      "event": "event_name",
      "custom_name": "Display Name",
      "math": "total"
    }]
  }
}

Math options: total, dau, weekly_active, monthly_active, unique_session, avg, sum, min, max

FunnelsQuery (conversion analysis)

{
  "kind": "InsightVizNode",
  "source": {
    "kind": "FunnelsQuery",
    "dateRange": {"date_from": "-30d"},
    "series": [
      {"kind": "EventsNode", "event": "step_1", "custom_name": "Step 1"},
      {"kind": "EventsNode", "event": "step_2", "custom_name": "Step 2"},
      {"kind": "EventsNode", "event": "step_3", "custom_name": "Step 3"}
    ],
    "funnelsFilter": {
      "funnelWindowInterval": 7,
      "funnelWindowIntervalUnit": "day"
    }
  }
}

Breakdown Analysis

Add to any query:

"breakdownFilter": {
  "breakdown": "property_name",
  "breakdown_type": "event"  // or "person"
}

SaaS Metrics Framework

For SaaS products, prioritize these metrics:

Resources

• •references/experiments.md - Detailed experiment design patterns
• •references/saas-playbook.md - SaaS-specific analytics strategies