Prompt lesson · 18 prompts
Data Analysis and Reporting prompts for Digital Marketing Managers
18 ready-to-use prompts from our AI for Digital Marketing Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Data Collection and Organization
Use this when you need to gather, categorize, and organize data from various sources to uncover insights for marketing or support.
Role — You are a research analyst skilled in data collection and organization. Your goal is to turn raw data from various sources into structured, actionable insights.
Context you provide
- {{data_sources}}: Specific sources to collect data from (e.g., social media, review platforms, chat logs, surveys).
- {{data_topic}}: The topic or theme to focus on (e.g., brand mentions, customer feedback, inquiries).
- {{organization_goal}}: How the organized data will be used (e.g., campaign insights, product improvement, support streamlining).
Instructions
- Ask for missing context before starting.
- Outline a systematic approach to collect data from the specified sources.
- Define categories for organizing the data based on the goal.
- Provide a framework for categorizing and structuring the collected data.
- Identify key themes or trends that emerge from the data and suggest how to visualize them.
Output format — Provide a structured data collection and organization plan, including categories, a categorization framework, and initial insights. Use bullet points and tables for clarity. Keep the tone practical and methodical.
Guardrails — Do not fabricate data; provide a plan for collection. Clearly state assumptions about data availability. Stay within the scope of the specified sources and topic.
Example — Data sources: Twitter, Trustpilot; Topic: brand sentiment; Goal: inform upcoming campaign.
Open this prompt Research · Beginner
Data Cleaning and Validation
Use this when you need to identify and correct errors, duplicates, or inconsistencies in your datasets to ensure reliable analysis.
Role — You are a data quality specialist. Your goal is to ensure datasets are accurate, consistent, and ready for reliable analysis.
Context you provide
- {{dataset}}: Description of the dataset (e.g., customer database, lead forms, sales data).
- {{data_issues}}: Known or suspected issues (e.g., duplicates, missing values, anomalies, formatting errors).
- {{data_goal}}: How the data will be used (e.g., marketing campaigns, reporting).
Instructions
- Ask for missing context before starting.
- Identify potential data quality issues based on the provided description.
- Provide a step-by-step plan to clean and validate the data, including specific checks for duplicates, missing values, and formatting.
- Suggest methods to make the cleaning process repeatable.
- Recommend best practices and tools for ongoing data quality monitoring.
Output format — Provide a clear, actionable data cleaning plan with specific steps, checks, and recommendations. Use bullet points and tables where helpful. Keep the tone technical but accessible.
Guardrails — Do not claim to have cleaned data you have not seen; provide a plan instead. Flag any assumptions about the data structure. Stay focused on data quality, not analysis.
Example — Dataset: Customer database with 10,000 records; Issues: suspected duplicates and missing emails; Goal: prepare for email campaign.
Open this prompt Automation · Intermediate
Customer Data Segmentation and Profiling
Use this when you need to segment customer data to tailor marketing strategies and improve campaign targeting.
Open this prompt Analysis · Intermediate
Marketing Performance Metrics Analysis
Use this when you need to analyze marketing performance metrics to identify strengths, weaknesses, and optimization opportunities.
Open this prompt Analysis · Intermediate
Identify Emerging Trends
Use this when you need to spot emerging patterns in customer interactions or market data to inform future strategies.
Open this prompt Analysis · Intermediate
Generate Insightful Reports
Use this when you need to turn raw data into a clear, actionable report with key insights and visualizations.
Open this prompt Analysis · Intermediate
Marketing Performance Dashboard Creation
Use this when you need to create a comprehensive performance dashboard to track key marketing metrics and gain insights.
Open this prompt Creating · Intermediate
Customer Segmentation for Targeting
Use this when you need to segment your customer base to tailor marketing strategies and improve personalization.
Open this prompt Analysis · Beginner
A/B Testing Analysis for Marketing
Use this when you need to analyze A/B test results to determine which marketing strategies are most effective.
Open this prompt Analysis · Intermediate
Campaign ROI Analysis
Use this when you need to calculate and analyze the return on investment for marketing campaigns to guide budget allocation.
Open this prompt Analysis · Intermediate
Listen to Social Conversations
Use this when you need to understand customer sentiment and key topics from social media to guide your marketing strategy.
Open this prompt Analysis · Intermediate
Website Traffic Analysis
Use this when you need to analyze website traffic data to uncover trends, user behaviors, and optimization opportunities.
Open this prompt Analysis · Intermediate
Email Marketing Performance Analysis
Use this when you need to analyze email campaign performance to optimize open rates, click-through rates, and conversions.
Open this prompt Analysis · Intermediate
Customer Lifetime Value Analysis
Use this when you need to calculate, segment, or predict customer lifetime value to inform retention and marketing strategies.
Open this prompt Analysis · Intermediate
Market Trend Analysis for Strategy
Use this when you need to analyze market trends to inform strategic marketing decisions and stay ahead of consumer preferences.
Open this prompt Research · Intermediate
Competitor Marketing Strategy Analysis
Use this when you need to systematically analyze competitors' digital marketing efforts to uncover strategic opportunities.
Open this prompt Analysis · Intermediate
Forecast Customer Behavior
Use this when you need to analyze historical data to predict future trends and inform strategic decisions.
Open this prompt Analysis · Intermediate
Automate Marketing Reports
Use this when you want to streamline recurring reporting by automating the aggregation and presentation of key metrics.
Open this prompt Automation · Advanced