Date-filters: Improve Options Across all of Hubspot [Master Idea]

VagaeNatus

Idea: Make all Date-filters available everywhere they are relevant.

 

Background: 

Hubspot is missing date-filters in multiple places and is not consistent (i.e. different date-filters are available at different places) about them. This issue drastically reduces the power of filters, reports, automation and marketing, etc. Fixing that would be high impact, it's a core platform feature, with impact on all products.

 

There has been 15+ ideas on the forum about missing date-filters for filters, reports, lists, workflows, ... everything. Those ideas were at first aimed to request one date-filter in one place. This master idea aims at grouping all smaller ideas, giviing visibility to this "Date-filters" issue and getting it prioritized as one overall review of "Date-filters" across Hubspot. Because the only solution is for Hubspot to fix Date-filters everywhere, by working just on that.

 

Things currently not possible on Hubspot (i.e. use cases):

1/ Filter contacts with last activity is more than 10 days ago

2/ Filter deals with a close date that is in the past

3/ Build Report on Deals with last activity is more than 30 days ago

I want to give my sales team a filter of contact not contacted since 14 days. I am expecting to go to contact and to save a filter but the Date-filter required to do that is missing.

4/ Build List of Contacts with customer/deal who expire in the next 30 days

5/ Build List of Contacts with deal created last week.

Etc...

 

Research:

I've been comparing all Date-filters and noticed there are 11 types of Date-filters currently available on Hubspot (see screenshot below). The issue is that those Date-filters are randomly available on:

- Contact WF but not Deal WF

- on List but not on Report

- on Dashboard but not Contact Table

Etc. There seems to be no logic and that this is just the results of features coming one after the other while Date-filters never receiving focus as one topic.

 

This feature request is not about creating new Date-filters but only about making all the ones currently existing available everywhere, it is relevant to have them. In a nutshell, that means turning all Red cells below to Green.

 

HS_Jun_2019_-_Dates_Filters_-_Google_Sheets.png

 

Some of the smaller ideas this master idea is grouping under one roof.

2017, Use 'relative' dates for enrolling contacts and companies in workflows by @Daniel1 

2017, Allow the use of relative dates in workflow... by @CCasemore (marked delivered but that's not fully the case)

2017, Filter using relative date values ("TODAY" etc.) by @Frank 

2017, Lead scoring - Add the option to refine... by @laurao93 

2018, Sales workflows deal properties based on dates by @Peter-marketing 

2019, More than filter for report timeframe by @krispag 

...

HubSpot updates
Status updated to: In Planning
Apr 16, 2020

Thanks everyone for the feedback on this review and thanks @VagaeNatus for such a detailed dive into underlying issues of filtering. We are in the process of reworking the "wiring" of our filter system at which point we will be able to solve many of the issues you have outlined. As we roll out improvements I will keep this idea up to date. 

30 Replies
Ruscoe
Member

Wow! This table is amazing. I was trying to figure out how to make company date filters match the contact date filters in a contact-based workflow. I realise I can now just switch to a company-based workflow. 

 

Thanks so much! 

 

(Please Hubspot - fix these inconsistencies!). 

mariuss
Participant

@VagaeNatus thanks for the detailed work.

 

I'd like to also have the "entered stage date" properties exposed, as we seem to inconsistently be able to pull them into segment / Google BigQuery. Some deals are returning null values even though the deal actually has moved through various stages.

 

Having access to this data would be extremely important for cohort-based performance/conversion rate analysis.

 

Best,

M

kreiley
Member

This is definitely needed. Being able to score companies based on date fields being "more than X ago" or "less than X ago" is huge for us.

Hawk-Steve
Top Contributor

+1 from me, lots of positives from this idea.

I'd like to add a use case for number properties within lists.

 

  • Number contains X
  • Number begins with X
  • Number ends with X
  • Number is between X and Y
Jonnydk
Top Contributor

@bkeller thanks for the update. This is very much needed and will save us a lot of time!

erica11
Top Contributor

Keen to see these inconsistencies fixed. Look forward to more updates.

Mark_H
Member

Hubspot Product Team,

It has been 18 months since this was posted and on two occassions you have noted a change coming, fix, or otherwise confirmation that what you have today is broken, outdated, or needs improvement.

 

It would be nice that you update your customers/community on a regular basis with perhaps an actual DATE of which you expect to deliver these promises/expectations.

 

Reporting is one of the low points of this product, and having a better more robust reporting engine and filters is key for managers to monitor performance.

 

Appreciate someone taking some time to respond.

lgil
HubSpot Employee

Hi all!

I think it will be pretty useful as well to be able to filter by a specific day of the week or a specific month; all in lists, workflows, and reports.

asilverman
Member

FIltering is critical for my business and I need an easy way to ensure we are reaching out to contacts more than 1X per day for certain types of communication. 

 

I absolutely need consistent filterning options and the ability to suppress people who were already contacted today in general with marketing emails or against specific emails. 

alester001
Member

This is great - agree this area is so limited in HubSpot.  We moved from Salesforce and love so much in HubSpot although really need to be able to create lists or even views that allow the user to use properties from associated deals, companies or contacts for columns, rather than having to create duplicate properties and write workflows.

Its so simple - If we can create a list using properties from deals, contacts, companies we should be able to also have assess to be shown in the coloumns.  As well as then having the columns set when sharing.

This part of HS is so far behind and taking up sooo much time.