My organization is looking into the option of redefining the start of the week dimension from Sunday to Monday and we are trying to understand the impact on historical data. In the attached article, we read "When a calendar’s definition of weeks and months changes, historical data is not altered." Can anyone explain what this means? If we use the week dimension and are analyzing a date range prior to this change, would those dimensions still show as week beginning on Sunday? Or would it redefine past weeks as week starting on Monday?
Thank you!
Solved! Go to Solution.
Views
Replies
Total Likes
I believe there are some calculations based on date configurations during data processing... Anything that is calculated should be fine, but it can be hard to determine which is which.
I've not actually changed the date settings, instead, for the users that needed Monday to Sunday reports, I used a series of custom date ranges.
However, if I were to do that, my first step would be to use an existing, or create a new QA/Dev/UAT suite and get some base data collected over a few months (preferably)... then change the date configuration on the test suite. in fact, I may be more tempted by a new suite, and track the existing QA/Dev suite in parallel (i.e. have the same data in 2 suites)
Then I could change the date configuration, and with 2 identical data sets, I could compare how reports will look. Basically, try to do due diligence prior to making the change so that you know what you are in for....
Good Luck
Views
Replies
Total Likes
I believe there are some calculations based on date configurations during data processing... Anything that is calculated should be fine, but it can be hard to determine which is which.
I've not actually changed the date settings, instead, for the users that needed Monday to Sunday reports, I used a series of custom date ranges.
However, if I were to do that, my first step would be to use an existing, or create a new QA/Dev/UAT suite and get some base data collected over a few months (preferably)... then change the date configuration on the test suite. in fact, I may be more tempted by a new suite, and track the existing QA/Dev suite in parallel (i.e. have the same data in 2 suites)
Then I could change the date configuration, and with 2 identical data sets, I could compare how reports will look. Basically, try to do due diligence prior to making the change so that you know what you are in for....
Good Luck
Views
Replies
Total Likes
Thanks for this advice, Jennifer. If we proceed with this methodology for testing I will provide an update with the results.
I haven't changed any report suite's calendar before. But I'd say it works like the following:
Let's say you have the following data:
And let's say your original calendar setting was with a standard Sun-Sat week.
Then when you reported page views by week, AA would report the following:
Now, if you were to change the calendar to a Mon-Sun week, then:
And AA should report the following:
This is how I would expect it to work... I think there are some old legacy fields that are actually set during processing (mobiledayofweek - part of the mobile dimensions; and weekly_visitor which is part of the old Weekly Unique Visitors metric... ), but you likely aren't using these... That data also wouldn't be updates with the change, but new data going forward would be recorded based on your calendar configuration.
In most cases, you will use the standard Day of the Week and just Unique Visitors broken down by week (rather than the specific "Weekly Unique Visitors metric)
Views
Likes
Replies