# Project 2 — Customer Email Responder
# From Spreadsheets to AI Tools — Book 6, Waskey Press

WHAT YOU WILL BUILD:
A prompt template that generates personalised customer emails
based on order history from your sales data.

TEMPLATE — CUSTOMER RE-ENGAGEMENT EMAIL
─────────────────────────────────────────
You are a Sales Manager at a technology company.

Customer context:
Company: [CUSTOMER NAME]
Region: [REGION]
Order history summary:
  - Total orders in 2024: [N]
  - Total spend: €[X]
  - Most purchased product: [PRODUCT]
  - Last order date: [DATE]
  - Last order status: [STATUS]
  - Days since last order: [N]

Task:
Write a personalised re-engagement email.
Requirements:
- Subject line that references their most purchased product
- Opening that acknowledges the relationship (not generic)
- Body: 2 short paragraphs — one about their product, one with an offer
- Offer: 10% discount on [MOST PURCHASED PRODUCT] valid 30 days
- Closing: professional, first name sign-off
- Maximum 180 words (not counting subject line)
- Tone: warm and professional, not pushy

HOW TO USE THIS TEMPLATE:
1. Open sales.csv and filter to one customer
2. Compute the required fields (total orders, spend, last order, etc.)
3. Fill in the [BRACKETS] with real values
4. Paste the complete prompt into your AI tool
5. Review, personalise the opening, send
