By Timur Kuchushev, 17 January 2017

Conversion Funnel based on Google Analytics Sequences

Here is a free tool for building a conversion funnel for your web site using Google Sheets and the Google Analytics Add-on.
Sales funnel is a visual representation of the journey a consumer takes through navigating a website and finally converting to a sale.

With our tool you can use GA sequences as steps of the funnel. This makes it even more powerful and flexible than built-in funnel reports of the Google Analytics.
Using this interactive table https://goo.gl/eOlgHh you can make a conversion funnel for your site.
If you are new to Google Analytics Spreadsheet Add-ons, check an introduction and a video tutorial first.
Building segment
1
Give a name to your segment
2
Select "Sequences" - "Filter"
3
Build Steps of your sequence
Each sequence step is a step of the funnel.
4
Check the number of users in the final step of the sequence
Funnel Template Configuration
1
Start working
Open the spreadsheet https://goo.gl/eOlgHh and save a copy in your account.
2
Authorization
Watch the video below
3
Insert data
  1. GA View ID
  2. Exact dates you want to look at
  3. Name of your segment from GA
4
Upload segment
Click on "Get segment" button
5
Upload data into spreadsheet
Click on "Add-ons" → "Google Analytics"→ "Run reports". The Report Status must return "completed successfully" and your data will be automatically uploaded.
6
Preview
Your funnel is ready. Below is an example of what your funnel may look like.

Back to the list