Time Based Dimension (Travel Industry)

Avatar

Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile

Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
Level 6

03-04-2019

Hi There,

Working in the travel sector we (and many of your clients) have 3 keys dates, which are:

Booking Date (This is standard date in Adobe Analytics).

Checkin Date (The date of the start of a Car Rental / Hotel Stay / Flight / Holiday / Cruise etc)

Checkout Date(The date of the end of a Car Rental / Hotel Stay / Flight / Holiday / Cruise etc)

which creates 2 key metrics for the business

Lead Times (The date difference between Booking Date and Checkin Date)

Duration (The date difference between Checkin and Checkout)

Currently we (and all of the people in our industry) capture Checkin and Checkout using evars. We export this data into SQL and Qlik / Tableau when we want to manipulate it however this is not ideal. Whilst we can easily capture the metrics as events using our data layer it creates an issue where if a customer places 2 bookings in 1 visit or refreshes the metric does not work (both are common).

If Adobe allowed an evar that used Unix time format to allow it would be a huge benefit to us as it would us to keep our analysis inside of Adobe.

Thanks

1 Comment

Avatar

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

339 likes

Total Posts

2,331 posts

Correct reply

819 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

339 likes

Total Posts

2,331 posts

Correct reply

819 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived