Creating a company activity report

SOLVE
ThomasF
Participant

Hi,

 

I'm trying to create a report that would help me see all the marketing activities of a given company. I want to see all the activities (email, website visits, content downloads) contacts within this company had for a specific period of time.

For context, I'm want to understand what content helped closed recent deals and when in the journey did they helped.

 

Thanks for your help!

Thomas

1 Accepted solution

Accepted Solutions
karstenkoehler
Solution
Most Valuable Member

Hello @ThomasF,

 

Great question! Since you're talking about three objects (contacts, companies, deals) we need to narrow down the issue. It has too many dimensions to display (three types of interactions, company names, deal amounts).

 

As a starting point for your exploration I'd suggest the following: Create a custom object report across contacts and companies and set the filters and properties as below.

 

  filters.png contacts-companies.png

 

Of course, you could also create a custom report across contacts and deals and display Deal name instead of Company name – which might make it easier to find the learnings you're looking for.

 

You'll immediately notice that you need to add additional filters for the visualization to be useful. Even with only 20 companies on the x-axis, the chart becomes almost undecipherable. You can set an additional filter, for example by Company name; list key accounts that you're interested in.

 

The reports above would not include sales activity. To visualize sales activity, you'd have to create a custom cross-object report on companies and activitities, display Name (Company) and Activity type (Activity) and measure by Count of Activities. Again, it's also a good idea to set a filter for this report to only show key accounts.

 

Hope this helps!

Karsten Köhler
Freelance Digital Marketing Advisor

Beratungstermin mit Karsten vereinbaren


Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

3 Replies 3
karstenkoehler
Solution
Most Valuable Member

Hello @ThomasF,

 

Great question! Since you're talking about three objects (contacts, companies, deals) we need to narrow down the issue. It has too many dimensions to display (three types of interactions, company names, deal amounts).

 

As a starting point for your exploration I'd suggest the following: Create a custom object report across contacts and companies and set the filters and properties as below.

 

  filters.png contacts-companies.png

 

Of course, you could also create a custom report across contacts and deals and display Deal name instead of Company name – which might make it easier to find the learnings you're looking for.

 

You'll immediately notice that you need to add additional filters for the visualization to be useful. Even with only 20 companies on the x-axis, the chart becomes almost undecipherable. You can set an additional filter, for example by Company name; list key accounts that you're interested in.

 

The reports above would not include sales activity. To visualize sales activity, you'd have to create a custom cross-object report on companies and activitities, display Name (Company) and Activity type (Activity) and measure by Count of Activities. Again, it's also a good idea to set a filter for this report to only show key accounts.

 

Hope this helps!

Karsten Köhler
Freelance Digital Marketing Advisor

Beratungstermin mit Karsten vereinbaren


Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

ThomasF
Participant

Hi Karsten,

 

Thanks for this detailed answer! This will definitely help me start the analysis. I'll be able to narrow down to companies that had significant activities. 
What I'm looking to achieve is kind of what we have on a contact record in terms of activity but summarized for all contacts at the account level. 

johnelmer
Top Contributor | Diamond Partner

@ThomasF  If you are unable to get the reporting you need using @karstenkoehler's approach, you may need to use more advanced software for the necessary analytics. 


Microsoft Power BI is a good solution for what you want to accomplish.  Power BI Free is included with Office365 and can be licensed separately.   You will also need the HubSpot Connector for Power BI, which is available in the HubSpot App Marketplace.  By using the connector, you will be able to create an automated data refresh schedule so that each time you open Power BI, the most recent HubSpot data is used to update your report.

 

There are a free and a $9.99 per month version of Power BI. Here is a high level comparison:

 

johnelmer_0-1608157538331.png




Did this post help solve your problem? If so, please mark it as a solution.


John Elmer, Bayard Bradford


John Elmer, CEO
Bayard Bradford

Advanced CRM | HubSpot Integrations | CRM-Driven Marketing for Revenue Growth
HubSpot Diamond Solutions Partner