Funnel analysis diagram for data analysis of a trader

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

The funnel chart is a management analysis tool which is suitable for the business process comparison specification, the period is long, each process link involves the complex business process. Funnel charts make it very intuitive to find pages or links that are problematic in business processes. The conversion rate of some key paths in the consumer Web site is an example of how the user can not only display the final conversion rate from the website to the purchase, but also the conversion rate of each step in the whole critical path. The following figure, combined with the actual exercise, with you to explore the implementation of this diagram, I had studied for a while to figure out, and I hope that the level of children with such shoes useful.

When I first saw someone make such a picture, I worshipped all kinds of things. Actually do a few more times after the discovery is quite simple.

In the original 6184.html "> data table to build a column, as the placeholder data, in addition, the conversion rate of each link, the overall conversion rate, the formula is as follows:

Nth link Placeholder data = (first link Entry number-Nth link entry number)/2

Nth link conversion rate = Nth Link Entry number/number (N-1) Link Entry numbers

Nth link Total conversion rate = Nth Link Entry number/1th link Entry number

Select the number of central data and placeholder data two columns, insert stacked bar chart, the following drawing effect. We usually align the key links from the overall to the Top-down order. Then, you can set the axis format on the vertical axis by right-clicking check the reverse category, and then right-click on the data source, and then click the Move Down button in the "Number of numbers" in the midpoint of the legend key to make sure, so the inverted triangle model comes out. The following figure:

Then the placeholder data bar in the icon to hide (on the red bar right "set data series format", the filler border is set to "no" can be), the legend, grid lines are deleted, the funnel map came out, the following figure:

The data in the figure can be added through a macro-defined tool Jwalk Chart tools to add (Baidu can, there is a tutorial), the funnel box is "insert"-> "shape"-> "Freeform", and then the color alignment is OK. The conversion rate of each link can be achieved by adding a "down arrow" shape to the left and inserting text into the arrows. Because the first link conversion rate is only 40% of each link is the lowest, so with light green marked, so the emphasis is also prominent.

In fact, a single funnel chart can not evaluate the site of a key process in the conversion rate of the good or bad. It is necessary to compare the effect before and after the same link, or to contrast the conversion rate of different users in the same link, or to compare the conversion rate of similar products in the same industry.

Of course, the funnel chart can not only reflect the user's conversion rate and loss rate in the business, but also can tell us the popularity of each business in the consumer Web site or the degree of importance, through the comparison of different business funnel chart, can find out the popularity of different, find hidden in the business problem.

Original text and: http://www.moguozhong.com/web-analytics/b2c-loudou.html, welcome reprint.