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
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
MVP
MichaelWon
MVP

Likes

434 likes

Total Posts

91 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
MichaelWon
MVP

Likes

434 likes

Total Posts

91 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
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

Avatar

Avatar
Boost 1
Level 1
Anders_Jasper_D
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Applaud 5
Applaud 50
Applaud 25
View profile

Avatar
Boost 1
Level 1
Anders_Jasper_D
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Applaud 5
Applaud 50
Applaud 25
View profile
Anders_Jasper_D
Level 1

12-03-2017

This was changed to 'In progress' over a year ago ?

 

I have a very hard time defending internally that this is not information out of the box in Adobe Analytics.

 

There need to be improvements in this area very soon. This has been part of other Web Analytics solutions for more than 5 years.

Avatar

Avatar
Validate 1
Level 2
Jeremy_Brugger
Level 2

Likes

5 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
Jeremy_Brugger
Level 2

Likes

5 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
Jeremy_Brugger
Level 2

12-03-2017

@Delfs, Firstly, I agree there are many aspects of Workspace that need to catch up to the times.

 

As for your specific need, our team has found a clumsy 'work-around':

- Row dimension: Hour

- Column Dimensions: Visits (or any metric) with Time sub-dimensions (eg; Today, Yesterday, Today-7)

 

                                                                               Visits

Hour                                            Today       |   Yesterday        |    Today-7

00:00 2017-03-13

01:00 2017-03-13

02:00 2017-03-13

03:00 2017-03-13

...

 

 

The row titles are a bit misleading since they have the date in it, but if you look in the data columns you'll see it notes the applicable date timestamp for Today/Yesterday/Yesterday-7.

 

Hopefully this is helpful.

 

Jeremy

Avatar

Avatar
Boost 1
Level 1
Anders_Jasper_D
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Applaud 5
Applaud 50
Applaud 25
View profile

Avatar
Boost 1
Level 1
Anders_Jasper_D
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Applaud 5
Applaud 50
Applaud 25
View profile
Anders_Jasper_D
Level 1

12-03-2017

@jer

 

Thank you for taking your time to describe your "Clumsy" work-around. 

It can probably buy me some time as the task at hand can be solved using this.

 

However customers subscribing to a solution with this level of ambitions should not have to use clumsy work-arounds for basic hour of day flow analytics, day of week etc.

 

Again thank you for responding so fast to my request. Lets keep the communitive alive

Avatar

Avatar
Validate 1
Level 1
thomask32386125
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
thomask32386125
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Applaud 5
View profile
thomask32386125
Level 1

04-05-2017

Is / Has this been worked on?

 

I'm reading the notes here to get caught up. My company works through watching sales by "Hour" for key volume dates YoY.

 

I would love a feature within the Custom Date Range functionality that could be part of the Current (Day / Week / Month / Quarter / Year) which include "Hour" to key off of.

 

In numerous times I've built reporting off of custom Excel lookups to be able to key off "through" Same Hour YoY.

 

If this was a standard out of the box feature to do Rolling "Hour" Current Date - 365 it would be the perfect solution to being able to true up aggregate sales YoY by Hour for deadline periods and not back my way into it through Excel.

 

Thanks!

 

Tom

Avatar

Avatar
Boost 5
Level 3
samsnarr
Level 3

Likes

33 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
samsnarr
Level 3

Likes

33 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
samsnarr
Level 3

17-05-2017

How about a way to create a custom classification on the date/time dimensions? We could just make them what we want instead of requiring Adobe to provide what works best for most. Just thinking of another way to provide a solution to this issue.