Setting a week to run from Mon-Sun instead of Sun-Sa?

[Paco Vermeulen]

Hi,

I'm new to using the Google Analytics spreadsheet add-on, and I was wondering how I can setup the definition of a week.

Currently I'm importing a couple of metrics with the dimension ga:week. This returns an index where each week starts on a Sunday. In our internal reporting we define a week as starting on Monday. 

How can I import my metrics summed per week (where a week starts on Monday and ends on Sunday)?

Thanks in advance,

Paco

[Philip Walton]

Hey Paco, I'm not sure if this is possible. You'd probably have better luck asking a reporting question like this on Stack Overflow with the [google-analytics] tag.

--
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-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/84febd81-606b-482f-abe4-ff229ab64870%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Tara Stockford]

Hi Paco

You can use ga:isoWeek instead, to get weeks starting on Monday (https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=detail&group=time&jump=ga_isoweek).

So for example, last Sunday was the beginning of week 47 but still the end of ISO week 46.

Tara