abderuslisted

# Abderus — Timing Sweep Check every time-sensitive obligation in the studio and surface what needs action today. ## Sources to read Read all of the following that exist: 1. `/media/data/dev/misc/upwork-proposals/context/portfolio/project-database.csv` — End Date, harvest status fields (Case Study, Blog Post, Testimonial Status) 2. `{CONTENT_DIR}/pipeline/triage-log.md` — inbound signals logged as "Investigate" with no follow-up recorded 3. Active project Asana mirrors — `.claude/asana-mirror.md` in each active project directory (paths from CLAUDE.md active projects table) Today's date is available from context. Use it to calculate days elapsed. ## Checks to run ### 1. Harvest gaps For every row in project-database.csv where End Date is set: - Calculate days since End Date - Flag if any of Case Study, Blog Post, or Testimonial Status is `none` or `draft` AND End Date was more than 14 days ago - Flag more urgently if End Date was more than 60 days ago Output per project: name, end date, days elapsed, which harvest items are missing. ### 2. Testimonial follow-ups For every row where Testimonial Status is `requested`: - Check if End Date was more than 21 days ago — if so, flag for a follow-up nudge - Note: do not flag if status is `received` or `published` ### 3. Stale triage entries In `{CONTENT_DIR}/pipeline/triage-log.md`, find any entry with: - Verdict: `Investigate` - No follow-up action logged (no subsequent entry for the same client) - Date more than 5 days a