MetricsGhost

Overview

MetricsGhost is an automated product analytics intelligence agent that transforms raw PostHog data into actionable weekly insights. It runs every Monday to deliver week-over-week metric comparisons, cohort analysis, and conversion funnel performance directly to your team. This agent eliminates manual data-pulling and enables data-driven product decisions by surfacing key trends, anomalies, and experiment results in a single narrative report.

How It Works

1. List Projects (PostHog) — Identifies and retrieves the active project ID from your PostHog workspace to scope all subsequent analytics queries.
2. Get Trend Results (PostHog) — Pulls weekly event trends including sign-ups, activation completion, feature usage, and subscription starts with user counts and aggregations.
3. Run HogQL Query (PostHog) — Executes a retention cohort analysis comparing 7-day vs. 14-day retention to measure user stickiness over time.
4. Run HogQL Query (PostHog) — Queries the activation funnel conversion rates by step to identify friction points in your user onboarding flow.
5. Get Experiment Results (PostHog) — Retrieves all running A/B test results including conversion rates and statistical significance indicators.
6. Get Event Definitions (PostHog) — Verifies all tracked events are firing correctly and discovers available event types for analysis.
7. Claude Opus 4.6 Analysis — Synthesizes all metrics data, calculates week-over-week deltas, flags outliers, and writes a narrative product health summary with strategic insights.
8. Send Message (Slack) — Posts the formatted weekly analytics report to your #product channel for team visibility.
9. Create Database Page (Notion) — Logs the complete weekly report as a new entry in your product metrics Notion database for historical tracking.
10. Append Blocks (Notion) — Adds metric visualizations, action items, and direct links to PostHog dashboards for easy drill-down access.

Key Features

• Automated Weekly Cadence — Runs every Monday without manual intervention, ensuring consistent reporting and eliminating scheduling friction.
• Multi-Metric Correlation — Analyzes activation rates, retention cohorts, funnel conversions, and A/B test results in a single coherent narrative.
• Week-over-Week Benchmarking — Automatically compares current metrics against prior weeks to surface trends, improvements, and concerning changes.
• AI-Powered Insights — Uses advanced reasoning to identify anomalies, connect metric patterns, and generate actionable recommendations.
• Integrated Knowledge Hub — Posts reports to Slack for immediate visibility and archives them in Notion for long-term trend analysis and team reference.

Use Cases

• Product Managers monitoring product health — Get a comprehensive Monday morning briefing on user engagement, conversion performance, and experiment outcomes to inform sprint priorities.
• Growth teams optimizing activation funnels — Automatically track funnel conversion rates week-to-week and quickly spot which funnel steps are degrading or improving.
• Leadership teams seeking data-driven decisions — Share polished weekly metrics summaries in Slack and Notion to keep executives aligned on product performance trends and KPI trajectories.
• Data-driven organizations building institutional memory — Automatically archive weekly analytics in Notion to enable historical comparison, team onboarding, and long-term product trend identification.