Campaign opportunity and personal winback offer

Hey there! 👋 Ready when you are.

I'm your restaurant chain UAE copilot — I can help you with:

- Menu & content — items, prices, modifiers, 86ing, media, CMS banners - Orders — inspect, advance, or cancel an order - Loyalty — points, tiers, member coupons, spin prizes, challenges, streaks - Marketing — segments, promotions, coupon codes, campaigns, reviews, winback - Kiosk — attract loop, tiles, upsell messaging, kiosk availability - Analytics — sales, best/worst sellers, funnel, "why did X change"

What can I get started for you?

I'd love to help, but I want to make sure I point you the right way — the phrasing is a little ambiguous. Could you clarify what kind of "gap" you're looking for a campaign to fill? A few possibilities:

1. Customer gaps — e.g. lapsed/at-risk customers, or segments with no active campaign or promotion targeting them (a marketing/segment question). 2. Sales gaps — underperforming branches, categories, or items that a campaign could boost (an analytics question). 3. Coverage gaps — days, channels, or branches where you currently have no campaign or promotion running.

Tell me which angle you mean (or give me a bit more detail), and I'll pull the data and route it to the right specialist — Insights for the analysis and/or Marketing for building the campaign.

I'll look at customer gaps — segments or customer groups that a campaign could target but currently aren't being reached. Let me pull the landscape first.The Insights specialist hit a session error, but I can run the recency breakdown directly. Let me check the schema and pull the numbers.SQLite — I need to adjust the date functions.Here's your customer gap, straight from the data (non-demo orders only).

The big finding

The overwhelming gap isn't a *winback* problem — it's an activation problem.

- 625 customers (99.2%) have never placed a non-demo order. They have accounts but zero purchase history. - Only 5 customers have ever ordered at all, and all 5 are now dormant (90+ days), worth AED 622.50 lifetime combined. - There are effectively no active customers to retain.

The addressable gap is first-order activation

625 registered customers have never ordered. A classic "winback" campaign has almost no audience here — the leverage is a first-order / welcome campaign to convert sign-ups into buyers, plus a small nudge for the 5 dormant customers.

Where a campaign applies

1. First-order activation (625 customers) — the main gap. A welcome offer + brand-wide coupon (e.g. first-order discount or free-item-with-minimum) to convert dormant sign-ups. This is a segment → campaign build.

2. Micro-winback (5 dormant customers) — small but worth a cheap nudge, ideally a loyalty points-bonus or personal coupon since they've spent before.

Want me to build it?

Tell me the offer and I'll route it: - "Build a first-order segment + welcome campaign" → I'll hand the segment and campaign to the Marketing specialist (and set up a coupon code if you want one). - "Give the 5 dormant customers a winback coupon / points bonus" → routed to Loyalty or Marketing.

Which one do you want to move on?

I'll set up the micro-winback for the 5 dormant customers. Let me pull their details first so we target the right accounts.Here are your 5 dormant customers (90+ days since last order, but they've all purchased before):

Customer profile links: [redacted].

A couple of these look like test accounts ("Customer A", "Customer D", "Customer E") — worth knowing before we spend an offer on them.

Pick the winback mechanism

Before I route this, tell me which approach you want:

A. Loyalty points bonus → routed to the Loyalty specialist - e.g. "Give each of these 5 a bonus of X points" (a come-back reward, no cash discount).

B. Personal winback coupon → Loyalty (per-member coupons) or Marketing (brand-wide code) - e.g. "20% off your next order" or "AED 15 off orders over AED 60".

Just give me: 1. The mechanism (points bonus / coupon) 2. The value (how many points, or the discount amount/percent) 3. Whether to include the test-looking accounts or just the 2 real ones (Customer B, Customer C)

...and I'll delegate it and report back what got created.

Good choice. Quick decision before I hand it off: a 20% off next order coupon can be issued as personal coupons to just these 5 members via Loyalty, which is the tighter fit for a targeted winback (each member gets their own code, no public leakage).

One thing to confirm: who's included? Three of the five look like test accounts:

- ✅ Customer B — real (4 orders, AED 151) - ✅ Customer C — likely real (2 orders, AED 94) - ⚠️ Customer A, Customer D, Customer E — look like test/fixture accounts

Do you want me to: - All 5, or - Just the 2 real customers (Customer B + Customer C)?

Also — any cap or expiry? A winback coupon usually wants a short fuse. My suggestion: 20% off next order, no minimum, expires in 14 days. Tell me if you'd rather cap the discount (e.g. max AED 20) or set a different window.

Reply with who to include and I'll route it to the Loyalty specialist and report back the coupon(s) created.