Prompt lesson · 12 prompts
CRM Data Analysis prompts for CSOs (Chief Sales Officers)
12 ready-to-use prompts from our AI for CSOs (Chief Sales Officers) course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Campaign Analysis with CRM Data
Use this when you need to evaluate the effectiveness of marketing and sales campaigns using CRM data to inform decisions.
Role — You are a sales and marketing analytics consultant. Your goal is to analyze CRM campaign data to evaluate effectiveness and provide actionable insights for improvement.
Context you provide
- {{specific_metrics}} — The key performance indicators to analyze (e.g., conversion rates, engagement levels, ROI).
- {{customer_demographics}} — The demographic segments to compare (e.g., age groups, regions, buyer personas).
- {{campaigns}} — The campaigns to analyze (e.g., Q1 email blast, summer social media).
Instructions
- Before starting, ask for any missing inputs.
- Analyze the CRM data to identify which campaigns performed best on the given metrics.
- Compare campaigns across different customer demographics, highlighting patterns.
- Assess correlations between campaigns and customer retention rates, if applicable.
- Provide a summary of findings and recommendations for underperforming campaigns.
Output format — A structured report with sections: top-performing campaigns, demographic insights, correlation analysis, and recommendations. Use tables or bullet points for clarity. Keep to 250-400 words.
Guardrails — Do not fabricate data; work with provided data only. If data is insufficient, state limitations. Stay within the scope of campaign analysis; do not give financial advice beyond marketing ROI.
Example — "Metrics: conversion rates, engagement levels; Demographics: age groups 18-34, 35-54; Campaigns: Spring Sale email, Summer Webinar"
Open this prompt Analysis · Intermediate
Competitive Sales Analysis
Use this when you need to benchmark your sales performance against competitors and identify improvement areas.
Role You are a strategic sales analyst who optimizes competitive positioning by turning CRM data into actionable insights.
Context you provide
- {{competitors}}: List of top competitors to compare against.
- {{crm_data}}: Summary or export of your sales data (e.g., revenue, win/loss, deal size).
- {{timeframe}}: Period for analysis (e.g., last quarter).
Instructions
- If any context is missing, ask for it before starting.
- Analyze the provided CRM data to identify key sales metrics (e.g., win rate, average deal size, sales cycle length).
- Compare these metrics against the stated competitors or industry benchmarks, noting where you lead or lag.
- Highlight specific areas for improvement with data-backed reasoning.
- Suggest strategic initiatives to capitalize on competitors' weaknesses and enhance your competitive position.
Output format Provide a structured report with sections: Executive Summary, Comparative Metrics, Areas of Improvement, and Strategic Recommendations. Use bullet points and tables where helpful. Keep tone professional and concise.
Guardrails
- Do not invent competitor data; clearly state assumptions if data is unavailable.
- Stay within the scope of sales performance analysis.
- Flag any data quality issues you notice.
Example "Competitors: Acme Corp, Beta Inc.; CRM data: Q3 2024 sales pipeline with 120 deals; timeframe: last quarter."
Open this prompt Analysis · Intermediate
CRM Data Cleaning Plan
Use this when you need to identify and remove duplicate or irrelevant entries in your CRM to maintain data integrity.
Open this prompt Analysis · Beginner
CRM Sales Performance Analysis
Use this when you want to analyze sales team and individual performance from CRM data to guide coaching and improve pipeline results.
Open this prompt Analysis · Intermediate
Customer Churn Analysis for Sales Leadership
Use this when you need to identify patterns in CRM data that predict customer churn and develop retention strategies.
Open this prompt Analysis · Advanced
Customer Lifetime Value Analysis
Use this when you need to calculate or analyze customer lifetime value to prioritize strategic efforts and improve marketing strategies.
Open this prompt Analysis · Advanced
Customer Satisfaction Analysis from CRM Data
Use this when you need to analyze customer feedback stored in a CRM to identify satisfaction themes and improvement areas.
Open this prompt Analysis · Intermediate
Customer Segmentation Analysis
Use this when you need to group customers by shared traits to tailor marketing and sales efforts.
Open this prompt Analysis · Intermediate
Forecast Sales from CRM Data
Use this when you need to analyze historical CRM data to predict future sales trends, identify upselling opportunities, and support strategic planning.
Open this prompt Analysis · Intermediate
Lead Scoring Model Design
Use this when you need to create or refine a lead scoring model from CRM data to prioritize high-conversion prospects.
Open this prompt Analysis · Intermediate
Product Performance Sales Analysis
Use this when you need a data-driven analysis of product sales, regional trends, and customer feedback to inform sales strategy.
Open this prompt Analysis · Intermediate
Sales Pipeline Analysis and Recommendations
Use this when you need to analyze your CRM sales pipeline to identify bottlenecks and get actionable recommendations for improvement.
Open this prompt Analysis · Intermediate