Demo · placeholder archive

Substack reorganisation audit

A placeholder archive of 24 essays in 3 series runs through the same audit a real publication would: one row per post, a 4-tag scheme with membership rules, a series index, and every rule scored as a live PASS/FAIL formula. Change a yellow cell and the Checks sheet re-scores. No client content is used.

24
posts audited
4
tags in the scheme
3
recurring series indexed
12
posts flagged for work

What the workbook decides

CheckRuleSample result
Every post taggedno blank proposed tag3 untagged
Tags from the schemeproposed tag must exist in Tag scheme0 off-scheme
Byline consistentevery byline equals the standard8 drifted
Every post has an imageno missing header image4 missing
Tag balancelargest tag under 60% of posts29%

Download the workbook   audit_report.json

Deliverables on a real engagement

  1. The audited workbook with the author's decisions in the yellow cells
  2. The applied reorganisation: tags, series index pages, homepage sections, navigation, standardised titles and images
  3. A before/after URL and subscriber check proving nothing was lost
  4. The maintenance guide