How to visualize Your Funnel Using Sequential Segment ( A GA and GDS Walkthrough)

Quick Navigation

What This Will Teach You To Do.

This video will teach you how to really use sequential segments in Google Analytics to see how people navigate through your website especially if you have a pre-defined funnel that you want to measure.

Power of Building Sequential Segments in Google Analytics

While Google Analytics is great, it does a very poor job of showing how people move through your website.

With user flow information in Google Analytics, you can see the navigation path, people are using on your website but if you know your funnel, then you can use sequential segments to see user flow.

And it does not matter what type of website it is, SAAS, E-commerce, etc, all you need to do is to understand the path you want to measure.

Mapping Out Your Funnel in LucidChart

But if you know your funnel, then you want to create a pictorial representation of this using LucidChart.

how to visualize sequential segment using in google analytics and looker data studio

In this example, using one of our client’s websites, we will create a chart that shows the flow between the homepage and the deals page since that is what we want to measure.

So let’s get that flow chart into LucidChart and we need to show the customer/client so clearly what we are measuring.

How to Setup Sequential Segments in GA, Step By Step

Now that we have mapped out the steps, we can go into Google Analytics and start creating the sequential segment.

And you can do this from any report. One of my favorite reports is the Source/Medium report in Google Analytics.

Step 1: Click on Segments

Step 2: Click Sequence.
The trick/hack here is to create the end first. This is because it makes it easier to create other steps in the funnel. 

Step 3: Name your segment. I usually like to use the name of the path I’m measuring in the naming convention. So for this example, it will be Deals 1.1 – Home Page – Deal Page [sequential].

Step 4: Create the first steps of your funnel.  

Step 5: Click Save

Step 6: Duplicate the first step and delete the step not needed. Name it appropriately.

Now we have all the steps needed in our new segment.

With the sequential segment created, we can quickly see the conversion rate between the two pages.

Using Your GA Sequential Segments in Data Studio

The next step I will do is to bring this into Data Studio.  And we can see the power in this as Data Studio tries to guess what we are trying to calculate.  With Data Studio, we are able to visualize it using trend line

Configuring Data Studio

To configure this in Data Studio, you want to connect your data source: Google Analytics and then add the data chart to it.

  • Click to insert the chart
  • Add users as the metric
  • Rename it to the name of the steps
  • Add the steps in your sequential segment to the report
  • Now divide the two steps with each other and that will give us the conversion rate.

You can make your report more meaningful and visually appealing by adding trendlines and data controls for date or channel.

What We Learned in Review

In this tutorial, we have been able to learn how to set up a sequential segment to measure conversion rate along a pre-defined funnel. We also learned how to visualize this in Data Studio and add control to show the conversion rate per channel.

Ready to Learn more: Get more out of your Analytics Setup. Learn more

Join 25,000+ Marketing Professionals

If you enjoyed this post, please consider subscribing to the Invesp blog feed to have future articles delivered to your feed reader. or,receive weekly updates by email:

Get CRO Advice You Can Act On

No spam. Unsubscribe any time.

Leave a Comment

Your email address will not be published.


About Us

Meet Ryan and learn how Rednavel Consulting might be a great fit for you Analytics + CRO needs.

I have a passion for helping people. I’ve found that I can help a lot more people as an Internet Marketing Consultant/Entrepreneur than anything else in life.
When I realized this, I had a change in career paths.
#CollegeDropout
Since then, I taught myself how to code, which is the backbone of the technical marketing I do now-a-days.

Apply to work with Rednavel Consulting

Our Assistant, Stringbean