Dashboards & Reporting

WHawkins3
Participant

Customized Data Report Exports

SOLVE

Hello, 

 

I'm looking to find some answers regarding creating customized reports for Deal info from my company HS system.  Currently I am running into issues where the the report is limited to 4 columns max.  I am needing to add more columns than that. 

 

Management is looking to see a report that can assist them with monthly and yearly budgeting.  Currently we are having to combine multiple report exports into one in order to get the amount of data columns required.  

 

For example

  • Combining Deal information with Contact/Company information.
  • Data points such as: Deal name, Deal Stage, Revenue, Deal owner, $ amount, company, total $ for company. 
  • Finding a lot of report templates that limit the amount of data columns that can be exported in one file. 
  • Can be exported from a dashboard for deeper analysis by analyst/management. 

 

I apprecaite any help or conversations that can be had to help.  

3 Accepted solutions
johnelmer
Solution
Top Contributor | Elite Partner
Top Contributor | Elite Partner

Customized Data Report Exports

SOLVE

@WHawkins3 The limitations of HubSpot reporting is a challenge that HubSpot has committed to addressing in the future. For now, the kind of analyses you want to run can be done by using business intelligence software such as Tableau, Microsoft Power BI, or even Excel.  There are apps in the HubSpot App Marketplace that have free trials so you can tell if this solution will meet your needs.  

 

1. HubSpot Integration for Power BI  This connector automatically syncs HubSpot to Power BI and the data refreshes on a regular schedule so that each time you open Power BI, the most recent HubSpot data is used to update your report.  Power BI is sort of a "super Excel" and is included with many Office 365 subscriptions.

2.  Excel Integration for HubSpot.  Using this app, your HubSpot data can be set up to refresh in Excel on a regularly scheduled basis. The integration would enable you to automate your sales reporting and create the charts you need.  

 

Hope this helps.

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






John Elmer, CEO
Bayard Bradford

Advanced CRM Implementation | HubSpot Custom Integration Services | Datawarehouse.io Apps for HubSpot
Elite HubSpot Solutions Partner
> Follow me on LinkedIn

View solution in original post

karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Customized Data Report Exports

SOLVE

Hi @WHawkins3,

 


@WHawkins3 wrote:

Currently I am running into issues where the the report is limited to 4 columns max.  I am needing to add more columns than that. 


Could you specify what you're referring to here?

 

When creating custom reports (Menu > Reports > Reports > Create report > Custom report builder), adding more than four columns works fine for me:

 

karstenkoehler_0-1676613914092.png

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

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

amitsarda
Solution
Participant

Customized Data Report Exports

SOLVE

Hi @WHawkins3! I would recommend following the approach shared by @johnelmer. You can use tools like Coupler to set up a data pipeline and visualize it in Tableau. I recently also got to know about another tool called Equals.app. To me, it seemed a lot similar to Rows.

View solution in original post

3 Replies 3
amitsarda
Solution
Participant

Customized Data Report Exports

SOLVE

Hi @WHawkins3! I would recommend following the approach shared by @johnelmer. You can use tools like Coupler to set up a data pipeline and visualize it in Tableau. I recently also got to know about another tool called Equals.app. To me, it seemed a lot similar to Rows.

karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Customized Data Report Exports

SOLVE

Hi @WHawkins3,

 


@WHawkins3 wrote:

Currently I am running into issues where the the report is limited to 4 columns max.  I am needing to add more columns than that. 


Could you specify what you're referring to here?

 

When creating custom reports (Menu > Reports > Reports > Create report > Custom report builder), adding more than four columns works fine for me:

 

karstenkoehler_0-1676613914092.png

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

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

johnelmer
Solution
Top Contributor | Elite Partner
Top Contributor | Elite Partner

Customized Data Report Exports

SOLVE

@WHawkins3 The limitations of HubSpot reporting is a challenge that HubSpot has committed to addressing in the future. For now, the kind of analyses you want to run can be done by using business intelligence software such as Tableau, Microsoft Power BI, or even Excel.  There are apps in the HubSpot App Marketplace that have free trials so you can tell if this solution will meet your needs.  

 

1. HubSpot Integration for Power BI  This connector automatically syncs HubSpot to Power BI and the data refreshes on a regular schedule so that each time you open Power BI, the most recent HubSpot data is used to update your report.  Power BI is sort of a "super Excel" and is included with many Office 365 subscriptions.

2.  Excel Integration for HubSpot.  Using this app, your HubSpot data can be set up to refresh in Excel on a regularly scheduled basis. The integration would enable you to automate your sales reporting and create the charts you need.  

 

Hope this helps.

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






John Elmer, CEO
Bayard Bradford

Advanced CRM Implementation | HubSpot Custom Integration Services | Datawarehouse.io Apps for HubSpot
Elite HubSpot Solutions Partner
> Follow me on LinkedIn