Spreadsheet: 180062d1347467989-help-with-of-in-pivot-table-pivot_help
Sheet: Data

State | CPL | Total Leads | Bad Leads | Net Leads | Marketing Spend | % of Total Spend | Contacted | Not Contacted | Quoted | Gross Closed | App Out | Quoted Hot | Quoted Warm | Proj. Close | Contact % | Quoted % | Contact to Quote % | Quote to Close % | Gross Closed % | Proj. Close % | Lead Source
Arizona | 9.09 | 72 | 14 | 58 | 654.48 | 0.054421768707483 | 36 | 22 | 8 | 2 | 1 | 3 | 0 | 4.83 | 0.6206896551724138 | 0.1379310344827586 | 0.2222222222222222 | 0.25 | 0.03448275862068965 | 0.08327586206896552 | Apollo
Arkansas | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Apollo
Colorado | 9.09 | 99 | 10 | 89 | 899.91 | 0.07482993197278912 | 53 | 36 | 11 | 4 | 0 | 1 | 4 | 5.46 | 0.5955056179775281 | 0.1235955056179775 | 0.2075471698113208 | 0.3636363636363636 | 0.0449438202247191 | 0.06134831460674157 | Apollo
Georgia | 9.09 | 143 | 25 | 118 | 1299.87 | 0.1080876795162509 | 60 | 58 | 21 | 5 | 3 | 2 | 2 | 9.27 | 0.5084745762711864 | 0.1779661016949153 | 0.35 | 0.2380952380952381 | 0.0423728813559322 | 0.0785593220338983 | Apollo
Illinois | 9.09 | 53 | 6 | 47 | 481.77 | 0.0400604686318972 | 29 | 18 | 10 | 3 | 2 | 0 | 1 | 4.9 | 0.6170212765957447 | 0.2127659574468085 | 0.3448275862068966 | 0.3 | 0.06382978723404255 | 0.1042553191489362 | Apollo
Indiana | 9.09 | 75 | 18 | 57 | 681.75 | 0.05668934240362812 | 36 | 21 | 19 | 5 | 0 | 0 | 4 | 5.8 | 0.631578947368421 | 0.3333333333333333 | 0.5277777777777778 | 0.2631578947368421 | 0.08771929824561403 | 0.1017543859649123 | Apollo
Iowa | 9.09 | 12 | 3 | 9 | 109.08 | 0.009070294784580499 | 6 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0.6666666666666666 |  |  |  |  |  | Apollo
Kansas | 9.09 | 42 | 6 | 36 | 381.78 | 0.03174603174603174 | 23 | 13 | 10 | 2 | 1 | 0 | 3 | 3.45 | 0.6388888888888888 | 0.2777777777777778 | 0.4347826086956522 | 0.2 | 0.05555555555555555 | 0.09583333333333334 | Apollo
Louisiana | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Apollo
Michigan | 9.09 | 133 | 25 | 108 | 1208.97 | 0.1005291005291005 | 71 | 37 | 22 | 7 | 0 | 2 | 4 | 9.120000000000001 | 0.6574074074074074 | 0.2037037037037037 | 0.3098591549295774 | 0.3181818181818182 | 0.06481481481481481 | 0.08444444444444445 | Apollo
Mississippi | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Apollo
Missouri | 9.09 | 60 | 14 | 46 | 545.4 | 0.04535147392290249 | 31 | 15 | 11 | 3 | 1 | 0 | 0 | 3.85 | 0.6739130434782609 | 0.2391304347826087 | 0.3548387096774194 | 0.2727272727272727 | 0.06521739130434782 | 0.08369565217391305 | Apollo
Nebraska | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Apollo
Nevada | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Apollo
North Carolina | 9.09 | 109 | 20 | 89 | 990.81 | 0.08238851095993953 | 56 | 33 | 21 | 9 | 3 | 0 | 3 | 12.15 | 0.6292134831460674 | 0.2359550561797753 | 0.375 | 0.4285714285714285 | 0.101123595505618 | 0.1365168539325843 | Apollo
Ohio | 9.09 | 119 | 27 | 92 | 1081.71 | 0.08994708994708996 | 53 | 39 | 24 | 2 | 0 | 2 | 2 | 3.72 | 0.5760869565217391 | 0.2608695652173913 | 0.4528301886792453 | 0.08333333333333333 | 0.02173913043478261 | 0.04043478260869565 | Apollo
Oklahoma | 9.09 | 22 | 5 | 17 | 199.98 | 0.01662887377173091 | 13 | 4 | 8 | 2 | 0 | 0 | 1 | 2.2 | 0.7647058823529411 | 0.4705882352941176 | 0.6153846153846154 | 0.25 | 0.1176470588235294 | 0.1294117647058824 | Apollo
Pennsylvania | 9.09 | 191 | 28 | 163 | 1736.19 | 0.1443688586545729 | 91 | 72 | 30 | 7 | 0 | 1 | 5 | 8.66 | 0.558282208588957 | 0.1840490797546012 | 0.3296703296703297 | 0.2333333333333333 | 0.04294478527607362 | 0.05312883435582822 | Apollo
South Carolina | 9.09 | 29 | 7 | 22 | 263.61 | 0.02191987906273621 | 14 | 8 | 6 | 2 | 0 | 1 | 2 | 3.06 | 0.6363636363636364 | 0.2727272727272727 | 0.4285714285714285 | 0.3333333333333333 | 0.09090909090909091 | 0.1390909090909091 | Apollo
Tennessee | 9.09 | 27 | 5 | 22 | 245.43 | 0.02040816326530612 | 12 | 10 | 5 | 2 | 0 | 0 | 0 | 2 | 0.5454545454545454 | 0.2272727272727273 | 0.4166666666666667 | 0.4 | 0.09090909090909091 | 0.09090909090909091 | Apollo
Texas | 9.09 | 60 | 5 | 55 | 545.4 | 0.04535147392290249 | 40 | 15 | 17 | 3 | 0 | 3 | 5 | 5.98 | 0.7272727272727273 | 0.3090909090909091 | 0.425 | 0.1764705882352941 | 0.05454545454545454 | 0.1087272727272727 | Apollo
Utah | 9.09 | 25 | 6 | 19 | 227.25 | 0.01889644746787604 | 14 | 5 | 2 | 0 | 0 | 0 | 0 | 0 | 0.7368421052631579 | 0.1052631578947368 | 0.1428571428571428 |  |  |  | Apollo
Virginia | 9.09 | 52 | 8 | 44 | 472.68 | 0.03930461073318216 | 29 | 15 | 11 | 3 | 0 | 0 | 4 | 3.8 | 0.6590909090909091 | 0.25 | 0.3793103448275862 | 0.2727272727272727 | 0.06818181818181818 | 0.08636363636363636 | Apollo
Arizona | 9.09 | 92 | 12 | 80 | 836.28 | 0.05257142857142857 | 54 | 26 | 16 | 5 | 1 | 0 | 3 | 6.449999999999999 | 0.675 | 0.2 | 0.2962962962962963 | 0.3125 | 0.0625 | 0.08062499999999999 | BW
Arkansas | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | BW
Colorado | 9.09 | 118 | 18 | 100 | 1072.62 | 0.06742857142857142 | 69 | 31 | 23 | 8 | 0 | 0 | 2 | 8.4 | 0.69 | 0.23 | 0.3333333333333333 | 0.3478260869565217 | 0.08 | 0.084 | BW
Georgia | 9.09 | 153 | 23 | 130 | 1390.77 | 0.08742857142857142 | 78 | 52 | 29 | 8 | 1 | 3 | 7 | 12.23 | 0.6 | 0.2230769230769231 | 0.3717948717948718 | 0.2758620689655172 | 0.06153846153846154 | 0.09407692307692309 | BW
Illinois | 9.09 | 126 | 20 | 106 | 1145.34 | 0.072 | 76 | 30 | 21 | 4 | 2 | 1 | 5 | 7.36 | 0.7169811320754716 | 0.1981132075471698 | 0.2763157894736842 | 0.1904761904761905 | 0.03773584905660377 | 0.06943396226415095 | BW
Indiana | 9.09 | 14 | 2 | 12 | 127.26 | 0.008 | 11 | 1 | 3 | 0 | 1 | 0 | 1 | 1.05 | 0.9166666666666666 | 0.25 | 0.2727272727272727 |  |  | 0.08750000000000001 | BW
Iowa | 9.09 | 7 | 1 | 6 | 63.63 | 0.004 | 6 | 0 | 2 | 1 | 0 | 0 | 1 | 1.2 | 1 | 0.3333333333333333 | 0.3333333333333333 | 0.5 | 0.1666666666666667 | 0.2 | BW
Kansas | 9.09 | 43 | 9 | 34 | 390.87 | 0.02457142857142857 | 25 | 9 | 11 | 3 | 1 | 0 | 3 | 4.45 | 0.7352941176470589 | 0.3235294117647059 | 0.44 | 0.2727272727272727 | 0.08823529411764706 | 0.1308823529411765 | BW
Louisiana | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | BW
Michigan | 9.09 | 131 | 23 | 108 | 1190.79 | 0.07485714285714286 | 61 | 47 | 14 | 3 | 0 | 1 | 2 | 4.06 | 0.5648148148148148 | 0.1296296296296296 | 0.2295081967213115 | 0.2142857142857143 | 0.02777777777777778 | 0.03759259259259259 | BW
Mississippi | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | BW
Missouri | 9.09 | 103 | 15 | 88 | 936.27 | 0.05885714285714286 | 58 | 30 | 21 | 3 | 0 | 4 | 4 | 6.44 | 0.6590909090909091 | 0.2386363636363636 | 0.3620689655172414 | 0.1428571428571428 | 0.03409090909090909 | 0.07318181818181818 | BW
Nebraska | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | BW
Nevada | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | BW
North Carolina | 9.09 | 88 | 13 | 75 | 799.92 | 0.05028571428571428 | 46 | 29 | 13 | 5 | 0 | 0 | 2 | 5.4 | 0.6133333333333333 | 0.1733333333333333 | 0.2826086956521739 | 0.3846153846153846 | 0.06666666666666667 | 0.07200000000000001 | BW
Ohio | 9.09 | 168 | 23 | 145 | 1527.12 | 0.09599999999999999 | 90 | 55 | 34 | 9 | 0 | 1 | 12 | 12.06 | 0.6206896551724138 | 0.2344827586206897 | 0.3777777777777778 | 0.2647058823529412 | 0.06206896551724138 | 0.08317241379310346 | BW
Oklahoma | 9.09 | 44 | 9 | 35 | 399.96 | 0.02514285714285714 | 23 | 12 | 12 | 3 | 0 | 0 | 2 | 3.4 | 0.6571428571428571 | 0.3428571428571429 | 0.5217391304347826 | 0.25 | 0.08571428571428572 | 0.09714285714285714 | BW
Pennsylvania | 9.09 | 238 | 35 | 203 | 2163.42 | 0.136 | 119 | 84 | 41 | 14 | 1 | 5 | 10 | 20.15 | 0.5862068965517241 | 0.2019704433497537 | 0.3445378151260504 | 0.3414634146341464 | 0.06896551724137931 | 0.09926108374384236 | BW
South Carolina | 9.09 | 25 | 3 | 22 | 227.25 | 0.01428571428571429 | 9 | 13 | 2 | 1 | 0 | 0 | 0 | 1 | 0.4090909090909091 | 0.09090909090909091 | 0.2222222222222222 | 0.5 | 0.04545454545454546 | 0.04545454545454546 | BW
Tennessee | 9.09 | 112 | 13 | 99 | 1018.08 | 0.064 | 71 | 28 | 26 | 5 | 2 | 2 | 3 | 8.62 | 0.7171717171717171 | 0.2626262626262627 | 0.3661971830985916 | 0.1923076923076923 | 0.0505050505050505 | 0.08707070707070706 | BW
Texas | 9.09 | 204 | 33 | 171 | 1854.36 | 0.1165714285714286 | 111 | 60 | 33 | 9 | 4 | 5 | 8 | 17.3 | 0.6491228070175439 | 0.1929824561403509 | 0.2972972972972973 | 0.2727272727272727 | 0.05263157894736842 | 0.1011695906432749 | BW
Utah | 9.09 | 11 | 5 | 6 | 99.99 | 0.006285714285714285 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3333333333333333 |  |  |  |  |  | BW
Virginia | 9.09 | 73 | 11 | 62 | 663.5699999999999 | 0.04171428571428571 | 42 | 20 | 10 | 4 | 3 | 1 | 0 | 7.21 | 0.6774193548387096 | 0.1612903225806452 | 0.2380952380952381 | 0.4 | 0.06451612903225806 | 0.1162903225806452 | BW
Arizona | 9.09 | 62 | 7 | 55 | 563.58 | 0.02474062250598564 | 36 | 19 | 11 | 2 | 2 | 2 | 2 | 5.420000000000001 | 0.6545454545454545 | 0.2 | 0.3055555555555556 | 0.1818181818181818 | 0.03636363636363636 | 0.09854545454545456 | HP1
Arkansas | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | HP1
Colorado | 9.09 | 186 | 22 | 164 | 1690.74 | 0.0742218675179569 | 110 | 54 | 31 | 4 | 7 | 1 | 6 | 11.81 | 0.6707317073170732 | 0.1890243902439024 | 0.2818181818181818 | 0.1290322580645161 | 0.02439024390243903 | 0.07201219512195121 | HP1
Georgia | 9.09 | 157 | 19 | 138 | 1427.13 | 0.06264964086193135 | 90 | 48 | 12 | 4 | 0 | 1 | 4 | 5.46 | 0.6521739130434783 | 0.08695652173913043 | 0.1333333333333333 | 0.3333333333333333 | 0.02898550724637681 | 0.03956521739130435 | HP1
Illinois | 9.09 | 291 | 53 | 238 | 2645.19 | 0.116121308858739 | 152 | 86 | 30 | 8 | 0 | 2 | 7 | 10.72 | 0.6386554621848739 | 0.1260504201680672 | 0.1973684210526316 | 0.2666666666666667 | 0.03361344537815126 | 0.04504201680672269 | HP1
Indiana | 9.09 | 272 | 38 | 234 | 2472.48 | 0.1085395051875499 | 167 | 67 | 50 | 11 | 1 | 4 | 11 | 16.69 | 0.7136752136752137 | 0.2136752136752137 | 0.2994011976047904 | 0.22 | 0.04700854700854701 | 0.07132478632478632 | HP1
Iowa | 9.09 | 47 | 7 | 40 | 427.23 | 0.01875498802873105 | 27 | 13 | 8 | 2 | 2 | 1 | 1 | 4.56 | 0.675 | 0.2 | 0.2962962962962963 | 0.25 | 0.05 | 0.114 | HP1
Kansas | 9.09 | 61 | 16 | 45 | 554.49 | 0.024341580207502 | 30 | 15 | 2 | 1 | 0 | 1 | 0 | 1.66 | 0.6666666666666666 | 0.04444444444444445 | 0.06666666666666667 | 0.5 | 0.02222222222222222 | 0.03688888888888889 | HP1
Louisiana | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | HP1
Michigan | 9.09 | 160 | 16 | 144 | 1454.4 | 0.06384676775738228 | 100 | 44 | 25 | 1 | 0 | 4 | 6 | 4.84 | 0.6944444444444444 | 0.1736111111111111 | 0.25 | 0.04 | 0.006944444444444444 | 0.03361111111111111 | HP1
Mississippi | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | HP1
Missouri | 9.09 | 132 | 16 | 116 | 1199.88 | 0.05267358339984038 | 78 | 38 | 28 | 8 | 0 | 0 | 12 | 10.4 | 0.6724137931034483 | 0.2413793103448276 | 0.358974358974359 | 0.2857142857142857 | 0.06896551724137931 | 0.0896551724137931 | HP1
Nebraska | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | HP1
Nevada | 9.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | HP1
North Carolina | 9.09 | 78 | 10 | 68 | 709.02 | 0.03112529928172386 | 46 | 22 | 14 | 3 | 1 | 2 | 4 | 5.97 | 0.6764705882352942 | 0.2058823529411765 | 0.3043478260869565 | 0.2142857142857143 | 0.04411764705882353 | 0.08779411764705881 | HP1
Ohio | 9.09 | 292 | 33 | 259 | 2654.28 | 0.1165203511572226 | 160 | 99 | 30 | 5 | 1 | 2 | 5 | 8.17 | 0.6177606177606177 | 0.1158301158301158 | 0.1875 | 0.1666666666666667 | 0.0193050193050193 | 0.03154440154440154 | HP1
Oklahoma | 9.09 | 34 | 8 | 26 | 309.06 | 0.01356743814844373 | 16 | 10 | 3 | 0 | 1 | 0 | 1 | 1.05 | 0.6153846153846154 | 0.1153846153846154 | 0.1875 |  |  | 0.04038461538461539 | HP1
Pennsylvania | 9.09 | 78 | 12 | 66 | 709.02 | 0.03112529928172386 | 42 | 24 | 11 | 3 | 0 | 0 | 2 | 3.4 | 0.6363636363636364 | 0.1666666666666667 | 0.2619047619047619 | 0.2727272727272727 | 0.04545454545454546 | 0.05151515151515151 | HP1
South Carolina | 9.09 | 43 | 9 | 34 | 390.87 | 0.01715881883479649 | 16 | 18 | 4 | 1 | 0 | 0 | 0 | 1 | 0.4705882352941176 | 0.1176470588235294 | 0.25 | 0.25 | 0.02941176470588235 | 0.02941176470588235 | HP1
Tennessee | 9.09 | 123 | 18 | 105 | 1118.07 | 0.04908220271348763 | 68 | 37 | 20 | 4 | 1 | 0 | 7 | 6.25 | 0.6476190476190476 | 0.1904761904761905 | 0.2941176470588235 | 0.2 | 0.0380952380952381 | 0.05952380952380952 | HP1
Texas | 9.09 | 355 | 43 | 312 | 3226.95 | 0.1416600159616919 | 197 | 115 | 27 | 8 | 3 | 1 | 4 | 12.01 | 0.6314102564102564 | 0.08653846153846154 | 0.1370558375634518 | 0.2962962962962963 | 0.02564102564102564 | 0.03849358974358975 | HP1
Utah | 9.09 | 26 | 4 | 22 | 236.34 | 0.01037509976057462 | 15 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0.6818181818181818 |  |  |  |  |  | HP1
Virginia | 9.09 | 109 | 12 | 97 | 990.81 | 0.04349561053471668 | 61 | 36 | 12 | 7 | 0 | 2 | 0 | 8.32 | 0.6288659793814433 | 0.1237113402061856 | 0.1967213114754098 | 0.5833333333333334 | 0.07216494845360824 | 0.08577319587628866 | HP1