Automated Cantaloupe Planogram Performance Report
Every Monday, WebRun opens Cantaloupe Seed Pro, pulls the prior week's sales by product slot across your machine fleet, compares each slot's sales rate to your targets, and writes a planogram performance report to Google Sheets showing your top performers, underperformers, and slot swap recommendations.
How do I automatically track which vending machine planogram slots are underperforming?
WebRun pulls prior week sales by product slot from Cantaloupe Seed Pro every Monday and writes a planogram performance report to Google Sheets. You see which slots are top earners and which are dead weight, with a fleet-wide underperformer list so your team can prioritize product swaps where they will have the biggest revenue impact.
- Underperforming slots are identified weekly instead of during quarterly reviews
- Product swap decisions are backed by actual sales data from Cantaloupe
- Fleet-wide planogram improvements compound into higher revenue per machine
Built for vending operators · category managers · route managers · convenience service operators
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
www.cantaloupe.com/products/software/seed-proin a real browser with your saved login - no setup, no API keys. -
1
Cantaloupe - pull slot-level sales and planogram data
cantaloupe.com
WebRun opens Cantaloupe to pull slot-level sales and planogram data. - Open Cantaloupe Seed Pro and navigate to the planogram or product sales report
- Pull prior week sales by product and slot for each machine
- Calculate units sold and revenue per slot
- Identify slots with sales below your minimum threshold and flag them as candidates for a swap
Done when Every machine's slot performance for the prior week is captured with sales figures.
-
2
Google Sheets - write planogram performance report
google.com
WebRun opens Google Sheets to write planogram performance report. - Open the planogram performance Google Sheet
- Write slot-level sales data ranked from best to worst performing for each machine
- Add a summary tab listing the top 10 underperforming slots across the entire fleet for prioritized action
Done when Google Sheets has this week's planogram scorecard with fleet-wide underperformer list.
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
Does it automatically update planograms in Cantaloupe?
No. WebRun reports on slot performance so your team can make informed product swap decisions. Planogram changes are made by your team in Cantaloupe after reviewing the report.
Can it compare performance across different machine types or locations?
Yes. The Google Sheet can be filtered by machine type, route, or location. Configure WebRun to tag each row with the relevant attributes when writing the report.
What data does it use to measure a slot's performance?
It uses units sold and revenue per slot from Cantaloupe's product sales data for the prior week. Slots with fewer than a full week of data (e.g. newly restocked products) are labeled accordingly.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.