Blog

A/B Test

AB Test Sample

AB test

Nosh Mish Mosh

The Nosh Mish Mosh is a recipe and ingredient meal delivery service. They ship the raw materials and you get to cook them at your home!

i.jpg

Nosh Mish Mosh wants to run an experiment to see if we can convince more people to purchase meal plans if we use a more artisanal-looking vegetable selection. We’ve photographed these modern meals with blush tomatoes and graffiti eggplants, but aren’t sure if this strategy will sell enough units to benefit from establishing a business relationship with a new provider.

Nosh Mish Mosh target goal is to get a $1240 more every week.

Task:

1.) Test between changing design(to more artisanal-looking vegetable selection).

  • Null hypothesis: There is no significant difference between the old and new design.
  • Alternative hypothesis: Old and new design are significantly different. Changing to new design will improve sales based on our expected sales increase of $1240.

Details:

  • customer_visits: total number of customers visits our page
  • purchasing_customers: Total number of customers who made a purchased
  • money_spent: List of amounts each customer spent

Data Inspection

In [156]:
import numpy as np
import pandas as pd
from scipy.stats import chi2_contingency
import matplotlib as plt
import seaborn as sns
from matplotlib import pyplot as plt
In [157]:
# List of data
customer_visits = [{'purchased': False, 'clickedthrough': True, 'id': 83421, 'moneyspent': 0, 'name': u'Michael Todd'}, {'purchased': False, 'clickedthrough': True, 'id': 46042, 'moneyspent': 0, 'name': u'Brianna Harmon'}, {'purchased': False, 'clickedthrough': False, 'id': 23766, 'moneyspent': 0, 'name': u'Mario Arnold'}, {'purchased': False, 'clickedthrough': False, 'id': 20859, 'moneyspent': 0, 'name': u'Paul Quinn'}, {'purchased': False, 'clickedthrough': True, 'id': 57771, 'moneyspent': 0, 'name': u'Jerome Moore'}, {'purchased': False, 'clickedthrough': True, 'id': 28993, 'moneyspent': 0, 'name': u'Mark Smith'}, {'purchased': True, 'clickedthrough': True, 'id': 15153, 'moneyspent': 39.01, 'name': u'Jacob Harmon'}, {'purchased': False, 'clickedthrough': False, 'id': 29596, 'moneyspent': 0, 'name': u'Curtis Blanchard'}, {'purchased': True, 'clickedthrough': True, 'id': 74271, 'moneyspent': 10.16, 'name': u'Wayne Potter'}, {'purchased': False, 'clickedthrough': True, 'id': 22627, 'moneyspent': 0, 'name': u'Andrew King'}, {'purchased': False, 'clickedthrough': True, 'id': 88286, 'moneyspent': 0, 'name': u'Brian Marshall'}, {'purchased': False, 'clickedthrough': True, 'id': 66112, 'moneyspent': 0, 'name': u'Nicole Bryan'}, {'purchased': False, 'clickedthrough': False, 'id': 60595, 'moneyspent': 0, 'name': u'Samuel Beck'}, {'purchased': False, 'clickedthrough': True, 'id': 10659, 'moneyspent': 0, 'name': u'Dawn Wallace'}, {'purchased': True, 'clickedthrough': True, 'id': 83489, 'moneyspent': 36.88, 'name': u'Jimmy Carrillo'}, {'purchased': False, 'clickedthrough': True, 'id': 44105, 'moneyspent': 0, 'name': u'Darren Mays'}, {'purchased': True, 'clickedthrough': True, 'id': 33246, 'moneyspent': 23.41, 'name': u'Kara Davis'}, {'purchased': False, 'clickedthrough': True, 'id': 62000, 'moneyspent': 0, 'name': u'Nancy Malone'}, {'purchased': False, 'clickedthrough': False, 'id': 18815, 'moneyspent': 0, 'name': u'Nancy Richmond'}, {'purchased': True, 'clickedthrough': True, 'id': 29847, 'moneyspent': 33.49, 'name': u'Mr. Brett Roberts'}, {'purchased': False, 'clickedthrough': False, 'id': 56146, 'moneyspent': 0, 'name': u'Angie Jones'}, {'purchased': False, 'clickedthrough': True, 'id': 94926, 'moneyspent': 0, 'name': u'Daniel Dixon'}, {'purchased': False, 'clickedthrough': False, 'id': 90193, 'moneyspent': 0, 'name': u'William Franco'}, {'purchased': True, 'clickedthrough': True, 'id': 44561, 'moneyspent': 27.76, 'name': u'Christine Osborne'}, {'purchased': False, 'clickedthrough': True, 'id': 94588, 'moneyspent': 0, 'name': u'Ronald Wright'}, {'purchased': False, 'clickedthrough': True, 'id': 75120, 'moneyspent': 0, 'name': u'Steven Paul'}, {'purchased': False, 'clickedthrough': True, 'id': 93822, 'moneyspent': 0, 'name': u'Danielle Cobb'}, {'purchased': False, 'clickedthrough': True, 'id': 74829, 'moneyspent': 0, 'name': u'Lindsey Haynes'}, {'purchased': False, 'clickedthrough': False, 'id': 33271, 'moneyspent': 0, 'name': u'Lawrence Walker'}, {'purchased': False, 'clickedthrough': True, 'id': 68272, 'moneyspent': 0, 'name': u'Jay Simmons'}, {'purchased': False, 'clickedthrough': False, 'id': 65093, 'moneyspent': 0, 'name': u'Jamie Cardenas'}, {'purchased': False, 'clickedthrough': False, 'id': 81074, 'moneyspent': 0, 'name': u'Ryan Miller'}, {'purchased': False, 'clickedthrough': False, 'id': 11639, 'moneyspent': 0, 'name': u'Kevin Hunter'}, {'purchased': True, 'clickedthrough': True, 'id': 98741, 'moneyspent': 38.6, 'name': u'John Terry MD'}, {'purchased': False, 'clickedthrough': True, 'id': 94756, 'moneyspent': 0, 'name': u'Brenda Jenkins'}, {'purchased': False, 'clickedthrough': True, 'id': 42182, 'moneyspent': 0, 'name': u'Martin Weiss'}, {'purchased': False, 'clickedthrough': True, 'id': 10861, 'moneyspent': 0, 'name': u'Timothy Vasquez'}, {'purchased': False, 'clickedthrough': True, 'id': 53861, 'moneyspent': 0, 'name': u'Lisa Rodriguez'}, {'purchased': False, 'clickedthrough': False, 'id': 52206, 'moneyspent': 0, 'name': u'Anna Burton'}, {'purchased': True, 'clickedthrough': True, 'id': 65040, 'moneyspent': 18.46, 'name': u'Tonya Lane'}, {'purchased': False, 'clickedthrough': False, 'id': 92545, 'moneyspent': 0, 'name': u'Adam Pena'}, {'purchased': False, 'clickedthrough': False, 'id': 22744, 'moneyspent': 0, 'name': u'Michael Harmon'}, {'purchased': False, 'clickedthrough': True, 'id': 99548, 'moneyspent': 0, 'name': u'Jeanette Martin'}, {'purchased': True, 'clickedthrough': True, 'id': 82600, 'moneyspent': 28.9, 'name': u'Megan Chapman'}, {'purchased': False, 'clickedthrough': False, 'id': 69140, 'moneyspent': 0, 'name': u'Michael Hill'}, {'purchased': False, 'clickedthrough': True, 'id': 63803, 'moneyspent': 0, 'name': u'Adam Houston'}, {'purchased': False, 'clickedthrough': True, 'id': 14586, 'moneyspent': 0, 'name': u'Travis Shelton'}, {'purchased': True, 'clickedthrough': True, 'id': 27137, 'moneyspent': 32.53, 'name': u'Eduardo Gillespie DVM'}, {'purchased': False, 'clickedthrough': False, 'id': 54610, 'moneyspent': 0, 'name': u'Crystal Hammond'}, {'purchased': False, 'clickedthrough': False, 'id': 51343, 'moneyspent': 0, 'name': u'George Mata'}, {'purchased': False, 'clickedthrough': True, 'id': 53428, 'moneyspent': 0, 'name': u'Theresa Hebert'}, {'purchased': False, 'clickedthrough': True, 'id': 15189, 'moneyspent': 0, 'name': u'Katherine Clarke'}, {'purchased': False, 'clickedthrough': True, 'id': 96920, 'moneyspent': 0, 'name': u'Angela Silva'}, {'purchased': False, 'clickedthrough': False, 'id': 27274, 'moneyspent': 0, 'name': u'Teresa Henderson'}, {'purchased': True, 'clickedthrough': True, 'id': 78341, 'moneyspent': 7.35, 'name': u'Brian Vasquez'}, {'purchased': False, 'clickedthrough': False, 'id': 55502, 'moneyspent': 0, 'name': u'Carrie Clarke'}, {'purchased': False, 'clickedthrough': True, 'id': 68081, 'moneyspent': 0, 'name': u'Walter Marquez'}, {'purchased': False, 'clickedthrough': True, 'id': 94418, 'moneyspent': 0, 'name': u'Shelby Hicks'}, {'purchased': False, 'clickedthrough': True, 'id': 90470, 'moneyspent': 0, 'name': u'Elizabeth James'}, {'purchased': False, 'clickedthrough': False, 'id': 75069, 'moneyspent': 0, 'name': u'Ashley Barron'}, {'purchased': False, 'clickedthrough': True, 'id': 19094, 'moneyspent': 0, 'name': u'Christopher Vazquez'}, {'purchased': True, 'clickedthrough': True, 'id': 42697, 'moneyspent': 14.81, 'name': u'Marie Williams'}, {'purchased': False, 'clickedthrough': False, 'id': 81395, 'moneyspent': 0, 'name': u'Derrick Johnson'}, {'purchased': False, 'clickedthrough': False, 'id': 17617, 'moneyspent': 0, 'name': u'Andrew Williamson'}, {'purchased': False, 'clickedthrough': False, 'id': 83382, 'moneyspent': 0, 'name': u'Sean Holt'}, {'purchased': False, 'clickedthrough': False, 'id': 30454, 'moneyspent': 0, 'name': u'Richard Williamson'}, {'purchased': False, 'clickedthrough': False, 'id': 41262, 'moneyspent': 0, 'name': u'Joseph Mcclure'}, {'purchased': False, 'clickedthrough': True, 'id': 85205, 'moneyspent': 0, 'name': u'Julie Robertson'}, {'purchased': False, 'clickedthrough': True, 'id': 61766, 'moneyspent': 0, 'name': u'Nathaniel Ramirez'}, {'purchased': False, 'clickedthrough': False, 'id': 21737, 'moneyspent': 0, 'name': u'Samantha Tran'}, {'purchased': False, 'clickedthrough': False, 'id': 85859, 'moneyspent': 0, 'name': u'Donald Martinez'}, {'purchased': False, 'clickedthrough': True, 'id': 51141, 'moneyspent': 0, 'name': u'Jasmine Davis'}, {'purchased': False, 'clickedthrough': False, 'id': 64934, 'moneyspent': 0, 'name': u'Bruce Pierce'}, {'purchased': False, 'clickedthrough': True, 'id': 69804, 'moneyspent': 0, 'name': u'Joseph Bailey'}, {'purchased': False, 'clickedthrough': True, 'id': 35659, 'moneyspent': 0, 'name': u'Jasmine Hester'}, {'purchased': True, 'clickedthrough': True, 'id': 88382, 'moneyspent': 27.57, 'name': u'Cynthia Reynolds'}, {'purchased': True, 'clickedthrough': True, 'id': 99851, 'moneyspent': 15.34, 'name': u'Stephen Mccall'}, {'purchased': False, 'clickedthrough': True, 'id': 70970, 'moneyspent': 0, 'name': u'Bradley Park'}, {'purchased': False, 'clickedthrough': False, 'id': 11803, 'moneyspent': 0, 'name': u'Kyle Smith'}, {'purchased': False, 'clickedthrough': False, 'id': 45422, 'moneyspent': 0, 'name': u'Shelby Ford'}, {'purchased': False, 'clickedthrough': False, 'id': 41088, 'moneyspent': 0, 'name': u'Jennifer Fernandez'}, {'purchased': False, 'clickedthrough': True, 'id': 70766, 'moneyspent': 0, 'name': u'Alejandro Perez'}, {'purchased': False, 'clickedthrough': True, 'id': 54807, 'moneyspent': 0, 'name': u'Chad Snyder'}, {'purchased': False, 'clickedthrough': False, 'id': 32418, 'moneyspent': 0, 'name': u'Elizabeth Adams'}, {'purchased': False, 'clickedthrough': False, 'id': 79746, 'moneyspent': 0, 'name': u'John Miller'}, {'purchased': False, 'clickedthrough': True, 'id': 31778, 'moneyspent': 0, 'name': u'Patrick Ford'}, {'purchased': False, 'clickedthrough': False, 'id': 94094, 'moneyspent': 0, 'name': u'Edward Valdez'}, {'purchased': False, 'clickedthrough': False, 'id': 56900, 'moneyspent': 0, 'name': u'Michael Aguilar'}, {'purchased': False, 'clickedthrough': True, 'id': 79915, 'moneyspent': 0, 'name': u'Tara Cooper'}, {'purchased': False, 'clickedthrough': False, 'id': 66018, 'moneyspent': 0, 'name': u'Garrett Schultz'}, {'purchased': False, 'clickedthrough': True, 'id': 54315, 'moneyspent': 0, 'name': u'Edward Smith'}, {'purchased': False, 'clickedthrough': True, 'id': 93718, 'moneyspent': 0, 'name': u'Betty Richardson DDS'}, {'purchased': False, 'clickedthrough': True, 'id': 70526, 'moneyspent': 0, 'name': u'Jacqueline Mitchell'}, {'purchased': False, 'clickedthrough': False, 'id': 64919, 'moneyspent': 0, 'name': u'Dennis Miles'}, {'purchased': False, 'clickedthrough': True, 'id': 16956, 'moneyspent': 0, 'name': u'Amanda Hamilton'}, {'purchased': False, 'clickedthrough': True, 'id': 87570, 'moneyspent': 0, 'name': u'Deanna Reilly'}, {'purchased': False, 'clickedthrough': True, 'id': 12295, 'moneyspent': 0, 'name': u'Crystal Cruz'}, {'purchased': False, 'clickedthrough': False, 'id': 65227, 'moneyspent': 0, 'name': u'Jerry Strickland'}, {'purchased': False, 'clickedthrough': True, 'id': 94736, 'moneyspent': 0, 'name': u'Abigail Durham'}, {'purchased': False, 'clickedthrough': True, 'id': 52641, 'moneyspent': 0, 'name': u'Emily George'}, {'purchased': False, 'clickedthrough': False, 'id': 14706, 'moneyspent': 0, 'name': u'Jesus Schmidt'}, {'purchased': False, 'clickedthrough': True, 'id': 24306, 'moneyspent': 0, 'name': u'Jennifer Ellis'}, {'purchased': False, 'clickedthrough': False, 'id': 44168, 'moneyspent': 0, 'name': u'Edward Evans'}, {'purchased': False, 'clickedthrough': True, 'id': 11658, 'moneyspent': 0, 'name': u'Lance Pitts'}, {'purchased': False, 'clickedthrough': False, 'id': 98508, 'moneyspent': 0, 'name': u'Sean Gray'}, {'purchased': False, 'clickedthrough': False, 'id': 46763, 'moneyspent': 0, 'name': u'Matthew Sosa'}, {'purchased': True, 'clickedthrough': True, 'id': 16737, 'moneyspent': 19.75, 'name': u'Deborah Abbott'}, {'purchased': False, 'clickedthrough': False, 'id': 81657, 'moneyspent': 0, 'name': u'Michelle Byrd'}, {'purchased': False, 'clickedthrough': False, 'id': 97211, 'moneyspent': 0, 'name': u'Colin Colon'}, {'purchased': False, 'clickedthrough': False, 'id': 98224, 'moneyspent': 0, 'name': u'Rose Miranda'}, {'purchased': False, 'clickedthrough': False, 'id': 91076, 'moneyspent': 0, 'name': u'Ashley Schultz'}, {'purchased': False, 'clickedthrough': True, 'id': 93812, 'moneyspent': 0, 'name': u'Mariah King'}, {'purchased': False, 'clickedthrough': False, 'id': 41588, 'moneyspent': 0, 'name': u'Heather Mclean'}, {'purchased': False, 'clickedthrough': False, 'id': 17888, 'moneyspent': 0, 'name': u'Jacqueline Quinn'}, {'purchased': False, 'clickedthrough': False, 'id': 34787, 'moneyspent': 0, 'name': u'Christian Lambert'}, {'purchased': True, 'clickedthrough': True, 'id': 43643, 'moneyspent': 13.25, 'name': u'Kayla Woodard DVM'}, {'purchased': False, 'clickedthrough': True, 'id': 43941, 'moneyspent': 0, 'name': u'Nicole Cox'}, {'purchased': False, 'clickedthrough': False, 'id': 55727, 'moneyspent': 0, 'name': u'David Arroyo'}, {'purchased': False, 'clickedthrough': False, 'id': 88751, 'moneyspent': 0, 'name': u'Jason Barnett'}, {'purchased': False, 'clickedthrough': True, 'id': 82268, 'moneyspent': 0, 'name': u'Stacey Harris'}, {'purchased': False, 'clickedthrough': False, 'id': 65405, 'moneyspent': 0, 'name': u'Amanda Rollins'}, {'purchased': False, 'clickedthrough': True, 'id': 95163, 'moneyspent': 0, 'name': u'Gabriela Anderson'}, {'purchased': False, 'clickedthrough': False, 'id': 28204, 'moneyspent': 0, 'name': u'Brandon Thompson'}, {'purchased': False, 'clickedthrough': False, 'id': 98640, 'moneyspent': 0, 'name': u'Austin Robles'}, {'purchased': False, 'clickedthrough': False, 'id': 56373, 'moneyspent': 0, 'name': u'Kenneth Hicks'}, {'purchased': False, 'clickedthrough': False, 'id': 13098, 'moneyspent': 0, 'name': u'Natalie Flores'}, {'purchased': False, 'clickedthrough': False, 'id': 43106, 'moneyspent': 0, 'name': u'Timothy Carr'}, {'purchased': True, 'clickedthrough': True, 'id': 58794, 'moneyspent': 23.41, 'name': u'William Jackson'}, {'purchased': False, 'clickedthrough': False, 'id': 65504, 'moneyspent': 0, 'name': u'Brian Hill'}, {'purchased': True, 'clickedthrough': True, 'id': 41269, 'moneyspent': 25.97, 'name': u'James Jackson'}, {'purchased': False, 'clickedthrough': False, 'id': 28525, 'moneyspent': 0, 'name': u'Gregory Craig'}, {'purchased': False, 'clickedthrough': True, 'id': 27632, 'moneyspent': 0, 'name': u'David Campbell'}, {'purchased': False, 'clickedthrough': True, 'id': 51069, 'moneyspent': 0, 'name': u'Michelle Bradley'}, {'purchased': False, 'clickedthrough': False, 'id': 75376, 'moneyspent': 0, 'name': u'Joann Williamson'}, {'purchased': False, 'clickedthrough': True, 'id': 68859, 'moneyspent': 0, 'name': u'Stephanie Carter'}, {'purchased': False, 'clickedthrough': False, 'id': 21812, 'moneyspent': 0, 'name': u'James Oliver'}, {'purchased': False, 'clickedthrough': True, 'id': 10908, 'moneyspent': 0, 'name': u'Priscilla Sanders'}, {'purchased': False, 'clickedthrough': True, 'id': 71219, 'moneyspent': 0, 'name': u'Heidi Olsen'}, {'purchased': True, 'clickedthrough': True, 'id': 33704, 'moneyspent': 9.72, 'name': u'John Reeves'}, {'purchased': True, 'clickedthrough': True, 'id': 12068, 'moneyspent': 9.29, 'name': u'Nathan Todd'}, {'purchased': True, 'clickedthrough': True, 'id': 63934, 'moneyspent': 24.32, 'name': u'Christopher Costa'}, {'purchased': False, 'clickedthrough': False, 'id': 67530, 'moneyspent': 0, 'name': u'Michele King'}, {'purchased': True, 'clickedthrough': True, 'id': 27158, 'moneyspent': 41.78, 'name': u'Eddie Rhodes'}, {'purchased': False, 'clickedthrough': True, 'id': 10475, 'moneyspent': 0, 'name': u'Breanna Murillo'}, {'purchased': True, 'clickedthrough': True, 'id': 20270, 'moneyspent': 36.0, 'name': u'Bethany Luna'}, {'purchased': False, 'clickedthrough': False, 'id': 67855, 'moneyspent': 0, 'name': u'Kaitlyn Richardson'}, {'purchased': False, 'clickedthrough': False, 'id': 66585, 'moneyspent': 0, 'name': u'Arthur Schmitt'}, {'purchased': True, 'clickedthrough': True, 'id': 76525, 'moneyspent': 24.11, 'name': u'Christine Anderson'}, {'purchased': False, 'clickedthrough': False, 'id': 61659, 'moneyspent': 0, 'name': u'Susan Brown'}, {'purchased': True, 'clickedthrough': True, 'id': 50612, 'moneyspent': 41.62, 'name': u'Julian Moreno'}, {'purchased': False, 'clickedthrough': False, 'id': 83878, 'moneyspent': 0, 'name': u'Elizabeth Foster'}, {'purchased': False, 'clickedthrough': True, 'id': 71029, 'moneyspent': 0, 'name': u'Todd Reynolds'}, {'purchased': False, 'clickedthrough': False, 'id': 11310, 'moneyspent': 0, 'name': u'Danielle Savage'}, {'purchased': False, 'clickedthrough': False, 'id': 78539, 'moneyspent': 0, 'name': u'Shannon Cox'}, {'purchased': False, 'clickedthrough': False, 'id': 64145, 'moneyspent': 0, 'name': u'Diana Morgan'}, {'purchased': True, 'clickedthrough': True, 'id': 34188, 'moneyspent': 33.7, 'name': u'Jeffrey Lewis'}, {'purchased': True, 'clickedthrough': True, 'id': 97226, 'moneyspent': 36.69, 'name': u'Jason Ayala'}, {'purchased': False, 'clickedthrough': True, 'id': 11979, 'moneyspent': 0, 'name': u'Edward Carlson'}, {'purchased': False, 'clickedthrough': False, 'id': 30678, 'moneyspent': 0, 'name': u'Christopher Lewis'}, {'purchased': False, 'clickedthrough': False, 'id': 78049, 'moneyspent': 0, 'name': u'Vanessa Simpson'}, {'purchased': False, 'clickedthrough': False, 'id': 23617, 'moneyspent': 0, 'name': u'Tara Reynolds'}, {'purchased': False, 'clickedthrough': True, 'id': 63394, 'moneyspent': 0, 'name': u'Heidi Haas'}, {'purchased': False, 'clickedthrough': True, 'id': 58395, 'moneyspent': 0, 'name': u'Breanna Munoz'}, {'purchased': False, 'clickedthrough': True, 'id': 40579, 'moneyspent': 0, 'name': u'Thomas Nash'}, {'purchased': False, 'clickedthrough': True, 'id': 85584, 'moneyspent': 0, 'name': u'Steven Roy'}, {'purchased': False, 'clickedthrough': False, 'id': 64760, 'moneyspent': 0, 'name': u'Alicia Matthews DDS'}, {'purchased': False, 'clickedthrough': True, 'id': 70407, 'moneyspent': 0, 'name': u'William Wilson'}, {'purchased': True, 'clickedthrough': True, 'id': 59854, 'moneyspent': 31.73, 'name': u'Dustin Lozano'}, {'purchased': True, 'clickedthrough': True, 'id': 72720, 'moneyspent': 43.25, 'name': u'Rhonda Roberts'}, {'purchased': False, 'clickedthrough': False, 'id': 28429, 'moneyspent': 0, 'name': u'Maxwell Norton'}, {'purchased': False, 'clickedthrough': False, 'id': 65447, 'moneyspent': 0, 'name': u'Wendy Wilkinson'}, {'purchased': False, 'clickedthrough': False, 'id': 58949, 'moneyspent': 0, 'name': u'Megan Stone'}, {'purchased': False, 'clickedthrough': True, 'id': 85423, 'moneyspent': 0, 'name': u'Andrew Francis'}, {'purchased': False, 'clickedthrough': False, 'id': 84687, 'moneyspent': 0, 'name': u'Jeremy Allison'}, {'purchased': True, 'clickedthrough': True, 'id': 93768, 'moneyspent': 27.93, 'name': u'Brian Bell'}, {'purchased': False, 'clickedthrough': False, 'id': 52864, 'moneyspent': 0, 'name': u'Morgan Garcia'}, {'purchased': False, 'clickedthrough': True, 'id': 21532, 'moneyspent': 0, 'name': u'Douglas Perez'}, {'purchased': False, 'clickedthrough': True, 'id': 73726, 'moneyspent': 0, 'name': u'Anthony Mccall'}, {'purchased': False, 'clickedthrough': True, 'id': 89626, 'moneyspent': 0, 'name': u'Samuel Brown'}, {'purchased': True, 'clickedthrough': True, 'id': 26287, 'moneyspent': 8.02, 'name': u'Ray Martinez'}, {'purchased': False, 'clickedthrough': True, 'id': 55955, 'moneyspent': 0, 'name': u'Lisa Irwin'}, {'purchased': False, 'clickedthrough': True, 'id': 35130, 'moneyspent': 0, 'name': u'Evan Sullivan'}, {'purchased': False, 'clickedthrough': True, 'id': 39133, 'moneyspent': 0, 'name': u'Brendan Vang'}, {'purchased': False, 'clickedthrough': True, 'id': 99047, 'moneyspent': 0, 'name': u'Stephanie Hughes'}, {'purchased': True, 'clickedthrough': True, 'id': 18592, 'moneyspent': 18.63, 'name': u'David Schwartz'}, {'purchased': False, 'clickedthrough': False, 'id': 84093, 'moneyspent': 0, 'name': u'William Cummings'}, {'purchased': False, 'clickedthrough': True, 'id': 18940, 'moneyspent': 0, 'name': u'Rose Whitehead'}, {'purchased': True, 'clickedthrough': True, 'id': 93396, 'moneyspent': 32.3, 'name': u'Alyssa Floyd'}, {'purchased': False, 'clickedthrough': False, 'id': 76152, 'moneyspent': 0, 'name': u'David Becker'}, {'purchased': False, 'clickedthrough': True, 'id': 40080, 'moneyspent': 0, 'name': u'Paige Barnes'}, {'purchased': False, 'clickedthrough': False, 'id': 17613, 'moneyspent': 0, 'name': u'Drew Flores IV'}, {'purchased': False, 'clickedthrough': True, 'id': 19314, 'moneyspent': 0, 'name': u'Elizabeth Flynn DDS'}, {'purchased': True, 'clickedthrough': True, 'id': 37651, 'moneyspent': 38.58, 'name': u'Brandon York'}, {'purchased': False, 'clickedthrough': False, 'id': 22201, 'moneyspent': 0, 'name': u'Gregory Duncan'}, {'purchased': False, 'clickedthrough': True, 'id': 35718, 'moneyspent': 0, 'name': u'Christopher Lewis'}, {'purchased': False, 'clickedthrough': False, 'id': 35033, 'moneyspent': 0, 'name': u'Charlotte Greene'}, {'purchased': False, 'clickedthrough': False, 'id': 53207, 'moneyspent': 0, 'name': u'Latasha Summers'}, {'purchased': False, 'clickedthrough': True, 'id': 93438, 'moneyspent': 0, 'name': u'Martin Rodriguez'}, {'purchased': False, 'clickedthrough': False, 'id': 82572, 'moneyspent': 0, 'name': u'Emily Carrillo'}, {'purchased': False, 'clickedthrough': False, 'id': 92655, 'moneyspent': 0, 'name': u'David Russell'}, {'purchased': False, 'clickedthrough': True, 'id': 91730, 'moneyspent': 0, 'name': u'Dawn Bond'}, {'purchased': False, 'clickedthrough': True, 'id': 89907, 'moneyspent': 0, 'name': u'Tricia Martinez'}, {'purchased': False, 'clickedthrough': False, 'id': 98049, 'moneyspent': 0, 'name': u'Erica Martinez'}, {'purchased': False, 'clickedthrough': True, 'id': 26466, 'moneyspent': 0, 'name': u'Joanna Hale DVM'}, {'purchased': False, 'clickedthrough': False, 'id': 51770, 'moneyspent': 0, 'name': u'Bianca Boyer'}, {'purchased': True, 'clickedthrough': True, 'id': 49057, 'moneyspent': 15.19, 'name': u'Jamie Howard'}, {'purchased': True, 'clickedthrough': True, 'id': 11813, 'moneyspent': 8.25, 'name': u'Robert Brown'}, {'purchased': False, 'clickedthrough': True, 'id': 16782, 'moneyspent': 0, 'name': u'Tyler Conley'}, {'purchased': False, 'clickedthrough': True, 'id': 18348, 'moneyspent': 0, 'name': u'Emily Davis'}, {'purchased': True, 'clickedthrough': True, 'id': 63406, 'moneyspent': 41.19, 'name': u'Teresa Martin'}, {'purchased': False, 'clickedthrough': False, 'id': 42074, 'moneyspent': 0, 'name': u'Dr. Kathy Turner'}, {'purchased': False, 'clickedthrough': False, 'id': 94350, 'moneyspent': 0, 'name': u'John Johnson'}, {'purchased': False, 'clickedthrough': True, 'id': 63067, 'moneyspent': 0, 'name': u'Melissa Taylor'}, {'purchased': False, 'clickedthrough': False, 'id': 63217, 'moneyspent': 0, 'name': u'Barbara Herring'}, {'purchased': True, 'clickedthrough': True, 'id': 27116, 'moneyspent': 32.47, 'name': u'Debra Elliott'}, {'purchased': True, 'clickedthrough': True, 'id': 31684, 'moneyspent': 36.79, 'name': u'Randy Garza'}, {'purchased': False, 'clickedthrough': True, 'id': 45588, 'moneyspent': 0, 'name': u'John Gonzales'}, {'purchased': False, 'clickedthrough': True, 'id': 76468, 'moneyspent': 0, 'name': u'Robert Bush'}, {'purchased': False, 'clickedthrough': False, 'id': 69738, 'moneyspent': 0, 'name': u'John Miller'}, {'purchased': False, 'clickedthrough': False, 'id': 42678, 'moneyspent': 0, 'name': u'Jessica Washington'}, {'purchased': False, 'clickedthrough': False, 'id': 48242, 'moneyspent': 0, 'name': u'David Rodriguez'}, {'purchased': False, 'clickedthrough': True, 'id': 87062, 'moneyspent': 0, 'name': u'Brianna Murphy'}, {'purchased': False, 'clickedthrough': False, 'id': 81318, 'moneyspent': 0, 'name': u'Mr. Steven Hendrix'}, {'purchased': False, 'clickedthrough': False, 'id': 30991, 'moneyspent': 0, 'name': u'Rhonda Lee'}, {'purchased': False, 'clickedthrough': False, 'id': 75040, 'moneyspent': 0, 'name': u'Megan Nguyen'}, {'purchased': False, 'clickedthrough': False, 'id': 57404, 'moneyspent': 0, 'name': u'Brenda Smith'}, {'purchased': False, 'clickedthrough': False, 'id': 31185, 'moneyspent': 0, 'name': u'Matthew Lewis'}, {'purchased': False, 'clickedthrough': True, 'id': 98288, 'moneyspent': 0, 'name': u'Michelle Lopez'}, {'purchased': False, 'clickedthrough': True, 'id': 98447, 'moneyspent': 0, 'name': u'Sarah Schmidt'}, {'purchased': False, 'clickedthrough': False, 'id': 37610, 'moneyspent': 0, 'name': u'Ryan Stephenson'}, {'purchased': False, 'clickedthrough': False, 'id': 74394, 'moneyspent': 0, 'name': u'Maria Moody'}, {'purchased': True, 'clickedthrough': True, 'id': 39389, 'moneyspent': 42.25, 'name': u'David Martinez'}, {'purchased': False, 'clickedthrough': False, 'id': 51105, 'moneyspent': 0, 'name': u'Andrew Carney'}, {'purchased': True, 'clickedthrough': True, 'id': 86851, 'moneyspent': 10.66, 'name': u'Brandon Young'}, {'purchased': False, 'clickedthrough': True, 'id': 93168, 'moneyspent': 0, 'name': u'Joanne Ingram'}, {'purchased': False, 'clickedthrough': True, 'id': 91502, 'moneyspent': 0, 'name': u'Brooke Smith DDS'}, {'purchased': True, 'clickedthrough': True, 'id': 40319, 'moneyspent': 43.61, 'name': u'Cory Sheppard'}, {'purchased': False, 'clickedthrough': True, 'id': 30791, 'moneyspent': 0, 'name': u'Gary Howard'}, {'purchased': False, 'clickedthrough': True, 'id': 72471, 'moneyspent': 0, 'name': u'James Torres'}, {'purchased': False, 'clickedthrough': True, 'id': 34422, 'moneyspent': 0, 'name': u'Patricia Petersen'}, {'purchased': False, 'clickedthrough': True, 'id': 46647, 'moneyspent': 0, 'name': u'James Johnson'}, {'purchased': False, 'clickedthrough': True, 'id': 75368, 'moneyspent': 0, 'name': u'Sherri Gibbs'}, {'purchased': False, 'clickedthrough': True, 'id': 21748, 'moneyspent': 0, 'name': u'Nicole Torres'}, {'purchased': False, 'clickedthrough': True, 'id': 59490, 'moneyspent': 0, 'name': u'Amanda Lewis'}, {'purchased': False, 'clickedthrough': True, 'id': 74448, 'moneyspent': 0, 'name': u'Sheila May'}, {'purchased': False, 'clickedthrough': False, 'id': 83824, 'moneyspent': 0, 'name': u'Jennifer Williams'}, {'purchased': False, 'clickedthrough': True, 'id': 52185, 'moneyspent': 0, 'name': u'Alyssa Anderson'}, {'purchased': False, 'clickedthrough': False, 'id': 46429, 'moneyspent': 0, 'name': u'Alicia King'}, {'purchased': False, 'clickedthrough': True, 'id': 60836, 'moneyspent': 0, 'name': u'Melissa Schultz'}, {'purchased': False, 'clickedthrough': False, 'id': 55993, 'moneyspent': 0, 'name': u'Andrew Williams'}, {'purchased': False, 'clickedthrough': False, 'id': 91752, 'moneyspent': 0, 'name': u'Lawrence Cruz'}, {'purchased': False, 'clickedthrough': True, 'id': 13152, 'moneyspent': 0, 'name': u'Jared Harrison'}, {'purchased': True, 'clickedthrough': True, 'id': 74692, 'moneyspent': 22.63, 'name': u'Anthony Rojas'}, {'purchased': False, 'clickedthrough': False, 'id': 40132, 'moneyspent': 0, 'name': u'Amanda Wilson'}, {'purchased': False, 'clickedthrough': True, 'id': 12916, 'moneyspent': 0, 'name': u'Christine Long'}, {'purchased': False, 'clickedthrough': True, 'id': 29123, 'moneyspent': 0, 'name': u'Eddie Hunter'}, {'purchased': False, 'clickedthrough': True, 'id': 20040, 'moneyspent': 0, 'name': u'Anthony Taylor'}, {'purchased': False, 'clickedthrough': True, 'id': 64921, 'moneyspent': 0, 'name': u'Michael Robinson'}, {'purchased': False, 'clickedthrough': True, 'id': 23280, 'moneyspent': 0, 'name': u'Amber Manning'}, {'purchased': False, 'clickedthrough': True, 'id': 18803, 'moneyspent': 0, 'name': u'Jordan Warren'}, {'purchased': False, 'clickedthrough': False, 'id': 91304, 'moneyspent': 0, 'name': u'Joseph Leonard'}, {'purchased': False, 'clickedthrough': False, 'id': 32733, 'moneyspent': 0, 'name': u'Brittany Aguilar'}, {'purchased': False, 'clickedthrough': False, 'id': 29799, 'moneyspent': 0, 'name': u'Jennifer Valencia'}, {'purchased': False, 'clickedthrough': False, 'id': 20648, 'moneyspent': 0, 'name': u'Mason Brown'}, {'purchased': False, 'clickedthrough': True, 'id': 49152, 'moneyspent': 0, 'name': u'Laurie Kelly'}, {'purchased': True, 'clickedthrough': True, 'id': 75289, 'moneyspent': 34.35, 'name': u'Michael Hale'}, {'purchased': False, 'clickedthrough': True, 'id': 38619, 'moneyspent': 0, 'name': u'Michelle Gill'}, {'purchased': False, 'clickedthrough': True, 'id': 74895, 'moneyspent': 0, 'name': u'Karen Mason'}, {'purchased': False, 'clickedthrough': False, 'id': 72875, 'moneyspent': 0, 'name': u'Karla Marquez'}, {'purchased': False, 'clickedthrough': False, 'id': 61570, 'moneyspent': 0, 'name': u'Keith Parker'}, {'purchased': False, 'clickedthrough': True, 'id': 67777, 'moneyspent': 0, 'name': u'Paige Williams'}, {'purchased': False, 'clickedthrough': True, 'id': 67674, 'moneyspent': 0, 'name': u'Jennifer Young'}, {'purchased': False, 'clickedthrough': False, 'id': 16009, 'moneyspent': 0, 'name': u'Patrick Mitchell'}, {'purchased': True, 'clickedthrough': True, 'id': 82406, 'moneyspent': 34.74, 'name': u'Michelle Rodriguez'}, {'purchased': False, 'clickedthrough': False, 'id': 73869, 'moneyspent': 0, 'name': u'Robert Phillips'}, {'purchased': True, 'clickedthrough': True, 'id': 16999, 'moneyspent': 42.38, 'name': u'Michael Gordon'}, {'purchased': False, 'clickedthrough': True, 'id': 23942, 'moneyspent': 0, 'name': u'Brian Phillips'}, {'purchased': False, 'clickedthrough': False, 'id': 62115, 'moneyspent': 0, 'name': u'Darrell Mullen'}, {'purchased': True, 'clickedthrough': True, 'id': 84774, 'moneyspent': 30.83, 'name': u'Edward Alvarado'}, {'purchased': False, 'clickedthrough': False, 'id': 21849, 'moneyspent': 0, 'name': u'Taylor Huynh'}, {'purchased': True, 'clickedthrough': True, 'id': 11283, 'moneyspent': 33.53, 'name': u'Danielle Garcia'}, {'purchased': False, 'clickedthrough': True, 'id': 24754, 'moneyspent': 0, 'name': u'Joan Rodriguez'}, {'purchased': False, 'clickedthrough': True, 'id': 90244, 'moneyspent': 0, 'name': u'Jeff Thompson'}, {'purchased': False, 'clickedthrough': True, 'id': 49753, 'moneyspent': 0, 'name': u'Dawn Perez'}, {'purchased': True, 'clickedthrough': True, 'id': 72460, 'moneyspent': 42.93, 'name': u'Alexa Jones'}, {'purchased': False, 'clickedthrough': True, 'id': 90996, 'moneyspent': 0, 'name': u'Tiffany Harris'}, {'purchased': False, 'clickedthrough': False, 'id': 74821, 'moneyspent': 0, 'name': u'Charles James'}, {'purchased': False, 'clickedthrough': True, 'id': 96647, 'moneyspent': 0, 'name': u'Mark Robinson'}, {'purchased': False, 'clickedthrough': True, 'id': 69043, 'moneyspent': 0, 'name': u'Mark Cole'}, {'purchased': False, 'clickedthrough': False, 'id': 43603, 'moneyspent': 0, 'name': u'Bryan Conley'}, {'purchased': False, 'clickedthrough': True, 'id': 90084, 'moneyspent': 0, 'name': u'Christie Bush'}, {'purchased': True, 'clickedthrough': True, 'id': 83537, 'moneyspent': 7.65, 'name': u'Colton Sanders'}, {'purchased': False, 'clickedthrough': False, 'id': 77169, 'moneyspent': 0, 'name': u'Kara Wilson'}, {'purchased': False, 'clickedthrough': True, 'id': 29544, 'moneyspent': 0, 'name': u'Linda Bonilla'}, {'purchased': True, 'clickedthrough': True, 'id': 15207, 'moneyspent': 12.08, 'name': u'Jacob Smith'}, {'purchased': False, 'clickedthrough': False, 'id': 23923, 'moneyspent': 0, 'name': u'Aaron Wilson'}, {'purchased': False, 'clickedthrough': True, 'id': 27773, 'moneyspent': 0, 'name': u'Madeline Kirby'}, {'purchased': False, 'clickedthrough': True, 'id': 79456, 'moneyspent': 0, 'name': u'Scott Jackson'}, {'purchased': False, 'clickedthrough': False, 'id': 24319, 'moneyspent': 0, 'name': u'Mrs. Emily Mayer MD'}, {'purchased': False, 'clickedthrough': True, 'id': 17710, 'moneyspent': 0, 'name': u'Tracy Bishop'}, {'purchased': False, 'clickedthrough': False, 'id': 78253, 'moneyspent': 0, 'name': u'Andrea Moran'}, {'purchased': False, 'clickedthrough': True, 'id': 40003, 'moneyspent': 0, 'name': u'Brandon Moore'}, {'purchased': False, 'clickedthrough': True, 'id': 98052, 'moneyspent': 0, 'name': u'Robert Richards'}, {'purchased': False, 'clickedthrough': True, 'id': 68944, 'moneyspent': 0, 'name': u'Whitney Hernandez'}, {'purchased': False, 'clickedthrough': True, 'id': 71720, 'moneyspent': 0, 'name': u'Dennis Hendricks'}, {'purchased': True, 'clickedthrough': True, 'id': 20500, 'moneyspent': 42.57, 'name': u'Kristen Russell'}, {'purchased': False, 'clickedthrough': True, 'id': 97193, 'moneyspent': 0, 'name': u'Rebecca Edwards'}, {'purchased': False, 'clickedthrough': False, 'id': 40411, 'moneyspent': 0, 'name': u'Tracey Hart'}, {'purchased': False, 'clickedthrough': False, 'id': 38127, 'moneyspent': 0, 'name': u'Darren Ramirez'}, {'purchased': True, 'clickedthrough': True, 'id': 27754, 'moneyspent': 22.25, 'name': u'Nicole Murphy'}, {'purchased': True, 'clickedthrough': True, 'id': 16681, 'moneyspent': 39.89, 'name': u'Megan Stephenson'}, {'purchased': False, 'clickedthrough': True, 'id': 56614, 'moneyspent': 0, 'name': u'Andrea Daniels'}, {'purchased': False, 'clickedthrough': False, 'id': 45306, 'moneyspent': 0, 'name': u'Elizabeth Proctor'}, {'purchased': True, 'clickedthrough': True, 'id': 37316, 'moneyspent': 23.34, 'name': u'Shane Martin'}, {'purchased': False, 'clickedthrough': True, 'id': 42770, 'moneyspent': 0, 'name': u'Jordan Norris'}, {'purchased': False, 'clickedthrough': False, 'id': 44755, 'moneyspent': 0, 'name': u'Emily Smith'}, {'purchased': True, 'clickedthrough': True, 'id': 86687, 'moneyspent': 8.23, 'name': u'Megan Chapman'}, {'purchased': False, 'clickedthrough': True, 'id': 60299, 'moneyspent': 0, 'name': u'Mary Moreno'}, {'purchased': False, 'clickedthrough': False, 'id': 71893, 'moneyspent': 0, 'name': u'Joshua Garcia'}, {'purchased': False, 'clickedthrough': True, 'id': 68950, 'moneyspent': 0, 'name': u'Kristy Martinez'}, {'purchased': False, 'clickedthrough': True, 'id': 45257, 'moneyspent': 0, 'name': u'Angela Smith'}, {'purchased': False, 'clickedthrough': True, 'id': 98513, 'moneyspent': 0, 'name': u'Alan Pace'}, {'purchased': True, 'clickedthrough': True, 'id': 69448, 'moneyspent': 19.65, 'name': u'Elizabeth Hernandez'}, {'purchased': True, 'clickedthrough': True, 'id': 76935, 'moneyspent': 44.75, 'name': u'Jacob Anderson'}, {'purchased': True, 'clickedthrough': True, 'id': 20830, 'moneyspent': 15.11, 'name': u'Laurie Parks'}, {'purchased': False, 'clickedthrough': True, 'id': 80256, 'moneyspent': 0, 'name': u'Lauren Jones'}, {'purchased': True, 'clickedthrough': True, 'id': 38217, 'moneyspent': 16.31, 'name': u'Kathleen Curtis'}, {'purchased': False, 'clickedthrough': False, 'id': 37323, 'moneyspent': 0, 'name': u'Todd James'}, {'purchased': False, 'clickedthrough': True, 'id': 92701, 'moneyspent': 0, 'name': u'Christopher Brown'}, {'purchased': False, 'clickedthrough': False, 'id': 39080, 'moneyspent': 0, 'name': u'Megan Lewis'}, {'purchased': True, 'clickedthrough': True, 'id': 32143, 'moneyspent': 12.66, 'name': u'Patrick Campbell'}, {'purchased': False, 'clickedthrough': False, 'id': 29620, 'moneyspent': 0, 'name': u'Tyler Berry'}, {'purchased': False, 'clickedthrough': False, 'id': 97935, 'moneyspent': 0, 'name': u'Patrick Wiley'}, {'purchased': False, 'clickedthrough': True, 'id': 23162, 'moneyspent': 0, 'name': u'Debra Rivas'}, {'purchased': False, 'clickedthrough': True, 'id': 17883, 'moneyspent': 0, 'name': u'Michael Ray'}, {'purchased': False, 'clickedthrough': False, 'id': 46384, 'moneyspent': 0, 'name': u'Janet Dixon'}, {'purchased': False, 'clickedthrough': True, 'id': 78782, 'moneyspent': 0, 'name': u'Kevin Johnson'}, {'purchased': False, 'clickedthrough': True, 'id': 39293, 'moneyspent': 0, 'name': u'Amy Stevens'}, {'purchased': False, 'clickedthrough': True, 'id': 94627, 'moneyspent': 0, 'name': u'Lindsay Schmidt'}, {'purchased': False, 'clickedthrough': False, 'id': 80130, 'moneyspent': 0, 'name': u'Kathleen Parker'}, {'purchased': True, 'clickedthrough': True, 'id': 74723, 'moneyspent': 13.18, 'name': u'Casey Robinson'}, {'purchased': False, 'clickedthrough': True, 'id': 35006, 'moneyspent': 0, 'name': u'Michael Simmons'}, {'purchased': False, 'clickedthrough': True, 'id': 78781, 'moneyspent': 0, 'name': u'Nicholas Valenzuela'}, {'purchased': False, 'clickedthrough': False, 'id': 91792, 'moneyspent': 0, 'name': u'Terry Wolfe'}, {'purchased': False, 'clickedthrough': False, 'id': 95362, 'moneyspent': 0, 'name': u'Brandon Allen'}, {'purchased': False, 'clickedthrough': False, 'id': 77117, 'moneyspent': 0, 'name': u'Whitney Willis'}, {'purchased': False, 'clickedthrough': False, 'id': 17330, 'moneyspent': 0, 'name': u'Jamie Black'}, {'purchased': False, 'clickedthrough': True, 'id': 23593, 'moneyspent': 0, 'name': u'Shelby Ferguson'}, {'purchased': False, 'clickedthrough': True, 'id': 11731, 'moneyspent': 0, 'name': u'Brandon Mccarthy'}, {'purchased': False, 'clickedthrough': False, 'id': 52068, 'moneyspent': 0, 'name': u'Noah Davis'}, {'purchased': True, 'clickedthrough': True, 'id': 55714, 'moneyspent': 27.22, 'name': u'Steven Huerta'}, {'purchased': False, 'clickedthrough': False, 'id': 41349, 'moneyspent': 0, 'name': u'Taylor Brooks'}, {'purchased': False, 'clickedthrough': False, 'id': 42710, 'moneyspent': 0, 'name': u'Jodi Wood'}, {'purchased': False, 'clickedthrough': True, 'id': 78911, 'moneyspent': 0, 'name': u'Darlene Archer'}, {'purchased': False, 'clickedthrough': False, 'id': 66936, 'moneyspent': 0, 'name': u'Shane Chavez'}, {'purchased': False, 'clickedthrough': True, 'id': 34161, 'moneyspent': 0, 'name': u'Julie Blair'}, {'purchased': False, 'clickedthrough': False, 'id': 26875, 'moneyspent': 0, 'name': u'Barbara Bishop'}, {'purchased': False, 'clickedthrough': False, 'id': 39156, 'moneyspent': 0, 'name': u'Jennifer Little'}, {'purchased': False, 'clickedthrough': True, 'id': 27049, 'moneyspent': 0, 'name': u'Austin Garcia'}, {'purchased': False, 'clickedthrough': False, 'id': 90162, 'moneyspent': 0, 'name': u'Samuel Hernandez'}, {'purchased': False, 'clickedthrough': True, 'id': 61030, 'moneyspent': 0, 'name': u'Michael Robinson'}, {'purchased': False, 'clickedthrough': False, 'id': 86541, 'moneyspent': 0, 'name': u'Megan Porter'}, {'purchased': False, 'clickedthrough': True, 'id': 74543, 'moneyspent': 0, 'name': u'Kelly Kelley'}, {'purchased': False, 'clickedthrough': False, 'id': 51921, 'moneyspent': 0, 'name': u'Katherine Hernandez'}, {'purchased': True, 'clickedthrough': True, 'id': 38991, 'moneyspent': 16.15, 'name': u'Antonio Page'}, {'purchased': False, 'clickedthrough': False, 'id': 79951, 'moneyspent': 0, 'name': u'Debbie Roach'}, {'purchased': False, 'clickedthrough': True, 'id': 37858, 'moneyspent': 0, 'name': u'Jacob Brooks'}, {'purchased': False, 'clickedthrough': False, 'id': 29230, 'moneyspent': 0, 'name': u'Troy Ward'}, {'purchased': False, 'clickedthrough': False, 'id': 85612, 'moneyspent': 0, 'name': u'Valerie Stuart'}, {'purchased': False, 'clickedthrough': True, 'id': 74577, 'moneyspent': 0, 'name': u'Sydney Jones'}, {'purchased': False, 'clickedthrough': True, 'id': 10686, 'moneyspent': 0, 'name': u'Scott Parker'}, {'purchased': True, 'clickedthrough': True, 'id': 48727, 'moneyspent': 14.6, 'name': u'Mark Manning'}, {'purchased': True, 'clickedthrough': True, 'id': 83641, 'moneyspent': 29.42, 'name': u'Brandy Guzman'}, {'purchased': False, 'clickedthrough': False, 'id': 43070, 'moneyspent': 0, 'name': u'Michael Smith'}, {'purchased': False, 'clickedthrough': False, 'id': 47649, 'moneyspent': 0, 'name': u'Jesse Young'}, {'purchased': False, 'clickedthrough': True, 'id': 14665, 'moneyspent': 0, 'name': u'Valerie Fisher'}, {'purchased': False, 'clickedthrough': True, 'id': 32956, 'moneyspent': 0, 'name': u'Joshua Lewis'}, {'purchased': False, 'clickedthrough': False, 'id': 49207, 'moneyspent': 0, 'name': u'Joel Barnes'}, {'purchased': False, 'clickedthrough': True, 'id': 37075, 'moneyspent': 0, 'name': u'Maria Williams'}, {'purchased': False, 'clickedthrough': False, 'id': 61773, 'moneyspent': 0, 'name': u'Craig Warner'}, {'purchased': True, 'clickedthrough': True, 'id': 98022, 'moneyspent': 42.17, 'name': u'Mrs. Carol Moon'}, {'purchased': False, 'clickedthrough': False, 'id': 22169, 'moneyspent': 0, 'name': u'Claudia Carpenter'}, {'purchased': False, 'clickedthrough': False, 'id': 72572, 'moneyspent': 0, 'name': u'Jay Curtis'}, {'purchased': False, 'clickedthrough': True, 'id': 73014, 'moneyspent': 0, 'name': u'Logan Haynes'}, {'purchased': False, 'clickedthrough': True, 'id': 41567, 'moneyspent': 0, 'name': u'John Romero'}, {'purchased': False, 'clickedthrough': False, 'id': 67591, 'moneyspent': 0, 'name': u'Raymond Hamilton'}, {'purchased': True, 'clickedthrough': True, 'id': 99190, 'moneyspent': 37.42, 'name': u'Patrick Wilson'}, {'purchased': False, 'clickedthrough': False, 'id': 12366, 'moneyspent': 0, 'name': u'Steven Suarez'}, {'purchased': False, 'clickedthrough': True, 'id': 75492, 'moneyspent': 0, 'name': u'Corey Ward'}, {'purchased': True, 'clickedthrough': True, 'id': 78145, 'moneyspent': 20.56, 'name': u'Ian Castaneda'}, {'purchased': True, 'clickedthrough': True, 'id': 51332, 'moneyspent': 39.39, 'name': u'Scott Rosales'}, {'purchased': True, 'clickedthrough': True, 'id': 11924, 'moneyspent': 16.22, 'name': u'Megan Hernandez'}, {'purchased': False, 'clickedthrough': True, 'id': 63050, 'moneyspent': 0, 'name': u'Erica Morris'}, {'purchased': False, 'clickedthrough': True, 'id': 96446, 'moneyspent': 0, 'name': u'Kelly Hebert'}, {'purchased': False, 'clickedthrough': False, 'id': 80227, 'moneyspent': 0, 'name': u'Nicholas Fernandez'}, {'purchased': False, 'clickedthrough': False, 'id': 19968, 'moneyspent': 0, 'name': u'Tanner Garrett'}, {'purchased': False, 'clickedthrough': False, 'id': 82033, 'moneyspent': 0, 'name': u'Kathleen Hudson'}, {'purchased': False, 'clickedthrough': False, 'id': 27420, 'moneyspent': 0, 'name': u'Melody Delgado'}, {'purchased': False, 'clickedthrough': True, 'id': 63575, 'moneyspent': 0, 'name': u'Michael Carlson'}, {'purchased': False, 'clickedthrough': False, 'id': 72892, 'moneyspent': 0, 'name': u'James Ward'}, {'purchased': False, 'clickedthrough': True, 'id': 50187, 'moneyspent': 0, 'name': u'Kimberly Brown'}, {'purchased': False, 'clickedthrough': True, 'id': 51526, 'moneyspent': 0, 'name': u'Beth Richardson'}, {'purchased': False, 'clickedthrough': False, 'id': 33661, 'moneyspent': 0, 'name': u'Brandon Hall'}, {'purchased': False, 'clickedthrough': True, 'id': 39216, 'moneyspent': 0, 'name': u'Christopher Davidson'}, {'purchased': False, 'clickedthrough': True, 'id': 47164, 'moneyspent': 0, 'name': u'Jessica Waters'}, {'purchased': False, 'clickedthrough': True, 'id': 15277, 'moneyspent': 0, 'name': u'Jeffrey Reed'}, {'purchased': False, 'clickedthrough': True, 'id': 46295, 'moneyspent': 0, 'name': u'Nicole Wright'}, {'purchased': False, 'clickedthrough': False, 'id': 15045, 'moneyspent': 0, 'name': u'Kimberly Clark'}, {'purchased': False, 'clickedthrough': False, 'id': 31747, 'moneyspent': 0, 'name': u'Raymond Moore'}, {'purchased': False, 'clickedthrough': False, 'id': 73528, 'moneyspent': 0, 'name': u'Sabrina Potts'}, {'purchased': False, 'clickedthrough': False, 'id': 97374, 'moneyspent': 0, 'name': u'Donald Herman'}, {'purchased': False, 'clickedthrough': True, 'id': 71635, 'moneyspent': 0, 'name': u'Steven Cooper'}, {'purchased': False, 'clickedthrough': False, 'id': 30831, 'moneyspent': 0, 'name': u'Kathryn Harris DDS'}, {'purchased': False, 'clickedthrough': True, 'id': 83061, 'moneyspent': 0, 'name': u'Holly David DDS'}, {'purchased': False, 'clickedthrough': True, 'id': 38254, 'moneyspent': 0, 'name': u'Tyler Wilson'}, {'purchased': False, 'clickedthrough': True, 'id': 63879, 'moneyspent': 0, 'name': u'Shane Bowen'}, {'purchased': True, 'clickedthrough': True, 'id': 52323, 'moneyspent': 20.03, 'name': u'Jennifer Weiss'}, {'purchased': False, 'clickedthrough': True, 'id': 76849, 'moneyspent': 0, 'name': u'Allison Johnson'}, {'purchased': False, 'clickedthrough': True, 'id': 80756, 'moneyspent': 0, 'name': u'Brenda Kerr'}, {'purchased': False, 'clickedthrough': False, 'id': 14052, 'moneyspent': 0, 'name': u'Molly Bautista'}, {'purchased': True, 'clickedthrough': True, 'id': 84737, 'moneyspent': 14.33, 'name': u'James Brooks'}, {'purchased': True, 'clickedthrough': True, 'id': 85695, 'moneyspent': 21.12, 'name': u'Leslie Gonzalez'}, {'purchased': False, 'clickedthrough': False, 'id': 95132, 'moneyspent': 0, 'name': u'James Coleman'}, {'purchased': False, 'clickedthrough': True, 'id': 97115, 'moneyspent': 0, 'name': u'Maria Johns MD'}, {'purchased': False, 'clickedthrough': True, 'id': 62025, 'moneyspent': 0, 'name': u'Jennifer Cervantes'}, {'purchased': False, 'clickedthrough': True, 'id': 14937, 'moneyspent': 0, 'name': u'Karen Jensen'}, {'purchased': False, 'clickedthrough': False, 'id': 48926, 'moneyspent': 0, 'name': u'John Reed'}, {'purchased': False, 'clickedthrough': False, 'id': 19450, 'moneyspent': 0, 'name': u'Craig Anderson'}, {'purchased': False, 'clickedthrough': False, 'id': 15073, 'moneyspent': 0, 'name': u'Alyssa Johnston PhD'}, {'purchased': False, 'clickedthrough': False, 'id': 22088, 'moneyspent': 0, 'name': u'Cheryl Smith'}, {'purchased': False, 'clickedthrough': True, 'id': 51416, 'moneyspent': 0, 'name': u'Steven Martin'}, {'purchased': False, 'clickedthrough': False, 'id': 43922, 'moneyspent': 0, 'name': u'Howard Barker'}, {'purchased': False, 'clickedthrough': False, 'id': 96403, 'moneyspent': 0, 'name': u'Steven Hoffman'}, {'purchased': True, 'clickedthrough': True, 'id': 21327, 'moneyspent': 22.93, 'name': u'Anthony Weaver'}, {'purchased': False, 'clickedthrough': True, 'id': 63726, 'moneyspent': 0, 'name': u'Leonard Parker'}, {'purchased': False, 'clickedthrough': True, 'id': 99766, 'moneyspent': 0, 'name': u'Luke Moore'}, {'purchased': False, 'clickedthrough': True, 'id': 27502, 'moneyspent': 0, 'name': u'Thomas Calhoun'}, {'purchased': False, 'clickedthrough': False, 'id': 14198, 'moneyspent': 0, 'name': u'Andrea Ware'}, {'purchased': False, 'clickedthrough': False, 'id': 75190, 'moneyspent': 0, 'name': u'Jason Wheeler'}, {'purchased': False, 'clickedthrough': False, 'id': 31930, 'moneyspent': 0, 'name': u'Trevor Franklin'}, {'purchased': True, 'clickedthrough': True, 'id': 45099, 'moneyspent': 11.72, 'name': u'Laura Chan'}, {'purchased': False, 'clickedthrough': False, 'id': 63784, 'moneyspent': 0, 'name': u'William Robles'}, {'purchased': False, 'clickedthrough': True, 'id': 27207, 'moneyspent': 0, 'name': u'Crystal Wheeler'}, {'purchased': True, 'clickedthrough': True, 'id': 38479, 'moneyspent': 32.66, 'name': u'Janet Sanders'}, {'purchased': False, 'clickedthrough': True, 'id': 18936, 'moneyspent': 0, 'name': u'Tina Myers'}, {'purchased': False, 'clickedthrough': False, 'id': 61147, 'moneyspent': 0, 'name': u'Tim Jones'}, {'purchased': True, 'clickedthrough': True, 'id': 97786, 'moneyspent': 8.31, 'name': u'Mr. Ryan Roberson'}, {'purchased': False, 'clickedthrough': True, 'id': 55741, 'moneyspent': 0, 'name': u'Amber Mcconnell'}, {'purchased': False, 'clickedthrough': True, 'id': 12230, 'moneyspent': 0, 'name': u'Nicole Young'}, {'purchased': False, 'clickedthrough': False, 'id': 89039, 'moneyspent': 0, 'name': u'Jessica Sosa'}, {'purchased': False, 'clickedthrough': True, 'id': 29244, 'moneyspent': 0, 'name': u'Hector Stanton'}, {'purchased': False, 'clickedthrough': False, 'id': 18958, 'moneyspent': 0, 'name': u'Katherine Rose'}, {'purchased': False, 'clickedthrough': False, 'id': 22665, 'moneyspent': 0, 'name': u'Ryan Gonzales'}, {'purchased': False, 'clickedthrough': False, 'id': 55513, 'moneyspent': 0, 'name': u'Steven Davis'}, {'purchased': False, 'clickedthrough': True, 'id': 12716, 'moneyspent': 0, 'name': u'Troy Flynn'}, {'purchased': True, 'clickedthrough': True, 'id': 95164, 'moneyspent': 22.19, 'name': u'Christine Ho'}, {'purchased': False, 'clickedthrough': True, 'id': 29399, 'moneyspent': 0, 'name': u'Stacy Spence'}, {'purchased': True, 'clickedthrough': True, 'id': 49176, 'moneyspent': 43.04, 'name': u'Curtis Hernandez'}, {'purchased': False, 'clickedthrough': True, 'id': 90278, 'moneyspent': 0, 'name': u'Kathryn Adams'}, {'purchased': True, 'clickedthrough': True, 'id': 55298, 'moneyspent': 15.89, 'name': u'Carl Burns'}, {'purchased': True, 'clickedthrough': True, 'id': 18964, 'moneyspent': 35.35, 'name': u'Jeffery Jackson'}, {'purchased': False, 'clickedthrough': True, 'id': 76590, 'moneyspent': 0, 'name': u'Katrina Garcia'}, {'purchased': False, 'clickedthrough': False, 'id': 50170, 'moneyspent': 0, 'name': u'Charles Nelson'}, {'purchased': False, 'clickedthrough': False, 'id': 37181, 'moneyspent': 0, 'name': u'Grant Pena'}, {'purchased': False, 'clickedthrough': False, 'id': 15578, 'moneyspent': 0, 'name': u'Jesus Waters'}, {'purchased': False, 'clickedthrough': False, 'id': 25113, 'moneyspent': 0, 'name': u'Jason Moore'}, {'purchased': False, 'clickedthrough': False, 'id': 60531, 'moneyspent': 0, 'name': u'Robert Thompson'}, {'purchased': True, 'clickedthrough': True, 'id': 54777, 'moneyspent': 42.04, 'name': u'Timothy Hoffman'}, {'purchased': False, 'clickedthrough': True, 'id': 68915, 'moneyspent': 0, 'name': u'Nicole Obrien'}, {'purchased': True, 'clickedthrough': True, 'id': 45628, 'moneyspent': 26.13, 'name': u'Breanna Parks'}, {'purchased': True, 'clickedthrough': True, 'id': 10694, 'moneyspent': 36.56, 'name': u'Bradley Hill'}, {'purchased': False, 'clickedthrough': True, 'id': 31868, 'moneyspent': 0, 'name': u'Julie Turner'}, {'purchased': True, 'clickedthrough': True, 'id': 60425, 'moneyspent': 11.37, 'name': u'Karen Frazier'}, {'purchased': True, 'clickedthrough': True, 'id': 40456, 'moneyspent': 28.29, 'name': u'Angela Adkins'}, {'purchased': False, 'clickedthrough': False, 'id': 60463, 'moneyspent': 0, 'name': u'Kevin Turner'}, {'purchased': False, 'clickedthrough': True, 'id': 18137, 'moneyspent': 0, 'name': u'John Martinez'}, {'purchased': False, 'clickedthrough': False, 'id': 79300, 'moneyspent': 0, 'name': u'Michael Small'}, {'purchased': True, 'clickedthrough': True, 'id': 48773, 'moneyspent': 37.38, 'name': u'James Goodman'}, {'purchased': True, 'clickedthrough': True, 'id': 26287, 'moneyspent': 12.91, 'name': u'Brenda Fields'}, {'purchased': False, 'clickedthrough': True, 'id': 31398, 'moneyspent': 0, 'name': u'Ray Mcbride'}, {'purchased': False, 'clickedthrough': False, 'id': 71857, 'moneyspent': 0, 'name': u'Dennis Thornton'}, {'purchased': False, 'clickedthrough': False, 'id': 73005, 'moneyspent': 0, 'name': u'Jordan Howard'}, {'purchased': True, 'clickedthrough': True, 'id': 80204, 'moneyspent': 30.73, 'name': u'Kara Dixon'}, {'purchased': True, 'clickedthrough': True, 'id': 89419, 'moneyspent': 44.59, 'name': u'Adam Thompson'}, {'purchased': False, 'clickedthrough': False, 'id': 63103, 'moneyspent': 0, 'name': u'Barbara Oconnor'}, {'purchased': False, 'clickedthrough': True, 'id': 71777, 'moneyspent': 0, 'name': u'Elizabeth Anderson'}, {'purchased': False, 'clickedthrough': True, 'id': 36282, 'moneyspent': 0, 'name': u'Sherry Sims'}, {'purchased': False, 'clickedthrough': True, 'id': 29864, 'moneyspent': 0, 'name': u'Robert Thompson'}, {'purchased': False, 'clickedthrough': True, 'id': 93579, 'moneyspent': 0, 'name': u'James Cooper'}, {'purchased': False, 'clickedthrough': False, 'id': 17559, 'moneyspent': 0, 'name': u'Deborah Chapman'}, {'purchased': True, 'clickedthrough': True, 'id': 42822, 'moneyspent': 38.53, 'name': u'Aaron Hamilton'}, {'purchased': False, 'clickedthrough': False, 'id': 15092, 'moneyspent': 0, 'name': u'Ashley Mccormick'}, {'purchased': False, 'clickedthrough': True, 'id': 52548, 'moneyspent': 0, 'name': u'Lisa Martinez'}, {'purchased': False, 'clickedthrough': True, 'id': 75509, 'moneyspent': 0, 'name': u'Billy Porter'}, {'purchased': False, 'clickedthrough': True, 'id': 15998, 'moneyspent': 0, 'name': u'David Johnson'}, {'purchased': False, 'clickedthrough': False, 'id': 98100, 'moneyspent': 0, 'name': u'Megan Pearson'}, {'purchased': False, 'clickedthrough': False, 'id': 16077, 'moneyspent': 0, 'name': u'Bryan Wallace'}, {'purchased': True, 'clickedthrough': True, 'id': 29577, 'moneyspent': 25.52, 'name': u'Alec Lewis'}, {'purchased': False, 'clickedthrough': False, 'id': 18685, 'moneyspent': 0, 'name': u'John Smith'}, {'purchased': False, 'clickedthrough': True, 'id': 27933, 'moneyspent': 0, 'name': u'Joshua Spears'}]
purchasing_customers = [{'purchased': True, 'clickedthrough': True, 'id': 15153, 'moneyspent': 39.01, 'name': u'Jacob Harmon'}, {'purchased': True, 'clickedthrough': True, 'id': 74271, 'moneyspent': 10.16, 'name': u'Wayne Potter'}, {'purchased': True, 'clickedthrough': True, 'id': 83489, 'moneyspent': 36.88, 'name': u'Jimmy Carrillo'}, {'purchased': True, 'clickedthrough': True, 'id': 33246, 'moneyspent': 23.41, 'name': u'Kara Davis'}, {'purchased': True, 'clickedthrough': True, 'id': 29847, 'moneyspent': 33.49, 'name': u'Mr. Brett Roberts'}, {'purchased': True, 'clickedthrough': True, 'id': 44561, 'moneyspent': 27.76, 'name': u'Christine Osborne'}, {'purchased': True, 'clickedthrough': True, 'id': 98741, 'moneyspent': 38.6, 'name': u'John Terry MD'}, {'purchased': True, 'clickedthrough': True, 'id': 65040, 'moneyspent': 18.46, 'name': u'Tonya Lane'}, {'purchased': True, 'clickedthrough': True, 'id': 82600, 'moneyspent': 28.9, 'name': u'Megan Chapman'}, {'purchased': True, 'clickedthrough': True, 'id': 27137, 'moneyspent': 32.53, 'name': u'Eduardo Gillespie DVM'}, {'purchased': True, 'clickedthrough': True, 'id': 78341, 'moneyspent': 7.35, 'name': u'Brian Vasquez'}, {'purchased': True, 'clickedthrough': True, 'id': 42697, 'moneyspent': 14.81, 'name': u'Marie Williams'}, {'purchased': True, 'clickedthrough': True, 'id': 88382, 'moneyspent': 27.57, 'name': u'Cynthia Reynolds'}, {'purchased': True, 'clickedthrough': True, 'id': 99851, 'moneyspent': 15.34, 'name': u'Stephen Mccall'}, {'purchased': True, 'clickedthrough': True, 'id': 16737, 'moneyspent': 19.75, 'name': u'Deborah Abbott'}, {'purchased': True, 'clickedthrough': True, 'id': 43643, 'moneyspent': 13.25, 'name': u'Kayla Woodard DVM'}, {'purchased': True, 'clickedthrough': True, 'id': 58794, 'moneyspent': 23.41, 'name': u'William Jackson'}, {'purchased': True, 'clickedthrough': True, 'id': 41269, 'moneyspent': 25.97, 'name': u'James Jackson'}, {'purchased': True, 'clickedthrough': True, 'id': 33704, 'moneyspent': 9.72, 'name': u'John Reeves'}, {'purchased': True, 'clickedthrough': True, 'id': 12068, 'moneyspent': 9.29, 'name': u'Nathan Todd'}, {'purchased': True, 'clickedthrough': True, 'id': 63934, 'moneyspent': 24.32, 'name': u'Christopher Costa'}, {'purchased': True, 'clickedthrough': True, 'id': 27158, 'moneyspent': 41.78, 'name': u'Eddie Rhodes'}, {'purchased': True, 'clickedthrough': True, 'id': 20270, 'moneyspent': 36.0, 'name': u'Bethany Luna'}, {'purchased': True, 'clickedthrough': True, 'id': 76525, 'moneyspent': 24.11, 'name': u'Christine Anderson'}, {'purchased': True, 'clickedthrough': True, 'id': 50612, 'moneyspent': 41.62, 'name': u'Julian Moreno'}, {'purchased': True, 'clickedthrough': True, 'id': 34188, 'moneyspent': 33.7, 'name': u'Jeffrey Lewis'}, {'purchased': True, 'clickedthrough': True, 'id': 97226, 'moneyspent': 36.69, 'name': u'Jason Ayala'}, {'purchased': True, 'clickedthrough': True, 'id': 59854, 'moneyspent': 31.73, 'name': u'Dustin Lozano'}, {'purchased': True, 'clickedthrough': True, 'id': 72720, 'moneyspent': 43.25, 'name': u'Rhonda Roberts'}, {'purchased': True, 'clickedthrough': True, 'id': 93768, 'moneyspent': 27.93, 'name': u'Brian Bell'}, {'purchased': True, 'clickedthrough': True, 'id': 26287, 'moneyspent': 8.02, 'name': u'Ray Martinez'}, {'purchased': True, 'clickedthrough': True, 'id': 18592, 'moneyspent': 18.63, 'name': u'David Schwartz'}, {'purchased': True, 'clickedthrough': True, 'id': 93396, 'moneyspent': 32.3, 'name': u'Alyssa Floyd'}, {'purchased': True, 'clickedthrough': True, 'id': 37651, 'moneyspent': 38.58, 'name': u'Brandon York'}, {'purchased': True, 'clickedthrough': True, 'id': 49057, 'moneyspent': 15.19, 'name': u'Jamie Howard'}, {'purchased': True, 'clickedthrough': True, 'id': 11813, 'moneyspent': 8.25, 'name': u'Robert Brown'}, {'purchased': True, 'clickedthrough': True, 'id': 63406, 'moneyspent': 41.19, 'name': u'Teresa Martin'}, {'purchased': True, 'clickedthrough': True, 'id': 27116, 'moneyspent': 32.47, 'name': u'Debra Elliott'}, {'purchased': True, 'clickedthrough': True, 'id': 31684, 'moneyspent': 36.79, 'name': u'Randy Garza'}, {'purchased': True, 'clickedthrough': True, 'id': 39389, 'moneyspent': 42.25, 'name': u'David Martinez'}, {'purchased': True, 'clickedthrough': True, 'id': 86851, 'moneyspent': 10.66, 'name': u'Brandon Young'}, {'purchased': True, 'clickedthrough': True, 'id': 40319, 'moneyspent': 43.61, 'name': u'Cory Sheppard'}, {'purchased': True, 'clickedthrough': True, 'id': 74692, 'moneyspent': 22.63, 'name': u'Anthony Rojas'}, {'purchased': True, 'clickedthrough': True, 'id': 75289, 'moneyspent': 34.35, 'name': u'Michael Hale'}, {'purchased': True, 'clickedthrough': True, 'id': 82406, 'moneyspent': 34.74, 'name': u'Michelle Rodriguez'}, {'purchased': True, 'clickedthrough': True, 'id': 16999, 'moneyspent': 42.38, 'name': u'Michael Gordon'}, {'purchased': True, 'clickedthrough': True, 'id': 84774, 'moneyspent': 30.83, 'name': u'Edward Alvarado'}, {'purchased': True, 'clickedthrough': True, 'id': 11283, 'moneyspent': 33.53, 'name': u'Danielle Garcia'}, {'purchased': True, 'clickedthrough': True, 'id': 72460, 'moneyspent': 42.93, 'name': u'Alexa Jones'}, {'purchased': True, 'clickedthrough': True, 'id': 83537, 'moneyspent': 7.65, 'name': u'Colton Sanders'}, {'purchased': True, 'clickedthrough': True, 'id': 15207, 'moneyspent': 12.08, 'name': u'Jacob Smith'}, {'purchased': True, 'clickedthrough': True, 'id': 20500, 'moneyspent': 42.57, 'name': u'Kristen Russell'}, {'purchased': True, 'clickedthrough': True, 'id': 27754, 'moneyspent': 22.25, 'name': u'Nicole Murphy'}, {'purchased': True, 'clickedthrough': True, 'id': 16681, 'moneyspent': 39.89, 'name': u'Megan Stephenson'}, {'purchased': True, 'clickedthrough': True, 'id': 37316, 'moneyspent': 23.34, 'name': u'Shane Martin'}, {'purchased': True, 'clickedthrough': True, 'id': 86687, 'moneyspent': 8.23, 'name': u'Megan Chapman'}, {'purchased': True, 'clickedthrough': True, 'id': 69448, 'moneyspent': 19.65, 'name': u'Elizabeth Hernandez'}, {'purchased': True, 'clickedthrough': True, 'id': 76935, 'moneyspent': 44.75, 'name': u'Jacob Anderson'}, {'purchased': True, 'clickedthrough': True, 'id': 20830, 'moneyspent': 15.11, 'name': u'Laurie Parks'}, {'purchased': True, 'clickedthrough': True, 'id': 38217, 'moneyspent': 16.31, 'name': u'Kathleen Curtis'}, {'purchased': True, 'clickedthrough': True, 'id': 32143, 'moneyspent': 12.66, 'name': u'Patrick Campbell'}, {'purchased': True, 'clickedthrough': True, 'id': 74723, 'moneyspent': 13.18, 'name': u'Casey Robinson'}, {'purchased': True, 'clickedthrough': True, 'id': 55714, 'moneyspent': 27.22, 'name': u'Steven Huerta'}, {'purchased': True, 'clickedthrough': True, 'id': 38991, 'moneyspent': 16.15, 'name': u'Antonio Page'}, {'purchased': True, 'clickedthrough': True, 'id': 48727, 'moneyspent': 14.6, 'name': u'Mark Manning'}, {'purchased': True, 'clickedthrough': True, 'id': 83641, 'moneyspent': 29.42, 'name': u'Brandy Guzman'}, {'purchased': True, 'clickedthrough': True, 'id': 98022, 'moneyspent': 42.17, 'name': u'Mrs. Carol Moon'}, {'purchased': True, 'clickedthrough': True, 'id': 99190, 'moneyspent': 37.42, 'name': u'Patrick Wilson'}, {'purchased': True, 'clickedthrough': True, 'id': 78145, 'moneyspent': 20.56, 'name': u'Ian Castaneda'}, {'purchased': True, 'clickedthrough': True, 'id': 51332, 'moneyspent': 39.39, 'name': u'Scott Rosales'}, {'purchased': True, 'clickedthrough': True, 'id': 11924, 'moneyspent': 16.22, 'name': u'Megan Hernandez'}, {'purchased': True, 'clickedthrough': True, 'id': 52323, 'moneyspent': 20.03, 'name': u'Jennifer Weiss'}, {'purchased': True, 'clickedthrough': True, 'id': 84737, 'moneyspent': 14.33, 'name': u'James Brooks'}, {'purchased': True, 'clickedthrough': True, 'id': 85695, 'moneyspent': 21.12, 'name': u'Leslie Gonzalez'}, {'purchased': True, 'clickedthrough': True, 'id': 21327, 'moneyspent': 22.93, 'name': u'Anthony Weaver'}, {'purchased': True, 'clickedthrough': True, 'id': 45099, 'moneyspent': 11.72, 'name': u'Laura Chan'}, {'purchased': True, 'clickedthrough': True, 'id': 38479, 'moneyspent': 32.66, 'name': u'Janet Sanders'}, {'purchased': True, 'clickedthrough': True, 'id': 97786, 'moneyspent': 8.31, 'name': u'Mr. Ryan Roberson'}, {'purchased': True, 'clickedthrough': True, 'id': 95164, 'moneyspent': 22.19, 'name': u'Christine Ho'}, {'purchased': True, 'clickedthrough': True, 'id': 49176, 'moneyspent': 43.04, 'name': u'Curtis Hernandez'}, {'purchased': True, 'clickedthrough': True, 'id': 55298, 'moneyspent': 15.89, 'name': u'Carl Burns'}, {'purchased': True, 'clickedthrough': True, 'id': 18964, 'moneyspent': 35.35, 'name': u'Jeffery Jackson'}, {'purchased': True, 'clickedthrough': True, 'id': 54777, 'moneyspent': 42.04, 'name': u'Timothy Hoffman'}, {'purchased': True, 'clickedthrough': True, 'id': 45628, 'moneyspent': 26.13, 'name': u'Breanna Parks'}, {'purchased': True, 'clickedthrough': True, 'id': 10694, 'moneyspent': 36.56, 'name': u'Bradley Hill'}, {'purchased': True, 'clickedthrough': True, 'id': 60425, 'moneyspent': 11.37, 'name': u'Karen Frazier'}, {'purchased': True, 'clickedthrough': True, 'id': 40456, 'moneyspent': 28.29, 'name': u'Angela Adkins'}, {'purchased': True, 'clickedthrough': True, 'id': 48773, 'moneyspent': 37.38, 'name': u'James Goodman'}, {'purchased': True, 'clickedthrough': True, 'id': 26287, 'moneyspent': 12.91, 'name': u'Brenda Fields'}, {'purchased': True, 'clickedthrough': True, 'id': 80204, 'moneyspent': 30.73, 'name': u'Kara Dixon'}, {'purchased': True, 'clickedthrough': True, 'id': 89419, 'moneyspent': 44.59, 'name': u'Adam Thompson'}, {'purchased': True, 'clickedthrough': True, 'id': 42822, 'moneyspent': 38.53, 'name': u'Aaron Hamilton'}, {'purchased': True, 'clickedthrough': True, 'id': 29577, 'moneyspent': 25.52, 'name': u'Alec Lewis'}]
# money_spent = [39.01, 10.16, 36.88, 23.41, 33.49, 27.76, 38.6, 18.46, 28.9, 32.53, 7.35, 14.81, 27.57, 15.34, 19.75, 13.25, 23.41, 25.97, 9.72, 9.29, 24.32, 41.78, 36.0, 24.11, 41.62, 33.7, 36.69, 31.73, 43.25, 27.93, 8.02, 18.63, 32.3, 38.58, 15.19, 8.25, 41.19, 32.47, 36.79, 42.25, 10.66, 43.61, 22.63, 34.35, 34.74, 42.38, 30.83, 33.53, 42.93, 7.65, 12.08, 42.57, 22.25, 39.89, 23.34, 8.23, 19.65, 44.75, 15.11, 16.31, 12.66, 13.18, 27.22, 16.15, 14.6, 29.42, 42.17, 37.42, 20.56, 39.39, 16.22, 20.03, 14.33, 21.12, 22.93, 11.72, 32.66, 8.31, 22.19, 43.04, 15.89, 35.35, 42.04, 26.13, 36.56, 11.37, 28.29, 37.38, 12.91, 30.73, 44.59, 38.53, 25.52]

Convert to data frame

  • customer_visits
In [172]:
customer_visits_df = pd.DataFrame.from_dict(customer_visits) 

customer_visits_df.to_csv (r'test8.csv', index = False, header=True)
print(customer_visits_df.shape)
customer_visits_df.head()

(500, 5)
Out[172]:
purchased clickedthrough id moneyspent name
0 False True 83421 0.0 Michael Todd
1 False True 46042 0.0 Brianna Harmon
2 False False 23766 0.0 Mario Arnold
3 False False 20859 0.0 Paul Quinn
4 False True 57771 0.0 Jerome Moore
  • purchasing_customers
In [174]:
purchasing_customers_df = pd.DataFrame.from_dict(purchasing_customers) 

purchasing_customers_df.to_csv (r'test9.csv', index = False, header=True)
print(purchasing_customers_df.shape)
purchasing_customers_df.head(5)

(93, 5)
Out[174]:
purchased clickedthrough id moneyspent name
0 True True 15153 39.01 Jacob Harmon
1 True True 74271 10.16 Wayne Potter
2 True True 83489 36.88 Jimmy Carrillo
3 True True 33246 23.41 Kara Davis
4 True True 29847 33.49 Mr. Brett Roberts

Determined The Sample Size

In order to get the sample size I need first to get the value of the ff:

  • Baseline Conversation Rate
  • Minimum Detectable Effect(lift)
  • Statatistical Significance Threshold

Baseline

In [177]:
print(' Total number of visits: ' + str(len(customer_visits_df)))
print(' Number of purchased customers: ' +  str(len(purchasing_customers)))


baseline = (len(purchasing_customers) / len
            (customer_visits)) * 100
'Proportion of customers made an order: ' + str(baseline)+'%'  

 Total number of visits: 500
 Number of purchased customers: 93
Out[177]:
'Proportion of customers made an order: 18.6%'

Minimum Detectable Effect(Lift)

Our lift price is 1240$

How many new customers we need to get this $1240 incerease?

The avg of money_spent of a customer is 27 thus we need 46 new customers to get this $1240 increase.

In [180]:
# Frequency of customer
increase_target = 1240

print(' Total money spent of purchased customers: ' + str(round(np.sum(purchasing_customers_df.moneyspent))))
avg_money_spent = np.mean(purchasing_customers_df.moneyspent)
print(' Average money spent: ' + str(round(avg_money_spent)))

new_customer_needed = increase_target / avg_money_spent
print(' Additional customer needed: ' + str(round(new_customer_needed)))

 Total money spent of purchased customers: 2469
 Average money spent: 27
 Additional customer needed: 47
In [183]:
# proportion of customer
target_total_customer = len(purchasing_customers) + new_customer_needed

# old customer plus new_customer_needed
print('We need: ' + str(round(target_total_customer)) + ' total customers')

# This is the proportion of our total customer needed(140) by the total web/customer visits(500)
target_total_customer_pct = round(target_total_customer / len(customer_visits) * 100, 2)
print('Proportion: ' + str(target_total_customer_pct) + str('%'))

We need: 140 total customers
Proportion: 27.94%
In [192]:
# percentage increase from baseline

# what is the increase percentage from 93 purchased to 140 needed to purchase
lift = (target_total_customer_pct - baseline) / baseline * 100
lift
Out[192]:
50.21505376344086

Statatistical Significance Threshold

We’d like to be fairly certain, but this isn’t going to be a million dollar decision, so let’s go with 5%.

In [186]:
Threshold = 0.05

Using Sample Calculator

sample%20calculator.png

Using Power (100 loops over 630 sample size)

In [193]:
# preset values
significance_threshold = 0.05
sample_size = 630
lift = 50.22
baseline_rate = 18.6 / 100
mde_rate = target_total_customer_pct / 100
In [236]:
results = []
pvals = []

for i in range(100):
    
    #simulatedata:
    nosh_old_design = np.random.choice(['yes','no'],size=int(sample_size/2),p=[baseline_rate,1-baseline_rate])
    nosh_new_design = np.random.choice(['yes','no'],size=int(sample_size/2),p=[mde_rate, 1-mde_rate])
    
    # creating datarame for simulated data
    group=['old design']*int(sample_size/2)+['new design']*int(sample_size/2)
    outcome=list(nosh_old_design)+list(nosh_new_design)
    sim_data={"Design":group,"Purchased?":outcome}
    sim_data=pd.DataFrame(sim_data)

    #runthetest
    ab_contingency=pd.crosstab(np.array(sim_data.Design),np.array(sim_data['Purchased?']))
    chi2,pval,dof,expected=chi2_contingency(ab_contingency)
    result=('significant'if pval < significance_threshold else 'not significant')
    pvals.append(pval)
   
    # append the result to our results list here:
    results.append(result)

print(pval)
ab_contingency

0.0026281765401769634
Out[236]:
col_0 no yes
row_0
new design 217 98
old design 251 64
In [212]:
# Showing first 5 results
print(results[0:5])
print(pvals[0:5])

['not significant', 'significant', 'significant', 'significant', 'significant']
[0.06077293155419593, 0.0015078564204969833, 0.0154820158944219, 0.0011539940593066217, 0.0001891089705147716]
In [219]:
sim_data.sample(5)
Out[219]:
Design Purchased?
147 old design no
480 new design yes
168 old design yes
553 new design no
35 old design no

Showing Power Results

Significant proportion over 100 loops

In [220]:
# Turn to np.array
results =  np.array(results)
In [221]:
# divide by 100 times (our for loop size)

print("Proportion of significant results:")
print(np.sum(results == 'significant')/ 100)


print("Proportion of NOT significant results:")
print(np.sum(results == 'not significant')/ 100 )

Proportion of significant results:
0.72
Proportion of NOT significant results:
0.28

P value over 100 trials

The graph shows 72% of our Pvals falls under significant threshold.

In [222]:
plt.figure(figsize=(15,7))
plt.plot(range(100), pvals, label='P-value', marker = 'o')
plt.axhline(y = 0.05, color = 'r', linestyle = '--', label='Pval 0.05')
plt.legend()

plt.xlabel("Number of trials")
plt.title("Power of 630 sample over 100 test trials")
plt.ylabel('Threshold')
Out[222]:
Text(0, 0.5, 'Threshold')

cook12.png

Conclusion

As the final result we got 72% proportion of significant results over 100 trials. There are 72 counts of p values below (0.05).

I am failed to reject the null hypothesis and conclude that the New Design has significant different from Old design thus we can achieved our target increase of $1240 mark by 72%.

Extra’s

Verifying and Checking

In [202]:
# Verify our code
sim_data.sample(5)
Out[202]:
Design Purchased?
77 old design no
276 old design no
311 old design no
290 old design no
16 old design no
In [203]:
# Old Design
# 18.6% made a purchase

sim_data[sim_data['Design'] == 'old design'].groupby('Purchased?').count()
Out[203]:
Design
Purchased?
no 258
yes 57
In [204]:
# Old Design
# 18.6% made a purchased
sim_data_old = sim_data[sim_data['Design'] == 'old design']
sim_data_old_yes = sim_data_old[sim_data_old['Purchased?'] == 'yes']
str(round(len(sim_data_old_yes) / len(sim_data_old) * 100,2)) + '%'
Out[204]:
'18.1%'
In [205]:
# New Design
# 27.94% made a purchased
sim_data[sim_data['Design'] == 'new design'].groupby('Purchased?').count()
Out[205]:
Design
Purchased?
no 228
yes 87
In [206]:
# New Design
# 27.94 made a purchased
sim_data_new = sim_data[sim_data['Design'] == 'new design']
sim_data_new_yes = sim_data_new[sim_data_new['Purchased?'] == 'yes']

print(np.sum(sim_data_new == 'yes'))
str(round(len(sim_data_new_yes) / len(sim_data_new) * 100,2)) + '%'

Design         0
Purchased?    87
dtype: int64
Out[206]:
'27.62%'

Leave a Reply