Tabellab

What-If Grid: Leads per Month for Every Posting Frequency and Views-to-Lead Rate with Mixed References and a Heat Map

Lesson 18 of 20 Lab 🔒 Locked

Lessons in this course

  1. Impressions per Post: Engagements, Engagement Rate, the Average Post and the Overall Rate of a LinkedIn ProfileLabFree
  2. Engagement by Format: Posts, Impressions per Post and Engagement Rate for Text, Image, Document, Video and Poll with COUNTIF and SUMIFSLab Locked
  3. A Weighted Engagement Score: Comments Count More Than Reactions, Points per 1,000 Impressions and a Top-3 HighlightLab Locked
  4. Follower Growth: New Followers, Unfollows, Net New, the Monthly Growth Rate and a Line Chart of a Company PageLab Locked
  5. Follower Demographics Fit: Share by Job Function, the Target-Profile Share and a Fit Index for New FollowersLab Locked
  6. Connection Cadence: Weekly Requests, Acceptance Rate, a Self-Set Cap with IF and a Running Total of New ConnectionsLab Locked
  7. From Profile Views to Inbound Leads: Step Rates, Leads per 1,000 Views and the Views Needed for a Lead TargetLab Locked
  8. A Social Selling Score Sheet: Four Pillars, a Total Score, Bands with IFS and the Weakest Pillar with XLOOKUPLab Locked
  9. When to Post: Average Impressions by Weekday and Time Slot with AVERAGEIFS, a Two-Criteria Check and a Column ChartLab Locked
  10. Typical Reach vs One Viral Post: Average, Median, an Outlier Flag with IF, LARGE and the Average Without OutliersLab Locked
  11. Comment Quality: Target-Profile Share of Comments, the Author's Reply Rate and Comments per 1,000 ImpressionsLab Locked
  12. Company Page vs Personal Profiles: Impressions per Follower, Impressions per Post and Engagement Rate by Account TypeLab Locked
  13. Content Pillars: Share of Posts vs Share of Engagements, an Index per Pillar, a Do-More Rule and a Clustered ChartLab Locked
  14. Follower Forecast: SLOPE, a Trend Line with FORECAST.LINEAR, a Three-Month Outlook and the Month a Target Is ReachedLab Locked
  15. Testing a Connection Note: Acceptance and Reply Rate per Variant, the Difference in Points, Relative Lift and a Sample CheckLab Locked
  16. Inbound Leads by First Touch: Leads, Pipeline, Won Deals and Won Revenue with COUNTIFS and SUMIFS on Two CriteriaLab Locked
  17. What Organic Costs: Hours per Activity, Cost of Time, Cost per Lead, Leads per 10 Hours and a Rank with RANK.EQLab Locked
  18. What-If Grid: Leads per Month for Every Posting Frequency and Views-to-Lead Rate with Mixed References and a Heat MapLab Locked
  19. Before You Analyse: Duplicate Rows, Impossible Values and Missing Dates in a Post Export with IF, OR and SUMPRODUCTLab Locked
  20. Final Project: A Quarterly LinkedIn Dashboard with Impressions, Engagement Rate, Profile Views per 1,000, Leads, a Target Flag and a Combo ChartLab Locked