Social media analytics and KPIs in Digital Marketing - Mini Project: Build & Apply

Social Media Analytics and KPIs

📖 Scenario: You are managing a small business's social media accounts. You want to understand how well your posts are doing by tracking key performance indicators (KPIs) such as likes, shares, comments, and follower growth.

🎯 Goal: Build a simple data structure to hold social media metrics, set a target for follower growth, calculate total engagement, and finalize the report setup.

📋 What You'll Learn

Create a dictionary with exact social media metrics for posts

Add a target follower growth variable

Calculate total engagement by summing likes, shares, and comments

Add a final summary statement variable

💡 Why This Matters

🌍 Real World

Social media managers track KPIs to understand audience interaction and growth, helping improve marketing strategies.

💼 Career

Knowledge of social media analytics is essential for roles in digital marketing, content creation, and brand management.

1

DATA SETUP: Create social media metrics dictionary

Create a dictionary called post_metrics with these exact entries: 'likes': 120, 'shares': 30, 'comments': 15, and 'followers': 1500.

Digital Marketing

# Create the post_metrics dictionary with given values
# Your code here

Hint

Use curly braces to create a dictionary with keys and values exactly as given.

2

CONFIGURATION: Set target follower growth

Create a variable called target_growth and set it to 100 to represent the desired increase in followers.

Digital Marketing

post_metrics = {'likes': 120, 'shares': 30, 'comments': 15, 'followers': 1500}
# Set the target_growth variable to 100
# Your code here

Hint

Assign the number 100 to the variable named target_growth.

3

CORE LOGIC: Calculate total engagement

Create a variable called total_engagement and set it to the sum of post_metrics['likes'], post_metrics['shares'], and post_metrics['comments'].

Digital Marketing

post_metrics = {'likes': 120, 'shares': 30, 'comments': 15, 'followers': 1500}
target_growth = 100
# Calculate total_engagement by adding likes, shares, and comments
# Your code here

Hint

Add the values for likes, shares, and comments from the dictionary and assign the result to total_engagement.

4

COMPLETION: Add final summary statement

Create a variable called summary and set it to the string 'Engagement and follower growth report ready.' to complete the report setup.

Digital Marketing

post_metrics = {'likes': 120, 'shares': 30, 'comments': 15, 'followers': 1500}
target_growth = 100
total_engagement = post_metrics['likes'] + post_metrics['shares'] + post_metrics['comments']
# Add the summary string variable
# Your code here

Hint

Assign the exact string to the variable named summary.

Practice

1. What does engagement rate measure in social media analytics?

easy

A. The total number of followers

B. The number of posts published

C. The amount of money spent on ads

D. How much users interact with your content

Solution

1. Step 1: Understand engagement rate meaning

   Engagement rate shows how actively users interact with your posts, like likes, comments, and shares.

2. Step 2: Compare options to definition

   Only How much users interact with your content describes interaction, while others describe followers, spending, or posting frequency.

3. Final Answer:

   How much users interact with your content -> Option D

4. Quick Check:

   Engagement rate = user interaction [OK]

Hint: Engagement means user actions on posts [OK]

Common Mistakes:

• Confusing engagement rate with follower count
• Thinking engagement is about ad spend
• Mixing engagement with number of posts

2. Which of the following is the correct formula to calculate Click-Through Rate (CTR)?

easy

A. (Number of followers ÷ Number of clicks) x 100

B. (Number of impressions ÷ Number of clicks) x 100

C. (Number of clicks ÷ Number of impressions) x 100

D. (Number of likes ÷ Number of shares) x 100

Solution

1. Step 1: Recall CTR formula

   CTR is the percentage of people who clicked after seeing the content, so clicks divided by impressions times 100.

2. Step 2: Match formula to options

   (Number of clicks ÷ Number of impressions) x 100 matches the correct formula. Others invert or use unrelated metrics.

3. Final Answer:

   (Number of clicks ÷ Number of impressions) x 100 -> Option C

4. Quick Check:

   CTR = clicks/impressions x 100 [OK]

Hint: CTR = clicks divided by impressions times 100 [OK]

Common Mistakes:

• Swapping clicks and impressions in formula
• Using followers or likes instead of clicks
• Confusing CTR with engagement rate

3. Given the data: 500 impressions, 25 clicks, and 10 shares, what is the Click-Through Rate (CTR) percentage?

medium

A. 2%

B. 5%

C. 10%

D. 20%

Solution

1. Step 1: Apply CTR formula

   CTR = (Clicks ÷ Impressions) x 100 = (25 ÷ 500) x 100

2. Step 2: Calculate the value

   (25 ÷ 500) = 0.05; 0.05 x 100 = 5%

3. Final Answer:

   5% -> Option B

4. Quick Check:

   CTR = 5% [OK]

Hint: Divide clicks by impressions, multiply by 100 [OK]

Common Mistakes:

• Using shares instead of clicks in calculation
• Multiplying before dividing
• Confusing CTR with engagement rate

4. A social media report shows a bounce rate of 90%, but the analyst suspects an error. Which mistake could cause this?

medium

A. Calculating bounce rate using clicks instead of visits

B. Mixing up bounce rate with engagement rate

C. Using total followers instead of website visitors

D. Counting users who left immediately as engaged users

Solution

1. Step 1: Understand bounce rate meaning

   Bounce rate measures the percentage of visitors who leave without interacting further on the site.

2. Step 2: Identify calculation error

   Using clicks instead of visits to calculate bounce rate inflates the number, causing wrong high bounce rate.

3. Final Answer:

   Calculating bounce rate using clicks instead of visits -> Option A

4. Quick Check:

   Bounce rate needs visits, not clicks [OK]

Hint: Bounce rate = exits ÷ visits, not clicks [OK]

Common Mistakes:

• Confusing bounce rate with engagement rate
• Using follower count in bounce rate
• Counting immediate leaves as engagement

5. You want to improve your social media campaign's conversion rate. Which combined action best supports this goal?

hard

A. Enhance content quality and add clear call-to-actions

B. Increase ad impressions and reduce post frequency

C. Boost follower count without changing content

D. Focus only on increasing likes and shares

Solution

1. Step 1: Understand conversion rate goal

   Conversion rate measures how many users complete a desired action, like buying or signing up.

2. Step 2: Identify actions that improve conversions

   Improving content quality and adding clear call-to-actions guide users to convert better than just increasing impressions or likes.

3. Final Answer:

   Enhance content quality and add clear call-to-actions -> Option A

4. Quick Check:

   Better content + clear CTAs = higher conversions [OK]

Hint: Good content + clear CTA = better conversions [OK]

Common Mistakes:

• Focusing only on impressions or followers
• Ignoring call-to-action importance
• Assuming likes equal conversions