Social media analytics and KPIs in Digital Marketing - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to identify the key metric that measures the number of times a post is seen.

Digital Marketing

metric = "[1]"  # This metric counts how many times content is displayed

Drag options to blanks, or click blank then click option'

Aimpressions

Bengagement

Cclicks

Dfollowers

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing impressions with engagement or clicks.

Impressions count how many times a post or content is shown to users, regardless of interaction.

2fill in blank

medium

Complete the code to calculate the engagement rate as a percentage.

Digital Marketing

engagement_rate = (engagements / [1]) * 100  # Calculate engagement rate

Drag options to blanks, or click blank then click option'

Aimpressions

Bclicks

Cshares

Dfollowers

Attempts:

3 left

💡 Hint

Common Mistakes

Using impressions or clicks instead of followers in the calculation.

The engagement rate is usually calculated by dividing total engagements by the number of followers, then multiplying by 100 to get a percentage.

3fill in blank

hard

Fix the error in the KPI calculation to correctly measure click-through rate (CTR).

Digital Marketing

ctr = (clicks / [1]) * 100  # Calculate click-through rate

Drag options to blanks, or click blank then click option'

Aimpressions

Bshares

Cengagements

Dfollowers

Attempts:

3 left

💡 Hint

Common Mistakes

Using followers or engagements instead of impressions in the denominator.

Click-through rate (CTR) is calculated by dividing clicks by impressions, then multiplying by 100 to get a percentage.

4fill in blank

hard

Fill both blanks to create a dictionary comprehension that maps each post to its engagement rate if the post has more than 1000 impressions.

Digital Marketing

engagement_rates = {post: ([1] / impressions) * 100 for post, impressions, [2] in posts_data if impressions > 1000}

Drag options to blanks, or click blank then click option'

Aengagements

Bclicks

Cfollowers

Dshares

Attempts:

3 left

💡 Hint

Common Mistakes

Using followers instead of engagements for the rate.

Incorrect variable unpacking causing errors.

The engagement rate is calculated using engagements divided by impressions. The third variable in the loop should be clicks to unpack the data correctly.

5fill in blank

hard

Fill all three blanks to create a filtered dictionary of posts with a high CTR (greater than 5%).

Digital Marketing

high_ctr_posts = {post: ([1] / [2]) * 100 for post, [3] in posts_data.items() if ([1] / [2]) * 100 > 5}

Drag options to blanks, or click blank then click option'

Aclicks

Bimpressions

Cdata

Dengagements

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up clicks and impressions.

Incorrect unpacking of dictionary items.

To calculate CTR, divide clicks by impressions. The loop unpacks each post and its data dictionary. The condition filters posts with CTR above 5%.

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