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

The process

Try It for Yourself

What do I get out of it?

Improve your conversion from free trial to paying customer.

How does it work?

In the subscriptions Stripe table, you have a column "Status" that will tell you if a subscription is cancelled, active, trial, etc. You also have a column "trial end (UTC)" that will tell you when is the end of the trial for customers who are in the status "trial".


  1. Import the Subscriptions table. See how to import your data in Actiondesk here.
  2. Add a calculated column called "Trial expires in 1-3 days" with the following formula: =IF(AND(#trial end (UTC)-TODAY()>0,#trial end (UTC)-TODAY()
  3. Then you just have to filter on records where the column "Trial expires within 3 days" is true.

That's it, you now have a dynamic list of the subscriptions about to end their trial, and you can try to action on them!

What do I get out of it?

Improve your conversion from free trial to paying customer.

How does it work?

In the subscriptions Stripe table, you have a column "Status" that will tell you if a subscription is cancelled, active, trial, etc. You also have a column "trial end (UTC)" that will tell you when is the end of the trial for customers who are in the status "trial".


  1. Import the Subscriptions table. See how to import your data in Actiondesk here.
  2. Add a calculated column called "Trial expires in 1-3 days" with the following formula: =IF(AND(#trial end (UTC)-TODAY()>0,#trial end (UTC)-TODAY()
  3. Then you just have to filter on records where the column "Trial expires within 3 days" is true.

That's it, you now have a dynamic list of the subscriptions about to end their trial, and you can try to action on them!

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

Create My First Report
X
Please wait...
Oops! Something went wrong while submitting the form.