Teams Graph Usage Report Adoption Digest Prompt
Use the Microsoft Graph reports API to build a Teams adoption / usage digest — active users, message and meeting activity, app usage — and post it back into Teams as an Adaptive Card for platform owners.
- Target user
- M365 platform admins and internal tooling engineers
- Difficulty
- Advanced
- Tools
- Claude, ChatGPT, Cursor
The prompt
You are an M365 platform engineer who has built Teams adoption reporting from the Microsoft Graph reports API and delivered it as Adaptive Card digests inside Teams. I will provide: - The reporting cadence (daily/weekly/monthly) and period (D7/D30/D90/D180) - Which metrics matter (active users, messages, meetings, calls, app usage) - The admin channel to post to and who consumes it - Whether the tenant has the "display concealed user information" privacy setting enabled - Auth model (app registration with application permissions) Your job: 1. **API selection** — map metrics to the correct Graph endpoints: - `GET /reports/getTeamsUserActivityUserDetail(period='D7')` - `GET /reports/getTeamsUserActivityCounts(period='D30')` - `GET /reports/getTeamsDeviceUsageUserCounts(period='D7')` - `GET /reports/getM365AppUserDetail(period='D30')` where relevant Note these return CSV by default (302 redirect to a download) or JSON with `?$format=application/json`. 2. **Auth** — application permission `Reports.Read.All`, client-credentials flow, and why delegated flows are the wrong choice for a scheduled job. 3. **Data handling** — parse the CSV/JSON, handle the de-identified (`display concealed`) case where names become `AAAAA...`, and compute deltas vs the prior period for trend arrows. 4. **Card design** — Adaptive Card 1.5: - KPI header row (`ColumnSet`) with active users, messages, meetings and a trend arrow (up/down) per KPI - A small textual sparkline or top-movers `FactSet` - Segment breakdown (channel messages vs chat, web vs desktop vs mobile) - `Action.OpenUrl` to the full report in SharePoint/Power BI and `Action.ShowCard` for detail 5. **Delivery** — a scheduled Power Automate Workflow or bot posting the card; how to keep it under the ~28 KB card limit by summarizing and linking to detail. 6. **Reliability** — the reports endpoints are eventually consistent and can lag 24-48h; handle empty/partial periods gracefully, retry on 429 with `Retry-After`, and never post a "0 users" card caused by a not-yet-ready report. 7. **Trend intelligence** — flag anomalies (a sudden drop in active users, a spike in guest activity) rather than dumping raw counts. Output as: (a) the endpoint-to-metric mapping, (b) auth/permission setup, (c) the CSV/JSON parsing + delta computation outline, (d) Adaptive Card JSON, (e) the schedule + reliability plan, (f) anomaly-flagging rules. Bias toward: application permissions with least privilege, graceful handling of report lag and de-identification, and insight over raw dumps.
Run this prompt with AI
Test it, get an AI-improved version, or compare models — live in the Prompt Workspace. No copy-paste.
Related prompts
-
Teams Adaptive Card Backup Job Status Digest Prompt
Design a Microsoft Teams Adaptive Card that summarizes nightly backup job outcomes — success/failure counts, failed jobs with reason, RPO breaches, and restore-test status — for the platform team.
-
Teams Adaptive Card CVE Advisory Digest Prompt
Design a daily CVE / security advisory digest posted to Microsoft Teams as an Adaptive Card — severity grouping, CVSS badges, affected-asset counts, and drill-down actions for the security team.
-
Teams Adaptive Card Kubernetes CrashLoopBackOff Alert Prompt
Design a Microsoft Teams Adaptive Card that surfaces Kubernetes CrashLoopBackOff pod alerts with restart counts, last-termination reason, container logs snippet, and one-click remediation actions.
-
Teams Adaptive Card SSL Certificate Expiry Monitor Prompt
Build a Microsoft Teams Adaptive Card digest that warns on TLS/SSL certificate expiry — days-remaining thresholds, issuer/SAN details, per-service ownership, and a renew/acknowledge action.
More Microsoft Teams prompts & error guides
Browse every Microsoft Teams prompt and troubleshooting guide in one place.
Reading prompts? Get all 500 in one free PDF
500 battle-tested, copy-paste AI prompts engineered by a senior systems engineer — every one with fill-in placeholders and safety/back-out notes. Drop your email and it's yours.
- 500 prompts: Linux · Kubernetes · Terraform · OpenStack · GitLab · Docker · Monitoring · Incident Response
- Instant PDF download — yours free, forever
- Plus one practical AI-workflow email a week (no spam)
Single opt-in · unsubscribe anytime · no spam.