Ask HN: Best way to generate product analytics SQL?

2 pointscolinplamondon3y ago2 comments

I've always used Amplitude / Mixpanel, but lately there's some queries that I just can't get out of it.

- Conversion funnels, grouped by user properties identified later in the funnel. - Highly specific cohort retention - Automating reporting into Google Sheets across weekly/monthly/quarterly.

Feels like I finally need to bite the bullet and learn SQL after pushing it off for a decade.

Anyone have links to services that generate SQL queries for common product analytics queries? I'm finding various blog posts, and a lot of enterprise-targeted BI tools.

Is there any tool that, given a schema, pops out queries? Like June.so for product analytics SQL queries.

Rakam looks similar to what I want, but it got bought, and seems to be EOL.

2 comments

XCSme3y ago

Not sure if it helps with your question, but there was a Show HN recently about a tool to generate metrics from SQL: https://news.ycombinator.com/item?id=30938109

colinplamondonOP3y ago

Whoa- thank you! Insanely close, this is awesome. Much appreciated.

j / k navigate · click thread line to collapse