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.
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.
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
2
Authorization
Watch the video below
Watch the video below
3
Insert data
- GA View ID
- Exact dates you want to look at
- Name of your segment from GA
4
Upload segment
Click on "Get segment" button
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.
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.
Your funnel is ready. Below is an example of what your funnel may look like.
