topic Re: Report - Number of unique companies contacted in Dashboards & Reporting

Report - Number of unique companies contacted

PKropp — Mon, 19 Jul 2021 09:28:26 GMT

Hi!

I'm looking for ideas and insights on how to create a report that lets me see how many unique companies the sales team has contacted in a given period of time(last month, last quarter, etc.). And, if possible, another report that shows the number of companies contacted for the first time at any given time.

Does anyone have experience in creating reports like this?

Cheers,

Pierre

Re: Report - Number of unique companies contacted

karstenkoehler — Mon, 19 Jul 2021 12:19:57 GMT

Hi @PKropp,

This is unfortunately a bit more complicated than it should be. HubSpot usually looks at the last interaction, not any interaction within a time frame.

For the first report, navigate to Menu > Reports > Reports > Create custom report > Single object > Companies.

Under Filters, set Last contacted to the time frame you're interested in. Additionally, if you only wanted to display companies created by sales, set a filter for "Original source data 1 contains exactly SALES".

You can then switch to the Visualization tab. In the left sidebar, ad Last contacted by clicking on Data step.

Next, drag and drop Last contacted and Count of Companies into the Displaying area. Switch the chart type to a vertical bar chart and change the Frequency on the upper right to weekly or monthly. You should see something like this:

Keep in mind that you're now looking at companies who've had their last sales contact in the timeframe, not necessarily any sales contact.

For your second report, you would need to create a custom date property, e.g. First contacted, that is stamped at the moment of that activity. By default, HubSpot maintains only the last touchpoint (e.g. Last contacted). In a company based workflow, you'd enroll companies when "First contacted is unknown" and "Last contacted is known". HubSpot would then log the date of the first interaction (chat conversation, call, email, or meeting) in First contacted.

You could then build the report above in the exact same way, replacing Last contacted with First contacted.

Best regards!

Re: Report - Number of unique companies contacted

webdew — Mon, 19 Jul 2021 12:02:44 GMT

Hi @PKropp ,

For the first report you can use 'last contacted' property for your report.
Create a custom report for single object Companies. Use these filter: https://prnt.sc/1d2krlz
Now, in visulization tab, under displaying, drag and drop the properties like this: https://prnt.sc/1d2lddo

For the second report, unfortuantely we have no native property of 'first contacted' in HubSpot. however some user have already put this idea on the community's idea forum. Much required update that many of my clients have also asked for. I will also advise you to upvote it. Howver, for a way around you can create a compoany custom property for 'first touched' and then call it in the report.

Hope this helps!

If we were able to answer your query, kindly help the community by marking it as a solution.

Thanks and Regards.

Re: Report - Number of unique companies contacted

FBinow — Fri, 02 Sep 2022 10:18:55 GMT

Hi Karsten,

Thanks for your great input.

I wondered if you could share some thoughts on the option to have an overview that is unique contacted companies. I've tried your solution, which is nice, however this counts the companies several times, as we keep contacting them. I'm particularly interested seeing how many new companies we initiate a dialouge (call/email) with. Is that possible?

Best regards

Frederik

this does not really determine the uniqueness of the company being reached out to.

Re: Report - Number of unique companies contacted

SKOOBEY1 — Tue, 10 Jan 2023 17:35:46 GMT

I'm also interested in the most recent reply by FBinnow.

Re: Report - Number of unique companies contacted

CArsenault — Wed, 30 Aug 2023 18:46:26 GMT

I'd like to see a solution that provides a unique set of companies, so there is no duplication. Ex) One company was emailed 10 times across X time period show show only as 1 company. With the solution given, it's being shown 10 times.

Re: Report - Number of unique companies contacted

KEdwards — Tue, 14 May 2024 21:48:03 GMT

This was my way of doing it and I think it worked. I hope it helps others.