# How To Calculate WAU in Sage | Arithmix

Learn how to calculate Weekly Active Users (WAU) in Sage with our step-by-step guide. Improve your data analysis skills and make informed business decisions. Start calculating WAU today!

Calculating WAU (Weekly Active Users) is an important metric for businesses that want to track the engagement of their users. It helps you understand how many unique users are interacting with your product or service on a weekly basis. In this article, we'll explain what WAU is, when it's valuable to calculate it, and how to calculate it in Sage.

## What Is WAU?

WAU stands for Weekly Active Users. It's a metric that measures the number of unique users who have engaged with your product or service within a week. This includes users who have logged in, made a purchase, or performed any other action that indicates they are actively using your product or service.

WAU is an important metric because it helps you understand how engaged your users are with your product or service. If your WAU is high, it means that your users are finding value in what you're offering and are returning to use it on a regular basis. If your WAU is low, it may indicate that your users are not finding value in your product or service and are not returning to use it.

## When Is It Valuable To Calculate WAU?

Calculating WAU is valuable for businesses that want to track user engagement over time. It's particularly useful for businesses that offer subscription-based services or products, as it helps them understand how many users are actively using their product or service on a regular basis.

WAU is also valuable for businesses that want to track the success of marketing campaigns or product updates. By comparing WAU before and after a campaign or update, businesses can see if there was an increase or decrease in user engagement.

## How to Calculate WAU in Sage

Calculating WAU in Sage is a simple process. First, you'll need to determine the time period you want to measure. For example, you may want to measure WAU for the past week.

Next, you'll need to determine the number of unique users who have engaged with your product or service during that time period. This can be done by looking at your user data and identifying the number of unique users who have logged in, made a purchase, or performed any other action that indicates they are actively using your product or service.

Once you have this number, you can calculate your WAU by dividing the number of unique users by the number of weeks in the time period you're measuring. For example, if you had 100 unique users engage with your product or service in the past week, your WAU would be 100 divided by 1 (since you're measuring for one week), which equals 100.

By regularly calculating your WAU in Sage, you can track the engagement of your users over time and make data-driven decisions to improve your product or service.

## How Do You Calculate WAU in Sage

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

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.