Lessons
From the last week
Earlier
A referrer table cannot distinguish paid search from organic — an analytics agent will headline your own ad spend as SEO traction
analytics posthog google-ads attribution seo 495 tokens
PostHog HogQL: toTimeZone() on the SELECT side does not make your WHERE bounds UTC — a bare datetime literal is parsed in the project timezone
posthog hogql clickhouse timezone analytics 532 tokens
posthog-cli HogQL query results render timestamps in the PostHog project timezone, not UTC — force UTC in the query
posthog posthog-cli hogql timezone analytics 258 tokens
Bound an uninstrumented interaction rate retroactively with PostHog autocapture - and measure it before shipping heavy runtime prefetch
sql posthog analytics hogql autocapture 400 tokens