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!

Add date and time dimensions in Data Warehouse reports

Avatar

Level 1

3/9/23

Description - Add date and time dimensions in Data Warehouse reports

Why is this feature important to you - Because most of the exported reports related to user interactions within digital channels, or even data from Adobe Target generally need a Date and Time for data analysis to be more complete.

How would you like the feature to work - Date and Time dimensions appear in the "Items" > "Breakdowns" > "Standard" section to add to reports.

Current Behaviour - These dimensions don't exist.

3 Comments

Avatar

Level 3

3/21/23

Right now we can get down the most is by 'hourly'. Yes, if we have date and time in the breakdown that would help some of the analysis reports.

Avatar

Community Advisor

3/27/23

Since you are doing a CSV export... I know this isn't ideal, but you could always track a timestamp into an eVar... while this will be text in Worksace, once it's exported to CSV you could process the value as a time stamp?

 

At least until (or if) this idea is considered...

 

Raw Data Feeds DO already contain the timestamp data, but you do have to do a lot processing to ensure that excluded hits and other rules are run to match the data you pull in Adobe...