If you really want to do this then brace yourself for a long haul this is not going to be one click process and will take a lot of time.
- Create a copy of this Google spreadsheet
- Click on tools>>script editor. This will open a new window
- In the new window click on resources>> Advanced google services
- Make sure status of "Google Analytics API" is on
- Click on "Google Developers Console" this will open a new window.
- In the new window turn on "Analytics API"
- Back to spreadsheet
- Click on Google Analytics >> Find profile / ids
- Replace your profile id in place of "ga:111111" in cells B3 and D3
- Open tab called "Funnel Steps"
- Define your funnel steps in column B like step1.php* , don't forget * at the end
- Make sure that in the same tab cell E1 has validation as "Campaigns!A:A"
- Navigate to Tools >> Scripts Editor
- This will open a new window for script editor
- In new window navigate to Resources >> Current Project's Triggers
- It will open a light box , click on "Add New Trigger"
- From 1st select box select option "getData"
- From 2nd select box select option "from spreadsheet"
- From 3rd select box select option "on change"
- Click on save and close the window
- Back to your spreadsheet, Click on Google analytics >> Get Data
- In the tab called "gaconfig" change value of cell B10 to "=CONCATENATE("ga:campaign==",'Funnel Steps'!E1)"
- Now navigate to tab "Funnel Steps" cell E1 will have drop down of all your campaigns
- Select any campaign you wish from drop down and refer to tab called "Funnel"
- Your campaign level funnel is ready
- You can use this to create ad group level or keyword level funnels too by making some changes
Fine print: I have also tested this for non filtered funnel (for all sources) and while comparing it with funnels in analytics i have found discrepancy of about 5%. Which i believe will be present at campaign level funnels. This will not work if your page view report returns more than 10000 rows for time period you have chosen. By default settings this is configured to show data of last 30 days. which you can change in tab called "gaconfig"
Digital Marketing / Web &amp; App Analytics expert with experience ranging from small businesses to very large portals. Across varied verticals like banking, travel, ecommerce, insurance. Google Adwords top contributor since 2013 and currently working with a leading Indian ecommerce portal. Aspiring writer, wants to be lighter!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.