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.
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.
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.
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.
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:
Webpage and blog titles are truncated to where it's not clear what page is performing well.
The graphics in any format (PPt, PDF, and ZIP) are delivered in a very poor quality
It would be nice if we could customize the look and feel of the reports (fonts, colors, etc.)
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.
Exporting to CSV at least is imperative. The current export only captures the unscrolled versions. It is absolutely useless for sales reporting in meetings.
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.
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.