topic Re: Creating an report on: opens per week day and hour. in Reporting & Analytics

Creating an report on: opens per week day and hour.

Wijtmans — Wed, 03 Jan 2024 12:31:56 GMT

Hi all,

I am trying to create a dashboard for our external marketing emails that displays data of the past 365 days to have a consistent data set to start of global marketing strategies.

One of the reports i would like to create is to visualize on what day clients open our emails and on what our of the day they open it. I want to try and combine these two metrics in one visual.

I am not a data scientist by profession, so i have a hard time transforming my thoughts into graphs. Below you will find a image of the result so far.

I want the x-axis to display the days of the week and the y-axis to display the amount of emails being opened on a particula day and the hour the emails being opened on a particular day.

I feel like the graph is displaying what i want, but i am not convinced of myself. The graph is not very friendly to read either, but i could not figure out a different way to show two y-axis's.

Tl;dr:

Is this graph correct; and
is there a more easy to read way to display the data?

Thanks for thinking along!

Nick

Re: Creating an report on: opens per week day and hour.

Ben_M — Wed, 03 Jan 2024 13:49:17 GMT

The field you are pulling apperas to be the first opened date of any email that you sent someone. This has little to do with overall performance of your emails and would only capture one particular email. My thought is that what you want is more complicated than what Hubspot reporting is designed to accomplish and you might need to dump the data from the API into an external solution to sort through the data and generate the open/by time of day report that you are looking for. I believe this is the endpoint you are looking for but it is from the legacydocs and I wasn't able to find a newer version of this: https://legacydocs.hubspot.com/docs/methods/email/email_events_overview

Re: Creating an report on: opens per week day and hour.

Wijtmans — Wed, 03 Jan 2024 14:23:22 GMT

Thanks for the link. It seems to be possible within the API, as suggested by the information on the page. Makes me think there might/should be a way.

The reason for the 'first opened date' is that the number of opens an email gets seems unrealistic. Some emails get 100+ opens, but I am pretty sure the user has not opened their email 100 times.

It is true that it would not capture the performance of the email, but that is not why I want to collect this data. We have a fairly niche industry and I want more insight into when emails are opened to predict habits and staffing.

I will try and fiddle some more with all the properties available. Thanks for your advice!