Marketing Email Report

[clubsodandlime]

Hi, 

I am looking to creat a report where I can break down emails sent by the "From Address" I then want to see for a specific week what the number of emails sent was, open rate, click through rate, and reply rate are. 

From what I could tell I couldn't create this report, if someone knows how to do it that would be amazing OR if there's a tool out there that allows me to build a report or selector where I can see how many emails have went out and what the stats are based on the email address. 

Thanks,

Nick 

[karstenkoehler · Accepted solution]

Hi @clubsodandlime,

This will likely become a huge table, but you could achieve it with this custom report builder configuration: https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder

The weekly frequency can be changed by clicking on the "Publish/send date - Weekly" pencil icon.

Best regards

[clubsodandlime]

Thanks but this really doesn't accomplish what I was looking for, I appreciate the advice though. 

[karstenkoehler]

@clubsodandlime what exactly are you looking for? If you don't specify your requirements, I can't help.

[clubsodandlime]

Essentially it needs to look like this 

Then I need to be able to compare it to previous weeks and see if there's an uptick or downtick in engagement. It needs to be broken up via email from address not individually by email name. 

[karstenkoehler]

@clubsodandlime if your just looking for a table (export), you can adjust the columns under Menu > Marketing > Emails and them export the view. The metrics as well as the from address are included there. You can make it a pivot table in Excel or Google Sheets by week - or play around more with the pivot table in the custom report builder.

[clubsodandlime]

Yes, but I don't want to have to do that every week or month I was looking for something that was rolling and could have on my dashboard. 

[karstenkoehler]

@clubsodandlime what's wrong with the report I shared? It has all the information you're looking for at a glance, adjusted to what's possible in HubSpot. You could check if you like the report better if you move the from address to the rows section - but pivot tables in HubSpot simply aren't as powerful as in other tools like Sheets or Excel. This is as close as you get natively.