Turn merchant data into QBR scorecards you can share

Merchant QBR AutoPilot helps account teams generate one merchant scorecard, batch scorecards from a OneDrive CSV or TSV, organize outputs in OneDrive, and share the package with stakeholders.

Start inside Microsoft 365 Copilot

Copy one of these prompts into the Merchant QBR AutoPilot agent. Use starter data to see the flow, or point the agent at your own OneDrive file when you are ready.

Generate QBR scorecards for every merchant in my OneDrive file
Generate an executive QBR deck in PowerPoint from a sample Excel file
Show sample merchants
⚙ Prepare
One merchant or batch
Step 1
💬 Choose your data path

Use a sample merchant, save starter data to OneDrive, paste CSV rows in chat, or search for your own OneDrive CSV/TSV by file name.

"Use my OneDrive merchant file" or "Use starter data"
Step 2
📊 Generate scorecards

Create PowerPoint scorecards for one merchant or every merchant in the file, with validation details for rows that need attention.

$8.84M
Total GMV
91.3%
Auth Success
2.14%
Cost of Accept.
Try it in Microsoft 365
Step 3
🗂️ Save to OneDrive

For own-data batches, the generated decks are saved in an organized OneDrive batch workspace next to the source file context.

Merchant QBR AutoPilot / QBR Workspaces / Batch Runs / 2026-Q2
📊 PowerPoint 📄 CSV / TSV source 🧾 Batch status
Step 4
📦 Package the batch

After scorecards are generated, create a ZIP bundle in the same OneDrive workspace so the batch is easy to download or share.

  • One ZIP package — all generated merchant PowerPoint scorecards in one place
  • OneDrive-hosted link — easier to revisit than temporary generated-file URLs
  • Batch summary — source file, generated count, and included merchants ready for review
🤝

Review and share

You have the scorecards, the batch workspace, and the ZIP bundle ready for internal review or merchant-facing QBR prep.

AI prep
Review
AI follow-up
✔ Share
Email-ready output
Step 5
✉️ Draft the summary email

When the ZIP is ready, open a short Outlook draft with the batch summary and OneDrive ZIP link included.

  • Source named — the merchant data file is listed for context
  • Generated count included — stakeholders can see how many scorecards are ready
  • ZIP link included — recipients can download the scorecard package
  • You stay in control — add recipients, review, and send from Outlook