topic Re: DUPLICATE CONTACTS ON CALL REPORT in Dashboards & Reporting

DUPLICATE CONTACTS ON CALL REPORT

Tucker1 — Mon, 28 Nov 2022 20:44:34 GMT

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?

Re: DUPLICATE CONTACTS ON CALL REPORT

crispyGTM — Tue, 29 Nov 2022 00:04:10 GMT

@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.

Re: DUPLICATE CONTACTS ON CALL REPORT

karstenkoehler — Tue, 29 Nov 2022 05:33:11 GMT

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!

Re: DUPLICATE CONTACTS ON CALL REPORT

Tucker1 — Tue, 29 Nov 2022 15:17:46 GMT

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?

Re: DUPLICATE CONTACTS ON CALL REPORT

karstenkoehler — Tue, 29 Nov 2022 15:23:29 GMT

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!