Noticing records labeled as Ultra Lapsed (status_id 70) when their data indicates that they should actually be Deep Lapsed (status_id 60)
A few CIDs here:
388280
6447251
1509923
6462623
10950427
Description
Description
Related Objects
Related Objects
Event Timeline
Comment Actions
I re-ran the segment update on the first 3 & they all updated to Deep Lapsed so the calculation is correct. It's a long time since we populated these so I can't recall but my best guess is we tweaked the definition after these ones were populated
wmf-cv api4 WMFDonor.update +v donor_segment_id= +v donor_status_id= +w 'id < 1600000' +w 'id > 1500000'
Comment Actions
Running this
wmf-cv api4 WMFDonor.update +v donor_segment_id= +v donor_status_id= +w 'wmf_donor.last_donation_date > "2018-06-30"' +w 'wmf_donor.donor_status_id = 70' +l 1000
seems to be altering them
Comment Actions
OK - I ran through this & cleared all of them out - should be closable now - we have to re-run the population over all donors come 1 July to re-calculate them so that would have caught these then anyway