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

# Bulletin list with air rate and sign-off state

> Powers the **TV/Radio bulletin status** table on the **Bulletins** screen.

Returns one row per bulletin ordered by `scheduled_at DESC`. Each row includes the slot, platform, story counts, computed `air_rate_pct`, and sign-off timestamps so the table can colour-code overdue reports.

`air_rate_pct` is `NULL` when a bulletin has no stories yet (upcoming slots).



## OpenAPI

````yaml /openapi/content.yaml get /api/v1/analytics/bulletins/daily
openapi: 3.0.3
info:
  title: Content Service API
  version: 1.0.0
  description: |2-

        **Content Service API** - Comprehensive content(story) and management system.
        
servers:
  - url: https://api.capedigital.co.ke/content
    description: Production
  - url: http://localhost:8000
    description: Local
security: []
paths:
  /api/v1/analytics/bulletins/daily:
    get:
      tags:
        - Bulletin Analytics
      summary: Bulletin list with air rate and sign-off state
      description: >-
        Powers the **TV/Radio bulletin status** table on the **Bulletins**
        screen.


        Returns one row per bulletin ordered by `scheduled_at DESC`. Each row
        includes the slot, platform, story counts, computed `air_rate_pct`, and
        sign-off timestamps so the table can colour-code overdue reports.


        `air_rate_pct` is `NULL` when a bulletin has no stories yet (upcoming
        slots).
      operationId: analytics_bulletins_daily_list
      parameters:
        - in: query
          name: date
          schema:
            type: string
          description: Calendar date in `YYYY-MM-DD` format (e.g. `2026-05-26`).
          required: true
        - in: query
          name: platform
          schema:
            type: string
            enum:
              - radio
              - television
          description: Broadcast platform. One of `television` (default) or `radio`.
      responses:
        '200':
          content:
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/DailyBulletin'
              examples:
                25May2026—TV:
                  value:
                    - - id: 018e2f3a-0000-7abc-8def-000000000001
                        platform: television
                        slot: morning
                        scheduled_at: '2026-05-25T07:00:00+03:00'
                        report_status: reviewed
                        editor_signed_off_at: '2026-05-25T08:12:00+03:00'
                        reviewed_at: '2026-05-25T09:45:00+03:00'
                        total_stories: 8
                        aired: 6
                        not_aired: 2
                        air_rate_pct: '75.0'
                      - id: 018e2f3a-0000-7abc-8def-000000000002
                        platform: television
                        slot: evening
                        scheduled_at: '2026-05-25T19:00:00+03:00'
                        report_status: draft
                        editor_signed_off_at: null
                        reviewed_at: null
                        total_stories: 0
                        aired: 0
                        not_aired: 0
                        air_rate_pct: null
                  summary: 25 May 2026 — TV
          description: ''
      security:
        - bearerAuth: []
components:
  schemas:
    DailyBulletin:
      type: object
      properties:
        id:
          type: string
          format: uuid
        platform:
          type: string
        slot:
          type: string
        name:
          type: string
        scheduled_at:
          type: string
          format: date-time
        editor:
          type: string
        presenters:
          type: array
          items:
            type: string
        report_status:
          type: string
        editor_signed_off_at:
          type: string
          format: date-time
          nullable: true
        reviewed_at:
          type: string
          format: date-time
          nullable: true
        total_stories:
          type: integer
        aired:
          type: integer
        not_aired:
          type: integer
        air_rate_pct:
          type: string
          format: decimal
          pattern: ^-?\d{0,4}(?:\.\d{0,1})?$
          nullable: true
      required:
        - air_rate_pct
        - aired
        - editor
        - editor_signed_off_at
        - id
        - name
        - not_aired
        - platform
        - presenters
        - report_status
        - reviewed_at
        - scheduled_at
        - slot
        - total_stories
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: 'Enter your JWT token in the format: Bearer <token>'

````