Page MenuHomePhabricator

Make sure silverpop export does not include endowment donations (except in explicit endowment fields)
Closed, ResolvedPublic2 Estimated Story Points

Description

We heavily use fields like latest_donation_date or highest_native_amount from the silverpop export. Do those fields include endowment donations? Can we make sure the endowment donations are excluded from those fields for legal reasons?

I made a request in T170972 to add a few endowment-specific fields to the export--just to say that it is OK to retain any field which explicitly contains endowment data (i.e. Endowment last donation date).

Marking this normal priority but it will be high come Q2.

Event Timeline

CCogdill_WMF created this task.
XenoRyet changed the point value for this task from 0 to 2.Jul 22 2019, 7:49 PM
XenoRyet moved this task from Triage to Sprint +1 on the Fundraising-Backlog board.

Change 526263 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/tools@master] Use wmf_donor fields for stats to avoid endowment munging

https://gerrit.wikimedia.org/r/526263

Change 526268 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/tools@master] Update latest calcs to avoid endowmnet

https://gerrit.wikimedia.org/r/526268

Change 526263 merged by jenkins-bot:
[wikimedia/fundraising/tools@master] Use wmf_donor fields for stats to avoid endowment munging

https://gerrit.wikimedia.org/r/526263

Change 526268 merged by jenkins-bot:
[wikimedia/fundraising/tools@master] Update latest calcs to avoid endowment

https://gerrit.wikimedia.org/r/526268

Change 526303 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/tools@master] Exclude endowment donations from highest total

https://gerrit.wikimedia.org/r/526303

Change 526568 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/tools@master] Fix missing db name on table join

https://gerrit.wikimedia.org/r/526568

Change 526568 merged by jenkins-bot:
[wikimedia/fundraising/tools@master] Fix missing db name on table join

https://gerrit.wikimedia.org/r/526568

Eileenmcnaughton added a subscriber: Ejegg.

OK - this should be all good now @Ejegg shall we change to 'resolved'?

Change 526303 abandoned by Eileen:
Exclude endowment donations from highest total

Reason:
merged a different change

https://gerrit.wikimedia.org/r/526303