Bulletin Analytics
Bulletin report sign-off status breakdown
Powers the Reports pending KPI card on the Bulletins screen and the executive alert on the Overview screen (‘N bulletin reports pending sign-off’).
Returns report_status counts for both platforms. Frontend should sum report_status = awaiting_review across platforms to derive the alert count.
Report status values:
draft— editor has not yet signed offawaiting_review— editor signed off, head of news review pendingreviewed— head of news review completesigned_off— fully closed
GET
Bulletin report sign-off status breakdown
Authorizations
Enter your JWT token in the format: Bearer
Query Parameters
Period string. Accepted formats:
2026-05— calendar monthQ2-2026— quarter (Q1–Q4)YTD-2026— year to date
Previous
Today's bulletin KPI summaryPowers the **KPI card row** on the **Bulletins** screen.
Returns a single object with aggregate counts across all bulletins for the requested date:
| Field | Definition |
|---|---|
| `tv_bulletins` | Total TV bulletins scheduled on the date |
| `radio_bulletins` | Total Radio bulletins scheduled on the date |
| `reports_pending` | Bulletins with `report_status = awaiting_review` |
| `tv_avg_air_rate` | Aired ÷ (aired + not_aired) across all TV slots |
| `radio_avg_air_rate` | Same for Radio |
| `legal_holds_today` | Distinct stories held for legal reasons across all bulletins |
Next
Bulletin report sign-off status breakdown
