topic Re: [HubSpot API] Best way to get timestamps for when deals enter specific pipeline stages? in APIs & Integrations

[HubSpot API] Best way to get timestamps for when deals enter specific pipeline stages?

PColusse — Tue, 30 Sep 2025 20:11:04 GMT

Hello everyone! I need help tracking two specific moments: when a deal enters stage X and when it enters stage Y - exactly these 2 timestamps. I'm using the HubSpot libraries for Python and everything works very well! It's just these specific timestamp fields that I don't know where/how to retrieve. Can you help me? Code of how I'm initially pulling the information below:

# Function to fetch all deals def fetch_all_deals(): all_deals = [] after = None while True: try: # Get deals with pagination deals_page = api_client.crm.deals.basic_api.get_page( limit=100, after=after, properties=[ "dealname", "amount", "dealstage", "pipeline", "closedate", "createdate", "hs_lastmodifieddate", "hs_date_entered_987312754", "hs_date_entered_987312757" ] ) # Add deals from current page to our list all_deals.extend(deals_page.results) # Check if there are more pages if deals_page.paging is None: break after = deals_page.paging.next.after except Exception as e: print(f"Error fetching deals: {str(e)}") break return all_deals

Re: [HubSpot API] Best way to get timestamps for when deals enter specific pipeline stages?

d-lupo — Wed, 01 Oct 2025 10:15:23 GMT

Hi @PColusse,

Why are you trying to handle this through the API?
From what I understand of your use case, you can achieve the same result more easily with a workflow:

Set up the workflow to trigger when a deal enters one of the two desired stages (activate reenrollment).
Add branches for the specific stages.
Within each branch, use the Edit property action to update the target property.

This way, you can simply copy the Last modified date into either hs_date_entered_987312754 or hs_date_entered_987312757, depending on the branch.

Alternatively, if your account doesn’t have the required license to build custom workflows (you’ll need at least one Professional or higher seat), you can use webhooks instead. Set up a webhook to send a request to a specified URL whenever a deal enters one of the desired stages. The request body will include the timestamp and stage, and your receiving system can then update the record in HubSpot using a standard API call.

Let me know if I’ve understood your scenario correctly and if either of these approaches helps! 😄

Re: [HubSpot API] Best way to get timestamps for when deals enter specific pipeline stages?

PColusse — Wed, 01 Oct 2025 11:51:24 GMT

Hi @d-lupo !

I'm using the API and Python because I want to create a database, process it to be formatted in a very specific way, and then upload it to an existing app I have for creating interactive cohort charts. The most difficult part is getting the data structured exactly how I need it for the initial processing.

The goal is to pull deal stage transition timestamps through the HubSpot API, transform that raw data into a cohort-ready format, and then feed it into my visualization application. The challenge isn't the analysis or charting part - I already have that infrastructure built - it's specifically getting the HubSpot data extraction and initial data transformation right so it matches the input requirements my cohort analysis app expects.

This is why I need those precise hs_date_entered_ timestamps for when deals move into specific stages - they're critical data points for calculating cohort progression rates and time-based metrics in my downstream analysis pipeline.

Re: [HubSpot API] Best way to get timestamps for when deals enter specific pipeline stages?

d-lupo — Wed, 01 Oct 2025 17:14:09 GMT

I'm still convinced that it would be easier the way I described above, but if you want to solve it programmatically, I think this is the request you are looking for:

Kind regards
Dennis