Expand my Community achievements bar.

SOLVED

Weekly data in Data Warehouse Report

Avatar

Level 1

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

  

WeekVisits
Week 0, 201814907
Week 1, 201819800
Week 2, 201817356
Week 3, 201815220
Week 4, 201814699

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

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi karolk31579512​,

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

Customize Calendar

Thank you.

View solution in original post

3 Replies

Avatar

Correct answer by
Employee Advisor

Hi karolk31579512​,

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

Customize Calendar

Thank you.

Avatar

Level 1

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

Avatar

Level 1

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