I find it impossible to get the sort of reporting I want from HubSpot or via any of the reporting integrations that I've tried. The main limitations I find are in grouping of emails/campaigns, and the ability to select date ranges and show week-on-week or month-on-month change for the specific attributes that I am interested in. Nor can I add targets and show variance to target. How I get around the problem now Currently to see what I want to see, I need to use the Marketing>Email>Export Email function to export a CSV of the email attributes over a given time frame, then I need to repeat that for the comparison time frame (previous month, for example). I then have to group the campaigns together in the way I want and do all of the month-on-month calculations manually, within a spreadsheet. The limitations of what's currently available in the dashboard In this dashboard, I can get a month-on-month view, but only for emails as a whole, top-level, which isn't helpful. I also can't adjust the metrics which display. I generally like to see sent, opened, open rate, clicked and CTR. Here, I'm stuck with sent, opened, clicks and click rate. There's also another level of grouping which I feel is missing. I can show emails at an individual level, or group things together into campaigns, but it still doesn't give me the flexibility I need. The way I use Hubspot, I've got emails grouped into campaigns, but then strategically, you can group those campaigns into being supportive of broad business objectives. Maybe if you provided some sort of text filtering on campaign name, I'd be able to build a report which grouped campaigns together. The other thing I can't do is input any sort of target to show movement versus target. Examples of what I'm trying to achieve Here are a couple of reports I've had to manually create using Google Sheets and Data Studio, because I can't get the data together in HubSpot in the way that I need it. So, for these reports, I'm looking at overall groups of "Journey" emails (welcome & in-life, helpful service hints etc.), and "Campaign" which is more tactical, focused on specific up-sell or cross-sell activity. We're not really using HubSpot for pure acquisition yet, this is almost all aimed at existing customers. This is the first report, a top-level dashboard that shows O/R and CTR for my two broad groups of email, both versus a target and with a "variance to previous month". It's not possible to create this report within HubSpot. Here's the next one, which basically shows the detail behind the above. Again, shows the two broad campaign types, with my desired metrics, targets, and this time without the month-on-month variance and showing a graph view instead. I feel that this sort of reporting is very similar to the sort of reporting I'd want to see and need in other previous roles I've worked in. I'm in B2B utilities right now, but would want very similar reports for previous Ecommerce B2C retail jobs that I've worked. Exporting to Sheets via API I've tried several routes to creating these reports using apps from Marketplace which can export data from HubSpot to Google Sheets, however, crucially, there is no ability within the API to select the data range that the email were sent within. There are "campaign created dates" and stuff like that, but that's not helpful. I don't think I'm unique in having campaigns and workflows setup which trigger on an ongoing basis month to month. It doesn't seem unreasonable to want to export sent data from a given time-frame. The functionality exists within HubSpot, because I can do it manually from within Marketng>Email>Export Email. If you just made that date range selector visible to the API, it would be problem solved, becuase I could do all other filtering within Sheets. As it stands all that these "export to Sheets" plugins can do is export campaign data "all-time", which doen't allow you to monitor how your performance is changing over time.
...read more