Expand my Community achievements bar.

SOLVED

A Date In a Profile Dataset Within X amount of Days of An Event Time Stamp

Avatar

Level 2

Context: we have a set of users who may or may not have registered for a portal. The profile attribute that tracks this registration is called Registered. When registered is equal to True, it means the user has registered, and when it is False it indicates that the user has not registered.

 

Here are 2 attributes of interest:

 

  • Registered attribute change date: The date the register profile attribute changed from False to True. This field is of type Date Time and is found in a custom profile schema in AJO. Note, this date time attribute is found in a profile schema in AJO, not an event schema.
  • Feedback Status: Status of the email send event; will be of type string from AJO Message Feedback Event Schema in AJO, and the values can be: sent, bounce, etc.

The KPI we are tracking is as follows:

 

The subset of users whose Registered attribute change date is with in 5 days of the email send timestamp, 10 days of the email send timestamp, and 15 days of the email send timestamp, within a month of the email send timestamp, etc. 

 

Any Ideas on how to orient this KPI?

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hey @jm_11 It seems the question more related to AJO/Experience Platform. You can try posting this query in AJO community or Experience Platform

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

Hey @jm_11 It seems the question more related to AJO/Experience Platform. You can try posting this query in AJO community or Experience Platform