Executive Dashboard: Sales Funnel Analysis

Executive Dashboard Sales Funnel Analysis

Desciption

Executive Dashboard: Sales Funnel Analysis
This executive dashboard provides an overview of customer behavior within a sales funnel. It provides insight into which days of the week customers are most likely to visit, which platform they are using, and the gender distribution of visitors. This dashboard can be used to identify trends and opportunities for optimization, as well as to measure the effectiveness of marketing campaigns.

Summary:
-Analyze customer behavior within a sales funnel
-Identify trends and opportunities for optimization
-Measure the effectiveness of marketing campaigns
-Analyze which days of the week customers are most likely to visit
-Analyze which platform customers are using
-Analyze the gender distribution of visitors

Who Can Benefit:
-Marketing professionals
-Business owners
-Analytics professionals

Benefits:
-Gain insight into customer behavior
-Identify trends and opportunities for optimization
-Measure the effectiveness of marketing campaigns
-Gain a better understanding of customer preferences and demographics

Data

Sales Funnel Analysis
Executive Dashboard example
All Visitors
90,400
Visits
by devices
Mobile
33.4%
All Visitors
Day of Week heatmap
For each funnel stage, which day(s) receive the most traffic?
Sun Mon Tue
12,922 12,955 12,697
Search
Payment
90,400
VISITORS
Confirmation
6,462 6,483
855
62
Desktop
66.6%
77
6,252
853
69
Mobile
Search
45,200
50% of All Visitors
Funnel Progression
Percent change based on previous funnel stage | Are there any trends based on the platform used?
Desktop
6,335 6,717
Wed Thu Fri Sat
12,831 13,444 12,750
838 899
54
All Visitors
Search
Payment
Confirmation
All Visitors
Search
Payment
Confirmation
66
This Summary Dashboard example generally serves as my initial target for dashboarding projects. Additional functions,
features, and charting requests are iteratively implemented with stakeholder feedback, while alternative approaches are
presented if the level of effort required exceeds a reasonable amount of time or simply isn’t possible. Color themes are
primarily based on company branding but custom palettes are also used if given the opportunity
Payment
871
6,406 6,545
54
12,801
150-95.0%
845
70
1,010-00.0%
3,020-80.0%
302-90.0%
6,030
6.7% of All Visitors
All Visitors
45,325 | 100.0%
15,100-50.0%
Gender Distribution
Does aske/bias exist between anders?
Search
22,52449.7%
Male Visitors
30,100-50.0%
30,200
Payment
2,930 | 6.5%
Confirmation
211 | 0.5%
Payment
3,100 | 6.9%
Confirmation
241 | 0.5%
DATE RANGE
1/1/2015 4/30/2015
Confirmation
452
0.5% of All Visitors
Search
22,676 | 50.3%
Female Visitors
60,200
All Visitors
45,075 | 100.0%