Rank every location by weekly performance automatically
Every Monday, WebRun opens Revel Systems, collects the prior week's net sales, transaction count, average ticket, and labor cost for every location, calculates a composite performance score, and writes the ranked table into your Google Sheet so you can act on it before the new week gets going.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically rank all my POS locations by weekly performance?
WebRun opens Revel Systems every Monday, collects the prior week's net sales, average ticket, and labor percentage for every location, calculates a composite performance score, and writes the ranked results into Google Sheets. Operators get a ready-to-act scorecard in minutes, with no manual data pull required.
- Weekly performance ranking ready in Google Sheets every Monday morning
- Top and bottom performers identified without a single manual report
- Historical week-over-week trends captured automatically in one sheet
Built for multi-location restaurant operators · retail chain managers · franchise owners · district managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
my.revelsystems.comin a real browser with your saved login - no setup, no API keys. -
1
Revel Systems - collect weekly KPIs by location
revelsystems.com How to Automate Revel Systems
WebRun opens Revel Systems to collect weekly KPIs by location. - Open the Revel Management Console and go to Reporting
- Set the date range to the prior full week for all locations
- Collect net sales, transaction count, average ticket, and labor percentage for each location
- Calculate a composite score weighting sales volume and average ticket
Done when Every location has its weekly KPIs and composite score ready.
-
2
Google Sheets - write ranked performance table
google.com How to Automate Google Sheets
WebRun opens Google Sheets to write ranked performance table. - Open the designated performance tracking sheet
- Append a new weekly row for each location in ranked order
- Apply conditional formatting so the top and bottom performers are color-coded
Done when This week's ranked performance table is written into Google Sheets.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
What metrics make up the composite score?
Net sales volume and average ticket are weighted equally by default. You can ask WebRun to add labor percentage or transaction count to the formula to match your priorities.
Does it overwrite old data or keep a history?
It appends each week as a new set of rows so you build a running history automatically. Previous weeks are never overwritten.
Can it alert me if a location drops in rank week over week?
Yes. Pair it with a Slack notification step and WebRun will flag any location that falls more than two positions compared with last week's ranking.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.