21 Data Analysis AI Prompts for Solopreneurs

## Role
You are an expert digital marketing analyst specializing in Google Analytics implementation and website tracking strategy.

## Task
Create a comprehensive, step-by-step guide to implement Google Analytics for a business website. The guide must enable tracking of website traffic, analysis of user behavior, and measurement of conversions. Write for solopreneurs with varying technical backgrounds, ensuring clarity at every step.

## Context
Business context: {{business-context}}
(Include: business name, website URL, primary conversion goal, target audience, and your level of technical expertise)

## Output
Deliver the guide as a numbered list with clear section headings. For each implementation step, provide:
- Concise instructions
- Detailed explanations of what the step accomplishes
- Tips and best practices for optimization
- Any prerequisites or common pitfalls to avoid

Structu

## Role
You are an expert in Microsoft Excel, providing clear, accurate instructions for tasks including pivot tables, formulas, data formatting, and charts.

## Task
Provide a comprehensive step-by-step guide to complete the specified Excel task described by the user.

## Instructions

1. **Define the task**: Clearly restate the specific Excel task or problem to be solved.

2. **Prerequisites**: Outline the initial setup required:
   - Required data structure or range
   - Any preliminary formatting needed
   - Relevant Excel version considerations or settings

3. **Step-by-step walkthrough**: Detail each action required:
   - Which tab, menu, or function to access
   - Exact formulas or data to enter, with explanations of each component and its purpose
   - Parameters or options to configure, explaining what each choice affects
   - How to verify results for accuracy

4. **Best practic

## Role

You are a product development strategist analyzing customer feedback to prioritize improvements.

## Task

Review customer feedback, categorize common themes and pain points, analyze their frequency and impact, then produce a prioritized list of actionable steps to enhance the product experience for solopreneurs.

## Context

**Product & Audience:**  
{{product-and-audience}}  
(Include product name, target audience, and key current features)

**Business Context:**  
{{business-context}}  
(Describe business goals and available resources—budget, team, timeline, technical capacity)

**Customer Feedback:**  
{{customer-feedback}}  
(Paste raw feedback, survey responses, support tickets, reviews, or interview notes)

## Method

1. Identify and group recurring themes and pain points from the feedback  
2. Assess each issue by frequency (how many customers mention it) and impact (sev

## Role
You are an expert financial analyst specializing in expense reporting and analysis.

## Task
Generate a comprehensive expense report for {{time-period}} that accurately categorizes and totals all expenditures. Organize the data chronologically, verify categorization accuracy, and provide clear subtotals and grand totals.

## Context
- Expense categories: {{expense-categories}}
- Currency: {{currency}}
- Report purpose: {{reporting-purpose}}

## Output
Present the expense report as:

1. **Main Table** (markdown format with 4 columns):
   - Date
   - Expense Category
   - Description
   - Amount
   
   List all expenses in chronological order with correct categorization.

2. **Summary Section**:
   - Subtotal for each expense category
   - Grand total of all expenses

Ensure amounts align properly and calculations are accurate.

## Role

You are an expert data automation specialist designing an AI-powered assistant for data management.

## Task

Create a comprehensive system to automate data entry, analysis, and reporting tasks. Work through each component methodically to deliver a production-ready automation solution.

## Context

**Spreadsheet application:** {{spreadsheet-application}}

**Business and data environment:** {{business-context}}
(Include: type of business, key data sources, primary reporting needs, and data update frequency)

## Process

### Data Entry
- Analyze the current data entry workflow and identify automation opportunities
- Design a system for automated data input with built-in validation rules
- Implement error checking and data quality assurance measures
- Establish a user-friendly interface for data interaction and oversight

### Analysis
- Develop algorithms tailored to the business-s

## Role

You are a Google Analytics expert specializing in event tracking setup and analysis.

## Task

Create a comprehensive, step-by-step guide to set up event tracking on {{website-url}} for monitoring user interactions including downloads, video plays, and link clicks.

## Context

The user needs to implement event tracking to understand how visitors interact with their website content. The guide should be accessible to users with limited Google Analytics experience, using clear language without excessive technical jargon.

## Output

Provide a numbered, sequential guide covering: accessing Google Analytics, navigating to Events configuration, creating custom events for downloads/video plays/link clicks, implementing the tracking code or tag, testing in real-time reports, and verifying data collection.

For each step, write concise, actionable instructions and indicate where a scree