12 of My 127 Posts Are Gone and I Can't Tell Tests From Failures

Описание и применение

Автор обнаружил, что один статус "removed" скрывает различие между тестовыми удалениями и удалениями платформой, что мешает анализу. Решение – добавить поле причины удаления.

Задача

The author’s single "removed" status flag conflates test deletions and platform takedowns, preventing meaningful analysis of post loss reasons.

Результат

By adding a reason field, the author can distinguish between intentional deletions and platform-initiated removals, enabling actionable insights and preventing misleading metrics.

Рабочий процесс

• 1. Identify removed posts in the status table. 2. For each removed post, record the reason: "my own smoke test", "platform removed it", or "rewritten and republished". 3. Update the table schema to include a second field for removal reason. 4. Review the list of removed posts to assess patterns and adjust publishing strategy.

Доказательства

The table has exactly one status for a post that is no longer live: removed. That single flag is carrying a lie.

Источник

I recorded the event, never the reason

Источник

The honest count is not "12 removed." It is the number of removed posts where I recorded why: zero.

Источник

So the fix is a second field, not a bigger table.

Источник