There was a big test Nov 22 (US only), we started the campaign Dec 2. Let’s make sure we get the right times (because time zones are confusing)
GC sent us the reports of all USD donations created on 12/02 and 12/22 (Amsterdam Time). Reports don’t show private info, only order IDs and amounts. both reports are here:
smb://filesrv1/Fundraising/Tech/Recurring Reports
As part of this, add some SQL queries to the Fun SQL queries page:
- Number of recurring subscriptions that should've processed on a given day
- Number of recurring subscriptions that did process on a given day
- 1 vs. 2