We should setup a trigger when credit card donation rate drop below a campaign-adjusted threshold

RESOLVED FIXED

Status

P1
normal
RESOLVED FIXED
4 years ago
4 years ago

People

(Reporter: davida, Assigned: johns)

Tracking

Details

(Whiteboard: [EOYFR2014][p1])

Attachments

(1 attachment)

(Reporter)

Description

4 years ago
and similarly for paypal donation rate.
Whiteboard: [EOYFR2014][p1]
Created attachment 8536843 [details]
Screen Shot 2014-12-15 at 08.44.25.png

Here's a quick screenshot to show the existing hourly income fluctuation which has been biased to US timezone so far.
It will be overly complex to try and track this automatically alongside predictions for future traffic given how variable these are. 

But as a sensible place we can start, here are the minimum donations by hour of day over the last two weeks, split out by PayPal and Credit Card. If the income drops below these we should definitely be investigating.

https://docs.google.com/a/mozillafoundation.org/spreadsheet/ccc?key=0AnUkMzboH_XAdExtRzY5YmkwcXVfRzhlZjd3Z0hGd0E#gid=0

The truest data source for this is the Totalizer DB which we are pinging frequently anyway.

@jbuck: Can we add another ping that checks the last 60 mins worth of donations against those thresholds in that gdoc?
Flags: needinfo?(jon)
Assignee: nobody → jon

Comment 3

4 years ago
Yerp.
Status: NEW → ASSIGNED
Flags: needinfo?(jon)
(Assignee)

Updated

4 years ago
Assignee: jon → johns
(Assignee)

Comment 4

4 years ago
I'll get a monitor written and added to our current monitoring.
(Assignee)

Comment 5

4 years ago
Here we go:
http://pastebin.mozilla.org/8067360

This is now monitoring and alerting below hourly thresholds(UTC based):

  case ${THECURRENTHOUR} in
    00 )
      PAYPAL_MINIMUM=1100
      CREDITCARD_MINIMUM=300
      ;;
    01 )
      PAYPAL_MINIMUM=800
      CREDITCARD_MINIMUM=300
      ;;
    02 )
      PAYPAL_MINIMUM=800
      CREDITCARD_MINIMUM=300
      ;;
    03 )
      PAYPAL_MINIMUM=500
      CREDITCARD_MINIMUM=300
      ;;
    04 )
      PAYPAL_MINIMUM=500
      CREDITCARD_MINIMUM=100
      ;;
    05 )
      PAYPAL_MINIMUM=500
      CREDITCARD_MINIMUM=100
      ;;
    06 )
      PAYPAL_MINIMUM=500
      CREDITCARD_MINIMUM=100
      ;;
    07 )
      PAYPAL_MINIMUM=500
      CREDITCARD_MINIMUM=100
      ;;
    08 )
      PAYPAL_MINIMUM=500
      CREDITCARD_MINIMUM=100
      ;;
    09 )
      PAYPAL_MINIMUM=500
      CREDITCARD_MINIMUM=100
      ;;
    10 )
      PAYPAL_MINIMUM=500
      CREDITCARD_MINIMUM=100
      ;;
    11 )
      PAYPAL_MINIMUM=500
      CREDITCARD_MINIMUM=100
      ;;
    12 )
      PAYPAL_MINIMUM=600
      CREDITCARD_MINIMUM=200
      ;;
    13 )
      PAYPAL_MINIMUM=600
      CREDITCARD_MINIMUM=200
      ;;
    14 )
      PAYPAL_MINIMUM=1100
      CREDITCARD_MINIMUM=400
      ;;
    15 )
      PAYPAL_MINIMUM=1100
      CREDITCARD_MINIMUM=400
      ;;
    16 )
      PAYPAL_MINIMUM=1100
      CREDITCARD_MINIMUM=400
      ;;
    17 )
      PAYPAL_MINIMUM=1200
      CREDITCARD_MINIMUM=400
      ;;
    18 )
      PAYPAL_MINIMUM=1200
      CREDITCARD_MINIMUM=400
      ;;
    19 )
      PAYPAL_MINIMUM=1200
      CREDITCARD_MINIMUM=400
      ;;
    20 )
      PAYPAL_MINIMUM=1200
      CREDITCARD_MINIMUM=400
      ;;
    21 )
      PAYPAL_MINIMUM=1000
      CREDITCARD_MINIMUM=200
      ;;
    22 )
      PAYPAL_MINIMUM=900
      CREDITCARD_MINIMUM=100
      ;;
    23 )
      PAYPAL_MINIMUM=900
      CREDITCARD_MINIMUM=100
      ;;
Status: ASSIGNED → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.