Dashboard creation for marketing KPIs in Digital Marketing - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a KPI in marketing dashboards?

A KPI (Key Performance Indicator) is a measurable value that shows how effectively marketing goals are being achieved. Examples include website traffic, conversion rate, and cost per lead.

beginner

Why should marketing dashboards use simple and clear visualizations?

Simple and clear visualizations help users quickly understand performance without confusion. They make it easier to spot trends and make decisions fast.

beginner

Name three common marketing KPIs to include in a dashboard.

Common marketing KPIs are: 1) Conversion Rate, 2) Customer Acquisition Cost (CAC), 3) Return on Ad Spend (ROAS).

intermediate

What is the benefit of using filters in a marketing KPI dashboard?

Filters let users focus on specific data like time periods, campaigns, or regions. This helps analyze performance in detail and make targeted decisions.

intermediate

How can color be used effectively in marketing dashboards?

Colors can highlight important data, show positive or negative trends, and group related information. Use consistent colors and ensure good contrast for readability.

Which of these is NOT typically a marketing KPI?

A Employee Satisfaction

B Bounce Rate

C Click-through Rate

D Cost per Lead

Employee Satisfaction is an HR metric, not a marketing KPI.

What is the main purpose of a marketing KPI dashboard?

A To display raw data tables

B To manage employee schedules

C To create marketing content

D To track and visualize marketing performance

Marketing KPI dashboards help track and visualize key marketing metrics for better decisions.

Which visualization is best to show trends over time in a marketing dashboard?

A Scatter Plot

B Pie Chart

C Line Chart

D Table

Line charts clearly show changes and trends over time.

Why should dashboards avoid clutter?

A To help users focus on key information

B To confuse users

C To make the dashboard load slower

D To add more colors

Less clutter helps users focus on the most important data quickly.

What does a filter in a dashboard allow you to do?

A Change the dashboard theme

B Select specific data to view

C Export data to Excel

D Add new KPIs automatically

Filters let users select and view specific slices of data.

Describe the key steps to create an effective marketing KPI dashboard.

Think about what marketers need to see and how to show it clearly.

Explain why it is important to select the right KPIs for a marketing dashboard.

Consider how KPIs guide decisions and focus attention.

Practice

1. What is the main purpose of a marketing KPI dashboard?

easy

A. To create complex formulas for data analysis only

B. To store raw marketing data without visualization

C. To display key marketing numbers clearly in one place

D. To replace all marketing reports with text summaries

Solution

1. Step 1: Understand the role of a dashboard

   A dashboard is designed to show important information clearly and quickly.

2. Step 2: Identify the main function in marketing context

   Marketing KPI dashboards focus on showing key numbers in one place for easy review.

3. Final Answer:

   To display key marketing numbers clearly in one place -> Option C

4. Quick Check:

   Dashboard = Clear key numbers [OK]

Hint: Dashboards summarize key info visually [OK]

Common Mistakes:

• Confusing dashboards with raw data storage
• Thinking dashboards only store data without visuals
• Assuming dashboards replace all reports with text

2. Which of the following is the correct way to add a filter for 'Date' in a marketing dashboard tool?

easy

A. Create a text box with date values

B. Write a SQL query to delete dates from the data

C. Use a pie chart to show dates

D. Add a slicer visual and connect it to the Date field

Solution

1. Step 1: Identify how filters work in dashboards

   Filters let users select data subsets, often using slicers connected to fields.

2. Step 2: Choose the correct method for date filtering

   Adding a slicer visual connected to the Date field allows interactive filtering by date.

3. Final Answer:

   Add a slicer visual and connect it to the Date field -> Option D

4. Quick Check:

   Filter by slicer on Date [OK]

Hint: Use slicers for interactive filters [OK]

Common Mistakes:

• Deleting data instead of filtering
• Using pie charts to filter data
• Using text boxes instead of filter controls

3. Given a dashboard showing total website visits by channel, if the data is: Organic=5000, Paid=3000, Referral=2000, what will the pie chart show for Paid visits percentage?

medium

A. 30%

B. 25%

C. 50%

D. 20%

Solution

1. Step 1: Calculate total visits

   Total = 5000 (Organic) + 3000 (Paid) + 2000 (Referral) = 10000 visits.

2. Step 2: Calculate Paid visits percentage

   Paid % = (3000 / 10000) * 100 = 30%.

3. Final Answer:

   30% -> Option A

4. Quick Check:

   Paid visits = 30% of total [OK]

Hint: Divide part by total, multiply by 100 [OK]

Common Mistakes:

• Adding percentages instead of calculating
• Using wrong total for percentage
• Confusing counts with percentages

4. You created a dashboard but the filter for 'Campaign' does not change the charts. What is the most likely cause?

medium

A. The data source is offline

B. The filter is not connected to the data model

C. The dashboard has too many visuals

D. The charts are using the wrong color scheme

Solution

1. Step 1: Understand filter connections

   Filters must be linked to the data model fields used in visuals to affect them.

2. Step 2: Identify why filter has no effect

   If the filter is not connected properly, selecting values won't update charts.

3. Final Answer:

   The filter is not connected to the data model -> Option B

4. Quick Check:

   Filter connection missing = no effect [OK]

Hint: Check filter connections to data fields [OK]

Common Mistakes:

• Blaming colors for filter issues
• Assuming too many visuals cause filter failure
• Ignoring filter-data model link

5. You want to create a dashboard showing monthly revenue and conversion rate by marketing channel with a filter for last 6 months. Which combination is best?

hard

A. Use a line chart for monthly revenue, a card for conversion rate, and a date slicer for last 6 months

B. Use a pie chart for monthly revenue, a table for conversion rate, and no filter

C. Use a bar chart for total revenue only, a text box for conversion rate, and a filter for all time

D. Use a scatter plot for revenue and conversion, and a slicer for last year

Solution

1. Step 1: Choose visuals matching data types

   Line charts show trends over time well; cards highlight single KPIs like conversion rate.

2. Step 2: Select appropriate filter for time range

   A date slicer filtered to last 6 months allows focused analysis on recent data.

3. Final Answer:

   Use a line chart for monthly revenue, a card for conversion rate, and a date slicer for last 6 months -> Option A

4. Quick Check:

   Visuals + filter match data needs [OK]

Hint: Match chart type to data and add time slicer [OK]

Common Mistakes:

• Using pie charts for time series data
• Not adding time filters
• Choosing visuals that don't highlight KPIs clearly