How To Calculate Paid Stage Monthly Active Users in HubSpot | Arithmix

Calculating Paid Stage Monthly Active Users (PSMAU) is an important metric for businesses that offer subscription-based services. This metric helps businesses understand the number of users who are actively using their paid services on a monthly basis. In this article, we will discuss what PSMAU is, when it is valuable to calculate it, and how to calculate it.

What Is Paid Stage Monthly Active Users?

Paid Stage Monthly Active Users (PSMAU) is a metric that measures the number of users who are actively using a paid service on a monthly basis. This metric is important for businesses that offer subscription-based services because it helps them understand the number of users who are paying for and using their services. PSMAU is calculated by counting the number of unique users who have used the paid service at least once during the month.

PSMAU is different from Monthly Active Users (MAU), which measures the number of users who have used a service, whether it is paid or free, at least once during the month. PSMAU only measures the number of users who have used the paid service, while MAU measures the total number of users who have used the service.

When Is It Valuable To Calculate Paid Stage Monthly Active Users?

Calculating PSMAU is valuable for businesses that offer subscription-based services because it helps them understand the number of users who are actively using their paid services. This metric can help businesses identify trends in user behavior and make informed decisions about their pricing and marketing strategies.

PSMAU can also help businesses identify potential churn risks. If the number of PSMAU is decreasing over time, it may be an indication that users are not finding value in the paid service and may be considering canceling their subscription. By monitoring PSMAU, businesses can take proactive measures to retain their users and improve their service.

How to Calculate Paid Stage Monthly Active Users

Calculating PSMAU is a simple process. To calculate PSMAU, you need to count the number of unique users who have used the paid service at least once during the month. Here are the steps to calculate PSMAU:

1. Identify the paid service that you want to measure PSMAU for.
2. Determine the time period that you want to measure PSMAU for (usually a month).
3. Count the number of unique users who have used the paid service at least once during the time period.
4. Divide the total number of unique users by the total number of days in the time period to get the average PSMAU for the month.

For example, if you want to calculate PSMAU for a paid email service for the month of January, you would count the number of unique users who have used the service at least once during January. Let's say there were 500 unique users who used the service at least once during January. January has 31 days, so the average PSMAU for January would be 16 (500/31).

By calculating PSMAU on a regular basis, businesses can monitor the usage of their paid services and make informed decisions about their pricing and marketing strategies.

How Do You Calculate Paid Stage Monthly Active Users in HubSpot

HubSpot itself isn't naturally geared towards letting you calculate complex metrics like Paid Stage Monthly Active Users. As an alternative, teams typically use products like Arithmix to import data from HubSpot and build out dashboards.

What is Arithmix?

Arithmix is the next generation spreadsheet - a collaborative, web-based platform for working with numbers you'll powerful yet easy to use. With Arithmix you can import data from systems like HubSpot, combine it with data from other systems, and create calculations like Paid Stage Monthly Active Users.

In Arithmix, data is organized into Tables and referenced by name, not by cell location like a spreadsheet, simplifying calculation creation. Data and calculations can be shared with others and re-used like building blocks, vastly streamlining analysis, model building, and reporting in a highly scalable and easy to maintain platform. Data can be edited, categorized (by dimensions) and freely pivoted. Calculations are automatically copied across a dimension - eliminating copy and paste of formulas.

Arithmix is fully collaborative, giving your entire team access to your numbers and the ability to work together seamlessly.

Calculating Paid Stage Monthly Active Users in Arithmix

Calculating metrics like Paid Stage Monthly Active Users is simple in Arithmix. Once you've created your free account, you'll be able to import your HubSpot data, and use it to create natural language formulas for metrics like Paid Stage Monthly Active Users.

Arithmix is designed to give you the power to build any calculations you want on top of your HubSpot data, while also being easy to use and collaborate on. You can share your dashboards with users inside and outside of your organisation, making it easy to empower your whole team.