Before you start

Download the Google Analytics API add on

Make a copy of this spreadsheet

This Google Sheet is set to "View Only", by making a copy you can edit & use the Funnelisator yourself

Do so by using the "File -> Make a copy" options in the menu.

What is my Google Analytics View ID?

In the URL of the relevant Google Analytics Reporting view, copy the number after the "p" and before the "/".

So for this example: "114831432"

Adjust the settings according to your funnel and details

By default, putting an page name in the "Page definition" field, will select visitors that had an exact match for that page. ("ga:pagePath==/example_page")

You can also use regular expressions and/or other dimensions, by entering the full filter in the "Page definition" fields. For example:

ga:pagePath=~/phones/(.*)?/

use regular expression operator: "=~"

ga:eventCategory==ScrollTracking;ga:eventAction==50%

uses events instead of pages

All available dimensions and metrics

https://ga-dev-tools.appspot.com/dimensions-metrics-explorer/

Build segments in GA Interface, test API & retrieve definition in Query Explorer

https://ga-dev-tools.appspot.com/query-explorer/

https://developers.google.com/analytics/devguides/reporting/core/v3/reference#filterOperators

Start analyzing funnels :)