ga:week represents gregorian calendar isn't showing 1/1 - 1/2 as Week 53 in the Google Sheet GA Add-in

gzog / analytics-issues

Automatically exported from code.google.com/p/analytics-issues

0 stars 0 forks source link

ga:week represents gregorian calendar isn't showing 1/1 - 1/2 as Week 53 in the Google Sheet GA Add-in #843

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago

Ga:Week 53 is only showing data between 12/27 and 12/31.  GA:Week 1 is only 
showing data for 1/1/ to 1/2.  Since ga:week is supposed to be the gregorian 
calendar this is not how the data should appear.  Week 53 2015 should be 12/27 
- 1/2  Can you please help?

Original issue reported on code.google.com by yodusa...@gmail.com on 3 Jan 2016 at 11:47

GoogleCodeExporter commented 8 years ago

What dates are you requesting data for?
Please include your full request.

Original comment by mcoh...@google.com on 4 Jan 2016 at 6:07

GoogleCodeExporter commented 8 years ago

I was trying to get data for Week 53 2015 which should have been dates
12/27/2015 to 1/2/2015.  However ga:Week 53 only showed data from 12/27 to
12/31 when I believe it should have showed data for the entire week.

Original comment by yodusa...@gmail.com on 4 Jan 2016 at 6:12

GoogleCodeExporter commented 8 years ago

What were the start date and end dates of your requested query?

Original comment by mcoh...@google.com on 4 Jan 2016 at 6:31

GoogleCodeExporter commented 8 years ago

12/27 to 1/2.

Original comment by yodusa...@gmail.com on 4 Jan 2016 at 6:33

GoogleCodeExporter commented 8 years ago

If you requested data for 1/1/2015 to 12/31/2015 the resulting data will not 
include 1/1/2016.

Original comment by mcoh...@google.com on 4 Jan 2016 at 6:33

GoogleCodeExporter commented 8 years ago

If you requested data for 1/1/2015 to 12/31/2015 the resulting data will not 
include 1/1/2016.

Original comment by mcoh...@google.com on 4 Jan 2016 at 6:33

GoogleCodeExporter commented 8 years ago

No, I requested data for 12/27/2015 to 1/2/2016.

Original comment by yodusa...@gmail.com on 4 Jan 2016 at 6:35

GoogleCodeExporter commented 8 years ago

I asked for the dimension to be ga;week

On Mon, Jan 4, 2016 at 12:34 PM, Yewande Odusanwo <yodusanwo@gmail.com>
wrote:

Original comment by yodusa...@gmail.com on 4 Jan 2016 at 6:35

GoogleCodeExporter commented 8 years ago

I now understand, ga:week is defined as "week of year" 
https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=d
etail&group=time&jump=ga_week

Week 53 of 2015 only includes the dates of 12/27 to 12/31
week 1 of 2016 only includes the dates of 1/1 to 1/2 

The solution you might use is to request the ga:year in addition to the ga:week 
and then add 2015,53 and 2016,1

Original comment by mcoh...@google.com on 4 Jan 2016 at 6:44

GoogleCodeExporter commented 8 years ago

Hello,

I agree, but according to the ga:week definition you provided:  Each week
starts on Sunday.  However, the Google Add-in is showing Week 1 2106 as
starting on Thursday.  Is that the way it should be?

Original comment by yodusa...@gmail.com on 4 Jan 2016 at 6:50

GoogleCodeExporter commented 8 years ago

Yes I think that everything is working as intended. every week block is Sunday 
to Saturday and weeks 1 and week 53 will inevitably be short weeks, there are 
days in those weeks that fall outside the "week of the year" for which no data 
is reported.  If you do not query for ga:year your week 1 will likely include 
data from week 1 of 2015 and the two days from week 1 in 2016.

Similarly if you were to query day of month you would also want to query for 
the month to distinguish between the first of one month and the first of 
another month.

Original comment by mcoh...@google.com on 4 Jan 2016 at 7:21

Changed state: WontFix