Tabellab

Social media analytics courses: measure what your posts really do

Likes are not a business result, but reach, engagement, follower growth and cost per outcome are, if you measure them properly.

Social Media Analytics courses (13)

$9.90Beginner

Instagram Growth & Reels Analytics: Reach by Format, Engagement Rates, Saves & Shares, Follower Churn, Posting Times & Story Funnels

Measure what actually grows an Instagram account. You will compare the reach of reels, carousels and photos, calculate engagement rates by reach and by followers, separate saves and shares from likes, split follower growth into new follows and unfollows, test posting times and hashtag sets and follow viewers through a story funnel and from profile visit to follow. Then you go deeper: reel retention and hook rate, a pillar-by-format heat map, non-follower reach, weighted post rankings, a follower forecast, median versus mean for viral outliers, a posting-mix what-if, data quality checks, monthly reporting with dates, a compounding growth grid and the link from tagged content to shop orders, finishing with a monthly scorecard. 20 hands-on labs, fictional plant studio data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Influencer Marketing ROI: Creator Selection, CPM, Promo Codes & Incrementality

Measure creator campaigns from the brand side in Excel: shortlist creators by engagement quality and audience fit, compare CPM, CPE and unique reach, price flat vs per-view vs hybrid fees, forecast views, track promo codes, UTM links and attribution windows, calculate ROAS, ROI, CAC and subscription LTV, prove incrementality with holdouts and difference-in-differences, test sensitivity and build a campaign dashboard, in 20 graded labs.

20 lessons · 20 labs

$9.90Intermediate

LinkedIn Ads for B2B Lead Generation: Audience Sizing, CPM & CPL, Lead Gen Forms vs Landing Pages, Lead Quality, Pipeline & Account Lists

Plan and judge LinkedIn campaigns for B2B in Excel. You will size audiences from job titles, company size and industry, calculate CPM, CTR, CPC and cost per lead, compare Lead Gen Forms with landing pages, follow leads to MQL, SQL and pipeline, check account lists and match rates, forecast leads from a budget, break results down by seniority, test leads against the target profile, measure creative fatigue, test forms for significance, find the marginal cost of scaling, time the sales cycle, report account penetration, allocate a budget with caps, build a what-if grid, score leads, pace a monthly budget and finish with a programme dashboard: 20 hands-on labs, fictional B2B software company, every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

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

$9.90Intermediate

Creator Economy Math: YouTube, Streaming & Sponsorships

Turn views into ad revenue with CPM and RPM, forecast channel growth, price sponsorships, add up affiliate, merch, membership and streaming income, split royalties, build a creator P&L and measure revenue concentration, then read retention curves, judge thumbnails by watch time, plan seasonal CPMs, compare shorts with long videos, report sponsor delivery, weight a deal pipeline, convert foreign payouts, run cash flow, price an editor hire, build a sensitivity grid, analyse member cohorts and finish with a dashboard, in 20 hands-on labs with every cell checked. Illustrative rates; not affiliated with any platform.

20 lessons · 20 labs

$9.90Intermediate

TikTok Ads & Short-Video Advertising: Hook Rate, Hold Rate, CPV, CPA, Creative Rotation, Bidding & Attribution Windows

The arithmetic behind TikTok ads and boosted creator posts, one spreadsheet at a time. You measure hook rate and hold rate, read quartile views and completion, price attention with CPM, CPV and cost per 6-second view, follow the funnel from view to purchase and set break-even and target CPAs. After that you score creatives against format benchmarks, catch creative fatigue with a trend line, cost boosted creator posts all-in, check bid strategies and delivery, size budgets for the learning phase, pace a monthly budget, compare attribution windows, correct recent days for conversion lag, judge split tests with a z-score, run a test lane with kill rules, plan creative rotation with dates, summarise audiences with SUMIFS, link frequency to CTR, build a CPA what-if grid and finish with an account dashboard: 20 hands-on labs, fictional tea brand Tindlewick Tea Co., every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

YouTube Channel Growth Analytics: Thumbnail CTR, View Duration & Retention, Traffic Sources, Upload Cadence, Subscriber Conversion & Series Planning

Understand what makes a YouTube channel grow by working through its numbers. You will calculate thumbnail CTR and the weighted channel CTR, turn watch hours into average view duration, rebuild a retention curve, chain impressions into watch time, split views by traffic source and group search terms into topics. You then measure subscriber conversion per 1,000 views and upload cadence, judge thumbnail tests with a written rule, compare video lengths, benchmark the first 48 hours, follow new and returning viewers, plan series by views per episode and carry-over, value end screens, forecast subscribers, compare upload days, build a what-if grid of CTR against view duration, run a video health check and finish with a quarterly channel scorecard. 20 hands-on labs, fictional gardening channel Pebblewick Garden, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Social Media Management & Client Reporting: KPI Trees, Month-on-Month & Year-on-Year, Benchmarks, Cross-Platform Roll-Ups, Goal Pacing & Insight Commentary

Build the monthly client report of a social media manager. You structure a report with a KPI tree, calculate month-on-month changes with a flat band, compare seasonal months year on year, normalise months to per-day and per-post averages, index accounts against illustrative platform benchmarks and against their own history, roll four platforms up into a blended engagement rate, harmonise metric names with a dictionary, pace monthly and quarterly goals, choose the right engagement-rate denominator, rank top posts and content pillars, separate organic from paid, forecast a trend, test whether a change is noise, write rule-based commentary, build a what-if grid, reconcile the draft with the exports and finish with a one-page client report. 20 hands-on labs, fictional agency Fernhollow Social and its clients, every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

TikTok Organic Content Analytics: Watch-Through Rate, Average Watch Time, For You vs Follower Views, Posting Cadence, Sound Tests & Profile-to-Link Clicks

Read organic short-video numbers the way an analyst does. You will calculate average watch time and watch-through rate, draw a retention curve and find the hook rate, split views into For You and follower traffic, measure engagement on views, log posting cadence and compare time slots, test trending sounds against original audio and follow the path from video views to profile visits and link clicks. Then you diagnose hooks and holds, compare video lengths, track net follower growth, separate typical videos from viral outliers, time the lifetime of a post, rank content pillars, read a posting-frequency test, forecast followers, audit an export, judge paired video tests, build a what-if grid for link clicks and finish with a monthly scorecard and chart. 20 hands-on labs, fictional stationery brand Quillfeather Paper Co., every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

Social Media Contests & Giveaways: Entry Rates, Cost per Entry & New Follower, Follower Retention, Prize Budgets & Fair Winner Draws

Run social media giveaways that earn their prize budget. You will turn reach and entries into entry rates, compare entry mechanics, price every entry and every new follower, separate attributable growth from normal growth, measure 30- and 90-day follower retention, plan the prize budget against a cap, draw winners fairly with RAND and weighted tickets, clean repeat and low-quality entries, score the official rules with a checklist, compare traffic sources and partner shares, read and forecast the daily entry curve, track engagement before and after, follow entrants into sales and ROI, value a retained follower, build a what-if grid and finish with a giveaway scorecard, in 20 hands-on labs, fictional outdoor-gear data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

YouTube & Video Ads: View Rate, CPV, Cost per Completed View, Reach & Frequency, Video Sequencing & Brand Lift

Measure video advertising the way an analyst does. You will calculate view rate and cost per view for skippable in-stream ads, read quartile reports, price a completed view, work out reach, average frequency and the cost per 1,000 people reached, plan budgets from a view target and translate CPV into CPM. Then you go deeper: watch time and earned actions, audiences and devices with SUMIFS, the first five seconds and benchmarks by length, five ad formats on one scale, frequency distributions and caps, reach curves with marginal cost, video sequences step by step, brand-lift surveys with absolute and relative lift, a significance test, confidence intervals and survey sizes, creative wear-out, a placement audit, a what-if grid and a budget ranked by cost per lifted user, finishing with a quarterly dashboard. 20 hands-on labs, fictional e-bike brand Tarnwick Cycles, every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

Meta Ads (Facebook & Instagram): Campaign Structure, Audiences & Overlap, the CPM-CTR-CVR Chain, Frequency, Learning Phase, Budgets & Reporting

Learn to read and steer Facebook and Instagram ads with a spreadsheet. You will roll ads up to ad sets and campaigns, split the cost per purchase into CPM, link CTR and conversion rate, diagnose weak ad sets against the account, measure reach, frequency and creative fatigue, check audience overlap, see what the learning phase demands of a budget and compare a campaign budget (CBO) with ad set budgets. Then you go deeper: placement breakdowns, hook and hold rates of video ads, attribution windows, break-even ROAS, the marginal cost of scaling, a seasonal CPM forecast, split-test significance, export quality checks, funnel stages, budget pacing and a scenario grid, and you finish with a monthly report by funnel stage. 20 hands-on labs, fictional candle shop Saltmarsh Candle Co., every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

Social Media Content Calendar Planning: Content Pillars, Weekly Cadence, Production Capacity, Approval Lead Times, Batching, Repurposing & Campaign Overlays

Plan a social media calendar that the team can actually deliver, in 20 hands-on labs. You will check the content pillar mix against a target, set a weekly cadence per platform, measure production hours per post and the real capacity of each person, work with publish dates, weekdays and ISO weeks, count approval lead times backwards in working days, quantify what batching and repurposing save, lay campaign overlays on the always-on plan and compare weekly load with capacity. Then you track the pipeline by status, size the content buffer in runway days, rebalance pillars from results per hour, read your own weekday and time-slot data, forecast hours for a bigger plan, cost the calendar in-house against freelance quotes, build a what-if grid, run quality checks and review on-time delivery, and finish with a quarterly dashboard. 20 hands-on labs, fictional yarn shop Thistledown Yarn Co., every cell checked as you go.

20 lessons · 20 labs

Likes are not a business result, but reach, engagement, follower growth and cost per outcome are, if you measure them properly. These courses cover the main platforms one by one, with the metrics that matter on each, and then show how to bring them together in content calendars, client reports and creator or influencer deals. Each lab uses a realistic data set so you practise the calculations that social media managers, freelancers and small-business owners actually need.

This topic hub gathers 13 Social Media Analytics courses from Marketing: 7 beginner, 6 intermediate. Most courses have about 20 hands-on labs, a final exam and a certificate, and the first lesson of every course is free. Searches this hub is built for: social media analytics excel; engagement rate formula; instagram reels analytics; youtube channel growth analytics.

Frequently asked questions

Which Social Media Analytics course should I start with?

Start with “Instagram Growth & Reels Analytics”. It is a beginner-level course, so no prior knowledge is assumed. Then move on to the more specialised courses in the list above.

How much do the Social Media Analytics courses cost?

Every course costs a one-time $9.90, with no subscription, and the first lesson of each course is free so you can try it before buying. Each course ends with a final exam and a certificate.

How are the Social Media Analytics courses taught?

Each course is a series of hands-on labs in a built-in spreadsheet that checks your formulas as you type, with short explanations alongside. You need only a web browser; nothing to install. Examples use fictional data and are for learning, not professional advice.

Open your first lab in under a minute

Pick a course, pay once and start right away. Your progress is saved in your account.

Browse the courses