FREE TEMPLATE

Social media post tracker: what went out, where, and what it did

A social media post tracker is a running log of every post you publish: when, where, in what format, and what it led to. Over a few months it shows which platforms and formats bring results. This one is filled in for a fictional dog groomer, with monthly totals and a learnings sheet. Download the filled example or the blank CSV, free with no signup.

Free, no signup · Updated · Opens in Excel, Google Sheets or Numbers

Download

In Google Sheets: File, Import, Upload, then pick the CSV.

What's inside

  • A post log: date, platform, format, pillar, what the post was, a link to it, reach, engagements, link clicks, bookings that mentioned it and a note
  • Monthly totals by platform, so you can compare where your time goes with what comes back
  • A learnings sheet that turns the log into decisions
  • A filled example for Wag & Wash, a fictional dog groomer (every figure is made up), and a blank CSV of each sheet

How to use it

  1. Add a row the day each post goes out, with a link to the live post.
  2. Fill the results a week later, from each platform's own insights, so every post has had the same time to collect them.
  3. Use the same metric names every time, even if platforms label them differently.
  4. Record what happened off the platform too, such as bookings or enquiries that mentioned a post.
  5. At the end of the month, total each platform and write two or three learnings.
  6. Use the learnings to plan next month, and check them against the log again in three months.

Preview: Post log

A filled example for a made-up small business.

DatePlatformFormatPillarWhat it wasLink to postReach (after 7 days)EngagementsLink clicksBookings that mentioned itNote
Mon 2 NovInstagramReelBefore and afterCockapoo puppy's first groom, start to finishSaved link4,120388213Most saves this month (example)
Mon 2 NovFacebookSame ReelBefore and afterSame videoSaved link1,3409691
Wed 4 NovInstagramCarouselTipsFive signs your dog's nails need a trimSaved link2,21016460Lots of shares
Thu 5 NovGoogle BusinessUpdateOffersChristmas groom slots openSaved linkn/an/a146Clicks from the Book button
Fri 6 NovTikTokVideoBehind the scenesDrying a very fluffy SamoyedSaved link6,85051221Big reach, few bookings
Mon 9 NovInstagramSingle imageTeamMeet Lucy, our new groomerSaved link1,48013100
Wed 11 NovFacebookText and photoOffersChristmas slots: only weekends left in DecemberSaved link2,06074318Local group shares helped
Fri 13 NovInstagramStoryOffersChristmas slots reminder with a link stickern/a690n/a184Stories disappear: log the same day

Preview: Monthly totals

A filled example for a made-up small business.

MonthPlatformPostsTotal reachTotal engagementsLink clicksBookings that mentioned a postTime spent (hours)
Nov 2026Instagram1431,4002,61096179
Nov 2026Facebook1014,20072088194
Nov 2026TikTok628,9002,140726
Nov 2026Google Business4n/an/a41141
NoteAll figures are made up for this example

Preview: Learnings

A filled example for a made-up small business.

MonthWhat the log showsWhat we'll doCheck again
Nov 2026Google Business brought the most bookings for the least timePost a Google Business update every week, not every fortnightFeb 2027
Nov 2026TikTok reach is high but bookings are lowKeep two TikToks a month for fun; stop spending time on captions thereFeb 2027
Nov 2026Facebook offer posts get shared in local groupsPost offers on Facebook firstFeb 2027
Nov 2026Before-and-after Reels get saved most on InstagramOne before-and-after Reel a weekFeb 2027

Tips

  • Wag & Wash, its staff and every figure in the example are made up. The results show how to read a log, not what to expect.
  • Fill results at the same age for every post, such as seven days after publishing. Comparing a post from this morning with one from last month isn't fair.
  • Platforms count reach and engagement in slightly different ways, so compare platforms on things you count yourself, such as bookings and link clicks.
  • Ask new customers how they heard about you, and add the answer to the bookings column. It's the most useful number in the log.
  • Log Stories on the day they go out. They disappear after 24 hours, and so does the easy way to find them.
  • Zolyp, which makes this template, shows each post's status from draft to live in its Calendar, and its Analyze feature writes a weekly report on connected accounts. Keep this log for anything that happens off the platforms, such as bookings.

Common questions

What is a social media post tracker?

A log of every post you publish: the date, platform, format, topic, a link to it and its results. It answers 'what did we post, and did it work?' without searching each platform.

What should I track for each post?

At minimum: date, platform, format, a link and one result that matters to the business, such as clicks, enquiries or bookings. Reach and engagements are useful for comparing posts on the same platform.

How is a post tracker different from a content calendar?

A calendar plans what will go out. A tracker records what did go out and what it did. Many businesses use both: plan in the calendar, then log the result in the tracker.

Are the figures in the example real?

No. The dog groomer and every figure are made up to show how a filled tracker reads.

Related

More free templates