Bottom line: Flow diagrams were useless to me for years because the tools drew every path and explained none of them. Shape the paths in BigQuery first, color each flow by whether it ends in a purchase, and add a channel filter, and the same diagram becomes one of the most useful views of a website I have. This post walks through all of it, queries and code included, using Google's public GA4 sample data. more...