How to Measure Active Customers From Stripe Data [Tutorial]

Jun 2, 2023
How to track active customers

Among the things keeping startup CEOs up at night, there’s a particularly terrifying one: Not knowing the number of active users their company has.

Understanding the pulse of a business has become an art unto itself, but in the context of slow economic growth and rising interest rates, there’s no time to master it. 

You either solve the problem or assume the risk of leaving it unattended.

If you’re growing tired of vague approximations and endless number-crunching sessions, get a Make account and get ready. In this tutorial, we’ll show you how to measure active customers from Stripe data.

And in less than an hour, you’ll be looking at your very own automated system to measure active customers once and for all.

Ready to slam-dunk the real number whenever the question comes up? Then let’s not waste another minute!

Step 1: Create a Google Sheets spreadsheet

The first thing you’ll need to gather the data on a regular and automated basis is a Google spreadsheet. 

Your sheet must have columns for:

  • Date

  • Number of customers

  • Percentage Increase/Decrease from the previous month

As you can tell, this solution will also show you how many customers you’ve won or lost compared to the previous measurement. 

Step 2: Create a Make scenario and add the Stripe app

Next, log in to your Make account and navigate to the scenario builder to create a new scenario.

Measure active customers automation - 1

In the scenario builder (aka visual canvas), search for the Stripe app and select the Stripe - List All Customers module. 

Measure active customers automation - 2

Before configuring the module, you need to connect your Stripe account to Make by entering your Stripe API key

Then, increase the Limit to a high number, since this is the number of customers that the module will fetch each time the scenario executes.

Measure active customers automation - 3

This is all you need to do in order to configure this module. Once done, hit OK.

Step 3: Add the Google Sheets app to your scenario

Next, you need to add the Google Sheets app by clicking the Add another module button. 

Measure active customers automation - 4

You want to add the data to your recently created Google Sheets spreadsheet and to do this we’ll select the Google Sheets - Add a Row module.

Measure active customers automation - 5

As you probably realized, your Google account needs to be connected to Make to proceed. 

Click the Add button and follow the prompts.

Measure active customers automation - 6

After connecting Google to Make, choose the Select by path option. 

Then select the Google Drive where the spreadsheet is, and then the spreadsheet that you want to add the data to followed by the sheet itself. 

Measure active customers automation - 7

You’ll notice that the spreadsheet cells are now visible and ready to map. The first field is Date, you can change the format of the date as you see here by using the formatDate (located in the functions tab) and the now variable followed by the format you want (see screenshot below for reference). 

The Total number of bundles data item represents the total number of customers.

In the Number of customers field, simply map the Total number of bundles data item as shown in the image below. 

Measure active customers automation - 8

Once done, click OK.

Step 4: Add a filter between the first two modules

Since there will be many customers resulting in bundles of data (hopefully), this will result in every bundle of data being added to the sheet as new rows - but we just want the total on a single row.

The solution to this problem is to use a filter so that only one bundle passes through and one row of data is added to the sheet (as required).

Notice the link between the two modules? Click on it to open the filter menu. 

Measure active customers automation - 9

Since you want to allow one bundle of data to pass through, configure the filter as follows: 

  • Map the Bundle order position item to the top field

  • Select the Numeric operators: Equal to operator

  • Enter 1 in the bottom field so that only the first bundle passes through

Measure active customers automation - 10

Then, hit OK and move to the next step.

Step 5: Add the second Google Sheets module

The next step is to get the previous month’s total number of customers from column B so we can calculate the percentage increase/decrease in the subsequent module. 

Add the Google Sheets - Get a Row module to the scenario, select your spreadsheet (like you did before), and simply use the following formula to retrieve this information.

Measure active customers automation - 11

All good? Then hit OK to finish configuring this module.

Step 6: Add the third Google Sheets module

In this step, we’ll automatically calculate the percentage increase/decrease in the total number of users your company or product has.

To do this, add the Google Sheets - Update a Row module to your scenario. 

First, you need to map the Row Number from the Add a Row module to the Row number field. 

Measure active customers automation - 12

To calculate the percentage increase/decrease, use the following formula in the corresponding field.

{{sum(total number of bundles - value) / value * 100}}

Here’s what it looks like when entered into the module:

Measure active customers automation - 13

Ready? There’s one more module to configure and we’ll be done.

Step 7: Add the Slack module

The final step is to send a notification to the person or team that requires the information.

We’re using Slack to do this but Make supports multiple team communication platforms in case you need to change it (such as Microsoft Teams,

Back to the scenario. Add the Slack - Create a Message module and connect your Slack account to Make by choosing the option of User or Bot as the connection type.

Measure active customers automation - 14

Once you establish the connection with Make, configure it as follows:

  • Choose the Select from the List option

  • Select the Channel Type

  • Select the User/Channel that you want to send the notification to

Measure active customers automation - 15

Now you’ll have to write the message that will accompany the information (i.e. number of users plus percentage variation). 

Here’s a sample of the text used to compose the message. You can enter any details and map any data you want from other modules - and even send a link to the sheet itself if you want to!

Measure active customers automation - 16

Once ready, hit OK. It’s time to test this automated scenario and see if it works as intended.

Step 8: Test and activate the scenario

Let’s take a look at what the scenario execution looks like.

Measure active customers automation - 17 gif

Seeing it perform the task of retrieving the data as expected, you can now set the scenario to execute on a custom schedule. 

In this demo we want it to execute on the first day of every month, so we can count on fresh data and draw plans upon it. 

Measure active customers automation - 18

And lastly, save the scenario and switch it on.

Measure active customers automation - 19

And this is how you measure the number of active customers based on payment data from Stripe. 

Final thoughts: Business fundamentals using real-world data

If you looked closely, you might have noticed that this Make-powered automation solves more than the original problem of measuring the active customers your company has.

On top of providing this data, it does so in a way that’s easy to understand, requires minimal resources, and automatically communicates the results to the stakeholders that need to know.

It is in the simplicity where the beauty of the solution resides. 

You won’t have to hunt for developers, splurge on consultants, or wrap your head around complicated concepts.

All it takes is an hour of your time, a strong desire to know what the actual numbers look like, and a Make account!

senior-content-writer-saas

Martin Etchegaray

Content Manager and Senior Editor at Make. I enjoy writing and reading about history, science, and tech.

Like this use case? Spread the word.

Get monthly automation inspiration

Join 75,000+ Makers and get the freshest content delivered straight to your inbox.