Dashboards & Reporting

Alex_L
Participante

Custom Report - Activities by Team Member and Pipeline

resolver

Hello,

 

We would like to track activities by team member and pipeline as a bar chart.  Essentially, the X-axis will be the pipeline, Y-axis is the count of activities and each vertical bar will be broken down by team member name. 

 

I have a similar report but it's broken down by only deal owner, not each individual rep (who can be part of a deal in terms of activities but not the deal owner). Note the filters: Close Date this Month

Screenshot 2023-02-21 142308.png

I tried another custom report using activity created by (property) and filtered by close date (this month) & activity date (this month). Would this be an more accurate representation of activities by team member by pipeline? (i.e. missing team members would indicate no activity in that pipeline).

Screenshot 2023-02-21 143209.png

Asking as a sanity check since we do have a medium to large team who arent represented here. TIA

 

 

0 Avaliação positiva
1 Solução aceita
karstenkoehler
Solução
Membro do Hall da Fama | Parceiro
Membro do Hall da Fama | Parceiro

Custom Report - Activities by Team Member and Pipeline

resolver

Hi @Alex_L,

 

Correct, it would look like this:

 

karstenkoehler_0-1677044705440.png

 

I would probably use Activity assigned to instead of Activity created by, just in case someone creates tasks for other users, for examples. I would want to see the assignee.

 

If there are unassigned activities, they should appear as a (No value) report label. If activities aren't shown under a pipeline, they either didn't happen or aren't associated to a deal within that pipeline.

 

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.

Exibir solução no post original

2 Respostas 2
Alex_L
Participante

Custom Report - Activities by Team Member and Pipeline

resolver

Thanks @karstenkoehler! That makes more sense with Activity Assigned To as the breakdown. 

0 Avaliação positiva
karstenkoehler
Solução
Membro do Hall da Fama | Parceiro
Membro do Hall da Fama | Parceiro

Custom Report - Activities by Team Member and Pipeline

resolver

Hi @Alex_L,

 

Correct, it would look like this:

 

karstenkoehler_0-1677044705440.png

 

I would probably use Activity assigned to instead of Activity created by, just in case someone creates tasks for other users, for examples. I would want to see the assignee.

 

If there are unassigned activities, they should appear as a (No value) report label. If activities aren't shown under a pipeline, they either didn't happen or aren't associated to a deal within that pipeline.

 

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.