Filter Deals Based on Company Properties

It would be super helpful to have the Company properties carry over to the Deal when it comes to filtering an reporting. For example, if we're running a campaign and I have a property for leads (in the Company status), once those become Deals, there is no way to track that property any longer, outside of exporting mutliple views to Excel and using vlookups.

 

Please consider adding this to the expanding functionality of the CRM!

 

Thanks!

HubSpot updates
Filter Deals Based on Company PropertiesHubSpot Product Team
changed to: In Planning
04-20-2018

Filter Deals Based on Company PropertiesHubSpot Moderator
changed to: Delivered
09-28-2018

At INBOUND 2018, we launched a new Report Builder that includes the ability to build a report across your 2 of your HubSpot datasets (otherwise known as "cross-object reporting"). This enables you to answer questions about your company AND deal data, bringing you even more powerful insights about the data in your HubSpot CRM. 

 

For a quick walkthrough of the new report builder, please check out this article from our knowledge base.

 

This blog post outlines some of the most exciting reporting & analytics updates from INBOUND, as well a number of examples of cross-object reports you can create in HubSpot. 

 

Please do not hesitate to pass along any feedback you have on this new tool!

14 Replies
nmason
Occasional Contributor

We are looking for something similar to this. We'd love to see all our deals by Industry, but the industry is segmented to the company area only. We'd also like to see deals by company lifecycle (SQL, Opportunity, and Customer) but again these are company properties that aren't accessible on Deal reports. 

 

Doesn't seeing all your deals segmented by industry seem like a basic sales tool?

brantcarter
New Member

I agree that without this feature the Hubspot Sales tool is basically useless for evaluating deals (unless you are a very small company and only have a few deals).

 

 

Johannes_LAC
Occasional Contributor

I agree with Matt. I am also puzzled that this cannot be done. We are segmenting at the contact level, but also here you cannot apply filters from contact properties to deals. The workaround ist to basically mirrow all segmenting properties at the contact / Company level by adding the same field at the deal level and then design a workflow which update the deal property/ once a new deal is created. Not pretty and difficult to believe this is the only fix...

 

Johannes_LAC
Occasional Contributor

Sorry. I have to correct my workaround it is not possible to include changing Deal properties in a worflow. You can Contact or company properties but not deal properties... !

FasenMungo
Occasional Contributor

Strongly agree with the request to implement a cross query function over Deals - Companies - Contacts. With the todays tools it is simply not possible to satisfy our needs to filter deals for segments, which are assigned to companies, etc., etc...

SteveO1
New Contributor

 As a new HS user from a competitor that has this, it a needed functionality.  I can recreate the dropdown properties under a deal, but it seems like a big waste of time to create the same dropdowns I created under a company and have to RECREATE them under deals.  Example, we tract prospects under the software platform they use to manage there business and have created ideal customer profiles.  If the prospect has a system we have already build the API for our solution to talk to theirs, it scores higher and if I want to look at deals and filter by systems we do and don't have integration with, I need to be able to easily look at deals and filter them.

Merit
Occasional Contributor

 This is something we feel that Hubspot is missing as well. It seems silly to create several properties (one under contacts, one under companies and one under deals). As an example, we use 'country' field on a company level but due to that we cannot filter deals based on country. 

MattF
Top Contributor

Has there been any update on this or any plans to add to development? I'm at the point where I would need to re-create the same company property and have my reps fill out the same information twice when creating a deal, just to avoid this. Seems unecessary for something that I'd consider basic functionality (ie, crosstab reporting in SFDC)

HubSpot Product Team
HubSpot Product Team
updated to: In Planning
 
MattF
Top Contributor

Yessssss! Thanks guys!