Create a proper Hour dimension for Web (Native already has it)

MichaelWon

MVP

14-11-2016

I posted this already, just bringing it back to the top!  Apologies for not following the rules.

We currently have both web and native implementations going to the same report suite.  Web has an "Hour" dimension that takes the following format (10:00 2016-11-13), Native has an "Hour of Day" dimension that takes the following format (23).

For me, the native dimension is preferred because that allows me to compare dates based on the time of day.  The we dimension is limiting because it is tied to a date so you cannot compare metrics.

25 Comments (25 New)
25 Comments

A_Wathen

MVP

14-11-2016

I totally agree with this.  We've paid for a VISTA rule to allow us to create a dimension that enables us to do this.

 

It definitely feels like this is funcationality that should come straight out of the box.

mubarakd5726232

14-11-2016

Similar for 'Month' . Adobe has added Month dimension meaning customers do not have to implement/capture however this captures  the month AND year .. which reduces functionality

 

eg.

1. As with above example I can't have 'Month' as the breakdown dimension and then use the 'new' compare time periods functionality to compare month traffic YOY .. this concept would apply to other Date dimensions offered out of the box.

2. Creating segments .. we capture hour of day, day of week in addition to Adobe dimensions which allows for creating segments too (as well as comparisons similar to above example) eg. visits duing hours 8 or 9 .. or visitors during weekend etc.  But would make sense if this functionality was offered 'out of the box' or without the need to duplicate recording.

 

Whilst it 'may' be necessary for Adobe to capre the time/date metrics as they do, so my slightly alternative suggestion would be they classify and make appropriate classifications available 😉

MichaelWon

MVP

15-11-2016

Can you add Hour of Day (00, 01, 02, 03, 04, etc) as a dimension in Analysis Workspace (and other tools) ASAP?  Right now all you have is 'Hour' which is bound to a date.  this makes it very difficult to compare day over day by hour.

Jeremy_Brugger

15-11-2016

@benjamingaines

jakewinterbb

15-11-2016

We want to add rolling date ranges in segments; there are a ton of great use cases that would be solved by this. Either way, we'll keep an eye on this idea for votes and comments and make sure we're solving your need as we go. 

 

^^^^^^^^^^^^^^^^^^^^^^^^

THAT! Please!!!

benjamingaines2

15-11-2016

These are all great points. Some thoughts:

 

1. For comparing hours of day across days, there's currently a bug (or perhaps bad design) related to the existence of the date in the rows when showing hour (as you pointed out). The result is that you can't really compare a single hour across days. That should be fixed in an upcoming release. 

 

2. Good point about 25 items in a graph. I'll send this over to our engineering team to review and hopefully get that increased.

 

3. This might be coming soon. We want to add rolling date ranges in segments; there are a ton of great use cases that would be solved by this. Either way, we'll keep an eye on this idea for votes and comments and make sure we're solving your need as we go. 

MichaelWon

MVP

15-11-2016

also - it would be nice to be able to a comparison of 'hour to date'  So if I am comparing today vs. yesterday i would have the ability to apply a segment to yesterday that matches the data available for today.

 

Example:

Current Date Time: 9/23/15 10am

Current Orders per Visit:: 6%

Yesterday Orders per Visit: 2%

Yesterday Orders per Visit through 10am: 7%

 

Being able to compare current conversion rates by time of day would be super helpful and cause people to pay attention in realtime vs. having to wait a day. (we can obvisouly visualize in other ways but it would be nice to have something out of the box)

 

again - apologies if this already exists.

psvlin

15-11-2016

@benjamingaines When can we expect this to be released?

MichaelWon

MVP

15-11-2016

First of All - Analysis Workspace is terrific!! Keep up the good work!

 

I am having a hard time finding how to compare two time periods by hour of day.  I see there is an 'hour' dimension.  However, this dimension includes the date.  This makes it hard to compare two diffrent time periods (i.e. Today vs. Yesterday by hour of day).  We are making marketing decisions in real time so it would be nice to have this capability.

 

Related, the charts in anlaysis workspace limit you to 20 line items.  I undestand the need to limit, but in the case where I would want to compare hour of day i would need at 24.  Can we bump the limit up to 25 : )

psvlin

15-11-2016

@benjamingaines awesome! This will add a lot more value to Workspace!