Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED

How to interpret Date range Minute from Datawarehouse export

Avatar

Level 3

Hi,

since last week a new UI is available for datawerhouse export in Adobe Analytics.

In this one now you can export the minute:

robinl39529461_0-1696312955579.png

 

I tried an it works but not sure how to interpret this field: how can I make it easier to read:

robinl39529461_1-1696313043365.png

 

I have to share it with some users and they expect to see it like in the workspace:

robinl39529461_0-1696313334883.png

Maybe not exactly the same way but something readable.

Any suggestion?

 

Thanks

 

Robin


 

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 3

Thanks Jennifer,

I just received this as reply from Adobe support.

A bit surprised by the logic with:

- leading the figures with 1 ...

- counting month from 0 in place of 1
But at least we have the explanation.

 

Hey Robin,

 

I did a test on my end by requesting a Data warehouse export with Month as dimension and Visit as Metric dated Oct,1.

 

Workspace:

 

robinl39529461_0-1696407335868.png

 

 

 

Export:

 

robinl39529461_1-1696407335870.png

 

So, the minute exports in the following format: 1YYMMDDHHMM 

 

where Month ranges from 0 to 11, 0- Jan, 1 - Feb ----- 11 - Dec

 

Moreover, I validated the syntax with the help of API.

 

API:

 

1st Oct, 23:34 comes up as 12309012334 (1YYMMDDHHMM) in the DW export.

 

 

robinl39529461_2-1696407335871.png

 

 

Similarly, 29th Sept, 11:16 comes up as 12308291116 (1YYMMDDHHMM) in the DW export.

 

robinl39529461_3-1696407335872.png

 

 

I hope this helps!

View solution in original post

4 Replies

Avatar

Community Advisor

It looks like the Minute Data is exported as a timestamp epoch; but when I try to convert that to a readable date, its 336 years in the future.....

 

Honestly, that information looks very strange to me too... 

 

I am going to check with one of my contacts who handles a lot of the Adobe documentation and see if there are some resources in the works.

 

Avatar

Correct answer by
Level 3

Thanks Jennifer,

I just received this as reply from Adobe support.

A bit surprised by the logic with:

- leading the figures with 1 ...

- counting month from 0 in place of 1
But at least we have the explanation.

 

Hey Robin,

 

I did a test on my end by requesting a Data warehouse export with Month as dimension and Visit as Metric dated Oct,1.

 

Workspace:

 

robinl39529461_0-1696407335868.png

 

 

 

Export:

 

robinl39529461_1-1696407335870.png

 

So, the minute exports in the following format: 1YYMMDDHHMM 

 

where Month ranges from 0 to 11, 0- Jan, 1 - Feb ----- 11 - Dec

 

Moreover, I validated the syntax with the help of API.

 

API:

 

1st Oct, 23:34 comes up as 12309012334 (1YYMMDDHHMM) in the DW export.

 

 

robinl39529461_2-1696407335871.png

 

 

Similarly, 29th Sept, 11:16 comes up as 12308291116 (1YYMMDDHHMM) in the DW export.

 

robinl39529461_3-1696407335872.png

 

 

I hope this helps!

Avatar

Community Advisor

Wow... given that, you would think that should be documented

 

That is helpful though, thank you for sharing your Client Care response! I hope it will help others.

Avatar

Level 1

Had a similar question and was getting Date Range Day values of 1240601 thru 1240631 for a Jul 2024 day-granular dump. The 06 really threw me for a loop but knowing it increments from zero is key even if it's completely not intuitive.