Number of days since "Last Seen"

SOLVE
PierreA
Participant

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 🙂

0 Upvotes
1 Accepted solution

Accepted Solutions
Josh
Solution
Recognized Expert | Platinum Partner

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".

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




Did this post help solve your problem? If so, please mark it as a solution.

Josh Curcio

HubSpot support and inbound marketing for OEMs, contract manufacturers, and industrial suppliers.
HubSpot Platinum Partner & HubSpot Certified Trainer

View solution in original post

1 Reply 1
Josh
Solution
Recognized Expert | Platinum Partner

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".

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




Did this post help solve your problem? If so, please mark it as a solution.

Josh Curcio

HubSpot support and inbound marketing for OEMs, contract manufacturers, and industrial suppliers.
HubSpot Platinum Partner & HubSpot Certified Trainer

View solution in original post