Automated Revel Underperforming Location Watchlist
Every Monday, WebRun opens Revel Systems, reviews the prior week's net sales and transaction counts for every location, and updates an Airtable watchlist that tracks any site missing its revenue or traffic target for two or more consecutive weeks, so your ops team has a living document of which locations need intervention.
How do I automatically track which of my POS locations are consistently underperforming?
WebRun checks Revel Systems sales and transaction data for every location each Monday. Locations that miss revenue or traffic targets for two or more consecutive weeks are added or updated in an Airtable watchlist, giving your ops team a live view of which stores need intervention and how long they have been underperforming.
- Chronic underperformers identified after two consecutive misses, not quarters later
- Ops team has a single Airtable view of every at-risk location with history
- Recovered locations automatically resolved so the watchlist stays clean and current
Built for multi-location restaurant operators · retail chain directors · franchise managers · area 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 - read prior-week net sales and transaction counts by location
revelsystems.com
WebRun opens Revel Systems to read prior-week net sales and transaction counts by location. - Open the Revel Management Console and pull prior-week net sales and transaction count for all locations
- Compare each location against its weekly revenue and traffic targets
- Identify locations that missed targets this week
- Cross-reference with the existing watchlist to determine if this is a second or subsequent consecutive miss
Done when Every location's target performance status for the week is determined.
-
2
Airtable - update underperforming location watchlist with latest data
airtable.com
WebRun opens Airtable to update underperforming location watchlist with latest data. - Open the underperforming locations watchlist base
- Add newly flagged locations as new records with location name, miss count, and this week's variance
- Update existing records with the latest week's data and increment the consecutive-miss counter
- Mark any location that returned to target this week as resolved with the date
Done when Airtable watchlist reflects current status for every location, including new entrants and resolved sites.
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
How many consecutive misses trigger a watchlist entry?
A location is added to the watchlist after missing its target for two consecutive weeks. You can adjust this threshold so one bad week does not generate a false alarm.
What happens when a location recovers?
WebRun marks the record as resolved with the recovery date and keeps it in the history. You can filter the watchlist to show only currently underperforming sites at any time.
Does it notify anyone when a location is added to the watchlist?
The watchlist updates automatically in Airtable, where your team can set Airtable's own notification rules. WebRun does not send external messages so you control who gets alerted and when.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.