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