Google Analytics Funnel Builder with mandatory first step

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.

is a Google Analytics fan, who also loves SEO, conversion optimization, online marketing and social media. You can follow her on Twitter and LinkedIn.

4 thoughts on “Google Analytics Funnel Builder with mandatory first step

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

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

Leave a Reply

Your email address will not be published. Required fields are marked *