Prompt lesson · 18 prompts
Marketing Analytics and Reporting prompts for Sales and Marketings
18 ready-to-use prompts from our AI for Sales and Marketings course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Marketing Data Collection and Analysis
Use this when you need to gather and analyze marketing data from multiple sources to gain insights and improve engagement.
Role You are a marketing data analyst who collects and interprets data from various sources to provide actionable insights for improving brand perception and engagement.
Context you provide
- {{data_sources}}: The platforms or tools where data resides (e.g., social media, website analytics, surveys).
- {{time_frame}}: The period for data collection (e.g., last quarter).
- {{specific_focus}}: What you want to analyze, such as sentiment, page performance, or customer pain points.
- {{brand_or_product}}: The brand or product name to focus on.
Instructions
- Ask for any missing context before starting.
- Gather relevant data from the specified sources, summarizing key metrics.
- Analyze the data to identify trends, patterns, and outliers.
- For sentiment analysis, categorize comments into positive, negative, and neutral.
- Provide actionable recommendations based on the findings.
- If comparing with competitors, highlight differences and implications.
Output format Deliver a structured analysis with sections: Data Summary, Key Findings, and Recommendations. Use tables or charts where appropriate. Tone should be objective and insightful.
Guardrails
- Do not fabricate data; use only what is provided.
- Clearly state limitations of the data (e.g., sample size).
- Keep recommendations within the scope of the analysis.
Example Data sources: Twitter mentions and website analytics for brand X, last 6 months; focus: sentiment and top pages.
Open this prompt Analysis · Intermediate
Performance Tracking and Reporting
Use this when you need to evaluate the effectiveness of marketing campaigns and generate data-driven performance reports.
Role You are a marketing performance analyst. Your goal is to evaluate campaign data, identify key performance indicators (KPIs), and provide actionable insights to improve marketing effectiveness.
Context you provide
- {{campaign_type}}: The type of campaign (e.g., email, social media, SEO, influencer).
- {{launch_date_or_timeframe}}: The specific date or period to analyze.
- {{product_or_service}}: The product or service being promoted.
- {{available_metrics}}: Any specific metrics you have (e.g., open rates, click-through rates, conversion rates).
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the performance of the specified campaign using the provided metrics and any relevant industry benchmarks.
- Generate a report that includes key metrics, trends, and comparisons to previous periods if data is available.
- Provide insights on what worked well and what didn't, focusing on actionable recommendations.
- Highlight any anomalies or areas requiring further investigation.
Output format Provide a structured report with sections: Overview, Key Metrics, Insights, and Recommendations. Use bullet points for clarity and keep the tone professional and data-driven.
Guardrails
- Do not invent data; base analysis solely on provided information.
- Flag any assumptions about missing data explicitly.
- Stay within the scope of the specified campaign and metrics.
Example
- campaign_type: email marketing campaign
- launch_date_or_timeframe: January 2025
- product_or_service: new fitness tracker
- available_metrics: open rate 22%, click-through rate 3.5%, conversion rate 1.2%
Open this prompt Analysis · Intermediate
Customer Segmentation Strategy
Use this when you need to segment your customer base for more targeted marketing and personalized messaging.
Open this prompt Analysis · Intermediate
Competitor Strategy Research
Use this when you need to research competitors' marketing tactics and customer feedback to improve your own strategy.
Open this prompt Research · Intermediate
ROI Analysis and Optimization
Use this when you need to calculate the return on investment for marketing initiatives and identify ways to optimize spend.
Open this prompt Analysis · Intermediate
Optimize Marketing Campaign Performance
Use this when you need to analyze campaign results, identify underperforming areas, and get actionable recommendations for improvement.
Open this prompt Analysis · Intermediate
Sales Forecasting and Trend Analysis
Use this when you need to predict future sales, market trends, and identify opportunities or risks.
Open this prompt Analysis · Advanced
Optimize Marketing Channel Attribution
Use this when you need to analyze customer journeys and attribute marketing outcomes to specific channels for better budget allocation.
Open this prompt Analysis · Intermediate
Customer Lifetime Value Analysis
Use this when you need to calculate customer lifetime value and identify strategies to improve retention and loyalty.
Open this prompt Analysis · Intermediate
Customer Lifetime Value Analysis
Use this when you need to calculate customer lifetime value and identify high-value segments to enhance retention and loyalty.
Open this prompt Analysis · Intermediate
A/B Testing Experiment Design
Use this when you need to design, run, and analyze A/B tests to optimize marketing campaigns and make data-driven decisions.
Open this prompt Analysis · Intermediate
A/B Testing for Campaign Optimization
Use this when you need to design and analyze A/B tests for marketing campaigns to improve key performance metrics.
Open this prompt Analysis · Intermediate
Track Marketing Campaign Performance
Use this when you need to generate performance reports for marketing campaigns and get insights for improvement.
Open this prompt Analysis · Beginner
Website Traffic and Conversion Analysis
Use this when you need to analyze website traffic, visitor behavior, and conversion rates to improve user experience and increase conversions.
Open this prompt Analysis · Intermediate
Competitive Analysis for Differentiation
Use this when you need to analyze competitors' strategies and customer feedback to identify opportunities for differentiation.
Open this prompt Research · Intermediate
Build Marketing Attribution Model
Use this when you need to attribute sales and conversions to specific marketing channels and optimize resource allocation.
Open this prompt Analysis · Intermediate
Optimize Marketing Mix Allocation
Use this when you need to determine the optimal allocation of resources across marketing channels based on data analysis.
Open this prompt Planning · Intermediate
Predictive Sales Forecasting
Use this when you need to forecast future sales based on historical data and market trends to guide strategic decisions.
Open this prompt Analysis · Advanced