[16:55:30] <sumanah>	 mwalker: Hi there! I am free for the next 4 hrs in case you wanna write together
[16:58:30] <mwalker>	 sumanah, k; the fundraising cluster seems to be exploding right now; so I'll get back to you on that
[16:58:40] <sumanah>	 Sure!
[19:50:34] <sumanah>	 mwalker: I am going to guess that the cluster is still exploding and thus predict that you will not be available today. I hereby offer my availability on Wed, Thurs, or Fri of this week to work on improving https://www.mediawiki.org/wiki/Requests_for_comment/CentralNotice_Caching_Overhaul_-_Frontend_Proxy .
[20:07:02] <mwalker>	 sumanah, thanks :)
[20:07:11] <sumanah>	 :)
[22:11:49] <awight>	 mwalker: -- Remove contacts who apparently have no contributions
[22:11:59] <awight>	 u sure we want to do that?
[22:12:41] <awight>	 meh, fair enuf
[22:15:23] <mwalker>	 awight, that's a difficult case actually
[22:15:27] <mwalker>	 because we probably don't
[22:15:37] <mwalker>	 but there's a fair number of assumptions around it
[22:15:58] <mwalker>	 ccogdill, ^
[22:16:33] <ccogdill>	 well, Sisolak and I have built that rule into queries in the past
[22:16:35] <awight>	 yr check for is_opt_out = 0 is all I really care about.  Other than that, it's just a question of whether we are spamming these ghost contacts
[22:16:50] <ccogdill>	 the rule, I mean, was that their last donation date couldn’t be blank or null
[22:17:28] <mwalker>	 if you're OK with always having that (for contacts that you want to mailmerge in data) then I can keep them in
[22:18:03] <mwalker>	 it's just something you have to know about the data to not send corrupted looking emails
[22:19:24] <ccogdill>	 do you see any reason we should include someone with no contributions?
[22:19:39] <ccogdill>	 what are the chances one of these people actually donated in the last 2-3 years?
[22:20:06] <awight>	 I have no idea what they're doing in our database.  I assume it's either corrupted data, or MG
[22:20:10] <mwalker>	 I was under the impression we've actually had a few people ask to add themselves to our lists
[22:27:48] <grrrit-wm>	 (PS1) Adamw: opt_out preferences apply to email addresses separately [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/133181
[22:28:21] <grrrit-wm>	 (PS1) Adamw: possibly more efficient to use the integer index [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/133182