Overview
Use PostHog as a data source for Chartcastr. Connect your PostHog project with a Personal API Key and Chartcastr will pull active user metrics, growth accounting data, and event analytics to generate charts delivered automatically to Slack or email. Chartcastr connects with read-only access to your PostHog project — it only needs thequery:read API key scope.
Setup
Create a PostHog Personal API Key
In PostHog, go to Settings → Personal API Keys (direct link) and create a new key. Grant it the
query:read scope. Copy the key — you’ll need it in the next step.Find your Project ID
In PostHog, go to Settings → Project and copy your Project ID (a numeric value). You can also find it in the URL:
https://us.posthog.com/project/<PROJECT_ID>/.Connect in Chartcastr
In Chartcastr, go to New Connection and select PostHog as a source. Enter your Personal API Key, Project ID, and host URL. Click Validate to test the connection.
Host URL: Use
https://us.posthog.com for US Cloud or https://eu.posthog.com for EU Cloud. Self-hosted users should enter their own PostHog instance URL.Select a metric
Choose which metric type you want to track. Each metric becomes its own source. You can add multiple sources to send different charts on different schedules.
Available Metrics
Active Users
| Metric | Description |
|---|---|
| DAU (Daily Active Users) | Unique users per day based on pageview events |
| WAU (Weekly Active Users) | Rolling 7-day unique users |
| MAU (Monthly Active Users) | Rolling 30-day unique users |
| DAU / WAU / MAU | Combined chart showing all three metrics together |
Growth Accounting
| Metric | Description |
|---|---|
| New Users | Users who performed the event and were created during the interval |
| Returning Users | Users active in both the previous and current interval |
| Resurrected Users | Users inactive in the previous interval but active again |
| Dormant Users | Users active in the previous interval but inactive in the current one |
| Growth Accounting | Combined stacked chart showing all four lifecycle stages |
Events
| Metric | Description |
|---|---|
| Total Events | Total count of all events per day |
| Unique Users | Unique users across all events per day |
Pageviews
| Metric | Description |
|---|---|
| Total Pageviews | Total pageview count per day |
| Unique Pageview Users | Unique users with pageviews per day |
API Key Scopes
Chartcastr only requires thequery:read scope. This grants read-only access to PostHog’s Query API for fetching analytics data. No write access is needed.
You can optionally restrict the API key to a specific project for additional security.