SpotOn Loyalty Win-Back Campaign Automation
Every Monday, WebRun opens SpotOn's loyalty dashboard, finds members who have not visited in 60 or more days, segments them by lifetime spend, logs the list in Google Sheets, and drafts a personalized win-back email campaign in Mailchimp for each tier, ready for your review and approval before anyone receives a message.
How do I automatically identify and reach lapsed SpotOn loyalty members?
WebRun opens SpotOn loyalty data every Monday, finds members who have not visited in 60 or more days, and segments them by lifetime spend in Google Sheets. It then drafts a tailored win-back email campaign per tier in Mailchimp, held for your review and approval, so no message reaches a guest before a manager signs off.
- Lapsed loyalty members identified every week before they become permanent lost customers
- Tiered offers mean high-value guests get premium treatment without blanket discounts
- Win-back list tracked in Google Sheets to measure campaign performance over time
Built for restaurant owners · bar and hospitality operators · retail loyalty program managers · multi-location food service brands
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
spoton.comin a real browser with your saved login - no setup, no API keys. -
1
SpotOn - identify lapsed loyalty members by last-visit date
spoton.com
WebRun opens SpotOn to identify lapsed loyalty members by last-visit date. - Open SpotOn loyalty and marketing reports and filter members by last visit date
- Identify members whose last visit was 60 or more days ago
- Capture name, email, phone, lifetime spend, visit frequency, and favorite item category for each
Done when All lapsed loyalty members are identified with their spend and visit history.
-
2
Google Sheets - log and segment members by spend tier
google.com
WebRun opens Google Sheets to log and segment members by spend tier. - Open the loyalty win-back tracker and append the new lapsed members list with this week's date
- Segment members into tiers: high-value (lifetime spend over $500), mid-tier ($100 to $500), and new lapsed (under $100)
- Flag any member who has been lapsed for more than 180 days as at-risk of permanent churn
Done when Lapsed members are logged and segmented by spend tier in Google Sheets.
-
3
Mailchimp - draft win-back campaign per tier for review
mailchimp.com
WebRun opens Mailchimp to draft win-back campaign per tier for review. - Create a draft email campaign in Mailchimp for each spend tier with a personalized subject line and offer
- High-value draft: a premium offer such as a complimentary appetizer or bonus points
- Mid-tier and new lapsed drafts: a percentage discount or double-points event invitation
- Leave all campaigns in draft status for manager review. Do not schedule or send without approval
Done when One Mailchimp campaign draft per tier is ready for manager review and scheduling.
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
Will it send win-back emails to guests without my approval?
No. Every win-back campaign is saved as a draft in Mailchimp. A manager must review the content and click send or schedule before any email reaches a guest.
How does it segment lapsed members into tiers?
It uses lifetime spend from SpotOn loyalty data: high-value members spent over $500, mid-tier members between $100 and $500, and new lapsed members under $100. You can adjust these thresholds in your workflow settings.
What if a lapsed member visits before the campaign goes out?
Run the workflow after the campaign is approved but before you schedule it: it re-checks SpotOn visit data and removes anyone who has returned since the initial pull, so you avoid awkward win-back emails to recent guests.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.