100 Best Claude Excel Data Analysis Prompts for Marketing Agencies

Direct Answer

The best Claude prompts for Excel data analysis for marketing agencies are a practical, repeatable set of tasks designed to extract insights from Excel data, standardize reporting, and drive actionable recommendations for clients. Use them to speed up analyses, ensure consistency, and keep outputs client-ready. The prompts assume clean input data and clear business goals, and should be adapted as needed to fit individual client contexts.

Introduction

This page is a practical prompt library for Excel data analysis tailored to marketing agencies. It helps analysts, marketers, and project teams transform Excel exports into insight-rich reports and dashboards.

Designed for professionals who work with client data, these Claude prompts cover cleaning, analysis, visualization, forecasting, and reporting to empower faster, more accurate decision making.

How to Use These Claude Prompts

• Replace placeholders like [Channel], [Region], and [Date] with your actual data fields.
• Add constraints such as date ranges, budget limits, and target metrics to tailor prompts to your client brief.
• Request outputs in preferred formats such as CSV, Excel, or a summarized report with bullet points.
• When outputs include numbers, require explicit calculations and unit clarity.
• Verify results by cross-checking summaries against source data before sharing with clients.
• If something feels off, rerun the relevant prompt with adjusted parameters to confirm consistency.

100 Best Claude Excel Data Analysis Prompts for Marketing Agencies

1. Data cleanup basics: Act as a data cleaning specialist. You are given an Excel dataset exported from a marketing platform. Your task is to standardize date formats, normalize campaign names, deduplicate records, and fill missing values using context-aware rules. Output a clean CSV-ready table and a summary of changes.
2. Campaign naming standard: Take a list of campaign names from an Excel column and map them to a standardized naming template: [Channel]-[Objective]-[Region]-[Quarter]. Provide a mapping table and a brief justification for each change to ensure consistency across reports.
3. Channel attribution setup: In an Excel file with channels and touchpoints, identify the optimal attribution model for a marketing agency client. Explain why the chosen model fits the client, and generate an attribute table showing channel contributions under that model.
4. KPI sanity check: Review a set of marketing KPIs in Excel for completeness and logical consistency. Flag anomalies, compute missing KPIs from existing data, and suggest definitions aligned with industry standards for reporting to clients.
5. Campaign performance pivot: Create a pivot-ready analysis plan in Excel for a multi-channel campaign. Define rows, columns, and filters to compare CTR, CPC, CPA, and ROAS by channel, region, and week. Provide step-by-step pivot operations.
6. Time-series trend map: Given weekly marketing data in Excel, generate a trend analysis plan including moving averages, seasonality detection, and anomaly alerts. Output a charting plan and a short narrative explaining trends.
7. Forecasting basics: Develop an Excel-ready forecasting model outline for monthly spend and expected CAC. Describe data inputs, assumptions, and a simple forecast formula. Include validation checks and a plan for updating forecasts monthly.
8. Budget vs spend audit: In an Excel workbook with budgets and actuals, compute variances by campaign and channel. Flag significant variances, calculate percentage deviation, and prepare a client-facing variance explanation.
9. ROI calculator: Create an Excel ROI calculator that accepts ad spend, revenue, and attribution weights. Output ROAS, net profit, and break-even spend with a scenario table for different weighting.
10. CAC breakdown: Build an Excel CAC breakdown that separates media spend, agency fees, and creative costs. Output CAC per channel, per campaign, and a total CAC with confidence intervals.
11. LTV projection: Develop an Excel-based LTV projection for a client’s product. Include churn, average order value, repeat purchase rate, and a sensitivity table for different discount rates.
12. A/B test synthesis: Aggregate A/B test results from Excel into a concise summary. Include sample size, conversion lift, confidence interval, and a recommended action with justification.
13. Dashboard blueprint: Outline an Excel dashboard structure for a marketing agency client. List metrics, data sources, update cadence, and visuals suitable for executive reviews.
14. Client-ready report pack: Generate a template outline for a monthly client report in Excel, including cover page, executive summary, key metrics, growth drivers, and actionable recommendations.
15. Churn analysis sheet: Create an Excel model to identify churn risk factors from marketing data. Include probability of churn by cohort, leading indicators, and a recommended retention plan.
16. Segmentation quiz: Segment a customer base in Excel using RFM analysis. Output customer segments, score thresholds, and recommended marketing actions per segment.
17. Geography insights: Analyze geographic performance in Excel. Provide a map-ready dataset, regional ROAS comparisons, and a brief interpretation notes.
18. Seasonality capture: Detect seasonal effects in monthly campaign data. Provide seasonal indices, flags for anomalies, and a plan to adjust spend by season.
19. Channel mix optimization: Run a constraint-based optimization in Excel to maximize ROAS with budget limits. Output recommended channel mix and a sensitivity table.
20. Creative impact check: Assess creative effectiveness in Excel by segmenting performance by creative variant. Provide a ranking and actionable optimization steps.
21. Landing page impact: Correlate landing page variants with conversion rate in Excel. Output a landing page impact score and recommended page optimizations.
22. Cost per click clarity: Compute CPC by campaign and keyword, then identify top drivers of cost. Generate insights and a plan to reduce wasteful spend.
23. Attribution model comparison: Compare two attribution models in Excel for a client dataset. Show differences in channel contributions and provide a recommendation.
24. Conversion funnel mapping: Map the marketing funnel in Excel from impression to conversion. Include drop-off points, conversion rates, and recommended optimizations.
25. Campaign calendar sync: Create an Excel-friendly campaign calendar that aligns with spend plan, flight dates, and expected returns. Include color-coded status indicators.
26. Lead scoring rules: Develop an Excel-based lead scoring model with weights, thresholds, and a rating output. Provide a sample dataset and resulting scores.
27. Content performance matrix: Build a matrix in Excel that links content assets to engagement metrics by channel. Provide insights and top-performing content ideas.
28. Email performance sketch: Analyze email metrics in Excel by campaign and list, including open rate, click-through, and conversions. Output a recommended email plan.
29. Social vs search ROI: Calculate ROI by channel type (social vs search) in Excel. Compare performance, cost structure, and provide a final recommendation.
30. Audience growth model: Model audience growth in Excel with acquisition rate, churn, and monthly net new users. Provide projected totals and confidence bounds.
31. Experiment planner: Plan a set of marketing experiments in Excel. Define hypothesis, sample size, metrics, duration, and success criteria.
32. Data dictionary: Create an Excel data dictionary for a marketing dataset. Include field names, descriptions, data types, and valid value ranges.
33. Data quality score: Compute a data quality score per column in Excel based on completeness, validity, uniqueness, and consistency. Output scores and remediation steps.
34. Benchmarking template: Build a benchmarking template in Excel comparing client performance to industry peers. Include metrics, sources, and interpretation notes.
35. Forecast accuracy check: In Excel, compare forecast vs actuals by month. Compute MAPE, MAE, and a summary of forecast gaps with improvement ideas.
36. Scenario planning: Create scenario analyses in Excel for best, base, and worst cases. Include spend, revenue, and profitability projections.
37. Data visualization plan: Propose an Excel-ready data visualization plan for client reports. List chart types, data mappings, and narrative cues.
38. Campaign drift detect: Detect drift in campaign performance over time in Excel. Output drift metrics and recommended corrective actions.
39. Market mix modeling: Outline a market mix modeling approach in Excel for a client, including inputs, outputs, and a simple elasticity interpretation.
40. Data consolidation: Consolidate multiple Excel sources into a single master sheet. Provide field mapping rules, deduplication steps, and a consistency check.
41. Sales attribution bridge: Link marketing touchpoints to sales in Excel. Produce a bridge table and a summarized impact by channel.
42. Lifecycle analytics: Analyze customer lifecycle stages in Excel. Output cohort retention, engagement scores, and next-best actions by stage.
43. PPC quality score: Assess PPC performance in Excel by quality score components. Highlight optimization opportunities for ads and keywords.
44. Content calendar analytics: Analyze content calendar data in Excel. Tie publishing frequency to engagement and conversions with recommendations.
45. Ecommerce funnel: Model ecommerce funnel in Excel from visit to purchase. Include drop-off rates, average order value, and recovery actions.
46. Offer performance map: Create an offer performance map in Excel by region and channel. Output top-performing offers and suggested optimizations.
47. Retention playbook: Design a retention-focused analysis in Excel with cohorts and churn reduction actions. Provide a monthly action plan.
48. Budget reallocation plan: Propose a data-backed budget reallocation in Excel to maximize ROAS under a fixed spend. Include a simple optimization outline.
49. Client-ready metrics: List a compact set of client-ready metrics in Excel with definitions, targets, and visual cues for a dashboard.
50. Data refresh protocol: Define an Excel data refresh protocol for marketing data sources, including frequency, validation checks, and error handling.
51. Email list hygiene: Audit email lists in Excel for deliverability factors. Output cleaning steps, suppression rules, and a re-engagement plan.
52. Creative variant testing: Evaluate creative variants in Excel by performance and lift. Produce a recommended iteration path and sample size guidance.
53. Landing page performance: Correlate landing page variants with conversions in Excel. Provide a landing page score and optimization ideas.
54. Audience segmentation map: Create a segmentation map in Excel showing segments, size, and revenue potential. Include recommended campaigns per segment.
55. Bid strategy advisor: Suggest bid strategy adjustments in Excel based on performance signals. Include risk notes and expected impact.
56. Attribution audit checklist: Provide a comprehensive attribution audit checklist in Excel to validate data integrity, modeling, and reporting.
57. Cross-channel synergy: Quantify cross-channel effects in Excel by measuring uplift when combining channels. Output synergy score and recommendations.
58. Brand lift proxy: Estimate brand lift indicators in Excel using surrogate metrics from campaigns. Provide interpretation and caveats.
59. Revenue attribution map: Map revenue attribution in Excel to marketing touchpoints. Provide a clean table and a narrative of drivers.
60. Landing page speed impact: Analyze page load times in Excel and correlate with conversions. Provide recommendations to optimize speed.
61. Seasonal budget shift: Create a seasonal budget shift plan in Excel with monthly reallocations to weathered channels. Include risk notes.
62. Sampling plan: Design a sampling plan in Excel for large datasets. Include sample size, sampling method, and confidence targets.
63. Data lineage trace: Capture data lineage in Excel for marketing datasets. Output a flow diagram as a textual description and checklist.
64. Forecast vs plan alignment: Compare forecasted metrics to the original plan in Excel. Highlight misalignments and propose corrective steps.
65. Sales funnel sync: Sync marketing data with CRM in Excel. Include field mappings and a workflow for monthly reconciliation.
66. Data quality exceptions: Identify data quality exceptions in Excel exports. Produce a defect log and remediation actions.
67. Experiment prioritization: Rank experiments by expected impact in Excel considering resources. Output top 5 experiments with rationale.
68. Shareable data pack: Package a compact Excel data pack for client sharing. Include key metrics, visuals, and a one-page summary.
69. Marketing mix insights: Generate marketing mix insights in Excel with channel contributions and cost efficiency notes.
70. Event-driven spikes: Detect event-driven spikes in campaign data in Excel. Provide cause analysis and mitigation steps.
71. Customer journey mapping: Map customer journeys in Excel from first touch to conversion. Highlight friction points and optimization ideas.
72. Cost center view: Create a cost center view in Excel breaking out spend by team and initiative. Output ROI per center.
73. Survey data quick分析: Analyze survey responses in Excel for sentiment and key drivers. Provide top insights and visual cues.
74. Product line profitability: Evaluate profitability by product line in Excel. Include contribution margins and recommended price adjustments.
75. Campaign localization: Assess localization impact in Excel by region. Provide localization recommendations and ROI adjustments.
76. Forecast anomaly alerts: Set up anomaly detection in Excel forecasts. Output alert rules and a monthly monitoring plan.
77. Auto-summarize reports: Create an Excel template that auto-summarizes data into a 1-page client report with visuals.
78. Key driver analysis: Identify top drivers of campaign performance in Excel using regression or correlation. Provide interpreted results.
79. SLA and cadence plan: Propose an Excel-based reporting cadence and service level agreement visuals for clients.
80. Data privacy safe prompt: Outline data handling in Excel for marketing data with PII considerations and safe output guidance.
81. Creative asset catalog: Catalog creative assets in Excel with performance by asset and channel. Suggest optimizations per asset.
82. Conversion rate lift: Calculate conversion rate lift when applying a new creative. Include statistical significance notes.
83. Campaign health score: Build a campaign health score in Excel combining multiple metrics. Provide a threshold-based health dashboard.
84. Email deliverability map: Map email deliverability factors in Excel. Output actionable fixes for senders and domains.
85. Budget scenario explorer: Create an Excel scenario explorer to compare spend plans and outcomes across scenarios.
86. Audience overlap analysis: Analyze audience overlaps between campaigns in Excel. Output overlap percentage and targeting suggestions.
87. Open rates by segment: Segment email opens by audience segment in Excel. Provide optimization ideas per segment.
88. Creative fatigue detector: Detect creative fatigue signals in Excel data. Propose refresh cadence and new creative ideas.
89. Offer testing plan: Plan offer tests in Excel including variants, target metrics, and decision criteria.
90. Geo-level ROAS: Compute ROAS by geographic region in Excel. Compare regions and suggest region-specific actions.
91. Audience lifetime value: Estimate customer lifetime value by segment in Excel. Include discount rate and churn assumptions.
92. Product mix optimization: Optimize product mix in Excel for profitability. Output recommended SKUs and projected margins.
93. Landing page variant compare: Compare multiple landing page variants in Excel. Provide lift, confidence, and recommended page 1.
94. Media plan synthesis: Synthesize a media plan in Excel from multiple sources. Include channel, spend, and expected outcomes.
95. Data normalization: Normalize disparate data fields in Excel to a common schema. Output a normalized master sheet.
96. Campaign risk assessment: Assess campaign risks in Excel with impact and likelihood, and propose mitigation steps.
97. Churn prevention tactics: List churn prevention tactics in Excel with expected impact and implementation steps.
98. Client Q&A prompts: Prepare a Q&A prompt set in Excel for client review meetings, including data sources and interpretation notes.
99. Performance snapshot: Create a one-page performance snapshot in Excel with key metrics, trends, and takeaways.
100. Automation plan: Outline an automation plan in Excel to standardize data collection, cleaning, analysis, and reporting, with milestones.

Best Practices

• Structure data in a clean, normalized Excel format before running prompts.
• Save prompts as templates to reuse across clients with minimal edits.
• Combine prompts to create end-to-end workflows from data ingestion to executive summaries.
• Use human-in-the-loop checks for critical client-facing outputs to ensure accuracy.
• Document assumptions and provide rationale alongside numerical conclusions.

Common Mistakes to Avoid

• Assuming input data is perfectly clean; always perform a data quality check first.
• Overloading prompts with too many goals; focus prompts on a single clear outcome per run.
• Failing to specify required formats or output units.
• Not validating outputs against source data or client briefs.
• Using ambiguous placeholders without clear replacement guidance.

FAQ

What makes these Claude prompts suitable for marketing agencies?

They’re tailored to Excel-based marketing data, cover end-to-end workflows, and produce client-ready outputs with clear insights.

Do I need to provide any data in the prompts?

Yes, you should supply the Excel data, field names, and any business rules or targets relevant to the prompt.

Can prompts be reused across clients?

Yes, by replacing placeholders and constraints to fit each client’s data and goals.

What output formats should I use for client delivery?

CSV, Excel, and concise narrative reports with visuals are recommended for clear communication.

How do I ensure accuracy in AI-generated analyses?

Validate outputs against source data, set explicit formulas, and perform spot checks on results.

Are these prompts suitable for beginners or only experts?

The prompts are suitable for both; beginners can start with simpler ones and iterate, while experts can customize advanced prompts.