Mass exporting timeline activities

[daniella1993]

It would be nice to be able to get a report on your companies with columns counting each HubSpot activity (including notes, voicemails). 

Or some high-level overview of the touch point timeline... 

Something that would show this type of info:

Pointclear calls it a "touch summary"

To demonstrate, take a look at the touch summary for the “uncloseable” that our competitor identified:

Date Stamp	Entry
04-Aug-16	vm 1
04-Aug-16	email 1
10-Aug-16	vm 2
10-Aug-16	email 2
12-Aug-16	no email just vm
18-Aug-16	zero out
24-Aug-16	vm 3
24-Aug-16	email 3
24-Aug-16	Dean called me to ask for more information for Mike Smith
30-Aug-16	follow up voice mail
30-Aug-16	follow up voice mail
30-Aug-16	email to request call back
30-Aug-16	I'll be on vacation from 24 Aug to 2 Sep and will have limited access to email
30-Aug-16	call scheduled for 8 Sep at 11
06-Sep-16	sent invite to confirm call
08-Sep-16	call
12-Sep-16	sent email to schedule a meeting with sales exec
16-Sep-16	confirmed appointment for noon Wed 21 Sep

[Salvatore]

I'm a mortgage broker, and this would be great to add my realtors i partner with.  This way thery would be able to effeciantly communicate back and forth assign task etc.  And if at the end of the day we part ways, they take thier book of business with them.

[PiaR]

This would be a great feature to get for all countries impacted by GDPR as this would enable us to support data subject rights re. access to data on them.

[lholzberger171]

 Upvote + 1,000! Would be uber valuable to be able to export this data for multiple contacts at once. 

[Deborah]

I agree. I would be great for GDPR purpose (disclosure right) to be able to export a chronik summary in order to display the customer what data we are storing...

I also like the idea to get a PDF summary besides the CSV download possibility.

[Shaunyim]

It would be great too if we could also export the names of the forms a user submitted to be captured in an excel sheet upon export.

-Posted on behalf of Scott Macdonald

[DannyCyan]

This would be great except it would be beneficial to get all the detail as well. 

We do lead gen with clients who have sales people who follow up on leads via Salesforce or SAP and it would be helpful to us when forwarding leads if we could just forward the entire contact history in one easy document so they can quickly follow the history of the lead and their interactions with marketing. 

[danpilat]

We definitely need this..

[SupportTeamDSS]

This would be fantastic. I spend a lot of time doing Ad Hoc reporting to show interactions for individual contacts, so it would be great if there were an export function to show all of the calls/ notes/ items associated with a contact so it would be tracked more automatically.

[johnelmer]

@daniella1993 @SupportTeamDSS @danpilat @DannyCyan @Shaunyim  Three different solutions are now available to solve this problem. (Disclosure: All three are provided by my firm via the HubSpot App Marketplace).

Option 1:  Ultimate Data Export for HubSpot app

One option is to export all of your CRM data using Ultimate Data Export for HubSpot.  Ultimate Data Export is available free of charge in the HubSpot App Marketplace.   With the Ultimate Data Export for HubSpot you can export the following data tables and their associations to Excel:

• Contacts

• Web Analytics

• Companies

• Deals

• Deal History

• Owners

• Campaigns

• Engagements

• Emails

• Products

• Tickets

• and more related subdata such as Pipelines and Associations.

The export comes by email as an Excel workbook with 30+ tabs.  You should be able to set up a pivot table to do the analysis, which would be all engagements per contact.  Since the export has the contact IDs needed to link engagements to contacts you should be able to pivot mostly any linkable record in the way described above.  I would recommend this option if you want a low-risk trial of exporting the data and setting up the analysis in Excel. It is not a long term solution if you need to run these reports on a regular basis with updated data.

Option 2: HubSpot Connector for Excel

Since the Ultimate Data Export app is intended for one-time use, you might consider licensing the HubSpot Connector for Excel.  This connector pushes data from your HubSpot portal to a cloud data warehouse, where it is queried automatically each time you open the Excel workbook with your pivot tables.   I recommend this only if you feel strongly that you want to do this work in Excel. The much better option is to use a BI software package (see Option 3)

Option 3: HubSpot Connector for Power BI or HubSpot Connector for Tableau

By using business intelligence software, you have more powerful tools for building the reports you want. Power BI is tightly integrated with Microsoft Azure (which is where the HubSpot Connector hosts your data warehouse).  There is a learning curve to Power BI, but it is similar to Excel in many respects.  I would recommend Power BI over Tableau if your company doesn't have any BI software, primarily because of the low cost of Power BI (free or $9.99 a month).

If you have any questions, please feel free to DM me here on the HubSpot Communities.

John

[PChalasani]

@johnelmer does this solution currently work? I'm specifically looking for an export of the activity timeline of all contacts, ideally, all historical events of the items you list above, such as all past email events, all past engagements, etc, and deal stage changes (especially moving to Closed Won, or any other specific changes)?

(These can be in multiple tables, and I'll worry about stitching them together)

[johnelmer]

@PChalasani I suggest trying the free Ultimate Currency Converter first.  That app has been undergoing maintenance because of changes to HubSpot's APIs.  If it isn't currently available, just check back. It will be up and running soon.