Prompt Almanac

Create beginner Works with: Any AI

Content Production Pipeline Tracker

Table output

Track pieces from idea to publication.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Create a tracker for content from idea to publication. Content types and volume: [CONTENT_TYPES_AND_VOLUME]. Team roles: [TEAM_ROLES]. Stages: [STAGES]. Channels: [CHANNELS]. Spreadsheet app: [SPREADSHEET_APP].

Return:
1. Sheet design: Pipeline | Calendar | Topics bank | Performance | Settings.
2. Pipeline columns: ID | Working title | Type | Target keyword or theme | Audience | Stage | Writer | Editor | Designer | Brief link | Draft due | Review due | Publish date | Channel | Status flag | Notes. Define stages with entry and exit criteria (idea, briefed, drafting, edit, design, approval, scheduled, published, refresh due).
3. Formulas: days in current stage, overdue flag, workload per person per week, count by stage (for a bottleneck chart), average cycle time from brief to publish.
4. Views: kanban-style filter by stage, a calendar by publish date, and a "needs attention" list for overdue items.
5. Performance tab: Link | Publish date | Page views | Engagement | Leads | Date of last refresh | Action.
6. Rules: work-in-progress limits per stage, naming conventions, and a weekly 15-minute pipeline review agenda.

Include 10 sample rows and expected outputs. Suggest metrics for spotting bottlenecks and the data validation lists to use.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts