Skip to main content
Solved

Trying to use Derived Properties to chart stickiness - first 14 days of usage since sign up

E
Helpful Hero
Forum|alt.badge.img
  • Esha
  • Helpful Hero
  • 8 replies

Our goal is to understand users' engagement in the first 14 days since sign up (see day per day event usage) through a stickiness chart. We were trying to use a derived property to calculate this date range based on today's date and user's sign up date but we haven't been successful. Any idea on how we can achieve this? Thanks!

Best answer by Esther Trapadoux

Thanks @Saish Redkar! Always a wealth of knowledge. 😊

Hey @Esha, definitely try that out and these steps below might also help:

  1. The account creation date can be sent as a user property. Looking at your project, I can see that you are using our iOS SDK and Android SDK. You can take a look at our documentation below for user property setup.

 

2. The account creation date can be formatted as an Epoch value or a string (YYYY-MM-DD HH:MM:SS). To segment users by the account creation date, you might want to apply operators: "greater or equal", "less or equal", "less" or "greater". For example, account_creation_date is greater than "2022-03-01".
 

Our Demo has a similar user property which is "trial_start_time". 

  • Apply filters in a chart

?name=Screenshot+2022-03-15+at+2.32.10+PM.png

  • Create a cohort in the Cohort tab

?name=Screenshot+2022-03-15+at+2.33.33+PM.png

View original
Did this topic help you find an answer to your question?

4 replies

Saish Redkar
Expert
Forum|alt.badge.img+10

Hi @Esha 

They have a formula documented for calculating a user’s age in here. You could try applying a similar logic using a user’s sign up date.

Saish | Connect with me on topmate.io/saish_redkar for supercharging your Amplitude skills
Esther Trapadoux
1 person likes this
  • Esther Trapadoux
    Esther Trapadoux
Esther Trapadoux
Community Manager
Forum|alt.badge.img+9

Thanks @Saish Redkar! Always a wealth of knowledge. 😊

Hey @Esha, definitely try that out and these steps below might also help:

  1. The account creation date can be sent as a user property. Looking at your project, I can see that you are using our iOS SDK and Android SDK. You can take a look at our documentation below for user property setup.

 

2. The account creation date can be formatted as an Epoch value or a string (YYYY-MM-DD HH:MM:SS). To segment users by the account creation date, you might want to apply operators: "greater or equal", "less or equal", "less" or "greater". For example, account_creation_date is greater than "2022-03-01".
 

Our Demo has a similar user property which is "trial_start_time". 

  • Apply filters in a chart

?name=Screenshot+2022-03-15+at+2.32.10+PM.png

  • Create a cohort in the Cohort tab

?name=Screenshot+2022-03-15+at+2.33.33+PM.png

Community @ Amplitude
E
Helpful Hero
Forum|alt.badge.img
  • Esha
  • Author
  • Helpful Hero
  • 8 replies
  • April 26, 2023

Hey @Esther Trapadoux , thanks so much for your help! Our dates were definitely wrong; we were sending them as utc string instead of an iso string!

Esther Trapadoux
1 person likes this
  • Esther Trapadoux
    Esther Trapadoux
Esther Trapadoux
Community Manager
Forum|alt.badge.img+9

@Esha date time formats are the bane of my existence. 😖

Community @ Amplitude

Reply


Helpful Members this Week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings