@ellery we can try to get this in tech's workflow, but that won't be immediate.

Are you going to pull for the immediate request https://trello.com/c/AEigLFqN/222-low-fundraising-recurring-spot-check?

@ellery ping on the above question

@ellery ping again

I don't know how you guys process recurring payments. Is there documentation on this? If not, I would prefer if whoever knows the most about recurring payments were to tackle some of these questions if this needs to happen before you can make it a regular report.

Caitlin is amazing and has been checking to make sure recurring donations are recurring every 2 weeks. I love that! Adding her to the card to share the query info.

We do still need the recurring analysis on how long recurring donations last.

Here is the query I usually use to check all recurring failures from all gateways:

mysql civicrm -B -e "SELECT * from civicrm_contribution_recur JOIN civicrm_contribution ON civicrm_contribution.contribution_recur_id = civicrm_contribution_recur.id WHERE civicrm_contribution_recur.contribution_status_id = 1 AND civicrm_contribution_recur.end_date IS NULL GROUP BY civicrm_contribution_recur.id DESC HAVING max(civicrm_contribution.receive_date) <= DATE_SUB(NOW(), INTERVAL 1 MONTH) LIMIT 50" > recur.tsv

I spot check transaction IDs on this report to make sure there is an obvious failure reason. They are almost always failures and cancellations of PayPal donations made on the PP side.

Anne asked for a GC-specific search so I came up with the query below. It returns 1932 rows for recurring contribs that failed in 2012 or earlier. I'm not confident this query is correct as I have to guess there have been other mysterious recurring failures since then. Can someone double check this GC query?

mysql civicrm -B -e "SELECT * from civicrm_contribution_recur JOIN civicrm_contribution ON civicrm_contribution.contribution_recur_id = civicrm_contribution_recur.id WHERE civicrm_contribution_recur.contribution_status_id = 1 AND civicrm_contribution_recur.end_date IS NULL AND civicrm_contribution_recur.trxn_id LIKE 'RECURRING GLOBALCOLLECT %' GROUP BY civicrm_contribution_recur.id DESC HAVING max(civicrm_contribution.receive_date) <= DATE_SUB(NOW(), INTERVAL 1 MONTH)" > recurGC.tsv

@atgo if it's sufficient, @Juro2351 now does the biweekly scan I used to do
for both GC and PP. I believe our queries are accurate, so there is a human
looking at this regularly :)

Le vendredi 29 mai 2015, atgo <no-reply@phabricator.wikimedia.org> a écrit :

atgo moved this task to Analysis on the Fundraising-Backlog workboard.

TASK DETAIL

https://phabricator.wikimedia.org/T90630

WORKBOARD

https://phabricator.wikimedia.org/project/board/41/

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: atgo
Cc: CCogdill_WMF, MeganHernandez_WMF, atgo, Aklapper, ellery, cwdent

@EYener does this have any interest beyond just historical for you? If not, would you please close it as 'declined' or 'invalid'?