How do I create fallout calculated metric?

Avatar

Avatar

e30powar

Avatar

e30powar

e30powar

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.  

 
 

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

e30powar

Avatar

e30powar

e30powar

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.

Answers (2)

Answers (2)

Avatar

Avatar

mesood

Avatar

mesood

mesood

17-08-2020

You can give a try by utilizing Create segment from touchpoint within fallout report. Refer: https://docs.adobe.com/content/help/en/analytics/analyze/analysis-workspace/visualizations/fallout/c...

Avatar

Avatar

stahl_p

Avatar

stahl_p

stahl_p

15-08-2020

Nice. Your scope is visitor, which is pretty extensive by looking at a sales/checkout funnel.

Have you tried/checked the numbers by setting the scope to visit or even hit (which would we the most restrictive funnel).