Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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.  

 
 

 

Accepted Solutions (1)

Accepted Solutions (1)

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.

Answers (2)

Answers (2)

Avatar

Avatar
Boost 5
Level 2
mesood
Level 2

Likes

16 likes

Total Posts

51 posts

Correct Reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile

Avatar
Boost 5
Level 2
mesood
Level 2

Likes

16 likes

Total Posts

51 posts

Correct Reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile
mesood
Level 2

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
Level 1
stahl_p
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
stahl_p
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
stahl_p
Level 1

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).