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

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!

Find more posts tagged with

Retention

Govern

Derived Properties

Accepted answers

Esther Trapadoux

Thanks Saish Redkar! Always a wealth of knowledge. 😊

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

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.

iOS SDK: https://developers.amplitude.com/docs/ios#setting-a-user-property
Android SDK: https://developers.amplitude.com/docs/android#set-user-properties

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

All comments

Saish Redkar

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.

Esther Trapadoux

Thanks Saish Redkar! Always a wealth of knowledge. 😊

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

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.

iOS SDK: https://developers.amplitude.com/docs/ios#setting-a-user-property
Android SDK: https://developers.amplitude.com/docs/android#set-user-properties

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

Esha

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

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

Quick Links

Unanswered Questions

Anonymous Users to Auth User in Sign Up/Sign In
We're losing user journey tracking when anonymous users switch devices during our sign-up flow. Our typical flow: anonymous user visits homepage on desktop → clicks Sign Up → redirects to Auth0 for registration → user verifies email on mobile (creating a new anonymous user ID) → returns to desktop to complete sign-up and…
Bug: 'Mark all as read' in Alerts not working
Clicking ‘Mark all 7 as read’ is not doing anything to clear my alerts MacBook Air 14-inch M4 macOS: 15.5 Browser: Chrome Version 136.0.7103.114
production houses in islamabad
Reality Beyond Dreams is a team of impact producers. At the heart of every film we produce, and every campaign that we design, are the core principles of Social Impact Entertainment. We are dedicated to creating cinematic projects that promote https://realitybeyonddreams.com/
Best Practices for Switching Amplitude Projects in a Multi-Country Mobile App (Post-Country Selection)
Hi everyone, I’m working on adding Amplitude to a single mobile application serving multiple countries. Inside the app, users are shown a country selector panel (e.g., Egypt, Turkey, UAE, etc.), which determines the localized experience they will receive — each country has its own UX flow and logic. The client wants…
unable to set user property
I have installed Amplitude via Google Tag Manager and looks like the user ID is not being set. I have installed 2 tag from GTM. * Tag type as init * Tag type as setUserId Still say Anonymous user