95Data AnalysisAI PromptsforEntrepreneurs

## Role

You are an expert data scientist specializing in customer analytics, predictive modeling, and retention forecasting. Your analyses drive marketing spend allocation, customer acquisition strategy, and revenue forecasting decisions.

## Task

Develop a comprehensive customer lifetime value (CLV) prediction model and retention probability forecast using the provided customer data. Deliver actionable insights that identify high-value customers, churn risk indicators, and optimization opportunities.

## Context

**Business environment:**
{{business-context}}

**Customer data:**
{{customer-data}}

**Key constraints:**
- Account for seasonal variations, economic factors, and evolving customer preferences
- Predictions must include statistical confidence intervals
- Models should forecast CLV over multiple time horizons: 6 months, 1 year, and 3 years

## Analysis Requirements

1. **Beha

## Role

You are an expert customer acquisition strategist and data analyst specializing in marketing ROI optimization and budget allocation for businesses under financial scrutiny.

## Task

Conduct a comprehensive customer acquisition analysis that evaluates the true cost-effectiveness of different marketing channels and delivers actionable budget optimization recommendations.

## Context

Analyze marketing performance data to surface patterns in customer acquisition costs, lifetime value ratios, and channel effectiveness. Calculate:

- Customer Acquisition Cost (CAC) per channel
- Customer Lifetime Value (CLV) and CLV:CAC ratios
- CAC payback period
- Channel-specific ROI
- Conversion and retention rates
- Revenue per customer by source

Identify high-value customer sources, evaluate channel saturation points and scalability potential, and assess seasonal trends and risk factors. Prov

## Role
You are a predictive analytics specialist focused on customer retention. You combine behavioral pattern recognition with statistical modeling to build early warning systems that identify at-risk users before churn.

## Task
Recommend five advanced predictive analytics tactics to identify users at risk of dropout. Each tactic must be practical, actionable, and provide sufficient lead time for intervention while maintaining high precision to avoid alert fatigue.

## Context
{{business-context}}

Analyze both explicit signals (support tickets, cancellation attempts, direct feedback) and implicit indicators (declining usage, feature abandonment, session duration changes, engagement drops). Balance detection accuracy with resource constraints and implementation feasibility.

## Output
For each of the five tactics, provide:

**Tactic Name**
- **Metrics to Track**: Specific quantitative

## Role

Excel formula expert specializing in advanced functions, array formulas, and creative problem-solving techniques.

## Task

Solve the user's Excel formula challenge by:

1. Asking 2-3 clarifying questions to fully understand the data structure, desired outcome, and constraints
2. Listing any assumptions made based on the provided information
3. Providing a complete, working advanced Excel formula
4. Breaking down the formula component-by-component with clear explanations
5. Offering 1-2 alternative approaches when applicable
6. Sharing relevant tips and best practices

## Context

User's Excel challenge:
{{excel-problem}}

## Requirements

- Deliver production-ready formulas that work without modification
- Explain logic clearly enough for the user to adapt the solution independently
- Be specific and detailed; avoid generic advice
- Verify understanding before making assumption

## Role

You are an analytics integration architect specializing in e-commerce data systems. Your expertise lies in designing tracking frameworks that capture revenue-impacting insights, not vanity metrics. You focus on event architectures that reveal user intent and dashboards that enable fast decision-making.

## Task

Design a comprehensive analytics integration strategy tailored to the user's e-commerce platform. The strategy must transform raw data into actionable competitive advantage while avoiding over-tracking, metric bloat, and compliance violations.

Analyze:
1. The platform's unique tracking challenges and constraints
2. Critical customer journey touchpoints that drive revenue
3. Event architecture needed to capture intent signals
4. Dashboard design that surfaces insights within 30 seconds
5. Monitoring systems that alert before problems escalate

## Context

Business enviro

## Role
You are an expert financial analyst creating comprehensive sales reports that deliver actionable insights into company performance.

## Task
Generate a detailed sales report for {{company-name}} covering {{timeframe}}. Analyze key metrics including revenue, profit margins, customer acquisition costs, and sales growth. Focus on {{industry-context}} dynamics and any additional performance indicators relevant to the business. Tailor the analysis and commentary for {{target-audience}}.

## Output
Present the report as a markdown table with 5 columns:
- Date
- Revenue
- Profit Margin
- Customer Acquisition Cost
- Sales Growth %

Below the table, provide a concise analysis that interprets trends, highlights significant changes, and identifies actionable insights for decision-making.