Weekly data in Data Warehouse Report

[karolk31579512]

In Adobe Analytics I've created a Data Warehouse Report with weekly data granularity. The results are:

Week	Visits
Week 0, 2018	14907
Week 1, 2018	19800
Week 2, 2018	17356
Week 3, 2018	15220
Week 4, 2018	14699

I have 3 questions:

1. What is the first day of the week for Adobe Analytics?

2. How are weeks spanning across 2 years numbered? Illustration: 31 Dec 2016 was a Saturday and the next day, Sunday 1 Jan was in 2017 but should have the same week number (assuming that Monday is the first day of the week)

3. There is a standard to approach to this topic: ISO weeks (ISO week date - Wikipedia ) - is Adobe Analytics taking it?

Cheers,

Karol

[Ishan_Sinha_ · Accepted solution]

Hi karolk31579512​,

Can you please check if the report suite has a customized calendar?

Customize Calendar

Thank you.

[karolk31579512]

Hi ishans9314858

We have checked the settings in the "Customize Calendar" and there the weeks are "Mon-Sun". However in reports obtained via the "Data Warehouse " we have "Sun-Sat" weeks. So I'm afraid that the "Correct Answer" star is not yet deserved. Can you please verify if this is the way it's meant to be?

Cheers,

Karol

[danieleb4933226]

Hi all,

are there any updates about this?

---

3. There is a standard to approach to this topic: ISO weeks (ISO week date - Wikipedia ) - is Adobe Analytics taking it?

---

I would like to use the iso week date as dimension within Workspace.

Thanks,

Daniele