product guideMar 18, 2026·11 min read

How PostHog Activation Funnel Diagnoser Finds Drop-Offs

By Jonathan Stocco, Founder

The Problem

Your team runs this workflow every week: pull records from Posthog, Notion, Slack, cross-reference with a second source, apply judgment, format the output, and route it to 3 different stakeholders. Last Tuesday it took 30–60 minutes per cycle. This Tuesday the person who usually runs it is out sick, and nobody else knows the exact steps. The output varies by who runs it and when.

The core issue is data fragmentation. The information exists, but assembling it into actionable intelligence requires manual effort that does not scale with headcount. PostHog Activation Funnel Diagnoser closes that gap by automating the product analytics and onboarding optimization workflow from data extraction through structured output delivery.

INFO

Teams typically spend 30–60 minutes per cycle on the manual version of this workflow. PostHog Activation Funnel Diagnoser reduces that to seconds per execution, with consistent quality every time.

What This Blueprint Does

Four Agents. Weekly Funnel Diagnosis. Critical Drop Identification.

The PostHog Activation Funnel Diagnoser pipeline runs 4 agents in sequence. The Fetcher pulls data from Posthog and Notion and Slack, and The Formatter delivers the output. Here is what happens at each stage and why it matters.

  • The Fetcher (Code-only): Queries PostHog API for funnel step data, user properties, and event sequences across the activation funnel.
  • The Assembler (Code-only): Identifies critical drops in the activation funnel: steps with conversion below threshold, segments with disproportionate drop-off, time-to-activate outliers, and behavioral deltas between converters and non-converters at each step..
  • The Analyst (Tier 2 Classification): Performs root cause diagnosis for each critical drop: segment comparison (which user segments drop off most), behavioral delta analysis (what converters do differently), time-to-activate patterns, and friction indicators.
  • The Formatter (Tier 3 Creative): Generates a Notion funnel diagnosis report with per-step analysis, segment breakdowns, and prioritized fixes, plus a Slack digest with the top 3 critical drops and their recommended interventions..

When the pipeline completes, you get structured output that is ready to act on. The blueprint bundle includes everything needed to deploy, configure, and customize the workflow:

  • 24-node main workflow + 3-node scheduler
  • Weekly activation funnel diagnosis from PostHog funnel data
  • Critical drop identification at each funnel step
  • Segment comparison analysis showing which user groups drop off most
  • Behavioral delta analysis between converters and non-converters
  • Time-to-activate distribution analysis with outlier detection
  • Prioritized fix recommendations sorted by potential conversion impact
  • Friction indicator identification per funnel step
  • Notion funnel diagnosis report with per-step analysis and segment breakdowns
  • Slack digest with top 3 critical drops and recommended interventions
  • Configurable: funnel steps, segment properties, conversion thresholds
  • Full technical documentation + system prompts

All scoring criteria, output formats, and routing rules are configurable in the system prompts — no workflow JSON edits required. This means PostHog Activation Funnel Diagnoser adapts to your specific process, terminology, and integration requirements without forking the entire workflow.

TIP

Every component in this pipeline is designed for customization. Modify system prompts to change scoring logic, output format, or routing rules — no code changes required.

How the Pipeline Works

Understanding how the pipeline works helps you customize it for your environment and troubleshoot issues when they arise. Here is a step-by-step walkthrough of the PostHog Activation Funnel Diagnoser execution flow.

Step 1: The Fetcher

Tier: Code-only

The pipeline starts here. Queries PostHog API for funnel step data, user properties, and event sequences across the activation funnel. Retrieves per-step conversion rates, time-to-convert distributions, and user segment breakdowns for the configurable lookback window.

This stage ensures all downstream agents receive clean, validated input. If this step returns incomplete data, every downstream agent works with a degraded picture.

Step 2: The Assembler

Tier: Code-only

Identifies critical drops in the activation funnel: steps with conversion below threshold, segments with disproportionate drop-off, time-to-activate outliers, and behavioral deltas between converters and non-converters at each step.

Why this step matters: The result is a prioritized action queue, not just a data dump.

Step 3: The Analyst

Tier: Tier 2 Classification

Performs root cause diagnosis for each critical drop: segment comparison (which user segments drop off most), behavioral delta analysis (what converters do differently), time-to-activate patterns, and friction indicators. Generates prioritized fix recommendations sorted by potential impact.

Every field in the output is structured for the next agent to consume without parsing.

Step 4: The Formatter

Tier: Tier 3 Creative

This is the final deliverable — what lands in your inbox or dashboard. Generates a Notion funnel diagnosis report with per-step analysis, segment breakdowns, and prioritized fixes, plus a Slack digest with the top 3 critical drops and their recommended interventions.

The entire pipeline executes without manual intervention. From trigger to output, every decision point follows a documented path. Every execution produces a traceable audit trail.

All nodes have been validated during Independent Test Protocol (ITP) testing on n8n v2.7.5. The error handling matrix in the bundle documents the recovery path for each failure mode.

INFO

This blueprint executes in your own n8n environment using your own API credentials. Zero external data sharing.

Why we designed it this way

n8n's batch node only outputs the last batch. If you process 20 records in batches of 5, you get back 5 records — the last batch. Without static data accumulation, multi-record pipelines silently drop 75% of results. Every multi-record blueprint uses explicit accumulation to collect results across all batches.

— ForgeWorkflows Engineering

Cost Breakdown

Weekly activation funnel diagnosis with critical drop identification, segment comparison, behavioral delta analysis, and prioritized fix recommendations delivered via Notion and Slack.

The primary operating cost for PostHog Activation Funnel Diagnoser is the per-execution LLM inference cost. Based on Independent Test Protocol (ITP) testing, the measured cost is: Cost per Run: $0.03–$0.10 per run. This figure includes all API calls across all agents in the pipeline — not just the primary reasoning step, but every classification, scoring, and output generation call.

To put this in context, consider the manual alternative. A skilled team member performing the same work manually costs $50–75/hour for an operations analyst at a fully loaded rate (salary, benefits, tools, overhead). If the manual version of this workflow takes 30–60 minutes per cycle, the per-execution cost in human labor is significant. The blueprint executes the same pipeline for a fraction of that cost, with consistent quality and zero fatigue degradation.

Infrastructure costs are separate from per-execution LLM costs. You will need an n8n instance (self-hosted or cloud) and active accounts for the integrated services. The estimated monthly infrastructure cost is ~$0.03-0.10 per weekly run + PostHog subscription., depending on your usage volume and plan tiers.

Quality assurance: Blueprint Quality Standard (BQS) audit result is 12/12 PASS. ITP result is 8/8 records, 14/14 milestones. These are not marketing claims — they are test results from structured inspection protocols that you can review in the product documentation.

All cost and performance figures are ITP-measured — tested against real data fixtures on n8n v2.7.5 in March 2026. See the product page for full test methodology.

TIP

Monthly projection: if you run this blueprint 100 times per month, multiply the per-execution cost by 100 and add your infrastructure costs. Most teams find the total is less than one hour of manual labor per month.

What's in the Bundle

6 files.

When you purchase PostHog Activation Funnel Diagnoser, you receive a complete deployment bundle. This is not a SaaS subscription or a hosted service — it is a set of files that you own and run on your own infrastructure. Here is what is included:

  • CHANGELOG.md — Version history
  • README.md — Setup and configuration guide
  • docs/TDD.md — Technical Design Document
  • posthog_activation_funnel_diagnoser_v1_0_0.json — n8n workflow (main pipeline)
  • schemas/assembler_output.json — Assembler output schema
  • schemas/fetcher_output.json — Fetcher output schema
  • system_prompts/analyst_system_prompt.md — Analyst system prompt
  • system_prompts/formatter_system_prompt.md — Formatter system prompt
  • workflow/phaf_scheduler_v1_0_0.json — Scheduler workflow

Start with the README.md. It walks through the deployment process step by step, from importing the workflow JSON into n8n to configuring credentials and running your first test execution. The dependency matrix lists every required service, API key, and estimated cost so you know exactly what you need before you start.

Every file in the bundle is designed to be read, understood, and modified. There is no obfuscated code, no compiled binaries, and no phone-home telemetry. You get the source, you own the source, and you control the execution environment.

Who This Is For

PostHog Activation Funnel Diagnoser is built for Product, Growth teams that need to automate a specific workflow without building from scratch. If your team matches the following profile, this blueprint is designed for you:

  • You operate in a product or growth function and handle the workflow this blueprint automates on a recurring basis
  • You have (or are willing to set up) an n8n instance — self-hosted or cloud
  • You have active accounts for the required integrations: PostHog account with funnel events configured, Anthropic API key, Notion workspace, Slack workspace (Bot Token with chat:write)
  • You have API credentials available: Anthropic API, PostHog API Key, Slack (Bot Token, httpHeaderAuth Bearer), Notion (httpHeaderAuth Bearer)
  • You are comfortable importing a workflow JSON and configuring API keys (the README guides you, but basic technical comfort is expected)

This is NOT for you if:

  • Does not modify your funnel or product — this is an analysis tool that recommends changes for human review
  • Does not run A/B tests — it diagnoses funnel problems, not test treatments
  • Does not work with non-PostHog analytics tools — this is PostHog-specific
  • Does not track individual user journeys — it analyzes aggregate funnel patterns
  • Does not guarantee conversion improvements — it identifies drop patterns that teams must act on

Review the dependency matrix and prerequisites before purchasing. If you are unsure whether your environment meets the requirements, contact support@forgeworkflows.com before buying.

NOTE

All sales are final after download. Review the full dependency matrix, prerequisites, and integration requirements on the product page before purchasing. Questions? Contact support@forgeworkflows.com.

Edge cases to know about

Every pipeline has boundaries. These are intentional design decisions, not oversights — understanding them helps you deploy with the right expectations and plan for edge cases in your environment.

Does not modify your funnel or product — this is an analysis tool that recommends changes for human review

This is intentional. We default to human-in-the-loop for actions that carry reputational or financial risk. Once your team has validated output accuracy over 20+ cycles, you can adjust the pipeline to auto-execute — the workflow JSON supports it, but the default is conservative.

Does not run A/B tests — it diagnoses funnel problems, not test treatments

We scoped this boundary after ITP testing revealed inconsistent results when the pipeline attempted this. The agents handle what they handle well — extending beyond this scope requires custom prompt engineering specific to your data shape.

Does not work with non-PostHog analytics tools — this is PostHog-specific

This keeps the pipeline focused on a single workflow. Adding this capability would introduce branching logic that varies by organization, and the tradeoff between complexity and reliability was not worth it for a reusable blueprint. Fork the workflow JSON if your use case demands it.

INFO

The dead letter queue captures any records that fail processing. Check it after your first production run to validate data coverage.

Getting Started

Deployment follows a structured sequence. The PostHog Activation Funnel Diagnoser bundle is designed for the following tools: n8n, Anthropic API, PostHog, Notion, Slack. Here is the recommended deployment path:

  1. Step 1: Import workflows and configure credentials. Import both workflow JSON files into n8n (main + scheduler). Configure PostHog API key (httpHeaderAuth), Notion API token (httpHeaderAuth with Bearer prefix), Slack Bot Token (httpHeaderAuth with Bearer prefix, chat:write scope), and Anthropic API key following the README.
  2. Step 2: Configure funnel analysis parameters. Set POSTHOG_PROJECT_ID, FUNNEL_STEPS (ordered array of event names defining your activation funnel), SEGMENT_PROPERTIES (user properties for breakdown analysis), CONVERSION_THRESHOLD (default 0.5), NOTION_DATABASE_ID, and SLACK_CHANNEL in the scheduler Payload Builder node.
  3. Step 3: Activate scheduler and verify. Update the webhook URL in the scheduler to match your main workflow webhook path. Activate both workflows. Send a test POST with _is_itp: true and sample funnel data. Verify the diagnosis report appears in Notion and the digest appears in Slack.

Before running the pipeline on live data, execute a manual test run with sample input. This validates that all credentials are configured correctly, all API endpoints are reachable, and the output format matches your expectations. The README includes test data examples for this purpose.

Once the test run passes, you can configure the trigger for production use (scheduled, webhook, or event-driven — depending on the blueprint design). Monitor the first few production runs to confirm the pipeline handles real-world data as expected, then let it run.

For technical background on how ForgeWorkflows blueprints are built and tested, see the Blueprint Quality Standard (BQS) methodology and the Inspection and Test Plan (ITP) framework. These documents describe the quality gates every blueprint passes before listing.

Ready to deploy? View the PostHog Activation Funnel Diagnoser product page for full specifications, pricing, and purchase.

TIP

Run a manual test with sample data before switching to production triggers. This catches credential misconfigurations and API endpoint issues before they affect real workflows.

Frequently Asked Questions

What is a critical drop?+

A funnel step where conversion rate falls below the configurable threshold (default 50%), or where week-over-week conversion declined more than 10%. The Assembler flags these steps and the Analyst diagnoses why users are dropping off at that specific point. The system prompts are standalone text files — edit scoring thresholds and output formats without touching the workflow JSON.

What are behavioral deltas?+

At each critical drop step, the Analyst compares the event sequences of users who converted vs those who did not. Behavioral deltas reveal what converters did differently — for example, they viewed the docs page before signing up, or they completed a tutorial step that non-converters skipped. Check the dependency matrix in the bundle for exact version requirements and credential setup steps.

How does segment comparison work?+

The Assembler breaks down conversion at each step by user properties (plan type, referral source, device, geography, etc.). If enterprise users convert at 80% but free users convert at 30% at the same step, that segment disparity drives targeted fix recommendations. The README walks through configuration in under 10 minutes, including test data for validation.

Is there a refund policy?+

All sales are final after download. Review the Blueprint Dependency Matrix and prerequisites before purchase. Questions? Contact support@forgeworkflows.com before buying. Full terms at forgeworkflows.com/legal.

What happens if PostHog event data is incomplete for a user?+

The analysis agent handles missing events gracefully — users without activation events score lower on those dimensions but aren't excluded. The output includes a data_completeness flag per user so you can filter results by confidence level.

Get PostHog Activation Funnel Diagnoser

$249

View Blueprint

Related Blueprints

Related Articles

PostHog Activation Funnel Diagnoser$249