Tabellab

Organic LinkedIn for Personal Brands & Company Pages: Impressions per Post, Engagement by Format, Follower Fit, Connection Cadence & Inbound Leads

Measure organic LinkedIn for a personal brand and a company page step by step. You will calculate impressions per post and engagement rates, compare formats, weight comments above reactions, track follower growth and the fit of followers with a target profile, keep a connection cadence, follow profile views to inbound leads and build a social selling score sheet. Then you go deeper: posting day and time, viral outliers, comment quality, company page against personal profiles, content pillars, a follower forecast, a test of connection notes, leads by first touch, the cost of time per lead, a what-if grid, export quality checks and a final quarterly dashboard. 20 hands-on labs, fictional payroll software company Quillhaven Payroll, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course teaches the numbers behind organic LinkedIn, for a personal brand and for a company page, one spreadsheet lab at a time. You work with Quillhaven Payroll, a fictional company that sells payroll software to small manufacturers, and with the profile of its founder, and you build every calculation yourself in an Excel-like sheet that checks each cell. In the 20 labs you calculate impressions per post and engagement rates, compare text, image, document, video and poll posts, build a weighted engagement score, track follower growth and the fit of followers with a target profile, keep a steady connection cadence, follow profile views to inbound leads, fill in a social selling score sheet, find good posting days, separate viral outliers from typical reach, forecast followers, test connection notes, trace leads to their first touch, price the time behind each lead and finish with a quarterly dashboard. The focus is on durable arithmetic and judgement rather than platform settings, which change. All companies, people and numbers are fictional and all benchmarks are illustrative.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy