June

YES

Replaceable in one session with an AI coding agent.

Product analytics with the reports already built: activation, retention and feature usage presented as answers rather than as a query builder.

Promptfree, for everyone, and the only version there is

Build the four reports that get read.

STACK
- Postgres, one events table, a small dashboard

EVENTS
- name, properties as JSON, user id, company id, timestamp
- Appended only; nothing updated, no aggregate tables

THE FOUR REPORTS
- Activation: the share of new users who reached a chosen event within seven days
- Retention: cohorts by first-seen week against activity in later weeks
- Feature usage: distinct users per event per week
- Company rollup: the same three grouped by company id rather than user id

WHY THOSE FOUR
- Every product analytics tool ends up showing these. Building them directly skips the query builder entirely

NAMING
- Event names in one shared constants file; never a string literal at a call site

Include the schema and all four queries.

What you lose

Report templates that answer the standard product questions without anyone designing a dashboard
Integrations that pull events from the tools you already send them to
Company-level rollups for business-to-business products

If you would rather not build

A weekly SQL query, which is honestly enough at the start

The escape hatch

open source · no votes, no paid placement

PostHog

Product analytics with funnels, retention and cohorts, self-hostable.

PostHog/posthogfree · open source

Metabase

Saved questions and dashboards over a database you already run.

metabase/metabasefree · open source

Why this verdict

our own opinion · changed only by a person

74/100

Verdict yes at 74. Four SQL queries replace most of a product analytics tool at small scale, and they are the four everyone ends up reading.

History

tracked since 10 Aug 2026 · nothing is ever overwritten

Interest · last 30 days

Nothing recorded yet. This chart fills in once the page has visitors, votes or prompt copies — it will not draw a flat line to look busy.

Questions about June

answered from the record above

Is June free?

No — the plan we track is $149 a month. From around $149/month billed monthly, priced on tracked users.

Can you replace June by building your own?

YES. Replaceable in one session with an AI coding agent. Replacement score 74 out of 100, build time one session. Read what you lose before you decide.

How much does June cost?

$149 a month on Pro — $1,788 a year. Recorded 10 Aug 2026.

What do you lose by replacing June?

Report templates that answer the standard product questions without anyone designing a dashboard; Integrations that pull events from the tools you already send them to; Company-level rollups for business-to-business products. If any of those carry weight for you, keep paying.

Is there an open-source alternative to June?

Yes: PostHog, Metabase. The prompt on this page is for when you want it your way instead.

Related entries

same category first, most replaced first

All 21 in Analytics

Coming soon

Every week, something stops being worth paying for.

New verdicts, prices that moved, entries added. One email a week. Unsubscribe in one click.

free forever · no tracking pixel · every prompt stays free on the site