📘
Content Revenue Ranker Workbook — Complete User Manual
Instruction Manual · How to use this template
The Content Revenue Ranker Workbook is a premium Google Sheets template that lets you rank every piece of content you publish — blog posts, videos, newsletters, and more — by actual revenue, ROI, and profit margin. It is built for content marketers, creators, solopreneurs, and marketing managers who need to know exactly which content earns money and which drains budget. You enter your content details and costs into the Content Revenue Log, rate each piece on four weighted dimensions in the Revenue Scorecard, and then the Dashboard automatically surfaces your highest-performing and lowest-performing content at a glance. A weighted scoring system produces a clear verdict for every piece — Scale, Optimize, or Retire — so every content dollar works harder.
⚡ Quick start
1Step 1 — Open the workbook and read the 'Read Me' sheet for a quick orientation, color-key legend, and any template-specific notes.
2Step 2 — Go to the 'Content Revenue Log' sheet and enter one row per content piece: Title, Type, Channel, Published date, Views, Leads, Revenue earned, Spend (cost), and your revenue Goal. All formula columns (marked ƒ) will populate instantly.
3Step 3 — Switch to the 'Revenue Scorecard' sheet. For each content piece, rate its Reach, Engage, Impact, and Efficiency on the provided scale (typically 1–10). The scorecard auto-calculates a weighted Score, Verdict, Rank, and 90-day Forecast.
4Step 4 — Open the 'Dashboard' sheet to see your portfolio-level KPIs, top content by profit, revenue vs spend comparisons, and daily revenue rates — all updated live from the other two sheets.
5Step 5 — Use the KPI cards and charts on each sheet to decide what to scale, what to optimize, and what to retire. Sort or filter any column to drill into specifics.
6Step 6 — Open the ✨ AI side-panel at any time to ask questions, run commands, or generate a full data report — no formulas to learn.
The Content Revenue Log is your master data-entry sheet. Every piece of content you have ever published gets one row here. You enter the facts — title, type, channel, date, traffic, leads, revenue, spend, and goal — and the sheet auto-calculates profit, ROI, cost efficiency, conversion rate, revenue rank, margin, a composite score, and more. This is the single source of truth that feeds both the Revenue Scorecard and the Dashboard.
✍️ Step by step
11. In the Title column, type the name of the content piece exactly as published (e.g., '10 SEO Tips for 2026'). Use one row per piece.
22. In Type, enter the content format — for example 'Blog', 'Video', or 'Newsletter'. Keep spelling consistent so the summary table groups correctly.
33. In Channel, enter the distribution platform — e.g., 'YouTube', 'Website', 'Email', 'LinkedIn'. Again, keep capitalization and spelling consistent.
44. In Published, enter the publication date in YYYY-MM-DD or your locale's date format (e.g., 2026-01-15). This date drives the ƒAge and ƒ$/Day calculations.
55. Fill in Views (total impressions or page views), Leads (number of email sign-ups, demo requests, or other conversions), and Revenue (total dollars earned from this piece — ads, affiliates, product sales, sponsorships, etc.).
66. In Spend, enter the total cost to produce and promote the piece (writer fees, ad spend, tools, etc.). Enter 0 if there was no cost.
77. In Goal, type your revenue target for this piece in dollars (e.g., 500). This powers the ƒProgress column so you can see how close each piece is to its target.
88. Once a row is complete, all ƒ columns auto-populate: Profit, ROI, $/View, Progress, Conv%, Age, Rank, $/Lead, $/Day, Payback, Rev%, Margin, Score, and Top%. Do not type in these cells.
99. Review the summary table on the right (ƒType, Pieces, Revenue, Profit, Avg Rev) and the KPI cards (Total Revenue, Net Profit, Weighted ROI, Avg Margin, Views, Leads) to monitor portfolio health. Use the six charts to visualize trends.
📋 Column-by-column
| Title | INPUT — Type the exact name of the content piece as it appears when published. Use a consistent naming convention so you can find and sort entries easily. Example: '10 SEO Tips for 2026' or 'May Newsletter #4'. |
| Type | INPUT — The format of the content. Use a short, consistent label such as 'Blog', 'Video', 'Newsletter', 'Podcast', or 'Infographic'. Consistency matters because the summary table and charts group by this value. |
| Channel | INPUT — The primary distribution platform or channel for this content. Examples: 'YouTube', 'Website', 'Email', 'LinkedIn', 'TikTok'. Keep spelling uniform across rows so aggregation formulas work correctly. |
| Published | INPUT — The date the content was first published, in date format (e.g., 2026-01-15 or 01/15/2026 depending on your locale). This date is used to calculate ƒAge (days since publication) and ƒ$/Day (revenue earned per day since publish). |
| Views | INPUT — Total views, impressions, or page views the content has received to date. Enter as a whole number with no currency symbol (e.g., 12500). This drives the ƒ$/View efficiency metric. |
| Leads | INPUT — The number of measurable conversions generated by this content — email sign-ups, demo requests, trial starts, or other lead actions. Enter as a whole number (e.g., 45). This is used to calculate ƒConv% and ƒ$/Lead. |
| Revenue | INPUT — Total revenue in dollars attributed to this content piece. Include all monetization: ad revenue, affiliate commissions, product sales, sponsorship fees, etc. Enter as a number without the dollar sign (e.g., 1200). This is the key input for most computed metrics. |
| Spend | INPUT — Total cost in dollars to create and promote this content piece. Include writer or production fees, paid promotion, tool costs, and any other direct expenses. Enter 0 if the piece had no cost. Example: 350. |
| ƒProfit | Profit equals Revenue minus Spend. It tells you the net dollars earned after covering all costs for this content piece. A positive value means the piece is profitable; a negative value means it lost money. Formula: Profit = Revenue − Spend. |
| ƒROI | Return on Investment, expressed as a percentage. It measures how much return you earned for every dollar spent. Formula: ROI = (Revenue − Spend) ÷ Spend × 100. An ROI of 200% means you earned $2 for every $1 spent. Values above 100% are generally good; below 0% means a loss. |
| ƒ$/View | Revenue per View (also called Dollars per View). It shows how much revenue each individual view generated. Formula: $/View = Revenue ÷ Views. A higher value means your content monetizes eyeballs efficiently. Typical ranges vary by niche — $0.01–$0.05 per view is common for ad-supported content, while high-ticket niches can see $0.50 or more. |
| Goal | INPUT — Your revenue target for this content piece, in dollars. Enter the amount you expected or hoped this piece would earn (e.g., 500). This powers the ƒProgress metric. Leave blank or enter 0 if you have no specific target. |
| ƒProgress | Progress toward your revenue Goal, expressed as a percentage. Formula: Progress = Revenue ÷ Goal × 100. A value of 100% means the piece hit its target; above 100% means it exceeded the goal. Below 50% may signal the piece needs optimization or promotion. |
| ƒConv% | Conversion Rate, expressed as a percentage. It measures the share of viewers who became leads. Formula: Conv% = Leads ÷ Views × 100. A Conv% of 2–5% is typical for blog content; landing pages or email may see 10%+. A very low rate suggests the content attracts traffic but fails to convert. |
| ƒAge | Age in days since the content was published. Formula: Age = Today's Date − Published Date. This is used to calculate time-based metrics like ƒ$/Day. Older content with sustained revenue is a strong asset; new content will naturally have a lower Age. |
| ƒRank | A numerical rank assigned to this content piece based on its overall performance relative to all other pieces in the log. Rank 1 is the best performer. The ranking is driven by the composite ƒScore. Use it to quickly identify your top and bottom content. |
| ƒ$/Lead | Revenue per Lead (Dollars per Lead). It shows the average revenue generated by each lead this content produced. Formula: $/Lead = Revenue ÷ Leads. A higher value means each conversion is more valuable. If this is low but Conv% is high, the content attracts many low-value leads. |
| ƒ$/Day | Revenue per Day (Dollars per Day), also called Revenue Velocity. It measures how much revenue the content earns on average each day since publication. Formula: $/Day = Revenue ÷ Age. A high $/Day means the piece generates consistent, ongoing income. Useful for comparing content of different ages on a level playing field. |
| ƒPayback | Payback Period in days. It estimates how many days it took (or will take) for the content's revenue to cover its cost. Formula: Payback = Spend ÷ (Revenue ÷ Age), i.e., Spend ÷ daily revenue rate. A shorter payback period is better — under 30 days is excellent. If revenue is zero, payback is undefined or infinite, signaling the piece has not yet earned back its investment. |
| ƒRev% | Revenue Share, expressed as a percentage. It shows what fraction of your total portfolio revenue this single piece contributes. Formula: Rev% = (Revenue of this piece ÷ Total Revenue of all pieces) × 100. A high Rev% means this piece is a major revenue driver. If one piece has 40%+ Rev%, your portfolio may be too dependent on it. |
| ƒMargin | Profit Margin, expressed as a percentage. It shows how much of each revenue dollar is kept as profit after costs. Formula: Margin = Profit ÷ Revenue × 100. A Margin of 70–90% is excellent for content (low production cost, high return). Below 20% suggests high costs relative to earnings. A negative Margin means the piece is losing money. |
| ƒScore | A composite weighted score that combines multiple performance dimensions — revenue, ROI, efficiency, conversion, velocity, and margin — into a single number. Higher is better. This score drives the ƒRank and ƒTop% columns. Use it as your single best measure of overall content performance. |
| ƒTop% | Top Percentile ranking. It tells you where this piece falls within your entire content portfolio, expressed as a percentile. Formula: Top% = Rank ÷ Total Pieces × 100. A Top% of 10% means the piece is in your top 10% of all content. Use this to quickly flag elite performers and underperformers. |
| ƒType | SUMMARY TABLE — This auto-populated column lists each unique content Type from your log (e.g., Blog, Video, Newsletter). It groups your data so you can compare performance across formats. |
| Pieces | SUMMARY TABLE — The count of content pieces for each Type. Formula: counts the number of rows matching that Type. Helps you see which formats you produce most. |
| Revenue | SUMMARY TABLE — Total revenue for all pieces of this Type. Formula: sums Revenue for rows matching the Type. Compare across types to see which format earns the most. |
| Profit | SUMMARY TABLE — Total profit for all pieces of this Type. Formula: sums Profit for rows matching the Type. A type with high revenue but low profit may have excessive production costs. |
| Avg Rev | SUMMARY TABLE — Average revenue per piece for this Type. Formula: Total Revenue of Type ÷ Pieces of Type. Useful for identifying which format delivers the highest per-piece return. |
📊 Reading the numbers
• Total Revenue (KPI) — The sum of all Revenue values across every content piece. This is your gross content income. Compare month over month to track growth.
• Net Profit (KPI) — Total Revenue minus Total Spend across all pieces. If this number is negative, you are spending more on content than you earn. Aim for steady growth.
• Weighted ROI (KPI) — A portfolio-level ROI that weights each piece's ROI by its share of total spend, giving a more accurate picture than a simple average. Values above 100% mean your content investment is profitable overall.
• Avg Margin (KPI) — The average Profit Margin across all pieces. Healthy content portfolios typically show 50–80%+ average margin. Low margins suggest overspending on production or promotion.
• Views and Leads (KPIs) — Total traffic and total conversions across all content. Use these to gauge overall reach and funnel health.
• Revenue vs Spend (chart) — A bar or column chart comparing total revenue against total spend per piece or per type. Bars where revenue far exceeds spend are your winners; the reverse signals cost problems.
• Profit by Piece (chart) — Shows each content piece's profit side by side. Look for pieces with negative bars — those are candidates for retirement or cost reduction.
• Revenue by Type (chart) — Breaks down total revenue by content format. Quickly see whether blogs, videos, or newsletters drive the most income.
• Revenue Velocity (chart) — Plots $/Day over time or per piece. Pieces with high velocity are generating revenue fast; flat or declining velocity may indicate content decay.
• ROI by Content (chart) — Ranks each piece by ROI percentage. Outliers with extremely high ROI deserve more investment; those near or below 0% need review.
• Avg Rev per Type (chart) — Shows the average revenue per piece for each content type, helping you decide which format to double down on.
⚠️ Avoid these mistakes
• Inconsistent Type or Channel labels (e.g., 'blog' vs 'Blog' vs 'Blog Post') will cause the summary tables and charts to split what should be one category into several. Pick a convention and stick to it.
• Leaving Spend blank instead of entering 0 can cause ROI, Margin, and Payback formulas to return errors. Always enter 0 for no-cost content.
• Entering Revenue or Spend with dollar signs or commas (e.g., '$1,200') instead of plain numbers (1200) may break calculations. Use plain numbers only.
• Forgetting to enter the Published date will cause ƒAge, ƒ$/Day, and ƒPayback to show errors or zero. Every row needs a date.
💡 Tips• Sort by ƒScore descending to instantly see your best-performing content at the top.
• Use Google Sheets' built-in filter to isolate a single Type or Channel and study its performance in isolation.
• Update Views, Leads, and Revenue monthly (or weekly) to keep velocity and payback metrics accurate and actionable.
• Duplicate a row and update the date and metrics to track the same content's performance over different time periods.
The Revenue Scorecard adds a qualitative dimension to your content analysis. While the Content Revenue Log tracks hard numbers, this sheet lets you rate each piece across four weighted dimensions — Reach, Engage, Impact, and Efficiency — to produce a composite Score and a clear Verdict (Scale, Optimize, or Retire). It also auto-generates a 90-day revenue forecast and a percentile ranking, and it aggregates performance by Channel.
✍️ Step by step
11. The Title column auto-populates or should match exactly the titles in your Content Revenue Log. Ensure consistency so VLOOKUP formulas can pull the correct data.
22. For each content piece, rate its Reach on a scale (e.g., 1–10). Reach measures how widely the content was distributed and seen — consider total views, impressions, social shares, and organic discovery.
33. Rate Engage (1–10): how well the audience interacted with the content — comments, likes, time on page, click-through rate, and similar engagement signals.
44. Rate Impact (1–10): the business value the content delivered — leads generated, sales influenced, brand authority built, or strategic goals advanced.
55. Rate Efficiency (1–10): how cost-effective the piece was to produce and promote relative to results. A high-cost piece with modest results scores low; a low-cost viral hit scores high.
66. Once all four ratings are entered, ƒScore, ƒRevenue, ƒVerdict, ƒProfit, ƒRank, ƒ$/Pt, ƒ90d Fcst, ƒPctile, ƒRev #, and ƒRev Gap auto-calculate. Do not type in these cells.
77. Review the Channel summary table on the right (Channel, ƒPieces, ƒRevenue, ƒAvg ROI, ƒConv%, ƒSpend, ƒProfit, ƒROAS, ƒMargin) to compare channel-level performance.
88. Check the ƒVerdict column for each piece: 'Scale' means invest more, 'Optimize' means improve before scaling, and 'Retire' means stop investing.
99. Use the six charts (Weighted Scores, Revenue by Channel, Profit by Channel, Score Breakdown, ROAS by Channel, Score vs Revenue) to visualize patterns and present findings to stakeholders.
📋 Column-by-column
| Title | INPUT — The name of the content piece, matching exactly the Title in the Content Revenue Log. This must be identical (case-sensitive) for VLOOKUP formulas to pull revenue, profit, and other data correctly. Example: '10 SEO Tips for 2026'. |
| Reach | INPUT — Your rating of how broadly this content was distributed and discovered, on a scale of 1 to 10. Consider total views, impressions, social shares, search rankings, and syndication. A score of 1 means almost no one saw it; 10 means it reached a very large audience relative to your niche. |
| Engage | INPUT — Your rating of how deeply the audience interacted with this content, on a scale of 1 to 10. Consider comments, likes, shares, average time on page, scroll depth, click-through rate, and reply rate. A score of 1 means the audience bounced immediately; 10 means highly active engagement. |
| Impact | INPUT — Your rating of the business results this content delivered, on a scale of 1 to 10. Consider leads generated, sales directly attributed, strategic positioning, brand authority, and whether it moved key business metrics. A score of 1 means negligible business impact; 10 means it drove significant measurable results. |
| Efficiency | INPUT — Your rating of the cost-effectiveness of producing and promoting this content, on a scale of 1 to 10. A piece that cost almost nothing but delivered strong results scores 9–10. A piece with high production and promotion costs relative to its output scores 1–3. |
| ƒScore | The weighted composite score combining Reach, Engage, Impact, and Efficiency into a single performance number. Each dimension is weighted (the exact weights are built into the formula) to reflect its relative importance to revenue generation. A higher Score is better. This score drives the Verdict, Rank, and Percentile columns. Typical range depends on your rating patterns — scores in the top quartile are your best content. |
| ƒRevenue | Total revenue for this content piece, pulled automatically from the Content Revenue Log via VLOOKUP. You do not enter this — it mirrors the Revenue column in the log. Displayed here so you can see financial performance alongside qualitative scores. |
| ƒVerdict | An auto-generated action recommendation based on the composite Score. Possible values: 'Scale' (high score — invest more resources, repurpose, promote further), 'Optimize' (mid-range score — improve engagement or distribution before scaling), or 'Retire' (low score — stop promoting, archive, or replace). Follow these verdicts to allocate your content budget efficiently. |
| ƒProfit | Net profit for this content piece, pulled from the Content Revenue Log via VLOOKUP. Formula: Profit = Revenue − Spend. Displayed here for side-by-side comparison with the qualitative Score. Negative profit on a high-Score piece may indicate a pricing or monetization gap. |
| ƒRank | Numerical rank of this piece based on its ƒScore relative to all other scored pieces. Rank 1 is the highest-scoring content. Use this to quickly identify your top performers and your weakest entries. |
| ƒ$/Pt | Revenue per Score Point (Dollars per Point). Formula: $/Pt = Revenue ÷ Score. It measures how much revenue each point of your weighted score translates into. A high $/Pt means the content not only scores well but also monetizes that quality effectively. A low $/Pt on a high-Score piece suggests untapped revenue potential. |
| ƒ90d Fcst | 90-Day Revenue Forecast. This projects how much revenue the content piece is likely to generate over the next 90 days based on its current daily revenue rate ($/Day from the Content Revenue Log). Formula: 90d Fcst = $/Day × 90. Use this to estimate near-term income and prioritize content that will deliver the most revenue in the coming quarter. |
| ƒPctile | Percentile ranking of this piece within the scored portfolio. A Pctile of 90 means this piece scores higher than 90% of all your content. Use this to set benchmarks — for example, only scale content above the 75th percentile, and consider retiring content below the 25th percentile. |
| ƒRev # | Revenue Rank — a numerical ranking of this content piece by revenue alone (not by Score). Rank 1 is the highest-earning piece. Compare this with ƒRank (score-based) to spot discrepancies — a piece ranked high by revenue but low by score may be earning well despite poor fundamentals, or vice versa. |
| ƒRev Gap | Revenue Gap — the difference between this piece's revenue and the revenue of the top-ranked piece. Formula: Rev Gap = Revenue of #1 piece − Revenue of this piece. A small gap means this piece is close to the top earner; a large gap highlights how far behind it trails. Use this to set realistic improvement targets. |
| Channel | SUMMARY TABLE — Auto-populated list of each unique Channel from your data (e.g., YouTube, Website, Email). Groups scorecard data so you can compare channel-level performance at a glance. |
| ƒPieces | SUMMARY TABLE — Count of scored content pieces per Channel. Helps you see where you are investing the most content effort. |
| ƒRevenue | SUMMARY TABLE — Total revenue generated by all content in each Channel. Formula: sums revenue for all pieces matching that Channel. |
| ƒAvg ROI | SUMMARY TABLE — Average Return on Investment for content in each Channel. Formula: averages the ROI of all pieces in the Channel. Channels with Avg ROI above 100% are profitable on average; below 100% may need cost optimization. |
| ƒConv% | SUMMARY TABLE — Average Conversion Rate for each Channel. Formula: averages the Conv% of all pieces in that Channel. Helps you see which channels turn viewers into leads most effectively. |
| ƒSpend | SUMMARY TABLE — Total spend across all content pieces in each Channel. Compare against ƒRevenue and ƒProfit to evaluate channel-level investment efficiency. |
| ƒProfit | SUMMARY TABLE — Total profit for each Channel. Formula: sums profit for all pieces in the Channel. A Channel with high revenue but low or negative profit needs cost control. |
| ƒROAS | Return on Ad Spend for each Channel, expressed as a ratio or percentage. Formula: ROAS = Revenue ÷ Spend. A ROAS of 4.0 means you earned $4 for every $1 spent. While similar to ROI, ROAS is commonly used in advertising contexts and does not subtract the cost first. Values above 3.0 are generally considered strong. |
| ƒMargin | SUMMARY TABLE — Average or total Profit Margin for each Channel. Formula: Profit ÷ Revenue × 100. Shows the profitability of each channel after costs. High-margin channels are more sustainable for long-term investment. |
📊 Reading the numbers
• Reach, Engage, Impact, Efficiency, Score, Revenue (KPIs) — These six KPI cards at the top show portfolio-wide averages or totals for each scorecard dimension plus total revenue. Use them to gauge overall content quality and spot which dimension is weakest across your entire portfolio.
• Weighted Scores (chart) — Displays each content piece's composite ƒScore as a bar or column. Quickly spot which pieces rise above or fall below the average. Pieces clustered near the bottom are retirement candidates.
• Revenue by Channel (chart) — Shows total revenue broken down by channel. If one channel dominates, consider diversifying. If a channel shows low revenue despite many pieces, investigate why.
• Profit by Channel (chart) — Similar to Revenue by Channel but shows profit. A channel with high revenue but low profit has a cost problem.
• Score Breakdown (chart) — Breaks out the four individual dimension scores (Reach, Engage, Impact, Efficiency) for each content piece, letting you see which dimension pulls a piece up or drags it down.
• ROAS by Channel (chart) — Compares Return on Ad Spend across channels. The highest-ROAS channel gives you the best bang for your buck. Channels below 1.0 ROAS are losing money.
• Score vs Revenue (chart) — A scatter plot or comparison chart plotting each piece's Score against its Revenue. Pieces in the high-Score, high-Revenue quadrant are your stars. High-Score but low-Revenue pieces have untapped potential. Low-Score but high-Revenue pieces may be flukes or one-offs.
⚠️ Avoid these mistakes
• Using different titles in the Scorecard than in the Content Revenue Log will break the VLOOKUP lookups, causing ƒRevenue, ƒProfit, and other pulled values to show errors or blanks. Copy-paste titles to ensure exact matches.
• Rating all content the same score (e.g., all 7s) eliminates differentiation and makes the Verdict useless. Be honest and use the full 1–10 range.
• Ignoring the Verdict column and continuing to invest in content marked 'Retire' is the most common way to waste budget. Trust the data.
• Forgetting to update scores as content matures — a blog post with low initial Reach may gain organic traffic over time and deserve a higher Reach rating in a later review.
💡 Tips• Schedule a monthly or quarterly scorecard review: re-rate Reach, Engage, Impact, and Efficiency for your existing content as new data comes in.
• Sort by ƒVerdict to group all 'Scale', 'Optimize', and 'Retire' pieces together for batch decision-making.
• Use the ƒRev Gap column to set specific, measurable revenue targets for underperforming content — aim to close the gap by a certain percentage.
• Compare ƒRank (score-based) with ƒRev # (revenue-based) to find pieces that score well but under-earn — these are your biggest optimization opportunities.
The Dashboard is your executive-level overview. It pulls data from both the Content Revenue Log and the Revenue Scorecard to present portfolio-wide KPIs, top-performing content, channel breakdowns, and trend charts in a single view. Use it for quick status checks, stakeholder presentations, and strategic decision-making without needing to dig into the detail sheets.
✍️ Step by step
11. You do not enter data on the Dashboard — every cell is auto-computed from the Content Revenue Log and Revenue Scorecard. Simply navigate here after entering data in the other sheets.
22. Review the main KPI cards at the top: Total Revenue, Net Profit, Profit Margin, Portfolio $/Day, Revenue, and Profit. These give you an instant health check of your entire content operation.
33. Check the content-level table (Title, ƒRevenue, ƒProfit, ƒScore, ƒROI, ƒVerdict, ƒ$/Day) to see each piece's key metrics and verdict in one consolidated row. This table pulls from both the Content Revenue Log (Revenue, Profit, ROI, $/Day) and the Revenue Scorecard (Score, Verdict).
44. Review the Channel summary table (Channel, ƒPieces, ƒRevenue, ƒSpend, ƒProfit, ƒROI) to compare channel-level performance at a glance.
55. Use the six Dashboard charts to visualize your portfolio: Revenue vs Spend, Profit by Channel, Top Content by Profit, Daily Revenue Rate, Content Scores, and ROI by Channel.
66. Share this sheet (or export it as PDF) with stakeholders who need a high-level view without access to the underlying data sheets.
77. Return to this sheet after each data update cycle (weekly or monthly) to track trend changes in KPIs and identify new winners or struggling pieces.
📋 Column-by-column
| Title | AUTO-POPULATED — The name of each content piece, pulled from the Content Revenue Log. This column lists all tracked content so you can see per-piece metrics at a glance on the Dashboard. |
| ƒRevenue | Total revenue for this content piece, pulled via VLOOKUP from the Content Revenue Log. Displayed here for quick reference alongside Score and Verdict from the Scorecard. |
| ƒProfit | Net profit for this content piece (Revenue minus Spend), pulled from the Content Revenue Log. A negative value highlights content that is costing you more than it earns. |
| ƒScore | The weighted composite score from the Revenue Scorecard, pulled via VLOOKUP. Gives you a qualitative performance measure right next to the financial metrics so you can see the full picture. |
| ƒROI | Return on Investment for this piece, pulled from the Content Revenue Log. Displayed as a percentage. Allows quick comparison of financial efficiency alongside the qualitative Score. |
| ƒVerdict | The action recommendation (Scale, Optimize, or Retire) from the Revenue Scorecard, pulled via VLOOKUP. This is the single most actionable column on the Dashboard — it tells you exactly what to do with each piece. |
| ƒ$/Day | Revenue per Day (revenue velocity) for this content piece, pulled from the Content Revenue Log. Shows how fast each piece earns money on a daily basis. High $/Day content is your most reliable ongoing revenue source. |
| Channel | SUMMARY TABLE — Auto-populated list of each unique Channel. Groups Dashboard data by channel for portfolio-level comparison. |
| ƒPieces | SUMMARY TABLE — Count of content pieces per Channel. Shows where your content volume is concentrated. |
| ƒRevenue | SUMMARY TABLE — Total revenue per Channel, summed from the Content Revenue Log via SUMIF. Compare channels to see which drives the most top-line income. |
| ƒSpend | SUMMARY TABLE — Total spend per Channel. Compare against revenue to evaluate each channel's cost efficiency at the portfolio level. |
| ƒProfit | SUMMARY TABLE — Total profit per Channel (Revenue minus Spend). The bottom line for each channel. Negative profit channels are draining your budget. |
| ƒROI | SUMMARY TABLE — Average or aggregate ROI per Channel. Channels with ROI above 100% are generating positive returns; below 100% are net losers. Use this to decide where to allocate future budget. |
📊 Reading the numbers
• Total Revenue (KPI) — The grand total of all revenue across every content piece. This is the headline number for your content operation. Track it monthly to measure growth.
• Net Profit (KPI) — Total Revenue minus Total Spend. This is the money you actually keep. If Net Profit is declining while Revenue grows, your costs are rising faster than income.
• Profit Margin (KPI) — Net Profit divided by Total Revenue, expressed as a percentage. Shows overall portfolio profitability. Healthy content operations typically run 50–80%+ margin. Below 30% warrants a cost review.
• Portfolio $/Day (KPI) — The total daily revenue rate across your entire portfolio. Formula: sum of all pieces' $/Day values. This tells you how much your content library earns every single day. Aim for steady growth in this metric.
• Revenue vs Spend (chart) — A side-by-side comparison of total revenue and total spend, typically by channel or by piece. Large gaps where revenue exceeds spend indicate healthy returns. Channels where spend exceeds revenue need immediate attention.
• Profit by Channel (chart) — Shows net profit broken down by channel. Use it to identify your most profitable distribution platform and reallocate budget toward it.
• Top Content by Profit (chart) — Ranks your content pieces by profit, highlighting the biggest winners. These are the pieces to study, replicate, and promote further.
• Daily Revenue Rate (chart) — Visualizes $/Day across pieces or over time. Rising rates indicate content that gains value with age (evergreen). Declining rates suggest content decay.
• Content Scores (chart) — Displays the weighted Score from the Revenue Scorecard for each piece. Use alongside the profit charts to ensure you are not just chasing revenue but also investing in high-quality content.
• ROI by Channel (chart) — Compares return on investment across distribution channels. The highest-ROI channel is where your next dollar of content spend should go, all else being equal.
⚠️ Avoid these mistakes
• Trying to type data into Dashboard cells will overwrite formulas and break the sheet. All data entry belongs in the Content Revenue Log and Revenue Scorecard only.
• Comparing Dashboard KPIs across time without updating the underlying data regularly leads to stale insights. Refresh Views, Leads, Revenue, and Spend in the Content Revenue Log at least monthly.
• Ignoring channels with negative profit on the Dashboard — these require either cost reduction or reallocation of content effort.
💡 Tips• Export the Dashboard as a PDF for monthly stakeholder reports — it is designed to be presentation-ready.
• Use the ƒVerdict column as your action list: batch all 'Retire' items for archiving, all 'Optimize' items for improvement sprints, and all 'Scale' items for additional promotion budget.
• Compare the Content Scores chart against the Top Content by Profit chart to find high-Score but low-Profit pieces — these are your best optimization opportunities.
• Bookmark the Dashboard tab in your browser for a one-click daily check on your content portfolio's financial health.
📖Glossary — what every value means
| ROI | Return on Investment. Measures how much profit you earn relative to what you spent. Calculated as (Revenue − Spend) ÷ Spend × 100, expressed as a percentage. An ROI of 150% means you earned $1.50 in profit for every $1 invested. Positive ROI means the investment is profitable; negative ROI means a loss. |
| Profit | Net earnings after subtracting all costs. Calculated as Revenue − Spend. A positive profit means the content earned more than it cost; negative profit (a loss) means costs exceeded revenue. |
| Margin | Profit Margin. The percentage of revenue retained as profit after costs. Calculated as (Profit ÷ Revenue) × 100. A margin of 80% means you keep 80 cents of every dollar earned. Higher is better; margins below 20% suggest high costs relative to revenue. |
| $/View | Revenue per View (Dollars per View). The average revenue generated by each individual view or impression. Calculated as Revenue ÷ Views. Typical values range from $0.01 to $0.10 for ad-supported content, but can be much higher for content selling premium products. |
| $/Lead | Revenue per Lead (Dollars per Lead). The average revenue attributable to each lead or conversion generated by the content. Calculated as Revenue ÷ Leads. Higher values indicate that each conversion is worth more to the business. |
| $/Day | Revenue per Day (Dollars per Day), also called Revenue Velocity. The average daily revenue a content piece generates since publication. Calculated as Revenue ÷ Age (in days). A high $/Day means the content earns steadily over time. Useful for comparing pieces of different ages. |
| $/Pt | Revenue per Score Point (Dollars per Point). Measures how much revenue each point of the weighted Score translates into. Calculated as Revenue ÷ Score. Helps identify whether high-scoring content is also effectively monetized. |
| Conv% | Conversion Rate, expressed as a percentage. The share of viewers who took a desired action (became a lead). Calculated as (Leads ÷ Views) × 100. Typical content conversion rates are 1–5%, though email and landing pages can reach 10%+. |
| ROAS | Return on Ad Spend. Measures the revenue generated for every dollar spent, expressed as a ratio. Calculated as Revenue ÷ Spend. A ROAS of 4.0 means $4 earned per $1 spent. Unlike ROI, ROAS does not subtract the cost first. Values above 3.0 are generally considered strong. |
| Payback | Payback Period. The estimated number of days required for a content piece's cumulative revenue to cover its production and promotion cost. Calculated as Spend ÷ (Revenue ÷ Age). A shorter payback is better — under 30 days is excellent. An infinite or very large payback means the piece has not earned back its cost. |
| Rev% | Revenue Share. The percentage of total portfolio revenue contributed by a single content piece. Calculated as (Piece Revenue ÷ Total Portfolio Revenue) × 100. Helps identify concentration risk — if one piece accounts for 40%+ of total revenue, your portfolio is overly dependent on it. |
| Top% | Top Percentile. Indicates where a piece falls in the ranked portfolio. Calculated as (Rank ÷ Total Pieces) × 100. A Top% of 5% means the piece is in the top 5% of all content. Lower percentages indicate better performance. |
| Pctile | Percentile ranking of a content piece based on its weighted Score. A percentile of 90 means the piece scores higher than 90% of all scored content. Used in the Revenue Scorecard to benchmark relative quality. |
| Rev Gap | Revenue Gap. The dollar difference between the top-earning content piece and the current piece. Calculated as Revenue of #1 piece − Revenue of this piece. Larger gaps indicate more room for improvement to reach top-performer status. |
| 90d Fcst | 90-Day Forecast. A forward-looking projection of how much revenue a content piece will generate over the next 90 days, based on its current daily revenue rate. Calculated as $/Day × 90. Useful for quarterly planning and budget allocation. |
| Score | Weighted Composite Score. A single number summarizing a content piece's overall performance across Reach, Engage, Impact, and Efficiency dimensions. Each dimension is weighted by its relative importance to revenue. Higher scores are better. This score drives the Rank, Verdict, and Percentile columns. |
| Verdict | An auto-generated action recommendation based on the composite Score. Possible values: Scale (invest more), Optimize (improve before scaling), or Retire (stop investing). Designed to turn data into clear next steps. |
| Portfolio $/Day | The total daily revenue rate of your entire content portfolio. Calculated as the sum of all individual $/Day values. Represents how much your complete content library earns every day. Track this over time to measure portfolio momentum. |
| Weighted ROI | A portfolio-level ROI metric that weights each content piece's ROI by its share of total spend, producing a more accurate measure of overall investment return than a simple average. Values above 100% indicate the portfolio is profitable. |
| Reach | A qualitative rating (1–10) of how broadly a content piece was distributed and discovered. Considers views, impressions, shares, and organic discoverability. Used as one of four dimensions in the Revenue Scorecard's weighted score. |
| Engage | A qualitative rating (1–10) of how deeply the audience interacted with the content. Considers comments, likes, time on page, and click-through rates. One of four scorecard dimensions. |
| Impact | A qualitative rating (1–10) of the business value a content piece delivered. Considers leads, sales, strategic positioning, and brand authority. One of four scorecard dimensions. |
| Efficiency | A qualitative rating (1–10) of how cost-effective a content piece was to produce and promote relative to its results. High efficiency means great results at low cost. One of four scorecard dimensions. |
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 assistant is a chat-based tool where you type plain-language questions or commands — no formulas or coding required.
2You can ask the assistant to explain any cell and its underlying formula (e.g., 'explain cell F5' or 'what does the Score in B12 mean?'). You can also give it action commands that read your sheet and make changes — for example, 'sum column C', 'fill the next row with data for my latest blog post', or 'color row 1 gold'. These commands work without breaking any existing formulas.
3The assistant can scan your entire workbook to check for issues, and you can attach a screenshot or image (such as an analytics report) for the AI to read and interpret. One-click presets tailored specifically to this Content Revenue Ranker template are available for common tasks — just click them to run a relevant analysis or action instantly without typing a prompt.
4In the Tools tab, you will find 'Analyze All My Data', which generates a comprehensive analytical report and outputs it to a new sheet. There is also an Auto-Fit feature to resize all columns for optimal readability, a Translate function to convert every label in the workbook to another language, and an Infographic builder to create a visual summary of your data.
5You can adjust the AI's communication style using the Tone selector (choose from Friendly, Professional, or Concise) and apply Smart Styling to improve the visual appearance of your sheets. Pro subscribers unlock additional capabilities including native chart generation, data forecasts, and a full multi-page report feature.
6The AI assistant comes with free trial requests to get you started. After the trial, a subscription provides a bigger monthly allowance of AI requests so you can continue using all features. Open the assistant any time you need help interpreting your data, automating repetitive actions, or preparing presentation-ready outputs.