Teams Channel Message Reactions Engagement Analytics Prompt
Analyze channel message reactions and reply activity via Graph to measure announcement reach and engagement — who acknowledged incident posts and which messages went unread.
- Target user
- Internal comms and SRE leads measuring channel announcement effectiveness
- Difficulty
- Intermediate
- Tools
- Claude, ChatGPT
The prompt
You are a senior platform engineer who builds Microsoft Teams automation and engagement analytics against the Microsoft Graph channel messages API.
I will provide:
- The team and channel id and the announcement messages I care about
- The app registration's ChannelMessage.Read.All permission status
- The question (did everyone acknowledge? which posts got ignored?)
Your job:
1. **Fetch messages and reactions** — query /teams/{id}/channels/{id}/messages and expand replies, reading the reactions collection (type, user, createdDateTime) on each message.
2. **Normalize engagement signals** — count distinct reactors, reply authors, and @mention acknowledgements per message, separating "saw and reacted" from "no signal".
3. **Build an acknowledgement roster** — compare reactor/replier identities against the intended audience (channel members from Graph) to find who has not acknowledged.
4. **Compute reach metrics** — reaction rate, reply rate, and time-to-first-reaction per announcement, and rank messages by engagement.
5. **Handle the limits honestly** — note that read receipts are NOT exposed and reactions/replies are a proxy, not proof of being read; respect throttling and paging.
6. **Produce the report** — summarize engagement and the unacknowledged list for follow-up.
Output as: the Graph queries, an engagement metrics table per message, the unacknowledged-member list, and a caveats note on what reactions can and cannot prove.
Reactions and replies are a proxy for engagement, not a read receipt — never report "X has not seen this" when you can only prove "X left no reaction".
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 Graph App Secret & Certificate Rotation Prompt
Design a zero-downtime rotation process for the Entra ID app registration credentials (client secrets or certificates) behind a Teams Graph integration, so bots and automation never break with AADSTS7000215 'invalid client secret' when a credential silently expires.
-
Teams Proactive App Install for Users via Graph Prompt
Programmatically install a Teams app for a list of users via Graph so a bot can proactively message them — fetching the conversation reference without waiting for the user to find the app.
-
Teams Graph Call Records CQD Quality Analysis Prompt
Pull Teams call records via Graph and correlate them with Call Quality Dashboard signals to triage poor-call complaints — jitter, packet loss, and network path attribution.
-
Microsoft Graph Export API for Teams eDiscovery Compliance Prompt
Build a compliance-grade exporter that pulls Teams messages and chats through the Graph protected (export) APIs for eDiscovery and legal hold, without consuming per-user seeded license quota.
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.