HogQL-powered insights
We've rewritten all our insights in HogQL and are releasing them, starting with trends.
This makes insights faster, more reliable, and enables advanced customization.
Q: Does pineapple belong on pizza?
% of this team (correctly) agree pineapple belongs on pizza
We're building an insights-like search functionality for everything qualitative. That means people, recordings, cohorts, events, and groups. This will enable you to search using simple sentences to easily find anything in PostHog. Additionally, you can trigger context-sensitive actions - such as cr...
No updates yet. Engineers are currently hard at work, so check back soon!
Here’s what we’re considering building next. Vote for your favorites or share a new idea on GitHub.
We've rewritten all our insights in HogQL and are releasing them, starting with trends.
This makes insights faster, more reliable, and enables advanced customization.
HogQL-based querying
Querying and processing performance (Thomas, Julian)
Artificial Hog / Post Intelligence (Michael)
Activation (side quest: Michael)
assumeNotNull
.NULL
-s. Whenever it sees any unaccounted null anywhere, the entire row is discarded from analysis. We have several fields and properties, which are sometimes NULL
, but mostly not. We have special handling for nullable fiels in the concat
function, and in all compersions. For example (0 != NULL)
feels like it should return true
, but in ClickHouse it returns NULL
. In HogQL it returns true
due to our special handling.NULL
. Unfortunately this nullability information gets lost once fields pass functions and subquery boundaries. Upgrading the type system to account for this is the goal.The highest-performing product teams building the most loved products at high-growth startups. For more context on the company read about the ideal customer persona.
Product analytics is a wide tool which fulfills many job-to-be-done (non-exhaustive list):
You can broadly group the job-to-be-done of Product Analytics in PostHog as:
You can find out more about the features we own here