Engagement by Format: Posts, Impressions per Post and Engagement Rate for Text, Image, Document, Video and Poll with COUNTIF and SUMIFS
Lessons in this course
- Impressions per Post: Engagements, Engagement Rate, the Average Post and the Overall Rate of a LinkedIn ProfileFree
- Engagement by Format: Posts, Impressions per Post and Engagement Rate for Text, Image, Document, Video and Poll with COUNTIF and SUMIFS Locked
- A Weighted Engagement Score: Comments Count More Than Reactions, Points per 1,000 Impressions and a Top-3 Highlight Locked
- Follower Growth: New Followers, Unfollows, Net New, the Monthly Growth Rate and a Line Chart of a Company Page Locked
- Follower Demographics Fit: Share by Job Function, the Target-Profile Share and a Fit Index for New Followers Locked
- Connection Cadence: Weekly Requests, Acceptance Rate, a Self-Set Cap with IF and a Running Total of New Connections Locked
- From Profile Views to Inbound Leads: Step Rates, Leads per 1,000 Views and the Views Needed for a Lead Target Locked
- A Social Selling Score Sheet: Four Pillars, a Total Score, Bands with IFS and the Weakest Pillar with XLOOKUP Locked
- When to Post: Average Impressions by Weekday and Time Slot with AVERAGEIFS, a Two-Criteria Check and a Column Chart Locked
- Typical Reach vs One Viral Post: Average, Median, an Outlier Flag with IF, LARGE and the Average Without Outliers Locked
- Comment Quality: Target-Profile Share of Comments, the Author's Reply Rate and Comments per 1,000 Impressions Locked
- Company Page vs Personal Profiles: Impressions per Follower, Impressions per Post and Engagement Rate by Account Type Locked
- Content Pillars: Share of Posts vs Share of Engagements, an Index per Pillar, a Do-More Rule and a Clustered Chart Locked
- Follower Forecast: SLOPE, a Trend Line with FORECAST.LINEAR, a Three-Month Outlook and the Month a Target Is Reached Locked
- Testing a Connection Note: Acceptance and Reply Rate per Variant, the Difference in Points, Relative Lift and a Sample Check Locked
- Inbound Leads by First Touch: Leads, Pipeline, Won Deals and Won Revenue with COUNTIFS and SUMIFS on Two Criteria Locked
- What Organic Costs: Hours per Activity, Cost of Time, Cost per Lead, Leads per 10 Hours and a Rank with RANK.EQ Locked
- What-If Grid: Leads per Month for Every Posting Frequency and Views-to-Lead Rate with Mixed References and a Heat Map Locked
- Before You Analyse: Duplicate Rows, Impossible Values and Missing Dates in a Post Export with IF, OR and SUMPRODUCT Locked
- Final Project: A Quarterly LinkedIn Dashboard with Impressions, Engagement Rate, Profile Views per 1,000, Leads, a Target Flag and a Combo Chart Locked