High Level Design

Overview

Understanding your sales funnel and its key components is critical before you can begin to evaluate and improve results – starting from leads through to closing sales opportunities. By analyzing the efficiency of your sales funnel, you will be able to spot bottlenecks and take the required action to improve the health of your business. Armed with the idea that each proposal has a sales funnel of its own, you will be able to advance your business proposals to new levels.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

Leads to Wins Analysis - Marketing Dashboard

Goals

  • Enable the business to create a focused series of events that all point towards the primary objective of sales conversions.
  • Allow the business to ‘sell right’ by building positive brand awareness and reputation before qualifying leads.

Objectives

Winning more deals from lead to close.

KPI Architecture

Objectives KPIs Measures Data Source
Winning More Deals from Lead to Close Leads to win #Leads Where Funnel-Stage = Leads Created [CRM System]. Leads
#Opportunities Where Funnel-Stage = Opportunities Won [CRM System].Opportunities
Leads Created to Qualified #Leads Where Funnel-Stage = Leads Created [CRM System]. Leads
#Opportunities Where Funnel-Stage = Leads Qualified [CRM System]. Leads
Leads Qualified to Opportunities Created #Opportunities Where Funnel-Stage = Leads Qualified [CRM System]. Leads
#Opportunities Where Funnel-Stage = Opportunities Created [CRM System].Opportunities
Opportunities Created to Closed #Leads Where Funnel-Stage = Opportunities Created [CRM System].Opportunities
#Opportunities Where Funnel-Stage = Opportunities Closed [CRM System].Opportunities
Opportunities Win Rate #Leads Where Funnel-Stage = Opportunities Closed [CRM System].Opportunities
#Opportunities Where Funnel-Stage = Opportunities Won [CRM System].Opportunities

Data Requirements

# Source Table Name Table Details (type, # rows, key fields)
1 [CRM System] Lead Track prospects apart from your contacts and opportunities with [CRM System] lead records.
2 [CRM System] Opportunity
3 [CRM System] Employee
4 [CRM System] Country

Data Modeling (Elasticube Design)

Suggested data model for leads-to-win analysis