Stripe: calculate your number of active subscriptions by plan

Live dashboard with the number of subscriptions by plan

The process

Try It for Yourself

Calculate your number of active subscriptions by plan with your Stripe data

What do I get out of it?

Understand the breakdown of your paying customers

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.

  1. Import the Subscriptions table in a sheet called "Stripe subscriptions". See how to import your data in Actiondesk here.
  2. Now, create a new sheet called "Subscriptions by plan"
  3. In "Stripe subscriptions", right click on the column "status" and choose "copy unique". In "Subscriptions by plan", paste the list of your unique statuses in B3.
  4. In "Stripe subscriptions", right click on the column "plan" and choose "copy unique". In "Subscriptions by plan", paste the list of your unique statuses in C2, D2 and E2.
  5. In C3, write the following formula: =COUNTIFS(Stripe data!#status,$B3,Stripe data!#plan,C$2) and copy paste this formula to the right and downward.


Et voilà! You now have a simple live dashboard giving you the number of active subscriptions by plan.

You could go further and calculate the revenue by plan, in $ and as a percentage of your total revenue.

Calculate your number of active subscriptions by plan with your Stripe data

What do I get out of it?

Understand the breakdown of your paying customers

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.

  1. Import the Subscriptions table in a sheet called "Stripe subscriptions". See how to import your data in Actiondesk here.
  2. Now, create a new sheet called "Subscriptions by plan"
  3. In "Stripe subscriptions", right click on the column "status" and choose "copy unique". In "Subscriptions by plan", paste the list of your unique statuses in B3.
  4. In "Stripe subscriptions", right click on the column "plan" and choose "copy unique". In "Subscriptions by plan", paste the list of your unique statuses in C2, D2 and E2.
  5. In C3, write the following formula: =COUNTIFS(Stripe data!#status,$B3,Stripe data!#plan,C$2) and copy paste this formula to the right and downward.


Et voilà! You now have a simple live dashboard giving you the number of active subscriptions by plan.

You could go further and calculate the revenue by plan, in $ and as a percentage of your total revenue.

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.