How to view historical deal stages

SOLVE
AcuityMR
Member

Is it possible to see a summary view of deal stage by date? For example, we have a "demo" stage within our deal pipeline. I'm trying to run a report that would allow me to see how many demo's were completed each month, but as soon as the deal moves past that stage (say to closed won or closed lost) I lose that perspective.

1 Accepted solution

Accepted Solutions
slepoidevin
Solution
Contributor

This is possible in a report (but you can only see aggregate numbers, you can't export the individual data). If you go to reports and create a custom deal report, you should be able to report on:
- Entered Stage

- Entered Stage Date

- Time in Stage (although this is only stamped after the next stage has been reached, it is not dynamic)

View solution in original post

11 Replies 11
jennysowyrda
Community Manager

Hey @AcuityMR

 

You can down export the history for all contact, company, and deal properties. This would give you the dates you're looking for. 

 

You can get to this option by clicking settings>properties>choose your property>export property history. 

 

 

0 Upvotes
gabrieloy
Member

Is there any way to get this informationthroughh the API?

0 Upvotes
jennysowyrda
Community Manager

HI @gabrieloy,

 

For a full outline of what is available with APIs, check out the deals APIs mentioned here.

 

@AndrewDick and @Kapil I noticed you've worked with the deals API before, do you have any suggestions for how to get started for @gabrieloy?

0 Upvotes
nateangell
Contributor

This is essential for us: We need to be able to view snapshots of a pipeline on any given date in the past: how many deals were in each stage, which deals were they, etc.

nateangell
Contributor

We had made a workaround to get historical deal movement info using the API, but then HubSpot made an unannounced change to the API. We managed to find another way to get the info via the API, and then we heard HubSpot may make that unavailable also. Why are they working to make historical deal stage movement information so hard to get? https://community.hubspot.com/t5/APIs-Integrations/Please-ensure-deal-stage-history-is-available-via...

nateangell
Contributor

ARGH! I just learned that one can export entire deal stage histories from the property itself in settings. The part I missed was that you can export all the histories for all the deals from the property in addition to seeing the history for just one deal. This is the incredibly simple solution for this need that no one thought to suggest till now, hence our needless trip to the API and redesign once the APIs changed.

0 Upvotes
Casana
Participant

Can you please share the link to where you found that?

0 Upvotes
sharonlicari
Community Manager

Hey @Casana 

 

Could you please advise which link are you looking for?

 

Thanks

Sharon


¿Sabías que la Comunidad está disponible en Español?
¡Participa hoy en conversaciones en el idioma de tu preferencia,cambiando el idioma en tus configuraciones!

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !


slepoidevin
Solution
Contributor

This is possible in a report (but you can only see aggregate numbers, you can't export the individual data). If you go to reports and create a custom deal report, you should be able to report on:
- Entered Stage

- Entered Stage Date

- Time in Stage (although this is only stamped after the next stage has been reached, it is not dynamic)

View solution in original post

WilliamMeeks
Participant

@slepoidevin @AnnaPerko 

 

It blows my mind that this information is only exportable this way! To my knowledge, you can't even build a workflow to capture this going forward like create new fields and add the date when the stage is entered.

 

This was a little clunky, but I was able to achieve this by exporting the data stage property history, see steps and screenshot below. Note, I had to write a formula in Excel to isolate the dates I wanted into one column as this file is horizontally long (left to right), and makes it near impossible to lookup and append. I had to also export a deal view, then do a lookup between the two files to make a master and segment the data to get a good visual.

 

  1. Settings>CRM>Properties
  2. Filter by "Deal Properties
  3. Search for "Deal Stage" 
  4. Click the "More" button
  5. Click "Export property history"

 

WilliamMeeks_0-1599756452193.png

 

ErikNordahl
Member

This should possible to retreive via normal api functionality... without manual steps needed.

 

Anyone found a way to get a snapshot of all deals state in a pipeline, per a specific date?

 

 

0 Upvotes