How To Calculate SMAC (Stage Monthly Active Clusters) in Deltek Ajera | Arithmix

Calculating SMAC (Stage Monthly Active Clusters) is a valuable tool for businesses looking to track their progress and growth over time. By analyzing the number of active clusters within a given time period, businesses can gain insight into their customer base and identify areas for improvement. In this article, we'll explore what SMAC is, when it's valuable to calculate, and how to calculate it.

What Is SMAC (Stage Monthly Active Clusters)?

SMAC refers to the number of active clusters within a given time period. A cluster is a group of customers who share similar characteristics, such as demographics or purchasing behavior. By tracking the number of active clusters over time, businesses can gain insight into their customer base and identify trends and patterns.

For example, a business may notice that the number of active clusters is decreasing over time. This could indicate that customers are becoming less engaged with the business, or that the business is failing to attract new customers. On the other hand, an increase in the number of active clusters could indicate that the business is successfully attracting new customers and retaining existing ones.

When Is It Valuable To Calculate SMAC (Stage Monthly Active Clusters)?

Calculating SMAC is valuable for businesses in a variety of industries. For example, an e-commerce business may use SMAC to track the number of active customers on their website, while a software company may use SMAC to track the number of active users on their platform.

SMAC is particularly valuable for businesses that rely on recurring revenue, such as subscription-based services. By tracking the number of active clusters over time, businesses can identify trends in customer behavior and make data-driven decisions to improve customer retention and increase revenue.

How to Calculate SMAC

Calculating SMAC is a relatively simple process. To calculate SMAC, follow these steps:

1. Determine the time period you want to analyze (e.g. one month).
2. Identify the clusters you want to track (e.g. customers who have made a purchase in the past month).
3. Count the number of active clusters within the time period.
4. Divide the number of active clusters by the total number of clusters to get the SMAC percentage.

For example, if a business has 1,000 customers and 500 of them made a purchase in the past month, the SMAC percentage would be 50%.

By regularly calculating SMAC, businesses can gain valuable insights into their customer base and make data-driven decisions to improve customer retention and increase revenue.

How Do You Calculate SMAC (Stage Monthly Active Clusters) in Deltek Ajera

Deltek Ajera itself isn�t naturally geared towards letting you calculate complex metrics like SMAC (Stage Monthly Active Clusters). As an alternative, teams typically use products like Arithmix to import data from Deltek Ajera and build out dashboards.

What is Arithmix?

Arithmix is the next generation spreadsheet - a collaborative, web-based platform for working with numbers that�s powerful yet easy to use. With Arithmix you can import data from systems like Deltek Ajera, combine it with data from other systems, and create calculations like SMAC (Stage Monthly Active Clusters).

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 SMAC (Stage Monthly Active Clusters) in Arithmix

Calculating metrics like SMAC (Stage Monthly Active Clusters) is simple in Arithmix. Once you've created your free account, you�ll be able to import your Deltek Ajera data, and use it to create natural language formulas for metrics like SMAC (Stage Monthly Active Clusters).

Arithmix is designed to give you the power to build any calculations you want on top of your Deltek Ajera 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.