Monday - Sunday Weekly Granularity in Report Builder

Thanks Tanmay,

That's really helpful. I have a follow up question. Will altering the week start retroactively update all of our previous data? Will it cause any issues with counting (for example) Unique Visitors? I don't want to make changes if it will skew what I already have.

Thanks

Tobz

Hi Toby, 

Changing the calendar changes the way data is processed (i.e. the definition of weekly and monthly unique visitors). When a calendar's definition of weeks and months changes, historical data is not altered.

Another way you could achieve this is by using custom expressions https://marketing.adobe.com/resources/help/en_US/arb/t_customized_date_expressions.html

You could enter an expression like : From cw-6w-1d (current week minus 6 weeks minus one day) To cw-1w-1d (current week minus one week minus one day) and select the granularity as weekly to get a time shifted reporting of data. 

Let me know if this is helpful. Thanks!

Tanmay

Hi Tanmay, 

could you maybe clarify what happens when the calendar definiton of weeks changes? 

In toby's example, say we change first day of week from Sunday to now be Monday. Assuming we have been collecting data on this report suite for 2 years. 

What would be the implications? 

Are we simply shifting the calendar 1 day forward to defin a week as starting on a Monday as opposed to a Sunday, which is what we expect and hence Uniques numbers can clearly be different due to processing them over a different range of dates. 

or...

is part of our data before the change calculating uniques with weeks starting on Sunday, and the rest of data from date the setting is changed calculating uniques with Sart of week as a Monday.

I'd like to get a clearer understanding of how the data will be affected in order to assess if it is a risk for me to change this setting on a report suite that has already been capturing data for a few years. 

much appreciated

Kind regards

Hi, 

Once you apply the new definition of the week the trended reports would display data corresponding to the new range of week. It does not change your historical data. For example, in the normal calendar you would see the data of visits for the week of 1st (sunday) to 7th (saturday) May 2016. If you start your calendar week from Wednesday you will see the report display data for weeks as 27th Apr to 4th May and therefore the count of visits would be different. 

I am not sure how it would affect the already scheduled reports and dashboards though. Still researching on that part. I hope this was helpful. Thanks!

Tanmay 

Hi Tanmay,

Thanks for this. I think the biggest concern is over scheduled reports / dashboard as these are the areas that will feel the biggest "jolt" if we change the date period, have your investigations come up with anything on this?

Thanks

Toby

Hi Toby,

Yes I have researched around this. Changing the date period will change the scheduled reports & Dashboards as well if they have any component of the week. They would now report the data according to the new definition of the week. So you would have to take that into consideration. 

Tanmay

Hi Kristi, 

Since you are using Current Week (cw) it anchors to the first day of the week which by default is Sun-Sat for you. 

You would have to get into the day granularity and calculate according to the day you are setting up the report. For example, if i want a report for last week i would do cd-11d to cd-4d

Can you try this and see if it works?

Hi Tanmay,

can it be rolled back. Suppose I change my calendar and now I want to undo.

Can I do that?

Or is it a one time function which admin can perform then after no change is allowed.

Thanks,

Ujjwal