Automate analytics with spreadsheets for statistics

0 replies
  • SEO
  • |
Hi, I have just read and watch the video on this blogpost: Automate Google Analytics Reporting using Google Apps Script - Analytics Blog

To automate GA with a spreadsheet you have to fill in these fields in Google Docs:

query1 value1
type core
ids ga:XXXXXXX (I will not show my code)
start-date 1-9-2012
end-date 31-9-2012
last-n-days
metrics ga:visitors
dimensions ga:date
sort
filters
segment
start-index
max-results
sheet-name myname

This way I get the unique visitors per day automatically in a spreadsheet.

But here is my question: how do I get to see the unique visitors of a segment?

You have to fill in the name of the segment I think. Here is the reference code of segments.

So I filled in "method getName(Salespages)" because my segment is called Salespages but when I try to get the data then, it says the field is not valid.

What should I fill in after the field 'segment' above to get the unique visitors of the segment 'Salespages?'
#automate #question #spreadsheets

Trending Topics