ROLE: You are a customer analytics specialist for e-commerce businesses.
TASK: Design a comprehensive cohort analysis framework for our e-commerce business that will help us understand:
- Customer lifetime value trends
- Retention patterns by acquisition channel
- Impact of first purchase category on future behaviour
- Effect of discounting on long-term value
- Seasonal patterns in customer reactivation
Include:
- Recommended cohort definitions
- Key metrics to track for each cohort
- Suggested analysis timeframes
- Visualisation approaches
- Common patterns to look for
- How to translate findings into marketing actions
BUSINESS CONTEXT:
{PRODUCT_CATEGORIES}
{CUSTOMER_ACQUISITION_CHANNELS}
{AVERAGE_PURCHASE_FREQUENCY}
{TYPICAL_CUSTOMER_LIFECYCLE}
{AVERAGE_CUSTOMER_LIFESPAN}
DATA AVAILABILITY:
{ORDER_HISTORY_FIELDS}
{CUSTOMER_PROFILE_DATA}
{MARKETING_TOUCHPOINT_DATA}
{TECHNICAL_LIMITATIONS}
Structure this as a strategic framework document with clear methodology and implementation steps.
You are a customer analytics specialist for e-commerce businesses. Design a comprehensive cohort analysis framework for our e-commerce business that will help us understand: - Customer lifetime value trends - Retention patterns by acquisition channel - Impact of first purchase category on future behaviour - Effect of discounting on long-term value - Seasonal patterns in customer reactivation Include: 1. Recommended cohort definitions 2. Key metrics to track for each cohort 3. Suggested analysis timeframes 4. Visualisation approaches 5. Common patterns to look for 6. How to translate findings into marketing actions BUSINESS CONTEXT: {PRODUCT_CATEGORIES} {CUSTOMER_ACQUISITION_CHANNELS} {AVERAGE_PURCHASE_FREQUENCY} {TYPICAL_CUSTOMER_LIFECYCLE} {AVERAGE_CUSTOMER_LIFESPAN} DATA AVAILABILITY: {ORDER_HISTORY_FIELDS} {CUSTOMER_PROFILE_DATA} {MARKETING_TOUCHPOINT_DATA} {TECHNICAL_LIMITATIONS} Structure this as a strategic framework document with clear methodology and implementation steps.Why it works: Creates a structured approach to understanding customer behaviour over time, enabling more targeted retention strategies.
