How do I create fallout calculated metric?

Avatar

Avatar
Validate 1
Level 2
e30powar
Level 2

Likes

5 likes

Total Posts

28 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
e30powar
Level 2

Likes

5 likes

Total Posts

28 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
e30powar
Level 2

13-08-2020

The ultimate goal here is to show a table of 200 geographic business units with their fallout % at each step of the purchase process so we can look for anomalies. In a fallout chart I can add the business units and show the comparison in the chart but more than 10 at a time is too much. 

e30powar_0-1597337009681.png


So how could i get it to something like this? The CSV export doesn't provide the columns & rows properly besides the fact that adding 200 BUs to the chart for export is not possible. 

 

e30powar_1-1597337391457.png

 

Building a free form table doesn't work because it's not using the logic of eventual path so the table has a higher visitor counts. If I could get the count of unique visitors by page name as eventual path then I could calculate the percentages myself.  

 
 

 

View Entire Topic

Avatar

Avatar
Validate 1
Level 2
e30powar
Level 2

Likes

5 likes

Total Posts

28 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
e30powar
Level 2

Likes

5 likes

Total Posts

28 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
e30powar
Level 2

13-08-2020

So after I wrote this, cathartic I guess, I figured out what to do. Check this out, by creating segments for each step and including each successive step in each segment I was able to match counts. 

 

e30powar_0-1597340283241.png

The segment for step 2 looks like this:

e30powar_1-1597340513508.png

 

Then by the 5th segment I have 5 page names. What's cool about this is I can set the segments to "Then Within" 1 visit, day, week etc.