Hi,
I'm trying to figure out how I can automate listing of the specific urls, users, and bounce rates for top user visited pages, top cities (ga:city) and top referring domains.
Can you please help with some of the code to pull that off?
thanks very much!
Chris
Hi,
I'm not 100% sure what you mean. Can you do a made-up sheet with the desired output?
Hey. Thanks for the response!
The best way to convey what I'm trying to achieve is as follows:
https://ga-dev-tools.appspot.com/query-explorer/
In my examples below the first link is the Google analytics API search. The second is the example result that I'd like to generate via SEO tools. Can you help me with the formula to achieve that?
Page Path
https://drive.google.com/open?id=1qEBCXzG-gAFWphNPTZmgYSfs2lLkSe2c
https://drive.google.com/open?id=1oyw_NMep5PgX5KwQo8s-IP7Gx8ntEu2t
City
https://drive.google.com/open?id=1-6oowvFhNDokU-M91GZZYk3VGTildTOk
https://drive.google.com/open?id=1BO8gBPz_Q--q0rHAoCE4Dzm_s0PXXvNu
Full Referrer
https://drive.google.com/open?id=1QDjJdViiNr7Jq2-WzuaTyKSLfc1xQgl6
https://drive.google.com/open?id=1QgQaoG3-QuMlSrOidhFdl3ob7UVAC_Ym
You can disregard. I was making a mistake with my selections in seotools.