How to Measure Whether Copilot Is Paying for Itself

To measure whether Copilot is paying for itself, compare each licensed person's time saved on a few recurring tasks with the licence cost, about $21 a month. Time those tasks before rollout, confirm real use in the admin centre's usage report, then re-time them after six weeks. Treat Microsoft's "assisted hours" estimate as a signal, not a saving.

The bar is low: at a staff cost of $30 an hour, a $21 licence breaks even at 42 minutes saved a month. So for most heavy users the question isn't really "does it pay?" but "which licences are sitting unused, and which people would save more if they used it differently?" The measurement below is built to answer those two questions with about an hour of work a month.

Follow me on Instagram@sagnikteaches

Stage 1: Time five recurring tasks before anyone has a licence

Time needed: 30-45 minutes per person, spread over a week.

Connect on LinkedInSagnik Bhattacharya

Without a baseline, every later number is a guess. Ask each person who will get Copilot to list five tasks they do every week and time them, roughly, for one week. Pick tasks that Copilot could plausibly help with: email triage, meeting notes, drafting routine letters, pulling figures into a summary, finding a document. Our tutorial on setting a baseline before you introduce AI covers the method in general; here's the version for Copilot.

Subscribe on YouTube@codingliquids

An illustrative baseline for a funeral director's office manager, one of five people getting licences in a 14-person business with two branches:

If you've already rolled out Copilot, you can still build a baseline: have one or two people do the same tasks without Copilot for a week. It's less clean, but far better than nothing.

If people struggle to list their recurring tasks, Copilot itself can help once it's licensed. An illustrative prompt and reply:

Prompt: "Look at the emails I've sent in the last two weeks.
Group them into types of recurring task, with a count for
each type. Don't include personal emails."

Illustrative reply:
- Supplier and venue confirmations: 38
- Replies to families about arrangements and timings: 21
- Staff rota changes: 14
- Invoice queries with the finance team: 9
- Price list requests: 6

What you'd check: the counts are approximate, and the categories are Copilot's guesses. Use it as a prompt for the baseline list, not as the baseline itself.

Stage 2: Decide what "paying for itself" means for you

Time needed: 15 minutes, once.

Write down three numbers before looking at any report:

1. Cost per licence per month. $21 on annual commitment, $18 if you bought on the promotion before 31 December 2026, $25.20 if billed monthly, or the bundle difference if you bought Business Standard with Copilot. Our tutorial on Microsoft 365 Copilot pricing has each figure.
2. Hourly cost of each licensed person. Pay plus on-costs. Use a real figure, not a flattering one.
3. Break-even minutes. Licence cost divided by hourly cost, times 60. At $21 and $30 an hour, 42 minutes a month.

Then add one quality measure that matters in your business, such as how quickly families or customers get a reply, or how many supplier emails need chasing. Time saved that makes the work worse isn't a saving.

Stage 3: Check who is actually using it

Time needed: 10 minutes a month.

In the Microsoft 365 admin centre, go to Reports, then Usage, and under Reports choose Microsoft Copilot, then Copilot. Microsoft's documentation describes what you'll see:

• Enabled users, active users and active users rate over the last 7, 28, 90 or 180 days. Active means the person did something intentional, such as submitting a prompt. Just opening the Copilot pane in Word doesn't count.
• Prompts submitted, in total and per active user.
• A per-person table with prompts submitted, active days and the last date each person used Copilot in Teams, Outlook, Word, Excel, PowerPoint and elsewhere.

Two details matter for small businesses. User names are hidden by default in usage reports; an admin has to choose to show user details to see who is who. And data for a given day typically appears within 48 hours, so check on a Wednesday for the previous week. The per-person table can be exported as a CSV file from the report's menu, which makes filling in a monthly tracker a two-minute copy and paste rather than retyping figures from the screen.

An illustrative 28-day view for the funeral director's five licences:

Branch manager B is the obvious question. Low use isn't always a lack of value; it may be that nobody showed her how Copilot fits her day. Talk to her before deciding anything. Ask what her week looks like and where she spends time on email and meetings; the answer usually points to one or two uses she hasn't tried.

Stage 4: Read the Copilot Dashboard with a sceptical eye

Time needed: 15 minutes a month.

Microsoft's Copilot Dashboard lives in the Viva Insights web app. According to Microsoft Learn, any Microsoft 365 business or enterprise customer can use it; you don't need a paid Viva Insights licence, and with at least one Copilot licence you get adoption and impact pages. Some features, such as benchmarks and group-level data, need 50 or more Copilot or Viva Insights licences, which most small businesses won't have. Global admins have access; others need it granted.

The figure that gets quoted is Copilot assisted hours. Microsoft describes it as an estimate of time employees were assisted over the past 28 days, calculated from Copilot actions multiplied by factors from Microsoft's own research, and says it should be viewed as a general estimate. Next to it, Copilot assisted value multiplies those hours by an hourly rate that defaults to $72. You can change the rate in the dashboard's value calculator, and you should, to your own staff cost.

Four cautions from Microsoft's documentation that matter in a small team:

• Small groups are hidden. To protect privacy, metrics aren't shown for groups below the minimum group size. With five licences, many breakdowns will show "--".
• Some metrics need optional diagnostic data. Assisted hours, emails sent using Copilot and meetings summarised need optional diagnostic data switched on for comprehensive figures.
• Satisfaction needs volume. The satisfaction rate only appears with at least 30 feedback responses from at least five people in a rolling 28 days.
• Data lags. The dashboard covers the previous 28 days, with up to a six-day delay.

Microsoft's own documentation also notes that Copilot is unlikely to be solely responsible for changes in the dashboard's metrics, since seasonality and role changes play a part. That's the right frame. The dashboard tells you whether use is growing and which features people use. It doesn't tell you what you saved.

Stage 5: Re-time the same tasks after six weeks

Time needed: 30 minutes per person, once, then 10 minutes a month.

Ask each person to re-time the Stage 1 tasks for one normal week, using Copilot wherever it helps. Also ask four quick questions, which work better than any dashboard for five people:

Copilot check-in (2 minutes)
1. Which of your five tasks does Copilot now help with?
2. For each, roughly how many minutes does it save a week?
3. What did Copilot get wrong this month, if anything?
4. What would you use it for if you knew how?

An illustrative before-and-after for the office manager's Monday branch meeting:

• Before: types notes during the meeting, then spends 30 minutes turning them into minutes and an action list, and sometimes misses who agreed to what.
• After: the meeting is recorded and transcribed; she reviews Copilot's recap, corrects one action assigned to the wrong branch manager, adds a decision taken after the recording stopped, and sends it. About 8 minutes.

That's 22 minutes a week, about 88 a month, from one task. The correction step matters, though. Keep it, and count its time.

Stage 6: Do the sum person by person

Time needed: 20 minutes, monthly for the first quarter, then quarterly.

Put each person's measured saving against their break-even figure. Halve the self-reported time saved to allow for optimism; if the licence still pays after halving, you can be confident. An illustrative month for the funeral director:

Across the five licences, $105 a month of cost against about $321 of halved value. The overall return looks healthy, but the average hides one licence that isn't working and one that's marginal. That's the point of doing it per person.

Stage 7: Act on it before the renewal date

Time needed: an hour at each decision point.

• Coach before you cut. Branch manager B gets 30 minutes with the office manager, showing the three prompts that save her the most time. Recheck in a month.
• Reassign rather than waste. Copilot Business is an annual commitment, so you can't simply cancel a licence mid-term. You can unassign it and give it to someone else who clears the thresholds.
• Fix the marginal ones. The finance administrator's saving is mostly email. If Copilot in Excel isn't helping with the monthly figures, find out why; often the data isn't in a clean table, which is a spreadsheet fix, not a Copilot one.
• Decide at renewal, not before. Use three months of per-person sums to set next year's licence count.

Measuring more than minutes

Time saved is the easiest number to collect, but it isn't always the one that matters most. Pick one outcome measure per role and track it alongside the minutes. Three illustrative examples:

• Office manager: how long families and venues wait for a reply. Before Copilot, emails that arrived after 3pm were often answered the next morning. After, the median reply time for the shared inbox fell from about five working hours to under two, measured by sampling 20 threads a month.
• Branch managers: actions from the Monday meeting completed by Friday. When actions arrive in writing within ten minutes of the meeting instead of the next day, more of them get done that week.
• Finance administrator: the number of supplier invoices that need a second chase. If Copilot drafts clearer queries first time, chasers fall.

These don't go into the ROI sum as dollars, and they don't need to. They're the answer when someone asks "is it actually making the work better?", and they catch the case where minutes are saved but quality slips.

A worked first quarter

Here's how the funeral director's numbers might move over three months, using the halved-value method from Stage 6:

Over the quarter, $903 of cautiously valued time against $615 of cost including setup, with the monthly gap widening as use settles. The setup cost doesn't recur, so month four onwards looks like month three. That's the shape to expect: a slow first month, a clear picture by the third.

Keep the monthly figures in one simple sheet so the trend is visible at renewal:

Month | Person | Active days | Minutes saved (reported) |
      | Minutes saved (halved) | Hourly cost | Value |
      | Licence cost | Outcome measure | Note

One row per person per month is enough. By renewal you'll have 12 rows for each licence, which is a far better basis for the next year's licence count than anyone's impression.

Five ways Copilot ROI gets measured wrong

1. Quoting the dashboard's assisted value as savings. An illustrative owner sees "38 Copilot assisted hours, $2,736 assisted value" and tells the team Copilot has saved $2,700 a month. The value uses the $72 default rate, and assisted hours measure time Copilot was involved, not time freed up. At the business's real $30 rate and a cautious view of how much of that time was saved, the figure is a fraction of that.
2. Measuring in week two. People are still learning. Early numbers understate the saving for keen users and overstate it for people trying everything once.
3. Counting activity as value. 200 prompts a month could mean heavy, useful use, or someone asking the same question five ways. Pair usage with the re-timed tasks.
4. Ignoring the correction time. If a recap takes 8 minutes to check and fix, the saving is the original 30 minutes minus 8, not 30.
5. Crediting Copilot for a quiet month. If the office was less busy in August, tasks take less time regardless. Compare like-for-like weeks where you can.

For the general method behind these numbers, read how to calculate AI ROI with a worked example and how to measure time saved after rolling out AI. If you're still deciding whether to buy licences, start with is Microsoft 365 Copilot worth it for a small business?, and for the tasks that usually produce the biggest measured savings, see triaging email and drafting replies with Copilot in Outlook.

Measuring Copilot: questions that come up

How long should I wait before judging Copilot's return?

Give it six to eight weeks after licences are assigned. The first fortnight is mostly people learning what to ask, and Microsoft's Copilot Dashboard needs data from several weeks to show trends. Check usage after two weeks to catch anyone who hasn't started, but don't make keep-or-cancel decisions until the second month.

Can I see what individual staff asked Copilot?

The admin centre usage report shows per-person activity such as prompts submitted, active days and last activity date in each app, once you choose to show user details, which are hidden by default. It doesn't show prompt content. Audit data for security and compliance is a separate area, and monitoring staff has legal and trust implications, so take advice before going further.

What's a good active-user rate for Copilot?

In a small business where you licensed people deliberately, aim for every licensed person to be active most weeks. The admin centre shows an active users rate over 7, 28, 90 or 180 days. Anything under about 80% over 28 days means some licences are going unused and should be reassigned or reviewed before renewal.

Further reads

• AI KPIs for Small Businesses: 12 Metrics Worth Tracking — Other metrics worth tracking beyond time saved.
• Copilot in Teams Meetings: Recaps, Actions and Privacy Settings — Meeting recaps are often the biggest measured saving.
• How Soon Should AI Pay for Itself? Payback Periods by Project — Realistic payback periods to compare against.
• Did Your AI Pilot Work? How to Set Success Criteria That Hold Up — Set pass marks that hold up at renewal time.
• Copilot Chat vs Microsoft 365 Copilot: What Do You Get Free? — What staff keep if you remove a licence.
• How to Review an AI Tool After 90 Days: Keep, Fix or Cancel — An evidence pack, a ten-point scoring sheet, a worked split verdict for four Copilot seats and a checklist for cancelling without loose ends.
• How Much Does AI Cost a Small Architecture Practice per Month? — Priced line by line: assistants, model-aware rendering, meeting notes and automation, with monthly budgets for one, five and twelve-person practices.
• Why AI Adoption Stalls in Accounting Firms, and How to Restart It — The five reasons AI stalls in accounting practices, a twenty-minute diagnosis, and a 30-day restart timed around the deadline calendar.
• How to Calculate the ROI of an AI Automation Before You Build It — A nine-step pre-build ROI method, a copyable worksheet, a roofing contractor's quote follow-ups costed, and a removals firm's idea that failed the test.
• ChatGPT or Copilot for a Microsoft 365 Business? — Decide whether a Microsoft 365 team needs paid Copilot, ChatGPT or included chat, using a two-user cost and workflow trial.
• How to Roll Out Microsoft 365 Copilot to a Small Team — Start everyone on free Copilot Chat, license three heavy users for four weeks, then let the usage report decide who gets a seat. A café group shows how.
• How Much Does an AI Pilot Project Cost? — What a small-business AI pilot really costs, with a catering company's six-week pilot costed, three budget levels and the commitments that inflate it.
• Microsoft 365 Copilot Readiness Checklist for Small Businesses — Licences, mailboxes, update channels and SharePoint oversharing checks, each with how to verify it, plus a boutique hotel's filled-in results.
• Is Copilot Pro Worth It for a Sole Trader? — Copilot Pro is retired. The four options that replaced it for a one-person business, priced for a year, with the traps in a single-user Microsoft account.
• How to Hire a Microsoft 365 Partner for a Copilot Rollout — A funeral director's Copilot rollout, from seat sums to a 30-day pilot: how to pick a Microsoft partner, read its badges and avoid paying for idle seats.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: Microsoft Learn documentation for the Microsoft Copilot usage report in the Microsoft 365 admin centre and for the Microsoft Copilot Dashboard in Viva Insights (licence thresholds, 28-day window, data delay, assisted hours and value, minimum group size, satisfaction threshold, user categories), checked September 2026.