New Feature Alert! As of May 2024, you can now view the details of how attributed revenue is calculated for each class. Learn more in the Tracking Attributed Revenue details below!
There are more and more reports in Punchpass that have a column called 'Attributed Revenue' - this article explains what it is, how we calculate it, and how you should use it to help evaluate your classes and passes.
Attributed Revenue is revenue from your pass sales that we assign to a specific class. The goal is to give you a revenue figure for each individual class - that helps you answer questions like...
Which classes are most profitable?
Which days of the week (or time of day!) are most profitable?
Who can use this feature?
Access to the Reports section requires admin-level access to Punchpass.
β
How Attributed Revenue is Calculated
The way we do this is to calculate a 'per visit' amount for each visit on a pass. Every attendance is linked to a specific pass, so we can use the pass per-visit amount to assign a revenue figure to the attendance. Add all the attendances up for a class and voila! you have revenue attributed to that specific class.
There is one important thing to understand. Until a pass is actually full and/or expired we can only estimate the per-visit revenue. Let's look at the two different pass types for examples.
Punchcards
Punchcards are easier because they have a specific number of visits, so we can calculate a per-visit number right away. However, it is still important to understand that can change.
The Pass: 10 Visit Punchcard that expires after 2 months.
Cost: $80
Initial Per-Visit Cost: $8 ($80 / 10 visits)
When that pass is created we assign it a per-visit value of $8. And we will use that figure for calculating the class revenue for any class the pass is used for. At the end of 2 months, the pass expires and can no longer be used. Then we recalculate the per-visit revenue.
Actual Visits Used: 7 out of 10
Final Per Visit Revenue: $11.43 ($80 / 7 visits)
So while the figure did not change a lot, it DID change once the pass was finished.
Unlimited Passes
Unlimited passes are much harder. There is no initial way to calculate the per-visit revenue because they have, by definition, an unlimited number of visits. π
So in order to calculate per-visit revenue, we let the client tell us what the number should be! There is a spot in the settings (more info below) clients can use to tell us what figure we should use. If we don't have that information, we use $10.
The Pass: 1 Month Unlimited
Cost: $120
Initial Per-Visit Cost: $10 (we use the default)
That is the number we use until the pass expires - then we calculate the final 'correct' number.
Actual Visits: 5
Final Per-Visit Revenue: $24 ($120 / 5 visits)
As you can see, the per-visit revenue changed....quite a bit! If the customer had visited 8 times, it would have been $15, but if they had visited 15 times it would have been $8.
We will highlight attributed revenue where we can in the app to let you know that the figure may change.
Why show a number if we know it will change?
The Attributed Revenue figure is designed to help you make high-level decisions:
Are my morning classes more profitable than my afternoon?
Are my yoga classes more profitable than my pilates classes?
Which pass brings in the most revenue per visit?
It is NOT designed for something like payroll, since the revenue number may change over time until all the passes have been used. Another way to think of this - the number will continue to get better and better until all the passes have been used up or expired. Only at that point will the number truly be final.
β
How to Get Started
There is nothing you need to do, we calculate this figure automatically! However, you can customize some elements to align with your business.
β
Customize your Attributed Revenue Calculation
There are multiple options to modify the information displayed when calculating your business's attributed revenue.
Including No-Shows in Attributed Revenue Calculations
Navigate to Manage > Settings > Taxes, Invoices, and Revenue. Select the option to include no-shows for attributed revenue reports. Press Save.
β
Set a Value for Unlimited Memberships
As unlimited passes start and end on different days for different customers, we use an estimate to calculate your attributed revenue. This estimate only impacts data where unlimited passes are still active.
Navigate to Manage > Settings > Taxes, Invoices, and Revenue. Enter your best estimate for the price per class. Press Save.
This calculation is zero by default.
This setting will reflect the currency your business is using.
You can change this number!
When you see the β οΈ emoji, this calculation is using attributed revenue.
β
Please note the Attributed Revenue value you enter will also impact the calculations displayed in the Individual Class Details report and the Instructor Activities Report as well.
Tracking Attributed Revenue
You'll see attributed revenue used across Punchpass. If you see a warning symbol, this means that the attributed revenue calculation is estimated.
On each of the Class Details pages
For each class, towards the bottom, we show the Class Attributed Revenue calculation.
β
The Attributed Revenue Report
Clicking on the Attributed Revenue Breakdown opens a report detailing how this calculation was determined.