How to interpret Date range Minute from Datawarehouse export | Community
Skip to main content
R
robinl39529461
Level 3
October 3, 2023
Solved

How to interpret Date range Minute from Datawarehouse export

  • October 3, 2023
  • 1 reply
  • 2969 views

Hi,

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

In this one now you can export the minute:

 

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

 

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

Maybe not exactly the same way but something readable.

Any suggestion?

 

Thanks

 

Robin


 

 

Best answer by robinl39529461

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:

 

 

 

 

Export:

 

 

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.

 

 

 

 

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

 

 

 

I hope this helps!

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 3, 2023

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.

 

    R
    robinl39529461AuthorAccepted solution
    Level 3
    October 4, 2023

    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:

     

     

     

     

    Export:

     

     

    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.

     

     

     

     

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

     

     

     

    I hope this helps!

      Jennifer_Dungan
      Community Advisor and Adobe Champion
      Jennifer_DunganCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      October 4, 2023

      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.

      Terms & ConditionsAccessibility statement

      Loading footer...