Post Format Mix: Average Score by Format, the Share of Top Posts with LARGE and an Index against the Overall Average
Lessons in this course
- Community Fit Scoring: Activity per 1,000 Members, a Weighted Fit Score, Rank and Priority TierFree
- Community Rules Compliance: a Rule Matrix, Rule Breaks per Planned Post, Verdicts and Promotional Load Locked
- Upvote Ratio: Estimating Total Votes, Upvotes and Downvotes from Score, Flagging Contested Posts and a Vote-Weighted Ratio Locked
- Comment Performance: Comments, Average Score, Helpful Share and Help-Thread Averages per Team Account Locked
- Best Time to Post: Posts and Average Score by Weekday, an Enough-Data Check and Time Slots with AVERAGEIFS Locked
- Post Format Mix: Average Score by Format, the Share of Top Posts with LARGE and an Index against the Overall Average Locked
- Title Length and Score: CORREL, SLOPE, R-squared and a Cautious FORECAST.LINEAR Prediction Locked
- Participation Balance: Weekly Promo Share, a Cap Check, Extra Helpful Items Needed and the Cumulative Share Locked
- Referral Traffic Quality: Engaged Rate, Conversion Rate, Revenue per Session and a Strong-Mixed-Weak Tier per Community Locked
- Tracking Hygiene: Cleaning UTM Source Tags, Mapping Channel Groups, Completeness Checks and the Share of Untrusted Traffic Locked
- Traffic Decay After a Post: Cumulative Share by Day, Daily Retention, Compound Decay and the Expected Tail Locked
- Community Effort ROI: Labour Cost, Gross Profit, Net Result, ROI and Where the Time Did Not Pay Locked
- AMA Planning: Forecasting Questions, Host Capacity, Hosts Needed and a Run-of-Show Timeline Locked
- AMA Results: Hourly Answer Rate, Open Questions, the Peak Hour and Sessions per Answer Locked
- Removals and Moderator Relations: Submissions, Removal Rate per Community and a Pause Rule Locked
- Weekly Participation Plan: Hours in Proportion to Fit, Caps per Community, Expected Comments and Hours Above the Caps Locked
- Is the Difference Real? Comparing Two Title Styles with the Standard Error, the t Statistic and T.TEST Locked
- Comment Sentiment and Themes: Mentions, Negative Counts, Net Sentiment and the Theme to Fix First Locked
- Integrity Check: First-Hour Share, z-Scores of Early Votes, a Review Flag and the Zero-Tolerance Count Locked
- Final Project: a Quarterly Community Marketing Dashboard with Conversion, Revenue per Hour, Rank, a Combo Chart and Conditional Formatting Locked