How To Calculate WAU in Sage | Arithmix

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.

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

Calculating WAU in Arithmix

Calculating metrics like WAU is simple in Arithmix. Once you've created your free account, you’ll be able to import your Sage data, and use it to create natural language formulas for metrics like WAU.

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