Skip to main content
method#258created 2026-10-27updated 2026-10-29

Turn a weekly ticket export into a themed summary

Group last week's tickets by theme with counts and one quote each, urgent and overdue first, and reuse the same request every week.

Steps

  1. Export last week's tickets from the help desk as a CSV; keep the message, status, priority and waiting-time columns.
  2. Ask for three things only: themes with counts, one word-for-word quote per theme, and urgent or overdue tickets on top with wait time.
  3. Define urgent in the request: high priority, past the target, or an angry or repeat customer.
  4. Check every count and quote against the file before sharing; a person still decides the replies.
  5. Reuse the same request, or a skill holding it, on next week's export so the summary keeps the same shape.

Source for the personal app publish/22-weekly-ticket-summary (video piece weekly-ticket-summary, Series A1).

Published from this note