Dashboards & Reporting

TVaz
Participante

Pipeline dashboard weekly progress by stage

resolver

Hi Community!

 

Do you know how can I create a dashboad for the Sales Pipeline that reflects the weekly progress by stage and total?

0 Me gusta
3 Soluciones aceptadas
karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

@TVaz 

 

First report draft (custom report builder, data source = deals)

 

karstenkoehler_0-1720776837714.png

 

Second and third report: These are only available as default reports in the sales report collections, as 'Deal change history' and 'Historical snapshots'. https://knowledge.hubspot.com/reports/create-sales-reports-with-the-sales-reports-analytics-tool

 

(Custom reports always show the current status of deals; it's not possible to create custom reports that show the development of deals over time.)

 

Let me know if you have any follow-up questions and please mark my replies as accepted solutions. It helps other forum members (and me) a lot.

 

Have a great weekend!

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.

Ver la solución en mensaje original publicado

0 Me gusta
karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

@TVaz in the sidebar to the left, search for "Pipeline stage" – you can then drag it to the right where it says "Drag fields here".

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.

Ver la solución en mensaje original publicado

0 Me gusta
karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

@TVaz you need to select your pipeline under "is any of".

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.

Ver la solución en mensaje original publicado

0 Me gusta
16 Respuestas 16
TVaz
Participante

Pipeline dashboard weekly progress by stage

resolver

 

Hey Karsten!

I´m in the Professional subscription. I tried to break down by report, maybe it is easier to explain: 

 

  • Pipeline by Stage: Bar or funnel chart showing the number of deald and total value at each stage.
  • Weekly Movement: Line or bar chart displaying deal progress/changes by week. X-Axis: Weeks; Y-Axis: Number of deals/total value
  • Total Progress: Cumulative chart showing total progress over time. X-Axis: Time; Y-Axis: Total deals

 

0 Me gusta
karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

@TVaz 

 

First report draft (custom report builder, data source = deals)

 

karstenkoehler_0-1720776837714.png

 

Second and third report: These are only available as default reports in the sales report collections, as 'Deal change history' and 'Historical snapshots'. https://knowledge.hubspot.com/reports/create-sales-reports-with-the-sales-reports-analytics-tool

 

(Custom reports always show the current status of deals; it's not possible to create custom reports that show the development of deals over time.)

 

Let me know if you have any follow-up questions and please mark my replies as accepted solutions. It helps other forum members (and me) a lot.

 

Have a great weekend!

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 Me gusta
TVaz
Participante

Pipeline dashboard weekly progress by stage

resolver

Thank you, Karsten.

 

Just one question (maybe I should have mentioned this before). I have more than once pipeline (one for each type of produtc). Can I choose the pipeline I want in these reports?

0 Me gusta
karstenkoehler
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

@TVaz yes, in custom report simply add a filter for 'Pipeline stage', in sales collection reports you'll find this in the right sidebar.

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 Me gusta
TVaz
Participante

Pipeline dashboard weekly progress by stage

resolver

Yes, I tried this but the only options I see are those. =/

TVaz_0-1720778297714.png

 

0 Me gusta
karstenkoehler
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

@TVaz my bad, please try 'Deal stage'.

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 Me gusta
TVaz
Participante

Pipeline dashboard weekly progress by stage

resolver

No. Nothing really changes. Is there any other type of report that might be easir to filter by pipeline? 

0 Me gusta
karstenkoehler
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

@TVaz my bad again, I misread. Here's the pipeline filter:

 

karstenkoehler_0-1720779184664.png

 

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 Me gusta
TVaz
Participante

Pipeline dashboard weekly progress by stage

resolver

Applying this filter it doesn´t change anything in my grafic. 

0 Me gusta
karstenkoehler
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

@TVaz once you've added it to the filters, have you clicked into it and specified a pipeline? (It says 'Click to apply filter')

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 Me gusta
TVaz
Participante

Pipeline dashboard weekly progress by stage

resolver

When I click it, that´s what I see. And even if I apply the filter, clicking in none, later I can´t find the option to specify a pipeline. 

 

TVaz_0-1720780828390.png

 

0 Me gusta
karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

@TVaz you need to select your pipeline under "is any of".

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 Me gusta
TVaz
Participante

Pipeline dashboard weekly progress by stage

resolver

Perfect! Thank you so much 🙂

0 Me gusta
TVaz
Participante

Pipeline dashboard weekly progress by stage

resolver

You mean here? I can´t find this option you mentioned. 

 

TVaz_0-1720777903773.png

 

0 Me gusta
karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

@TVaz in the sidebar to the left, search for "Pipeline stage" – you can then drag it to the right where it says "Drag fields here".

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 Me gusta
karstenkoehler
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Pipeline dashboard weekly progress by stage

resolver

Hi @TVaz,

 

Which subscription level are you on? If you're using the free CRM or are on a Starter subscription, you would navigate to Menu > Reporting & Data > Reports > Create report and then search for deal reports including stage information:

 

karstenkoehler_0-1720775080566.png

 

Once you find one to your liking, save it and set up a recurring email by following these steps: https://knowledge.hubspot.com/dashboard/email-or-export-reports-and-dashboards#manage-recurring-repo...

 

If you're on a Professional or Enterprise subscription, you can also create custom reports: https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder

 

Alternatively, check out the sales report collections: https://knowledge.hubspot.com/reports/create-sales-reports-with-the-sales-reports-analytics-tool

 

You might find your desired report in there and can then set up recurring emails as well: https://knowledge.hubspot.com/dashboard/email-or-export-reports-and-dashboards#manage-recurring-repo...

 

If you cannot find your desired report, please describe in a bit more detail what exactly you would like to see on the x-axis, y-axis and which chart type you envision. I can then lay out more detailed steps for creating a custom report.

 

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 Me gusta