Render's Stripe SQL Insights app: cancelled subscriptions?

1

I’m using Render’s Stripe app that exports Stripe data to a Render postgres database: Stripe App Marketplace

It’s pretty cool! However, it looks like it only syncs data about active and past_due subscriptions:

stripe_22o9=> select distinct status from stripe_subscriptions;
  status  
----------
 past_due
 active
(2 rows)

Is it possible to configure it to also include cancelled subscriptions? I’d like to run analysis on churn rates, and join the Stripe data to our own line-of-business data to look for patterns in users who are likely to churn vs users who are likely to retain.

2

To clarify - it only syncs subscription data about active and past_due subscriptions. Data about cancelled subscriptions is still visible in the customers, charges and invoices tables.

3

Thanks for raising this. This is definitely a bug. I just took a look and I think I see where the issue is. I’ve made a ticket and will keep you posted when we have a fix out.

1 Like
4

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.