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

Calculating SMAC (Stage Monthly Active Clusters) is a valuable tool for businesses looking to gain insights into their customer base. By analyzing customer behavior and engagement, businesses can make informed decisions about marketing strategies, product development, and customer retention. In this article, we will explore what SMAC is, when it is valuable to calculate, and how to calculate it.

What Is SMAC (Stage Monthly Active Clusters)?

SMAC is a metric used to measure customer engagement and behavior. It is calculated by grouping customers into clusters based on their activity level and stage in the customer journey. The stages typically include prospect, lead, opportunity, and customer. The clusters are then analyzed to determine the percentage of customers in each stage who are actively engaged with the business on a monthly basis.

For example, if a business has 100 customers in the opportunity stage, and 80 of those customers have engaged with the business in the past month, the SMAC for that cluster would be 80%. This information can be used to identify areas where customer engagement is low and to develop strategies to improve engagement.

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

SMAC is valuable for businesses of all sizes and industries. It can be particularly useful for businesses with a large customer base or those that operate in highly competitive markets. By understanding customer behavior and engagement, businesses can make informed decisions about marketing strategies, product development, and customer retention.

SMAC can also be used to identify areas where customer engagement is low and to develop strategies to improve engagement. For example, if a business has a low SMAC for customers in the lead stage, they may need to improve their lead generation strategies or offer more targeted marketing campaigns to increase engagement.

How to Calculate SMAC (Stage Monthly Active Clusters)

Calculating SMAC requires data on customer activity and stage in the customer journey. This data can be obtained from a variety of sources, including customer relationship management (CRM) software, marketing automation tools, and website analytics.

To calculate SMAC, follow these steps:

1. Group customers into clusters based on their stage in the customer journey (prospect, lead, opportunity, customer).
2. Determine the number of customers in each cluster.
3. Determine the number of customers in each cluster who have engaged with the business in the past month.
4. Calculate the percentage of customers in each cluster who have engaged with the business in the past month.
5. Analyze the results to identify areas where customer engagement is low and to develop strategies to improve engagement.

By following these steps, businesses can gain valuable insights into customer behavior and engagement, and use this information to make informed decisions about marketing strategies, product development, and customer retention.

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

FinancialForce 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 FinancialForce 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 FinancialForce, 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 FinancialForce 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 FinancialForce 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.