Customer Lifecycle Email Analysis AI Prompt

Analyze the effectiveness of lifecycle email sequences and identify gaps in the program.

Lifecycle data: {{lifecycle_data}} (email type, trigger event, send date, open, click, conversion)
Customer journey stages: {{stages}} (onboarding, activation, engagement, expansion, retention, win-back)

1. Lifecycle email inventory:
   Map every automated email to the customer journey stage:
   - Trigger: what event sends this email?
   - Goal: what action should the recipient take?
   - Metric: how is success measured?

2. Coverage gaps:
   - Which stages have no automated email coverage?
   - Are there high-value moments in the customer journey with no triggered email?
   - Common gaps: post-onboarding engagement, pre-renewal reminder, post-cancellation win-back

3. Sequence performance:
   For each lifecycle sequence:
   - Open rate by email position (Email 1, 2, 3...): how quickly does engagement decay?
   - Click rate by position
   - Completion rate: what % of recipients receive all emails in the sequence?
   - Conversion rate: what % take the desired action?

4. Time-to-convert analysis:
   - From lifecycle email send to conversion: how long does it take?
   - Is there an optimal timing window? (Some emails may be sent too early or too late)

5. Optimization opportunities:
   - Sequences with lowest conversion rate: content or timing issue?
   - High open but low click sequences: strong subject line but weak email body
   - Low open sequences: timing, subject line, or sender name issue

6. Recommended additions:
   Based on the gap analysis, propose 3 new lifecycle automations:
   - Trigger event
   - Goal
   - Message approach
   - Expected impact on activation/retention/revenue metric

Return: lifecycle email inventory, coverage gap analysis, sequence performance table, and 3 recommended new automations.