← All files for this project · the case study

results.json

{ "data": {  "leads_all": 8000,  "deals_all": 842,  "first_lead": "2017-06-14",  "last_lead": "2018-05-31",  "first_win": "2017-12-05",  "last_win": "2018-11-14" }, "kpi": {  "leads": 5998,  "won": 781,  "rate": 0.1302,  "median_days": 12.0,  "reps": 21 }, "sources": [  {   "source": "Organic search",   "leads": 1736,   "won": 255,   "rate": 0.1469  },  {   "source": "Paid search",   "leads": 1182,   "won": 175,   "rate": 0.1481  },  {   "source": "Social",   "leads": 1051,   "won": 66,   "rate": 0.0628  },  {   "source": "Not recorded",   "leads": 861,   "won": 181,   "rate": 0.2102  },  {   "source": "Direct visit",   "leads": 380,   "won": 54,   "rate": 0.1421  },  {   "source": "Email",   "leads": 347,   "won": 14,   "rate": 0.0403  },  {   "source": "Referral",   "leads": 211,   "won": 24,   "rate": 0.1137  },  {   "source": "Other",   "leads": 114,   "won": 4,   "rate": 0.0351  },  {   "source": "Display ads",   "leads": 75,   "won": 5,   "rate": 0.0667  },  {   "source": "Other ads",   "leads": 41,   "won": 3,   "rate": 0.0732  } ], "curve": [  0.0435,  0.0986,  0.1434,  0.1805,  0.2215,  0.2766,  0.3175,  0.3624,  0.3918,  0.4213,  0.4533,  0.4814,  0.5006,  0.5262,  0.5455,  0.5621,  0.5762,  0.5967,  0.6069,  0.6184,  0.6274,  0.6389,  0.6517,  0.6658,  0.6735,  0.6786,  0.6825,  0.685,  0.6914,  0.6965,  0.7068,  0.7106,  0.7157,  0.7196,  0.7247,  0.735,  0.7388,  0.7452,  0.7516,  0.7529,  0.758,  0.7618,  0.7682,  0.7708,  0.7721,  0.7746,  0.7772,  0.781,  0.7849,  0.7887,  0.7926,  0.7939,  0.7939,  0.7951,  0.7964,  0.8003,  0.8054,  0.8079,  0.8118,  0.8118,  0.8156,  0.8156,  0.8169,  0.8207,  0.8207,  0.822,  0.8246,  0.8246,  0.8259,  0.8284,  0.8297,  0.8297,  0.8335,  0.8361,  0.8387,  0.8412,  0.8438,  0.8464,  0.8464,  0.8489,  0.8515,  0.854,  0.854,  0.854,  0.8579,  0.8604,  0.8617,  0.8656,  0.8681,  0.8681,  0.8681,  0.8694,  0.872,  0.8732,  0.8745,  0.8745,  0.8758,  0.8796,  0.8809,  0.8822,  0.8848,  0.8873,  0.8886,  0.8899,  0.8899,  0.8899,  0.8924,  0.8924,  0.8937,  0.895,  0.8976,  0.9001,  0.9014,  0.9052,  0.9065,  0.9065,  0.9078,  0.9091,  0.9091,  0.9104,  0.9117,  0.9117,  0.9117,  0.9117,  0.9129,  0.9142,  0.9193,  0.9206,  0.9206,  0.9206,  0.9219,  0.9232,  0.9257,  0.9257,  0.927,  0.927,  0.927,  0.9283,  0.9283,  0.9283,  0.9283,  0.9283,  0.9296,  0.9296,  0.9321,  0.9334,  0.9334,  0.9334,  0.9373,  0.9373,  0.9373,  0.9373,  0.9373,  0.9385,  0.9385,  0.9411,  0.9437,  0.9437,  0.9437,  0.9437,  0.9437,  0.9437,  0.9449,  0.9488,  0.9501,  0.9501,  0.9513,  0.9513,  0.9513,  0.9526,  0.9526,  0.9526,  0.9539,  0.9539,  0.9552,  0.9577,  0.9577,  0.9577,  0.959,  0.959,  0.9603 ], "reps": [  {   "rep": "Rep 1",   "won": 128,   "median_days": 11.0  },  {   "rep": "Rep 2",   "won": 77,   "median_days": 9.0  },  {   "rep": "Rep 3",   "won": 71,   "median_days": 10.0  },  {   "rep": "Rep 4",   "won": 63,   "median_days": 9.0  },  {   "rep": "Rep 5",   "won": 56,   "median_days": 8.0  },  {   "rep": "Rep 6",   "won": 55,   "median_days": 11.0  },  {   "rep": "Rep 7",   "won": 54,   "median_days": 12.0  },  {   "rep": "Rep 8",   "won": 49,   "median_days": 14.0  },  {   "rep": "Rep 9",   "won": 48,   "median_days": 13.0  },  {   "rep": "Rep 10",   "won": 32,   "median_days": 9.5  },  {   "rep": "Rep 11",   "won": 30,   "median_days": 15.0  },  {   "rep": "Rep 12",   "won": 23,   "median_days": 77.0  },  {   "rep": "Rep 13",   "won": 23,   "median_days": 6.0  },  {   "rep": "Rep 14",   "won": 23,   "median_days": 66.0  },  {   "rep": "Rep 15",   "won": 22,   "median_days": 17.0  },  {   "rep": "Rep 16",   "won": 9,   "median_days": 148.0  },  {   "rep": "Rep 17",   "won": 6,   "median_days": 98.0  },  {   "rep": "Rep 18",   "won": 6,   "median_days": 208.5  },  {   "rep": "Rep 19",   "won": 4,   "median_days": 150.0  },  {   "rep": "Rep 20",   "won": 1,   "median_days": 306.0  },  {   "rep": "Rep 21",   "won": 1,   "median_days": 175.0  } ], "top5_share": 0.5058, "months": [  {   "month": "2018-01",   "leads": 1141,   "won": 152,   "forecast": null  },  {   "month": "2018-02",   "leads": 1028,   "won": 149,   "forecast": null  },  {   "month": "2018-03",   "leads": 1174,   "won": 167,   "forecast": null  },  {   "month": "2018-04",   "leads": 1352,   "won": 183,   "forecast": 182.4  },  {   "month": "2018-05",   "leads": 1303,   "won": 130,   "forecast": 175.2  } ], "may_gap": 45.2, "stopped": {  "reps": 3,  "by_month": {   "2018-01": 16,   "2018-02": 25,   "2018-03": 23,   "2018-04": 21,   "2018-05": 0  },  "per_month_jan_apr": 21.25 }, "checks": {  "deals_matched": 842,  "duplicate_ids": 0,  "won_before_contact": 1,  "blank_source": 48 }}

{
 "data": {
  "leads_all": 8000,
  "deals_all": 842,
  "first_lead": "2017-06-14",
  "last_lead": "2018-05-31",
  "first_win": "2017-12-05",
  "last_win": "2018-11-14"
 },
 "kpi": {
  "leads": 5998,
  "won": 781,
  "rate": 0.1302,
  "median_days": 12.0,
  "reps": 21
 },
 "sources": [
  {
   "source": "Organic search",
   "leads": 1736,
   "won": 255,
   "rate": 0.1469
  },
  {
   "source": "Paid search",
   "leads": 1182,
   "won": 175,
   "rate": 0.1481
  },
  {
   "source": "Social",
   "leads": 1051,
   "won": 66,
   "rate": 0.0628
  },
  {
   "source": "Not recorded",
   "leads": 861,
   "won": 181,
   "rate": 0.2102
  },
  {
   "source": "Direct visit",
   "leads": 380,
   "won": 54,
   "rate": 0.1421
  },
  {
   "source": "Email",
   "leads": 347,
   "won": 14,
   "rate": 0.0403
  },
  {
   "source": "Referral",
   "leads": 211,
   "won": 24,
   "rate": 0.1137
  },
  {
   "source": "Other",
   "leads": 114,
   "won": 4,
   "rate": 0.0351
  },
  {
   "source": "Display ads",
   "leads": 75,
   "won": 5,
   "rate": 0.0667
  },
  {
   "source": "Other ads",
   "leads": 41,
   "won": 3,
   "rate": 0.0732
  }
 ],
 "curve": [
  0.0435,
  0.0986,
  0.1434,
  0.1805,
  0.2215,
  0.2766,
  0.3175,
  0.3624,
  0.3918,
  0.4213,
  0.4533,
  0.4814,
  0.5006,
  0.5262,
  0.5455,
  0.5621,
  0.5762,
  0.5967,
  0.6069,
  0.6184,
  0.6274,
  0.6389,
  0.6517,
  0.6658,
  0.6735,
  0.6786,
  0.6825,
  0.685,
  0.6914,
  0.6965,
  0.7068,
  0.7106,
  0.7157,
  0.7196,
  0.7247,
  0.735,
  0.7388,
  0.7452,
  0.7516,
  0.7529,
  0.758,
  0.7618,
  0.7682,
  0.7708,
  0.7721,
  0.7746,
  0.7772,
  0.781,
  0.7849,
  0.7887,
  0.7926,
  0.7939,
  0.7939,
  0.7951,
  0.7964,
  0.8003,
  0.8054,
  0.8079,
  0.8118,
  0.8118,
  0.8156,
  0.8156,
  0.8169,
  0.8207,
  0.8207,
  0.822,
  0.8246,
  0.8246,
  0.8259,
  0.8284,
  0.8297,
  0.8297,
  0.8335,
  0.8361,
  0.8387,
  0.8412,
  0.8438,
  0.8464,
  0.8464,
  0.8489,
  0.8515,
  0.854,
  0.854,
  0.854,
  0.8579,
  0.8604,
  0.8617,
  0.8656,
  0.8681,
  0.8681,
  0.8681,
  0.8694,
  0.872,
  0.8732,
  0.8745,
  0.8745,
  0.8758,
  0.8796,
  0.8809,
  0.8822,
  0.8848,
  0.8873,
  0.8886,
  0.8899,
  0.8899,
  0.8899,
  0.8924,
  0.8924,
  0.8937,
  0.895,
  0.8976,
  0.9001,
  0.9014,
  0.9052,
  0.9065,
  0.9065,
  0.9078,
  0.9091,
  0.9091,
  0.9104,
  0.9117,
  0.9117,
  0.9117,
  0.9117,
  0.9129,
  0.9142,
  0.9193,
  0.9206,
  0.9206,
  0.9206,
  0.9219,
  0.9232,
  0.9257,
  0.9257,
  0.927,
  0.927,
  0.927,
  0.9283,
  0.9283,
  0.9283,
  0.9283,
  0.9283,
  0.9296,
  0.9296,
  0.9321,
  0.9334,
  0.9334,
  0.9334,
  0.9373,
  0.9373,
  0.9373,
  0.9373,
  0.9373,
  0.9385,
  0.9385,
  0.9411,
  0.9437,
  0.9437,
  0.9437,
  0.9437,
  0.9437,
  0.9437,
  0.9449,
  0.9488,
  0.9501,
  0.9501,
  0.9513,
  0.9513,
  0.9513,
  0.9526,
  0.9526,
  0.9526,
  0.9539,
  0.9539,
  0.9552,
  0.9577,
  0.9577,
  0.9577,
  0.959,
  0.959,
  0.9603
 ],
 "reps": [
  {
   "rep": "Rep 1",
   "won": 128,
   "median_days": 11.0
  },
  {
   "rep": "Rep 2",
   "won": 77,
   "median_days": 9.0
  },
  {
   "rep": "Rep 3",
   "won": 71,
   "median_days": 10.0
  },
  {
   "rep": "Rep 4",
   "won": 63,
   "median_days": 9.0
  },
  {
   "rep": "Rep 5",
   "won": 56,
   "median_days": 8.0
  },
  {
   "rep": "Rep 6",
   "won": 55,
   "median_days": 11.0
  },
  {
   "rep": "Rep 7",
   "won": 54,
   "median_days": 12.0
  },
  {
   "rep": "Rep 8",
   "won": 49,
   "median_days": 14.0
  },
  {
   "rep": "Rep 9",
   "won": 48,
   "median_days": 13.0
  },
  {
   "rep": "Rep 10",
   "won": 32,
   "median_days": 9.5
  },
  {
   "rep": "Rep 11",
   "won": 30,
   "median_days": 15.0
  },
  {
   "rep": "Rep 12",
   "won": 23,
   "median_days": 77.0
  },
  {
   "rep": "Rep 13",
   "won": 23,
   "median_days": 6.0
  },
  {
   "rep": "Rep 14",
   "won": 23,
   "median_days": 66.0
  },
  {
   "rep": "Rep 15",
   "won": 22,
   "median_days": 17.0
  },
  {
   "rep": "Rep 16",
   "won": 9,
   "median_days": 148.0
  },
  {
   "rep": "Rep 17",
   "won": 6,
   "median_days": 98.0
  },
  {
   "rep": "Rep 18",
   "won": 6,
   "median_days": 208.5
  },
  {
   "rep": "Rep 19",
   "won": 4,
   "median_days": 150.0
  },
  {
   "rep": "Rep 20",
   "won": 1,
   "median_days": 306.0
  },
  {
   "rep": "Rep 21",
   "won": 1,
   "median_days": 175.0
  }
 ],
 "top5_share": 0.5058,
 "months": [
  {
   "month": "2018-01",
   "leads": 1141,
   "won": 152,
   "forecast": null
  },
  {
   "month": "2018-02",
   "leads": 1028,
   "won": 149,
   "forecast": null
  },
  {
   "month": "2018-03",
   "leads": 1174,
   "won": 167,
   "forecast": null
  },
  {
   "month": "2018-04",
   "leads": 1352,
   "won": 183,
   "forecast": 182.4
  },
  {
   "month": "2018-05",
   "leads": 1303,
   "won": 130,
   "forecast": 175.2
  }
 ],
 "may_gap": 45.2,
 "stopped": {
  "reps": 3,
  "by_month": {
   "2018-01": 16,
   "2018-02": 25,
   "2018-03": 23,
   "2018-04": 21,
   "2018-05": 0
  },
  "per_month_jan_apr": 21.25
 },
 "checks": {
  "deals_matched": 842,
  "duplicate_ids": 0,
  "won_before_contact": 1,
  "blank_source": 48
 }
}