Days before first purchase from registration date | Community
Skip to main content
June 19, 2020
Solved

Days before first purchase from registration date

  • June 19, 2020
  • 2 replies
  • 1733 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by David_Jerome

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

2 replies

Level 4
June 22, 2020
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.
David_Jerome
David_JeromeAccepted solution
Level 6
June 26, 2020

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