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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Email throughput by domain

Avatar

Level 1

Need an email throughput by domain report

1 Accepted Solution

Avatar

Correct answer by
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

5 Replies

Avatar

Correct answer by
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

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

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?

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

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