Add stripe as a revenue source
Contents
When using revenue analytics, you can connect Stripe to PostHog as a source of revenue data. Revenue analytics will automatically use the data from Stripe to build your revenue dashboard.
If you already have a Stripe-connected source, you can access the revenue analytics settings page and turn on the Stripe toggle to connect to your Stripe data.
The Stripe connector can link charges, customers, invoices, prices, products, subscriptions, and balance transactions to PostHog.
Creating a Stripe API key
You need a Stripe API key to create a connector. Head to your Stripe dashboard > Developers > API keys, under Restricted keys, click + Create a restricted key.
You need to give your API key the following Read permissions in the Permissions column:
| Resource Type | Required Read Permissions |
|---|---|
| Core | Balance transaction sources, Charges, Customers, Disputes, Payouts, Products |
| Billing | Credit notes, Invoices, Prices, Subscriptions |
| Connect | Application Fees, Transfers (Or click Read in the Connect header) |
If you aren't concerned with giving us more permissions than necessary, you can also simply click Read on the Core, Billing, and Connect headers to give us the necessary permissions.
If your Stripe account is in a language other than English, we suggest you update it to English before following the steps above to guarantee the correct permissions are set.
Adding a data source
- In PostHog, go to the Data pipeline page select the Sources tab.
- Click + New source button and select Stripe by clicking the Link button.
- In Stripe, get your Account ID by going to Settings > Business, selecting the Account details tab, and clicking your Account ID or pressing
⌘+Ito copy your ID. - Get your API key from the previous section
- Optional: Add a prefix to your table names
- Click Next
For Stripe tables, incremental syncs will only sync new records and not update existing records. This is a limitation of the Stripe API in which it's not possible to query for updated data.
The data warehouse then starts syncing your Stripe data. You can see details and progress in the data pipeline sources tab.
How is the data stored?
Your data will be imported and transformed into a set of managed views. Revenue analytics will use these views to build your revenue dashboard automatically.
You can also use these views in the SQL editor to run custom queries and visualize the data.
Deferred revenue
PostHog will automatically defer revenue recognition to match your accounting practices. This means we spread the revenue across all the months a charge is relevant for. You can read more about this on the deferred revenue page.
Connect to customers
You can link your Stripe customers to your persons and groups in PostHog. This helps you identify your top customers and see how much revenue they're generating.
You can learn more about this on the connect to customers page.