HubSpot Ideas

sgraci

Natively export contact activity history

There should really be a native way to export the contact activity history in bulk to a CSV or excel file similar to other Hubspot fields. This would be a great way to organized and filter the user history for personalized marketing emails and workflows.

14 Replies
SupportTeamDSS
Participant

This is something I was hoping for as well. My "fix" for it for now was to create individual contact properties where I can record the date that the contact went from one deal stage to the next. It's fairly clunky and relies on a lot of rote data entry & relying on people to stay up to date with all of their information. If we could track this and have it listed rather than having the deal stages as a static report showing the current deal stage, that would be very helpful.

johnelmer
Top Contributor | Elite Partner

@SupportTeamDSS @sgraci I've done some research on your request and it looks like this can be done using existing third party tools.

 

Bayard Bradford's HubSpot integration platform, Datawarehouse.io pulls the Deal History data you need to create the reporting you are looking for.  The best way to automate this reporting would be to use our Power BI Connector for HubSpot app and build your report in Power BI.  The deal history data provides the length of time each deal has been in each pipeline stage. The bulk of the work to get this going would be to label, sort, and set up pipelines for all of your pipeline stages because of the how deal history data is structured in HubSpot. 

 

While there is some upfront work involved, the advantage of using the Power BI integration is that your reports will automatically update with current data each time you open and refresh them.  The time savings should be significant.

 

DM me for more information.

 

John

sgraci
Participant

Thank you John, thank you very much for taking the time to research and share this information. I will look into and see if it is something that would work for us.

nat_sch
Member

I don't understand how this is actually not possible.

It is possible on Pipedrive for example.

 

I understand this is a way of keeping people sticky to the tool, but it would actually be quite helpful to be able to export any such activity data, and I don't see how this would be very difficult to set up ?

 

We tried it the developer way like explained here but it takes ages to create an export and is not feasible for non-devs.

FRodriguez
HubSpot Employee

We would be interested in an export option as well.  We are trying to look at our Behavioral Events at a very granular level that is not available in the current reporting tools.  Enabling us to export the Behavioral Event data on the individual contact would enable us to gather the data we need.

Replying on behalf of our customer- Danielle Bonadies

SuperGenius
Member

Seems like a no-brainer.  HubSpot should find a way to do an old HubSpot to New Hubspot export/import of all activity for contacts and companies.  Sometimes businesses change and you want to stick with Hubspot without going to another platform.  If you cant do this, you are starting from scratch and you might as well go with a new platform., i.e:

 

Hubspot if you are listening >>>> this feature can help customers stick with HubSpot.  

Bruno_Teixeira
Key Advisor | Diamond Partner

That would be nice to have.

vjuncoec
Participant

I agree. Besides, sometimes you need to explain to contacts they really did surf on our sites and they filled our forms out. Just right now, a customer is complaning about that, but actually they left us their information. 

FinnJohannsen
Participant

A good way to implement Article 15 of the GDPR (In German: DSGVO) regulation and to cap legal aspects. If there is a demand for this article, the German customers/companies habe quite a problem. An export of activities and collected information is very important.

WFord3
Member

This would be a very useful function to have. 

MCarter24
Participant

@johnelmer can your HubSpot Ultimate Data Export tool export a Contact record's (and/or a Deal record's) history of comms and notes? We need this ability for regulatory reasons in our sector. This is for one Contact or Deal at a time, not for multiple records. Thanks in advance for your help! ~MC

johnelmer
Top Contributor | Elite Partner

@MCarter24  What you are asking about is called Engagements.  Ultimate Data Export does export Engagements.  However, it does not export one record at a time.   The good news is that you can do this natively in HubSpot.  Read more here: https://knowledge.hubspot.com/contacts/export-contact-data 

MCarter24
Participant

Thanks for the tip @johnelmer! 🙏 Problem is... the export is in JSON format which, to me (as a non-techie) is just gobbledeegook (no matter which app / JSON reader/editor I try to open it in).  I want to see the Notes, Emails etc. in a document as if they were copied and pasted from the HubSpot screen into a Word document. (Believe it or not, this is what our staff are doing now, to satisfy the regulatory requirements — that is, manually copying and pasting! Such a waste of time and money!) I am astounded that getting an export of a contact's comms out of HubSpot is so difficult. Surely there's a solution for this out there somewhere? Any other tips @johnelmer for getting the data out in a (for me) usable format?

 

@sgraci did you find a solution?

 

If anyone else could point me towards a solution, I'd be super grateful! Thanks! ~MC

CDorner5
Member

I would urgently need this function, too. For us it is important to be able to prove to our clients what we did for them. So what I need is an export (excel or word; readable to the human eye) of all engagements associated with a specific deal. Now, I could live with an export covering all deals and then just copying out the one that I need; however, as it is now, I need to manually copy this information, which is very tedious.