Get month over month email statistics
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.