Tickets & Conversations

jessreilley
Participant

Create a report that shows the owner of a ticket during different phases of the ticket

SOLVE

Hi,

 

Is it possible to create a report of who was the owner of a ticket during each stage in the ticket pipeline?  We want to get a count of the ticket owner during the different ticket statuses, but I can't figure out how to generate this report.

 

Thanks!
Jess

0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Create a report that shows the owner of a ticket during different phases of the ticket

SOLVE

Hi @jessreilley,

 

Not out of the box, no. You would have to set up a property for each stage, a user property:

  • Stage 1 user
  • Stage 2 user
  • Stage 3 user

etc

 

These user properties can be created like any other property (dropdown, single-line text, number). Simply select the HubSpot user property type.

 

You would then have to set up workflows that, when a deal enters a certain stage, copies the deal owner into the corresponding stage owner.

 

Going forward, you would then be able to report on owners in each stage or create a table view to see which owner a deal has had in a specific stage.

 

If your deals tend to change owners, you might want to consider if these changes are role-based. In that case, you could create an owner property for each of these roles which might make reporting easier.

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

0 Upvotes
1 Reply 1
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Create a report that shows the owner of a ticket during different phases of the ticket

SOLVE

Hi @jessreilley,

 

Not out of the box, no. You would have to set up a property for each stage, a user property:

  • Stage 1 user
  • Stage 2 user
  • Stage 3 user

etc

 

These user properties can be created like any other property (dropdown, single-line text, number). Simply select the HubSpot user property type.

 

You would then have to set up workflows that, when a deal enters a certain stage, copies the deal owner into the corresponding stage owner.

 

Going forward, you would then be able to report on owners in each stage or create a table view to see which owner a deal has had in a specific stage.

 

If your deals tend to change owners, you might want to consider if these changes are role-based. In that case, you could create an owner property for each of these roles which might make reporting easier.

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes