Powerworks Connected Garage — Full MVP

ROLE: Data Ops Assistant
GOAL: Clean and map Powerworks CSV to CRM fields.
INPUTS: CSV with columns [Name, Email, Phone, Vehicle, Mileage, Branch, LastServiceDate, ServiceType].
TASKS:
1) Normalise phone to +971 format; split first/last names.
2) Validate emails; flag bounce risks.
3) Standardise ServiceType to {Minor, Major, AC, Other}.
4) Derive 'ServiceDueDate' = max(LastServiceDate+180d, Mileage+10,000km heuristic if available).
5) Output clean CSV and a mapping table: {SourceField -> CRMField}.
RETURN: Clean CSV + mapping in Markdown table.

Create Smart List rule sets for:
- "Due in 30 days": ServiceDueDate between today and +30d.
- "Abandoned Estimate": Last Quote Sent ≥ 3 days AND Stage=Quote Sent AND No Booking.
- "High-Value Repeat": Last 12m spend ≥ AED 3,000 OR ≥ 2 visits.
Return JSON: [{"name":"Due in 30 days","rules":[...]}...]

Generate workflow scaffolds for each stage transition:
- Trigger: Stage changes to "Quote Sent"
  Actions: Send email with estimate link; wait 48h; if not moved to Booked → send WhatsApp nudge; create follow-up task.
- Trigger: Stage changes to "Completed"
  Actions: Send review+referral request; if review received → tag "PW:Review:Google".
Return YAML actions with merge fields {{contact.first_name}}, {{contact.custom.vehicle_model}}, {{opportunity.amount}}

Draft a concise "Thank You + Next Steps" email (UK English). Variables:
{{contact.first_name}}, {{contact.custom.vehicle_model}}, {{location.name}}, {{contact.custom.preferred_branch}}.
Tone: professional, reassuring. Include 1 CTA button: "Book inspection". 120–150 words.

Write a post-service WhatsApp (≤500 chars) asking for a Google review and offering a 15% referral perk.
Include placeholders: {{google_review_link}}, {{referral_form_link}}, {{contact.first_name}}.

Create a friendly welcome email (120–160 words) with:
- Who we are (Powerworks, British-owned, Al Quoz & DIP)
- What to expect at next visit
- Link buttons: "WhatsApp Us", "Service Guide"
Variables: {{contact.first_name}}, {{location.name}}, {{custom_values.whatsapp}}

Provide 3-step reminder copy set:
R1 (email, 90–120w), R2 (WhatsApp, ≤350 chars), R3 (voicemail script, 60–80w).
Tone: proactive, helpful; include {{contact.custom.vehicle_model}} and branch selector link.

Generate JSON spec for a Service Booking form with validation rules (phone E.164, mileage numeric).
Include field → CRM mapping and success actions: create opportunity, send email, add to Smart List "Due in 30 days".

Write microcopy for an estimate approval page: headline, 2-line explainer, consent text, and submit success message. UK English.

Produce a headline & subhead set for each funnel:
- AC Service Offer
- Annual Service
- Brakes & Suspension
Format: 3 options per page. Keep to 8–12 words per headline, 12–20 words per subhead.

Create a slot schedule JSON for:
- Branches: Al Quoz, DIP
- Ramps: 1..5
- Days: Mon–Sat, 4 slots/day, service durations as defined, 15m buffers.
Also output pseudo-logic to auto-assign ramp with least load at booking time.

Write: Meta title (≤60 ch), Meta description (140–155 ch), Intro paragraph (60–90w), and 5 FAQs for a UAE garage with two branches, British-owned, focusing on AC, servicing, brakes/suspension. Include both branch names. UK English.

Provide SQL-like metric definitions for:
- Conversion% = Completed / New Enquiry (rolling 30d)
- Ramp Utilisation% = BookedSlotMinutes / TotalAvailableMinutes
- Referral Ratio = (New from Referral) / (All New)
Also create alert rules (YAML) when conversion dips < 18% or any ramp utilisation > 85% for 3 consecutive days.

Create 3 micro-SOPs (≤8 steps each):
A) Raising an estimate and sending the approval link
B) Moving a job between ramps without breaking buffers
C) Logging a phone enquiry and triggering the quote flow
Add 60–90s talk tracks for Loom recordings.

Build a monthly test matrix:
- Hypotheses for 3 weakest funnel steps
- Variant copy (email subject ≤44 chars; WhatsApp ≤250 chars)
- Success metrics & guardrails
Return as a Markdown table ready for Google Sheets.