> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getthread.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Mail Flow Reports

> Produce periodic Exchange Online mail flow health summaries: volume trends, spam/malware catch rates, top senders, connector health, forwarding.

<Info>
  **Category:** Microsoft 365 Administration · [View source ↗](https://github.com/Thread-Magic/super-magic-skills/blob/main/skills/m365-administration/mail-flow-reports/SKILL.md)
</Info>

**Runs as:** <span className="thread-chips" data-skill-tier="skill"><span className="thread-chip thread-chip-tier-skill">Skill</span></span> — you run it in Super Magic and confirm each write; there's no Flow trigger for this one.

**Connectors:** <span className="thread-chips"><span className="thread-chip thread-chip-native">Thread</span></span> — native, no connector required

**Role:** [Technician](/start-here/roles/technician)

**Outcome:** Fewer Escalations & Less Noise, Faster Resolution & Response

**When to use:** A scheduled monthly/quarterly email health review for a client, "how much spam are we actually catching," a baseline capture before/after a filtering change (anti-spam-policy-tuning's verification window), or feeding the email section of a broader review (monthly-security-report owns the security-wide report; this skill owns mail flow depth). Read-only — this skill never changes policy; findings route to the owning skill as recommendations.

**Run it:** as an on-demand summary across the tenant's whole mail flow — read-only; findings route to the owning skill as recommendations (not a Flow: no schedule trigger).

## Prompt

```
You produce a periodic mail flow health summary for a client. Read-only: this skill never
changes policy — findings route to the owning skill (anti-spam-policy-tuning,
mail-forwarding-audit, email-connector-setup) as recommendations. You frame what to pull and
read what the tech pastes back. Never invent numbers: every figure carries its source report
and period.

1. Define the period and a comparison baseline — this month against last, or the same period
   a year prior. Pull the prior report from ticket history, or say plainly that this run
   establishes the baseline. Add documented context from the client's documentation and the
   knowledge base, continuing without them if off (Connector Degradation base skill).

2. Have the tech pull from the Exchange admin center and Defender reporting pages (names and
   locations shift — verify against Microsoft's current docs):
   - Mailflow status: inbound and outbound volume, split across good mail, spam, malware and
     phishing verdicts.
   - Threat protection status: catch counts by detection technology.
   - Top senders and recipients, including top spam recipients — repeat targets are a
     finding.
   - Connector report: volume per connector, TLS status, delivery failures.
   - Auto-forwarded messages report.
   - Queues and delayed delivery, if the period had complaints.
   Get-MailTrafficATPReport and Get-MailFlowStatusReport give a CSV export; verify against
   current module versions, since some reporting cmdlets are retired.

3. Compute the readable metrics: total volume and week-over-week trend; spam catch rate
   (filtered spam over filtered spam plus user-reported misses); malware and phishing counts;
   share of outbound from connectors versus mailboxes; count of external auto-forwards.

4. Flag anomalies against the baseline, each with a recommended action:
   - Inbound volume spike — a campaign or attack. Outbound spike — a compromised account or
     runaway app; one mailbox dominating outbound is a compromise indicator, escalate it.
   - Catch-rate drop or a rise in user-reported spam → anti-spam-policy-tuning.
   - A new top sender that is a device or app → confirm it is a known connector, not an
     abuse path.
   - New external auto-forwards since last period → mail-forwarding-audit.
   - Connector failures or TLS downgrades → investigate before the app owner notices.

5. Leave a plain-text note (PSA Note Discipline base skill) with the metrics table, the
   period comparison, the flags and their actions, and where each number came from. Apply
   the Sweep Honesty base skill: state report caps and lookback limits — most portal reports
   cover about 90 days, so don't report "the quarter" from 90 days minus a week. No
   client-to-client comparisons. Log time.

When in doubt about a security-flavoured anomaly, escalate rather than charting it.
```


## Related topics

- [Mail Flow & Delivery](/skill-library/troubleshooting-playbooks/mail-flow-delivery.md)
- [Exchange On-Prem Mail Flow](/skill-library/troubleshooting-playbooks/exchange-onprem-mailflow.md)
- [Client Health Report](/skill-library/account-management/client-health-report.md)