We use cookies to make HubSpot's community a better place. Cookies help to provide a more personalized experience and relevant advertising for you, and web analytics for us. To learn more, and to see a full list of cookies we use, check out our Cookie Policy (baked goods not included).

Allow cookies

View Deal and Contact Properties in One Report

: Delivered
fsta
Submitted by fsta on ‎02-16-2017 12:27

We require the ability view/export one report or list that combines properties from both contacts and deals.  I'm confused as to how this basic functionality is not currently available.

 

Currently, we have to export our contacts and deals separately and then combine them in Excel.  However, there is no unique key to utilize when performing the join. The deal export only provides the "Associated With" field.  This is in a different format from the Contact properties (First Name, Last Name, Company).  Additionally, we have many contacts that have the same name (ie - John Smith), which is very problematic when using this work-around.  

 

See more ideas labeled with:
HubSpot updates
7 Replies
wasifkasim
wasifkasim
New Contributor
‎05-14-2017 05:56

100% agree. The ability to add contact properties to deals would signficantly help ROI reporting.

 

Hubspot relies heavily on "sources" for ROI reporting, but for more complex business with multiple integrations, this is quite inaccurate (as most pop up in offline sources - eg: zapier, unbounce & other integrations).

 

If we were able to add "lead source" to deals - this would signficantly help the problem and provide clear articulation on which channels are working and which aren't.

 

Currently I'm considering:

1) Moving away from Hubspot CRM to SalesForce (which will only raise questions on using SF for marketing as well) - to be able to do this

2) Using Domo/DataHero or other tools to do this - which are quite complicated as well for the average marketer (I tried! And I need some consulting help for this avenue as well)

 

So yeah, if HS can fix this - it'd be of massive value

 

JasonTisdall
JasonTisdall
Occasional Contributor
‎08-29-2017 05:13

Agree. The contact/deal integration is a weak spot in Hubspot that crops up in many different ways.

nmason
nmason
Occasional Contributor
‎09-08-2017 02:34

I agree with this but there also should be data that is shared between deals and companies. Industry, for example, is a company property, so you can't see or report on your deals by industry.

chasem
chasem
New Contributor
‎02-20-2018 08:39

Yes - this is an ongoing issue for us as well.   I'm sure a very common complaint.   I figure not an easy fix for hubspot, but the community really needs this. 

 

thanks

 

paju
paju
Occasional Contributor
‎06-12-2018 03:25

Agreed.  Need to be able to associate revenue with marketing activities to justify paying for Hubspot!

Giordan
Giordan
New Contributor
‎08-23-2018 04:17

Upvote on this one for sure!

meagmccann
HubSpot Moderator
HubSpot Moderator
‎09-28-2018 05:45
updated to: Delivered

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 contact 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!