# Reporting on Last modified and updates

**URL:** <https://community.hubspot.com/t/reporting-on-last-modified-and-updates/102345>\
**Category:** Dashboards & Reporting\
**Tags:** workflows\
**Created:** [March 12, 2024, 2:42pm UTC](https://community.hubspot.com/t/reporting-on-last-modified-and-updates/102345 "2024-03-12T14:42:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![CClark3](https://avatars.discourse-cdn.com/v4/letter/c/87869e/32.png) [@CClark3](https://community.hubspot.com/u/CClark3)\
**Post date:** [March 12, 2024, 2:42pm UTC](https://community.hubspot.com/t/reporting-on-last-modified-and-updates/102345/1 "2024-03-12T14:42:47Z")

</div>

Hello,

I’m running into a bit of dilemna. I want to build a dashboard/report in Hubspot to point out any changes to a deal where a close date has changed, or any field. I know its not possible to show changes that were made but I would like to at least have the last modified date show. The problem is we have workflows running on deals daily(to populate todays date) so when i pull the last modified date they are all updated daily. Is it a way to exclude workflows updates from reports? Or a way to show the last user modification date and not by the workflow?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [March 12, 2024, 2:46pm UTC](https://community.hubspot.com/t/reporting-on-last-modified-and-updates/102345/2 "2024-03-12T14:46:32Z")

</div>

Hi @CClark3,

The “Last modified date” is not suitable for this, unfortunately, for the reason you’re describing. It’s not possible to change the behavior of that property or have it exclude certain changes.

If you’re interested in changes to deals, I’d recommend the sales analytics: [Create sales reports in the sales analytics suite](https://knowledge.hubspot.com/reports/create-sales-reports-with-the-sales-reports-analytics-tool)

(specifically the “Forecasts & Pipeline” section)

These include a “Deal change history” and “Deal push rate” report which might give you out of the box what you’re looking for - or at least close to it.

Best regards!

---

<div class="post-metadata">

**Author:** ![Lucila-Andimol](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lucila-andimol/32/69276_2.png) [@Lucila-Andimol](https://community.hubspot.com/u/Lucila-Andimol)\
**Post date:** [March 12, 2024, 2:50pm UTC](https://community.hubspot.com/t/reporting-on-last-modified-and-updates/102345/3 "2024-03-12T14:50:05Z")

</div>

Hey @CClark3

so the only way to see manually how it was modified is entering manually to each record here

 ![Screenshot 2024-03-12 at 15.49.53.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/2/6251cd24483487810f5366a0b91643d76b4a4f4d.png)

If you only want to see the user’s/manul modifications you will need to go throughout the API.

hope this helps

---

<div class="post-metadata">

**Author:** ![Girifox](https://avatars.discourse-cdn.com/v4/letter/g/90db22/32.png) [@Girifox](https://community.hubspot.com/u/Girifox)\
**Post date:** [August 6, 2024, 10:35am UTC](https://community.hubspot.com/t/reporting-on-last-modified-and-updates/102345/4 "2024-08-06T10:35:50Z")

</div>

I have the same requirement, and can’t/don’t want to use the API to get the answer, as I am looking for the simplest solution. I couldn’t find a workaround in the marketplace, either.

---

<div class="post-metadata">

**Author:** ![RubenBurdin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rubenburdin/32/75212_2.png) [@RubenBurdin](https://community.hubspot.com/u/RubenBurdin)\
**Post date:** [May 7, 2025, 9:57am UTC](https://community.hubspot.com/t/reporting-on-last-modified-and-updates/102345/5 "2025-05-07T09:57:28Z")

</div>

I’ve solved this recently with custom-coded workflow actions, but it requires access to Operations Hub Pro.

There is a hidden property you can extract via API, as detailed in this thread here: [https://community.hubspot.com/t5/APIs-Integrations/Last-modified-by-user/m-p/839546?profile.language=en](https://community.hubspot.com/t5/APIs-Integrations/Last-modified-by-user/m-p/839546?profile.language=en).

You can create three custom properties, such as:

- last\_modified\_by\_user\_id
- last\_modified\_by\_user\_timestamp
- last\_modified\_by\_user\_source

and then map them through a custom-coded workflow action or a third-party tool like [n8n.io](http://n8n.io). Then, you can use these properties in reports as needed. These can be configured for different records, as needed.
