📘
Property Content Scheduler Workbook — End-User Instruction Manual
Instruction Manual · How to use this template
The Property Content Scheduler Workbook is a premium Google Sheets template designed for real estate professionals, property managers, and marketing teams who need to plan, execute, and measure every marketing post across a portfolio of listings. It connects three powerful worksheets — a detailed Content Log for every post you publish, a Listings sheet that monitors each property's marketing health, and a Marketing Dashboard that visualizes budget pacing, engagement efficiency, and coverage gaps at a glance. The workflow is simple: log each piece of content you create, and the workbook automatically calculates cost-per-engagement, flags stale listings, ranks your best-performing channels, and tells you exactly where to focus next. Whether you manage five rental units or fifty active sales listings, this workbook replaces scattered spreadsheets and guesswork with a single, formula-driven command center.
⚡ Quick start
1Step 1: Open the workbook and read the 'Read Me' sheet for a quick orientation on color coding, sheet purposes, and any template-specific notes from the creator.
2Step 2: Go to the 'Listings' sheet and enter every property in your portfolio — fill in the Property name, Status (Active/Pending/Sold), Price, and Listed date for each one. This is the foundation the other sheets pull from.
3Step 3: Switch to the 'Content Log' sheet and start recording marketing posts. For each post, enter the Date, Property name (must match Listings exactly), content Type, Platform, Status, Engagement count, Cost, and the post URL. All formula columns will auto-populate instantly.
4Step 4: Open the 'Marketing Dashboard' and set a Target post count and Budget for each property. The dashboard will immediately show your progress, pacing, projected engagement, and spending against those targets.
5Step 5: Review the KPI cards at the top of each sheet — they summarize portfolio-wide health in a single glance. On the Marketing Dashboard, study the six charts to identify your strongest channels, biggest coverage gaps, and budget risks.
6Step 6: Use the auto-computed ƒAction and ƒAlert columns to guide your daily work — they tell you which properties need attention right now and what kind of action to take.
The Content Log is your post-by-post marketing journal. Every time you publish a social media post, listing ad, email blast, video, or any other piece of marketing content for a property, you record it here. The sheet then auto-calculates cost efficiency, engagement velocity, performance rankings, and recommended next actions so you always know what is working and what is not.
✍️ Step by step
11. In the Date column, enter the date the content was published using your spreadsheet's date format (e.g., 2026-06-15). Always use a true date value, not plain text, so formulas can calculate time-based metrics correctly.
22. In the Property column, type the exact property name as it appears in the Listings sheet — spelling and capitalization must match perfectly, because Listings pulls data from this sheet using lookup functions.
33. In the Type column, enter the content format: e.g., Photo, Video, Carousel, Blog, Email, Virtual Tour, Flyer, Story. Be consistent with your naming so the Spend by Format chart on the Dashboard groups correctly.
44. In the Platform column, enter where you posted: e.g., Instagram, Facebook, Zillow, Realtor.com, TikTok, YouTube, Email, Google Ads. Consistent naming is critical because Channel charts and ƒvs Chan rely on it.
55. In the Status column, record the current state: Draft, Scheduled, Published, Boosted, or Archived. Only Published or Boosted posts should have Engagement and Cost filled in.
66. In the Eng (Engagement) column, enter the total engagement count — likes, comments, shares, saves, clicks, or whatever your primary engagement metric is. Use raw numbers (e.g., 342), not formatted strings.
77. In the Cost column, enter how much you spent promoting or producing this piece of content in your local currency (e.g., 25.00 for twenty-five dollars). Enter 0 for organic posts.
88. Paste the live URL of the post in the URL column so you or your team can click through to review the content at any time.
99. Once those input columns are filled, review the auto-computed columns (ƒCPE through ƒvs Chan) — they update instantly and tell you how this post stacks up against your averages, how quickly engagement is decaying, and whether you should boost, repeat, or retire the content.
📋 Column-by-column
| Date | INPUT — Enter the publication date of the content piece. Use a proper date format (e.g., 2026-06-15 or June 15, 2026). This date drives every time-based formula on the sheet, including Engagement per Day, Decay, and the Listings sheet's Last Post and Gap calculations. Example: 2026-06-20. |
| Property | INPUT — Type the name of the property this content is for. This must exactly match a property name in the Listings sheet (case and spacing included), because Listings uses COUNTIFS, FILTER, and AVERAGEIFS lookups keyed on this value. Example: 123 Oak Street. |
| Type | INPUT — The format or category of the content. Use consistent labels like Photo, Video, Carousel, Blog, Email, Virtual Tour, Story, or Flyer. The Marketing Dashboard's 'Spend by Format' chart groups spending by this value, so inconsistent naming (e.g., 'video' vs 'Video') will create duplicate chart categories. Example: Carousel. |
| Platform | INPUT — The channel or platform where the content was published. Examples: Instagram, Facebook, Zillow, TikTok, YouTube, Google Ads, Email. This value feeds the 'Engagement by Channel,' 'Channel Scores,' and 'Posts vs Eng by Channel' charts, as well as the ƒvs Chan and ƒTop Chan computations on the Listings sheet. Be precise and consistent. Example: Instagram. |
| Status | INPUT — The current lifecycle state of the post. Recommended values: Draft, Scheduled, Published, Boosted, Archived. Only rows marked Published or Boosted should have Engagement and Cost data filled in, as draft or scheduled posts have no performance data yet. Example: Published. |
| Eng | INPUT — Short for Engagement. Enter the total number of engagement actions (likes, comments, shares, saves, clicks, or your chosen primary metric) as a whole number. Do not include currency symbols or commas — just the raw count. A post with 58 likes, 12 comments, and 4 shares would be entered as 74. Example: 74. |
| Cost | INPUT — The total amount spent to create and/or promote this piece of content, in your local currency. Enter as a number with up to two decimal places. For purely organic (unpaid) posts, enter 0. Include ad spend, boosting fees, or production costs as appropriate. Example: 35.00. |
| ƒCPE | AUTO-COMPUTED — Cost Per Engagement. Formula in words: Cost ÷ Engagement. It tells you how much you paid for each individual engagement action. A lower CPE is better — it means you are getting interactions cheaply. If you spent $50 and got 200 engagements, your CPE is $0.25. For organic posts (Cost = 0), CPE will be $0.00, which is ideal. Typical healthy range for real estate social content: $0.10–$1.00. Anything above $2.00 per engagement may indicate the content or targeting needs rethinking. |
| ƒROI | AUTO-COMPUTED — Return on Investment. Formula in words: (Engagement − Cost) ÷ Cost, expressed as a percentage or ratio. It measures how much engagement value you received relative to what you spent. A positive ROI means you earned more engagement than you paid for (in relative terms); a negative ROI means you overspent for the engagement received. A high-performing boosted post might show an ROI of 300%+ while a poorly targeted ad could show a negative value. For organic posts where cost is zero, this may display as a special indicator since division by zero is not meaningful. |
| ƒEng/Day | AUTO-COMPUTED — Engagement Per Day. Formula in words: Total Engagement ÷ number of days since the post's Date. This normalizes engagement across posts of different ages so you can fairly compare a post published yesterday to one published three weeks ago. A freshly published viral post might show 50+ Eng/Day while an older steady performer might show 3–5 Eng/Day. Higher is better, but expect natural decline over time as content ages. |
| ƒvs Avg | AUTO-COMPUTED — Versus Average. Formula in words: this post's Engagement compared to the average Engagement of all posts, shown as a percentage difference or ratio. A value above 100% (or above 0% difference) means this post outperformed the portfolio average; below means it underperformed. Use this to quickly spot your winners and losers. Example: +45% means this post earned 45% more engagement than average. |
| ƒScore | AUTO-COMPUTED — Composite performance Score. This is a blended rating that combines multiple factors — typically Engagement, CPE, ROI, and Eng/Day — into a single number so you can rank posts holistically rather than on one metric alone. Higher is better. Posts in the top quartile of Score are your best-performing content and should be studied for replication. Posts with very low Scores are candidates for retirement or rework. |
| ƒDecay | AUTO-COMPUTED — Engagement Decay rate. Formula in words: measures how rapidly a post's engagement is tapering off over time, typically by comparing recent engagement velocity to initial engagement velocity. A high decay value means the post's engagement dropped off quickly after publishing — common for time-sensitive content like open house announcements. A low decay value means the post has evergreen staying power. Use this to decide whether to re-boost a post (low decay = still has life) or retire it (high decay = audience has moved on). |
| ƒRank | AUTO-COMPUTED — Overall Rank. Formula in words: posts are sorted by their ƒScore and assigned a numerical rank, with 1 being the best-performing post in the entire Content Log. Use Rank to instantly find your top performers — filter or sort by this column to surface your best content for replication or your worst content for review. |
| ƒAction | AUTO-COMPUTED — Recommended Action. Based on the post's Score, Decay, CPE, and ROI, this column outputs a plain-language suggestion such as Boost, Repeat, Rework, or Retire. Boost means the post is performing well and could benefit from additional ad spend. Repeat means the content format or topic should be replicated for other properties. Rework means engagement is mediocre but the concept has potential if revised. Retire means the content is underperforming and spending should stop. Treat these as data-driven suggestions, not commands. |
| ƒCum Spend | AUTO-COMPUTED — Cumulative Spend. Formula in words: a running total of Cost from the first row to the current row when sorted by Date. It shows your total marketing expenditure over time. Use this to track how quickly you are burning through your budget and whether spending is accelerating or steady. If Cumulative Spend is climbing faster than cumulative engagement, your efficiency is declining. |
| ƒvs Chan | AUTO-COMPUTED — Versus Channel average. Formula in words: this post's Engagement compared to the average Engagement for all posts on the same Platform. It isolates channel-specific performance — a post might underperform the portfolio average (ƒvs Avg) but overperform within its channel (ƒvs Chan) if that channel typically gets lower engagement. Positive values mean the post beat its channel peers; negative values mean it lagged. Use this alongside ƒvs Avg for a more nuanced view. |
| URL | INPUT — Paste the full URL link to the published content so you or your team can click through to view, edit, or verify the post. Example: https://www.instagram.com/p/ABC123. This column is for reference only and is not used in any formulas. |
📊 Reading the numbers
• Total Spend KPI: shows the sum of all Cost entries across the Content Log. Compare this to your total budget to see how much you have invested so far. If it is approaching your budget limit, slow down paid posts or reallocate.
• Median Eng KPI: the median (middle value) of all Engagement counts. Median is more reliable than average because it is not skewed by one viral post. If your Median Eng is below 50 for social content, your content strategy may need a refresh.
• Momentum KPI: indicates whether overall engagement is trending up or down recently compared to earlier periods. Positive momentum means your recent posts are outperforming older ones — your strategy is improving. Negative momentum is a warning sign.
• Eng KPI: likely shows total or average engagement across all posts. Use this as a quick health check — is engagement growing week over week?
• Cost and CPE KPIs: total cost and the overall cost-per-engagement across all posts. If CPE is rising while Eng is flat, you are paying more for the same results — time to optimize targeting or creative.
⚠️ Avoid these mistakes
• Mismatched Property names: if you type '123 Oak St' in Content Log but '123 Oak Street' in Listings, the lookup formulas will not link them. Always copy-paste property names to avoid mismatches.
• Entering Engagement or Cost for Draft/Scheduled posts: this will skew your averages and KPIs. Only enter performance data for Published or Boosted posts.
• Inconsistent Type or Platform labels: 'IG' vs 'Instagram' or 'video' vs 'Video' will create duplicate categories in charts and break channel comparisons. Pick one label and stick with it.
• Using text dates instead of real dates: typing 'June 15' as plain text instead of a proper date value will break ƒEng/Day, ƒDecay, and every time-based calculation. Always use date-formatted cells.
💡 Tips• Sort by ƒRank to instantly see your best and worst content, then study what your top 5 posts have in common (platform, type, time of day).
• Filter by Platform and review ƒvs Chan to see which channel gives you the best engagement per dollar — this should drive your budget allocation decisions.
• Use the ƒAction column as your daily to-do list: boost what it says to boost, retire what it says to retire, and replicate what it says to repeat.
• Periodically archive old rows (move to a hidden archive tab) to keep the sheet performant while preserving historical data.
The Listings sheet is your property portfolio roster. Every property you are marketing lives here, and the sheet automatically pulls data from the Content Log to show you how well each listing is being covered — how many posts it has, when the last one went up, whether there is a dangerous gap, and which channel performs best for that property. Use this sheet to ensure no listing falls through the cracks.
✍️ Step by step
11. In the Property column, enter the name or address of each property in your portfolio. This name is the key that links to the Content Log, so it must be identical to what you enter there. Add every property, even ones you have not started marketing yet.
22. In the Status column, enter the listing status: Active, Pending, Sold, Coming Soon, or Off Market. This helps you prioritize — Active listings need the most marketing attention.
33. In the Price column, enter the listing price or rental rate as a number (e.g., 425000 or 2200). Do not include currency symbols or commas — formatting should be handled by the cell format. This value feeds into ƒMkt ROI and ƒCost/1K calculations.
44. In the Listed column, enter the date the property was first listed on the market (e.g., 2026-05-01). This drives the ƒDOM (Days on Market) calculation and helps assess marketing urgency — properties listed longer need more aggressive content.
55. Once your properties and their details are entered, all ƒ columns auto-populate by pulling data from the Content Log via COUNTIFS, FILTER, AVERAGEIFS, and INDEX formulas.
66. Review the ƒAlert column regularly — it flags properties with dangerously large gaps between posts or insufficient total coverage. Address these first.
77. Use the ƒPriority column to sort your properties by marketing urgency. High-priority listings are those with high DOM, low post counts, large gaps, and active status — they need content now.
88. Check ƒTop Chan to see which platform delivers the best engagement for each property, then allocate your next post to that channel.
99. Monitor ƒEng Trend to see if a property's engagement is rising or falling over recent posts — a declining trend on an Active listing is a red flag that your content needs refreshing.
📋 Column-by-column
| Property | INPUT — The name or address of the property. Must exactly match the Property column entries in the Content Log for cross-sheet lookups to work. Enter every property in your portfolio, including those not yet marketed. Example: 456 Elm Avenue, Unit 2B. |
| Status | INPUT — The current market status of the property. Use consistent values: Active, Pending, Sold, Coming Soon, or Off Market. Active properties are prioritized by the ƒPriority formula. Example: Active. |
| Price | INPUT — The listing price or monthly rental rate as a plain number. Do not include dollar signs, commas, or text — just the numeric value. This is used to calculate ƒMkt ROI (marketing spend as a percentage of property value) and ƒCost/1K (cost per thousand dollars of listing price). Example: 375000. |
| Listed | INPUT — The date the property was first listed on the market. Use a proper date format (e.g., 2026-04-10). This is used to compute ƒDOM (Days on Market). For properties not yet listed, leave blank or enter the anticipated listing date. Example: 2026-04-10. |
| ƒDOM | AUTO-COMPUTED — Days on Market. Formula in words: Today's Date − Listed Date. It counts how many calendar days the property has been on the market. Higher DOM values indicate a property that has been sitting longer and may need more aggressive or different marketing. In many markets, 0–30 DOM is fresh, 30–90 is moderate, and 90+ is cause for concern. A rising DOM on an Active listing should trigger a content push. |
| ƒPosts | AUTO-COMPUTED — Total Posts count. Formula in words: COUNTIFS across the Content Log counting all rows where the Property column matches this listing's Property name. It shows how many pieces of content have been created for this property. Zero posts on an Active listing is a critical gap. A healthy listing typically has 5–15+ posts depending on your strategy. |
| ƒLast Post | AUTO-COMPUTED — Last Post date. Formula in words: the MAX (most recent) Date from all Content Log rows matching this property. It shows when the last piece of content was published for this listing. If the Last Post date is more than 7–14 days ago on an Active listing, the property is going stale and needs fresh content. |
| ƒGap | AUTO-COMPUTED — Gap in days. Formula in words: Today's Date − ƒLast Post date. It measures how many days have passed since the most recent content was published for this property. A Gap of 0–7 days is healthy, 7–14 is a caution zone, and 14+ is a red flag. Properties with no posts will show the maximum possible gap (since Listed date or a large default value). The Marketing Dashboard and KPIs use the Worst Gap metric to surface the most neglected property. |
| ƒAlert | AUTO-COMPUTED — Alert flag. This column outputs a warning label (e.g., Stale, No Posts, Overdue, or OK) based on the ƒGap value and the property's Status. An Active property with a Gap over 14 days might show 'Stale'; one with zero posts shows 'No Posts.' Sold or Off Market properties typically show 'OK' since they do not need active marketing. Use this column as your early warning system — filter for non-OK values to see which properties need immediate attention. |
| ƒAvg Eng | AUTO-COMPUTED — Average Engagement. Formula in words: AVERAGEIFS across Content Log Engagement values where the Property matches this listing. It shows the mean engagement per post for this property. Compare across properties to see which listings resonate with your audience. A property with high Avg Eng may benefit from more frequent posting; one with low Avg Eng may need a creative refresh or different platform. |
| ƒTop Chan | AUTO-COMPUTED — Top Channel. Formula in words: identifies the Platform with the highest average or total Engagement for this property, using a combination of FILTER and INDEX/MATCH or similar lookup across the Content Log. It tells you which marketing channel works best for this specific listing. Use this to decide where to post next — if Instagram is the top channel for a downtown condo, prioritize Instagram content for that property. |
| ƒSpend | AUTO-COMPUTED — Total Spend for this property. Formula in words: SUMIFS across Content Log Cost values where the Property matches this listing. It shows how much total marketing budget has been spent on this property. Compare to the property's Price to assess proportionality — spending $5,000 to market a $500,000 property (1%) may be reasonable, while the same spend on a $100,000 property (5%) may be excessive. |
| ƒCPE | AUTO-COMPUTED — Cost Per Engagement for this property. Formula in words: ƒSpend ÷ total Engagement for this property. It is the property-level version of the post-level CPE in the Content Log. Lower is better. Compare across properties — if one listing has a CPE three times higher than others, its content or targeting needs work. |
| ƒPriority | AUTO-COMPUTED — Priority ranking. This is a composite score that considers the property's Status, DOM, Gap, Post count, and Engagement Trend to assign a priority level (e.g., High, Medium, Low, or a numeric rank). Active properties with high DOM, few posts, large gaps, and declining engagement rank highest. Use this column to decide which property gets your next marketing effort. |
| ƒPace | AUTO-COMPUTED — Posting Pace. Formula in words: ƒPosts ÷ ƒDOM (or a time-normalized variant), showing how many posts per day or per week are being produced for this property. A healthy pace depends on your strategy, but one post per week (0.14/day) is a common baseline for active listings. If Pace is well below your target, increase content production for that property. |
| ƒMkt ROI | AUTO-COMPUTED — Marketing ROI (Return on Investment). Formula in words: a ratio relating the marketing Spend to the property's Price or value, potentially factoring in Engagement. It measures whether your marketing investment is proportionate and effective relative to the property's value. A very high Mkt ROI means you are getting strong engagement for low spend relative to property value. A low or negative Mkt ROI means you may be overspending for the engagement you are receiving on a given property. |
| ƒEng Trend | AUTO-COMPUTED — Engagement Trend. Formula in words: compares the average engagement of recent posts (e.g., the last 3–5) to earlier posts for this property, showing whether engagement is rising, stable, or declining. An upward trend (often shown as a positive value, arrow, or label like Rising) means your content is gaining traction. A downward trend (Declining) means audience interest is waning and you should try a new creative approach, platform, or content type. |
| ƒCost/1K | AUTO-COMPUTED — Cost per Thousand Dollars of listing price. Formula in words: (ƒSpend ÷ Price) × 1000. It normalizes marketing spend relative to the property's value so you can fairly compare spending across listings of different price points. For example, spending $500 on a $500,000 listing yields a Cost/1K of $1.00, while the same spend on a $250,000 listing yields $2.00. Lower is more efficient. Use this to ensure you are not over-investing in lower-value listings at the expense of higher-value ones. |
📊 Reading the numbers
• Avg DOM KPI: the average Days on Market across all properties. If this is rising over time, your portfolio is sitting longer on average — consider increasing marketing frequency or exploring new channels.
• Coverage KPI: the percentage of Active listings that have at least one post (or meet a minimum threshold). 100% coverage means every active listing has been marketed. Below 80% is a warning — some properties are being ignored.
• Worst Gap KPI: shows the largest ƒGap value in your portfolio — the property that has gone the longest without new content. If this number exceeds 14 days, someone on your team needs to create content for that property today.
• Price KPI: likely an aggregate (average or total) of listing prices, useful for context on portfolio size and for benchmarking spend ratios.
• DOM and Gap KPIs: quick reference numbers that summarize the portfolio's average days on market and average posting gap. Watch both — rising averages signal that properties are aging and content is not keeping up.
⚠️ Avoid these mistakes
• Entering property names that do not exactly match the Content Log — even an extra space will break the lookup formulas and cause ƒPosts, ƒLast Post, and every other computed column to show zero or errors.
• Forgetting to update the Status column when a property goes from Active to Pending or Sold — this will cause the priority formulas to keep flagging it as needing marketing when it does not.
• Leaving the Listed date blank for active properties — ƒDOM will not calculate, which breaks ƒPace and ƒPriority.
• Entering the Price with dollar signs or commas (e.g., $425,000 instead of 425000) — this can cause the cell to be treated as text, breaking ƒMkt ROI and ƒCost/1K.
💡 Tips• Sort by ƒPriority to create your daily marketing to-do list — start with the highest-priority properties each morning.
• Use ƒTop Chan to double down on what works: if a property's top channel is Facebook, schedule your next three posts for that property on Facebook.
• Compare ƒCost/1K across your portfolio to ensure budget allocation is proportionate to property values — luxury listings may warrant higher absolute spend but should have comparable Cost/1K ratios.
• When a property sells, change Status to Sold. The formulas will deprioritize it automatically, but the data stays for historical analysis.
The Marketing Dashboard is your executive control panel. It aggregates data from the Content Log and Listings sheet into a single view with six interactive charts and key performance indicators. Use it for weekly reviews, team meetings, and strategic decisions — it shows at a glance whether you are on pace, within budget, and reaching every property in your portfolio.
✍️ Step by step
11. The Property column auto-populates from the Listings sheet. Do not type in this column — it mirrors your portfolio roster.
22. In the Target column, enter the number of posts you plan to create for each property during your campaign period (e.g., 12 posts over the quarter). This sets the denominator for ƒProgress and ƒGap.
33. In the Budget column, enter the total marketing budget allocated to each property (e.g., 500). This enables the ƒ$ Left, ƒSpend %, and Budget Pacing chart to track your spending against plan.
44. All other columns (ƒPosts through ƒProj Eng) auto-calculate by pulling data from the Content Log using COUNTIFS, FILTER, SUMIFS, and AVERAGEIFS. You do not need to enter anything else.
55. Review the six KPI cards at the top of the sheet for a portfolio-wide pulse check: Coverage, Stale %, Wk CPE, Target, Gap, and Pace.
66. Study the six charts to understand channel performance, budget health, format effectiveness, and per-listing efficiency. Each chart answers a specific strategic question (see Reading section below).
77. If ƒGap shows a large number for any property, that property is behind on content — prioritize it immediately.
88. If ƒ$ Left is negative for any property, you have overspent that property's budget — freeze paid posts and shift to organic content.
99. Use the ƒRank column to identify which properties are getting the best engagement return per dollar and replicate their strategy across the portfolio.
📋 Column-by-column
| Property | AUTO-POPULATED — The property name, pulled from the Listings sheet. Do not edit this column directly; it stays in sync with your Listings roster. Any property added to or removed from Listings will automatically appear or disappear here. |
| ƒPosts | AUTO-COMPUTED — Total Posts count for this property, pulled from the Content Log via COUNTIFS. Same value as ƒPosts on the Listings sheet but displayed here for dashboard convenience. Shows how many pieces of content have been created for this property so far. |
| Target | INPUT — Your planned post count goal for this property over the current campaign or time period. Enter a whole number (e.g., 15). This is the benchmark against which ƒProgress and ƒGap are measured. If you do not set a target, those progress metrics will not be meaningful. Adjust targets as your strategy evolves. |
| ƒProgress | AUTO-COMPUTED — Progress toward target. Formula in words: ƒPosts ÷ Target, expressed as a percentage. 100% means you have hit your posting goal; above 100% means you exceeded it. Below 50% with less than half the campaign remaining is a warning sign. Use this to see which properties are on track and which are falling behind. |
| ƒGap | AUTO-COMPUTED — Gap to target. Formula in words: Target − ƒPosts. It shows how many more posts you need to create to reach your goal. A Gap of 0 means goal met. A large Gap with little time remaining means you need to accelerate content production or revise the target. |
| ƒPace | AUTO-COMPUTED — Current posting pace. Formula in words: ƒPosts ÷ elapsed campaign days (or weeks), projected against the remaining time to see if you will hit your Target at the current rate. If Pace is below 1.0 (or whatever your normalized baseline is), you are behind schedule. Above 1.0 means you are on track or ahead. |
| ƒDays Left | AUTO-COMPUTED — Days Left in the campaign or evaluation period. Formula in words: Campaign End Date − Today's Date (the end date may be a fixed cell reference or derived from the listing period). It tells you how much runway you have to hit your posting and budget targets. As this number shrinks, urgency increases for properties with large ƒGap values. |
| ƒETA | AUTO-COMPUTED — Estimated Time of Arrival to target. Formula in words: ƒGap ÷ current posting rate (ƒPace), showing the estimated number of days until you hit the Target post count at the current pace. If ETA exceeds ƒDays Left, you will not hit your target without accelerating. This is your most actionable pacing metric — it answers 'will I make it at this rate?' with a clear yes or no. |
| ƒSpend | AUTO-COMPUTED — Total Spend for this property, pulled from the Content Log via SUMIFS. Same as ƒSpend on the Listings sheet but displayed here next to Budget for easy comparison. Shown in your currency. |
| ƒEng/$ | AUTO-COMPUTED — Engagement Per Dollar. Formula in words: Total Engagement ÷ Total Spend for this property. It measures raw engagement efficiency — how many engagement actions you get for each dollar spent. Higher is better. A property with 500 engagements on $100 spend has an Eng/$ of 5.0, meaning five interactions per dollar. Compare across properties to find your most cost-effective listings. |
| ƒSpend % | AUTO-COMPUTED — Spend Percentage. Formula in words: ƒSpend ÷ Budget × 100. It shows what percentage of the allocated budget has been consumed. 0% means nothing spent yet; 100% means budget fully used. Over 100% means you have overspent. Aim to keep Spend % roughly proportional to the elapsed campaign time — if you are 50% through the campaign, Spend % around 50% is on track. |
| ƒRank | AUTO-COMPUTED — Efficiency Rank across all properties. Properties are sorted by a composite metric (likely ƒEng/$ or a blend of progress, engagement, and cost efficiency) and assigned a rank, with 1 being the most efficient. Use this to identify which properties are giving you the best return and study their content strategy. |
| Budget | INPUT — The total marketing budget allocated to this property for the campaign period, in your local currency. Enter as a plain number (e.g., 750). This is used to calculate ƒ$ Left, ƒSpend %, and feeds the Budget Pacing chart. Set realistic budgets based on property value and marketing strategy. |
| ƒ$ Left | AUTO-COMPUTED — Dollars Left. Formula in words: Budget − ƒSpend. It shows how much of the allocated budget remains for this property. A positive number means you have room to spend; zero means budget is exhausted; a negative number means you have overspent. If ƒ$ Left is low but ƒGap is high, you may need to shift to organic content or request additional budget. |
| ƒProj Eng | AUTO-COMPUTED — Projected Engagement. Formula in words: estimates the total engagement this property will accumulate by the end of the campaign based on current posting pace and average engagement per post. It is a forward-looking forecast. If Projected Engagement is far below a desired threshold, it signals that you need to either post more frequently or improve content quality to boost per-post engagement. |
📊 Reading the numbers
• Coverage KPI: percentage of properties that have at least one post (or meet a minimum posting threshold). 100% is the goal — anything less means some listings are going unmarketed.
• Stale % KPI: the percentage of active properties whose posting gap exceeds a staleness threshold (e.g., 14 days). A Stale % of 0% is ideal; above 20% means a significant portion of your portfolio is being neglected.
• Wk CPE KPI: Weekly Cost Per Engagement — your average CPE for the current or most recent week. Compare to prior weeks to see if efficiency is improving. A declining Wk CPE is good; a rising Wk CPE means each engagement is costing more.
• Target, Gap, and Pace KPIs: portfolio-level summaries of your posting targets, how far behind you are in aggregate, and your current posting velocity. If Gap is large and Pace is low, you need to create content urgently.
• Engagement by Channel chart: a bar or column chart showing total or average engagement broken down by Platform. Use it to identify your strongest channels (tallest bars) and weakest channels (shortest bars). Reallocate budget toward top channels.
• Budget Pacing chart: visualizes actual spend versus planned budget over time for each property or the portfolio. If the spending line is above the budget line, you are overspending. If below, you have room. Aim to stay close to the pacing line.
• Spend by Format chart: shows how your budget is distributed across content Types (Photo, Video, Carousel, etc.). Use it to identify which formats consume the most budget and cross-reference with engagement charts to see if high-spend formats also deliver high engagement.
• Eng/$ by Listing chart: a bar chart ranking properties by Engagement Per Dollar. Properties on the left (or top) are the most efficient — each dollar spent produces the most engagement. Properties on the right (or bottom) are least efficient and may need creative or targeting changes.
• Channel Scores chart: a composite scoring visualization showing each Platform's overall performance across multiple metrics (engagement, CPE, volume). Use it to decide which channels deserve more investment and which should be scaled back.
• Posts vs Eng by Channel chart: plots the number of posts against total engagement for each channel. Channels in the upper-right quadrant (many posts, high engagement) are your workhorses. Channels in the lower-left (few posts, low engagement) may not be worth the effort. Channels with few posts but high engagement are hidden gems — consider posting more there.
⚠️ Avoid these mistakes
• Forgetting to set Target and Budget for each property — without these inputs, the progress, pacing, spend percentage, and dollars-left calculations have no baseline and will show meaningless values.
• Setting unrealistically high Targets that you cannot achieve, which makes every property look perpetually behind and causes alert fatigue.
• Ignoring the ƒETA column — Progress might look acceptable at 60%, but if ETA shows you need 45 more days and you only have 10 left, you will not make it.
• Manually editing auto-populated columns like Property or ƒPosts — these are formula-driven and your edits will be overwritten or cause errors.
💡 Tips• Use this sheet as your weekly review tool: every Monday, scan the KPIs and charts to set priorities for the week ahead.
• If ƒ$ Left is approaching zero but ƒGap is still large, pivot to organic content (zero-cost posts like agent videos, neighborhood photos, or client testimonials) to close the gap without overspending.
• Export or screenshot the charts for client reports or team presentations — they visualize your marketing effort and ROI in an easy-to-understand format.
• Compare the Engagement by Channel and Channel Scores charts side by side: a channel might have high total engagement simply because you post there often, but a low Channel Score if its per-post efficiency is poor.
📖Glossary — what every value means
| CPE (Cost Per Engagement) | Cost Per Engagement — the amount of money spent for each individual engagement action (like, comment, share, click, save). Calculated as total Cost divided by total Engagement. Lower is better. In real estate social marketing, a CPE under $1.00 is generally efficient; above $2.00 warrants review. |
| ROI (Return on Investment) | Return on Investment — a ratio measuring the value received relative to the cost incurred. In this template, calculated as (Engagement − Cost) ÷ Cost. A positive ROI means you received more engagement value than you spent; a negative ROI means you overspent. Higher percentages indicate more efficient marketing. |
| Eng/Day (Engagement Per Day) | Engagement Per Day — total engagement divided by the number of days since the content was published. It normalizes engagement across posts of different ages for fair comparison. Higher values indicate faster or stronger engagement accumulation. |
| DOM (Days on Market) | Days on Market — the number of calendar days a property has been actively listed for sale or rent. Calculated as Today's Date minus the Listed Date. Lower DOM is generally better, indicating faster transactions. High DOM (90+ days) suggests the listing needs more marketing or a price adjustment. |
| Eng (Engagement) | Engagement — the total count of audience interactions with a piece of content, including likes, comments, shares, saves, clicks, or other platform-specific actions. Entered as a raw number. Higher engagement indicates content that resonates with your audience. |
| Eng/$ (Engagement Per Dollar) | Engagement Per Dollar — the number of engagement actions received for each dollar of marketing spend. Calculated as total Engagement divided by total Spend. Higher is better. An Eng/$ of 10 means you got ten interactions for every dollar spent. |
| Mkt ROI (Marketing ROI) | Marketing Return on Investment — measures how effectively your marketing spend converts into engagement relative to the property's value. A high Mkt ROI means you are generating strong engagement with low spend relative to the property's price. Useful for comparing marketing efficiency across properties of different values. |
| Cost/1K (Cost Per Thousand) | Cost Per Thousand Dollars of listing price — calculated as (Marketing Spend ÷ Property Price) × 1000. It normalizes marketing costs relative to property value so you can compare spending efficiency across listings of different price points. Lower is more efficient. |
| Wk CPE (Weekly CPE) | Weekly Cost Per Engagement — the average CPE for the current or most recent week. Used to track short-term efficiency trends. A declining Wk CPE over consecutive weeks indicates improving marketing efficiency. |
| Stale % | Stale Percentage — the share of active listings whose most recent post exceeds a freshness threshold (typically 14 days). A Stale % of 0% means every active property has recent content. Rising Stale % indicates growing content gaps across the portfolio. |
| Coverage | Coverage — the percentage of active listings that have at least one marketing post (or meet a minimum posting threshold). 100% coverage means every active property is being marketed. Below 100% means some properties have no content at all. |
| Cum Spend (Cumulative Spend) | Cumulative Spend — a running total of all marketing costs from the first entry to the current row, sorted by date. Shows how total expenditure accumulates over time. Useful for tracking budget burn rate. |
| ETA (Estimated Time of Arrival) | Estimated Time of Arrival to target — the projected number of days until a property reaches its Target post count at the current posting pace. Calculated as Gap (remaining posts needed) divided by current Pace. If ETA exceeds Days Left, the target will not be met without acceleration. |
| Proj Eng (Projected Engagement) | Projected Engagement — a forward-looking estimate of the total engagement a property will accumulate by the end of the campaign, based on current posting rate and average engagement per post. Helps anticipate whether engagement goals will be met. |
| Momentum | Momentum — a trend indicator comparing recent engagement performance to earlier periods. Positive momentum means recent posts are outperforming historical averages, suggesting an improving strategy. Negative momentum is a warning that audience interest or content quality may be declining. |
| Decay | Engagement Decay — a measure of how quickly a post's engagement rate drops off after initial publication. High decay means engagement faded fast (typical for time-sensitive announcements); low decay means the content has lasting appeal. Useful for deciding whether to re-boost or retire a post. |
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 built-in AI assistant, click the sparkle (✨) icon in the side panel of your Google Sheets workbook. The AI assistant is a chat-based tool where you type questions or commands in plain language — for example, 'explain cell F5' will break down the formula in that cell and tell you exactly what it calculates and why, or 'what does the CPE column mean?' will give you a plain-English explanation tailored to this template.
2You can issue action commands that read your data and make changes without breaking any formulas. For example, type 'sum column C' to get a quick total, 'fill the next row with a new entry for 123 Oak Street' to auto-populate a row, or 'color row 1 gold' to apply formatting. These are typed commands in the chat, not standalone buttons — the AI reads your instruction and executes it directly on the sheet.
3The AI assistant includes one-click presets tailored specifically to this Property Content Scheduler template. These presets run common analyses and actions relevant to property marketing workflows with a single click, saving you from typing repetitive prompts. You can also scan the entire workbook for errors, inconsistencies, or opportunities by asking the AI to review your data holistically, and you can attach a screenshot or image (such as a competitor's marketing report) for the AI to read and interpret.
4Under the Tools tab, you will find ANALYZE ALL MY DATA, which generates a comprehensive analytical report and outputs it to a new sheet — perfect for monthly reviews or client presentations. The Tools tab also includes AUTO-FIT columns to resize all columns for optimal readability, TRANSLATE to convert every label in the workbook to another language, and the ability to build an INFOGRAPHIC from your data. A Tone selector lets you choose between Friendly, Professional, and Concise styles for AI responses, and Smart Styling applies polished formatting to your sheets.
5Pro features unlock native chart creation, data forecasts, and a full multi-page report — ideal for in-depth portfolio analysis and professional client deliverables. The AI assistant comes with free trial requests to get you started. After the trial, a subscription gives you a bigger monthly allowance of AI requests so you can continue using all features at scale.