As a follow-up to my post about discontinuing PadiTrack and the suggested alternative with Google Sheets, here’s a short update after a few people requested a version with the option to select mandatory first step of the funnel.
So, here’s an updated version of the GA Funnel Builder where steps 2 through 10 require that the visitor has also viewed step 1. To save the document in your account, select File – Make a copy.
As a future version we’ll see how to add events to the pageviews being tracked as funnel steps.
If you have any other questions or ideas, please share them below.
P.S. Got a Google Analytics question? Send it to me and I’ll try to answer it on the blog.
Margarita Evtimova
Margarita Evtimova is a Google Analytics fan, who also loves SEO, conversion optimization, online marketing and social media. You can follow her on Twitter and LinkedIn.
This set of spreadsheets has been a lifesaver when getting dumped into a project halfway through where Goals in GA were not correctly set up… but this one with the mandatory first step only yields 0 when I know there has been traffic that has followed the path beginning with the first step. Do we need to make a tweak somewhere to get this to apply the first URI as mandatory? Thanks.
Hi Michelle, can you share your file? Maybe there’s an error in my formula.
Thank you for your awesome temple. I was so lost when paditrack was discontinued.
And I am wondering if we can have “required step” just like in analytics when you set up goal, visitors with have to go through previous steps in order to be counted on the funnel using this temple you provided?
Thank you
Hi James, it would definitely be possible, I’ll have to update the template to include it. Hope to do this soon.