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
Seeker
Level 5
David-123
Level 5

Likes

114 likes

Total Posts

132 posts

Correct Reply

18 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Springboard
Establish
View profile

Avatar
Seeker
Level 5
David-123
Level 5

Likes

114 likes

Total Posts

132 posts

Correct Reply

18 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Springboard
Establish
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
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

337 likes

Total Posts

2,286 posts

Correct Reply

815 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

337 likes

Total Posts

2,286 posts

Correct Reply

815 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