Email throughput by domain

[charella5661599]

Need an email throughput by domain report

[Darren_Bowers · Accepted solution]

Hi @charella5661599 - You can do this is using a Distribution of values on the email domain from the broadLogRcp table.

Open up the broadLogRcp schema and click the data tab

Right-click the list and select Configure List

Add a new column and use the formula GetEmailDomain(@address)

Click the Distribution of values button and you should get a table showing you the email domains, Count and Percentage of each domain in the broadlog.

This will contain all statuses (Sent, Failed, etc) so play with the filtering to get the results you want. It also only contains the last 180 days or however long you have your broadLog retention period set to

[Milan_Vucetic]

Hi @charella5661599,

You can use default report Broadcast statistics which shows the breakdown by internet domain, of all messages processed and sent, of hard and soft bounces, opens, clicks and unsubscriptions. 

Regards, 

Milan

[Darren_Bowers]

Hey Milan - I was looking at this report a while ago. Do you know how to change the list of domains on this report?

[Milan_Vucetic]

Hi @Darren_Bowers, data is generated in the cube and all domains are there (from delivery) but some of them are shown and some of them are put in the Others category. Check report definition, there should be JS file just after query named Data, where you can change condition in order to avoid that domains are put in Others category. Hope this helps. Regards, Milan

[Darren_Bowers]

Thanks Milan - I'll take another look at it. This report has some other stats that are useful, but the reporting engine is very complex and poorly documented