Update RML donors to have status of non-donor in CiviCRM
Closed, ResolvedPublic
Actions

Description

Currently only donors with some form of donation history have segmentation data - this means around 32 million contacts have records & around 8.5 don't - the expectation originally was that the value of adding specific non-donor information to non-donors did not warrant the extra disk usage, back up delay, performance trade offs as we don't do much with them - however, the parent task here has reported it as an issue

Just checking with @Dwisehaupt and it would take around 22GB more disk space to store this data (44GB on the staging server which I believe is the one we will run out of disk on first) and add around 1.5 hours to the restore process.

Is it possible to simply query for 'OR is empty' in Acoustic @KHaggard ?

Related Objects
Search...

Status	Assigned	Task
Resolved	• KHaggard	T363527 New Segmentation Framework not quite usable yet
Resolved	Eileenmcnaughton	T363959 Non-donor status missing records in our segmentation framework
Resolved	• KHaggard	T365534 Update RML donors to have status of non-donor in CiviCRM

Event Timeline

Eileenmcnaughton created this task.May 21 2024, 9:43 PM

Restricted Application removed a project: Patch-For-Review. · View Herald TranscriptMay 21 2024, 9:43 PM

Eileenmcnaughton updated the task description. (Show Details)May 21 2024, 10:00 PM

There are certainly other ways we can isolate Non-donor RML sign-ups in Acoustic, we've done that in the past via "both_funds_latest_donation_date is blank".

I think the expectation from the rest of fr-online was that non-donor status and segment would be updated in Acoustic as well.

So you're saying we ran out of disk space to label these ones?

Well I wouldn't say we ran out of disk space - it's more like adding 22GB to our database will bring forward the time frame in which we need to replace our server / create other work.

We would want to be sure that there is real value in storing this data given the cost

Eileenmcnaughton moved this task from Triage to Current Sprint on the Fundraising-Backlog board.May 22 2024, 12:01 AM

Ah I see. I think it would be worth asking Sheetal and Erica to weigh in on it. I don't think Sheetal has a phab handle yet so tagging @ERoden-WMF

@Eileenmcnaughton @KHaggard @ERoden-WMF
Hi all, jumping in with a suggestion in case it helps: in the past we've only targeted recent RML non donor sign ups, so we could explore adding a time range (past 2 or 3 years sign ups).