# Lead, Deal and Compnay source Discrepancy

**URL:** <https://community.hubspot.com/t/lead-deal-and-compnay-source-discrepancy/93352>\
**Category:** CRM\
**Tags:** professional\
**Created:** [November 6, 2023, 1:03pm UTC](https://community.hubspot.com/t/lead-deal-and-compnay-source-discrepancy/93352 "2023-11-06T13:03:15Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![OAskarov](https://avatars.discourse-cdn.com/v4/letter/o/df788c/32.png) [@OAskarov](https://community.hubspot.com/u/OAskarov)\
**Post date:** [November 6, 2023, 1:03pm UTC](https://community.hubspot.com/t/lead-deal-and-compnay-source-discrepancy/93352/1 "2023-11-06T13:03:15Z")

</div>

Hi,

I need help with discrepancies between leads, deals, and company source properties.

I have two questions:

1. Is there a way to filter a view or a list to see all the sources from all these objects: Lead Source, Company Source, Deal source?

2. What is the most intelligent way to align these values from the Lead Source?

Thanks

---

<div class="post-metadata">

**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\
**Post date:** [November 6, 2023, 11:38pm UTC](https://community.hubspot.com/t/lead-deal-and-compnay-source-discrepancy/93352/2 "2023-11-06T23:38:45Z")

</div>

Hello @OAskarov thank you for posting in our Community!

I want to share this knowledge base with more information. It’s a great source that explains the source.

To our top experts @jolle [@Shadab\_Khan](https://community.hubspot.com/t5/user/viewprofilepage/user-id/513582) any recommendations to @OAskarov?

Thank you,

Pam

---

<div class="post-metadata">

**Author:** ![OAskarov](https://avatars.discourse-cdn.com/v4/letter/o/df788c/32.png) [@OAskarov](https://community.hubspot.com/u/OAskarov)\
**Post date:** [November 8, 2023, 9:05am UTC](https://community.hubspot.com/t/lead-deal-and-compnay-source-discrepancy/93352/3 "2023-11-08T09:05:39Z")

</div>

Hello @PamCotton ,

Thank you very much for this answer.

Can you please resend me the knowledge base link? It doesn’t open.

Thank you

---

<div class="post-metadata">

**Author:** ![Shadab\_Khan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/shadab_khan/32/12293_2.png) [@Shadab\_Khan](https://community.hubspot.com/u/Shadab_Khan)\
**Post date:** [November 7, 2023, 5:54am UTC](https://community.hubspot.com/t/lead-deal-and-compnay-source-discrepancy/93352/4 "2023-11-07T05:54:33Z")

</div>

Thanks @PamCotton,

Hi @OAskarov

Really good and important question here:

Natively the source properties are bit of a hassle to work with, You will be better of on modelling that data and transferring them in custom properties and move them through contact ➝ company ➝ deal objects

Our team had a similar use-case where we [did this](https://blog.revpartners.io/en/revops-articles/how-zoobean-got-accurate-marketing-attribution-for-offline-sources), feel free to take a look and implement this solution tailored to your business.

Stay Awesome & Keep Doing it BIG 🔥

---

<div class="post-metadata">

**Author:** ![OAskarov](https://avatars.discourse-cdn.com/v4/letter/o/df788c/32.png) [@OAskarov](https://community.hubspot.com/u/OAskarov)\
**Post date:** [November 8, 2023, 9:04am UTC](https://community.hubspot.com/t/lead-deal-and-compnay-source-discrepancy/93352/5 "2023-11-08T09:04:34Z")

</div>

Hi [@Shadab\_Khan](https://community.hubspot.com/t5/user/viewprofilepage/user-id/513582) ,

Thank you for that explanation. I’m really looking for a solution without the need to export data from HubSpot to Excel 😐. I guess this is not an option right now in HubSpot.

We have Lead Source, Deal Source, and Company source properties that narrow down the lead’s attribution from the Original Source.

I appreciate your help!

I’ll try to sort it out some way.

Thanks again!

---

<div class="post-metadata">

**Author:** ![Shadab\_Khan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/shadab_khan/32/12293_2.png) [@Shadab\_Khan](https://community.hubspot.com/u/Shadab_Khan)\
**Post date:** [November 8, 2023, 9:42am UTC](https://community.hubspot.com/t/lead-deal-and-compnay-source-discrepancy/93352/6 "2023-11-08T09:42:23Z")

</div>

@OAskarov That excel thing is a one-time exercise for historical data, once you are done with that WFs will take care of the rest for all your new data, that solution won the [Impact Award by HubSpot](https://www.hubspot.com/impact-awards-showcase-home#:~:text=Cocofact%20(LATAM)-,RevPartners%20(NAM),-T%26H%20Digital)

---

<div class="post-metadata">

**Author:** ![Shadab\_Khan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/shadab_khan/32/12293_2.png) [@Shadab\_Khan](https://community.hubspot.com/u/Shadab_Khan)\
**Post date:** [November 8, 2023, 9:40am UTC](https://community.hubspot.com/t/lead-deal-and-compnay-source-discrepancy/93352/7 "2023-11-08T09:40:06Z")

</div>

@OAskarov

Try [this link](https://knowledge.hubspot.com/reports/understand-hubspots-traffic-sources-in-the-traffic-analytics-tool) that @PamCotton shared
