📘
Social Post Scheduler Workbook — Complete User Manual
Instruction Manual · How to use this template
The Social Post Scheduler Workbook is a premium Google Sheets template that lets you plan, publish, and analyze social media posts across seven platforms — all from one place. It automatically scores every post by engagement, surfaces your best-performing days and hashtags, and forecasts next week's reach so you can double down on what works. Whether you're a solopreneur, freelance social media manager, or small marketing team, the workflow is simple: log each post in the Post Log, let the formulas rank and score it, then check the Dashboard and Weekly Tracker to see trends and forecasts. The Hashtag Library and Best Times sheets refine your strategy over time, showing which tag sets drive the most reach and which days earn the highest engagement.
⚡ Quick start
1Step 1: Open the workbook and read the Read Me sheet for a quick orientation on color-coding and sheet purposes.
2Step 2: Go to the 📅 Post Log sheet and enter your first post — fill in Date, Platform, Format, Status, Hashtags, Caption, Likes, Comments, and Reach. All formula columns (marked ƒ) will populate automatically.
3Step 3: Add your go-to hashtag sets in the #️⃣ Hashtag Library — give each set a name, paste the tags, and assign a category. The library will start tracking performance once posts reference those set names.
4Step 4: Check the 📊 Dashboard after logging 5–10 posts to see platform breakdowns, hashtag ROI rankings, and goal progress. Set your reach or engagement targets in the Target column of the Goals table.
5Step 5: Review the 📈 Weekly Tracker each Monday to compare actual reach against the forecast line and spot week-over-week growth or decline.
6Step 6: Consult the 🕐 Best Times sheet after two or more weeks of data to learn which days and platforms deliver the highest engagement, then adjust your posting schedule accordingly.
The Post Log is the heart of the workbook — every social media post you publish (or plan to publish) gets a row here. The left side tracks published posts with actual metrics; the right side is a content pipeline where you draft upcoming ideas with estimated performance. All other sheets pull their data from this log, so keeping it accurate and up to date is essential.
✍️ Step by step
11. For each published post, enter the Date in YYYY-MM-DD or your locale's date format. The ƒDay column auto-detects the weekday.
22. Choose the Platform from the dropdown (e.g., Instagram, TikTok, Facebook, X/Twitter, LinkedIn, YouTube, Pinterest) and select the Format (e.g., Reel, Carousel, Story, Static, Video, Text, Pin).
33. Set Status to Published, Draft, or Scheduled to track where the post stands.
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 is not used in calculations but helps you review content at a glance.
66. After 24–48 hours, come back and enter actual Likes, Comments, and Reach numbers from the platform's analytics.
77. All ƒ columns to the right (Eng %, Rank, Score, vs Avg, Reply %, Tag ROI, Velocity, Momentum, Percentile) will auto-calculate — do not type in them.
88. For upcoming content ideas, scroll to the pipeline section and fill in Platform, Format, Idea, Priority (High / Medium / Low), Stage (Idea / Drafting / Ready / Scheduled), and Due date.
99. The pipeline's ƒ columns (Due In, Est Reach, Est Eng %, Est Score, Hit %, Urgency) forecast performance based on your historical data and flag approaching deadlines — mark Done when published.
📋 Column-by-column
| Date | INPUT — the date the post was (or will be) published. Use a consistent date format such as YYYY-MM-DD or MM/DD/YYYY. Example: 2026-06-15. |
| ƒDay | AUTO-COMPUTED — the day of the week derived from the Date column (e.g., Monday, Tuesday). Used by the 🕐 Best Times sheet to aggregate performance by weekday. No action needed. |
| Platform | INPUT — the social media platform where the post was published. Choose from the dropdown: Instagram, TikTok, Facebook, X/Twitter, LinkedIn, YouTube, or Pinterest. Example: Instagram. |
| Format | INPUT — the content format of the post. Options typically include Reel, Carousel, Story, Static Image, Video, Text Post, or Pin. This feeds the Reach by Format chart. Example: Reel. |
| Status | INPUT — the current state of the post: Published, Scheduled, or Draft. Only Published posts with metrics entered will factor into performance calculations. |
| Hashtags | INPUT — the name of the hashtag set used on this post, matching a Set name in the #️⃣ Hashtag Library exactly (case-sensitive). This link powers the Tag ROI calculation. Example: 'Growth Tips'. |
| Caption | INPUT — the full or abbreviated caption text of the post. Stored for your reference and content review; not used in any formula. Example: '5 tips to grow your audience this summer 🌞'. |
| Likes | INPUT — the total number of likes the post received. Enter a whole number pulled from the platform's analytics after 24–48 hours. Example: 342. |
| Comments | INPUT — the total number of comments the post received. Enter a whole number. Example: 28. |
| Reach | INPUT — the total number of unique accounts that saw the post. Enter a whole number from the platform's analytics. Example: 5200. |
| ƒEng % | AUTO-COMPUTED — Engagement Rate, calculated as (Likes + Comments) ÷ Reach × 100. Measures how actively your audience interacted relative to how many people saw the post. A rate above 3–5% is generally strong; below 1% suggests the content did not resonate. Displayed as a percentage. |
| ƒRank | AUTO-COMPUTED — a numerical rank ordering all published posts from highest to lowest based on their Score. Rank 1 is your top-performing post. Use this to quickly spot your best and worst content. |
| ƒScore | AUTO-COMPUTED — a composite performance score that blends Engagement Rate, Reach, and interaction volume into a single number. Higher is better. A Score above your rolling average means the post outperformed your norm; the exact scale depends on your data range but typical values might run from 0 to 100+. |
| ƒvs Avg | AUTO-COMPUTED — shows how this post's Score compares to your overall average Score, expressed as a percentage difference. A positive value like +25% means the post performed 25% above your average; a negative value means below average. Helps you instantly flag winners and underperformers. |
| ƒReply % | AUTO-COMPUTED — Reply Rate, calculated as Comments ÷ (Likes + Comments) × 100. Measures how much of your engagement came from comments (deeper interaction) versus passive likes. A Reply % above 15–20% suggests your content sparked conversation; below 5% means engagement is mostly passive. |
| ƒTag ROI | AUTO-COMPUTED — Hashtag Return on Investment. Compares the reach of this post to the average reach of all posts using the same hashtag set (via VLOOKUP to the Hashtag Library). A value above 1.0 means this post outperformed the set's average; below 1.0 means it underperformed. Helps you evaluate whether certain tag sets boost or drag down performance. |
| ƒVelocity | AUTO-COMPUTED — a measure of how quickly the post accumulated engagement relative to its age. Calculated by dividing total interactions (Likes + Comments) by the number of days since posting. High Velocity (e.g., 50+ interactions/day) means rapid early traction; low Velocity suggests slow or declining interest. |
| ƒMomentum | AUTO-COMPUTED — tracks the trend direction of your recent posts' Velocity, indicating whether your content performance is accelerating or decelerating over your last several posts. Positive Momentum means your recent posts are gaining traction faster than older ones; negative Momentum signals a slowdown. |
| ƒPercentile | AUTO-COMPUTED — shows where this post falls relative to all your published posts, expressed as a percentile (0–100). A post at the 90th percentile outperformed 90% of all your posts. Quick way to contextualize any single post's performance against your entire history. |
| Platform (Pipeline) | INPUT — the platform you plan to post on for this upcoming content idea. Same dropdown as the published section. Example: TikTok. |
| Format (Pipeline) | INPUT — the planned content format for this upcoming post. Example: Carousel. |
| Idea | INPUT — a brief description of the content idea or working title. Example: 'Behind-the-scenes studio tour'. |
| Priority | INPUT — how important or time-sensitive this idea is. Choose High, Medium, or Low. High-priority ideas sort to the top of your pipeline view. |
| Stage | INPUT — the production stage of this idea: Idea, Drafting, Ready, or Scheduled. Update as the content moves through your workflow. |
| Due | INPUT — the target publish date for this idea, in the same date format as the Date column. Example: 2026-07-01. |
| ƒDue In | AUTO-COMPUTED — the number of days remaining until the Due date. Displays a positive countdown (e.g., 5 = five days left) or a negative number if overdue (e.g., -2 = two days past due). Helps you prioritize content production. |
| ƒEst Reach | AUTO-COMPUTED — Estimated Reach, a forecast of how many accounts this planned post is likely to reach. Calculated from your historical average reach for the same Platform and Format combination. Treat it as a planning estimate, not a guarantee. |
| ƒEst Eng % | AUTO-COMPUTED — Estimated Engagement Rate for this planned post, based on historical averages for the chosen Platform and Format. Useful for setting realistic expectations before publishing. |
| ƒEst Score | AUTO-COMPUTED — Estimated Score, projecting the composite performance score this post might achieve based on historical patterns for similar Platform/Format combinations. |
| ƒHit % | AUTO-COMPUTED — Hit Rate, the percentage of your past posts on this Platform/Format combination that scored above average. A high Hit % (e.g., 70%+) means this type of content reliably performs well; a low Hit % (below 30%) suggests inconsistent results. |
| ƒUrgency | AUTO-COMPUTED — a combined urgency indicator factoring in how soon the post is due and its priority level. Posts with high priority and imminent deadlines surface with the highest urgency. Use this to decide what to work on next. |
| Done | INPUT — check this box or type TRUE/YES when the planned post has been published. Marking it Done excludes it from active pipeline views and urgency calculations. |
📊 Reading the numbers
• Avg Reach KPI: the mean reach across all published posts — compare individual post Reach to this to see if a post is above or below your norm. A rising Avg Reach over time is a healthy sign.
• Above Avg KPI: the count or percentage of posts that exceeded the average Score, showing how consistently you create strong content. Above 50% means more winners than losers.
• Eng Rate KPI: your overall Engagement Rate across all posts — aim for 3–5%+ depending on platform norms. If this drops, your content may be reaching people but not resonating.
• Peak Velocity KPI: the highest Velocity any single post achieved — this is your benchmark for viral or breakout content. Use it to set aspirational targets.
• 📈 Engagement Trend chart: plots Eng % over time; look for an upward slope indicating improving content quality. Sudden dips may correlate with format changes or algorithm shifts.
• 📊 Reach by Format chart: shows which format (Reel, Carousel, Static, etc.) generates the most reach on average — lean into your top-performing format.
• 🎯 Reach by Platform chart: compares average reach across platforms so you can allocate effort to your highest-return channels.
• 💬 Likes vs Comments chart: visualizes the balance of passive (Likes) versus active (Comments) engagement — a healthy mix means your content is both broadly appealing and conversation-starting.
• 📈 Score Trend chart: tracks your composite Score over time — an upward trend means your overall post quality is improving.
• 🔄 Velocity by Post chart: shows engagement speed per post, helping you spot which content gains traction fastest after publishing.
⚠️ Avoid these mistakes
• Entering the Hashtags value as raw tags (#growth #tips) instead of the Set name from the Hashtag Library — the VLOOKUP will fail and Tag ROI will show an error.
• Forgetting to come back and enter actual Likes, Comments, and Reach after publishing — without these, all ƒ columns remain zero or blank, skewing your analytics.
• Overwriting a formula cell (any ƒ column) with a typed number — this breaks the auto-calculation for that row and every sheet that pulls from it.
• Leaving the Status as Draft or Scheduled when the post is actually published — unpublished statuses may be excluded from performance calculations.
💡 Tips• Sort by ƒRank to instantly see your top-performing posts and study what made them work.
• Use conditional formatting or the ƒvs Avg column to color-code posts that beat or miss your average — green for positive, red for negative.
• Log posts within 48 hours of publishing for the most accurate Velocity calculations, since Velocity divides engagement by days elapsed.
• Fill the pipeline section every Sunday to plan your upcoming week, then check ƒUrgency daily to stay on track.
The Dashboard is your command center — it aggregates data from the Post Log, Hashtag Library, and Weekly Tracker into platform summaries, hashtag rankings, and goal tracking. Visit it regularly to understand which platforms are delivering, which hashtag sets are earning their keep, and whether you are on track to hit your targets.
✍️ Step by step
11. You do not need to type anything on this sheet except your Targets in the Goals section — every other cell is auto-populated from the Post Log and Hashtag Library.
22. Review the Platform Performance table at the top to compare total posts, likes, reach, engagement rate, and reply rate across all seven platforms.
33. Check the ƒWin % column to see what percentage of each platform's posts scored above average — this tells you where your content is most reliably strong.
44. Scroll to the Hashtag Summary table to see which tag sets are used most and which deliver the best ROI Score and average reach.
55. In the Goals section, enter your Target numbers (e.g., target monthly reach, target engagement rate) next to each platform. The ƒProgress column auto-calculates how close you are.
66. Review the KPI cards at the top — Posts/Wk shows your posting cadence, Total Reach and Fcst Reach compare actual to forecasted reach, and Eng % gives your blended engagement rate.
77. Use the six charts to visually compare platforms, formats, weekdays, hashtag ROI, and goal progress at a glance.
📋 Column-by-column
| Platform | AUTO-POPULATED — lists each of the seven social media platforms. This is a reference column that anchors the summary table; do not edit it. |
| ƒPosts | AUTO-COMPUTED — the total number of published posts on each platform, counted from the Post Log using COUNTIF. Tells you where you are most active. |
| ƒLikes | AUTO-COMPUTED — the sum of all Likes received on each platform, aggregated from the Post Log using SUMIF. Higher totals indicate platforms where your content resonates most. |
| ƒReach | AUTO-COMPUTED — the total Reach across all posts on each platform, summed from the Post Log. This is your raw visibility metric per platform. |
| ƒEng % | AUTO-COMPUTED — the weighted average Engagement Rate per platform, calculated as total (Likes + Comments) ÷ total Reach × 100 using AVERAGEIFS from the Post Log. Compare across platforms to find where your audience is most engaged. Above 3% is generally strong. |
| ƒReply % | AUTO-COMPUTED — the average Reply Rate per platform, showing what proportion of engagement is comments versus likes. Platforms with a Reply % above 15% have audiences that actively converse with your content. |
| ƒAvg Score | AUTO-COMPUTED — the mean composite Score for all posts on each platform. A high Avg Score indicates consistently strong overall performance on that channel. |
| ƒLast Post | AUTO-COMPUTED — the date of the most recent published post on each platform. If a platform shows a date more than 7–14 days old, you may be neglecting it. |
| ƒShare % | AUTO-COMPUTED — the percentage of your total posts that were published on each platform (e.g., if 30 of 100 posts went to Instagram, Share % = 30%). Helps you see how your effort is distributed. |
| ƒWin % | AUTO-COMPUTED — Win Rate, the percentage of posts on each platform that scored above your overall average. A Win % above 50% means more than half your posts on that platform are winners. Below 30% suggests the platform may not suit your content style. |
| ƒTrend | AUTO-COMPUTED — a directional indicator (such as ↑, →, or ↓ or a numeric slope) showing whether each platform's recent performance is improving, flat, or declining relative to earlier posts. An upward trend is encouraging; a downward trend warrants investigation. |
| Set | AUTO-POPULATED — the hashtag set names pulled from the Hashtag Library via VLOOKUP. Each row corresponds to one of your named hashtag sets. |
| ƒUses | AUTO-COMPUTED — how many times each hashtag set has been used across all posts in the Post Log. High usage with high ROI is ideal; high usage with low ROI means you should rotate that set out. |
| ƒAvg Reach (Hashtag) | AUTO-COMPUTED — the average Reach of posts that used each hashtag set. Compare sets side by side to identify which tags drive the most visibility. |
| ƒROI Score (Hashtag) | AUTO-COMPUTED — the Hashtag ROI Score summarizing the return each set delivers relative to its usage. Higher is better; scores significantly below 1.0 suggest the set may be hurting discoverability. |
| Platform (Goals) | AUTO-POPULATED — lists each platform in the Goals tracking section. Do not edit. |
| ƒCurrent | AUTO-COMPUTED — your current actual metric value (e.g., current total reach or engagement rate) for each platform, pulled from the Post Log. |
| Target | INPUT — your goal value for each platform's key metric (e.g., 10000 for monthly reach, or 5.0 for target engagement rate). Type the number you are aiming for. Example: 10000. |
| ƒProgress | AUTO-COMPUTED — Progress toward your target, calculated as ƒCurrent ÷ Target × 100 and displayed as a percentage. 100% means you hit the goal; above 100% means you exceeded it. Below 50% with little time remaining signals you may need to increase posting frequency. |
📊 Reading the numbers
• Posts/Wk KPI: the average number of posts you publish per week — consistency matters for algorithm favor; aim for a steady or growing number.
• Total Reach KPI: cumulative reach across all platforms and all time — this is your total audience exposure. Compare it week-over-week for growth.
• Fcst Reach KPI: forecasted reach for the upcoming period based on your trend data from the Weekly Tracker — if Fcst Reach exceeds Total Reach's recent pace, your trajectory is positive.
• 📊 Posts by Platform chart: a bar or pie chart showing post volume distribution — if one platform dominates, consider diversifying.
• 📶 Reach by Platform chart: highlights which platforms deliver the most eyeballs — prioritize platforms with high reach relative to effort.
• 🎬 Avg Reach by Format chart: shows which content format (Reel, Carousel, etc.) generates the most reach on average — lean into top performers.
• 📅 Eng % by Day chart: reveals which weekdays produce the highest engagement rates — schedule important posts on peak days.
• 🏷️ Hashtag ROI chart: ranks your hashtag sets by ROI Score so you can retire underperformers and double down on top sets.
• 🎯 Goals vs Target chart: a progress bar or comparison chart showing how each platform's current metric stacks up against your target — green means on track, red means behind.
⚠️ Avoid these mistakes
• Editing any cell other than the Target column — everything else on this sheet is formula-driven and will break if overwritten.
• Setting unrealistic Targets that make your Progress permanently red and discouraging — base targets on your recent 4-week averages plus 10–20% stretch.
• Ignoring the ƒTrend column — even if current numbers look good, a downward trend warns of future declines.
💡 Tips• Screenshot this sheet weekly and share it with clients or your team as a quick performance summary.
• Use the ƒWin % column to decide where to invest more effort: platforms with high Win % deserve more posts; platforms with low Win % need a strategy rethink.
• Cross-reference ƒLast Post dates to make sure no platform goes dormant — set a personal rule like 'no platform older than 5 days'.
• Compare the Hashtag ROI table with the Best Times data to craft a winning formula: best tags + best days = maximum reach.
The Hashtag Library is your organized collection of reusable hashtag sets. Each set has a name and a group of tags you copy-paste onto posts. Over time, the sheet auto-tracks how each set performs — reach, engagement, ROI — so you can rotate in winning sets and retire underperformers. Think of it as your hashtag strategy database.
✍️ Step by step
11. In the Set column, create a short, memorable name for each hashtag group (e.g., 'Growth Tips', 'Motivation Monday', 'Product Launch').
22. In the Tags column, paste the actual hashtags separated by spaces or commas (e.g., '#growthhacking #socialmedia #marketingtips').
33. Assign a Category to each set (e.g., Niche, Trending, Brand, Community) to help you filter and analyze tag types.
44. The ƒCount column automatically counts how many individual hashtags are in the Tags cell — aim for 5–15 per set on Instagram, fewer on other platforms.
55. As you log posts in the Post Log and reference these Set names in the Hashtags column, the ƒUses, ƒAvg Reach, ƒAvg Eng %, and ƒROI Score columns auto-update using COUNTIF and AVERAGEIFS from the Post Log.
66. Check ƒIdle Days and ƒFreshness regularly — sets that haven't been used in 14+ days may be going stale and should be refreshed or rotated.
77. Use the charts to compare sets visually and decide which ones to keep, tweak, or replace.
📋 Column-by-column
| Set | INPUT — a unique, descriptive name for this hashtag group. Must match exactly what you type in the Post Log's Hashtags column for the VLOOKUP to work. Keep it short and consistent. Example: 'Growth Tips'. |
| Tags | INPUT — the actual hashtag strings in this set, separated by spaces or commas. Example: '#socialmedia #marketing #growthhacking #contenttips #digitalmarketing'. |
| Category | INPUT — a label to classify this set's purpose. Common categories: Niche (industry-specific), Trending (popular/seasonal), Brand (your branded tags), Community (engagement-focused). Example: Niche. |
| ƒCount | AUTO-COMPUTED — the number of individual hashtags in the Tags cell, typically counted by the number of '#' symbols or space-separated tokens. Useful for ensuring you are within platform limits (e.g., Instagram allows up to 30 but 5–15 is often optimal). A count of 0 means the Tags cell may be empty or malformatted. |
| ƒUses | AUTO-COMPUTED — how many posts in the Post Log reference this set by name, counted via COUNTIF. A high number means the set is in heavy rotation. Compare Uses against ROI Score to decide if popular sets are actually performing well. |
| ƒStatus | AUTO-COMPUTED — a label indicating whether this set is Active, Idle, or Retired, typically based on how recently and frequently it was used. Active means used in the last 7–14 days; Idle means not used recently; Retired means unused for an extended period. |
| ƒAvg Reach | AUTO-COMPUTED — the average Reach of all posts that used this hashtag set, pulled via AVERAGEIFS from the Post Log. Higher Avg Reach means this tag set is consistently expanding your audience. Compare sets to identify your highest-visibility groups. |
| ƒAvg Eng % | AUTO-COMPUTED — the average Engagement Rate of posts using this set. A set with high Avg Reach but low Avg Eng % might be attracting views but not the right audience. Ideally, both numbers should be strong. |
| ƒReach/Tag | AUTO-COMPUTED — Reach per Tag, calculated as Avg Reach ÷ Count. Measures the efficiency of each individual hashtag within the set. A set of 5 tags with 5,000 Avg Reach (1,000 Reach/Tag) is more efficient than a set of 20 tags with 5,000 Avg Reach (250 Reach/Tag). Higher is better. |
| ƒROI Score | AUTO-COMPUTED — a composite score reflecting the return this hashtag set delivers relative to how often it is used. Combines reach efficiency, engagement, and usage frequency. A score above 1.0 indicates the set delivers above-average returns; below 1.0 means it underperforms. Aim to keep your active rotation above 1.0. |
| ƒIdle Days | AUTO-COMPUTED — the number of days since this set was last used on a post, calculated from the most recent post date referencing this set. If Idle Days exceeds 14–21, the set may be going stale or forgotten. Consider refreshing the tags or re-introducing the set. |
| ƒFreshness | AUTO-COMPUTED — a qualitative indicator (e.g., Fresh, Aging, Stale) derived from Idle Days and usage trends. Fresh means recently and regularly used; Stale means the set hasn't appeared in weeks. Stale sets may contain outdated or shadow-banned tags — review and update them. |
📊 Reading the numbers
• Count KPI: total number of hashtag sets in your library. A healthy library has 8–20 diverse sets covering different categories.
• Avg Reach KPI: the grand average reach across all sets — sets significantly above this benchmark are your top performers.
• Avg Eng % KPI: the blended engagement rate across all sets — compare individual sets against this to find over- and underperformers.
• Reach/Tag KPI: average reach generated per individual hashtag — helps you evaluate tag efficiency at a library-wide level.
• ROI Score KPI: average ROI across all sets — aim to push this up by retiring low-ROI sets and adding proven winners.
• Idle Days KPI: the average idle period across all sets — if this number climbs above 10, your rotation is slowing and sets are going unused.
• 📊 Usage by Set chart: a bar chart showing how many times each set was used — over-reliance on one set means limited discovery potential.
• 📈 Avg Reach by Set chart: ranks sets by average reach, helping you identify your visibility powerhouses.
• ⚡ ROI Score by Set chart: ranks sets by ROI, the single best indicator of overall set value.
• 📊 Reach vs Efficiency chart: plots Avg Reach against Reach/Tag to find sets that are both high-reaching and tag-efficient — the top-right quadrant is the sweet spot.
• 📈 Avg Eng % by Set chart: shows which sets drive the most audience interaction — useful for conversation-focused campaigns.
• 🏷️ Category Mix chart: shows the distribution of your sets across categories — ensure a balanced mix of Niche, Trending, Brand, and Community tags.
⚠️ Avoid these mistakes
• Misspelling the Set name in the Post Log — even a trailing space will break the VLOOKUP, causing zero matches and blank ROI data.
• Pasting hashtags without '#' symbols — while some platforms don't require them, the Count formula may rely on the '#' character to tally tags correctly.
• Never retiring underperforming sets — if a set consistently scores below 1.0 ROI, replace it rather than hoping it improves.
• Having too few sets (under 4) — limited variety means limited experimentation and discovery.
💡 Tips• Create seasonal sets (e.g., 'Summer Vibes', 'Holiday Promo') and swap them in and out as the calendar shifts — check ƒFreshness to time the rotation.
• Build one 'Evergreen' set per platform with your top 5–10 reliably performing tags for use on any post.
• Sort by ƒROI Score descending to immediately see your best and worst sets, then make rotation decisions accordingly.
• When a set goes Stale, research whether any of its tags have been shadow-banned or oversaturated before reusing them.
The Weekly Tracker aggregates your Post Log data into weekly summaries, letting you spot trends, calculate growth rates, and compare actual reach against a rolling forecast. Use it to evaluate your week-over-week trajectory and decide whether to maintain, increase, or adjust your posting strategy.
✍️ Step by step
11. Enter the Week number (1, 2, 3, etc.) and the Start date of each week in the first two columns. All other columns auto-populate from the Post Log.
22. The ƒPosts column counts how many posts were published during each week's date range using COUNTIFS.
33. ƒReach sums the total reach for that week, and ƒEng % calculates the week's blended engagement rate.
44. Check ƒWoW % (Week-over-Week growth) to see if your reach is expanding or contracting compared to the previous week.
55. Review the ƒForecast column, which projects next week's expected reach based on your trend — compare this to actual results to evaluate forecasting accuracy.
66. The ƒStreak column tracks consecutive weeks of growth or improvement — a long positive streak confirms sustained momentum.
77. Scroll down to the charts for visual trend analysis: Actual vs Forecast shows prediction accuracy, Cumulative Reach shows your total audience exposure over time.
📋 Column-by-column
| Week | INPUT — a sequential week number (1, 2, 3…). Start from 1 and increment each week. This anchors the time series for all weekly calculations. |
| Start | INPUT — the start date of this week (typically a Monday). Use the same date format as the Post Log. Example: 2026-06-15. |
| ƒPosts | AUTO-COMPUTED — the number of posts published during this week's date range (Start to Start + 6 days), counted from the Post Log using COUNTIFS. A consistent posting cadence (e.g., 5–7/week) is ideal for algorithm favor. |
| ƒReach | AUTO-COMPUTED — the total Reach of all posts published in this week, summed from the Post Log using SUMIFS. This is the key weekly output metric. |
| ƒEng % | AUTO-COMPUTED — the blended Engagement Rate for all posts published this week, calculated as total weekly (Likes + Comments) ÷ total weekly Reach × 100. Compare across weeks to spot engagement trends. |
| ƒLikes | AUTO-COMPUTED — the total Likes received across all posts published this week. A secondary volume metric useful for tracking audience appreciation trends. |
| ƒ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 indicate growth; negative values indicate decline. Swings of ±20% or more warrant investigation. |
| ƒReach/Post | AUTO-COMPUTED — Reach per Post for the week, calculated as ƒReach ÷ ƒPosts. This efficiency metric tells you whether adding more posts actually increased overall reach proportionally. A declining Reach/Post while increasing Posts may signal content fatigue. |
| ƒ4-Wk Avg | AUTO-COMPUTED — the rolling four-week average of Reach, smoothing out weekly volatility to reveal the underlying trend. Compare current week Reach to this average: consistently above means accelerating growth; consistently below means deceleration. |
| ƒCumulative | AUTO-COMPUTED — the running total of all Reach from week 1 through the current week. This ever-increasing number shows your total audience exposure over the life of the tracker. Useful for reporting total impressions to clients or stakeholders. |
| ƒForecast | AUTO-COMPUTED — the projected Reach for the next week, calculated from recent trend data (likely a linear or weighted moving average projection). Compare this to actual results to gauge the accuracy of the forecast and anticipate upcoming performance. |
| ƒFcst Δ | AUTO-COMPUTED — Forecast Delta, the difference between actual Reach and the Forecasted Reach for that week (Actual − Forecast). A positive Fcst Δ means you beat the forecast; negative means you fell short. Consistently large deltas suggest the forecast model needs recalibration (usually by logging more consistent data). |
| ƒStreak | AUTO-COMPUTED — the number of consecutive weeks showing positive Reach growth (or the count resets on a decline). A streak of 4+ weeks signals strong sustained momentum. If the streak breaks, analyze what changed that week. |
| ƒVolatility | AUTO-COMPUTED — a measure of how much your weekly Reach fluctuates, likely calculated as the standard deviation or coefficient of variation over recent weeks. High Volatility (large swings) means unpredictable results; low Volatility means consistent, reliable performance. Aim for lower volatility as your strategy matures. |
📊 Reading the numbers
• Latest Posts KPI: the number of posts published in the most recent completed week — compare to your target cadence.
• Fcst Reach KPI: the forecasted reach for the upcoming week — use this to set expectations with clients or plan promotional spending.
• Reach/Post KPI: efficiency metric for the latest week — if this drops below your 4-week average, investigate content quality or timing.
• Wk Growth KPI: the WoW % for the latest week — positive is good, but watch for abnormally high values driven by a single viral post.
• 📈 Actual vs Forecast chart: overlays your real Reach against the forecast line — when actuals consistently exceed forecasts, your strategy is outperforming expectations.
• 📊 Eng % Trend chart: plots weekly engagement rate over time — look for stability or upward movement, not sharp oscillations.
• 📋 Posts per Week chart: a bar chart of weekly post volume — identifies weeks where you fell behind or overposted.
• 📊 Forecast Variance chart: shows the Fcst Δ per week — clusters of positive or negative deltas reveal systematic forecasting bias.
• 📊 Cumulative Reach chart: a steadily ascending line — any flattening indicates stagnation that needs attention.
• ⚡ Reach per Post chart: tracks your efficiency over time — the ideal trajectory is upward (more reach from each post).
⚠️ Avoid these mistakes
• Skipping weeks or leaving gaps in the Week/Start columns — this breaks the sequential calculations for WoW %, Streak, and Cumulative totals.
• Entering overlapping date ranges — each week's Start date should be exactly 7 days after the previous one to avoid double-counting posts.
• Comparing weeks with very different post volumes without considering Reach/Post — a week with 10 posts will naturally have higher total Reach than a week with 3 posts, so efficiency metrics matter more than raw totals.
💡 Tips• Fill in Week and Start dates at the beginning of each month so the formulas are ready to auto-populate as posts are logged.
• Use the ƒForecast value to set weekly reach goals and share them with your team at Monday standups.
• When ƒVolatility is high, look at the Post Log for that period — usually one viral post or one missed day explains the swing.
• Export the Cumulative Reach chart for quarterly reports to stakeholders showing overall audience growth.
The Best Times sheet analyzes your Post Log data by day of the week and by platform to reveal when your audience is most engaged. Use it to optimize your publishing schedule — post on your highest-rated days and platforms for maximum reach and engagement.
✍️ Step by step
11. This sheet is entirely auto-calculated — you do not need to type anything. All data flows from the Post Log and Dashboard.
22. The top table breaks down performance by day of the week (Monday through Sunday), showing post volume, average reach, average engagement rate, average score, and a star Rating.
33. Review the ƒRating column to see which days earn the most stars — schedule your highest-priority content on top-rated days.
44. The bottom table shows performance by platform, including each platform's Best Day (the weekday with the highest engagement on that platform), Peak Eng %, and Consistency score.
55. Cross-reference the per-platform Best Day with the overall day ratings to find the optimal posting windows.
66. Revisit this sheet after every 2–4 weeks of new data, as audience behavior shifts seasonally and with algorithm updates.
📋 Column-by-column
| Day | AUTO-POPULATED — lists each day of the week (Monday through Sunday). This is the anchor column for the daily performance table; do not edit. |
| ƒPosts (Day) | AUTO-COMPUTED — the number of posts published on each weekday, counted from the Post Log using COUNTIFS on the ƒDay column. Shows which days you post most frequently. A day with very few posts may not have enough data for reliable averages. |
| ƒAvg Reach (Day) | AUTO-COMPUTED — the average Reach of posts published on each weekday, pulled via AVERAGEIFS from the Post Log. Higher Avg Reach on certain days suggests your audience is more active then. Compare all seven days to find the peaks. |
| ƒAvg Eng % (Day) | AUTO-COMPUTED — the average Engagement Rate for posts published on each weekday. This is often the most actionable metric — a day with high reach but low engagement means visibility without interaction, while high engagement signals genuine audience interest. |
| ƒAvg Score (Day) | AUTO-COMPUTED — the average composite Score for each weekday, combining reach and engagement into one number. The day with the highest Avg Score is your overall best day to post. |
| ƒRating | AUTO-COMPUTED — a visual star rating (e.g., ★★★★★) or numeric scale ranking each day from best to worst based on a blend of Avg Score, Avg Eng %, and Avg Reach. Five stars (or the highest value) marks your peak day; one star marks your weakest. Schedule your most important content on 4- or 5-star days. |
| Platform (Best Times) | AUTO-POPULATED — lists each platform in the per-platform analysis table. Pulled via INDEX/MATCH from the Dashboard. Do not edit. |
| ƒBest Day | AUTO-COMPUTED — the weekday that produces the highest engagement or score on each specific platform, determined via INDEX/MATCH. For example, your Best Day on Instagram might be Wednesday while your Best Day on LinkedIn might be Tuesday. Customize your posting schedule per platform accordingly. |
| ƒPeak Eng % | AUTO-COMPUTED — the highest single-day average Engagement Rate achieved on each platform. This is the ceiling — if your overall Eng % on that platform is much lower than the Peak, you are likely posting on suboptimal days some of the time. |
| ƒAvg Reach (Platform) | AUTO-COMPUTED — the overall average Reach per post on each platform, providing context alongside the day-specific data. Compare to the per-day numbers to see how much day selection affects reach. |
| ƒPosts (Platform) | AUTO-COMPUTED — total post count per platform, giving you a sense of sample size. Platforms with fewer than 5–10 posts may not have statistically meaningful patterns yet. |
| ƒConsistency | AUTO-COMPUTED — a measure of how consistent each platform's performance is across different weekdays, likely based on the standard deviation or range of daily scores. High Consistency means the platform performs similarly regardless of day — timing matters less. Low Consistency means some days dramatically outperform others — timing matters a lot, so follow the Best Day recommendation closely. |
📊 Reading the numbers
• Avg Reach KPI: the grand average reach across all days — days above this are your high-opportunity windows.
• Avg Eng % KPI: the overall average engagement rate — days significantly above this are engagement sweet spots.
• Avg Score KPI: the blended average score — use as the baseline to judge which days truly excel.
• 📊 Avg Eng % by Day chart: a bar chart comparing weekday engagement rates — the tallest bar is your best day to post for interaction.
• 📈 Avg Reach by Day chart: shows which day generates the widest audience — may differ from the engagement leader.
• 🏆 Peak Eng by Platform chart: shows the highest possible engagement rate per platform, motivating you to optimize timing and hit those peaks.
• 📶 Avg Reach by Platform chart: contextualizes each platform's reach alongside the day data.
• 🥧 Post Share by Day chart: a pie chart showing how your posts are distributed across weekdays — if you're posting mostly on your weakest day, that's an easy fix.
• 📊 Volume by Platform chart: shows how many posts each platform has in the dataset — low-volume platforms need more data before their Best Day is reliable.
⚠️ Avoid these mistakes
• Making scheduling decisions from fewer than 2 weeks of data — early patterns may be coincidental. Wait for at least 10–20 posts spread across multiple weeks.
• Ignoring platform-specific Best Day recommendations and posting everything on the same day — each platform's audience has different online habits.
• Treating the star Rating as permanent — audience habits shift, so revisit this sheet monthly and adjust your schedule.
💡 Tips• Combine the Best Day per platform from this sheet with the top hashtag sets from the Hashtag Library to create your optimal posting formula for each channel.
• If ƒConsistency is low for a platform, day selection is critical — stick tightly to the Best Day. If Consistency is high, you have more scheduling flexibility.
• Use the Post Share by Day pie chart to check if you're accidentally skewing your data by over-posting on one day — even distribution gives more reliable Best Times analysis.
• Share the Best Times findings with your team or client to align on a weekly content calendar backed by data.
📖Glossary — what every value means
| Eng % | Engagement Rate — the percentage of people who interacted with a post out of those who saw it, calculated as (Likes + Comments) ÷ Reach × 100. A rate above 3–5% is generally considered strong, though benchmarks vary by platform. Higher engagement means your content resonates with the audience. |
| Reply % | Reply Rate — the proportion of total engagement that comes from comments rather than likes, calculated as Comments ÷ (Likes + Comments) × 100. A Reply % above 15–20% indicates your content is sparking conversation, not just passive appreciation. |
| Tag ROI | Hashtag Return on Investment — measures whether a particular hashtag set helped a post perform above or below the set's historical average reach. A value above 1.0 means the post outperformed the set's norm; below 1.0 means it underperformed. |
| ROI Score | Return on Investment Score — a composite metric in the Hashtag Library rating the overall value a hashtag set delivers considering reach, engagement, and usage frequency. Scores above 1.0 indicate the set returns more value than average; below 1.0 signals underperformance. |
| Velocity | Engagement Velocity — the speed at which a post accumulates engagement, calculated as (Likes + Comments) ÷ days since posting. Higher velocity indicates fast early traction; typical values depend on your audience size but spikes above your average suggest viral potential. |
| Momentum | A trend indicator showing whether your recent posts' Velocity is accelerating (positive Momentum) or decelerating (negative Momentum) compared to earlier posts. Positive Momentum confirms your content strategy is gaining steam. |
| Percentile | A ranking from 0 to 100 showing where a post falls relative to all your published posts. The 90th percentile means the post outperformed 90% of your content — useful for identifying standout hits. |
| WoW % | Week-over-Week percentage change — the growth or decline in a weekly metric compared to the prior week, calculated as (Current Week − Previous Week) ÷ Previous Week × 100. Positive values indicate growth; negative values indicate decline. |
| Reach/Post | Reach per Post — total weekly Reach divided by the number of posts that week. Measures content efficiency: a high Reach/Post means each post is pulling its weight. Declining Reach/Post with increasing volume may signal content fatigue. |
| Reach/Tag | Reach per Tag — the average Reach of a hashtag set divided by the number of individual hashtags in that set. Measures how efficiently each tag within the set contributes to visibility. Higher values mean fewer tags are doing more work. |
| 4-Wk Avg | Four-Week Rolling Average — the mean Reach over the last four completed weeks, used to smooth out week-to-week fluctuations and reveal the underlying trend. Compare current week Reach to this number to see if you are above or below your recent norm. |
| Fcst Reach | Forecasted Reach — a projection of expected reach for an upcoming period, calculated from recent trend data using a moving average or regression model. Use it for planning and expectation-setting, not as a guarantee. |
| Fcst Δ | Forecast Delta — the difference between actual Reach and forecasted Reach (Actual − Forecast). A positive delta means you outperformed the prediction; a negative delta means you fell short. |
| Streak | Growth Streak — the number of consecutive weeks with positive Reach growth. A streak of 4+ weeks signals sustained momentum. The counter resets when a week shows a decline. |
| Volatility | A measure of how much a metric fluctuates over time, typically based on standard deviation or coefficient of variation. Low Volatility means steady, predictable performance; high Volatility means large week-to-week swings requiring investigation. |
| Win % | Win Rate — the percentage of posts on a given platform that scored above the overall average Score. A Win % above 50% means the platform is reliably strong for your content. |
| Share % | Post Share — the percentage of your total posts published on a given platform. Reveals how your effort is distributed across channels. |
| Hit % | Hit Rate — the percentage of past posts matching a given Platform/Format combination that scored above your overall average. A high Hit % indicates that combination reliably produces strong content. |
| Urgency | A pipeline priority indicator that combines a content idea's Priority level (High/Medium/Low) with how soon it is due (ƒDue In). Ideas that are high priority and due soon receive the highest Urgency rating. |
| Idle Days | The number of days since a hashtag set was last used on a post. Sets idle for 14+ days may contain stale or shadow-banned tags and should be reviewed. |
| Freshness | A qualitative label (Fresh, Aging, or Stale) indicating how recently and consistently a hashtag set has been used. Stale sets should be refreshed with updated tags. |
| Consistency | A measure of how evenly a platform performs across different weekdays. High Consistency means timing matters less; low Consistency means posting day significantly affects results and you should follow Best Day recommendations closely. |
| Est Reach | Estimated Reach — a forecast of a planned post's likely reach based on historical averages for the same Platform and Format. Used in the content pipeline for planning purposes. |
| Est Eng % | Estimated Engagement Rate — a forecast of a planned post's likely engagement rate based on historical data for the same Platform and Format combination. |
| Est Score | Estimated Score — a projected composite performance score for a planned post, derived from historical patterns. |
| Score | A composite performance metric blending Engagement Rate, Reach, and interaction volume into a single number for easy comparison. Higher is better. Posts ranking above your average Score are considered winners. |
| Rank | A numerical ordering of all published posts from best (1) to worst based on their composite Score. Rank 1 is your top performer. |
| Due In | The number of days remaining until a planned post's target Due date. Positive values are days left; negative values mean the deadline has passed. |
| Rating | A star-based or numeric evaluation of each weekday's overall performance, blending Avg Score, Avg Reach, and Avg Eng %. Higher ratings identify your best days to publish. |
| Trend | A directional indicator (up, flat, or down) showing whether a platform's or metric's recent trajectory is improving, holding steady, or declining. Upward trends confirm your strategy is working; downward trends warrant investigation. |
| Posts/Wk | Posts per Week — the average number of posts published weekly across all platforms. Consistent posting cadence (typically 5–7 posts/week for active accounts) supports algorithm favor and audience retention. |
| KPI | Key Performance Indicator — a highlighted summary metric displayed prominently at the top of a sheet for at-a-glance performance monitoring. Each sheet's KPIs surface the most important numbers you should check regularly. |
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
1To open the AI assistant, click the ✨ sparkle icon in the bottom-right corner of your Google Sheets screen. This opens a side panel where you can chat with the built-in AI in plain language — no formulas or technical knowledge required.
2Ask it to explain any cell by typing a prompt like 'explain B7' or 'what does the Eng % formula do?' The assistant reads the cell's formula and gives you a plain-English breakdown. You can also give it commands that act on your sheet — for example, 'sum column C', 'fill the next row with sample data', or 'color row 1 gold'. These commands read your actual data and make changes without breaking any existing formulas.
3Use the one-click presets tailored specifically to this Social Post Scheduler template. These presets run common analyses or actions relevant to social media scheduling with a single tap — no need to type a custom prompt each time. You'll find them in the assistant panel ready to use.
4The Tools tab includes powerful features: 'Analyze All My Data' generates a full performance report and outputs it to a new sheet, 'Auto-Fit' adjusts column widths for readability, and 'Translate' converts every label in the workbook to your preferred language. You can also build a visual infographic summary of your data from within the assistant.
5Customize the assistant's communication style with the Tone selector (choose Friendly, Professional, or Concise) and apply Smart Styling to format your sheets visually. Upgrading to Pro unlocks native chart generation, advanced forecasting, and a comprehensive multi-page report feature.
6You can attach a screenshot or image to the chat — for example, snap a chart from another analytics tool and the assistant will read and interpret it for you. You start with a set of free AI trial requests. After those are used, a subscription plan gives you a bigger monthly allowance of requests to keep using the assistant throughout the month.