Stripe: list customers who canceled in the past 30 days

See at a glance all the customers who canceled their subscription recently

All use cases
HubSpot
SQL
Airtable
Salesforce
Pipedrive
Intercom
Stripe

The process

Try It for Yourself

What do I get out of it?

Understand and reduce your churn.

‍

How does it work?

In the subscriptions Stripe table, you have a column "Status" that will tell you if a subscription is canceled or active. You also have a column "Canceled at (UTC)" that will tell you when the subscription was canceled.


  1. Import the Subscriptions table. See how to import your data in Actiondesk here.
  2. Add a calculated column called "Canceled in past 30 days" with the following formula: =IF(#canceled at (UTC)="", "No", IF(TODAY()-#canceled at (UTC)‍
  3. Then you just have to filter on records where the column "Canceled in past 30 days" is "true".


You now have a dynamic list of the subscriptions canceled, and you can try to action on them. Maybe try to understand why these customers canceled or offer them a discount to get them back.

What do I get out of it?

Understand and reduce your churn.

‍

How does it work?

In the subscriptions Stripe table, you have a column "Status" that will tell you if a subscription is canceled or active. You also have a column "Canceled at (UTC)" that will tell you when the subscription was canceled.


  1. Import the Subscriptions table. See how to import your data in Actiondesk here.
  2. Add a calculated column called "Canceled in past 30 days" with the following formula: =IF(#canceled at (UTC)="", "No", IF(TODAY()-#canceled at (UTC)‍
  3. Then you just have to filter on records where the column "Canceled in past 30 days" is "true".


You now have a dynamic list of the subscriptions canceled, and you can try to action on them. Maybe try to understand why these customers canceled or offer them a discount to get them back.

Read more
Create My First Report
see all Stripe use cases
The Advantages

Key Benefits

Eliminate the need for expensive third-party connectors and laborious copy-pasting.

Seamlessly import, organize, filter, and manipulate your Stripe data. Analyze it alongside data from other sources, and build custom Stripe dashboards and reports.

View and organize your Stripe data within a familiar spreadsheet interface.

Seamlessly import, organize, filter, and manipulate your Stripe data. Analyze it alongside data from other sources, and build custom Stripe dashboards and reports.

Feel confident in knowing that your data is always accurate and up-to-date.

Thanks to real-time cloud-based updates, any changes to your data made from within Stripe are automatically reflected in your Actiondesk spreadsheet.

Save time to analyze your data and make better decisions for your business
Create My First Report
Learn More

Our Use Cases

Stripe: list customers whose free trial is expiring in the next 3 days

See at a glance all the customers whose free trial is about to end

Create this report with my data →

Stripe: calculate your number of active subscriptions by plan

Live dashboard with the number of subscriptions by plan

Create this report with my data →

Stripe: get a MRR or ARR summary

Always know what you current MRR is

Create this report with my data →

Stripe: list delinquent customers

See at a glance all the customers who haven't paid their last invoice.

Create this report with my data →

Stripe: list customers who canceled in the past 30 days

See at a glance all the customers who canceled their subscription recently

Create this report with my data →
Create My First Report
X
Please wait...
Oops! Something went wrong while submitting the form.