# How To Calculate GMAU in Hive | Arithmix

Learn how to calculate GMAU (Gross Monthly Active Users) in Hive with this comprehensive guide. Discover the steps and formulas needed to accurately measure user engagement and track the success of your Hive platform.

Calculating GMAU in Hive is a simple process that can help you measure the effectiveness of your online community. In this article, we will explain what GMAU is, when it is valuable to calculate it, and how to calculate it in Hive.

## What Is GMAU?

GMAU stands for "Gross Monthly Active Users." It is a metric used to measure the number of unique users who have interacted with your online community within a given month. This metric is particularly useful for online businesses and communities that rely on user engagement to drive growth and revenue.

By tracking GMAU, you can get a better understanding of how many people are actively engaging with your community and how that number changes over time. This information can help you make data-driven decisions about how to improve your community and increase user engagement.

## When Is It Valuable To Calculate GMAU?

Calculating GMAU is valuable for any online community that wants to track user engagement and growth. This metric is particularly useful for businesses and communities that rely on user engagement to drive revenue, such as social media platforms, online marketplaces, and gaming communities.

If you are running an online community, tracking GMAU can help you identify trends in user engagement and identify areas where you need to improve. For example, if you notice a decline in GMAU over time, it may be a sign that your community is losing momentum and needs a boost to keep users engaged.

## How to Calculate GMAU in Hive

Calculating GMAU in Hive is a straightforward process. Here are the steps:

2. Select the date range you want to analyze. For example, you may want to look at the past month or quarter.
3. Look for the "Gross Monthly Active Users" metric. This will show you the number of unique users who have interacted with your community within the selected date range.
4. You can also view a graph of GMAU over time to see how it has changed over the selected date range.

By following these simple steps, you can easily calculate GMAU in Hive and use this metric to track user engagement and growth in your online community.

## Conclusion

Calculating GMAU is a valuable tool for any online community that wants to track user engagement and growth. By measuring this metric in Hive, you can get a better understanding of how many people are actively engaging with your community and how that number changes over time. This information can help you make data-driven decisions about how to improve your community and increase user engagement.

## How Do You Calculate GMAU in Hive

Hive itself isn’t naturally geared towards letting you calculate complex metrics like GMAU. As an alternative, teams typically use products like Arithmix to import data from Hive 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 Hive, combine it with data from other systems, and create calculations like GMAU.

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.