How do I create a Fallout visualization when by pages (URLs) are in four different report suites and there is no universal report suite?
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:
- Total Visits: xxx
- Entries from previous page: 0
- 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.
It might not be possible, as far as I know.