📘
Social Post Scheduler Workbook — Complete Instruction Manual
Instruction Manual · How to use this template
The Social Post Scheduler Workbook is a premium Google Sheets template that helps content creators, social media managers, and small business owners track, score, and optimize their social media posts across up to seven platforms. Log every post with its engagement metrics, and the workbook auto-calculates performance scores, engagement percentages, hashtag ROI, weekly reach forecasts, and best-day recommendations — all without any add-ons or code. The workflow is simple: log your posts and metrics in the Post Log, curate hashtag sets in the Hashtag Library, and let the Dashboard, Weekly Tracker, and Best Times sheets surface your winning patterns so you can post less and grow faster.
⚡ Quick start
1Step 1 — Open the workbook and read the 'Read Me' sheet for a quick orientation, then make a copy of the file (File → Make a copy) so your data stays private.
2Step 2 — Go to the 📅 Post Log sheet and enter your first post: fill in the Date, Platform, Format, Status, Hashtags (use a set name from the Hashtag Library), Caption, Likes, Comments, and Reach columns. All ƒ columns will calculate automatically.
3Step 3 — Open the #️⃣ Hashtag Library sheet and add your hashtag sets: type a Set name, paste the Tags, and choose a Category. The library will auto-track usage and ROI as you log posts.
4Step 4 — Log at least 5–10 posts with real engagement numbers, then visit the 📊 Dashboard to see platform comparisons, hashtag ROI rankings, and goal progress.
5Step 5 — Check the 📈 Weekly Tracker after your first full week of data to see reach forecasts, week-over-week growth, and posting consistency streaks.
6Step 6 — Visit the 🕐 Best Times sheet to discover which days deliver the highest engagement and reach for each platform, then adjust your posting schedule accordingly.
The Post Log is the heart of the workbook — every social media post you publish gets a row here. You enter the date, platform, format, status, hashtags, caption, and raw engagement numbers; the sheet then auto-scores each post, ranks it against your history, and feeds data to every other sheet. Use it daily or after each post.
✍️ Step by step
11. In the Date column, enter the date the post was published (format: YYYY-MM-DD or your locale's date format). The ƒDay column will auto-fill with the day of the week.
22. Select the Platform from the dropdown (e.g., Instagram, TikTok, Facebook, Twitter/X, LinkedIn, YouTube, Pinterest) and choose the Format (e.g., Reel, Carousel, Story, Static, Video, Text, Pin).
33. Set the Status to indicate whether the post is Published, Scheduled, or Draft.
44. In the Hashtags column, type the exact Set name from your #️⃣ Hashtag Library (e.g., 'Growth Tips') so the VLOOKUP can match it and calculate Tag ROI.
55. Write or paste the Caption text for reference — this column is for your notes and does not affect calculations.
66. After the post has been live for 24–48 hours, enter the Likes, Comments, and Reach numbers from your platform analytics. All ƒ columns will instantly recalculate.
77. Review the auto-computed columns: ƒEng %, ƒRank, ƒScore, and ƒPercentile tell you how this post stacks up. ƒvs Avg shows whether it beat your average.
88. Use the planning section (right side) to queue future posts: fill in Platform, Format, Idea, Due date, Priority, Stage, and mark Done when published. The ƒDays Left, ƒEst Reach, ƒEst Score, and ƒUrgency columns help you prioritize your pipeline.
99. Check the KPI cards and charts at the top or side of the sheet regularly to spot engagement trends, reach by format, and queue urgency.
📋 Column-by-column
| Date | INPUT — Enter the date the post was published. Use a consistent date format such as YYYY-MM-DD or MM/DD/YYYY. Example: 2026-06-15. |
| ƒDay | AUTO-COMPUTED — Day of the week derived from the Date column (e.g., Monday, Tuesday). Used by the 🕐 Best Times sheet to determine which days perform best. No action needed. |
| Platform | INPUT — Select the social media platform where the post was published. Choose from the dropdown: Instagram, TikTok, Facebook, Twitter/X, LinkedIn, YouTube, or Pinterest. Example: Instagram. |
| Format | INPUT — Select the content format or post type. Options typically include Reel, Carousel, Story, Static Image, Video, Text Post, Pin, etc. Example: Reel. This feeds into the 'Reach by Format' chart on the Dashboard. |
| Status | INPUT — The current state of the post. Choose Published (live and collecting data), Scheduled (queued but not yet live), or Draft (in progress). Only Published posts with engagement data will affect scoring. |
| Hashtags | INPUT — Enter the hashtag set name exactly as it appears in the #️⃣ Hashtag Library Set column (e.g., 'Fitness Tips'). The sheet uses VLOOKUP to pull tag data and calculate Tag ROI. If you used no set, leave blank. |
| Caption | INPUT — Paste or type the post caption or a brief description. This is a reference field for your convenience and does not affect any calculations. Example: '5 morning habits that changed my life 🌅'. |
| Likes | INPUT — Enter the total number of likes (or hearts/reactions) the post received. Use a whole number with no commas or symbols. Example: 347. Update this 24–48 hours after publishing for accurate scoring. |
| Comments | INPUT — Enter the total number of comments the post received. Whole number, no symbols. Example: 42. This is used to compute Reply % and engagement metrics. |
| Reach | INPUT — Enter the total reach (unique accounts that saw the post) from your platform analytics. Whole number. Example: 5200. Reach is the primary metric for many auto-computed scores and forecasts. |
| ƒEng % | AUTO-COMPUTED — Engagement Rate, calculated as (Likes + Comments) ÷ Reach × 100. Expressed as a percentage. A good engagement rate varies by platform but generally 3–6% is solid, above 6% is excellent, and below 1% suggests the content did not resonate. Higher is better. |
| ƒRank | AUTO-COMPUTED — A numerical rank of this post compared to all other posts in the log, ordered by Score. Rank 1 is your best-performing post ever. Use this to quickly spot your top content. |
| ƒScore | AUTO-COMPUTED — A composite performance score that blends Engagement %, Reach, Likes, and Comments into a single number. The formula weighs multiple engagement signals so that a post with high reach but low engagement doesn't outscore a smaller but highly engaging post. Higher is better; compare scores across posts to find your winners. |
| ƒvs Avg | AUTO-COMPUTED — Shows how this post's Score compares to your overall average Score, expressed as a percentage difference. A value of +25% means the post scored 25% above your average. Positive values (green) are above-average posts; negative values (red) are below-average. Aim for more posts above 0%. |
| ƒReply % | AUTO-COMPUTED — Reply Percentage, calculated as Comments ÷ (Likes + Comments) × 100. It measures how much of your engagement is conversation-driven rather than passive likes. A Reply % above 20% indicates strong audience interaction; below 5% suggests people liked but did not feel compelled to comment. |
| ƒTag ROI | AUTO-COMPUTED — Hashtag Return on Investment. Uses VLOOKUP to find the hashtag set in the #️⃣ Hashtag Library and compares the reach or engagement of posts using that set versus overall averages. A Tag ROI above 1.0 means the hashtag set is boosting performance above baseline; below 1.0 means it is underperforming. Helps you decide which hashtag sets to keep or retire. |
| ƒVelocity | AUTO-COMPUTED — Measures how quickly engagement accumulated, approximated as (Likes + Comments) ÷ days since posting. A high Velocity means the post gained traction quickly (potentially going viral), while a low Velocity means engagement trickled in slowly. Useful for identifying content that catches fire early. |
| ƒMomentum | AUTO-COMPUTED — A trend indicator that compares recent post Velocity to your historical average Velocity. Positive Momentum means your content is accelerating in performance over time; negative Momentum means recent posts are slowing down. Use it to gauge whether your content strategy is improving week over week. |
| ƒPercentile | AUTO-COMPUTED — Shows what percentage of your posts this one outperformed. A Percentile of 90 means this post did better than 90% of all posts in your log. Above 75 is a strong post, 50 is average, below 25 is underperforming. Useful for quickly scanning large logs. |
| ƒPlat Rank | AUTO-COMPUTED — Platform Rank, ranking this post only against other posts on the same platform. Rank 1 means it is your top post on that platform. Helps you find your best Instagram post vs. your best TikTok post, etc. |
| ƒCum Reach | AUTO-COMPUTED — Cumulative Reach, a running total of Reach for all posts up to and including this row (ordered by date). Shows your total audience exposure over time. Useful for tracking growth milestones (e.g., 'I've reached 100K total eyeballs'). |
| Platform (Queue) | INPUT — In the planning/queue section, select the platform for an upcoming post idea. Same dropdown as the main Platform column. Example: TikTok. |
| Format (Queue) | INPUT — In the planning/queue section, select the format for the upcoming post. Example: Carousel. |
| Idea | INPUT — Write a brief description of the post idea or content concept. Example: 'Behind-the-scenes office tour'. This is a free-text reference field. |
| Due | INPUT — Enter the target publish date for this queued post. Use a date format like YYYY-MM-DD. Example: 2026-07-01. |
| ƒDays Left | AUTO-COMPUTED — Number of days remaining until the Due date. Calculated as Due date minus today's date. A negative number means the post is overdue. Turns red when the deadline is near or passed. |
| Priority | INPUT — Assign a priority level to the queued post, such as High, Medium, or Low. Helps you sort and focus on the most important upcoming content. |
| Stage | INPUT — Track the production stage of the queued post: Idea, Writing, Designing, Ready, or Scheduled. Update this as you progress through content creation. |
| Done | INPUT — Mark this checkbox or type 'Yes' when the post has been published. Completed items can be filtered out to keep your queue clean. |
| ƒEst Reach | AUTO-COMPUTED — Estimated Reach for the queued post, predicted based on your historical average reach for the same Platform and Format combination. Gives you a realistic expectation before publishing. |
| ƒEst Eng | AUTO-COMPUTED — Estimated Engagement for the queued post, predicted from your historical average engagement rate for that Platform and Format. Helps you anticipate how much interaction to expect. |
| ƒEst Score | AUTO-COMPUTED — Estimated Score for the queued post, predicted from historical Score averages for the same Platform and Format. Lets you compare planned posts to see which ones are likely to perform best. |
| ƒWin % | AUTO-COMPUTED — Win Percentage, the historical probability that a post with this Platform and Format combination will score above your overall average. Expressed as a percentage. A Win % of 70% means 7 out of 10 similar posts beat the average. Prioritize formats and platforms with high Win %. |
| ƒUrgency | AUTO-COMPUTED — A composite urgency score combining Days Left and Priority. Posts that are high-priority and close to their due date get the highest Urgency scores. Use this to sort your queue and focus on what needs attention now. |
| ƒBest Day | AUTO-COMPUTED — Recommends the best day of the week to publish this queued post, based on historical engagement data for the selected Platform. Pulled from the 🕐 Best Times analysis. Example output: 'Wednesday'. |
| ƒHistory | AUTO-COMPUTED — A mini-summary of your historical performance for this Platform + Format combination, such as average score or number of past posts. Gives quick context so you can see if you have enough data to trust the estimates. |
📊 Reading the numbers
• Avg Reach KPI: Your average reach across all published posts. Rising over time means your content is gaining traction; falling means you may need to refresh your strategy. Compare monthly.
• Viral Rate KPI: The percentage of your posts that exceed a high-performance threshold (e.g., top 10% by reach). A Viral Rate above 5–10% is healthy; 0% means no breakout hits.
• Eng Rate KPI: Your overall average engagement rate across all posts. Benchmark: 3–6% is good for most platforms. Use this as the baseline to judge individual posts via the ƒvs Avg column.
• Peak Velocity KPI: The highest Velocity score in your log, representing your fastest-growing post ever. A new Peak Velocity means you had a potential viral moment.
• 📈 Engagement Trend chart: Shows engagement rate over time. Look for an upward slope, which means your content quality is improving. Dips may align with platform changes or off-topic posts.
• 📊 Reach by Format chart: Compare how different formats (Reel, Carousel, Static, etc.) perform in reach. Double down on the tallest bars.
• 🎯 Reach by Platform chart: See which platform delivers the most eyeballs. Invest more time where the reach bar is longest.
• 💬 Likes vs Comments chart: Plots likes against comments per post. Posts in the upper-right corner have both high likes and high comments — these are your most engaging pieces.
• 📈 Score Trend chart: Tracks your composite Score over time. An upward trend confirms your overall strategy is working.
• 📌 Queue Urgency chart: Visualizes your upcoming posts by urgency. Tall bars need immediate attention; use this to plan your week.
⚠️ Avoid these mistakes
• Do not leave Likes, Comments, or Reach as zero for published posts — the formulas will calculate misleading scores. Enter real numbers or leave the row as Draft status.
• Make sure the Hashtags value matches a Set name in the Hashtag Library exactly (case-sensitive). A typo will break the VLOOKUP and ƒTag ROI will show an error or zero.
• Do not enter engagement numbers too early. Wait 24–48 hours after publishing so the metrics stabilize before logging.
• Do not delete the ƒ formula columns or overwrite them with static values — this will break downstream calculations on every other sheet.
💡 Tips• Sort by ƒRank or ƒPercentile to instantly find your all-time best posts and reverse-engineer what made them work.
• Use the queue section to plan a full week of content, then sort by ƒUrgency to prioritize your production schedule.
• Filter by Platform to see scoring and trends for a single network, which is helpful when preparing platform-specific reports.
• Periodically review posts with ƒvs Avg below -20% to understand what content types to avoid.
The Dashboard aggregates all your Post Log data into a bird's-eye view of performance by platform, hashtag set, and goal progress. Use it for weekly or monthly reviews to understand which platforms and hashtag strategies are winning, and whether you are on track to hit your reach or engagement targets.
✍️ Step by step
11. No manual data entry is required on this sheet — everything auto-populates from the 📅 Post Log and #️⃣ Hashtag Library via COUNTIF, SUMIF, AVERAGEIFS, COUNTIFS, and VLOOKUP formulas.
22. Review the Platform Performance table to compare total posts, likes, reach, engagement rate, reply rate, and average score across all your active platforms.
33. Check the Hashtag ROI table (Set, ƒUses, ƒAvg Reach, ƒROI Score) to see which hashtag sets deliver the best return and which are underperforming.
44. Use the Goals section to set reach or engagement targets per platform: type your Target number in the Target column, and watch ƒProgress, ƒGap, ƒRate/Wk, and ƒETA Wks auto-calculate.
55. Scan the KPI cards for top-level numbers: total Likes, total Reach, overall Eng %, Reply %, Avg Score, and Last Post date.
66. Study each chart to identify patterns: which platform gets the most posts, which has the highest reach, which format averages the best, which day of the week has peak engagement, which hashtags have the best ROI, and how close you are to your goals.
77. Use the ƒTrend and ƒGrowth columns in the platform table to see directional momentum — is each platform improving or declining?
📋 Column-by-column
| Platform | AUTO-POPULATED — Lists each platform that appears in your Post Log. No input needed. |
| ƒPosts | AUTO-COMPUTED — Total number of published posts on this platform, counted via COUNTIF from the Post Log. A higher number gives you more reliable averages. |
| ƒLikes | AUTO-COMPUTED — Sum of all Likes for posts on this platform, aggregated via SUMIF. Compare across platforms to see where your audience is most responsive. |
| ƒReach | AUTO-COMPUTED — Total Reach across all posts on this platform. Summed via SUMIF from the Post Log. The primary volume metric. |
| ƒEng % | AUTO-COMPUTED — Average Engagement Rate for this platform, calculated via AVERAGEIFS from the Post Log's ƒEng % column. Compare across platforms: if Instagram shows 5.2% and Twitter shows 1.8%, Instagram is more engaging for your content. |
| ƒReply % | AUTO-COMPUTED — Average Reply Percentage for this platform. Higher Reply % means more comments relative to likes, indicating deeper audience conversations on that platform. |
| ƒAvg Score | AUTO-COMPUTED — Average composite Score for posts on this platform. Lets you compare overall content performance across networks on one consistent scale. |
| ƒLast Post | AUTO-COMPUTED — The date of your most recent post on this platform. Helps you spot platforms you may be neglecting. If the Last Post date is more than 7–14 days ago, consider whether you need to re-engage that audience. |
| ƒShare % | AUTO-COMPUTED — The percentage of your total posts that went to this platform. Calculated as Posts on this platform ÷ Total posts × 100. Reveals how you are distributing effort. If one platform has 60%+ of your posts, you may be over-invested. |
| ƒWin % | AUTO-COMPUTED — The percentage of posts on this platform that scored above your overall average Score. A platform with Win % above 50% consistently produces above-average content for you. |
| ƒTrend | AUTO-COMPUTED — A directional indicator (e.g., ↑, ↓, or →) showing whether this platform's recent performance is improving, declining, or steady compared to earlier periods. |
| ƒGrowth | AUTO-COMPUTED — The percentage change in reach or engagement for this platform over a recent window (e.g., last 4 weeks vs. prior 4 weeks). Positive growth means the platform is trending up for you. |
| Set | AUTO-POPULATED — Lists each hashtag Set name from the #️⃣ Hashtag Library. No input needed. |
| ƒUses | AUTO-COMPUTED — How many posts in the Post Log used this hashtag set. More uses give you more statistical confidence in the ROI Score. |
| ƒAvg Reach (Hashtag) | AUTO-COMPUTED — Average Reach of posts that used this hashtag set, pulled via VLOOKUP/AVERAGEIFS from the Post Log. Compare across sets to find your highest-reach tags. |
| ƒROI Score | AUTO-COMPUTED — Hashtag ROI Score, measuring how much extra reach or engagement this set delivers compared to your baseline average. Above 1.0 is above-average return; below 1.0 is below-average. Retire or refresh sets consistently below 0.8. |
| Platform (Goals) | AUTO-POPULATED — Lists each platform for goal tracking. No input needed. |
| ƒCurrent | AUTO-COMPUTED — Your current cumulative reach (or other tracked metric) for this platform to date. Pulled from Post Log aggregations. |
| Target | INPUT — Enter your target goal for this platform. For example, if you want to reach 50,000 people on Instagram this quarter, type 50000. This is the only manual input on the Dashboard. |
| ƒProgress | AUTO-COMPUTED — Progress toward your target, shown as a percentage. Calculated as Current ÷ Target × 100. At 100% you have met your goal; above 100% means you exceeded it. |
| ƒGap | AUTO-COMPUTED — The absolute amount remaining to hit your target. Calculated as Target − Current. When Gap reaches 0, you have met the goal. |
| ƒRate/Wk | AUTO-COMPUTED — Your average weekly rate of progress toward the goal, calculated from your posting history. Used to project how many weeks it will take to close the Gap. |
| ƒETA Wks | AUTO-COMPUTED — Estimated weeks remaining to reach your Target at the current Rate/Wk. Calculated as Gap ÷ Rate/Wk. If ETA Wks is more than your remaining time horizon, you may need to increase posting frequency or improve content quality. |
📊 Reading the numbers
• Likes KPI: Your total likes across all platforms. A growing number over time means you are building an increasingly engaged following.
• Reach KPI: Your total cumulative reach. This is the headline number for how many people have seen your content.
• Eng % KPI: Your overall blended engagement rate. Benchmark against 3–6% for healthy performance.
• Reply % KPI: Your overall comment-to-engagement ratio. Above 15–20% suggests your audience finds your content discussion-worthy.
• Avg Score KPI: The average composite score across all posts. Track this monthly — a rising Avg Score means your content quality is improving.
• Last Post KPI: The date of your most recent post on any platform. If this is more than a few days ago, you may be falling behind on consistency.
• 📊 Posts by Platform chart: A bar or pie chart showing post volume distribution. Make sure you are not neglecting any key platform.
• 📶 Reach by Platform chart: Shows which platform drives the most eyeballs. Invest energy where reach is highest.
• 🎬 Avg Reach by Format chart: Compare content formats (Reel, Carousel, etc.) by average reach. The tallest bar is your best-performing format.
• 📅 Eng % by Day chart: Shows which day of the week yields the highest engagement. Align your posting calendar to the peak days.
• 🏷️ Hashtag ROI chart: Ranks your hashtag sets by ROI Score. Use the top sets more often and retire the bottom ones.
• 🎯 Goals vs Target chart: Visual progress bars for each platform's goal. Green/full bars mean you are on track; short bars mean you need to accelerate.
⚠️ Avoid these mistakes
• Do not type data into auto-computed cells on this sheet — it will overwrite formulas and break the dashboard.
• Remember to enter a Target value for each platform in the Goals section, or the Progress, Gap, and ETA columns will show errors or zeros.
• Do not delete rows from the platform or hashtag tables, as the formulas expect a fixed list of entries.
💡 Tips• Screenshot the Dashboard weekly and compare side-by-side to track month-over-month improvement visually.
• Sort the hashtag table by ƒROI Score descending to quickly see your top-performing tag sets.
• Use the ƒETA Wks column to decide if you need to ramp up posting frequency to hit quarterly goals.
• Check ƒTrend arrows weekly — a downward trend on a key platform is an early warning to investigate content quality or algorithm changes.
The Hashtag Library is your central repository for organizing, tracking, and evaluating hashtag sets. Each row represents a named group of hashtags you use together. The sheet auto-tracks how often each set is used, its average reach and engagement, and whether it is still fresh or going stale. Use it to build a data-driven hashtag strategy rather than guessing.
✍️ Step by step
11. In the Set column, type a short, descriptive name for your hashtag group. Example: 'Fitness Tips' or 'Product Launch'.
22. In the Tags column, paste the actual hashtags separated by spaces or commas. Example: '#fitness #health #workout #gym #motivation'.
33. In the Category column, classify the set: Niche, Branded, Trending, Community, etc. This helps you filter and analyze which category types perform best.
44. The ƒCount column auto-counts how many individual tags are in the Tags field. Keep sets between 5–15 tags for most platforms.
55. All other columns (ƒUses, ƒStatus, ƒAvg Reach, ƒAvg Eng %, ƒReach/Tag, ƒROI Score, ƒDays Idle, ƒFreshness) auto-calculate by cross-referencing the 📅 Post Log via COUNTIF and AVERAGEIFS.
66. Review ƒROI Score regularly: sets above 1.0 are earning their place; sets below 0.8 should be refreshed or retired.
77. Monitor ƒDays Idle and ƒFreshness to rotate sets — stale hashtags can reduce algorithmic reach on some platforms.
88. When creating new posts in the Post Log, reference the Set name from this library in the Hashtags column to ensure tracking works correctly.
📋 Column-by-column
| Set | INPUT — A short, unique name for this hashtag group. This is the key that links to the Post Log's Hashtags column via VLOOKUP. Must match exactly. Example: 'Morning Routine'. |
| Tags | INPUT — The actual hashtags in this set, separated by spaces or commas. Example: '#morning #routine #productivity #earlybird #selfcare'. Paste them exactly as you would use them on social media. |
| Category | INPUT — A classification label for the type of hashtag set. Suggested categories: Niche, Branded, Trending, Community, Seasonal, Product. Helps you analyze which category types drive the best ROI. |
| ƒCount | AUTO-COMPUTED — The number of individual hashtags in the Tags field, counted automatically. Most platforms perform best with 5–15 tags per post on Instagram, 3–5 on Twitter, and 5–10 on TikTok. If Count is above 30, consider trimming. |
| ƒUses | AUTO-COMPUTED — The total number of posts in the Post Log that reference this Set name. Calculated via COUNTIF. More uses give you more reliable averages. If Uses is below 3, treat ROI Score as preliminary. |
| ƒStatus | AUTO-COMPUTED — An auto-assigned label like Active, Low Use, or Stale, based on usage frequency and recency. Active means the set is used regularly; Stale means it has not been used recently and may need refreshing. |
| ƒAvg Reach | AUTO-COMPUTED — The average Reach of all posts that used this hashtag set, calculated via AVERAGEIFS from the Post Log. Compare across sets: the set with the highest Avg Reach is bringing your content to the most eyeballs. |
| ƒAvg Eng % | AUTO-COMPUTED — The average Engagement Rate of posts using this hashtag set. A set with high Avg Reach but low Avg Eng % may be reaching the wrong audience. Ideal sets have both metrics above your overall averages. |
| ƒReach/Tag | AUTO-COMPUTED — Reach per Tag, calculated as Avg Reach ÷ Count. Measures the efficiency of each individual hashtag in the set. Higher is better — it means each tag is pulling its weight. A set with 30 tags but low Reach/Tag is bloated. |
| ƒROI Score | AUTO-COMPUTED — Return on Investment Score for this hashtag set. Compares the set's average performance to your baseline averages. Above 1.0 means the set boosts performance above your norm; below 1.0 means it drags it down. Above 1.5 is excellent. Below 0.7 warrants retirement. |
| ƒDays Idle | AUTO-COMPUTED — Number of days since this hashtag set was last used in a post. Calculated as today's date minus the most recent Post Log entry referencing this set. If Days Idle exceeds 30, the set may be going stale. |
| ƒFreshness | AUTO-COMPUTED — A freshness indicator derived from Days Idle, categorizing the set as Fresh (recently used), Aging (moderately idle), or Stale (long idle). Rotating hashtag sets keeps your content from being flagged as repetitive by platform algorithms. |
📊 Reading the numbers
• Count KPI: The total number of hashtag sets in your library. A healthy library has 10–20 varied sets to rotate through.
• Avg Reach KPI: The average reach across all your hashtag sets. Use this as a baseline to judge individual set performance.
• Avg Eng % KPI: Your blended engagement rate across all sets. Sets above this number are outperforming.
• Reach/Tag KPI: Average efficiency of individual hashtags across your library. Higher is better.
• ROI Score KPI: Your overall hashtag ROI baseline. Individual sets should aim to be above this number.
• Days Idle KPI: Average idle time across all sets. If this is high, you are not rotating your tags enough.
• 📊 Usage by Set chart: Shows how often each set is used. Avoid over-relying on one set — spread usage across your top performers.
• 📈 Avg Reach by Set chart: Ranks sets by average reach. The tallest bars are your most powerful hashtag groups.
• ⚡ ROI Score by Set chart: Visualizes ROI Scores across sets. Focus on the sets that consistently appear at the top.
• ⚡ Reach per Tag chart: Shows efficiency per individual tag by set. Lean sets with high Reach/Tag are better than bloated sets.
• 💪 Eng % by Set chart: Compares engagement rates by set. High-engagement sets drive conversations, not just views.
• 🏷️ Category Mix chart: Shows the distribution of your sets by Category. A diverse mix (Niche, Branded, Trending, etc.) is healthier than over-indexing on one type.
⚠️ Avoid these mistakes
• Do not use different set names in the Post Log than what is in this library — the VLOOKUP will fail and Tag ROI will show errors.
• Do not leave the Tags field empty — ƒCount will show 0 and Reach/Tag cannot be calculated.
• Avoid creating too many sets with only 1–2 uses; the averages will be unreliable. Aim for at least 3–5 uses before making strategic decisions based on ROI Score.
💡 Tips• Create one set per content theme (e.g., 'Motivation', 'Tutorials', 'Behind the Scenes') for clean performance tracking.
• Every month, retire your 2–3 lowest ROI Score sets and replace them with new experimental sets to keep your hashtag strategy evolving.
• Use the ƒFreshness column to build a rotation schedule: use Fresh sets sparingly and bring Stale sets back into rotation or replace them.
• Filter by Category to compare Niche vs. Trending performance — often niche sets deliver better ROI despite lower raw reach.
The Weekly Tracker aggregates your Post Log data into weekly summaries, showing reach trends, posting consistency, week-over-week growth, and a 4-week rolling forecast. Use this sheet for weekly reviews to understand your trajectory and predict future performance.
✍️ Step by step
11. Each row represents one week. The Week number and Start date are entered manually or auto-generated depending on your setup. Enter the Week number (e.g., 1, 2, 3) and the Start date of that week (e.g., 2026-06-16).
22. All other columns auto-compute by pulling data from the 📅 Post Log using COUNTIFS and SUMIFS filtered by the week's date range.
33. Review ƒPosts and ƒReach weekly to see volume and exposure trends.
44. Check ƒWoW % (week-over-week change) to see if this week improved or declined versus last week.
55. Monitor ƒ4-Wk Avg to smooth out weekly noise and see your true trend line.
66. Use ƒForecast and ƒvs Fcst to compare predicted reach to actual reach — this tells you if you are ahead or behind your trajectory.
77. Watch ƒStreak for consecutive weeks of growth. A long positive streak confirms your strategy is working. A broken streak signals a need to investigate.
88. Check ƒVolatility to understand how consistent your performance is. Low volatility with steady growth is the ideal pattern.
📋 Column-by-column
| Week | INPUT — Enter the week number sequentially (1, 2, 3, etc.). This serves as the row identifier and x-axis label for charts. |
| Start | INPUT — Enter the start date (typically Monday) of this tracking week. Format: YYYY-MM-DD. Example: 2026-06-16. This date anchors the COUNTIFS/SUMIFS that pull data from the Post Log. |
| ƒPosts | AUTO-COMPUTED — Total number of published posts during this week, counted via COUNTIFS from the Post Log using the Start date range. Track your posting consistency week to week. |
| ƒReach | AUTO-COMPUTED — Total Reach of all posts published during this week, summed via SUMIFS. This is your headline weekly performance number. |
| ƒEng % | AUTO-COMPUTED — Average Engagement Rate across all posts this week. Calculated via AVERAGEIFS. Compare to your all-time Eng % to see if this was a strong or weak engagement week. |
| ƒLikes | AUTO-COMPUTED — Total Likes received on posts published this week. Summed via SUMIFS from the Post Log. |
| ƒWoW % | AUTO-COMPUTED — Week-over-Week percentage change in Reach, calculated as (This Week's Reach − Last Week's Reach) ÷ Last Week's Reach × 100. Positive values mean growth; negative values mean decline. Consistent positive WoW % is the goal. |
| ƒReach/Post | AUTO-COMPUTED — Average Reach per Post this week, calculated as ƒReach ÷ ƒPosts. This efficiency metric tells you whether posting more is actually increasing total reach or just diluting per-post performance. A high Reach/Post is better than high total Reach from many low-quality posts. |
| ƒ4-Wk Avg | AUTO-COMPUTED — A 4-week rolling average of Reach, smoothing out weekly spikes and dips to show the underlying trend. If the 4-Wk Avg is rising, your trajectory is positive regardless of individual week fluctuations. |
| ƒCumulative | AUTO-COMPUTED — Running total of Reach from Week 1 to the current week. Shows your all-time accumulated exposure. Useful for tracking milestones and reporting to stakeholders. |
| ƒForecast | AUTO-COMPUTED — A projected Reach value for this week based on your recent trend and growth rate. Derived from the 4-week rolling average and growth trajectory. Compare with actual ƒReach to see if you are beating or missing expectations. |
| ƒvs Fcst | AUTO-COMPUTED — The difference between actual Reach and Forecasted Reach, expressed as a percentage. Positive means you outperformed the forecast; negative means you underperformed. Consistently beating your forecast means your growth is accelerating. |
| ƒStreak | AUTO-COMPUTED — The number of consecutive weeks with positive WoW growth. A Streak of 4+ means you have been growing for a full month straight. A Streak reset to 0 or negative flags a down week that broke the run. |
| ƒVolatility | AUTO-COMPUTED — A measure of how much your weekly Reach fluctuates, based on standard deviation or variance of recent weeks. Low Volatility (below 20%) with positive growth is ideal — it means predictable, steady improvement. High Volatility means unpredictable swings, which makes planning harder. |
📊 Reading the numbers
• Latest Posts KPI: How many posts you published in the most recent tracked week. Staying consistent (e.g., 4–7 posts/week) is key to growth.
• Fcst Reach KPI: The forecasted reach for the next week based on your trend. Use this to set expectations.
• Reach/Post KPI: Your latest week's efficiency. If this drops while total posts increase, you may be posting low-quality filler.
• Wk Growth KPI: The most recent WoW % change. Green/positive is good; red/negative warrants investigation.
• 📈 Actual vs Forecast chart: A dual-line chart comparing your real reach to the forecast. When the actual line is above the forecast, you are outperforming. Persistent gaps below forecast suggest a strategy problem.
• 📊 Eng % Trend chart: Shows engagement rate over weeks. Look for stability or upward movement.
• 📋 Posts per Week chart: A bar chart of weekly post volume. Consistency matters more than occasional spikes.
• 📊 4-Wk Rolling Avg chart: A smoothed trend line of reach. This is the most reliable indicator of your true trajectory.
• 📊 WoW Growth chart: Visualizes week-over-week changes. Clusters of green bars mean sustained momentum.
• ⚡ Reach per Post chart: Tracks per-post efficiency over time. Rising Reach/Post means each post is working harder for you.
⚠️ Avoid these mistakes
• Do not skip weeks — leave a row with the Week number and Start date even if you posted nothing, so the time series remains continuous and formulas do not break.
• Make sure the Start dates do not overlap or have gaps; each should be exactly 7 days after the previous one.
• Do not edit the ƒ formula columns; they pull from the Post Log automatically.
💡 Tips• Set a weekly calendar reminder to add a new week row and review the tracker every Monday.
• Use the ƒvs Fcst column to identify your best and worst weeks, then cross-reference the Post Log to understand what drove the difference.
• If ƒVolatility is high, experiment with a more consistent posting cadence and measure whether it stabilizes over the next 4 weeks.
• Share the Actual vs Forecast chart with stakeholders — it is a compelling visual for demonstrating growth.
The Best Times sheet analyzes your historical data to reveal which days of the week and which platforms deliver the strongest engagement, reach, and scores. Use this sheet to optimize your posting schedule so every post goes live when your audience is most active.
✍️ Step by step
11. No manual input is needed — all data auto-populates from the 📅 Post Log (via COUNTIFS, AVERAGEIFS, INDEX/MATCH) and the 📊 Dashboard (via INDEX/MATCH).
22. The top table shows performance by Day of the week: each row (Monday through Sunday) displays the number of posts, average reach, average engagement rate, average score, and a Tier rating.
33. The bottom table shows performance by Platform: each row lists the platform's best day, peak engagement rate, average reach, post count, and consistency score.
44. Review the ƒTier column in the day table — it classifies each day as Top Tier, Mid Tier, or Low Tier based on relative performance. Schedule your most important content on Top Tier days.
55. Check the ƒBest Day column in the platform table to see which day works best for each specific platform (e.g., Instagram might peak on Wednesday while LinkedIn peaks on Tuesday).
66. Use ƒConsistency to gauge how reliable the data is — a high Consistency score means the day or platform performs well repeatedly, not just due to one viral post.
77. Cross-reference your findings here with the 📅 Post Log queue section to align Due dates with recommended best days.
📋 Column-by-column
| Day | AUTO-POPULATED — Each row represents a day of the week (Monday through Sunday). No input needed. |
| ƒPosts (Day) | AUTO-COMPUTED — Total number of posts published on this day of the week across your entire history. More posts give you a more reliable average. If any day has fewer than 3 posts, treat the averages with caution. |
| ƒAvg Reach (Day) | AUTO-COMPUTED — Average Reach of posts published on this day, calculated via AVERAGEIFS from the Post Log. The day with the highest Avg Reach is when your content gets seen by the most people. |
| ƒAvg Eng % (Day) | AUTO-COMPUTED — Average Engagement Rate of posts published on this day. The day with the highest Avg Eng % is when your audience is most interactive. This may differ from the highest-reach day. |
| ƒAvg Score (Day) | AUTO-COMPUTED — Average composite Score of posts published on this day. Combines reach and engagement into a single quality metric per day. |
| ƒTier | AUTO-COMPUTED — A tier classification (Top Tier, Mid Tier, Low Tier) assigned to each day based on its relative performance across Reach, Eng %, and Score. Post your most important content on Top Tier days; use Low Tier days for experimental or lower-stakes content. |
| Platform (Best Times) | AUTO-POPULATED — Each row represents a platform. No input needed. |
| ƒBest Day | AUTO-COMPUTED — The single best-performing day of the week for this specific platform, determined by the highest average engagement or score. Example: 'Wednesday' for Instagram. Schedule your platform-specific content on this day whenever possible. |
| ƒPeak Eng % | AUTO-COMPUTED — The highest average Engagement Rate achieved on any single day for this platform. This is the ceiling of what you can expect when timing is optimal. |
| ƒAvg Reach (Platform) | AUTO-COMPUTED — The overall average Reach for this platform across all days. Compare to the Dashboard's platform-level reach for consistency. |
| ƒPosts (Platform) | AUTO-COMPUTED — Total posts on this platform used in the Best Times analysis. Minimum of 5–10 posts per platform recommended for reliable best-day detection. |
| ƒConsistency | AUTO-COMPUTED — A measure of how reliably the platform performs on its best day versus other days. High Consistency (e.g., above 70%) means the best day is clearly and repeatedly better. Low Consistency means performance is more random and day-of-week matters less for this platform. |
📊 Reading the numbers
• Avg Reach KPI: The overall average reach across all days. Days above this number are your strong days.
• Avg Eng % KPI: The blended engagement rate across all days. Use as a benchmark to evaluate each day.
• Avg Score KPI: The average composite score across all days. Top Tier days will be well above this number.
• 📊 Avg Eng % by Day chart: A bar chart showing engagement rate for each day of the week. The tallest bar is your optimal posting day for engagement.
• 📈 Avg Reach by Day chart: Shows average reach per day. The tallest bar is your optimal day for visibility.
• 🏆 Peak Eng by Platform chart: Compares the peak engagement rate across platforms. Helps you see which platform rewards good timing the most.
• 📶 Avg Reach by Platform chart: Shows average reach per platform in the context of timing analysis.
• ⭐ Score by Day chart: Visualizes the composite score by day. A useful all-in-one view of day quality.
• 📊 Posts by Platform chart: Shows how many posts per platform are feeding the analysis. Low counts mean less reliable recommendations.
⚠️ Avoid these mistakes
• Do not make scheduling decisions based on fewer than 3 posts per day or platform — the averages will be unreliable and potentially misleading.
• Do not assume best days are permanent. Re-check this sheet monthly as audience behavior and platform algorithms change.
• Do not ignore the ƒConsistency column — a 'best day' with low consistency is not much better than any other day.
💡 Tips• Combine best-day insights with format insights from the Dashboard: post your best format on your best day for maximum impact.
• If two days are close in performance, alternate between them to avoid audience fatigue on a single day.
• Use the platform-specific Best Day recommendations to stagger your cross-platform posting: Instagram on Wednesday, LinkedIn on Tuesday, TikTok on Friday, etc.
• Re-run your analysis quarterly by reviewing this sheet to adapt to shifting audience habits.
📖Glossary — what every value means
| Eng % | Engagement Rate — the percentage of people who interacted with your post out of those who saw it. Calculated as (Likes + Comments) ÷ Reach × 100. A healthy Eng % is 3–6% for most platforms; above 6% is excellent, below 1% is weak. |
| Reply % | Reply Percentage — the share of total engagement that comes from comments rather than passive likes. Calculated as Comments ÷ (Likes + Comments) × 100. Above 20% indicates strong conversational engagement; below 5% means your content gets likes but not discussion. |
| Tag ROI | Hashtag Return on Investment — a score measuring how much a specific hashtag set boosts your post performance compared to your overall baseline. Above 1.0 means the set adds value; below 1.0 means it underperforms. Calculated by comparing average reach/engagement of posts using that set versus all posts. |
| ROI Score | Return on Investment Score — used in the Hashtag Library and Dashboard to rank hashtag sets by their contribution to performance. Above 1.0 is positive ROI; above 1.5 is excellent; below 0.7 warrants replacing the set. |
| Velocity | Engagement Velocity — how fast a post accumulates engagement, approximated as total interactions (Likes + Comments) divided by the number of days since it was posted. High Velocity suggests viral potential or strong initial traction. |
| Momentum | A trend metric comparing your recent posting Velocity to your historical average Velocity. Positive Momentum means your content is gaining traction faster than usual; negative means it is slowing down. |
| WoW % | Week-over-Week percentage change — the growth or decline in a metric (usually Reach) from one week to the next. Calculated as (This Week − Last Week) ÷ Last Week × 100. Consistently positive WoW % indicates healthy growth. |
| 4-Wk Avg | Four-Week Rolling Average — the average of a metric over the last four weeks, used to smooth out weekly noise and reveal the true underlying trend. A rising 4-Wk Avg means sustained improvement, not just a one-week spike. |
| Reach/Post | Reach per Post — average reach achieved per individual post, calculated as Total Reach ÷ Number of Posts. Measures content efficiency: a high Reach/Post means each piece of content works hard for you. |
| Reach/Tag | Reach per Tag — average reach divided by the number of hashtags in a set. Measures individual hashtag efficiency. Higher means each tag is contributing meaningfully to discovery. |
| Cum Reach | Cumulative Reach — a running total of all reach accumulated over time, growing with each new post. Useful for tracking long-term exposure milestones. |
| Forecast | A projected future value (typically Reach) for an upcoming week, extrapolated from your recent trend and 4-week rolling average. Compare Actual to Forecast to see if you are ahead or behind your trajectory. |
| vs Fcst | Versus Forecast — the percentage difference between your actual result and the forecasted value. Positive means you outperformed expectations; negative means you fell short. |
| vs Avg | Versus Average — how a single post's Score compares to the mean Score of all posts, expressed as a percentage difference. Positive means above average; negative means below. |
| Percentile | A ranking that shows what percentage of all posts a given post outperformed. A 90th-percentile post beat 90% of all posts. Above 75 is strong; around 50 is median; below 25 is underperforming. |
| Plat Rank | Platform Rank — a post's ranking within its own platform only (e.g., your #1 Instagram post, your #3 TikTok post). Useful for platform-specific content analysis. |
| Win % | Win Percentage — the share of posts (on a given platform or in a given format) that scored above your overall average. A Win % above 50% means that platform or format consistently produces above-average results. |
| Streak | A count of consecutive weeks with positive week-over-week growth. A longer streak indicates sustained momentum. When the streak breaks, investigate what changed. |
| Volatility | A measure of how much a metric fluctuates week to week, based on variance or standard deviation. Low Volatility (under 20%) means predictable, stable performance; high Volatility means erratic swings. |
| Freshness | A status label for hashtag sets based on how recently they were used. Fresh means recently active; Aging means moderately idle; Stale means the set has not been used in a long time and may need refreshing or replacing. |
| Days Idle | The number of days since a hashtag set was last used in a published post. Sets idle for more than 30 days are considered stale and should be rotated back in or retired. |
| ETA Wks | Estimated Time of Arrival in Weeks — the projected number of weeks needed to reach a goal at the current rate of progress. Calculated as Gap ÷ Rate per Week. Lower is better; if ETA exceeds your timeline, increase output. |
| Share % | The percentage of your total posts allocated to a specific platform. Calculated as Posts on Platform ÷ Total Posts × 100. Reveals effort distribution across networks. |
| Tier | A performance classification assigned to days of the week: Top Tier (best performance), Mid Tier (average), or Low Tier (below average). Based on composite scoring of reach, engagement, and score metrics. |
| Consistency | A reliability metric for Best Times analysis, measuring how repeatably a platform or day outperforms. High Consistency means the pattern is trustworthy; low Consistency means results vary and the recommendation is less reliable. |
| Est Reach | Estimated Reach — a predicted reach value for a queued/planned post based on historical averages for the same Platform and Format. Helps prioritize which upcoming posts to publish first. |
| Est Eng | Estimated Engagement — a predicted engagement value for a planned post, derived from historical averages. Used alongside Est Reach and Est Score to preview potential performance. |
| Est Score | Estimated Score — a predicted composite score for a planned post, based on historical data for similar Platform and Format combinations. |
| Urgency | A composite priority score for queued posts that factors in both the Priority level (High/Medium/Low) and how close the Due date is. Higher Urgency means the post needs attention sooner. |
| Growth | The percentage change in a platform's reach or engagement over a recent comparison window (e.g., last 4 weeks vs. prior 4 weeks). Positive Growth means improving performance; negative means declining. |
| Trend | A directional indicator (↑ up, → flat, ↓ down) showing whether a platform's performance is improving, stable, or declining over recent weeks. |
| Viral Rate | The percentage of your posts that cross a high-performance threshold (typically the top 10% by reach or score). A Viral Rate above 5–10% means you are regularly producing breakout content. |
| Peak Velocity | The highest Velocity value in your entire post history, representing your fastest-engaging post ever. A useful benchmark for identifying true viral moments. |
Every template ships with an AI side-panel. Type in plain language — it fills rows, explains any cell, and analyses your data for you.
How to use it
1The built-in ✨ AI side-panel is a chat assistant available directly inside Google Sheets. To open it, click the ✨ icon in the side panel or access it from the Extensions menu. You start with free AI trial requests, and a subscription unlocks a bigger monthly allowance of requests for heavier usage.
2Ask the AI assistant questions in plain language to understand any cell — for example, type 'Explain cell B7' or 'What does ƒTag ROI mean?' and it will describe the formula and what the value tells you. It reads your actual sheet data, so answers are specific to your numbers.
3Use commands to take action on your sheet without risking formula breakage: type 'Sum column C', 'Fill the next row with sample data', 'Color row 1 gold', or 'Sort by Score descending'. The assistant reads your sheet and executes changes safely, preserving all auto-computed formulas.
4The AI can scan your entire workbook for issues, and you can attach a screenshot or image (e.g., a platform analytics screenshot) for it to read and interpret. One-click presets tailored to this template are available for common actions, saving you time on repetitive analysis tasks.
5In the Tools tab, use ANALYZE ALL MY DATA to generate a full analytical report exported to a new sheet, or AUTO-FIT columns to clean up your layout. You can also TRANSLATE every label in the workbook to another language, or build a visual INFOGRAPHIC summarizing your social media performance.
6Customize the assistant's communication style with the Tone selector (Friendly, Professional, or Concise) and use Smart Styling for automatic formatting. Pro users unlock native AI-generated CHARTS, FORECASTS, and a comprehensive multi-page REPORT for deeper analysis and presentation-ready output.