If you run a business with multiple locations, totals only tell part of the story. The real questions tend to be location specific.

Which location is driving the most redemptions.
Which rewards are trending in one market but not another.
Which locations might need help promoting a program.
How fulfillment volume is shifting month to month.

This is especially true for multi location retailers and franchises, where local results can vary from store to store.

That is why we released the Transaction quantities by location report. It gives you a simple location by location view of how many times specific perks were earned or redeemed over a time period, with a separate column for each perk you select. It is useful for gyms and fitness studios, and it also applies to salons, spas, and retail brands that run loyalty, referrals, or other customer loyalty programs.

You can read the documentation here: https://docs.perkville.com/features/reports/transaction-quantities-by-location?utm_source=chatgpt.com

What the report shows

This report maps the locations you select to the perks you select, so you can see how each perk performs at each location.

You will see:
• Location name and your location ID for each location
• One column per selected perk, where the value is the total quantity earned or redeemed at that location

Filters you can use

The report includes filters that help you answer very specific questions without needing to export raw transactions first.

Common filters include:
• Transaction date range, based on when the transaction happened in your source system
• Last modified date range, for when transactions were last modified
• Locations and location groups, which is helpful for franchises and regional operators
• Earn perks and redeem perks, including inactive perks, and different redemption types
• Status, such as active or voided

Practical use cases across verticals

Below are ways operators and marketing teams use this report across gyms and studios, salons and spas, and retail and franchise environments.

1. Prepare for a reward program revamp

This one comes up a lot. A business is about to refresh their rewards catalog, and they expect a rush on the current rewards before the change goes live.

To prepare, they want to know how many of each type of reward was redeemed at each location over the past year.

How to run it:
• Set the transaction date range to the last 12 months
• Select your locations or location groups
• Under redeem perks, select the rewards you are retiring or changing
• Export the CSV and review redemption quantities per location

What it helps you do:
• Forecast inventory needs for physical rewards
• Plan staffing if certain redemptions require manual fulfillment
• Identify locations that may need extra communication about the upcoming change
• Avoid last minute surprises if a few locations historically see much higher redemption volume

This use case shows up in multiple verticals:
• Fitness: branded merchandise, smoothies, guest passes
• Salon and spa: product redemptions, service add ons, retail items at checkout
• Retail and franchises: promo items, gift cards and high demand items

2. Benchmark perk adoption across locations

When you launch a new reward, referral offer, or limited time perk, this report quickly shows which locations are driving activity for that specific perk.

For franchises and multi location retailers, this is one of the most practical ways to validate campaign success. You can see whether the campaign is being promoted consistently, and which locations may need help.

How teams use this:
• Identify top performing locations and document what they did
• Coach or support locations with lower adoption
• Validate whether a program rollout was consistent across regions

3. Spot under promoted rewards

Sometimes a perk is good, but staff are not mentioning it consistently, signage is missing, or the offer is buried in a menu.

If the same perk is earned or redeemed heavily at some locations and barely at others, that is a strong signal that execution is uneven. In franchise environments, this can also highlight differences in training, staffing, or local manager focus.

Examples:
• A spa location that consistently mentions a special perk at checkout
• A retail store that trains associates to bring up rewards on every transaction
• A fitness studio that highlights rewards in class and on digital screens

4. Evaluate campaign lift by location

Run the report for a campaign window, then compare it to a prior period using the same perks and locations.

This helps answer questions like:
• Did this campaign work everywhere or only in a few markets
• Which locations need a different offer or messaging
• Which perks created the most lift during the campaign

If you want line item detail behind the totals, pair this report with the Transaction detail report so you can drill into individual transactions.

5. Optimize your reward mix for each market

Not every market responds the same way. Some locations may prefer experiential rewards, while others lean toward discounts or retail items.

For multi location retail and franchises, this can help you balance brand consistency with local relevance. You can keep a standard national set of perks, then add a few location or region specific options based on what performs.

Use this report to:
• Decide which perks to feature per region
• Retire or refresh perks that consistently underperform everywhere
• Build location specific merchandising or service scripts

This is especially helpful for salon and spa brands where service preferences can vary by neighborhood, and for retailers where product assortment differs by store.

6. Forecast reward cost and operational load

Redemption volume drives cost and staffing, especially for physical or high touch rewards.

Use this report to:
• Anticipate fulfillment volume per location
• Inform budgeting based on what customers actually redeem
• Plan ahead for seasonal spikes

Retail example: planning staffing and inventory for a holiday redemption push.
Spa example: planning appointment availability for a popular add on reward.
Fitness example: planning stock for merchandise rewards.

7. Audit anomalies faster

When numbers look off, this report can help you isolate the issue quickly.

Ways teams use it:
• Look for unexpected spikes or drops in a specific perk by location
• Filter by status to include or exclude voided activity
• Narrow down to a small set of perks and locations for investigation

Then, if needed, use transaction level reporting to confirm the underlying transactions.

How to run the report

Go to Reports
Select Transaction quantities by location
Choose your filters and date range
Click Run Report to export a CSV

Related resources

Here are a few related posts that pair well with this report:
• New feature: Transaction detail report
https://info.perkville.com/blog/new-feature-transaction-detail-report

• New report: Points by customer
https://info.perkville.com/blog/points-by-customer-report

• New report: Challenge overview by home location
https://info.perkville.com/blog/new-report-challenge-overview-by-home-location

‍