Bookings Modified Online (Travel Industry)

[David_Jerome]

Hi There,

I work for a car rental company and we allow for bookings to be amended online. Currently we actually have a way of splitting out if an transactionID is "New" or "Modified" and in an evar. Before I spec this in to our development team I am keen to know from either someone in the travel sector if they have successfully implemented this solution or an Adobe expert if Adobe can handle negative units? I know it can handle negative revenue but need to check units.

My goal is the following:

Customer journey scenario

1) Customers Places Initial Booking

Reservation Number: ABC123

Group A Car - Price EUR 100

Insurance - Price EUR 20

2) Customer Returns and Modifies Booking (ABC123)

Changes the Car to a Group B Car (120 EUR) which in turn increases the insurance to EUR 22

Would the following work?

1) Places Initial Booking

TransactionID = ABC123|0

Product: Group A Car | 1 Unit | EUR 100

Product: Insurance | 1 Unit | EUR 20

EVARX: New Booking

2) Returns and Modifies booking (ABC123)

TransactionID = ABC123|1

Product: Group A Car | -1 Unit | EUR -100

Product: Insurance | -1 Unit | EUR -20

Product: Group B Car | 1 Unit | EUR 120

Product: Insurance | 1 Unit | EUR 22

EVARX: Modified Booking

Looking at the 2 Reservations we would see:

EUR 120 in car revenue

EUR 22  in insurance revenue

Whilst we would also be able to see the upsell revenue with the EVAR applied to show:

EUR 20 in car revenue

EUR 2 in insurance revenue

Long story short - has anybody used negative units in Adobe Analytics?

If so, then this solution should work for modified reservations.

Thanks

David

[ashokkumarm · Accepted solution]

Hi David,

Store Purchase count in One Event and Store Return count in another Event for same product.

Action1: User1 purchase a Car means Purchase count will increase by 1.

Action2: User2 purchase a Car means Purchase count will increase by 1.

Action3: User1 return a Car means Return count will increase by 1.

Now we need to add calculated metric for Actual Purchase count, ie, Actual Purchase Count = Purchase Count - Return Count

For Modification Cost,

Action1: (Buy for 100) User1 purchase a Car means Purchase amount will increase by 100.

Action2: (Buy for 100) User2 purchase a Car means Purchase amount  will increase by 100.

Action3: (Modify 100 to 120) User1 modify a Car means Return amount will increase by 100 and Purchase amount will increase by 120. (need to trigger both events)

Now we need to add calculated metric for Actual Purchase amount, ie, Actual Purchase amount = Purchase amount - Return amount

Hope you got the answer.

Regards

Ashok