Chapter 23 Exercises: Platform Analytics Deep Dive

Exercise 23.1: YouTube Studio Full Walkthrough

Objective: Develop hands-on familiarity with every major section of YouTube Studio analytics.

Requirements: A YouTube channel with at least 5 published videos and some analytics data.

Part A: Audience Retention Analysis (30 minutes)

For your three most recent videos, navigate to each video's individual analytics (YouTube Studio → Content → click a video → Analytics tab).

Open the "Engagement" section and find the audience retention graph. For each video:

1. Screenshot or sketch the retention curve shape
2. Identify the single largest drop-off point (outside the initial 30-second period)
3. Note the exact timestamp where that drop-off occurred
4. Write one sentence describing what you were doing in the video at that moment
5. Write one hypothesis for why viewers left at that point

Part B: Traffic Source Audit (20 minutes)

In the Reach section, find the Traffic Source report for your last 28 days.

1. Record the percentage of views from: YouTube Search, Browse Features, Suggested Videos, External Sources, End Screens, Other
2. Calculate what percentage of your traffic is "algorithm-dependent" (Browse + Suggested) vs. "intent-driven" (YouTube Search + External)
3. If your algorithm-dependent percentage is above 70%: write a 100-word plan for how you would increase your YouTube Search and External traffic over the next three months
4. If your intent-driven percentage is already above 30%: write a 100-word plan for how you would maintain and improve this distribution

Part C: Impressions Funnel (15 minutes)

Find your impressions click-through rate for the last 28 days: 1. What is your current impressions CTR? 2. How does this compare to the 4–6% healthy range? 3. Pick your worst-performing video by CTR. What does the thumbnail look like? What is the title? What would you change about each? 4. Pick your best-performing video by CTR. What elements does it have that your worst-performing thumbnail lacks?

Exercise 23.2: TikTok Analytics Content Strategy Workshop

Objective: Use TikTok analytics to identify content patterns and build a data-driven posting strategy.

Requirements: TikTok Business or Creator account with at least 15 published videos.

Step 1: Complete Content Performance Audit

Create a spreadsheet with these columns for your last 20 videos: - Video title/description (first 50 characters) - Post date - Total plays - Unique viewers - Average watch time (seconds) - Percentage of video watched - Saves - Shares - Comments - Traffic source (% For You vs. % Following) - Video length (seconds)

Step 2: Pattern Analysis

With your completed table, calculate or observe:

1. What is your average completion rate (% of video watched)? How does this compare to the 60–65% high-performer benchmark?
2. What is the correlation between video length and completion rate? Do shorter videos complete at higher percentages?
3. Which three videos have the highest save rates (saves ÷ unique viewers)? What do these videos have in common?
4. Which three videos have the highest For You distribution (as % of total plays)? What did these videos do that triggered algorithm distribution?
5. What day/time patterns do you see in your top-performing content?

Step 3: Content Calendar Revision

Based on your analysis, draft a two-week content calendar that: - Uses your peak-engagement time slots (from the Followers Activity tab) - Balances your highest-engagement content types (from your pattern analysis) - Includes at least two videos specifically designed to improve your average completion rate

Write a 150-word explanation of the strategic choices you made in this calendar and which metrics you're targeting to improve.

Exercise 23.3: Instagram Insights Story Analytics Lab

Objective: Learn to use Instagram Story analytics as UX research for your content.

Requirements: Instagram Business or Creator account with at least 10 story posts in the last 14 days.

The UX Analysis:

For each of your last 5 story sequences (a multi-frame story posted as a series), gather the analytics for each frame: - Frame number in sequence - Views - Forward taps - Back taps - Exits - Any interactions (replies, link taps, sticker interactions)

For each sequence, calculate: - Exit rate for each frame = Exits ÷ Views - Back tap rate for each frame = Back taps ÷ Views - Forward tap rate = Forward taps ÷ Views

Analysis questions:

1. Which frames in your stories have the highest exit rates? What were you doing at those moments?
2. Which frames have the highest back tap rates? Why do you think people wanted to see those frames again?
3. Is there a pattern in which frame position tends to have the highest exits? (First frame? Middle? Just after your CTA?)
4. If you were a user experience designer and this was app usage data, not story analytics — what would you conclude about where your story sequences need improvement?

Deliverable: Write a 200-word "story UX report" analyzing your findings and identifying three specific changes you would make to your story format based on the data.

Exercise 23.4: Email Analytics Deep Dive and List Health Assessment

Objective: Conduct a comprehensive audit of your email list health using your ESP analytics.

Requirements: An email list with at least 100 subscribers and 5+ sent campaigns.

Part A: Campaign Performance Analysis

Pull analytics for your last 10 sent emails and create a table with: - Email subject line - Send date - Total delivered - Open rate (%) - Click rate (%) - Click-to-open rate (%) - Unsubscribe rate (%) - Top-clicked link

Identify: 1. Your top 3 performing emails by CTOR (not open rate) 2. Your bottom 3 performing emails by CTOR 3. The specific elements that differentiate your top vs. bottom performers (subject line, content type, CTA placement, email length)

Part B: List Health Assessment

1. What percentage of your list has opened at least one email in the last 90 days? (This is your "active" percentage.)
2. What percentage has never opened any email?
3. What is your average monthly unsubscribe rate over the last 6 months?
4. Are you currently above or below the 0.5% per-email unsubscribe threshold?

Part C: Welcome Sequence Audit

If you have a welcome sequence (automated series for new subscribers): 1. Record open rate and CTR for each email in the sequence 2. Where does the most significant open rate drop occur between consecutive emails? 3. What does this drop tell you about the content of the preceding email?

If you don't have a welcome sequence: write a three-email welcome sequence outline (subject line + 3-sentence content description for each email) based on what you know about your audience and what you want them to understand about your brand within their first week.

Exercise 23.5: Building Your Unified Cross-Platform Dashboard

Objective: Create a working, real-data cross-platform analytics dashboard you will actually use.

Instructions:

Build a tracking document in Google Sheets, Notion, or your preferred tool with the following structure:

Sheet 1: Weekly Summary

Columns: Date | Week # | Platform | Metric | Value | vs. Last Week (+ or -)

Add rows for these metrics from every platform you're active on: - YouTube: Weekly views, subscriber count change, top video's CTR - TikTok: Weekly video views, follower change, average completion rate - Instagram: Weekly accounts reached, saves per post (average) - Podcast: Weekly downloads, completion rate (Spotify) - Email: Open rate, click rate, new subscribers, unsubscribes, net growth - Revenue: Total earnings this week (all sources)

Sheet 2: Content Performance Log

For every piece of content you publish: - Platform | Date | Title | Reach | Engagement rate | Saves/Completion rate | Email sign-ups driven (if tracked) | Revenue driven (if tracked)

Sheet 3: Monthly Synthesis

A single page you fill in at month-end: - Month-over-month change for 10 key metrics - Top insight from the month (one sentence) - The one thing you're changing next month based on data

Commitment: Run this dashboard for four consecutive weeks. After week four, write a 150-word reflection: what patterns did you discover that you wouldn't have known without tracking?

Exercise 23.6: Platform Analytics Comparison Report

Objective: Critically evaluate the analytics tools across the platforms you use.

Instructions:

For each platform you're active on, complete an "analytics audit card":

Written reflection (300 words):

Based on your ratings: 1. Which platform gives you the best analytics for your current business stage and goals? 2. Which platform analytics are you most underutilizing — i.e., where do you have access to better data than you're currently using? 3. If you could redesign one platform's analytics interface to better serve creator businesses, which would you choose and what specific changes would you make? 4. How does the analytics quality of each platform affect your strategic choices about where to invest your content energy?