Sherlock

The Tenure of a user or an account is an essential data point when assessing product engagement.

Tenure is the answer to the question: How long has this user/account been with us?

In Sherlock, Tenure is a trait we hold dear. On any user or account detail page, you can view Tenure, but more importantly, Tenure is a trait you can use to segment your users/accounts.

We use the standard <code>created_at</code> trait (using iso8601 format) to calculate Tenure. This is a trait you can pass at the user as well as at the account level (using <a href="https://segment.com/docs/spec/group/" rel="nofollow noopener noreferrer" target="_blank">Segment's Group call</a>). The calculation is pretty simple:

For user tenure, we simply subtract the <code>created_at</code> date from TODAY.

For account tenure, we look first for a <code>created_at</code> trait on the Group-level. If one does not exist, we look for the <code>created_at</code> trait for the users on that account and subtract the earliest data from TODAY. This calculation takes a bit longer, so using <code>created_at</code> at the Group level is definitely recommended.

- For user tenure, we simply subtract the <code>created_at</code> date from TODAY.
- For account tenure, we look first for a <code>created_at</code> trait on the Group-level. If one does not exist, we look for the <code>created_at</code> trait for the users on that account and subtract the earliest data from TODAY. This calculation takes a bit longer, so using <code>created_at</code> at the Group level is definitely recommended.

If you are not using the created_at trait for users or accounts, we will not be able to calculate Tenure in Sherlock :/

What is Tenure and how is it calculated?

How does Sherlock calculate Tenure?

If you are not using the created_at trait for users or accounts, we will not be able to calculate Tenure in Sherlock :/