A Demonstration on How Copilot Helps Preparing a Marketing Campaign
Scenario
As a marketing executive, you’re launching a Q3 product awareness campaign and need to plan, create, and track performance across tools like Word, Excel, and PowerPoint. Microsoft Copilot lay down the credentials for a campaign with target results, and how it works across Microsoft 365 apps:
Preparing a Marketing Campaign with Target Results
In Word: Campaign Brief Drafting
Prompt:
Copilot, draft a marketing campaign brief for our new product launch targeting B2B clients in the legal sector. Include campaign goals, key messages, channels, timeline, and KPIs.
Marketing Campaign Brief – Q3 Product Awareness
- Campaign Objective: Raise awareness of our new compliance dashboard among legal firms.
- Target Audience: Decision-makers in mid-sized law firms (IT, compliance, operations).
- Key Message: “Stay audit-ready with real-time compliance visibility.”
- Channels: LinkedIn, email marketing, webinars, paid search
- Timeline: July–September
- KPIs:
- 2,000 landing page visits
- 150 demo bookings
- CTR of 2.5% on paid ads
- Email open rate of 25%
In Excel: Budget & KPI Tracker
Prompt:
Copilot, create a marketing campaign budget and performance tracker. Include rows for channels, cost, and expected results.
Copilot creates:
- LinkedIn Ads: Budget £3,000 | Expected Leads: 50 | Target CTR: 2.5%
- Email: Budget £500 | Expected Leads: 30 | Target CTR: 25% open
- Google PPC: Budget £2,000 | Expected Leads: 70 | Target CTR: 3.0%
Bonus: Copilot offers conditional formatting to flag underperformance or budget overruns.
In PowerPoint
Prompt:
Copilot, create a 5-slide presentation from the brief for Monday’s leadership meeting.
Slides include:
- Campaign Overview
- Target Audience & Messaging
- Marketing Channels & Timeline
- Expected Results & KPIs
- Budget Breakdown
Outcome
For you, Copilot rapidly turns your campaign idea into a structured, measurable plan, backed by data and ready to present.
LANIX - If you’d like this example tailored to another scenario, feel free to connect with us. Contact: Richard Cheng, Director for Smart Services.
