Рус
Eng
Привет, меня зовут Миролюбов Владимир
Моя специальность — продакт-менеджмент и онлайн-бизнес. Изучаю психологию и философию. Делюсь разными идеями и мыслями на все эти темы. Больше обо мне тут.
9 April, 2015 in Blog , Blog (42), sales funnel (1)

My universal sales funnel (+ Excel)

Hi! Some friends ask me about how I control efficiency in my marketing campaign for my PLANO. Today I want to share some sales funnel excel table which help me to analyze all advert information.

This is standard sales funnel, but I In this table I use two global parameters – traffic channels and site ways.

sales-funnel

As you see, I use customer, product and channels segments and compare them on an advertising efficiency. This tab showing customer way and you can see strong are weak parts of your business.

Also, I use three colors: green (good), yellow (well) and red (poor) and mark them not only advertising efficiency. You can mark and your site efficiency page-ways too.

In the last tab, I use CAC (read more about “Online business metrics“) because these metrics shows you the cost of one of your paid client.

Download universal sales funnel.xlsx (12 Kb)

25 March in Blog
0

Hi! Some friends ask me about how I control efficiency in my marketing campaign for my PLANO. Today I want to share some sales funnel excel table which help me to analyze all advert information. This is standard sales funnel, but I In this table I use two global parameters – traffic channels and site ways. […]

24 March in Blog
0

Hi! Some friends ask me about how I control efficiency in my marketing campaign for my PLANO. Today I want to share some sales funnel excel table which help me to analyze all advert information. This is standard sales funnel, but I In this table I use two global parameters – traffic channels and site ways. […]