SaaS Cohort Analysis Tools Compared (Amplitude, Mixpanel, PostHog)

The cohort analysis tool market has consolidated around three dominant options for SaaS product teams: Amplitude, Mixpanel, and PostHog. Each has a distinct philosophy, a different pricing model, and different analytical strengths. Choosing the wrong tool — or choosing the right tool for the wrong reasons — creates switching costs that accumulate over years as historical data, team workflows, and downstream integrations build up around the initial choice.

This comparison evaluates all three tools across the dimensions that matter most for product analytics work: retention analysis depth, funnel and cohort construction, behavioral segmentation, SQL access, pricing structure, integration ecosystem, and fit by company stage. It closes with a decision matrix that matches tool characteristics to the most common company situations.

Retention Analysis Depth

Retention analysis is the core use case that separates serious product analytics tools from general dashboarding tools. The retention question — "of users who did X, what percentage came back to do Y at each subsequent time interval?" — requires precise control over cohort definition, retention event definition, and time granularity.

Amplitude provides the most flexible retention analysis of the three. It supports four retention measurement approaches: N-day retention (active on exactly day N after the cohort event), bracket retention (active at any point within a time bracket), unbounded retention (active at any point after day N), and return retention (performed the same event at least once again). Each can be defined with a different retention event — "logged in," "completed a workflow," "exported a report" — allowing the analyst to measure retention on behaviors that represent actual value delivery rather than passive presence.

Amplitude's behavioral cohorts can be applied to retention analysis, allowing questions like: "What is the 90-day retention of users who completed the onboarding flow versus users who did not, broken out by acquisition channel?" This multi-dimensional cohort retention is where Amplitude genuinely leads the field.

Amplitude's 2024 product benchmark data, drawn from analysis across its customer base, found that products with retention curves that flatten above 40% at 8 weeks (indicating a stable retained core) grew revenue 2.6x faster over the following 12 months than products with continuously declining retention curves — a finding that underscores why retention analysis depth is the most important capability in the category.

Mixpanel provides strong retention analysis through its "Retention" report, which supports interval retention and bounded retention views. The cohort definition is accessible — filtered by user properties and prior event completion — but the flexibility to define complex multi-event cohort conditions is more limited than in Amplitude. For standard retention questions (day-7, day-30, day-90 by acquisition source and plan tier), Mixpanel is excellent. For research-grade retention analysis with complex behavioral cohort definitions, it has limits.

PostHog has added significant retention analysis capabilities in recent versions and now supports N-day, weekly, and monthly retention with behavioral cohort filtering. Its retention analysis is functional for most product team needs, but the depth of configuration — particularly around multi-event retention definitions and retention curve segmentation — lags Amplitude. PostHog's advantage in retention analysis is not depth but integration: because session replay and feature flag data live in the same system, analysts can immediately pull recordings of churned users from a retention cohort to understand behavioral patterns. This qualitative integration is not available in Amplitude or Mixpanel natively.

Funnel Cohort Construction

Funnel analysis in all three tools follows the same conceptual model but with different implementation flexibility. The key differentiators are: support for unordered funnels, time window customization per step, property filtering within funnel steps, and cohort breakdowns applied to funnel conversions.

Amplitude supports both strict-order and any-order funnels, with per-step time window customization and property-level filtering within each step. Its "Conversion Drivers" feature automatically segments converting versus dropping users by the properties that most distinguish the two populations — a significant time-saver that surfaces segmentation insights that would otherwise require manual iteration.

Mixpanel funnels are the most visually accessible and support per-step time windows, property filtering, and the ability to see individual users at each funnel step (useful for qualitative investigation of drop-off populations). Mixpanel's "Funnel Trends" view, which shows conversion rate over time by completion date, is particularly useful for detecting whether a product or marketing change has improved funnel conversion. The limitation is that Mixpanel's unordered funnel support is less sophisticated than Amplitude's.

PostHog funnels support strict-order and unordered modes, with step-level time window customization. The integration with session replay at the funnel step level is PostHog's unique strength: when a user drops off at step 3, the funnel view surfaces a button to watch session recordings of users who dropped at that step. This makes PostHog funnels more diagnostic than statistical — the question is not just "how many dropped off" but "what were they doing when they dropped off."

For the instrumentation requirements that make any of these funnel tools work correctly, see the product analytics instrumentation playbook. For the structural principles of correct funnel visualization, see the funnel visualization best practice guide.

Behavioral Segmentation

Behavioral segmentation — the ability to define user populations by what they did, not just who they are — is the capability that separates product analytics tools from BI tools.

Amplitude has the most powerful behavioral segmentation engine. Amplitude cohorts can include multi-step event sequences with time-between-event constraints ("users who completed event A within 3 days of completing event B, but not event C"), property-level conditions at the event level, and time-windowed event count conditions ("users who triggered event A more than 5 times in the past 30 days"). These cohorts can be applied to any analysis type — retention, funnel, user composition — making it possible to do genuinely complex behavioral research.

Mixpanel behavioral cohorts support event completion conditions, event count conditions, and property filters, but multi-step sequence conditions with time constraints are more limited. For most product team segmentation needs — "users who did onboarding but did not use feature X," "users who logged in more than once in week 1" — Mixpanel is fully capable. For research-grade behavioral cohort construction, Amplitude is stronger.

PostHog behavioral cohort support is growing but is currently behind both Amplitude and Mixpanel for complex multi-step behavioral definitions. For straightforward segmentation (users who fired event X, users with property Y), PostHog is fully capable. For complex behavioral cohorts, PostHog's SQL access via HogQL is the recommended path — which requires data team involvement.

SQL Access and Data Portability

SQL access to raw event data is increasingly a baseline requirement rather than a premium feature, as data teams build custom models, join product data with CRM and financial data, and need to avoid being locked into a vendor's query interface.

PostHog provides the most direct SQL access of the three. Its HogQL interface allows arbitrary SQL queries over the event store, and its data warehouse integration (connecting to BigQuery, Snowflake, Redshift, S3) allows event data to be queried alongside external tables. PostHog is the right choice for companies that want SQL-first product analytics.

Amplitude provides SQL access through its Amplitude Data Management platform and through data export to Snowflake or BigQuery. The SQL access is real but indirect — it requires a data export setup rather than direct querying of Amplitude's event store. Amplitude's primary interface is its visual analytics product, not SQL.

Mixpanel does not provide direct SQL access to raw events. Analysis is done through the UI or through Mixpanel's HTTP query API, which returns aggregated results rather than raw events. Companies that need SQL access to product event data alongside Mixpanel will need to implement a parallel event export pipeline to a data warehouse — which adds infrastructure cost and complexity.

For the data warehouse options that complement any of these tools, see the SaaS data warehouse graduation guide.

Pricing Structure Comparison

The pricing models of the three tools are structurally different, which creates very different cost trajectories as a company grows.

Amplitude prices on Monthly Tracked Users (MTUs) — the number of unique users who fired at least one event in a calendar month. This means costs scale with user base growth, not event volume. For products with high event-per-user ratios (power users generating many events), Amplitude can be relatively cost-effective. For products with large inactive user bases (where many users fire one event per month to be counted as MTUs), it can be expensive. Amplitude's Starter plan is free up to 50,000 MTUs. Growth pricing is custom.

Mixpanel also prices on MTUs, with a free plan up to 20M events/month (effectively unlimited for early-stage). Mixpanel has historically been more aggressively priced than Amplitude for comparable feature sets, and its free tier is more generous. The Growth plan pricing becomes competitive with Amplitude at most company sizes.

PostHog prices on events ingested, with 1M events/month free on the cloud. Beyond that, pricing is $0.00045 per event, with significant volume discounts. Self-hosted PostHog has no event-based fees — infrastructure costs only. For companies at 50M+ events/month, PostHog is typically the lowest-cost option of the three by a significant margin. The trade-off is that self-hosting requires infrastructure management that Amplitude and Mixpanel do not.

Integration Ecosystem

Amplitude has the most extensive native integration ecosystem, with direct connections to Salesforce, HubSpot, Braze, Iterable, Snowflake, BigQuery, Redshift, and dozens of other tools. Its data management features allow property enrichment from connected data sources. For companies running complex marketing and customer data stacks, Amplitude's integrations reduce the custom pipeline engineering required.

Mixpanel has a broad integration ecosystem via Segment and Rudderstack compatibility plus native connections to common tools. It is well-integrated into the modern data stack but has fewer native connections than Amplitude.

PostHog integrates via its webhook system and CDP destinations, with native connections to major data warehouses and popular tools. Its self-hosted nature makes it the most data-sovereignty-compatible option for companies with strict data residency requirements.

Decision Matrix by Company Stage

Seed stage (pre-$1M ARR), small team, no dedicated analyst: PostHog on the cloud free tier. It covers product analytics, feature flags, session replay, and A/B testing in one tool without cost. The self-serve analytics quality is sufficient for product teams at this stage, and the event-based pricing means costs only scale when the business is generating meaningful activity.

Series A ($1M–$5M ARR), product team with occasional analyst support: Mixpanel at growth pricing. The self-serve accessibility is the decisive factor — product managers can answer retention and funnel questions without waiting for analyst availability. Mixpanel's free tier covers most companies at this stage.

Series B and beyond ($5M+ ARR), dedicated data/analytics team: Amplitude for companies prioritizing behavioral cohort analysis depth and integration with a complex martech stack. PostHog for companies with data residency requirements, high event volumes where pricing matters, or a preference for SQL-first analytics and open-source tooling.

Multi-product companies with complex data requirements: A warehouse-first approach (BigQuery or Snowflake as the primary analytics layer) with PostHog or Amplitude as the product analytics UI layer. This separates the analytics from the vendor and allows SQL-based analysis across all data sources. The self-serve analytics guide describes how to implement this architecture.

Companies with feature flag and A/B testing as primary use cases: PostHog, which is the only tool of the three that provides a production-grade feature flag and experiment system integrated with product analytics. For experiment-heavy teams, this integration eliminates the need for a separate experimentation platform for simple feature flag-based experiments. For more complex experiments, see the experimentation platform build vs buy guide.

Frequently Asked Questions

Conclusion

Amplitude, Mixpanel, and PostHog each serve a different primary use case well. Amplitude is the analyst's tool — powerful behavioral cohort construction, deep retention analysis, and an extensive integration ecosystem that suits data-team-backed product analytics at growth and scale. Mixpanel is the product manager's tool — fast, self-serve, accessible funnel and retention analysis that does not require SQL or data team support. PostHog is the builder's tool — open-source, SQL-accessible, integrated with feature flags and session replay, and cost-effective at high event volume.

The selection decision should be driven by team composition, event volume, data residency requirements, and the relative priority of self-serve accessibility versus analytical depth. Switching between these tools after significant historical data and team workflows have accumulated around one is expensive — the initial decision deserves careful analysis of the factors that will matter most at the company's next stage, not just its current one.