Correct parameters for filtering landing pages

169 views
Skip to first unread message

Pedro Teixeira

unread,
Oct 30, 2016, 5:21:13 PM10/30/16
to google-analytics-spreadsheet-add-on

Hi,

 

I'm trying to use the API in Google Docs through the plugin and would like to extract the number of sessions, transactions and revenue from organic traffic during the month of August but only for landing pages where the URL contains "/restaurants/".

 

I've tried like as seen below but I'm getting an error because of the incorrect dimensions:

 

test2.jpg
 

 

 

Can you please help me out setting up the parameters correctly?

 

Thanks,

 

Pedro

Pedro Teixeira

unread,
Oct 31, 2016, 1:38:21 PM10/31/16
to google-analytics-spreadsheet-add-on

Here's a visual: 

Philip Walton

unread,
Oct 31, 2016, 1:47:02 PM10/31/16
to Pedro Teixeira, google-analytics-spreadsheet-add-on
You don't need to URL Encode the equals sign in your filter. You only need to do that when the param is being requested as part of a URL (which in this case it's not).

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/f09d0895-4bcf-40a3-b9f1-7a81696a9e33%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Pedro Teixeira

unread,
Oct 31, 2016, 5:22:31 PM10/31/16
to google-analytics-spreadsheet-add-on, pedrote...@gmail.com
Thanks for getting back on this. How can I then retrieve these sessions, transactions, revenue figures but only for Landings Pages URLs containing the  "/restaurants" ? I'm trying to mimic a GA filter but not sure how to do it.

Pedro Teixeira

unread,
Nov 1, 2016, 3:13:39 AM11/1/16
to google-analytics-spreadsheet-add-on
Any help please? It sounds like a straightforward thing to extract but I can't seem to find the correct commands to use. Also don't now how to further make this more complex and add goals information.

Please excuse any typos as sent from the iPhone

Alex Nisavic

unread,
May 4, 2017, 12:02:57 PM5/4/17
to google-analytics-spreadsheet-add-on
I'm trying to do something similar with getting pageviews and goals retrieved for specific pages. 

Have you found a solution for this??
Reply all
Reply to author
Forward
0 new messages