100 Best Claude Excel Data Analysis Prompts for Event Planners

Direct Answer

The best Claude prompts for Excel data analysis for event planners are: use this collection of 100 prompts to extract insights from event data in Excel with Claude. They cover attendance forecasting, budget variance, vendor scoring, seating optimization, sponsorship ROI, post-event impact, and more, each formatted for quick execution and clear outputs.

Introduction

This prompt library is tailored for event planners who rely on Excel data to optimize outcomes. It provides practical Claude prompts to analyze registrations, budgets, vendors, venues, and attendee experiences.

If you plan events, manage budgets, or optimize sponsor value, this collection helps you translate data into actionable decisions using Claude prompts.

How to Use These Claude Prompts

• Replace placeholders like [data], [ton e], and [constraints] with your event-specific values.
• Add constraints to enforce formats, budgets, or safety requirements.
• Request outputs in clear tables, bullet lists, or summarized dashboards to fit your reporting workflow.
• Verify outputs by cross-checking with your source data and one or two spot checks.
• Use the prompts to build reusable templates for recurring events.
• Adapt prompts to fit your organization’s data governance rules.

100 Best Claude Excel Data Analysis Prompts for Event Planners

1. Attendance forecast basics: You are an event planning analyst. Task: forecast expected attendance for the next event using previous events data. Context: [data from last 3 events: date, venue capacity, registered, attended, ticket type]. Output format: a concise table with date, forecasted attendees, confidence interval, and key drivers. Constraints: use at most eight rows, explain outliers, provide a brief rationale.
2. Budget variance analysis: You are a finance planner. Task: analyze budget variance for the current event cycle. Context: [budgeted amounts vs actuals by category: venue, catering, staff, marketing, contingency]. Output format: bullet list of variances with percentage deviations and recommended corrective actions. Constraints: highlight top three overruns and provide one sentence mitigation per item.
3. Vendor scorecard creation: You are a procurement analyst. Task: create a vendor performance scorecard based on delivery reliability, cost, quality, and communication. Context: [vendors A, B, C, D with scores from past events]. Output format: table with vendor, metric scores, total score, and recommendation. Constraints: normalize scores on a 100-point scale; include a weighted summary.
4. Seat map optimization: You are a operations planner. Task: optimize seating to maximize adjacency of VIP guests while maintaining accessibility requirements. Context: [layout constraints, guest lists, VIPs, accessibility needs]. Output format: recommended seating plan and rationale in bullet form. Constraints: avoid seat clashes, respect group sizes, and create at least two backup arrangements.
5. Campaign ROI estimation: You are a marketing analyst. Task: estimate ROI for a marketing campaign based on spend, channel mix, and expected ticket uplift. Context: [costs by channel, expected conversion rate, average revenue per attendee]. Output format: calculator-style summary with ROI percentage, break-even point, and sensitivity notes. Constraints: show at least three scenario results.
6. Check-in efficiency model: You are an event ops consultant. Task: model check-in throughput under different staffing levels and tech assist. Context: [current check-in time, queue length, staff count, tech tools]. Output format: chart-like text and recommended staffing plan. Constraints: provide max wait time target and break-even staffing level.
7. Registration trend analysis: You are a data analyst. Task: analyze registration trends over the last year and identify seasonality. Context: [monthly registrations, marketing spend, external events]. Output format: trend line notes and a forecast for next two months. Constraints: include seasonality index and actionable insights.
8. Catering cost breakdown: You are a catering analyst. Task: break down catering costs by item type and portion. Context: [menus, headcount, price per head]. Output format: table with item, unit cost, quantity, total, and recommended cost-saving ideas. Constraints: keep total under allocated budget.
9. Sponsor value mapping: You are a sponsorship manager. Task: map sponsor benefits to perceived value for attendees. Context: [sponsor packages, perks, anticipated attendance]. Output format: value map table and a one-paragraph justification. Constraints: include at least three new value-add ideas.
10. Refund risk assessment: You are a risk analyst. Task: assess refund risk based on ticket type, event date, and policy. Context: [refund rates from prior events, policy terms, ticket mix]. Output format: risk matrix and mitigation steps. Constraints: categorize risk as low/medium/high with rationale.
11. Attendee segmentation: You are a data strategist. Task: segment attendees into groups by behavior and needs. Context: [survey responses, past attendance, ticket type]. Output format: segment list with characteristics and suggested tailored communications. Constraints: provide 4 segments at most.
12. Post-event survey synthesis: You are a feedback analyst. Task: synthesize post-event survey results into actionable insights. Context: [ratings, comments, NPS]. Output format: bullets of top themes and 3 concrete actions. Constraints: quantify impact where possible.
13. Venue capacity planning: You are a space planning expert. Task: evaluate venue capacity against attendee projections and safety limits. Context: [venue layout, occupancy limits, expected turnout]. Output format: capacity verdict with recommended adjustments. Constraints: include safety margin.
14. Marketing attribution: You are a marketing data scientist. Task: attribute registrations to channels with a simple model. Context: [channel spend, clicks, registrations]. Output format: table with attribution share, caveats, and recommended optimizations. Constraints: avoid over-attribution.
15. Ticket tier optimization: You are a pricing analyst. Task: optimize ticket tier mix to balance revenue and accessibility. Context: [tier prices, historical uptake, capacity]. Output format: recommended tier distribution and rationale. Constraints: ensure at least 25 percent of tickets in mid-tier.
16. Deal pipeline health: You are a program manager. Task: evaluate the health of the event deal pipeline. Context: [prospects, stage, expected close date, potential revenue]. Output format: health score and next actions. Constraints: color-code statuses in text.
17. Sponsorship ROI modeling: You are a financial analyst. Task: model sponsor ROI using projected exposure, attendee reach, and value of on-site activation. Context: [sponsor deals, impressions, coverage]. Output format:ROI calculation, payback period, and recommendations. Constraints: show sensitivity to attendance changes.
18. Vendor risk alert: You are a procurement risk manager. Task: identify top vendor risk factors before a big event. Context: [vendor history, contract terms, backup options]. Output format: risk brief with mitigations. Constraints: categorize risks and assign severity.
19. Waste management plan: You are a sustainability planner. Task: design a waste management plan for event. Context: [venue waste streams, recycling options, composting capacity]. Output format: actionable plan with milestones. Constraints: include KPIs.
20. Social media lift: You are a social media analyst. Task: estimate social media lift from pre-event campaigns. Context: [baseline reach, campaign spend, influencer picks]. Output format: projection table and recommended tweaks. Constraints: provide uncertainty range.
21. Table capacity mapping: You are an operations engineer. Task: map table capacity to guest seating preferences. Context: [table sizes, guest lists, VIP groups]. Output format: seating plan links and capacity notes. Constraints: keep guests within comfort zone.
22. Air quality risk check: You are a safety analyst. Task: assess air quality risks for indoor venues. Context: [ventilation specs, occupancy, local air quality data]. Output format: risk rating and mitigation steps. Constraints: none.
23. Floor plan heat map: You are an facilities analyst. Task: generate a heat map of traffic flow on the floor plan. Context: [foot traffic data, booth locations]. Output format: text-based heat map with hotspots and suggested re-routing. Constraints: none.
24. Catering waste audit: You are a sustainability auditor. Task: audit catering waste and identify reductions. Context: [menus, waste logs, portion sizes]. Output format: bullet findings and 3 reduction actions. Constraints: quantify waste reduction.
25. Feedback loop design: You are a process designer. Task: create a feedback loop between attendees and organizers. Context: [communication channels, response times, escalation path]. Output format: flow diagram in text and 2 KPI targets. Constraints: none.
26. Power usage forecast: You are an energy planner. Task: forecast power usage for the event. Context: [lighting, AV, cooling loads, backup power]. Output format: forecast table with peak demand and reserve plan. Constraints: include contingency.
27. Risk-adjusted schedule: You are a project manager. Task: build a risk-adjusted event schedule. Context: [task durations, dependencies, buffers, risk flags]. Output format: schedule with risk scores and mitigation times. Constraints: keep critical path intact.
28. Payment reconciliation: You are an finance clerk. Task: reconcile all payments received vs outstanding. Context: [invoice IDs, amounts, dates, payer]. Output format: reconciliation table and variance notes. Constraints: flag mismatches.
29. Attendee churn analysis: You are a data scientist. Task: analyze attendee churn across multiple events. Context: [attendee IDs, attendance history, ticket types]. Output format: churn rate and retention tactics. Constraints: segment by reason.
30. Post-event impact: You are a business analyst. Task: estimate post-event impact on brand metrics. Context: [pre and post-event brand metrics, sentiment, media coverage]. Output format: impact summary with 2–3 actionable PR actions. Constraints: none.
31. Cancellation risk matrix: You are a risk manager. Task: build a cancellation risk matrix by event type and time to event. Context: [cancellation history, refund terms, external factors]. Output format: matrix and recommended policies. Constraints: color-coded.
32. Venue accessibility check: You are an accessibility consultant. Task: assess venue accessibility for all attendees. Context: [entrances, restrooms, seating, signage]. Output format: compliance checklist and enhancement plan. Constraints: include estimated cost.
33. Sponsor activation plan: You are a sponsorship strategist. Task: design sponsor activations that fit the event theme. Context: [sponsor goals, audience profile, space constraints]. Output format: activation ideas with expected reach and budget. Constraints: select at least two activations.
34. Sponsor catalog update: You are a partnerships coordinator. Task: refresh sponsor catalog for next event. Context: [past sponsorship data, new opportunities, pricing]. Output format: updated catalog with tiered options and rationale. Constraints: ensure value alignment.
35. Attendee journey map: You are a user experience analyst. Task: map the attendee journey from discovery to post-event. Context: [touchpoints, drop-offs, satisfaction metrics]. Output format: journey map steps with improvement ideas. Constraints: focus on pain points.
36. CEU eligibility check: You are an compliance analyst. Task: verify continuing education unit eligibility for sessions. Context: [accreditation rules, session details, vendor claims]. Output format: eligibility grid and notes. Constraints: none.
37. Email marketing cadence: You are a campaign planner. Task: design an email cadence for registration and pre-event reminders. Context: [email templates, send times, open rates]. Output format: schedule and content outline with personalization fields. Constraints: avoid fatigue.
38. VIP experience design: You are a guest experience designer. Task: craft a memorable VIP attendee program. Context: [VIP list, perks, exclusive sessions]. Output format: agenda and rationale. Constraints: include metrics for success.
39. Risk scenario planner: You are a risk planner. Task: develop scenarios for high-impact risks and responses. Context: [risk types, likelihood, impact, triggers]. Output format: scenarios with response playbooks. Constraints: include a 24-hour escalation path.
40. Check-in data dashboard: You are a data visualization specialist. Task: design a check-in analytics dashboard. Context: [live check-in data, peak times, device counts]. Output format: list of dashboard widgets and data sources. Constraints: ensure real-time alerts.
41. Crowd flow guidance: You are a crowd management expert. Task: create guidance to manage crowd flow in crowded zones. Context: [zone layouts, capacity, exit routes]. Output format: tactical plan with staff roles. Constraints: minimize bottlenecks.
42. Event-day communications: You are a communications lead. Task: craft event-day communications plan for staff and vendors. Context: [timeline, channels, escalation points]. Output format: message schedule and templates. Constraints: multilingual needs.
43. Venue heat map insights: You are a spatial analyst. Task: derive insights from venue heat map data to optimize placements. Context: [traffic, booth popularity, seat demand]. Output format: insights list and recommended actions. Constraints: prioritize high-impact changes.
44. Post-event ROI report: You are a financial reporter. Task: prepare a post-event ROI report with key metrics. Context: [revenues, costs, attendance, sponsor value]. Output format: executive summary and detail appendix. Constraints: avoid fluff.
45. Data privacy checklist: You are a compliance advisor. Task: create a data privacy checklist for attendee data. Context: [data types, retention periods, consent]. Output format: checklist with remediation steps. Constraints: align with regulations.
46. Forecast model validation: You are a data engineer. Task: validate the accuracy of your forecast model for attendance. Context: [actual vs forecast, error metrics]. Output format: validation report and next model tweaks. Constraints: report bias if any.
47. Cost-saving hacks: You are a procurement analyst. Task: identify cost-saving opportunities with no quality loss. Context: [current contracts, alternate vendors, bulk discounts]. Output format: bullet list with estimated savings and payback periods. Constraints: prioritize impact.
48. Session popularity ranking: You are a content analyst. Task: rank sessions by expected popularity. Context: [past attendance, topics, speakers]. Output format: ranked list with rationale. Constraints: include confidence score.
49. Food waste minimization: You are a sustainability advisor. Task: minimize catering waste with portion control. Context: [menu, headcount, service style]. Output format: optimization notes and waste targets. Constraints: quantify reduction.
50. Staffing plan snapshot: You are an operations planner. Task: generate a staffing plan snapshot for event days. Context: [shifts, roles, coverage, peak times]. Output format: table with roles and hours. Constraints: include backup options.
51. Revenue by channel: You are a data analyst. Task: break down revenue by sales channel and ticket type. Context: [transactions, refunds, fees]. Output format: table and interpretation notes. Constraints: exclude outliers.
52. Attendee sentiment map: You are a sentiment analyst. Task: map attendee sentiment to event moments. Context: [survey comments, ratings]. Output format: moment-to-sentiment map and improvement ideas. Constraints: prioritize critical moments.
53. Logistics route optimization: You are a logistics planner. Task: optimize vendor delivery routes around the venue. Context: [delivery windows, street access, loading docks]. Output format: route plan with time windows and risk notes. Constraints: minimize delays.
54. A/B testing plan: You are a experiments lead. Task: design an A/B test for an event feature. Context: [feature variants, metrics, sample size]. Output format: test plan with success criteria and rollout steps. Constraints: ensure randomization.
55. Ticketing fraud checks: You are a security analyst. Task: implement fraud detection checks for ticket purchases. Context: [purchase patterns, IP flags, device fingerprints]. Output format: risk rules and action steps. Constraints: minimize false positives.
56. Sponsor package alignment: You are a partnerships manager. Task: evaluate sponsor packages for alignment with event goals. Context: [goals, audience, pricing, benefits]. Output format: alignment report with recommendations. Constraints: show gaps.
57. Vendor onboarding guide: You are a procurement lead. Task: create a vendor onboarding guide for new partners. Context: [contracts, safety, data sharing]. Output format: step-by-step guide and checklist. Constraints: concise.
58. Post-event media brief: You are a PR specialist. Task: draft a post-event media brief for outlets. Context: [event highlights, quotes, stats]. Output format: one-page brief with key messages. Constraints: approvals required.
59. Content plan alignment: You are a content strategist. Task: align content plan with event agenda and sponsor messaging. Context: [sessions, sponsors, channels]. Output format: content map and pillar ideas. Constraints: avoid overlap.
60. On-site tech readiness: You are a IT/DX lead. Task: verify on-site tech readiness for AV and networks. Context: [equipment inventory, network specs, support contacts]. Output format: readiness checklist and failover plan. Constraints: none.
61. Registration data quality: You are a data quality engineer. Task: audit registration dataset for completeness and duplicates. Context: [fields, duplicate rules, validation]. Output format: data quality report and remediation steps. Constraints: prioritize critical fields.
62. Sustainability scorecard: You are a sustainability analyst. Task: build a sustainability scorecard for the event. Context: [energy, waste, sourcing]. Output format: scorecard with targets and progress placeholders. Constraints: include improvement plan.
63. Speaker coordination plan: You are an events coordinator. Task: coordinate speaker logistics and bios. Context: [presentation slots, travel, bios]. Output format: plan with deadlines and reminders. Constraints: avoid overlaps.
64. Vendor contract check: You are a legal/commercial manager. Task: audit vendor contracts for risk and obligations. Context: [terms, termination, penalties]. Output format: risk notes and recommended edits. Constraints: none.
65. Attendee accessibility notes: You are a accessibility consultant. Task: prepare accessibility notes for the event. Context: [ramp access, signage, captions]. Output format: notes with suggested improvements. Constraints: include cost estimates.
66. Food safety checklist: You are a safety officer. Task: ensure catering adheres to safety standards. Context: [storage temps, handling, contamination controls]. Output format: checklist with sign-off items. Constraints: none.
67. Back-end data sync: You are a data engineer. Task: ensure back-end data sync between registration and analytics. Context: [data sources, sync frequency, conflict resolution]. Output format: sync plan and monitoring notes. Constraints: none.
68. Post-event recaps: You are a communications planner. Task: draft post-event recap email to attendees. Context: [highlights, photos, next steps]. Output format: concise recap with CTA. Constraints: include unsubscribe option.
69. ROI storytelling: You are a storyteller for executives. Task: craft the ROI narrative for post-event reports. Context: [metrics, benchmarks, outcomes]. Output format: narrative with data bullets. Constraints: align with audience.
70. Facility risk audit: You are a facilities risk assessor. Task: audit venue facilities for safety and compliance. Context: [fire exits, ADA compliance, hazards]. Output format: audit report and remediation plan. Constraints: prioritize critical items.
71. Pricing elasticity test: You are a pricing scientist. Task: assess pricing elasticity by ticket tier. Context: [historic uptake, price points, competitor pricing]. Output format: elasticity table and recommended price points. Constraints: avoid price shocks.
72. Registration funnel review: You are a funnel analyst. Task: review the registration funnel for drop-offs. Context: [landing page, form fields, checkout], Output format: funnel critique with 3 improvement actions. Constraints: quantify impact.
73. Color-coded dashboards: You are a visualization expert. Task: design color-coded dashboards for event metrics. Context: [KPIs, thresholds, audience]. Output format: dashboard blueprint and legend. Constraints: accessible color palette.
74. Data retention plan: You are a compliance officer. Task: create a data retention and deletion plan for attendee data. Context: [data types, legal requirements, retention periods]. Output format: policy document with schedule. Constraints: none.
75. Feedback channel mapping: You are a process designer. Task: map feedback channels to responsible teams. Context: [channels, SLAs, escalation]. Output format: map with owners and response targets. Constraints: none.
76. Asset tracking: You are a logistics manager. Task: track event assets from procurement to reuse. Context: [asset IDs, locations, lifecycle]. Output format: tracker table and status alerts. Constraints: include depreciation notes.
77. Exhibit booth optimization: You are an exhibit planner. Task: optimize booth placements for foot traffic. Context: [booth map, traffic data, interest signals]. Output format: placement suggestions and justification. Constraints: avoid crowding.
78. VIP guest brief: You are a guest relations lead. Task: prepare brief for VIP attendees with schedule and preferences. Context: [VIP list, special requests]. Output format: concise briefing document. Constraints: ensure privacy.
79. Session scheduling logic: You are a session planner. Task: build a scheduling logic to minimize overlap of similar topics. Context: [topics, speakers, room availability]. Output format: schedule plan with rationale. Constraints: optimize for attendee sequencing.
80. Weather contingency plan: You are an operations planner. Task: design weather contingencies for outdoor events. Context: [forecast, backup venues, transport]. Output format: contingency matrix and action steps. Constraints: none.
81. Registration cap strategy: You are a events strategist. Task: set a registration cap with waitlist logic. Context: [capacity, demand signals, safety margin]. Output format: cap plan and messaging. Constraints: transparent criteria.
82. Expense approval workflow: You are a program administrator. Task: define an expense approval workflow for staff. Context: [approval levels, thresholds, routing]. Output format: workflow diagram in text and SLA notes. Constraints: none.
83. Sponsor activation calendar: You are a sponsorship coordinator. Task: build a calendar of sponsor activations. Context: [sponsor schedule, venue slots, ROI goals]. Output format: calendar with milestones and owners. Constraints: avoid conflicts.
84. Guest feedback prioritization: You are a product manager. Task: prioritize guest feedback items for the next event. Context: [ratings, comments, feasibility]. Output format: ranked list with rationale. Constraints: quick wins first.
85. Pricing scenario brief: You are a pricing strategist. Task: draft pricing scenarios for different demand levels. Context: [baseline demand, capacity, competitor moves]. Output format: scenario briefs with recommended actions. Constraints: none.
86. Sponsorship lead scoring: You are a partnerships analyst. Task: score potential sponsors by fit and value. Context: [prospects, fit score, deal size]. Output format: lead score table and next-step actions. Constraints: update quarterly.
87. Attendee locator plan: You are a logistics planner. Task: design an attendee locator plan for large venues. Context: [registration data, beacon tech, privacy]. Output format: plan with privacy notes and accuracy targets. Constraints: none.
88. EventMetrics glossary: You are a documentation specialist. Task: create a glossary of event metrics used in this context. Context: [common terms, definitions]. Output format: glossary entries with examples. Constraints: concise.
89. Sustainability action list: You are a sustainability coordinator. Task: list practical sustainability actions for the event. Context: [waste, energy, sourcing]. Output format: prioritized action list with owners. Constraints: quick wins.
90. Attendee loyalty program: You are a loyalty manager. Task: design a simple attendee loyalty program. Context: [points, tiers, benefits]. Output format: program outline and implementation steps. Constraints: budget aware.
91. Vendor escalation protocol: You are a vendor manager. Task: create an escalation protocol for vendor issues. Context: [severity levels, contacts, timelines]. Output format: protocol document with templates. Constraints: none.
92. Session recording plan: You are a media planner. Task: plan session recordings and rights management. Context: [session list, permissions, file formats]. Output format: plan with deliverables and storage. Constraints: quality thresholds.
93. Attendee data map: You are a data architect. Task: map attendee data across systems for analytics. Context: [CRM, registration, marketing]. Output format: data map with ownership and lineage notes. Constraints: maintain privacy.
94. Forecast update sprint: You are a product owner. Task: plan a sprint to update forecast model inputs. Context: [data pipelines, validation tests]. Output format: sprint backlog with milestones. Constraints: align with event cycle.
95. Revenue leakage audit: You are an audit analyst. Task: identify revenue leakage across the event lifecycle. Context: [fees, refunds, comps]. Output format: leakage report and remediation steps. Constraints: quantify impact.
96. Room acoustics plan: You are an AV engineer. Task: propose acoustics adjustments for room efficiency. Context: [sound levels, room dimensions, speaker placement]. Output format: plan with acoustic targets. Constraints: budget limits.
97. Gallery layout suggestions: You are a space planner. Task: propose gallery layout changes to improve flow. Context: [artifacts, labels, crowding points]. Output format: layout notes and rationale. Constraints: none.
98. Scenario playbook: You are a operations commander. Task: build a playbook for common event scenarios. Context: [scenario list, triggers, roles]. Output format: playbook with checklists and contact info. Constraints: concise.
99. Post-event learnings: You are a knowledge manager. Task: capture and organize learnings from the event. Context: [notes, debriefs, decisions]. Output format: knowledge base entry with actionable items. Constraints: none.
100. Executive briefing slide: You are a corporate comms lead. Task: draft an executive briefing slide on event performance. Context: [key metrics, sponsor outcomes, next steps]. Output format: slide outline with bullets and notes. Constraints: concise.

Best Practices

• Keep inputs clean and standardized to improve prompt accuracy.
• Save prompts as templates and reuse across events to maintain consistency.
• Review outputs for edge cases and validate with human checks.
• Limit scope per prompt to avoid overfitting results.
• Respect attendee privacy and data retention rules when using data prompts.

Common Mistakes to Avoid

• Using vague prompts without concrete data context.
• Ignoring data quality issues before running prompts.
• Assuming outputs are final without validation checks.
• Overloading prompts with too many constraints that make results impractical.
• Not updating prompts with recent event-specific data.

FAQ

What kinds of Excel data are best for Claude prompts for event planning?

Event planners should provide structured datasets like registrations, budgets, attendance, vendor metrics, and seating plans, with clear fields for dates, amounts, quantities, and categories.

How do I ensure Claude outputs are ready for dashboards?

Ask for outputs in table or bullet formats with labeled columns, include summaries and trend notes, and request CSV-friendly formats when possible.

Can these prompts handle live event data?

Yes—design prompts with live data feeds and request real-time summaries or alerts for key metrics, while ensuring data privacy rules are followed.

What if data is missing or inconsistent?

Ask Claude to flag missing fields, provide data-imputation options, and include sensitivity notes explaining how gaps affect results.

Are these prompts suitable for different event types?

Yes, prompts can be adapted for conferences, weddings, trade shows, and corporate meetings by filling in event-specific placeholders.

How do I scale prompts for multi-event portfolios?

Create a template per event and batch-run across the portfolio with a standardized data schema and aggregated outputs.