Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Email throughput by domain

Avatar

Level 1

Need an email throughput by domain report

1 Accepted Solution

Avatar

Correct answer by
Level 9

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)

DarrenOrigin_0-1589498820510.png

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.

DarrenOrigin_1-1589498842164.png

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

View solution in original post

5 Replies

Avatar

Correct answer by
Level 9

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)

DarrenOrigin_0-1589498820510.png

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.

DarrenOrigin_1-1589498842164.png

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

Avatar

Community Advisor

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. 

s_ncs_user_broadcast_report.png

Regards, 

Milan

 

 

Avatar

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

Avatar

Community Advisor
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

Avatar

Level 9
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