Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Fallout Visualization

Avatar

Level 2

How do I create a Fallout visualization when by pages (URLs) are in four different report suites and there is no universal report suite?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

The short answer is: You can't.

The long answer is: You can, sort of, with Excel, but it won't be 100% accurate.

For each Page, get 1) its total Visits, and 2) its Entries where the Referrer is the previous page's URL, e.g. for Page 2, the Referrer would be Page 1's URL. At the end, you should have something like this:

Page 1:

- Total Visits: xxx

- Entries from previous page: 0

Page 2:

- Total Visits: yyy

- Entries from previous page: zzz

...and so on

Then the flow from Page 1 --> Page 2 would be yyy / xxx.

Note: This will definitely not be exactly what you're looking for, because not all users from Page 2 would have been from Page 1. So when you do the flow from Page 2 --> Page 3, that flow % will not be a subset of the Page 1 --> Page 2 flow %.

The best answer is: start tracking your pages in one report suite.

View solution in original post

2 Replies

Avatar

Employee Advisor

It might not be possible, as far as I know. 

Avatar

Correct answer by
Community Advisor

The short answer is: You can't.

The long answer is: You can, sort of, with Excel, but it won't be 100% accurate.

For each Page, get 1) its total Visits, and 2) its Entries where the Referrer is the previous page's URL, e.g. for Page 2, the Referrer would be Page 1's URL. At the end, you should have something like this:

Page 1:

- Total Visits: xxx

- Entries from previous page: 0

Page 2:

- Total Visits: yyy

- Entries from previous page: zzz

...and so on

Then the flow from Page 1 --> Page 2 would be yyy / xxx.

Note: This will definitely not be exactly what you're looking for, because not all users from Page 2 would have been from Page 1. So when you do the flow from Page 2 --> Page 3, that flow % will not be a subset of the Page 1 --> Page 2 flow %.

The best answer is: start tracking your pages in one report suite.