I am working on creating a marketing overview dashboard for my company. We would like to see month over month email statistics. Currently the only way to get that data is to manually export the emails on the "Marketing->Email" tab and select each month in the fixed time frame. I am looking for an api that will allow me to get the same data that is available via that report but in an automated fashion.
I wrote a script that warehoused every single email event in our hubspot instance (api endpoint: email/public/v1/events) which will work but the number of records is too big for my MySql database. Any recommendations here would be great! I would think month over month email metrics would be a common request.
We had similar issues across our organisation as well. And since we are a lead generation and marketing agency, tracking the emails sent were very important to us.
Luckily we came across one tool which integrateed with HS and allowed us to get deeper insights on our campaigns.
If you or anyone would like to know about the tool I can send an inbox.
This will retrieve every single event which means that you will need a very big database to store it (make sure to index). These event come with date stamps so I am using that field with Tableau to make month charts for email activity. Let me know if you have questions on how to break this out. Not ideal as an endpoint that had the aggregated monthly values would be much more efficient but it is working for now.
There is now a HubSpot to Tableau connector in the HubSpot App marketplace. The connector service includes a HubSpot-optimized SQL data warehouse hosted in the Microsoft Azure cloud.
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