topic Re: Being able to highlight if any Deal activity hasn't happened in the last x days/weeks in Dashboards & Reporting

Being able to highlight if any Deal activity hasn't happened in the last x days/weeks

andrew_carroll — Thu, 08 Aug 2019 06:33:39 GMT

I want to report any Contacts/Deals that haven't had an activity in the last x days/weeks.

eg: Last Activity Date IS NOT 14 days

At the moment you can only select "IS" or a specific date which means you manually have to update the report every week.

Re: Being able to highlight if any Deal activity hasn't happened in the last x days/weeks

adeelfaisal — Thu, 08 Aug 2019 12:53:35 GMT

Hey @andrew_carroll

In my understanding, contact and deal filters have this limitation but if you are using Sales Hub Professional you can create a custom property and use workflows to change that property as workflows have the filters of activity not happened in last x days that you are looking for.

Do let me know if it helps.

Re: Being able to highlight if any Deal activity hasn't happened in the last x days/weeks

MikeLawson — Thu, 08 Aug 2019 19:06:13 GMT

@adeelfaisal great suggestion. I would do it this same way.

Re: Being able to highlight if any Deal activity hasn't happened in the last x days/weeks

andrew_carroll — Thu, 08 Aug 2019 23:13:50 GMT

Thanks very much @adeelfaisal !

This would work for an individual managing their Contacts/Deals however I am looking to develop a Management report that could identify slippages.

This report would be used as part of 1:1 with Sales team members.

It would be great to know if you still think it could work. Given you can choose IS and IS NOT for a contact owner filter, I would have thought it wouldn't be too hard to add an IS NOT for a date field like Last Activity Date.

Thanks again! AC

Re: Being able to highlight if any Deal activity hasn't happened in the last x days/weeks

andrew_carroll — Thu, 08 Aug 2019 23:15:08 GMT

Thanks too @MikeLawson .

As per my response to @adeelfaisal ....this would work for an individual managing their Contacts/Deals however I am looking to develop a Management report that could identify slippages.

This report would be used as part of 1:1 with Sales team members.

Thanks again! AC

Re: Being able to highlight if any Deal activity hasn't happened in the last x days/weeks

MikeLawson — Mon, 12 Aug 2019 11:41:40 GMT

@andrew_carroll

ahh I see what you are saying. I tried to reproduce this in hubspot but haven't been able to get it working yet.

I will tell you that I work for a company, Rekener, that creates scorecards based off hubspot data designed to help managers coach better in their 1 on 1s. Hubspot actually just put us in one of their blogs.

I have built this type of report for some of our other customers, happy to talk through it more if this is a huge pain point for you guys.

Best,

Mike

Re: Being able to highlight if any Deal activity hasn't happened in the last x days/weeks

llawrence0906 — Sat, 29 Aug 2020 23:37:36 GMT

@adeelfaisal , is there any chance you could explain this more? I'm still a little green with hubspot, and I'm trying to figure out which of my customers I haven't seen for over 7 days. Thanks!

Re: Being able to highlight if any Deal activity hasn't happened in the last x days/weeks

James-Preseem — Thu, 29 Oct 2020 14:00:59 GMT

Adellfaisal,

I have the same issue listed above but with tickets. The issue with the tickets and this solution is having the ticket re-enroll in the workflow. A ticket with no activity will not re-enroll in the workflow unless it has some sort of activity. Therefore there is no way to run the workflow that will change the property necessary to highlight the inactivity.

Ultimately having a contra to the "IS" filter i.e. "Is Not" coupled with the ability to define a specified number of specified intervals.... is not 5 days or "is not 12 hours" or is not 2 weeks would be beneficial, but not currently acheivable with either reports, dashboards, or workflows from my conversations with or friends at Hubspot.

James