Tabellab

Commentary Rules: Materiality, Explain-the-Miss Logic, Sentences Built with TEXT and a Count of KPIs That Need Words

Lesson 17 of 20 Lab 🔒 Locked

Lessons in this course

  1. The KPI Tree Behind a Monthly Social Report: Posts, Impressions per Post, CTR and Engagement Rate per PlatformLabFree
  2. Month-on-Month Change: Absolute Change, Percentage Change, a Flat Band and Direction LabelsLab Locked
  3. Year-on-Year and Seasonality: Comparing with the Same Month Last Year, the 12-Month Total and a Two-Year Line ChartLab Locked
  4. Fair Months: Days in the Month with EOMONTH, Impressions per Day, Per-Day Change and Impressions per PostLab Locked
  5. Benchmarks: Looking Up a Platform Benchmark with XLOOKUP, the Benchmark Index, Verdict Bands and a Highlight RuleLab Locked
  6. The Account's Own Baseline: Rolling 3-Month Rate, 12-Month Mean, Standard Deviation and the z-Score of the Report MonthLab Locked
  7. Cross-Platform Roll-Up: Total Impressions, a Blended Engagement Rate, Platform Share and a Stacked Column ChartLab Locked
  8. Goal Pacing Within the Month: Expected to Date, Pace, Projected Month End and a Three-Level StatusLab Locked
  9. Quarterly Goals: Cumulative Actual against a Linear Plan, the Required Weekly Run Rate and the Projected Quarter EndLab Locked
  10. One Language for Four Exports: A Metric Dictionary with XLOOKUP and a Standardised Roll-Up with SUMIFSLab Locked
  11. Engagement Rate by Followers or by Reach: Two Denominators, a Ranking with RANK.EQ, the Best Account and a Bar ChartLab Locked
  12. Top Posts and Content Pillars: LARGE for the Top Three, INDEX-MATCH for the Post, Pillar Counts, Pillar Rates and a Bar ChartLab Locked
  13. Follower Growth: Net Adds, Monthly Growth Rate, Unfollow Rate, Twelve-Month Growth and a Column ChartLab Locked
  14. Trend and Forecast: SLOPE, R Squared, FORECAST.LINEAR for the Next Three Months and the Gap to a GoalLab Locked
  15. Organic and Paid in One Report: Paid Share of Impressions, Blended and Organic Engagement Rate, Cost per Paid Engagement and a Highlight RuleLab Locked
  16. Noise or Real Change: The Two-Proportion z-Test for an Engagement Rate, p-Values and a Verdict ColumnLab Locked
  17. Commentary Rules: Materiality, Explain-the-Miss Logic, Sentences Built with TEXT and a Count of KPIs That Need WordsLab Locked
  18. What-If Grid for a Goal: Mixed References, a Heat Map, Required Cadence, Required Engagements per Post and Scenario CountsLab Locked
  19. Quality Checks Before Sending: Reconciling Report Figures with Platform Exports, a Tolerance, Check Flags and a Row HighlightLab Locked
  20. Final Project: A One-Page Monthly Client Report with Month-on-Month, Year-on-Year, Blended Engagement Rate, Goal Status and a ChartLab Locked