7b94537670
- Add Apollo Client for Saleor GraphQL API - Create GraphQL fragments (Product, Variant, Checkout) - Create GraphQL queries (Products, Checkout) - Create GraphQL mutations (Checkout operations) - Add TypeScript types for Saleor entities - Add product helper functions - Install @apollo/client and graphql dependencies Part of WordPress/WooCommerce → Saleor migration
305 lines
6.0 KiB
Markdown
305 lines
6.0 KiB
Markdown
# Email Reactivation Campaign Strategy
|
|
## Post-Migration Marketing Plan
|
|
|
|
### Customer Segments (4,886 Total)
|
|
|
|
| Segment | Count | Definition | Strategy |
|
|
|---------|-------|------------|----------|
|
|
| **VIP_CUSTOMER** | ~200 | 3+ completed orders | Loyalty rewards, early access, referral program |
|
|
| **ACTIVE_CUSTOMER** | ~972 | 1-2 completed orders | Cross-sell, subscription, reviews |
|
|
| **CART_ABANDONER** | ~1,086 | Pending/processing orders | Recovery sequence, discount incentive |
|
|
| **PROSPECT** | ~2,628 | Registered, never ordered | Welcome series, education, first-order discount |
|
|
|
|
---
|
|
|
|
## Campaign 1: Cart Abandoner Recovery
|
|
|
|
**Target:** 1,086 users with pending/processing orders
|
|
|
|
### Email Sequence
|
|
|
|
#### Email 1: Immediate (0 hours)
|
|
```
|
|
Subject: Zaboravili ste nešto u korpi 👀
|
|
|
|
Pozdrav [First Name],
|
|
|
|
Primijetili smo da ste ostavili artikle u korpi za kupovinu:
|
|
|
|
[Product Name] - [Price] RSD
|
|
|
|
Poštarina je BESPLATNA za narudžbine preko 3.000 RSD.
|
|
|
|
[DOVRŠI KUPOVINU]
|
|
|
|
Pitanja? Odgovorite na ovaj email.
|
|
|
|
---
|
|
Team Manoon
|
|
```
|
|
|
|
#### Email 2: 24 hours
|
|
```
|
|
Subject: Još uvijek čekamo vas 🛒
|
|
|
|
[First Name],
|
|
|
|
Vaša korpa još uvijek čeka:
|
|
|
|
[Product Image]
|
|
[Product Name]
|
|
|
|
Ostalo je još samo par komada na zalihi.
|
|
|
|
[DOVRŠI KUPOVINU]
|
|
```
|
|
|
|
#### Email 3: 72 hours (Final)
|
|
```
|
|
Subject: Posebna ponuda samo za vas 🎁
|
|
|
|
[First Name],
|
|
|
|
Vidimo da ste zainteresovani za naše proizvode.
|
|
|
|
Koristite kod ZAVRSI10 za 10% popusta na vašu narudžbinu.
|
|
|
|
Važi naredna 24 sata.
|
|
|
|
[DOVRŠI KUPOVINU]
|
|
```
|
|
|
|
---
|
|
|
|
## Campaign 2: Prospect Activation
|
|
|
|
**Target:** 2,628 registered users who never ordered
|
|
|
|
### Email Sequence
|
|
|
|
#### Email 1: Welcome (Day 0)
|
|
```
|
|
Subject: Dobrodošli u Manoon porodicu ✨
|
|
|
|
Zdravo [First Name],
|
|
|
|
Hvala što ste se prijavili! Očekuje vas:
|
|
|
|
✓ 100% prirodna kozmetika
|
|
✓ Vidljivi rezultati za 30 dana
|
|
✓ Besplatna dostava preko 3.000 RSD
|
|
|
|
Kao dobrodošlicu, imate 15% popusta na prvu kupovinu.
|
|
|
|
Kod: DOBRODOSLI15
|
|
|
|
[PREGLEDAJ PROIZVODE]
|
|
|
|
---
|
|
Team Manoon
|
|
```
|
|
|
|
#### Email 2: Education (Day 3)
|
|
```
|
|
Subject: Kako izgleda 30-dnevna transformacija?
|
|
|
|
[First Name],
|
|
|
|
Pogledajte neverovatne rezultate naših kupaca:
|
|
|
|
[Before/After Image Gallery]
|
|
|
|
💬 "Nakon 3 nedelje primetila sam ogromnu razliku"
|
|
- Marija, Beograd
|
|
|
|
[POGLEDAJ PRIČE]
|
|
```
|
|
|
|
#### Email 3: Social Proof (Day 7)
|
|
```
|
|
Subject: Više od 1.000 zadovoljnih kupaca
|
|
|
|
[First Name],
|
|
|
|
Naši kupci vole:
|
|
|
|
⭐⭐⭐⭐⭐ "Najbolji serum koji sam koristio"
|
|
⭐⭐⭐⭐⭐ "Kosa mi je znatno jača"
|
|
⭐⭐⭐⭐⭐ "Konačno prirodni proizvodi koji rade"
|
|
|
|
[ČITAJ UTISKE]
|
|
```
|
|
|
|
#### Email 4: Urgency (Day 14)
|
|
```
|
|
Subject: Poslednja prilika: 15% popusta
|
|
|
|
[First Name],
|
|
|
|
Vaš kod DOBRODOSLI15 ističe za 48 sati.
|
|
|
|
Ne propustite priliku da isprobate našu prirodnu kozmetiku sa popustom.
|
|
|
|
[ISKORISTI POPUST]
|
|
```
|
|
|
|
---
|
|
|
|
## Campaign 3: Win-Back (Inactive Customers)
|
|
|
|
**Target:** Active customers who haven't ordered in 6+ months
|
|
|
|
### Email Sequence
|
|
|
|
#### Email 1: "We Miss You" (Day 0)
|
|
```
|
|
Subject: Nedostajete nam, [First Name] 💚
|
|
|
|
Zdravo [First Name],
|
|
|
|
Primijetili smo da dugo niste naručivali.
|
|
|
|
Imamo novo za vas:
|
|
|
|
🆕 Novi proizvodi
|
|
🎁 Specijalne ponude
|
|
📦 Brža dostava
|
|
|
|
Želite da vidite šta je novo?
|
|
|
|
[VIDI NOVITETE]
|
|
```
|
|
|
|
#### Email 2: Incentive (Day 7)
|
|
```
|
|
Subject: Specijalna ponuda za povratak
|
|
|
|
[First Name],
|
|
|
|
Kao znak zahvalnosti za vašu raniju podršku:
|
|
|
|
20% popusta na sledeću kupovinu
|
|
|
|
Kod: POVRATAK20
|
|
|
|
Važi do: [Date]
|
|
|
|
[KUPI SADA]
|
|
```
|
|
|
|
---
|
|
|
|
## Campaign 4: VIP Customer Rewards
|
|
|
|
**Target:** 200 customers with 3+ orders
|
|
|
|
### Exclusive Perks
|
|
|
|
1. **Early Access** - New products 48 hours before public
|
|
2. **Birthday Gift** - Free product on birthday
|
|
3. **Referral Program** - Give 15%, Get 15%
|
|
4. **Exclusive Content** - Behind the scenes, beauty tips
|
|
|
|
#### Email Template
|
|
```
|
|
Subject: Vi ste naš VIP kupac 🌟
|
|
|
|
Draga [First Name],
|
|
|
|
Zahvaljujući vašoj podršci ([X] kupovina), postali ste deo našeg VIP kluba.
|
|
|
|
Vaše privilegije:
|
|
|
|
✨ Rani pristup novim proizvodima
|
|
🎁 Rođendanski poklon
|
|
💰 20% popust na SVAKU kupovinu
|
|
👥 Poklonite 15% prijateljima, zaradite 15%
|
|
|
|
[VIDI VIP PONUDE]
|
|
|
|
Hvala vam što ste deo Manoon priče.
|
|
|
|
---
|
|
Team Manoon
|
|
```
|
|
|
|
---
|
|
|
|
## Technical Implementation
|
|
|
|
### Saleor Setup for Segmentation
|
|
|
|
```python
|
|
# Add custom metadata to users during migration
|
|
metadata = {
|
|
"segment": "CART_ABANDONER", # or VIP_CUSTOMER, ACTIVE_CUSTOMER, PROSPECT
|
|
"wp_user_id": 12345,
|
|
"order_count": 2,
|
|
"completed_orders": 1,
|
|
"total_spent": 15000.00,
|
|
"first_order_date": "2023-01-15",
|
|
"registration_date": "2022-11-20"
|
|
}
|
|
```
|
|
|
|
### Integration Options
|
|
|
|
#### Option 1: Saleor Webhooks + n8n + MailerLite/Mailchimp
|
|
```
|
|
Saleor User Created → n8n → Add to Email List → Trigger Sequence
|
|
```
|
|
|
|
#### Option 2: Direct SQL Queries for Export
|
|
```sql
|
|
-- Export PROSPECTS for welcome campaign
|
|
SELECT email, first_name, metadata->>'registration_date' as date
|
|
FROM account_user
|
|
WHERE metadata->>'segment' = 'PROSPECT';
|
|
|
|
-- Export CART_ABANDONERS
|
|
SELECT email, first_name, metadata->>'order_count' as orders
|
|
FROM account_user
|
|
WHERE metadata->>'segment' = 'CART_ABANDONER';
|
|
```
|
|
|
|
#### Option 3: Mautic (already installed on your cluster)
|
|
- Import segmented lists
|
|
- Create campaigns per segment
|
|
- Track opens, clicks, conversions
|
|
|
|
---
|
|
|
|
## Campaign Calendar
|
|
|
|
| Week | Campaign | Target | Emails |
|
|
|------|----------|--------|--------|
|
|
| 1 | Cart Recovery | 1,086 abandoners | 3 emails |
|
|
| 2 | Prospect Welcome | 2,628 prospects | 4 emails |
|
|
| 3 | Win-Back | Inactive customers | 2 emails |
|
|
| 4 | VIP Launch | 200 VIPs | 1 email + setup |
|
|
| Ongoing | Nurture | All segments | Monthly newsletter |
|
|
|
|
---
|
|
|
|
## Success Metrics
|
|
|
|
| Metric | Target |
|
|
|--------|--------|
|
|
| Cart recovery rate | 10-15% |
|
|
| Prospect conversion | 5-8% |
|
|
| Win-back rate | 3-5% |
|
|
| VIP referral rate | 20% |
|
|
| Overall email open rate | >25% |
|
|
| Click-through rate | >3% |
|
|
|
|
---
|
|
|
|
## Next Steps
|
|
|
|
1. **Migrate data** using `migrate_all_users_and_orders.py`
|
|
2. **Set up email platform** (MailerLite, Mailchimp, or Mautic)
|
|
3. **Create email templates** in your chosen platform
|
|
4. **Import segmented lists** from Saleor
|
|
5. **Launch campaigns** in sequence
|
|
6. **Track results** and optimize
|