# Posthog Financial Model Open-source product analytics platform built for engineers and product teams, with self-hosted deployment and a complementary paid cloud tier. - Canonical: https://finamodel.com/startups/posthog - Excel download: https://finamodel.com/startup-models/posthog.xlsx - Category: Dev Tools - Model type: SaaS ARR / Valuation - Funding round: Series B - Funding: $15M - Founded: 2021 - Geography: Not in deck (company is UK-founded but targets global developer market). - Customer: B2B ## About the company PostHog is a self-deployable open-source product-analytics platform with trends, retention, funnels, paths, dashboards, session replay, feature flags, and heatmaps. It targets technical product teams that want a unified, extensible tool without data silos, SQL dependency, or surrendering usage data to third parties. Free self-hosted software is the acquisition engine. Cloud hosting and enterprise self-hosted tiers add scalability, permissions, support, and service levels, using flat pricing. Community evangelism, content, and open-source contributions generate inbound paid demand, but the deck does not provide tiers, ARR, or ARPU. Thousands of companies were using PostHog, alongside about 6,500 community developers and 100 contributors, with less than $25,000 total marketing spend. Target users had 50% one-month free-product retention. The model should forecast deployments, cloud conversion, usage, enterprise upgrades, hosting cost, expansion, and churn. ## What's included - 5-year monthly revenue build with stage-appropriate growth assumptions - Full P&L, headcount plan, and operating-expense schedule - Cash-flow statement, runway, and burn-rate tracking - Valuation via exit multiple with a DCF cross-check - Returns analysis with MOIC and IRR - Unit economics including CAC, LTV, payback, and cohort retention ## Product & value proposition - Product analytics platform (trends, retention, funnels, paths, dashboards, session replay, feature flags, heatmaps) in a single self-deployable tool. - Core proposition: eliminates data silos and the need for multiple stitched-together tools; no SQL required; flat pricing. - Self-host option is the primary differentiator - addresses GDPR/privacy needs and avoids sending user data to third parties. - Plugin/event-pipeline architecture allows data export/import and extensibility (CDP capability). - Target persona: technical PMs and senior engineers at companies where product usage is strategic; "visionaries" who want control and extensibility without being sold to. ## Market - No TAM/SAM/SOM figures given in deck. - Market framing: existing product analytics tools (Mixpanel, Amplitude etc.) were not built for engineering teams and create data silos. - Two segments identified: (1) Startups - broad, shallow, well-defined needs; (2) Scale-ups & Enterprise - high volume + privacy + product-led = "very badly served". - Market thesis: product-led growth becoming mainstream; every team will eventually need a clear view of user behavior. ## Revenue model - Open-source core (self-hosted, free) drives top-of-funnel adoption. - Paid product: cloud-hosted tier and enterprise self-host with permissioning, scalability, support, and SLAs. - Pricing model: "flat pricing" referenced as a differentiator. - Go-to-market: community-led (developer evangelism, content, open-source contributions) → inbound paid enquiries → enterprise upsell as product matures. - No ARR, MRR, ARPU, or pricing tiers disclosed numerically in deck. ## Traction & metrics - Deployments: "Thousands of companies are using us" - chart shows steep J-curve from ~early 2020 to late 2020; no Y-axis labels visible. - Deployment growth rate: increasing month-on-month; chart of deployments/month shows acceleration in most recent period (month shown as incomplete with projection). - Monthly events (cloud only): exponential growth Jan–November 2020; sharp near-vertical inflection from October to November 2020. No absolute values on Y-axis. - Inbound demand: separate chart (Apr 2020 – Jan 2021) shows near-zero until ClickHouse enabled (~Oct 2020), then near-vertical growth through Jan 2021. - Community: ~6,500 developers across Slack, GitHub, Twitter, and product; ~100 contributors across all repos (up from 0 in February 2020). - Marketing spend: <$25K total marketing spend over all time. - Retention (free product): 50% one-month retention for target persona (technical PM / senior engineer); 33% for other profiles. ## Unit economics - Retention: 50% M1 for core persona vs. 33% for others. - CAC: effectively near-zero for self-serve / community channel; <$25K total marketing spend to acquire thousands of companies. - No LTV, payback period, gross margin, or ARPU figures in deck. ## Competition / moat - Named competitors (implicit): Mixpanel, Amplitude - "not built for teams, engineers left out". - Moat sources: open-source community (100 contributors, 6,500+ developers); self-host option enabling privacy/GDPR compliance; extensibility via plugins; flat pricing vs. event-based pricing of incumbents. - Competitive positioning: incumbents serve enterprise well; startups are underserved on the whole-product dimension. PostHog targets visionaries first, then pragmatists as product matures. ## Team & funding ask / use of funds - Use of funds: Implied by roadmap - expand value proposition, grow community (developer evangelism, DX), take plugins out of beta, build inbound sales process for enterprise. --- ## Recommended financial model - **Archetype + why:** Open-source SaaS - usage-based / freemium ARR model. PostHog has two distinct layers: (1) a free self-hosted OSS product that drives community and deployment growth, and (2) a paid cloud + enterprise tier. The model should track free deployments as a top-of-funnel lead pool converting to paid cloud seats or enterprise contracts. This is analogous to a PLG (product-led growth) SaaS model with a free-to-paid conversion funnel. - **Forecast horizon & granularity:** 3 years (2021–2023), monthly for Year 1, quarterly for Years 2–3. - **Key drivers & assumptions:** - Monthly new deployments (free self-hosted): thousands already deployed; rate accelerating month-on-month. Model ~500–1,000 new deployments/month at deck date, growing 15–20% MoM - rationale: steep J-curve visible in slide 9/10 images with no Y-axis labels to anchor absolute figure. - Free-to-paid conversion rate (cloud): 2–5% of free deployments convert to cloud paid plan - rationale: typical OSS-to-SaaS conversion range; deck shows "swamped with paid enquiries" but no conversion % given. - ARPU (cloud paid): $500–$2,000/month - rationale: "flat pricing" model, developer-tool comps (Segment, Amplitude SMB tier), no pricing disclosed. - Enterprise ACV: $20,000–$100,000/year - rationale: enterprise self-host with permissioning/scalability support, consistent with dev-tools enterprise pricing; no figures in deck. - M1 retention (free): 50% for core persona, 33% for others. Blended ~40% assumed for modeling. - Paid churn (monthly): 2–3% gross - rationale: strong testimonials, "can't survive without PostHog" quotes; early-stage so some involuntary churn expected. - CAC (community/inbound): near-zero for self-serve; $5,000–$15,000 for enterprise sales-assisted - rationale: <$25K total marketing to date for thousands of deployments. - Gross margin: 70–80% - rationale: cloud hosting + support costs offset by high software margins; self-host has near-zero COGS. - Headcount growth: seed-stage team, 10–20 people at deck date; scale in engineering and growth engineering per roadmap focus 2021. - **Scenarios (Base / Bull / Bear - which variables flex):** - Base: 15% MoM deployment growth, 3% free-to-paid conversion, $800 ARPU, 2.5% monthly paid churn. - Bull: 25% MoM deployment growth, 6% conversion, $1,200 ARPU, 1.5% churn - driven by accelerating ClickHouse-enabled inbound and enterprise deals. - Bear: 8% MoM deployment growth, 1.5% conversion, $500 ARPU, 4% churn - community plateaus, enterprise sales cycle longer than expected. - **Required sheets / outputs:** 1. Assumptions dashboard (all drivers in one place, color-coded) 2. Deployment funnel (free installs → active → paid cloud → enterprise) 3. ARR bridge (new, expansion, churn, net new ARR by month) 4. P&L (revenue, COGS, gross profit, S&M, R&D, G&A, EBITDA) 5. Headcount plan (by department) 6. Cash / runway (burn rate, months runway) 7. KPI summary (deployments, DAU/MAU, conversion rate, NRR, CAC, LTV, LTV:CAC) ## Frequently asked questions ### Is the Posthog financial model free? Yes. The Posthog model is a free Excel download with live formulas. ### Can I change the assumptions? Yes. The workbook is editable and its live formulas recalculate when assumptions change.