PostHog weekly
PostHog is a product analytics platform. Basedash queries your PostHog data directly with HogQL. Connect PostHog to Basedash to ask questions, build dashboards, and automate reporting with AI.
14-day trial. No credit card required.
Pulled the last 12 weeks from posthog. Up +38% vs. the prior period — growth accelerating in the last four weeks.
Basedash connects to your PostHog project and queries events, persons, and other tables with HogQL, PostHog's SQL dialect. No sync to Basedash Warehouse is required.
Read the PostHog setup guideCreate a personal API key
In PostHog, go to Settings > Personal API keys and create a key with the query:read scope for your project.
Pick your region and project
Choose US Cloud, EU Cloud, or Self-hosted with your host URL, then enter the project ID from your PostHog dashboard URL.
Connect and sync
Basedash checks the key, then syncs the project's schema.
Access Basedash needs
- A personal API key with the query:read scope
- Access to the project you want to analyze
Imagine ChatGPT or Claude, but with full context of your PostHog schema and how your team uses it. Basedash answers in plain language, backed by real queries.
Try asking
- Revenue by region from PostHog for the last four quarters.
- Which PostHog tables power our core KPIs, and how fresh are they?
- Compare weekly active accounts in PostHog against last year.
- Break down PostHog orders by product line and channel.
Plain-language queries
Ask follow-ups in natural language. Basedash translates them into SQL against your PostHog data.
Knows your business
Basedash learns your KPIs, schemas, and the way your team talks about PostHog.
Agentic by default
Runs multiple queries, resolves errors, and keeps iterating until the answer is right.
Keep querying PostHog directly, and sync your SaaS tools into a managed warehouse to see how sales, finance, product, and operations actually connect.
- Queries run in placeBasedash connects to PostHog directly and queries your data where it lives. No copies to keep in sync.
- Scoped credentialsConnect with a dedicated PostHog user or key so Basedash only sees the data you grant.
- SaaS data alongsideSync CRM, billing, and support tools into Basedash Warehouse and analyze them in the same workspace.
Common questions about PostHog and Basedash
Does Basedash copy my PostHog data?
No. Basedash queries your PostHog project directly with HogQL, so events, persons, and other tables stay in PostHog and there's no sync to maintain. If you want to join PostHog data with your CRM or billing tools, you can sync those tools into Basedash Warehouse alongside it.
Does Basedash work with PostHog EU Cloud and self-hosted PostHog?
Yes. Choose US Cloud, EU Cloud, or Self-hosted when you connect. Pick the region that matches the URL you log in with, us.posthog.com or eu.posthog.com. For self-hosted instances, enter your PostHog host, for example https://posthog.example.com.
Which PostHog API key scope does Basedash need?
A personal API key with the query:read scope for the project you want to analyze. Create one just for Basedash, limited to the projects it needs, and rotate it regularly. If the connection fails, confirm the project ID belongs to an organization the key can access.
More warehouse sources
See all integrationsPopular dashboards for PostHog
Each template includes a sample dashboard, metric guidance, and a copy-pasteable AI prompt.
Popular automations for PostHog
Each template includes a copy-pasteable AI prompt and an example output.
- Customer success
Weekly customer health report
Weekly account-by-account health scoring with churn risk, expansion signals, and at-risk renewals.
Open template - Growth
Weekly user growth report
New signups, activations, WAU, and the channels behind each — pulled into one weekly growth recap.
Open template - Growth
Activation funnel report
Step-by-step activation funnel with drop-off, time between steps, and which channels activate fastest.
Open template - Product
Feature adoption report
Weekly adoption of every new feature, with power users named and underperforming features flagged.
Open template
We'll walk through how Basedash works with PostHog and answer questions for your exact use case.