This is my second week learning how to use Hubspot in my new position. I was tasked with finding unique interactions for each company by date. For example, a sales rep had three interactions with Company “ABC” on three separate dates. I would like to generate a report that reflects this with all companies and respective contact date(s). Ideally, the final report will have just two columns: company name, contact date(s).
I did some digging around with similar questions on the community and saw that Hubspot only registers last contact date but not a record of all contact dates with that specific company. Is this still in effect? If so, I assume this report would be not possible?
It’s possible to create these kinds of reports (either a single object Activities report or a cross object Companies and Sales Activities report) but it’s not possible to get a list of dates in one column. HubSpot is storing the dates of activities and they can be accessed via these reports but it’s not possible to get a list of dates in one column, separated by commas, see below. HubSpot will simply treat dates as individual columns or as something to be aggregated by week, month, year:
