All posts
Own Your Data

PostHog, Mixpanel or Your Own Pipeline: Product Analytics You Own

By

October 30, 2026

6 min read

PostHog gives 1M events a month free and is open source, but says self-hosting is unsupported and practical only under about 300,000 events a month. Mixpanel is $10,080 a year at 10M events. A first-party pipeline on Firehose, S3 and Athena costs a few dollars a month at the same volume. What each one is good at.

Product Analytics
Own Your Data
PostHog
Mixpanel
Amazon Athena

Product analytics is the easiest tool to own and the one where owning it matters most. The events are a record of what every user did in your product. They are also the data an AI assistant needs to answer "why did signups drop last week".

The options

Option

Price

Strength

Catch

PostHog Cloud

First 1M events/month free; then $0.00005 per event for 1–2M, falling with volume

Analytics, replay, flags, experiments in one

Your users' behaviour lives at PostHog

PostHog self-hosted

Hosting only (MIT licence)

Same product, your servers

PostHog calls it officially unsupported; it suggests it is practical under ~300k events/month

Mixpanel Growth

1M events free; $10,080/year at 10M events/month

Mature analysis UI

Per-event pricing; data at Mixpanel

Your own pipeline on AWS

Firehose $0.029/GB ingested; Athena $5/TB scanned; S3 storage

Raw events in SQL, any retention, no third party

You build the dashboards

Want a second opinion on this for your system?

Book a free 30-minute call. You'll leave knowing what we'd do first and roughly what it costs, whether or not you hire us.

What an owned pipeline looks like

  1. A small SDK that sends typed events to a collector on your own domain (no third-party host for blockers to match).

  2. The collector validates each event and puts it on Amazon Data Firehose.

  3. Firehose writes compressed files to S3, partitioned by day.

  4. Athena queries the files with SQL. Partition projection means a new day is queryable with no crawler.

  5. Dashboards read through your own API, cached for a few minutes.

This is the pipeline behind our own sites. At 10M events a month of about 1KB each, Firehose bills each record in 5KB increments, so ingestion is roughly 50GB, about $1.45 a month. Gzipped storage is a few gigabytes. Each dashboard query scans a few days of partitions, a fraction of a cent.

What you give up

  • Session replay and heatmaps. Building replay well is real work; if you need it, keep a tool for replay alone and sample it.

  • Point-and-click funnels for non-technical users, unless you build the screens. SQL is the interface until then.

  • Feature flags and experiments, which are a separate system. A simple flag table and a hash-based assignment go a long way.

hoolco Monthly Review

Once a month: what changed in tech that month and what it means for you, from cloud and AI to security and the tools you build with. Every item links to its source. No sales pitch, unsubscribe in one click.

As of October 30, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.