You want to build this report by domain group, not domain. Example, RoadRunner no longer exists, it is now part of Spectrum Communications. I will build a mapping for domains -> domain groups to use.

This might be something @EYener could query for you from the civicrm_mailing_provider_data table?

Sure thing we can help with this. Thanks for the ping @Eileenmcnaughton .

@KHaggard is there a particular email send or segment or email or date range this is associated with?

Tagging @RMurthy to assist

@EYener there are quite a few actually. if you take a peek into our stats sheet, you'll notice a few segments that have an unusually high number of blocks (column J) compared to most of the other segments within the same cluster of sends.

For some context, a usual block rate is anywhere under 0.1%.

Some examples of really high blocks are (over 0.5%):

1b_Control_TS-Republican-Age-60plus
R1-1_Control_Endowment
R1-1_Control_LNA-5-9.99
R1-5_Copy-ButtonString-NoButtonStack_LNA-5-9.99

Some examples of fairly high blocks (not alarming but still higher than we usually see - between 0.1 to 0.5%):

1a_Control_TS-Republican-Age-20-59
1_Control_PlannedGiving-NonRcv
1_Control_PlannedGiving-Rcv
R1-1_Control_TS-Age-40-59
R1-2_Design-BadgesTrivia-DidYouKnowStats_TS-Age-40-59
R1-1_Control_LNA-10-34.99
R1-5_Design-BadgesTrivia-DidYouKnowStats_LNA-10-34.99
Some Canadian sends as well

Hope this helps, please let me know if you need further assistance pinpointing the exact sends!

Thanks @MNoorWMF ! So it sounds like we should be looking at the enUS segments only. Has this been for Email2 only? Or should we go back to email1?

US sends from 9/16, 9/30, 10/22, and 10/26 specifically for soft bounces @EYener

Also just want to mention, Moska listed blocks but we're also interested in the higher than expected soft bounce rate we've been seeing lately for Email 2. Especially in this send: 1b_20201026_UnitedStates(US)_English(en)_Email2_Control_TS-Republican-Age-60plus

Thanks!

Also, just wanting to realign on the main issue of this task:
yahoo.com is bouncing at 3% now based on the latest enUS send we deployed, which seems alarming since it's the second most popular domain group in every email send. @EYener is it possible to pull a civi report tracking yahoo specifically?

sp69074332
sp69074334
sp69074335
sp69074336
sp69074338
sp69074316
sp69074317
sp69074321
sp69074324

A 3% is normal for Verizon (aka, AOL/Yahoo). When I see blocks at Verizon it will be 100% soft boucning.

@KHaggard I wanted to circle back on this as it came up as a request in our Asana backlog as well.

Is this still needed? Do you think you would need this on an ongoing basis, or was this a one-off request?

Hi @EYener - thanks for circling back! This was a one-off request that I don't believe we need anymore. However, the main idea of this task was to see if I can learn how to pull a longitudinal report from Civi. If I can learn how to do that, I won't need to loop in multiple stakeholders in order to give Trilogy a report. Is that a possibility?

Thanks, I appreciate that. Confirming that resolving this task makes sense and we can move over to email or Slack about any followups. Thanks!