For customers who are NOT in MPR

For customers who are in MPR - No purchase greater than 12 mos

For customers who are in MPR - No purchase within last 12 mos

For customers who are in MPR - 1 purchase in last 12 mos

For customers who are in MPR - 2 purchases in last 12 mos

For customers who are in MPR - Former Silver, 3 Purchases in last 12 mos

For customers who are in MPR - Former Gold (4, 5, 6, 7, 8, 9 orders in last 12 mos)

For customers who are in MPR - Former Platinum (10+ orders in last 12 mos)