Dashboard creation for marketing KPIs in Digital Marketing - Mini Project: Build & Apply

Dashboard creation for marketing KPIs

📖 Scenario: You are a marketing analyst tasked with creating a simple dashboard to track key marketing performance indicators (KPIs) for your team. The dashboard will help visualize important metrics like website visits, conversion rates, and social media engagement.

🎯 Goal: Build a basic dashboard structure that organizes marketing KPIs clearly and allows easy updates of the data.

📋 What You'll Learn

Create a data structure to hold marketing KPIs with exact values

Add a configuration variable for a target goal for one KPI

Use a loop or comprehension to prepare KPI display data

Complete the dashboard layout with final labels and structure

💡 Why This Matters

🌍 Real World

Marketing teams use dashboards to monitor campaign performance and make data-driven decisions quickly.

💼 Career

Skills in organizing and presenting marketing KPIs are essential for roles like marketing analyst, digital marketer, and data specialist.

1

Set up the marketing KPIs data

Create a dictionary called marketing_kpis with these exact entries: 'Website Visits': 12000, 'Conversion Rate': 3.5, 'Social Media Engagement': 4500

Digital Marketing

# Create the marketing_kpis dictionary with the exact KPI values
# Your code here

Need a hint?

Use a dictionary with keys as KPI names and values as their numbers.

2

Add a target goal for Conversion Rate

Create a variable called conversion_target and set it to 4.0 to represent the target conversion rate percentage.

Digital Marketing

marketing_kpis = {
    'Website Visits': 12000,
    'Conversion Rate': 3.5,
    'Social Media Engagement': 4500
}
# Create the conversion_target variable with value 4.0
# Your code here

Need a hint?

This variable will help compare actual conversion rate to the target.

3

Prepare KPI display data with status

Create a new dictionary called kpi_status using a dictionary comprehension. For each KPI in marketing_kpis, set the value to 'On Track' if the KPI is not 'Conversion Rate' or if its value is greater than or equal to conversion_target. Otherwise, set it to 'Needs Improvement'.

Digital Marketing

marketing_kpis = {
    'Website Visits': 12000,
    'Conversion Rate': 3.5,
    'Social Media Engagement': 4500
}
conversion_target = 4.0
# Create kpi_status dictionary with status based on conversion_target
# Your code here

Need a hint?

Use a dictionary comprehension with a condition checking the KPI name and value.

4

Complete the dashboard layout structure

Create a list called dashboard_layout that contains strings combining each KPI name, its value from marketing_kpis, and its status from kpi_status in this exact format: "KPI: [KPI Name], Value: [Value], Status: [Status]" for all KPIs.

Digital Marketing

marketing_kpis = {
    'Website Visits': 12000,
    'Conversion Rate': 3.5,
    'Social Media Engagement': 4500
}
conversion_target = 4.0
kpi_status = {kpi: ('On Track' if (kpi != 'Conversion Rate' or value >= conversion_target) else 'Needs Improvement') for kpi, value in marketing_kpis.items()}
# Create dashboard_layout list with formatted KPI strings
# Your code here

Need a hint?

Use a list comprehension with f-strings to format each KPI's display line.