Feb 6, 2019 7:19 AM
I am trying to import tickets into the system with their associated contacts and companies. This is very important as our clients look for a report of what tickets (plus typers and peoples) they have logged as part of teh account management process - this is standard practice in any service industry.
I can import and associate to a company or a contact but NOT both, this is incredibly frustrating and seemingly a huge hole in the system. As you cannot also automatically associate a ticket with a company by entering the contact (who is associated with a company), users are wasting time and effort for a seemingly simple fix.
Feb 6, 2019 2:50 PM
Not sure if all import rules apply to Service Hub, but please do a quick test with a single record.
-1- Import a ticket and associate with the Contact.
-2- Export that ticket into a .csv (which contains the unique ticket id).
-3- Import that ticket and associate with the Company. Update based on unique ticket id. (important)
Although this solution requires multiple steps, it is scalable. The alternative is to use an import service (e.g., Import2, Data2CRM, etc.).
Feb 7, 2019 5:35 AM
Many thanks that works, kind of! The only problem with the above approach is that it creates a new company for each ticket entry leaving you with a very messy database. Maybe I did not do it properly but that's what happened to me
For anyone else trying the process, from nothing in the database, would be
All sorted! I hope that helps someone else
Feb 7, 2019 8:27 AM
Of course, you are correct. That is expected behavior on an empty CRM.
Based on the original problem description, I presumed your Contacts and Companies were already existing in HubSpot with associations established, and that Tickets were our only focus.
Glad it worked out.
Feb 7, 2019 5:30 PM - edited Feb 7, 2019 5:30 PM
Great process, and thanks for sharing it.
Are your tickets usually short transactions, or can they span days/weeks? Sorry for hijacking your thread, but it looks as though you're succeeding with something I'm failing at: Reporting on Tickets.
As far as I can see, Tickets in HubSpot are treated as a single entity. The transactions (emails, notes, calls etc) on the ticket are not visible to the reporting engine - so there's no way to report on customer activity within a specific timeframe. This limitation makes activity-based billing a challenge.
Feb 8, 2019 7:15 AM
I'm a relatively new user but, as far as I can tell, the best way to do most reports is by going to the tickets screen and click options - export and select all data items. This allows you to download all the ticket info into an Excel file which you can then perform your own reports on.
It would be relatively simple to filter by company and then see tickets created within set timeframes such as ticket created date, last activity date, number of time contacted etc.
It's not a canned pretty report but would do the jobn and you could, I'm sure, achieve at least some of your desired results in under 5 mintues.
Hope that helps
Feb 10, 2019 3:31 PM
Thanks for taking the time to reply. Exporting data is Ok and this is how I'm doing it currently - the limitation being reports are no longer linked to live data. Plus it's a manual time-consuming process that requires you to remember to email the reports... you get the picture I'm sure!
The reporting engine in HubSpot is automatic & linked to the live data, so the results are dynamic and always up to date. They let you analyse your data in real-time (within limits) by presenting the reports on dashboards. Unfortunately, the limitations of the reporting tool, coupled with the reportable ticket data, make specific time-period reports almost impossible (unless I'm missing something).