50 Copilot Prompts for Marketing Teams
I've seen marketing teams spend more time formatting emails than thinking about messaging. That's backwards. Microsoft 365 Copilot handles the mechanical work—drafting, formatting, summarizing—so you can focus on strategy and creative. These 50 prompts come from my MS-4018 training sessions where I've watched people go from skeptical to converted in about 10 minutes. The first email draft that saves 20 minutes sells itself. Each prompt here is specific, tested, and ready to use in your existing Microsoft 365 apps.
Email Campaign & Outreach Prompts
1. Customer Re-engagement Email Series
Use Copilot in Outlook to draft a three-email series targeting inactive customers. Specify your product, the time since last purchase, and desired tone. Copilot will generate personalized subject lines and body copy that you can customize with merge fields.
2. Event Invitation with Follow-up Sequence
Ask Copilot in Word to create an event invitation email template, then use Outlook Copilot to generate three follow-up emails (reminder, last chance, thank you). Include event details, target audience, and registration link in your prompt for fully contextualized drafts.
3. Newsletter Content from Recent Updates
Use Business Chat to query 'Summarize all marketing updates from SharePoint and Teams channels from the past month.' Then ask Copilot in Word to 'Create a newsletter highlighting these updates in 300 words with section headers.' Your monthly newsletter writes itself from existing communications.
4. Personalized Sales Follow-up After Meeting
After a Teams meeting with a prospect, use Copilot in Teams to generate meeting notes and action items. Then in Outlook, prompt 'Draft a follow-up email referencing our Teams meeting on [date], emphasizing [key points discussed] and proposing next steps.' Copilot pulls context from the meeting transcript.
5. Cold Outreach Email with A/B Variants
In Outlook Copilot, request 'Draft two versions of a cold outreach email for [target persona] promoting [product/service]. Version A should emphasize ROI, Version B should emphasize ease of use.' Test both approaches without spending an hour writing.
6. Partnership Proposal Email
Use Copilot in Word to draft a partnership proposal document, then ask Outlook Copilot to 'Summarize this Word document into a compelling partnership proposal email, keeping it under 200 words with a clear call to action.' Professional proposals in minutes, not hours.
7. Customer Testimonial Request Email
Prompt Copilot in Outlook with 'Draft an email to [customer name] requesting a testimonial about [specific result they achieved]. Make it warm, specific, and include 3-4 guiding questions they can answer.' Get more testimonials by making the ask effortless.
8. Product Launch Announcement Multi-Channel
Ask Business Chat 'Create a product launch announcement for [product name] with key features [list features]. I need versions for email (300 words), LinkedIn post (150 words), and internal Teams announcement (100 words).' One prompt, three channels covered.
Content Creation & Copywriting Prompts
9. Blog Post from Meeting Notes
After a Teams strategy meeting, use Copilot in Teams to generate a transcript summary. Then in Word, prompt 'Create a 600-word blog post from these meeting notes about [topic], targeting [audience], with an engaging introduction and 3 main sections.' Your meetings become publishable content.
10. Social Media Content Calendar
In Word, ask Copilot to 'Create a 30-day social media content calendar for [business type] with daily post ideas, recommended hashtags, and best posting times. Focus on [themes/topics].' Export to Excel for scheduling and tracking.
11. Landing Page Copy Framework
Use Copilot in Word to 'Draft landing page copy for [product/service] using the AIDA framework (Attention, Interest, Desire, Action). Target audience is [persona], main benefit is [benefit], include 5 bullet points and 2 testimonial placeholders.' Conversion-focused copy in minutes.
12. Case Study from Customer Emails
Use Business Chat to 'Find all emails with [customer name] discussing results and outcomes.' Then in Word, prompt 'Create a case study highlighting this customer's challenge, solution, and results based on these emails. Format with clear sections and pull quotes.' Turn email threads into marketing assets.
13. Product Description Variations
In Word, request 'Write 5 different product descriptions for [product] ranging from 50-150 words. Vary the tone: professional, casual, technical, benefit-focused, and storytelling.' Test different angles without the copywriting grind.
14. White Paper Executive Summary
Upload or reference your detailed white paper in Word, then ask Copilot to 'Create a compelling executive summary of this document in 250 words, emphasizing key findings and business implications for C-level readers.' Make your research digestible for busy executives.
15. FAQ Section from Support Emails
Use Business Chat to 'Summarize the top 10 customer questions from Outlook emails in the past 3 months about [product/topic].' Then in Word, 'Format these as an FAQ section with clear questions and detailed answers.' Your support emails become marketing content.
16. Press Release Draft
In Word, prompt 'Draft a press release announcing [news/event] following AP style. Include a compelling headline, dateline, 3-4 paragraphs covering who/what/when/where/why, a quote from [executive name and title], and boilerplate about [company].' Professional releases without the PR agency cost.
17. Video Script from Blog Content
Reference an existing blog post in Word and ask Copilot to 'Convert this blog post into a 2-minute video script with an attention-grabbing hook, three main points, and a clear call to action. Include [presenter name] speaking in a conversational tone.' Repurpose content across channels effortlessly.
18. Email Signature with Marketing Message
Ask Copilot in Word to 'Create 5 professional email signature variations that include [name, title, contact info] plus a rotating marketing message about [current campaign/offer]. Keep total under 100 words.' Turn every email into a marketing touchpoint.
Data Analysis & Reporting Prompts
19. Campaign Performance Dashboard
In Excel with your campaign data, prompt Copilot to 'Create a visual dashboard showing email open rates, click rates, and conversions by campaign. Include a pivot table and 3 charts highlighting top performers and trends.' Instant insights without pivot table expertise.
20. Marketing Budget Variance Analysis
Upload your marketing budget spreadsheet to Excel and ask Copilot to 'Compare planned vs. actual spending by category, calculate variance percentages, highlight categories over budget in red, and create a summary chart.' Know where your money goes without manual calculations.
21. Lead Source ROI Calculator
In Excel, request 'Create a formula to calculate ROI for each lead source using columns for Cost, Leads Generated, Conversion Rate, and Average Deal Value. Sort by highest ROI and create a bar chart.' Identify your best channels with mathematical precision.
22. Social Media Engagement Trends
Import social media metrics into Excel and prompt 'Analyze engagement trends over the past 6 months. Create a line chart showing likes, comments, and shares by platform. Identify the best-performing content types and recommend posting frequencies.' Data-driven social strategy in minutes.
23. Customer Acquisition Cost by Channel
Ask Copilot in Excel to 'Calculate Customer Acquisition Cost (CAC) for each marketing channel by dividing total channel spend by customers acquired. Create a comparison table and highlight channels with CAC below $X.' Optimize spending with clear visibility.
24. Content Performance Scorecard
In Excel with content metrics, prompt 'Create a scorecard ranking our content pieces by a weighted formula: 40% traffic, 30% engagement time, 20% social shares, 10% conversions. Format as a table with conditional formatting showing top and bottom performers.' Know what content works.
25. Marketing Funnel Conversion Analysis
Upload funnel data to Excel and ask 'Calculate conversion rates between each funnel stage (awareness → interest → consideration → purchase). Create a funnel chart and identify the biggest drop-off points with percentage decreases.' Find and fix your conversion bottlenecks.
26. Competitor Comparison Matrix
In Excel, request 'Create a competitive comparison matrix with [your company] vs. [3 competitors] across features [list features]. Use conditional formatting to highlight our strengths in green and gaps in yellow.' Position yourself competitively with visual clarity.
Presentation & Sales Deck Prompts
27. Pitch Deck from Business Plan
Reference your business plan document and ask Copilot in PowerPoint to 'Create a 10-slide investor pitch deck covering problem, solution, market size, business model, team, and ask. Use a professional template with minimal text and compelling visuals.' Turn documents into presentations instantly.
28. Quarterly Marketing Review
In PowerPoint, prompt 'Create a quarterly marketing review presentation with slides for: Q3 goals, campaign results (use data from [Excel file]), wins and learnings, Q4 strategy, and budget needs. Include speaker notes for each slide.' Executive-ready reviews without the PowerPoint struggle.
29. Product Launch Presentation
Ask Copilot in PowerPoint to 'Build a product launch presentation for [product name] including: market opportunity, product features, competitive advantages, pricing, go-to-market strategy, and success metrics. Target audience is [internal team/external partners]. Use 12-15 slides.' Launch with confidence and clarity.
30. Sales Training Deck
In PowerPoint, request 'Create a sales training presentation covering our value proposition, ideal customer profile, common objections and responses, demo flow, and closing techniques. Include interactive slide prompts for role-playing exercises.' Onboard sales reps faster with consistent training materials.
31. Webinar Slide Deck
Prompt Copilot in PowerPoint to 'Design a webinar presentation on [topic] for a 45-minute session. Include title slide, agenda, 5-7 content slides with key takeaways, Q&A slide, and CTA slide. Add speaker notes with timing suggestions for each section.' Professional webinars without the design headache.
32. Customer Success Story Presentation
Reference your case study document and ask PowerPoint Copilot to 'Create a 6-slide customer success story presentation: customer background, challenge, solution implemented, results with metrics, customer quote, and next steps for prospects.' Make your wins visual and shareable.
33. Marketing Strategy Presentation
In PowerPoint, prompt 'Build an annual marketing strategy presentation covering: market analysis, target audience personas, positioning, channel strategy, content plan, budget allocation, KPIs, and timeline. Use a modern template with data visualization.' Strategic planning made presentation-ready.
34. Speaker Notes from Slide Content
With an existing PowerPoint deck, ask Copilot to 'Generate detailed speaker notes for each slide that expand on the bullet points, include transition phrases, and suggest relevant examples to share.' Present with confidence even on complex topics.
Team Collaboration & Meeting Efficiency Prompts
35. Campaign Brainstorm Meeting Summary
After a Teams brainstorming session, use Copilot in Teams to 'Summarize this meeting, organize ideas by theme, identify the top 3 concepts with the most support, and create action items with owners.' Never lose a good idea in meeting chaos again.
36. Client Feedback Consolidation
Use Business Chat to 'Search all Teams channels and SharePoint for client feedback about [product/feature] from the past quarter. Summarize common themes, positive feedback, and pain points.' Aggregate scattered insights into actionable intelligence.
37. Marketing Campaign Project Plan
In Copilot Pages, prompt 'Create a project plan for our [campaign name] including timeline, key milestones, deliverables, team responsibilities, budget line items, and success metrics. Format as a collaborative document the team can edit.' Collaborative planning in one shared AI workspace.
38. Post-Meeting Action Items Email
After a Teams meeting, ask Copilot to 'Draft an email to all attendees summarizing decisions made, action items with owners and deadlines, and open questions needing follow-up.' Keep everyone aligned without manual note-taking.
39. Content Approval Status Report
Use Business Chat to 'Show me the status of all content pieces in [SharePoint folder] or [Teams channel] awaiting approval, recently approved, or needing revisions.' Get instant visibility without checking multiple locations.
40. Competitive Intelligence Digest
Prompt Business Chat to 'Summarize all mentions of competitors [list names] from Teams channels, emails, and documents from the last month. What are their recent moves and how should we respond?' Turn scattered intelligence into strategic awareness.
41. Team Meeting Prep Brief
Before a recurring team meeting, ask Business Chat to 'What marketing priorities and updates were discussed in emails and Teams since our last meeting on [date]? Create a brief summary as meeting prep.' Walk into meetings informed and ready.
42. Campaign Retrospective Document
In Word, prompt 'Create a campaign retrospective template for [campaign name] with sections for: objectives, what worked, what didn't, key metrics, team feedback, and recommendations for next time.' Build organizational memory and continuous improvement.
Marketing Operations & Planning Prompts
43. Marketing Calendar Template
Ask Copilot in Excel to 'Create a 12-month marketing calendar template with columns for date, campaign name, channel, target audience, owner, budget, and status. Include conditional formatting for upcoming deadlines and completed items.' Organize your entire marketing year visually.
44. Content Audit Spreadsheet
In Excel, request 'Build a content audit template with columns for: content title, URL, publish date, last update, traffic (last 30 days), conversions, current status, and action needed. Add formulas to identify content older than 12 months or underperforming.' Know what content needs attention.
45. Vendor Comparison Analysis
Upload vendor proposal documents to Business Chat and prompt 'Compare these three marketing software vendors across pricing, features, integration capabilities, and support. Create a summary recommendation.' Make procurement decisions faster with AI-assisted analysis.
46. Brand Voice Guidelines Document
In Word, ask Copilot to 'Create a brand voice guidelines document for [company name] defining our tone (professional/casual/authoritative), vocabulary to use and avoid, example phrases, and before/after writing samples for common scenarios like emails, social posts, and web copy.' Ensure consistent messaging across your team.
47. Marketing SLA Document
Prompt Word Copilot to 'Draft a marketing service level agreement for internal stakeholders covering: request submission process, turnaround times by project type, revision policy, priority criteria, and escalation procedures.' Set clear expectations and reduce constant interruptions.
48. Influencer Outreach Tracker
In Excel, request 'Create an influencer outreach tracking spreadsheet with columns for influencer name, platform, followers, engagement rate, outreach date, response status, collaboration type, and cost. Include formulas for engagement rate calculations and status filtering.' Manage influencer relationships systematically.
49. Marketing Policy and Procedures Manual
Ask Word Copilot to 'Create a marketing operations manual covering: brand asset approval process, content publishing workflow, social media guidelines, vendor management, budget request procedures, and emergency communication protocols.' Onboard team members faster with documented processes.
50. Campaign Budget Request Template
In Word, prompt 'Design a campaign budget request template including: campaign overview, target audience, objectives, detailed budget breakdown by line item, expected ROI, timeline, and approval signature section.' Standardize requests and speed approvals.
51. Marketing Technology Stack Documentation
Use Copilot in Word to 'Create documentation of our marketing technology stack listing each tool, purpose, owner, cost, integrations, login information location, and renewal date. Include a visual diagram showing how tools connect.' Keep your martech organized and accessible.
52. SWOT Analysis for New Market
In Word or PowerPoint, request 'Create a SWOT analysis (Strengths, Weaknesses, Opportunities, Threats) for entering [new market/launching new product]. Format as a 2x2 matrix with bullet points in each quadrant and a summary paragraph of strategic implications.' Strategic planning made faster and more thorough.
💡 Pro Tips from an MCT
- Always provide context in your prompts: specify your audience, desired tone, word count, and format. Copilot delivers better results when you're specific about what you need.
- Use Business Chat to search across your entire Microsoft 365 environment before creating new content. You likely already have emails, documents, or meeting notes containing the information you need.
- Chain prompts across applications for compound productivity gains. Start with Business Chat to find information, move to Word to draft content, then use Outlook to distribute it—each step takes minutes instead of hours.
- Save your best-performing prompts in a OneNote notebook organized by task type. Small business owners who document their prompts create a reusable productivity system worth thousands in time savings.
- Invest 30 minutes learning keyboard shortcuts for Copilot in each app (Alt + I in most Office apps). The faster you can invoke Copilot, the more seamlessly it fits into your workflow and the more time you'll actually save.
Want Your Team Using These Prompts by Friday?
I deliver hands-on Copilot training (MS-4018, MS-4019) where your team walks out with a custom prompt library for your actual workflows. Not theory—practical skills they'll use Monday morning. Custom AI solutions in 90 days. You own the IP.
Book Copilot Training