Time Based Dimension (Travel Industry)

Avatar

Avatar

David-123

Avatar

David-123

David-123

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 (1 New)
1 Comment

Avatar

Avatar

jantzen_belliston-Adobe

Community Manager

Total Posts

1.9K

Likes

312

Correct Answer

570

Avatar

jantzen_belliston-Adobe

Community Manager

Total Posts

1.9K

Likes

312

Correct Answer

570
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived