Stripe is one of ChartMogul's supported billing systems. Connect your Stripe account with ChartMogul to quickly bring together all your customer and billing data into ChartMogul’s subscription analytics platform. Seeing all your billing data in one place allows you to perform deeper analysis on your subscription data so you can make informed decisions to grow your business.
Here's what we cover in this article:
- Adding a Stripe data source
- Connecting Stripe
- Importing historical data
- What you need to know
- Using CMRR with Stripe
Adding a Stripe data source
- Navigate to Data Platform.
- Click ADD A DATA SOURCE.
- Select Stripe.
- Enter a unique name and click Next.
Select the environment of the data you would like to import in ChartMogul. You will also be provided an option to include deleted Stripe customers in the data that will be imported to ChartMogul.
Once you have set the environment and whether to include or exclude the deleted customers for import, click Connect with Stripe. To know more about the import deleted customers option, please read this article.
You will be redirected to your Stripe account.
If you are not logged in to your Stripe account, you will need to sign in using the credentials for the account you would like to sync to ChartMogul. If you are already signed in, after authorizing ChartMogul to have read-only access to your data you will be redirected back to ChartMogul.
Importing historical data
Include deleted customers in Stripe
If this option is enabled, we will include the deleted customers in Stripe during the import. If a customer in ChartMogul is deleted in Stripe, we will cancel all of the customer’s active subscriptions and remove any personal information such as name, company, email, and address.
On the other hand, if this option is disabled, we will skip any deleted customers in Stripe during import. Also, ChartMogul will delete the customer if it has been deleted in Stripe.
Invoiced customer handling
With Stripe it's possible to send open invoices to your customers. In ChartMogul, the Invoiced customer handling setting enables you to control when to consider a subscription active in order for it to contribute to your MRR.
This setting has the following options:
- Classify invoiced customers as active the moment their first invoice is opened. But if their invoice fails to be paid then exclude them. (default)
- Invoiced customers will be reported active when a subscription invoice for an amount above $0.00 is opened. If the invoice enters a past due or failed state the invoice will be reported failed and if the customer does not have a successful subscription invoice, their subscription will be removed.
- Only include invoiced customers when they have at least one successfully paid/closed invoice.
- Invoiced customers will be reported active when a subscription invoice for an amount above $0.00 is successfully closed (i.e. paid).
- Classify invoiced customers as active the moment their first invoice is opened.
- Invoiced customers will be reported active when a subscription invoice for an amount above $0.00 is opened. If the invoice enters a past due or failed state, the invoice will NOT be reported failed; and if this customer does not have a successful subscription invoice, their subscription will NOT be removed.
Initiating the import
After configuring the above settings click on Import Data.
A progress bar will appear displaying the amount of time remaining until your import is complete. Once the import has been completed, your ChartMogul dashboard will automatically update when there are activities in your Stripe account.
If you alter one of the settings in your data source or a data setting requiring a re-sync, you will need to re-import your data to make the behavior consistent historically and going forward. You can do so by clicking on Re-sync data.
What you need to know
- If you are using Stripe’s multi-plan subscriptions, learn more here.
- To import your test data into ChartMogul, select Test data as the environment. Once you have selected the environment and started the import, you cannot change it. If you need to import your data from a different environment, you will need to create a new data source.
- If you're using the latest version of our Stripe integration, ChartMogul imports customers when they are created in Stripe. If you're using previous versions, ChartMogul imports customers when they have a trial or invoice in Stripe.
- ChartMogul automatically imports customer metadata as custom attributes.
- ChartMogul allows you to import deleted customers in Stripe. Learn more.
- No payment method is required to create a subscription with a trial period. An immediate invoice is created for $0. Learn more about using trial periods on subscriptions.
- ChartMogul uses Stripe’s Events API to retrieve trial-related customer data. Stripe doesn’t allow events older than 30 days to be retrieved anymore. Because of this, ChartMogul can only map trial dates that happened 30 days before the date of the initial import.
- ChartMogul limits the number of imported invoices to 2000 per customer.
Using CMRR with Stripe
Committed Monthly Recurring Revenue (CMRR) is a projection of MRR into the future. It’s calculated using subscription events, which Stripe imports automatically. Learn more about CMRR.
Here’s what you need to know about using CMRR with Stripe:
- CMRR is only available with the latest version of ChartMogul’s Stripe integration. To check if you’re using the latest version, navigate to Data Platform > Data Sources and select your Stripe data source. If you’re able to view a series of tables with customer and invoice data, you’re using the latest version. If you’re only able to view a setup screen, you’re using a previous version. Contact support to migrate your account to the latest version.
- For each subscription, ChartMogul only reports the next scheduled subscription event when viewing CMRR. For example, on May 27, a customer signs up for a subscription that begins on June 1 and will be upgraded on June 15. From May 27 to May 31, only the Start (Scheduled) event will be reported. On June 1, when the Start (Scheduled) event becomes New Business, the Update (Scheduled) event dated for June 15 will be reported.