Export dashboard report data to CSV, XLS or XLSX format

Hi HubSpot team,

 

When I tried to export data from Session Country report in Web Analytics Dashboard, I realized that data can be exported:

  • just in PDF, PPTX or ZIP format
  • just on dashboard level (it is not possible to export just one report)

I would like to be able to export data from any dashboard report (such as Session Country report) to CSV, XLS or XLSX for further analysis and visualisation in tools such as Excel, Power BI and Tableau.

 

Kind regards,

Goran

HubSpot updates
changed to: In Planning
Mar 14, 2019

31件のコメント
新規投稿者

This would be EXTREMELY helpful because then we could schedule recurring emails with the dashboard information in a .csv file. 

常連ユーザー

Would also like this feature, as tools like Excel can be used to analyse data further.

一般投稿者

Yes please: we have scheduled reporting on weekly and monthly bases, and need the detail that CSV files can provide. 

新規投稿者

Yes count me in on that!

It would be extremely useful.

一般投稿者

If we could use Excel to data query HubSpot, so that we can manipulate the data as needed, that would be wonderful. I've done this for years with Salesforce. Missing the insights in HubSpot.

 

Thanks!

一般投稿者

Native connector for Microsoft Power BI or Power Query would be huge.

 

But I guess it would require warehouse with SQL database and that's whole another game.

トップ投稿者 | Diamond Partner
トップ投稿者 | Diamond Partner

Gorand and anyone else interested in Power BI, Our HubSpot to Power BI connector service is now live in the HubSpot integrations directory: https://www.hubspot.com/integrations/powerbi Yes, it includes a data warehouse (Azure) with a SQL database that is optimized for HubSpot Marketing and HubSpot CRM. We have multiple options for automatic updating of your HubSpot data. We are a HubSpot Agency Partner and built this connector to serve HubSpot users who want Salesforce-quality reporting for their CRM data. We provide a template for CRM reporting and are interested in hearing suggestions for a Marketing report template.

Thanks, John Elmer
Bayard Bradford www.bayardbradford.com

一般投稿者

Hi @johnelmer,

 

That sounds interesting. Could you please share some pricing details?

 

Cheers,

Goran

トップ投稿者 | Diamond Partner
トップ投稿者 | Diamond Partner

Please submit a contact form -- it's on the bottom of our landing page that has a working demo of Power BI with HubSpot data:  https://www.bayardbradford.com/hubspot-power-bi-integration-sign-up/

 

We will get back to you with pricing options. You will find it to be much more affordable that other connector services.

 

thanks,

 

John

一般投稿者

Thanks @johnelmer!

トップ投稿者 | Diamond Partner
トップ投稿者 | Diamond Partner

Excited to announce that our HubSpot Connector for Microsoft Power BI has exited beta successfully and is now available through the HubSpot Connect program. Here is a link to the directory listing.  

一般投稿者

Hello,

 

I've been working on creating monthly analytics reports for our C-Suite and Leadership teams. I was able to work with a HubSpot account manager to create dashboards with the right mix of reports for things like web traffic, social interactions, blogging performance, etc. Unfortunately, when I go to export these reports the files come out rather disappointing and unattractive:

  1. Webpage and blog titles are truncated to where it's not clear what page is performing well.
  2. The graphics in any format (PPt, PDF, and ZIP) are delivered in a very poor quality
  3. It would be nice if we could customize the look and feel of the reports (fonts, colors, etc.)
  4. The hover feature over reports such as the Sessions by Source would be great to also include on the export (breaking down the data clearly by each source with hard numbers)

Overall, I feel that the Dashboard export needs a bit of redesign. It would be so convenient to create reports like this for various departments and leadership with easy to use export options with high-quality graphics customized in company color and fonts. My team likes the information in these reports, we just want a higher quality export to deliver to leadership, especially at the enterprise account level.

新規投稿者

This would be so simple to implement - PLEASE make reports downloadable as CSVs. 

一般投稿者

Exporting to CSV at least is imperative. The current export only captures the unscrolled versions. It is absolutely useless for sales reporting in meetings.

新規投稿者

Yes! This would be so so helpful! Please add this as an option!

新規投稿者 | Gold Partner
新規投稿者 | Gold Partner

Agreed! Client are clammoring for simple numbers to be generated week by week, sent to sales, then reported to investors per community setup for Enterprise license. Visuals are great but they requested instant numbers get emailed to them week over week, month by month, etc. 

 

Going to see if there's a quick fix or 3rd party solution to achieve this goal on their behalf.

Anonymous

You could use our HubSpot to PowerBi Integration to get the automated scheduled reports you need.

 

Take a look.

 

https://www.bayardbradford.com/hubspot-power-bi-integration-sign-up/ 

新規投稿者 | Gold Partner
新規投稿者 | Gold Partner

Thanks so much but we've offered other 3rd party options to client and because they're paying a LOT for Enterprise-level license, they feel as though it should be included and refuse to pay for another solution outside Hubspot, unfortunately.

新メンバー

Would love to be able to schedule a recurring email on the reports I create to output a csv.  Use case - not everyone is in the CRM and uses excel for their departments - e.g. finance, etc.   

HubSpot製品開発チーム
HubSpot製品開発チーム
ステータスに更新: In Planning