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.
