content-reconciliation

name	content-reconciliation
description	Issue reconciliation workflow — keeps GitHub Issues in your content repo in sync with actual Zernio/Late post status. Covers fuzzy matching, label updates, close logic, skip rules, and comment templates. Use when user says "reconcile issues", "sync posts to issues", "issue reconciliation", "match posts to issues", "pipeline sync", "update issue status from posts".

Content Reconciliation Skill

Keeps GitHub Issues in {{CONTENT_REPO}} in sync with actual Zernio/Late post status. Runs as a scheduled cron job (Mon + Thu mornings) and can be triggered manually.

Reconciliation Workflow

1. Pull posts — Paginate through late_list_posts for both scheduled and published statuses (at least 300-500 of each for good coverage).
2. Pull open issues — List all open issues from {{CONTENT_REPO}}.
3. Match posts to issues — Use fuzzy matching on:
   • Issue title vs post content/title (multi-word phrase overlap)
   • Topic-specific keyword matching (e.g., "mythos", "openshell", "copilot cli")
   • Issue number tags in posts (e.g., issue-197)
   • A match score threshold of ≥5 to avoid false positives.
4. Update matched issues:
   • Comment — Leave a structured comment with post IDs, platforms, dates, and status table.
   • Label — Set the correct status label:
     • status:published if any posts are published
     • status:scheduled if posts exist but none published yet
   • Remove stale status labels (status:draft, status:ready, ) when upgrading.