Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Weekly data in Data Warehouse Report

karolk31579512
Level 1
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
ishans52004352
Correct answer by
Employee
Employee

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
ishans52004352
Correct answer by
Employee
Employee

Hi karolk31579512​,

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

Customize Calendar

Thank you.

View solution in original post

karolk31579512
Level 1
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

danieleb4933226
Level 1
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