Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Email throughput by domain

1 Accepted Solution
Darren_Bowers
Correct answer by
Community Advisor
Community Advisor

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
Darren_Bowers
Correct answer by
Community Advisor
Community Advisor

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

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

 

 

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