Keep a social media post archive that pays you back

Key takeaways

A social media post archive is a simple record of every published post with its date, pillar, format, link and a few results, built by moving each month's rows out of the calendar. It pays back three ways: you can repeat formats that worked, reshare evergreen winners and spot patterns over a year. Ten minutes at month end keeps it current.

• Move each month's rows to the archive at month end.
• Add 3 results: reach, saves or shares, and enquiries.
• Tag evergreen winners for resharing.
• Review patterns once a quarter.

What goes in the archive?

One row per published post: date, platform, pillar, format, a short description, the link to the live post, and three results, usually reach, saves or shares, and any enquiries it brought. Add a 'reshare?' tag for evergreen posts that did well. Keep it in the same file as the calendar, on its own tab.

• How to build a monthly social media content calendar
• Content calendar fields: what each row needs

How does it feed the monthly plan?

In the review step of each planning session, sort the archive for the last month and pick posts to repeat. Before filling slots, check the reshare tags for anything due back. Over time, the archive tells you which pillars and formats bring enquiries, which is what decides your slots.

• Plan next month from last month's results
• Reshare your best old posts on a schedule

Why not rely on the platforms' own history?

Platform insights show some results, but they do not record your pillars, your goals or which posts brought enquiries, and they are split across platforms. They also only keep some data for a limited time. Your own archive keeps everything in one place, in your own terms.

• A social media reporting dashboard with three numbers

How do you keep it from becoming a chore?

Record only three results per post and do it once a month, in about ten minutes. Moving rows from the calendar to the archive is most of the work. Skip anything you never look at again.

When is an archive not worth it?

It is not worth it if nobody ever looks at it in planning. Start using it at your next session; if it is still unused after three months, cut it down to just the reshare list.

What does this look like in practice?

A pattern we see: a business that cannot remember which posts brought its best enquiries last year, so it cannot repeat them. A simple archive usually reveals two or three formats doing most of the work within a quarter.

• See client work
• Social Media Marketing for UK businesses

Archive checklist

• Add an archive tab to the calendar file.
• Move each month's rows across at month end.
• Record three results per post.
• Tag evergreen winners.
• Review patterns quarterly.

• Content calendar completion rate: planned vs published
• A quarterly social media plan above the monthly calendar

Next step

Create an archive tab and move last month's posts into it with three results each. That is your first month of evidence.