Page MenuHomePhabricator

Spike: Let's take a look at recurring
Closed, DuplicatePublic1 Estimated Story Points

Description

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:

  1. Number of recurring subscriptions that should've processed on a given day
  2. Number of recurring subscriptions that did process on a given day
  3. 1 vs. 2

Event Timeline

atgo raised the priority of this task from to Medium.
atgo updated the task description. (Show Details)
atgo edited a custom field.
atgo added subscribers: Aklapper, atgo.
atgo renamed this task from Let's take a look at recurring to Spike: Let's take a look at recurring.Jan 14 2015, 11:43 PM
atgo added a project: Fundraising-Backlog.

@MeganHernandez_WMF did you see if Ellery would be able to look into this? Thanks!

@atgo There is a trello card in with research&data for this. Ellery has not run this yet.