Expand my Community achievements bar.

SOLVED

Days before first purchase from registration date

Avatar

Level 1

Hi,

I'm looking to implement a rule in adobe launch similar to the Days before first purchase with a slight modification. I want to know the Days before first purchase from the date of registration.

 

Any insights will be really helpful.

Thanks!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 8

There may be better ways to do this but my approach would be to get a FIXED registration date (using Unix Timestamp) added to your data layer, which is available on all visits post registration, such as:

 

registrationTime = 1593172370551

 

You could set this in Launch, but personally I would use the data layer for reliability.

 

Then when a customer makes a purchase, create a "date difference" value in Launch between (Date.now() - registrationTime), which you can convert to Hours / Days / Weeks etc and set this as an EVENT / EVAR. Depending on your business need, you may want to get exact numbers (average 1.44 days) or rounded for graphing in EVARS.

 

I hope this helps.

 

Dave

View solution in original post

2 Replies

Avatar

Level 4
Do you have access to Adobe data feeds? If so you could query this by referencing the registration event and the last_purchase_num column.

Avatar

Correct answer by
Level 8

There may be better ways to do this but my approach would be to get a FIXED registration date (using Unix Timestamp) added to your data layer, which is available on all visits post registration, such as:

 

registrationTime = 1593172370551

 

You could set this in Launch, but personally I would use the data layer for reliability.

 

Then when a customer makes a purchase, create a "date difference" value in Launch between (Date.now() - registrationTime), which you can convert to Hours / Days / Weeks etc and set this as an EVENT / EVAR. Depending on your business need, you may want to get exact numbers (average 1.44 days) or rounded for graphing in EVARS.

 

I hope this helps.

 

Dave