Number of days since "Last Seen"

[PierreA]

Hello,

I'm looking for a custom property that would calculate the number of days between last contact was seen (last visit) and today please.

EG : last seen on April 1st 2020, if today is April 15 2020 => answer=15.

This is not linked to last marketing activity but last time contact was seen.

Thanks a lot 🙂

[DStaat]

Hey @PierreA and @Josh,

Have you heard of Tick Tock Today? It's an app that creates a today's date property for your objects. It's available on the HubSpot Marketplace.

You could use this property to create a time between property using today's date and the contact's last seen date. There's a blog post going over how to to that here.

 
If you have any questions, feel free to reach out. I'd be happy to hop on a call with you!

Best,

-David Staat

[Josh · Accepted solution]

Hi @PierreA,

You'll have to create a calculated property to calculate "Time Between". There is already a property called "Time Last Seen" which is a date property, but you will need to create a custom property for "Today's Date".

• Here's an article on how to create a Today's Date timestamp. 
• Here's an article on calculated properties.

After these properties are created you can use the calculated property for reports, workflows, or just to see the number of days since a contact was last on the website.

I hope this helps!

Josh