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

Time Based Dimension (Travel Industry)

Avatar

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile
David-123
Level 5

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
Springboard
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

329 likes

Total Posts

2,247 posts

Correct Reply

811 solutions
Top badges earned
Springboard
Validate 500
Validate 250
Validate 100
Validate 50
View profile

Avatar
Springboard
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

329 likes

Total Posts

2,247 posts

Correct Reply

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

27-10-2020

 
Status changed to: Archived