Page MenuHomePhabricator

As an email reporter, I need to know how to pull domain reports in Civi for soft bounces
Open, Needs TriagePublic

Description

We've been seeing some higher than usual bounce rates for yahoo.com domains, as well as a variety of other domains. We reached out to Trilogy to advise on next steps, and we need to provide a longitudinal report from Civi tracking bounces and opens per domain name. Is it possible for me to learn how to pull these reports from Civi, or is this something we need to request via phab only?

Here's a list of the problematic domains we want to track:
Yahoo.com - a little over 2% of this domain bounces, makes up about ~15% share of the total send list

The following domains have a send share lower than 3%, but have higher than 50% bounce rates:
Cox.net
Charter.net
Cfl.rr.com
Tampabay.rr.com
Roadrunner.com
Rochester.rr.com

Blocks
optonline.net - 60% block rate for this domain on a recent send

Event Timeline

KHaggard created this task.Oct 27 2020, 8:05 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 27 2020, 8:05 PM

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?

EYener added a subscriber: RMurthy.Oct 27 2020, 9:35 PM

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?

KHaggard added a comment.EditedOct 28 2020, 1:19 PM

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.