Compute Baseline
SkillMonitoring & opsComputes substacker's rolling 4-week baseline for open rate, click rate, views-per-send, and weekly subscriber delta using corpus/stats/ archived CSVs. Produces per-metric z-scores of the current week against the baseline and flags cold-start windows where fewer than 4 prior weeks exist. Use after ingest-substack-csv each Monday. Trigger keywords — baseline, rolling median, z-score, cold start, per-metric comparison.
Available today. Use it from your connected AI after setup.
No other account needed.
Connect ahel once, and every AI you use reads what you have installed.
Then ask your AI: use the Compute Baseline skill
What this skill tells your AI
The instructions your AI receives, as published by lyndonkl/claude in skills/compute-baseline/SKILL.md and read by ahel’s review.
Workflow
Per week:
- [ ] Step 1: Load last 4 weekly CSVs from corpus/stats/
- [ ] Step 2: For each metric (open_rate, click_rate, views_per_send, weekly_sub_delta):
- Compute 4-week median
- Compute trimmed median (drop 1 outlier)
- Compute IQR
- [ ] Step 3: z-score = (current - median) / IQR
- [ ] Step 4: If <4 weeks in history, return baseline: not-yet-established
- [ ] Step 5: Emit baseline object per metric with confidence flag
Baseline object schema
{
"open_rate": {"current": 0.47, "median_4w": 0.49, "trimmed_median": 0.49, "iqr": 0.03, "z": -0.67, "confidence": "medium"},
"click_rate": {...},
"views_per_send": {...},
"weekly_sub_delta": {...},
"cold_start": false
}
Confidence: high if 4+ weeks and low IQR. medium if 4+ weeks and typical IQR. low if N<4.
Guardrails
- Only compare writer's own trajectory. Never pull external benchmarks.
- Below N=4, return cold-start flag. Report writes "baseline not yet established" rather than noisy averages.
- IQR-based comparisons (not σ-based) for robustness at small N.
- Outlier handling: use trimmed median to blunt a single extreme week.
- |z| ≥ 1.0 is the "material move" threshold used downstream by
attribute-performance. - Don't recompute baselines for prior weeks. Each week's baseline is from that week's trailing 4.
Signals
- GitHub stars
- 158
- Forks
- 23
- Last commit
- Sep 2026
Advanced
- Catalog kind
- skill
- Gateway key
compute-baseline- Source
- github.com/lyndonkl/claude