Use the free template below to plan a blog article and its related email or social posts in one place. Copy it into your own document or spreadsheet; no registration is required. Give every deliverable its own row so that a finished article does not hide an unfinished image, caption or email.
Copy this content planner
Create these columns in your working file. If your spreadsheet supports pasting tab-separated text, the header below can be pasted into the first row.
Item ID Campaign Reader question Format Channel Owner Draft due Publish date Status Asset link Live URL Review date Result / next action
Use a stable item ID such as BAL-01. Keep dates in one format, for example YYYY-MM-DD. Store links to drafts and approved assets in the asset column; add the public URL only after publication. Leave unknown dates blank until someone accepts responsibility for them.
An example campaign with separate deliverables
This fictional campaign helps new managers prepare for their first one-to-one meeting.
| ID | Deliverable | Reader question | Channel | Dependency |
|---|---|---|---|---|
| MGR-01 | Practical article | What should I discuss in the first meeting? | Blog | Interview and example agenda checked |
| MGR-02 | Short checklist post | What should I prepare beforehand? | Social | Approved checklist from MGR-01 |
| MGR-03 | Email introduction | How can I use the agenda this week? | Live link to MGR-01 | |
| MGR-04 | Follow-up answer | What if the employee has little to say? | Blog | Reader questions and specialist review |
Adapt the idea to each channel
The blog can explain context and show the complete agenda. The social post should offer a useful preparation checklist in its own right. The email can explain who the agenda helps and link to it. Copying the same opening paragraph into every channel often leaves the reader without a clear next step.
Keep the campaign label consistent across the rows, but allow each item to have its own approval and publication date. An article correction may affect the checklist or email; the shared label helps you find those dependencies.
Set up status and review rules
- Idea: proposed, with no production commitment yet.
- In progress: an owner is working towards an agreed deadline.
- Review: a named person has a specific review task.
- Ready: copy, assets and links are approved.
- Published: the live version has been checked and its URL recorded.
At review, record a result that matches the item’s purpose and a next action. For the meeting agenda, relevant questions might be whether readers used it, what they found unclear and which follow-up explanation they requested. Do not fill every result cell with impressions simply because that number is available.
Keep the shared planner accessible to contributors and assign one person to resolve scheduling conflicts. For a fuller explanation of dates and responsibilities, see the content calendar guide.
