hoangsonww

monthly-review

Compile a month-over-month retrospective from Agent Monitor data — sessions, cost, token volumes, completion rate, top projects by working directory, and notable shifts versus the prior month. Uses daily_sessions/daily_events (365d) from analytics, the session list, and the pricing cost breakdown. Use when doing a monthly retrospective or planning the month ahead.

hoangsonww 956 221 Updated 4w ago

Resources

1
GitHub

Install

npx skillscat add hoangsonww/claude-code-agent-monitor/monthly-review

Install via the SkillsCat registry.

SKILL.md

Monthly Review

Generate a month-over-month productivity retrospective from Agent Monitor data.

Input

The user provides: $ARGUMENTS

This may be:

  • "this month" or empty (default: the current calendar month to date)
  • "last month" for the previous full calendar month
  • A specific month: "2026-02" or "February 2026"

The comparison period is always the immediately preceding calendar month.

Data Sources

Endpoint Returns
GET /api/analytics daily_sessions and daily_events (365d) for monthly bucketing and trends; tokens (total_input/output/cache_read/cache_write — baselines pre-summed); tool_usage (top 20); sessions_by_status
GET /api/sessions?limit=500 Sessions with started_at, ended_at, status, model, cwd, cost, and metadata (turn_count, thinking_blocks) — for per-project (cwd) grouping and completion rate
GET /api/pricing/cost total_cost and per-model breakdown (input/output/cache tokens, cost, matched_rule)

Report Sections

1. Month at a Glance

Compare the target month to the prior month in a table:

Metric This Month Last Month Change
Sessions N N ▲/▼ N%
Total Cost $X.XXXX $X.XXXX ▲/▼ N%
Tokens (in/out/cache) N N ▲/▼ N%
Completion Rate N% N% ▲/▼ N pts
Active Days N N ▲/▼

Derive monthly buckets from daily_sessions / daily_events. Completion rate =
completed sessions / total sessions for the month (from sessions_by_status and
the filtered session list).

2. Top Projects (by cwd)

Group the month's sessions by cwd. For the top 5–8 projects, list session count,
total cost, completion rate, and dominant model. Note any project that newly
appeared or dropped off versus last month.

3. Cost & Token Breakdown

From /api/pricing/cost, show cost per model and the dominant token type. Compute
cache hit rate = total_cache_read / (total_cache_read + total_input) and compare
to last month. Currency to 4 decimals.

4. Tool & Workflow Shifts

From tool_usage, highlight the tools that rose or fell most month-over-month, and
any new tool adopted. Flag rising error/Compaction activity if present.

5. Notable Shifts & Narrative

Three to five plain-language observations: what changed, why it likely changed, and
what it implies (e.g., "cost up 22% but sessions flat → heavier per-session work").

6. Focus for Next Month

Two to four prioritized, actionable goals grounded in the numbers above.

Output

  • Markdown report with emoji-light, scannable section headers.
  • Tables for all month-over-month comparisons; ▲ / ▼ for deltas.
  • Currency in USD to 4 decimals; tokens with thousands separators.
  • Lead with a 2–3 sentence executive summary, then the sections in order.
  • Cite only numbers returned by the API; if a month has no data, say so explicitly.