# Tracking Ownership Changes in a Report

**URL:** <https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [October 17, 2020, 1:48am UTC](https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890 "2020-10-17T01:48:40Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![2chars](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/2chars/32/18130_2.png) [@2chars](https://community.hubspot.com/u/2chars)\
**Post date:** [October 17, 2020, 1:48am UTC](https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890/1 "2020-10-17T01:48:40Z")

</div>

Is there a way to track changes in ownership for a deal or contact (lead) in a report?

For example - we have some leads that get nurtured by one user before being turned over to another.

Or as posted [previously](https://community.hubspot.com/t5/Dashboards-Reporting/Tracking-Ownership-Changes-in-a-Report/td-p/282838):

“…when a sales team member leaves, we reassign those contacts to another team member. I would like to create a report that shows how many contacts/deals have changed ownership recently and which contacts/deals they are.”

If there’s no perfect way to do this, could we at least create a custom property and do some rudimentary tracking?

---

<div class="post-metadata">

**Author:** ![siez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/siez/32/74736_2.png) [@siez](https://community.hubspot.com/u/siez)\
**Post date:** [October 13, 2021, 5:16pm UTC](https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890/2 "2021-10-13T17:16:22Z")

</div>

This is a really important requirment for my company too and I believe it could be useful for any company where there are different email markeitng and sales team (quite possibly almost every company).  
In my company as well, contacts are nurtured by marketing team and then quailified and passed onto the sales team. We want to keep a track of how many contacts are being assigned to different teams each month. This is a very crucial thing to track. Please share a solution to this!

---

<div class="post-metadata">

**Author:** ![mattmason](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mattmason/32/65552_2.png) [@mattmason](https://community.hubspot.com/u/mattmason)\
**Post date:** [January 26, 2022, 6:50pm UTC](https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890/3 "2022-01-26T18:50:06Z")

</div>

We are looking for this functionality in our organisation too!!

---

<div class="post-metadata">

**Author:** ![PBeardwell](https://avatars.discourse-cdn.com/v4/letter/p/f14d63/32.png) [@PBeardwell](https://community.hubspot.com/u/PBeardwell)\
**Post date:** [May 5, 2022, 2:28pm UTC](https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890/4 "2022-05-05T14:28:22Z")

</div>

I would also like to be able to track who owned what company at what time. Ie when did account x be passed to Sales Person y. For similar reasons to those others have listed above.

---

<div class="post-metadata">

**Author:** ![JLandis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jlandis/32/84083_2.png) [@JLandis](https://community.hubspot.com/u/JLandis)\
**Post date:** [March 14, 2023, 10:28pm UTC](https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890/5 "2023-03-14T22:28:16Z")

</div>

+1. I am also looking for a way to generate a report that shows companies reps have added and removed their names from each week. Finding this data very difficult to come by in a list or a report.

---

<div class="post-metadata">

**Author:** ![HMaschmann](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hmaschmann/32/13521_2.png) [@HMaschmann](https://community.hubspot.com/u/HMaschmann)\
**Post date:** [April 7, 2023, 5:23pm UTC](https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890/6 "2023-04-07T17:23:05Z")

</div>

Even if it wasn’t reportable, it would at least be helpful to see an Ownership change as an Activity. Of course, a report would be best.

---

<div class="post-metadata">

**Author:** ![Ruurd](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ruurd/32/74102_2.png) [@Ruurd](https://community.hubspot.com/u/Ruurd)\
**Post date:** [July 15, 2023, 9:41am UTC](https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890/7 "2023-07-15T09:41:35Z")

</div>

Hi @2chars,

This can be done with 2 custom properties and 2 workflows. I did it for Contacts, but I think you can replicate this for any object that has an Owner property.

Custom properties:

- Previous Contact Owner (Type: Hubspot User)
- Copy of Contact Owner (Type: Hubspot User)  
_(In the screenshots you’ll see that I called the property ‘WF - Copy of Contact Owner’ to indicate this field is only used for a workflow, but that’s just my personal preference.)_

Workflows:

- Workflow 1 copies the value of ‘Contact Owner’ to ‘Copy of Contact Owner’ for each new Contact
- Workflow 2 tiggers when the ‘Contact Owner’ is changed (event-based), copies the value from ‘Copy of Contact Owner’ into ‘Previous Contact Owner’ and then the value from ‘Contact Owner’ into ‘Copy of Contact Owner’.

You can then use the field ‘Previous Contact Owner’ in a report.

Hope this helps!

Best, Ruurd

 ![Screenshot 2023-07-15 at 11.38.50.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/f/5f7cf8b715326c9aaeb047f75bb5e403365eb4ba.png)  
Workflow 1  
 ![Screenshot 2023-07-15 at 11.39.16.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/e/2ebff3e0fb386b338f1493ec5ff60ba10ec4ddf7.png)  
Workflow 2

---

<div class="post-metadata">

**Author:** ![HMaschmann](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hmaschmann/32/13521_2.png) [@HMaschmann](https://community.hubspot.com/u/HMaschmann)\
**Post date:** [July 18, 2023, 2:23pm UTC](https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890/8 "2023-07-18T14:23:28Z")

</div>

Thank you for your help. This is great.  
-Heidi

---

<div class="post-metadata">

**Author:** ![Mor\_Gold](https://avatars.discourse-cdn.com/v4/letter/m/d6d6ee/32.png) [@Mor\_Gold](https://community.hubspot.com/u/Mor_Gold)\
**Post date:** [June 22, 2025, 8:38am UTC](https://community.hubspot.com/t/tracking-ownership-changes-in-a-report/26890/9 "2025-06-22T08:38:39Z")

</div>

@Ruurd - great solution, even 2 years later. Thanks!
