Dashboard creation for marketing KPIs in Digital Marketing - Step-by-Step Execution

Concept Flow - Dashboard creation for marketing KPIs

Identify KPIs

↓

Collect Data

↓

Choose Visualization Types

↓

Design Dashboard Layout

↓

Build Dashboard

↓

Review & Adjust

↓

Share Dashboard

This flow shows the step-by-step process to create a marketing KPI dashboard, from deciding what to measure to sharing the final dashboard.

Execution Sample

Digital Marketing

KPIs = ['Website Traffic', 'Conversion Rate', 'Bounce Rate']
data = collect_data(KPIs)
visuals = create_charts(data)
dashboard = build_dashboard(visuals)
show(dashboard)

This example collects data for key marketing KPIs, creates charts, builds a dashboard, and displays it.

Analysis Table

Step	Action	Input	Output	Notes
1	Identify KPIs	None	List of KPIs: Website Traffic, Conversion Rate, Bounce Rate	Decide what metrics matter
2	Collect Data	KPIs list	Data for each KPI collected	Gather data from sources like Google Analytics
3	Choose Visualization Types	Data	Charts selected: Line chart for traffic, Gauge for conversion, Bar for bounce	Pick best chart for each KPI
4	Design Dashboard Layout	Charts	Layout plan created	Arrange charts for clarity
5	Build Dashboard	Layout plan, Charts	Interactive dashboard built	Use tools like Tableau or Power BI
6	Review & Adjust	Dashboard	Dashboard refined	Fix issues, improve readability
7	Share Dashboard	Final dashboard	Dashboard shared with team	Publish or send link
8	End	N/A	Process complete	All steps done

💡 All steps completed, dashboard is ready and shared

State Tracker

Variable	Start	After Step 1	After Step 2	After Step 3	After Step 4	After Step 5	After Step 6	Final
KPIs	None	['Website Traffic', 'Conversion Rate', 'Bounce Rate']	Same	Same	Same	Same	Same	Same
Data	None	None	Collected data for KPIs	Same	Same	Same	Same	Same
Visuals	None	None	None	Charts created for each KPI	Same	Same	Same	Same
Layout	None	None	None	None	Layout plan created	Same	Same	Same
Dashboard	None	None	None	None	None	Dashboard built	Refined dashboard	Final dashboard shared

Key Insights - 3 Insights

Why do we need to identify KPIs before collecting data?

Identifying KPIs first (see execution_table step 1) ensures we collect only relevant data, saving time and focusing on what matters.

How do we decide which visualization type to use for each KPI?

Choosing the right chart (step 3) depends on the data type and what story you want to tell, as shown by selecting line, gauge, or bar charts.

Why is reviewing and adjusting the dashboard important after building it?

Reviewing (step 6) helps catch errors and improve clarity, making sure the dashboard communicates insights effectively.

Visual Quiz - 3 Questions

Look at the execution_table, what is the output after Step 2?

A Data for each KPI collected

B List of KPIs identified

C Dashboard built

D Layout plan created

💡 Hint

Check the 'Output' column for Step 2 in the execution_table.

At which step is the dashboard actually built?

A Step 3

B Step 5

C Step 6

D Step 7

💡 Hint

Look for the step where 'Interactive dashboard built' appears in the Output column.

If we skip Step 1, what would likely happen to the data collected?

A Data would be irrelevant or too broad

B Data would be more accurate

C Dashboard would build faster

D Visualization types would be easier to choose

💡 Hint

Refer to key_moments about the importance of identifying KPIs before data collection.

Concept Snapshot

Dashboard Creation for Marketing KPIs:
1. Identify key metrics to track.
2. Collect relevant data from sources.
3. Choose charts that best show each KPI.
4. Design a clear layout.
5. Build and refine the dashboard.
6. Share with stakeholders.

Full Transcript

Creating a marketing KPI dashboard involves several clear steps. First, you decide which key performance indicators (KPIs) matter most. Then, you collect data for those KPIs from your marketing tools. Next, you pick the best types of charts to show each KPI clearly. After that, you design how the dashboard will look, arranging charts for easy understanding. Then, you build the dashboard using software tools. You review and adjust it to fix any issues and improve clarity. Finally, you share the dashboard with your team or stakeholders so everyone can see the marketing performance at a glance.

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