Social media posts
A Google Sheets template by TrackerHacker LLC, version 1.
Your posts' likes, comments and shares each day from Instagram, Facebook, YouTube, X, TikTok, Bluesky and more. A Trending tab ranks what gained most since yesterday, Platforms compares them side by side, and To do flags a post that takes off.
Social media postsv2
Use this templateGoogle asks you to choose the template once, then TrackerHacker copies it into your own Google Drive, charts and all, and you pick the emails that fill it, like your bank's or PayPal's. New here? You sign in with Google on the way.
Columns
- Day (always filled): The day the numbers were read, in your timezone.
- Platform (always filled): Which platform the post is on.
- Post ID (always filled): The platform's own id for the post. Kept per day, so a later reading that day updates its row and the next day gets a new one.
- Posted at: When the post was published.
- Link: The post's address, where the platform gives one.
- Caption: The post's text, as the platform gives it.
- Views: Views, plays or impressions so far, as the platform counts them. Blank when it doesn't say.
- Likes: Likes so far, or reactions on Facebook.
- Comments: Comments or replies so far.
- Shares: Shares, reposts or retweets so far.
Copied it and connected your copy? TrackerHacker asks how it's going on your sheet's page after two weeks, and your stars show up here.
More business templates · Template library · What is TrackerHacker?