Weekly data in Data Warehouse Report

Avatar

Avatar
Validate 1
Level 1
karolk31579512
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
karolk31579512
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
karolk31579512
Level 1

18-02-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

155 likes

Total Posts

330 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

155 likes

Total Posts

330 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
ishans52004352
Employee

18-02-2019

Hi karolk31579512​,

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

Customize Calendar

Thank you.

Answers (2)

Answers (2)

Avatar

Avatar
Level 1
danieleb4933226
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
danieleb4933226
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
danieleb4933226
Level 1

27-10-2020

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

Avatar

Avatar
Validate 1
Level 1
karolk31579512
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
karolk31579512
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
karolk31579512
Level 1

28-02-2019

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