PostHog Endpoints Tutorial: Build a Custom Analytics Dashboard from Scratch

PostHog recently shipped Endpoints, a feature that lets you create custom API endpoints from HogQL queries. In this video, JJ walks through the full process of building a web analytics dashboard powered by PostHog's endpoint infrastructure. You'll see how to plan your data structure, write HogQL queries, add SQL variables for date filtering, create materialized views for faster performance, and connect everything to a front-end dashboard. A s of March 2026, the Endpoints feature has no pricing yet, so it's a good time to experiment. This is a practical walkthrough, not a conceptual overview. JJ builds the endpoint live, runs into real errors, and shows how to troubleshoot them. If you want help setting up PostHog for your product or building custom dashboards with endpoints, reach out at visionlabs.com/contact Topics covered: 00:00 Dashboard demo and overview 00:31 Who is JJ Reynolds / VisionLabs intro 00:53 PostHog Endpoints feature (currently free, pricing coming soon) 01:08 Planning your data structure in a Google Sheet 02:12 Creating your first endpoint in PostHog 02:44 Using HogQL AI to write your SQL query 03:30 Understanding WHERE statements and removing filters 04:18 Adding SQL variables (start date / end date) 04:51 Using variables in your query 05:30 VisionLabs CTA 06:00 Troubleshooting variable errors and populating dates 06:48 Saving your endpoint 07:15 Using the endpoint with your API key 07:32 Cache age and materialization settings 07:57 Creating a materialized view manually 09:33 Materializing the view and setting sync frequency 10:10 Swapping your endpoint query to use the materialized view 11:08 Troubleshooting date formatting with toDate 11:47 Why materialized views make queries faster 12:25 The actual query behind the demo dashboard 13:11 Recap and when this approach makes sense