# DUPLICATE CONTACTS ON CALL REPORT

**URL:** <https://community.hubspot.com/t/duplicate-contacts-on-call-report/70116>\
**Category:** Dashboards & Reporting\
**Created:** [November 28, 2022, 8:44pm UTC](https://community.hubspot.com/t/duplicate-contacts-on-call-report/70116 "2022-11-28T20:44:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tucker1](https://avatars.discourse-cdn.com/v4/letter/t/9d8465/32.png) [@Tucker1](https://community.hubspot.com/u/Tucker1)\
**Post date:** [November 28, 2022, 8:44pm UTC](https://community.hubspot.com/t/duplicate-contacts-on-call-report/70116/1 "2022-11-28T20:44:34Z")

</div>

Hello everyone, I was hoping that someone could help me out here..

I would like to have a report that I can pull in order to see how many calls vs how many qualification, meetings set, deals made, etc.

However, when I pull the report, it will include the same contact multiple times if they have multiple phone numbers..

For example, If I want to see how many meetings we set last month based on how many calls were made, it will show “John Doe” listed twice in the set meetings column if he has a Mobile phone and his Compnay line listed in his contact information.

Does anyone know how I can resolve this issue?

---

<div class="post-metadata">

**Author:** ![crispyGTM](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/crispygtm/32/40025_2.png) [@crispyGTM](https://community.hubspot.com/u/crispyGTM)\
**Post date:** [November 29, 2022, 12:04am UTC](https://community.hubspot.com/t/duplicate-contacts-on-call-report/70116/2 "2022-11-29T00:04:10Z")

</div>

@Tucker1 It sounds like you need to re-create the report as a single-object (contact) based report for this. Activity based reports will pull in multiple activities associated to the contacts.

---

<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:** [November 29, 2022, 5:33am UTC](https://community.hubspot.com/t/duplicate-contacts-on-call-report/70116/3 "2022-11-29T05:33:11Z")

</div>

Hi @Tucker1,

How exactly have you created this report? In a single-object activity report, HubSpot will count and show activities and not automatically deduplicate by contact.

Similarly, if you use the custom report builder and select multiple data source and choose _Activities_ as the primary data source, HubSpot will behave the same.

In other words, the object you want to deduplicate by must be the primary data source of the report. In your case that would be _Contacts_, with _Activities_ as an additional data source.

Once you share more details, I can also provide more help, if needed. Feel free to take screenshots of your report settings.

Hope this helps!

---

<div class="post-metadata">

**Author:** ![Tucker1](https://avatars.discourse-cdn.com/v4/letter/t/9d8465/32.png) [@Tucker1](https://community.hubspot.com/u/Tucker1)\
**Post date:** [November 29, 2022, 3:17pm UTC](https://community.hubspot.com/t/duplicate-contacts-on-call-report/70116/4 "2022-11-29T15:17:46Z")

</div>

Thank you for your response Karsten. I previously built a report that had shown me Contacts vs Lead status’s. However, I want to see how many phone calls it takes in order to obtain those lead status’s. If I build my report based on Contacts Vs Lead Status’s, is there a way to also input count of calls?

 ![InkedCalls Report - Duplicate Contacts_LI.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/3/d3702388c55b750a7323299660fa6e0ff3c4e0b8.jpeg)

 ![Calls Report .png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/d/1d0d4ad7bbe9812bf60ecc560ecb837b01e58155.png)

---

<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:** [November 29, 2022, 3:23pm UTC](https://community.hubspot.com/t/duplicate-contacts-on-call-report/70116/5 "2022-11-29T15:23:29Z")

</div>

Hi @Tucker1,

Your report has the primary data source contacts, so it shouldn’t be showing contacts multiple times.

With the report you’re trying to create you need to be cautious. HubSpot is not necessarily only visualizing calls that led to a certain lead status but also calls within this status. It might not make a difference practically but you should keep it in mind.

If you want to visualize the count of calls by current contact lead status, you should be all sorted.

Best regards!
