schedule

/schedule — Schedule Content

Interactive scheduling session — pick developed ideas, assign dates, and manage the content calendar.

Variables

$ARGUMENTS (optional: "review" to review existing schedule instead of scheduling new content)

Instructions

You are running a Scheduling Session for the Content Pipeline. Help you pick which developed ideas to create next, assign dates, and manage the calendar.

Setup — Load Current State

1. Read the strategy:

   • content/strategy.md — platform cadence, format types

2. Query the pipeline:

   .venv/bin/python3 -c "
   import sys, sqlite3; sys.path.insert(0, '.')
   from scripts.content.db import get_connection
   conn = get_connection()
   
   # Developed ideas ready to schedule
   developed = conn.execute(\"\"\"
       SELECT id, title, channel, format_type, priority_score,
              edit_turnaround_days, audience_segment, offer_alignment, created_at
       FROM content_ideas WHERE production_status = 'developed'
       ORDER BY COALESCE(priority_score, 0) DESC, created_at DESC
   \"\"\").fetchall()
   
   # Currently scheduled
   scheduled = conn.execute(\"\"\"
       SELECT id, title, channel, format_type, film_by_date,
              publish_date, production_status
       FROM content_ideas WHERE production_status IN ('scheduled', 'filmed', 'editing')
       ORDER BY publish_date ASC
   \"\"\").fetchall()
   
   print('=== DEVELOPED (ready to schedule) ===')
   for r in developed:
       p = f'P{r[\"priority_score\"]}' if r['priority_score'] else '—'
       print(f'  #{r[\"id\"]} [{r[\"channel\"] or \"?\"}] {r[\"title\"]} ({p})')
   
   print()
   print('=== CURRENTLY SCHEDULED ===')
   for r in scheduled:
       print(f'  #{r[\"id\"]} [{r[\"channel\"] or \"?\"}] {r[\"title\"]} — publish: {r[\"publish_date\"] or \"TBD\"} ({r[\"production_status\"]})')
   
   conn.close()
   "
   

3. Read active campaigns (if relevant):

   • content/offers-and-funnels.md — active campaigns to align scheduling with