funnel ROi

profileinwoodchck
Copyofeyecarechart1.xlsx

Sheet1

Dr. Corneal's Projected Sales Funnel
Google Newspapers Magazines Radio
Prospects (5000) 4,500 3,000
Leads Level A
Wears Glasses 3,375 1,875
Leads Level B
Fashion Sunglasses 250 100
Total Leads Level A+B 2,550
Opportunities 191 10
Customers 5
Total Customers
Assumptions:
5,000 people live within 15 miles of Dr. Corneal's store
90% use Google regularly, 50% read newspaper, 60% read magazines, 20% listen to radio
Based on medical data,on average 75% of the population needs glasses
Radio listeners are older, have more eye issues, 90% need glasses
10% of people don't need glasses but like fashion sunglasses
Average Call To Action Response Rates
Google 5%
Newspapers 2%
Magazines 3%
Radio 1%
Average conversion rate from Opportunity to Customer - 50%