Written Assignment
tuotuo
Staticalworkbook.xlsxData
| Date | Sales | Holiday | AVERAGE_PRICE | PROMOTION | MEDIA_SPEND_of_competitor | IMP_EMAIL | SP_EMAIL | IMP_PAID_SEARCH | SP_PAID_SEARCH | IMP_ONLINE_DISPLAY | SP_ONLINE_DISPLAY | SP_PRODUCT_SEARCH | IMP_PRODUCT_SEARCH | IMP_TV | SP_TV |
| 1/7/13 | 515554.89222502 | 1 | 30.0015660065 | 4 | 410000 | 863530.201 | 1060.6740767607 | 11037.6195564885 | 10967.001457846 | 11516.0856376188 | 1921.8737900408 | 5870.9528668572 | 7490.8953663622 | 10741.3857535839 | 11751.3643304429 |
| 1/14/13 | 468720.876201344 | 0 | 34.9981650118 | 6 | 1704000 | 777268.56901428 | 981.0538052283 | 10910.4503410009 | 10645.1883665886 | 9724.5056828696 | 1568.8932774772 | 6451.9896666004 | 8147.8140422114 | 11714.5868640253 | 11828.9803138837 |
| 1/21/13 | 398371.080877776 | 1 | 33.7232752692 | 4 | 1951410 | 790764.214374927 | 893.3483841813 | 10825.381689942 | 10924.8262798737 | 9540.6845283394 | 1560.8640314636 | 4800.4841765455 | 6078.2297154461 | 11138.7370388331 | 12850.4336732459 |
| 1/28/13 | 523995.067191106 | 1 | 39.8264793081 | 5 | 4321800 | 838703.706731684 | 983.469360686 | 10975.6778835798 | 10617.4114483457 | 9106.5109728559 | 1541.019282308 | 2555.5368075784 | 3201.4631313183 | 9464.8605890008 | 11075.5266739935 |
| 2/4/13 | 508059.956171809 | 1 | 39.2740286109 | 3 | 429600 | 808247.772589065 | 937.1304320769 | 10667.6233314069 | 10211.63151464 | 8947.1429014516 | 1443.2523469583 | 858.8500145191 | 1084.9026537846 | 8592.6710384069 | 8802.6904950587 |
| 2/11/13 | 524137.474632649 | 0 | 36.3584365361 | 4 | 932874 | 744831.839957317 | 878.9367976908 | 10767.1087447983 | 11748.4227780282 | 10189.9280239784 | 1748.5446224558 | 350.5227456318 | 441.6336738922 | 9229.90359206 | 10286.5089796661 |
| 2/18/13 | 545531.147964955 | 0 | 36.0126864925 | 6 | 3719196 | 764503.244895339 | 965.6889041413 | 13007.77882453 | 13411.2060054486 | 11477.1648649253 | 1838.2359117437 | 2697.1859637402 | 3271.9425365974 | 10451.9437028404 | 11808.0618471095 |
| 2/25/13 | 483418.744214147 | 0 | 38.5161219386 | 7 | 1335000 | 812007.324348953 | 994.7161972637 | 13047.7473355378 | 12978.3038270132 | 11273.9111337347 | 1904.0606320602 | 3561.5218000238 | 4543.9115894848 | 10282.3611086549 | 11204.9447483345 |
| 3/4/13 | 475735.149673611 | 1 | 38.0716161745 | 5 | 480000 | 765341.969637719 | 915.6447595575 | 13188.4188607544 | 13394.8038262559 | 9571.2482396634 | 1508.9677796503 | 3675.9743011656 | 4543.5124860756 | 8284.5441107032 | 9523.0893169646 |
| 3/11/13 | 510531.429430944 | 1 | 35.5449944598 | 4 | 315000 | 829429.846671503 | 1046.9609034214 | 13168.0766825458 | 13494.8327271964 | 8781.1566659712 | 1460.049230834 | 3815.611180563 | 4872.0888804958 | 8725.1145147278 | 9281.9907569721 |
| 3/18/13 | 506087.403347096 | 1 | 30.9896145368 | 7 | 3489000 | 805166.785350185 | 939.1843261167 | 12994.2243287786 | 12936.2802396727 | 9490.699457478 | 1547.253585336 | 4654.9454512447 | 5635.525495561 | 8815.2778448044 | 9320.2985419339 |
| 3/25/13 | 400493.208109798 | 0 | 35.6827523489 | 3 | 3269256 | 809215.806794349 | 969.8765892696 | 10386.8935335245 | 10968.6021232937 | 9748.836075416 | 1542.9349148138 | 2953.6348746177 | 3463.7811175018 | 8299.3319972233 | 9025.2336744267 |
| 4/1/13 | 754760.859840942 | 0 | 38.1658925433 | 5 | 2262000 | 827294.780587674 | 1008.2038414723 | 10461.6161809566 | 9674.5742211707 | 8713.9573577316 | 1422.4892183219 | 4469.1720661573 | 5427.8857668568 | 7655.2714892178 | 8260.9612587352 |
| 4/8/13 | 489428.847267371 | 0 | 33.3206275174 | 6 | 582000 | 803070.475341388 | 964.7474658503 | 10403.1917859683 | 8984.9362576119 | 8693.6461478734 | 1396.7402263773 | 4314.6953486342 | 5073.5399000057 | 7818.8406757062 | 8293.3575237524 |
| 4/15/13 | 465920.836013387 | 0 | 36.7913995601 | 7 | 2210898 | 886351.416032221 | 1064.1486128157 | 10281.2285651726 | 9692.0777666502 | 9489.3820159818 | 1546.0913586422 | 4501.3575665111 | 5346.4002049238 | 9240.8602108456 | 10984.6111988207 |
| 4/22/13 | 496180.575883606 | 0 | 32.626447052 | 6 | 393000 | 803312.14932329 | 932.2607009515 | 10835.7412838245 | 10460.4528861021 | 10210.0844969862 | 1774.2285254058 | 4349.4742966762 | 5250.487968565 | 9650.3224157014 | 10053.712849682 |
| 4/29/13 | 638277.008896307 | 1 | 32.7990553134 | 7 | 330000 | 782868.036821097 | 918.9250836547 | 11093.0058192679 | 10440.9624992597 | 10665.7544258064 | 1716.0946853417 | 4197.60947751 | 4943.9360515198 | 8710.5506944085 | 10198.8768405062 |
| 5/6/13 | 468693.057852264 | 0 | 34.8713976754 | 7 | 3768000 | 872280.925598816 | 977.8489040188 | 11006.486615818 | 10913.5270298301 | 10536.3377193474 | 1741.4267003537 | 3860.1447423742 | 4935.0256127095 | 9017.0573340701 | 9354.3448309831 |
| 5/13/13 | 436272.597710813 | 1 | 31.8738203757 | 2 | 1896000 | 841907.682981009 | 976.542828582 | 10914.7121496143 | 10666.1026446287 | 10362.5842391828 | 1551.5480001743 | 3816.6369636222 | 4985.8601365171 | 8370.1239014718 | 9721.0702744512 |
| 5/20/13 | 578185.610333369 | 0 | 34.8317868374 | 0 | 480000 | 786292.588759836 | 993.3422041865 | 7970.9262256629 | 7713.617429668 | 10152.4202588403 | 1636.2738398411 | 3679.031450543 | 4330.7138695015 | 11032.4165051632 | 12990.8448816801 |
| 5/27/13 | 602874.993175951 | 0 | 36.1356199087 | 3 | 1320000 | 760098.926478791 | 858.6615428698 | 7981.8127404947 | 7646.2039244898 | 9292.5852414525 | 1579.2864802881 | 3834.5393394842 | 5121.5326396337 | 9763.0129510926 | 10721.7715047441 |
| 6/3/13 | 431978.810163336 | 1 | 32.576856134 | 5 | 0 | 765019.664680346 | 966.6642768008 | 8167.6589979869 | 7908.6556147844 | 7843.6368585745 | 1279.0554224039 | 4185.4862623855 | 5181.5711936833 | 8161.5646073956 | 9038.8942131671 |
| 6/10/13 | 555855.2967978 | 0 | 31.2321075988 | 7 | 192000 | 758538.102491876 | 902.3058091426 | 7844.3883727049 | 7367.3361713109 | 8395.3538829532 | 1357.8135788464 | 3920.6402974308 | 4989.5083260595 | 9406.4200486003 | 9956.9537422128 |
| 6/17/13 | 418044.57725187 | 1 | 30.5767928913 | 7 | 1410000 | 838877.829578423 | 1036.3186524452 | 8063.2337676582 | 8159.563177101 | 8232.7964574445 | 1330.7114431951 | 2670.4560815858 | 3341.2543567386 | 8596.7147917291 | 9378.0179559375 |
| 6/24/13 | 373110.775407309 | 0 | 30.3649102187 | 7 | 1042800 | 696725.495030455 | 817.9592216306 | 8664.1674918525 | 9244.9246593338 | 8324.5905481139 | 1368.4392596993 | 2524.2818314895 | 3257.0897995344 | 7531.4271615241 | 8145.951435123 |
| 7/1/13 | 427432.969016811 | 0 | 29.2100659735 | 7 | 471000 | 747507.86542375 | 957.5856848311 | 8742.2959786945 | 8120.3710305248 | 9788.5413380281 | 1701.539976204 | 3568.1215258038 | 4332.5895755989 | 9065.0525256162 | 10783.6045651192 |
| 7/8/13 | 510668.928141173 | 0 | 35.2057055586 | 3 | 780000 | 758774.733997551 | 970.5519049018 | 8669.4064783749 | 7974.7607729683 | 11066.7811970906 | 1752.9063170992 | 3425.5883584566 | 4384.8183614666 | 9005.2678473066 | 9104.8399239478 |
| 7/15/13 | 432693.032598319 | 0 | 32.4497574682 | 5 | 1488000 | 708052.062754494 | 832.4237332199 | 8895.5572701479 | 8341.1508406864 | 12142.7606794686 | 2132.6820982638 | 2613.9895148357 | 3282.347803993 | 7731.2421355578 | 8288.1904855909 |
| 7/22/13 | 437619.364247437 | 0 | 32.4497574682 | 5 | 0 | 730721.804983071 | 851.9233907658 | 8889.8768896951 | 8554.4460111421 | 11354.3225221925 | 1786.0136119162 | 3887.6002972976 | 4930.8277763549 | 8271.787500819 | 9185.0154213515 |
| 7/29/13 | 415143.373900728 | 0 | 33.4261397218 | 3 | 9000 | 695722.802121245 | 881.2552965618 | 9182.9803697246 | 8742.0319871873 | 7807.3434217512 | 1211.8081831135 | 4542.6737966117 | 5326.9535049484 | 8506.7732896245 | 9866.3224717748 |
| 8/5/13 | 452574.875064434 | 0 | 38.7038896 | 4 | 1178400 | 883351.227275512 | 1135.5591691892 | 9042.7016109972 | 9102.3169935933 | 9206.7231258803 | 1510.9040008238 | 4066.7401228673 | 4923.6758959398 | 8195.0212191688 | 9120.8463376954 |
| 8/12/13 | 487523.206301548 | 0 | 42.909315753 | 1 | 348000 | 838847.23443297 | 954.7438453677 | 8985.3436667289 | 8986.8674928641 | 10543.9904873282 | 1701.4260346367 | 2345.4209343021 | 2965.059438277 | 8867.6520731016 | 10410.1933402454 |
| 8/19/13 | 410808.811231763 | 1 | 38.4465553022 | 7 | 4191000 | 869788.335184762 | 948.4264994535 | 9062.6344751095 | 8946.7673146771 | 10351.7615105891 | 1776.9534428128 | 2860.2489736411 | 3518.6817506358 | 10308.2492358673 | 11490.7583262883 |
| 8/26/13 | 389210.089315526 | 0 | 34.8046113573 | 7 | 2076318 | 791231.31344373 | 954.9355412783 | 13986.3537755214 | 13154.4028312265 | 11867.3343038598 | 1879.0194029403 | 4005.8210224305 | 4550.340028001 | 10047.0091504175 | 10927.8510548943 |
| 9/2/13 | 624996.111913597 | 0 | 42.3314741648 | 5 | 1884000 | 799879.264269856 | 969.3687157525 | 13759.9958667242 | 14735.233748345 | 12000.2190430618 | 1978.7144025222 | 3625.5773980849 | 4396.5775853859 | 11671.8974308427 | 12878.3610006398 |
| 9/9/13 | 538185.078831331 | 0 | 40.0473077361 | 4 | 1666710 | 751164.019064224 | 848.6689603952 | 13681.706233873 | 14034.6386429013 | 11781.0872266711 | 2140.4676737012 | 3032.0293236725 | 3652.5521855591 | 11522.61693585 | 12017.8315683843 |
| 9/16/13 | 526219.283952491 | 0 | 40.9525104178 | 0 | 795000 | 786269.953688319 | 957.3616227877 | 13698.455436311 | 13834.2374058563 | 11950.7588632581 | 1933.7801654373 | 3812.0849616357 | 4447.3458683804 | 11876.0984732541 | 13386.9397719293 |
| 9/23/13 | 494174.821060216 | 0 | 34.289278147 | 7 | 1972980 | 724660.138870466 | 841.7831185793 | 13896.5414996036 | 12818.7489787288 | 11313.5570471562 | 1787.7831983036 | 2055.192960999 | 2464.6573200538 | 10229.9387735331 | 11844.8521249948 |
| 9/30/13 | 426724.801846447 | 1 | 37.2975368358 | 3 | 300000 | 784596.426333556 | 938.6008182522 | 16306.8776338265 | 16750.118364454 | 8695.6331635911 | 1406.8841986082 | 2302.2513922749 | 2864.7479452758 | 8857.1049471145 | 9529.0821549278 |
| 10/7/13 | 737435.935222428 | 0 | 45.2271238324 | 6 | 1470000 | 731986.726370927 | 908.1815895407 | 16313.1736150907 | 14735.138304375 | 9470.4938663161 | 1547.948354433 | 3135.630608592 | 3860.9466150491 | 8568.6632479531 | 9090.9997334516 |
| 10/14/13 | 553702.778565882 | 1 | 35.0045984651 | 7 | 5013000 | 863705.10831022 | 1067.4967066089 | 15981.147606141 | 15351.5759594767 | 10331.2292021124 | 1679.4972463022 | 3451.7221012589 | 4431.0797120394 | 12435.5632729788 | 13171.7809469829 |
| 10/21/13 | 503663.618232401 | 0 | 35.6403657218 | 3 | 1128000 | 895282.389252825 | 1069.5725862025 | 15837.4389747371 | 16454.522832636 | 9827.3973176793 | 1809.9558001454 | 3558.7446471504 | 4448.2986567443 | 17139.9139546387 | 19989.9879172133 |
| 10/28/13 | 640710.016391614 | 1 | 32.2698905533 | 5 | 846600 | 933832.703220834 | 1138.8100079653 | 17954.3947055091 | 17622.8318177688 | 12460.827950118 | 2138.8995260715 | 3580.3071462233 | 4745.8282763323 | 13496.054634205 | 14460.5682139099 |
| 11/4/13 | 498026.556663596 | 0 | 38.412083633 | 7 | 3045900 | 747568.513007389 | 894.7346084682 | 17725.9050626202 | 18945.3408086279 | 13007.5092475146 | 2370.1350916156 | 3607.3069594726 | 4684.4856256528 | 12335.868142065 | 12882.2188103521 |
| 11/11/13 | 640144.5985143 | 1 | 42.577453229 | 5 | 1050000 | 841465.261843513 | 1037.7331852975 | 17784.6240114523 | 17711.01499458 | 11784.3678137582 | 1964.8662403726 | 3891.6512437042 | 4864.128559348 | 15285.3936599443 | 17035.9847378559 |
| 11/18/13 | 583335.47164045 | 1 | 32.3320431246 | 4 | 2988000 | 939603.814329083 | 1080.0358806728 | 17448.0390110834 | 16662.4607442422 | 13569.0114078932 | 2213.2653741298 | 3820.4351495217 | 4815.1477559114 | 15208.3161765114 | 18000.5439929142 |
| 11/25/13 | 813296.287588811 | 0 | 41.1677087187 | 2 | 342000 | 861811.374279173 | 1116.4796057903 | 20302.5408260825 | 19561.3140226186 | 15643.4719453416 | 2588.7190762664 | 5063.7114300495 | 6081.8021309496 | 20170.5622177098 | 21502.9539868096 |
| 12/2/13 | 1128883.29649823 | 0 | 42.2940752075 | 5 | 0 | 988315.952738238 | 1153.5286250868 | 20565.5488953429 | 20605.370199958 | 14580.255867182 | 2484.4898844673 | 5151.558961125 | 6925.056725112 | 16883.9860808854 | 18895.9334510548 |
| 12/9/13 | 1001084.61266607 | 1 | 42.991055114 | 7 | 0 | 1112817.17398024 | 1367.3714821246 | 20379.6885973706 | 20786.7804797603 | 13242.6936856345 | 2396.8411617642 | 4275.3165475407 | 5621.988874062 | 14091.9075242373 | 16050.725353978 |
| 12/16/13 | 886570.533339409 | 1 | 34.5426656579 | 7 | 1254000 | 736200.326471613 | 881.3010059946 | 20319.9329194206 | 19934.4765993781 | 11587.5030762787 | 1695.6752055845 | 3893.8901782004 | 4893.6338276158 | 12381.5305204699 | 15238.5569831063 |
| 12/23/13 | 547204.25911499 | 0 | 32.9281464978 | 7 | 180000 | 636627.148458304 | 710.3250890622 | 20415.4755650118 | 18953.5451606705 | 10502.1229403993 | 1755.8063518346 | 3608.5686096368 | 4745.1105263815 | 12091.1096735055 | 13289.3692913001 |
| 12/30/13 | 569633.214267788 | 0 | 34.8566879542 | 7 | 1806000 | 819333.811088192 | 959.0706459929 | 13722.9855929417 | 13846.0989393173 | 9141.350938885 | 1685.0646100063 | 3307.3007523164 | 4409.4391252091 | 14729.6920340765 | 15284.9458402394 |
| 1/6/14 | 454489.351061213 | 1 | 36.5582033741 | 7 | 63000 | 778763.147910319 | 953.8591264114 | 13948.4394022562 | 13541.2401358577 | 8907.6845120849 | 1446.3894197048 | 2193.6416938273 | 2622.8443864921 | 14877.2181865492 | 16377.9936675508 |
| 1/13/14 | 514507.159988753 | 0 | 32.2456296037 | 5 | 838800 | 990087.003792206 | 1230.5887772129 | 14012.9229608361 | 12584.2154252265 | 9530.0201881193 | 1509.1636806526 | 2011.9691102201 | 2452.3785042088 | 13051.8966682792 | 14425.8669791568 |
| 1/20/14 | 464515.126924129 | 1 | 37.8856508657 | 5 | 2877000 | 916455.209802549 | 1124.9171216357 | 13918.8536844122 | 13396.2129654869 | 9425.5489382194 | 1543.0065402309 | 3340.5449066975 | 4280.8536954524 | 12116.9110618304 | 12671.0543084621 |
| 1/27/14 | 405270.52808562 | 1 | 35.4808124523 | 6 | 3297600 | 763715.969419648 | 902.9236059903 | 15040.9930019141 | 14204.0654114562 | 10244.7441503587 | 1767.6296735545 | 3167.6924317677 | 3739.4163772954 | 11728.8399474804 | 12465.3173037901 |
| 2/3/14 | 529406.387951138 | 1 | 41.7719654732 | 2 | 2229000 | 839236.621656066 | 1054.2924082544 | 14930.1248799767 | 14654.9692995398 | 10665.3873350543 | 1653.6441111932 | 2978.1298727305 | 3962.2871885375 | 10899.1184978849 | 11437.880387004 |
| 2/10/14 | 612168.70934617 | 0 | 37.5005558178 | 4 | 360000 | 875535.179154862 | 983.8415773929 | 15175.7604155583 | 14459.5079531047 | 10016.1875087655 | 1614.7254200853 | 3292.548674793 | 4211.942059623 | 12582.7304467064 | 13450.8256582806 |
| 2/17/14 | 512639.632935922 | 0 | 36.8729273498 | 7 | 630000 | 947408.588659536 | 1158.4700267995 | 15246.775611711 | 15278.3118257739 | 9110.314433493 | 1438.2868002027 | 2775.6836592529 | 3662.5253077383 | 12020.2745037983 | 13075.0284746767 |
| 2/24/14 | 460751.309997941 | 0 | 37.801411814 | 5 | 2671110 | 865791.843846763 | 1074.3490673858 | 12593.6055674955 | 11845.1809143274 | 8386.9333645505 | 1347.0444871764 | 2873.4517889772 | 3542.8997109399 | 11152.838943573 | 12021.7557495209 |
| 3/3/14 | 562006.52421884 | 1 | 41.4884081209 | 4 | 600000 | 825974.045853624 | 959.1072356433 | 12690.9120838298 | 12003.4818074589 | 8101.4293572149 | 1357.6310438041 | 3395.168915072 | 4179.2804084692 | 10240.3635777842 | 11140.4377617423 |
| 3/10/14 | 564982.033151222 | 0 | 38.4671656688 | 7 | 0 | 1009994.15401 | 1191.3122865932 | 12816.676386824 | 12962.9934876108 | 8354.6685591197 | 1406.1107183136 | 3592.5489094456 | 4332.4224843361 | 12240.1239121588 | 13359.0062760051 |
| 3/17/14 | 555279.376604489 | 0 | 38.175789214 | 7 | 3550500 | 850125.791972056 | 974.601962913 | 12459.6311186839 | 11632.4014953881 | 8529.3657352568 | 1448.8522458434 | 3354.8571970469 | 4321.4487710443 | 10206.3629389278 | 11842.9622478369 |
| 3/24/14 | 452409.766213813 | 0 | 33.8353414078 | 7 | 432000 | 889365.804256491 | 1156.4505071738 | 12413.7357531847 | 12667.9871922413 | 8123.1772663533 | 1359.8445324822 | 3430.6364917179 | 4310.2390115181 | 10084.9127357773 | 11458.4135436218 |
| 3/31/14 | 779112.258316751 | 1 | 40.5315856296 | 4 | 1545402 | 956211.677121793 | 1168.5630037439 | 13346.6554376659 | 13343.5407966226 | 7338.4542537098 | 1052.6713946398 | 3255.1403800182 | 4217.0274280893 | 12433.4499479536 | 13705.4006853187 |
| 4/7/14 | 599229.215485865 | 1 | 37.6944131966 | 7 | 3241152 | 1192065.03696294 | 1427.2821913458 | 13702.2516970564 | 13588.5194803098 | 6883.753988182 | 1130.0174087144 | 3360.0729670428 | 3944.2611225176 | 10049.2231723388 | 11619.693068125 |
| 4/14/14 | 487160.964239032 | 0 | 35.4255945159 | 7 | 3957000 | 988068.152191022 | 1145.2038760048 | 13471.8126965984 | 13195.4346629442 | 7525.0147484219 | 1257.8952688873 | 3535.6516013059 | 4187.1933285471 | 12417.7567463066 | 14091.4132187383 |
| 4/21/14 | 559185.827508074 | 0 | 35.1620270218 | 4 | 150000 | 975289.568273152 | 1274.7396548868 | 13433.0734167477 | 12761.3551759189 | 7674.4944420655 | 1269.5967008441 | 2890.6298909812 | 3686.9299628476 | 12888.1321717079 | 12889.8981355166 |
| 4/28/14 | 729284.736282471 | 1 | 32.8248712685 | 7 | 204600 | 1058911.94718141 | 1246.672607337 | 13255.387356951 | 13018.6941726662 | 8283.0156889129 | 1326.4046080475 | 2683.7332409873 | 3469.5420043583 | 13450.1402908595 | 13862.8033105519 |
| 5/5/14 | 473373.097203784 | 0 | 36.8583999766 | 7 | 2400000 | 1080784.85205798 | 1323.0290246919 | 13473.3822606745 | 13682.7787356456 | 7232.977359953 | 1216.856536365 | 2924.5435641472 | 3603.2721476302 | 8168.0392658369 | 8787.017266312 |
| 5/12/14 | 513026.093089424 | 1 | 35.1706150427 | 3 | 3918000 | 1009485.01964031 | 1236.9255859688 | 13395.4084046744 | 12245.2382436809 | 7187.432822194 | 1184.8997365645 | 3101.7599094308 | 3806.1478128946 | 10737.1726926524 | 11301.8322701889 |
| 5/19/14 | 600266.576399435 | 0 | 35.840714696 | 3 | 459000 | 986093.367619622 | 1187.8744618756 | 13665.6831763063 | 13757.2055613993 | 5973.6229780217 | 1024.4650365327 | 3210.001318738 | 3795.9428157144 | 12226.0786154819 | 13678.7789724132 |
| 5/26/14 | 642193.629325771 | 0 | 39.8475808741 | 3 | 1440000 | 1002743.28908184 | 1151.6373692045 | 12111.7753129717 | 11962.7258485647 | 5317.6854195728 | 826.4235788507 | 2633.1500551239 | 3296.2041044253 | 10354.2737627594 | 11110.0793701232 |
| 6/2/14 | 541088.301613491 | 1 | 35.8350775688 | 7 | 47550 | 992520.533952754 | 1157.7013966802 | 11996.8536713009 | 12380.5806190097 | 6260.8524584305 | 989.5397495082 | 2162.6402505487 | 2786.7296661043 | 9622.464789102 | 11627.4574451233 |
| 6/9/14 | 570025.41643195 | 0 | 32.716802228 | 5 | 222000 | 897630.645312383 | 1075.2185741559 | 12064.3138139504 | 11864.171585329 | 7463.2478167065 | 1185.2733371287 | 2152.8576231012 | 2678.3537211815 | 11359.7323274663 | 13056.8956226996 |
| 6/16/14 | 538649.126215343 | 1 | 34.9526771788 | 7 | 1266000 | 1046642.00021071 | 1242.9123232139 | 11939.1536730253 | 11938.9116343021 | 7065.3970921096 | 1258.2464169725 | 2387.0763364465 | 2941.8325243917 | 9330.4501302513 | 10775.2038635659 |
| 6/23/14 | 418121.535197507 | 0 | 34.7193391717 | 7 | 924000 | 1009123.73759017 | 1262.1940751444 | 12070.2773730483 | 12086.4362723971 | 6757.1227335364 | 1013.2862683096 | 2269.5280778337 | 2799.0302800216 | 9720.7662988419 | 10696.0971299256 |
| 6/30/14 | 499594.544632756 | 0 | 30.6398266832 | 7 | 1101000 | 1005973.66372007 | 1131.5458885653 | 17524.8546825737 | 16918.2695144614 | 6463.0489228712 | 1050.4052734205 | 2741.4038744394 | 3528.710648691 | 10163.5154290044 | 11108.5848868375 |
| 7/7/14 | 484678.336573692 | 0 | 33.9384613863 | 4 | 58800 | 918222.90855747 | 1069.3115299891 | 17612.1530261018 | 17459.7941089988 | 6198.8853206444 | 1116.8378006985 | 3258.9519078155 | 3892.429513089 | 8663.5467118472 | 9193.7205588841 |
| 7/14/14 | 434144.350452166 | 0 | 32.7342130657 | 7 | 1344000 | 950985.384548515 | 1209.2684148466 | 17759.8274984779 | 17268.941835819 | 7345.8979178587 | 1275.8233871171 | 3290.2861435042 | 4010.9602976239 | 8905.9946582811 | 9888.3579769096 |
| 7/21/14 | 440849.454949605 | 0 | 36.1853672773 | 3 | 3660876 | 948983.333217322 | 1143.3869598415 | 17848.7423630366 | 17146.6210814468 | 9475.9399877385 | 1656.7318483405 | 3420.7832967901 | 4265.571529485 | 10450.5559097116 | 11682.9150476426 |
| 7/28/14 | 429708.297819586 | 0 | 33.8799802047 | 3 | 907800 | 864518.839302487 | 1051.7051797616 | 16309.2919727494 | 16710.8866609631 | 8004.4010861498 | 1315.9370196174 | 3209.0945135222 | 4106.6176982542 | 9862.3120889683 | 10140.6953234672 |
| 8/4/14 | 511725.062156209 | 0 | 41.6238399526 | 4 | 1023000 | 966521.853949101 | 1180.6678178686 | 16561.3345051647 | 15664.9121704682 | 6996.3246515816 | 1173.1704452086 | 2813.2744767233 | 3468.7281534899 | 9170.2203575405 | 10486.7022635526 |
| 8/11/14 | 520943.571013572 | 0 | 45.3615394065 | 1 | 35400 | 1007109.55330305 | 1206.3880188918 | 16662.4255794153 | 16064.1092969273 | 6952.9475807445 | 1145.7036015787 | 2371.9962872025 | 2928.0829998588 | 8542.129018263 | 9269.7746353688 |
| 8/18/14 | 466785.359604917 | 1 | 42.3885451059 | 3 | 3900000 | 1116068.49239037 | 1412.7239388339 | 16510.8740547535 | 15209.6222043438 | 7087.7134334258 | 1199.0643209381 | 2575.1842110925 | 3175.6183916319 | 10641.6684722951 | 11659.5340220204 |
| 8/25/14 | 456443.085526818 | 0 | 39.4320325455 | 7 | 1681782 | 1003149.2105761 | 1188.3040376568 | 17378.7772746035 | 17845.9586910894 | 6617.7740248605 | 1146.5084313349 | 2850.1951065626 | 3453.2395637869 | 9206.6024979749 | 10021.4058562744 |
| 9/1/14 | 688566.94283017 | 0 | 46.1025482034 | 5 | 2363676 | 1011989.18098535 | 1280.8267682555 | 17521.7717104112 | 17065.4832823741 | 7008.31004199 | 1181.102424534 | 2791.0822674637 | 3566.3810584324 | 11249.3202441563 | 12591.9611080828 |
| 9/8/14 | 590046.851016563 | 0 | 41.3024566044 | 4 | 1912200 | 1192819.3890691 | 1418.1587014302 | 17733.7470761177 | 17041.4780492597 | 7886.957339099 | 1372.5040071485 | 2867.6098081902 | 3548.2285543039 | 11860.9137685962 | 12890.3930639003 |
| 9/15/14 | 578272.730536651 | 0 | 45.9423134583 | 4 | 1357500 | 1325039.84192699 | 1568.5554989901 | 17800.5045849732 | 17124.8896131993 | 8465.3847535112 | 1451.2937434699 | 3324.8979282107 | 4149.5781358991 | 12033.0424108805 | 12942.8925066119 |
| 9/22/14 | 519059.309611781 | 0 | 37.9711324371 | 7 | 3015000 | 1297995.33616853 | 1606.2094276357 | 17773.024144744 | 17903.4082666894 | 7555.7397382012 | 1276.5244778056 | 3630.6318815426 | 4188.1907645624 | 10773.6967828537 | 12404.508059537 |
| 9/29/14 | 470067.858453538 | 1 | 38.9119448458 | 3 | 420000 | 1180930.43074409 | 1360.2616421478 | 18382.508485095 | 18668.5628506986 | 7229.7791627897 | 1128.3338546717 | 3520.3774939805 | 4276.7647944276 | 10935.6764625009 | 12411.2263923514 |
| 10/6/14 | 775082.292257302 | 0 | 48.281430853 | 5 | 796200 | 1054625.9400708 | 1266.5412711537 | 18106.7301203058 | 18149.2815558113 | 7631.9239787753 | 1275.0209447881 | 4111.4821111097 | 4735.2433005392 | 11432.70410446 | 12822.3361075729 |
| 10/13/14 | 591541.034873709 | 1 | 38.242271271 | 7 | 4158900 | 1229659.16500649 | 1542.9827415393 | 18435.7044015671 | 16867.7677488688 | 6931.9037190585 | 1150.6287849353 | 4065.8992299236 | 4875.6797340091 | 13861.3215857465 | 15200.2484119046 |
| 10/20/14 | 530629.181532112 | 0 | 38.7077967486 | 7 | 3135000 | 1510739.73008098 | 1925.4588387882 | 18392.1192919432 | 17647.5954953381 | 7927.3425820844 | 1318.5629799155 | 3695.0209847752 | 4963.9782726039 | 14146.7035695462 | 15422.9973182387 |
| 10/27/14 | 662411.737689301 | 1 | 35.9899046991 | 7 | 1224000 | 1359089.39842196 | 1606.18178798 | 23017.9089858511 | 23498.8666373386 | 9424.8098782274 | 1459.1925467605 | 4073.7440136302 | 5211.8268428542 | 12893.9209360574 | 13636.158780579 |
| 11/3/14 | 607060.929056826 | 0 | 44.1209372882 | 7 | 1209000 | 1149455.71635349 | 1284.0064542695 | 22624.4131930452 | 22559.2543242096 | 8248.4560162894 | 1395.1154758568 | 3750.7500814743 | 4787.4064784427 | 15066.3583082654 | 16913.4217869039 |
| 11/10/14 | 681552.702421149 | 1 | 47.7506543729 | 5 | 2971380 | 1209487.56163331 | 1465.7744400257 | 23074.5546089308 | 23493.1062022294 | 8889.3221267077 | 1526.6711182697 | 4072.0694428117 | 4669.7362252207 | 15274.9386680236 | 16881.2161948808 |
| 11/17/14 | 645246.987547239 | 1 | 35.4006370315 | 4 | 2301000 | 1286234.30096654 | 1480.2675686074 | 23193.2360848724 | 22275.0101113232 | 10768.9757497372 | 1831.7730075911 | 4140.4629990285 | 4930.9706830622 | 19588.8112447835 | 22047.2049608081 |
| 11/24/14 | 834697.121942395 | 0 | 42.8156814059 | 2 | 60000 | 1411327.42305669 | 1735.9632767276 | 25048.2439848903 | 26267.7172280156 | 12868.4886442757 | 2316.5852745634 | 5024.9743530935 | 6680.1968511042 | 19965.399915092 | 20531.3769588145 |
| 12/1/14 | 1157634.00014367 | 0 | 44.9792533012 | 5 | 60000 | 1513810.97391125 | 1746.2878175281 | 24407.4838066289 | 24151.6775623622 | 11271.2831326291 | 1900.9216316095 | 6206.5429391278 | 7652.2590658493 | 16485.9330011844 | 18343.1357730219 |
| 12/8/14 | 1035302.9359358 | 1 | 44.2069045925 | 7 | 42000 | 1589559.99945146 | 1806.6857574115 | 24784.4290246277 | 23966.2626383279 | 10283.2978773184 | 1619.6004369645 | 5434.7987692165 | 7117.4554617376 | 15393.0941060276 | 18198.6434024003 |
| 12/15/14 | 939530.514322176 | 1 | 37.7535017754 | 7 | 1104000 | 1671531.59978672 | 1882.9247519724 | 24980.3083887193 | 22591.3059267867 | 10130.9093390929 | 1639.4438630428 | 5997.6932876791 | 7061.9047706481 | 12788.4997520757 | 13332.177896586 |
| 12/22/14 | 617367.702623452 | 0 | 35.2671772819 | 7 | 144000 | 1745994.05868269 | 2080.1282702695 | 24894.7625105252 | 26200.1893670759 | 9793.596357659 | 1658.5704465755 | 4018.2549448022 | 5016.4300302975 | 15999.8376451344 | 17618.4450025738 |
| 12/29/14 | 477703.929611813 | 0 | 31.3036430673 | 6 | 1287600 | 693105.403297642 | 853.5887606352 | 10919.4294642534 | 10887.7391405444 | 11522.8807724147 | 1945.7332096332 | 3874.6996309319 | 4460.9312977594 | 9517.8624604365 | 11565.543736137 |
Sales_Months
Sales 41281 41288 41295 41302 41309 4131 6 41323 41330 41337 41344 41351 41358 41365 41372 41379 41386 41393 41400 41407 41414 41421 41428 41435 41442 41449 41456 41463 41470 41477 41484 41491 41498 41505 41512 41519 41526 41533 41540 41547 41554 41561 41568 41575 41582 41589 41596 41603 41610 41617 41624 41631 41638 41645 41652 41659 41666 41673 41680 41687 4169 4 41701 41708 41715 41722 41729 41736 41743 41750 41757 41764 41771 41778 41785 41792 41799 41806 41813 41820 41827 41834 41841 41848 41855 41862 41869 41876 41883 41890 41897 41904 41911 41918 41925 41932 41939 41946 41953 41960 41967 41974 41981 41988 41995 42002 515554.89222501998 468720.87620134401 398371.08087777602 523995.06719110598 508059.956171809 524137.47463264898 545531.14796495496 483418.74421414698 475735.14967361098 510531.42943094397 506087.403347096 400493.20810979803 754760.85984094196 489428.84726737102 465920.83601338702 496180.57588360598 638277.00889630697 468693.05785226403 436272.59771081299 578185.610333369 602874.99317595095 431978.81016333599 555855.29679779999 418044.57725187001 373110.775407309 427432.969016811 510668.92814117298 432693.032598319 437619.36424743698 415143.37390072801 452574.87506443402 487523.20630154799 410808.81123176299 389210.08931552601 624996.11191359698 538185.07883133099 526219.28395249101 494174.821060216 426724.80184644699 737435.93522242794 553702.77856588201 503663.61823240097 640710.01639161399 498026.55666359601 640144.59851429996 583335.47164044995 813296.28758881101 1128883.29649823 1001084.61266607 886570.53333940904 547204.25911499001 569633.21426778799 454489.351061213 514507.15998875297 464515.12692412903 405270.52808562003 529406.38795113796 612168.70934616996 512639.63293592201 460751.30999794102 562006.52421883994 564982.03315122204 555279.37660448905 452409.76621381298 779112.25831675099 599229.21548586502 487160.96423903201 559185.827508074 729284.73628247099 473373.09720378398 513026.09308942402 600266.57639943506 642193.62932577101 541088.30161349103 570025.41643195006 538649.12621534301 418121.53519750701 499594.54463275598 484678.33657369198 434144.35045216599 440849.45494960499 429708.29781958601 511725.06215620902 520943.57101357199 466785.359604917 456443.085526818 688566.94283017004 590046.85101656301 578272.73053665098 519059.30961178098 470067.85845353798 775082.29225730198 591541.03487370897 530629.18153211195 662411.73768930102 607060.92905682605 681552.70242114901 645246.98754723906 834697.121942395 1157634.00014367 1035302.9359358 939530.51432217599 617367.70262345194 477703.92961181299
IMP_SP_Visual
ONLINE_DISPLAY
IMP_ONLINE_DISPLAY SP_ONLINE_DISPLAY 1921.87379004084 1568.89327747722 1560.86403146362 1541.0192823079899 1443.25234695826 1748.54462245581 1838.23591174375 1904.0606320602301 1508.9677796502599 1460.0492308339601 1547.25358533604 1542.9349148138101 1422.4892183218899 1396.7402263772799 1546.09135864218 1774.2285254058199 1716.0946853416999 1741.42670035372 1551.5480001742901 1636.2738398411 1579.28648028814 1279.0554224039299 1357.8135788463701 1330.71144319512 1368.43925969928 1701.5399762040499 1752.9063170991601 2132.6820982638101 1786.01361191623 1211.80818311352 1510.90400082375 1701.42603463672 1776.95344281282 1879.0194029403399 1978.7144025221901 2140.46767370115 1933.78016543734 1787.7831983035801 1406.88419860822 1547.9483544329801 1679.4972463022 1809.95580014539 2138.8995260715201 2370.1350916155602 1964.86624037257 2213.2653741298 2588.71907626642 2484.4898844673098 2396.84116176415 1695.67520558452 1755.80635183457 1685.06461000634 1446.3894197048 1509.1636806525601 1543.0065402308501 1767.62967355449 1653.6441111932099 1614.7254200853099 1438.2868002027101 1347.04448717644 1357.63104380407 1406.11071831359 1448.8522458433699 1359.8445324822401 1052.6713946398299 1130.0174087143801 1257.8952688873201 1269.59670084406 1326.40460804748 1216.85653636501 1184.89973656454 1024.46503653274 826.42357885067497 989.53974950821203 1185.2733371286899 1258.2464169724601 1013.28626830956 1050.40527342051 1116.8378006984999 1275.8233871170901 1656.73184834055 1315.93701961744 1173.1704452086301 1145.7036015787401 1199.0643209381201 1146.50843133488 1181.10242453398 1372.50400714852 1451.2937434698799 1276.5244778056101 1128.33385467171 1275.02094478809 1150.62878493534 1318.5629799155399 1459.1925467604699 1395.11547585677 1526.6711182696999 1831.7730075910899 2316.5852745634202 1900.9216316094901 1619.60043696453 1639.4438630428201 1658.57044657554 1945.73320963322 11516.0856376188 9724.5056828695506 9540.6845283394305 9106.51097285586 8947.1429014515597 10189.9280239784 11477.1648649253 11273.9111337347 9571.2482396634405 8781.1566659711607 9490.6994574779801 9748.8360754160403 8713.9573577316496 8693.6461478734109 9489.3820159818497 10210.084496986199 10665.754425806401 10536.337719347401 10362.584239182799 10152.4202588403 9292.5852414525307 7843.6368585744503 8395.3538829532499 8232.7964574444904 8324.5905481138907 9788.5413380280606 11066.7811970906 12142.7606794686 11354.3225221925 7807.3434217511804 9206.7231258803095 10543.990487328199 10351.7615105891 11867.3343038598 12000.219043061799 11781.087226671099 11950.758863258099 11313.5570471562 8695.6331635910792 9470.4938663161192 10331.229202112399 9827.3973176793206 12460.827950118 13007.509247514599 11784.367813758199 13569.0114078932 15643.4719453416 14580.255867182001 13242.6936856345 11587.503076278699 10502.1229403993 9141.3509388849998 8907.6845120848593 9530.0201881192806 9425.54893821941 10244.7441503587 10665.3873350543 10016.187508765501 9110.3144334930093 8386.9333645504594 8101.42935721495 8354.6685591197293 8529.3657352567807 8123.1772663532902 7338.4542537098496 6883.7539881820203 7525.0147484219196 7674.4944420654901 8283.0156889128702 7232.9773599529799 7187.4328221940495 5973.62297802173 5317.6854195727801 6260.8524584305196 7463.2478167064801 7065.3970921096297 6757.1227335363501 6463.0489228711604 6198.8853206444001 7345.8979178586997 9475.9399877385003 8004.40108614983 6996. 32465158164 6952.9475807445297 7087.7134334257598 6617.7740248604896 7008.3100419900302 7886.9573390990399 8465.3847535111599 7555.7397382012296 7229.7791627896604 7631.9239787752704 6931.9037190584704 7927.3425820843604 9424.8098782274192 8248.4560162894195 8889.3221267077206 10768.975749737199 12868.4886442757 11271.2831326291 10283.2978773184 10130.909339092899 9793.5963576590493 11522.880772414699
SP
IMP
IMP_EMAIL SP_EMAIL 1060.67407676071 981.05380522826999 893.34838418125696 983.46936068596699 937.13043207693295 878.93679769075197 965.68890414125303 994.71619726368704 915.64475955754597 1046.96090342142 939.18432611667401 969.87658926955305 1008.2038414723301 964.74746585025798 1064.1486128157101 932.26070095148395 918.92508365473896 977.84890401884195 976.54282858200304 993.34220418649397 858.66154286980804 966.66427680081699 902.30580914255302 1036.3186524452001 817.95922163064904 957.58568483108297 970.55190490177097 832.42373321993705 851.92339076578298 881.25529656175195 1135.55916918918 954.74384536765103 948.42649945353105 954.93554127825405 969.36871575246096 848.66896039521305 957.36162278774998 841.78311857929998 938.600818252159 908.18158954072499 1067.49670660893 1069.5725862025199 1138.8100079653 894.73460846821399 1037.7331852974601 1080.03588067282 1116.47960579029 1153.52862508678 1367.3714821245701 881.30100599456398 710.325089062237 959.07064599291004 953.85912641144398 1230.5887772128699 1124.9171216356699 902.92360599028495 1054.29240825444 983.84157739292698 1158.4700267994599 1074.3490673858 959.10723564330999 1191.31228659316 974.60196291302304 1156.4505071737501 1168.56300374394 1427.2821913457899 1145.2038760047601 1274.7396548868201 1246.672607337 1323.0290246918701 1236.9255859687501 1187.8744618756 1151.6373692045399 1157.7013966802499 1075.2185741558901 1242.91232321389 1262.1940751443699 1131.54588856533 1069.3115299891101 1209.2684148466001 1143.3869598414601 1051.70517976159 1180.66781786864 1206.3880188918099 1412.7239388338601 1188.3040376568299 1280.82676825555 1418.1587014302499 1568.55549899011 1606.20942763571 1360.2616421478499 1266.5412711536901 1542.9827415393299 1925.45883878819 1606.1817879799801 1284.0064542695 1465.77444002575 1480.2675686073901 1735.96327672758 1746.28781752805 1806.6857574114799 1882.9247519724499 2080.1282702695398 853.588760635163 863530.201 777268.56901427999 790764.21437492699 838703.70673168404 808247.77258906502 744831.83995731699 764503.24489533901 812007.32434895297 765341.96963771898 829429.84667150304 805166.785350185 809215.80679434899 827294.780587674 803070.47534138802 886351.41603222105 803312.14932328998 782868.03682109702 872280.92559881601 841907.68298100901 786292.58875983604 760098.92647879105 765019.66468034603 758538.10249187599 838877.82957842306 696725.49503045494 747507.86542375002 758774.73399755103 708052.06275449402 730721.80498307105 695722.80212124495 883351.22727551195 838847.23443297006 869788.33518476202 791231.31344373 799879.26426985604 751164.01906422398 786269.95368831896 724660.13887046603 784596.42633355595 731986.72637092695 863705.10831021995 895282.38925282506 933832.70322083402 747568.51300738903 841465.261843513 939603.81432908296 861811.37427917297 988315.95273823803 1112817.17398024 736200.32647161302 636627.148458304 819333.81108819204 778763.14791031904 990087.00379220594 916455.20980254898 763715.96941964806 839236.62165606604 875535.17915486195 947408.58865953598 865791.84384676302 825974.045853624 1009994.1540100001 850125.79197205603 889365.80425649101 956211.67712179304 1192065.0369629399 988068.15219102195 975289.56827315199 1058911.9471814099 1080784.8520579799 1009485.01964031 986093.36761962203 1002743.28908184 992520.53395275399 897630.64531238296 1046642.00021071 1009123.73759017 1005973.66372007 918222.90855746996 950985.38454851496 948983.33321732201 864518.83930248697 966521.85394910094 1007109.55330305 1116068.49239037 1003149.2105761 1011989.18098535 1192819.3890690999 1325039.8419269901 1297995.3361685299 1180930.4307440899 1054625.9400708 1229659.16500649 1510739.7300809801 1359089.39842196 1149455.71635349 1209487.56163331 1286234.3009665399 1411327.42305669 1513810.97391125 1589559.9994514601 1671531.59978672 1745994.0586826899 693105.40329764201
SP
IMP
PAID_SEARCH
IMP_PAID_SEARCH SP_PAID_SEARCH 10967.001457846 10645.1883665886 10924.8262798737 10617.4114483457 10211.631514639999 11748.4227780282 13411.206005448599 12978.3038270132 13394.8038262559 13494.832727196401 12936.2802396727 10968.6021232937 9674.5742211707402 8984.9362576119202 9692.0777666501508 10460.452886102101 10440.9624992597 10913.5270298301 10666.1026446287 7713.6174296679701 7646.2039244898397 7908.6556147844203 7367.3361713109298 8159.5631771010303 9244.9246593337793 8120.3710305247996 7974.7607729682504 8341.1508406863595 8554.4460111421304 8742.0319871872907 9102.3169935932601 8986.8674928640503 8946.7673146771103 13154.4028312265 14735.233748344999 14034.6386429013 13834.2374058563 12818.7489787288 16750.118364454 14735.138304374999 15351.575959476701 16454.522832636001 17622.831817768802 18945.340808627901 17711.01499458 16662.460744242198 19561.314022618601 20605.370199958001 20786.780479760298 19934.4765993781 18953.545160670499 13846.0989393173 13541.240135857701 12584.215425226501 13396.2129654869 14204.0654114562 14654.9692995398 14459.507953104699 15278.311825773901 11845.1809143274 12003.4818074589 12962.9934876108 11632.4014953881 12667.9871922413 13343.540796622599 13588.5194803098 13195.434662944201 12761.355175918899 13018.694172666201 13682.778735645599 12245.2382436809 13757.2055613993 11962.7258485647 12380.580619009699 11864.171585329001 11938.9116343021 12086.436272397101 16918.269514461401 17459.794108998802 17268.941835819001 17146.6210814468 16710.8866609631 15664.9121704682 16064.1092969273 15209.622204343799 17845.9586910894 17065.483282374102 17041.478049259698 17124.889613199299 17903.408266689399 18668.5628506986 18149.2815558113 16867.767748868799 17647.595495338101 23498.8666373386 22559.2543242096 23493.106202229399 22275.010111323201 26267.717228015601 24151.677562362202 23966.262638327898 22591.305926786699 26200.189367075898 10887.7391405444 11037.6195564885 10910.4503410009 10825.381689942 10975.6778835798 10667.6233314069 10767.108744798301 13007.77882453 13047.747335537801 13188.4188607544 13168.076682545799 12994.2243287786 10386.893533524501 10461.6161809566 10403.1917859683 10281.2285651726 10835.7412838245 11093.005819267901 11006.486615817999 10914.712149614301 7970.9262256628599 7981.81274049475 8167.6589979868704 7844.3883727049397 8063.2337676582401 8664.1674918524895 8742.2959786944793 8669.4064783748508 8895.5572701478504 8889.8768896951497 9182.9803697246007 9042.7016109972101 8985.3436667289407 9062.6344751095094 13986.3537755214 13759.995866724201 13681.706233872999 13698.455436311 13896.5414996036 16306.8776338265 16313.1736150907 15981.147606140999 15837.438974737101 17954.394705509101 17725.905062620201 17784.624011452299 17448.039011083401 20302.540826082499 20565.548895342901 20379.688597370601 20319.9329194206 20415.475565011799 13722.985592941701 13948.439402256199 14012.9229608361 13918.853684412201 15040.993001914099 14930.1248799767 15175.760415558299 15246.775611711 12593.605567495501 12690.9120838298 12816.676386824 12459.631118683899 12413.735753184699 13346.655437665901 13702.251697056399 13471.812696598399 13433.0734167477 13255.387356951 13473.3822606745 13395.408404674399 13665.6831763063 12111.7753129717 11996.8536713009 12064.313813950401 11939.153673025299 12070.2773730483 17524.854682573699 17612.153026101802 17759.827498477898 17848.742363036599 16309.291972749401 16561.3345051647 01 16662.4255794153 16510.874054753502 17378.777274603501 17521.771710411202 17733.747076117699 17800.504584973201 17773.024144743998 18382.508485095001 18106.730120305801 18435.704401567102 18392.1192919432 23017.9089858511 22624.413193045199 23074.554608930801 23193.236084872398 25048.243984890301 24407.483806628901 24784.429024627701 24980.308388719299 24894.762510525201 10919.429464253401
SP
IMP
PRODUCT_SEARCH
IMP_PAID_SEARCH SP_PAID_SEARCH 5870.9528668572102 6451.9896666003597 4800.4841765454703 2555.5368075784099 858.85001451913604 350.52274563182698 2697.1859637402499 3561.5218000237801 3675.9743011656301 3815.6111805630499 4654.94545124467 2953.63487461773 4469.1720661573399 4314.6953486341999 4501.3575665110502 4349.4742966762497 4197.60947750996 3860.1447423742202 3816.6369636222498 3679.0314505429701 3834.5393394841999 4185.4862623854797 3920.6402974307698 2670.4560815858299 2524.2818314895198 3568.1215258037701 3425.58835845664 2613.98951483566 3887.6002972976498 4542.6737966117098 4066.7401228672902 2345.4209343021098 2860.2489736411299 4005.8210224305099 3625.5773980849199 3032.0293236725101 3812.08496163573 2055.1929609990002 2302.2513922748699 3135.63060859198 3451.7221012588602 3558.7446471503699 3580.3071462233202 3607.3069594726098 3891.6512437041802 3820.4351495216702 5063.7114300494804 5151.5589611249598 4275.3165475407204 3893.89017820038 3608.5686096368499 3307.3007523163501 2193.64169382725 2011.96911022008 3340.5449066974802 3167.6924317676899 2978.1298727305498 3292.5486747930299 2775.6836592529498 2873.4517889771801 3395.1689150719699 3592.5489094456402 3354.8571970468502 3430.6364917179499 3255.1403800181702 3360.07296704276 3535.65160130595 2890.6298909811999 2683.7332409872702 2924.5435641471799 3101.7599094308098 3210.00131873796 2633.1500551239101 2162.6402505486599 2152.8576231012298 2387.0763364465001 2269.5280778336901 2741.4038744394302 3258.9519078154699 3290.28614350424 3420.78329679014 3209.09451352224 2813.2744767233198 2371.9962872025299 2575.1842110924899 2850.1951065625799 2791.0822674637302 2867.60980819017 3324.8979282106902 3630.6318815426498 3520.3774939804998 4111.4821111096599 4065.8992299235601 3695.0209847751898 4073.7440136301898 3750.7500814742598 4072.0694428117099 4140.4629990284702 5024.9743530935102 6206.5429391278303 5434.7987692164797 5997.6932876791197 4018.2549448022201 3874.6996309318802 7490.8953663622397 8147.8140422114202 6078.2297154461003 3201.4631313182899 1084.90265378462 441.63367389218701 3271.9425365973898 4543.91158948477 4543.5124860755604 4872.0888804958404 5635.5254955610499 3463.7811175018301 5427.8857668568498 5073.5399000057096 5346.4002049238497 5250.4879685649503 4943.9360515197504 4935.0256127095399 4985.8601365171498 4330.7138695015401 5121.5326396336804 5181.5711936832904 4989.5083260595102 3341.2543567385701 3257.0897995344499 4332.5895755988704 4384.8183614666204 3282.3478039929901 4930.8277763548804 5326.9535049483602 4923.6758959398403 2965.05943827699 3518.6817506358102 4550.3400280009801 4396.5775853859404 3652.55218555908 4447.3458683803701 2464.6573200538401 2864.7479452757598 3860.9466150490698 4431.07971203939 4448.2986567442904 4745.8282763323195 4684.4856256527501 4864.1285593480097 4815.1477559114101 6081.8021309495698 6925.0567251120101 5621.9888740620499 4893.6338276157603 4745.1105263814698 4409.43912520911 2622.84438649207 2452.3785042088198 4280.8536954523997 3739.4163772954398 3962.2871885374798 4211.9420596229802 3662.52530773834 3542.8997109399002 4179.2804084692498 4332.4224843360598 4321.44877104427 4310.2390115180897 4217.02742808934 3944.2611225176302 4187.1933285470795 3686.9299628476101 3469.5420043583399 3603.2721476302199 3806.1478128945901 3795.9428157143798 3296.2041044252601 2786.7296661042901 2678.3537211814701 2941.8325243916502 2799.0302800216 3528.7106486909802 3892.42951308902 4010.9602976239098 4265.5 715294850397 4106.6176982541501 3468.7281534899298 2928.0829998588401 3175.6183916318701 3453.2395637868899 3566.3810584324101 3548.2285543039402 4149.5781358991198 4188.1907645623896 4276.7647944275604 4735.2433005391804 4875.6797340090998 4963.9782726039002 5211.8268428542196 4787.4064784427001 4669.7362252206603 4930.9706830622099 6680.1968511041696 7652.25906584929 7117.4554617376098 7061.9047706480997 5016.4300302974598 4460.9312977594
SP
IMP
TV
IMP_PAID_SEARCH SP_PAID_SEARCH 11751.364330442901 11828.9803138837 12850.4336732459 11075.5266739935 8802.6904950586795 10286.5089796661 11808.0618471095 11204.944748334499 9523.0893169646406 9281.9907569720599 9320.2985419339293 9025.2336744266995 8260.9612587352203 8293.3575237524401 10984.611198820699 10053.712849682001 10198.8768405062 9354.3448309831492 9721.07027445124 12990.844881680099 10721.7715047441 9038.8942131670701 9956.9537422127505 9378.0179559375392 8145.95143512296 10783.6045651192 9104.8399239477694 8288.1904855908706 9185.0154213514597 9866.3224717747598 9120.8463376954096 10410.1933402454 11490.7583262883 10927.8510548943 12878.361000639799 12017.831568384299 13386.939771929299 11844.852124994801 9529.0821549278098 9090.9997334516302 13171.780946982901 19989.987917213301 14460.568213909901 12882.2188103521 17035.984737855899 18000.543992914201 21502.9539868096 18895.9334510548 16050.725353977999 15238.5569831063 13289.3692913001 15284.945840239399 16377.9936675508 14425.866979156801 12671.0543084621 12465.3173037901 11437.880387003999 13450.825658280601 13075.028474676699 12021.7557495209 11140.4377617423 13359.006276005101 11842.9622478369 11458.4135436218 13705.4006853187 11619.693068125 14091.4132187383 12889.8981355166 13862.803310551901 8787.0172663120193 11301.832270188899 13678.7789724132 11110.0793701232 11627.4574451233 13056.8956226996 10775.203863565899 10696.0971299256 11108.5848868375 9193.7205588841407 9888.3579769095504 11682.9150476426 10140.6953234672 10486.702263552599 9269.7746353688199 11659.5340220204 10021.405856274399 12591.9611080828 12890.393063900299 12942.892506611901 12404.508059537 12411.2263923514 12822.336107572901 15200.2484119046 15422.9973182387 13636.158780579 16913.421786903898 16881.216194880799 22047.2049608081 20531.376958814501 18343.135773021899 18198.643402400299 13332.177896585999 17618.445002573801 11565.543736137 10741.3857535839 11714.586864025299 11138.7370388331 9464.8605890008494 8592.6710384069302 9229.90359206004 10451.943702840401 10282.361108654901 8284.5441107032002 8725.1145147278003 8815.2778448043591 8299.3319972233403 7655.2714892178101 7818.8406757061903 9240.8602108455907 9650.3224157013901 8710.5506944084991 9017.0573340700594 8370.1239014718194 11032.416505163201 9763.0129510925708 8161.5646073955804 9406.4200486003392 8596.7147917291495 7531.4271615240896 9065.0525256162291 9005.2678473066098 7731.2421355578199 8271.7875008190094 8506.7732896244797 8195.0212191688097 8867.6520731015607 10308.249235867301 10047.0091504175 11671.8974308427 11522.616935849999 11876.0984732541 10229.9387735331 8857.1049471144506 8568.6632479530599 12435.563272978799 17139.913954638701 13496.054634205 12335.868142064999 15285.3936599443 15208.3161765114 20170.562217709801 16883.986080885399 14091.9075242373 12381.5305204699 12091.1096735055 14729.692034076499 14877.2181865492 13051.8966682792 12116.9110618304 11728.839947480399 10899.1184978849 12582.7304467064 12020.2745037983 11152.838943573001 10240.363577784199 12240.123912158801 10206.362938927799 10084.9127357773 12433.449947953601 10049.223172338799 12417.756746306601 12888.132171707901 13450.140290859499 8168.0392658369201 10737.172692652401 12226.0786154819 10354.2737627594 9622.4647891019995 11359.732327466299 9330.4501302512508 9720.7662988419306 10163.515429004399 8663.5467118472498 8905.9946582810899 10450.5559097116 9862.3120889682796 9170.2203 575405001 8542.1290182629891 10641.668472295099 9206.6024979748508 11249.320244156301 11860.9137685962 12033.0424108805 10773.6967828537 10935.6764625009 11432.704104459999 13861.3215857465 14146.7035695462 12893.9209360574 15066.3583082654 15274.9386680236 19588.811244783501 19965.399915091999 16485.933001184399 15393.0941060276 12788.499752075701 15999.837645134399 9517.8624604365305
SP
IMP
IMP_SP_Regression
| SUMMARY OUTPUT - EMAIL | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9848083731 | |||||||
| R Square | 0.9698475316 | |||||||
| Adjusted R Square | 0.9695519192 | |||||||
| Standard Error | 38357.6169229048 | |||||||
| Observations | 104 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 4827074494721.03 | 4827074494721.03 | 3280.8076285967 | 2.23131288111572E-79 | |||
| Residual | 102 | 150073291152.44 | 1471306776.00431 | |||||
| Total | 103 | 4977147785873.46 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 5559.2086170401 | 16776.973197755 | 0.3313594503 | 0.7410528112 | -27717.8381737434 | 38836.2554078236 | -27717.8381737434 | 38836.2554078236 |
| SP_EMAIL | 828.3258499469 | 14.4614164144 | 57.2783347226 | 2.23131288111578E-79 | 799.6416990568 | 857.0100008369 | 799.6416990568 | 857.0100008369 |
| SUMMARY OUTPUT - PAID_SEARCH | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9899883698 | |||||||
| R Square | 0.9800769723 | |||||||
| Adjusted R Square | 0.9798816485 | |||||||
| Standard Error | 623.099890167 | |||||||
| Observations | 104 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 1948140914.33628 | 1948140914.33628 | 5017.7037661764 | 1.47225451259034E-88 | |||
| Residual | 102 | 39601854.25887 | 388253.473126176 | |||||
| Total | 103 | 1987742768.59515 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 486.8443463526 | 207.9094294728 | 2.3416174417 | 0.0211441784 | 74.4569787827 | 899.2317139224 | 74.4569787827 | 899.2317139224 |
| SP_PAID_SEARCH | 0.9837890037 | 0.0138883117 | 70.8357520337 | 1.47225451259034E-88 | 0.9562416033 | 1.0113364041 | 0.9562416033 | 1.0113364041 |
| SUMMARY OUTPUT - ONLINE_DISPLAY | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9768449258 | |||||||
| R Square | 0.954226009 | |||||||
| Adjusted R Square | 0.9537772444 | |||||||
| Standard Error | 424.7493107557 | |||||||
| Observations | 104 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 383617143.527343 | 383617143.527343 | 2126.3396695338 | 3.96376234392869E-70 | |||
| Residual | 102 | 18402021.6527158 | 180411.97698741 | |||||
| Total | 103 | 402019165.180059 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 725.266641841 | 192.0751873238 | 3.7759517611 | 0.0002681276 | 344.2864184966 | 1106.2468651853 | 344.2864184966 | 1106.2468651853 |
| SP_ONLINE_DISPLAY | 5.5687846344 | 0.1207658387 | 46.1122507533 | 3.96376234392891E-70 | 5.329246166 | 5.8083231028 | 5.329246166 | 5.8083231028 |
| SUMMARY OUTPUT - PRODUCT_SEARCH | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9879269147 | |||||||
| R Square | 0.9759995887 | |||||||
| Adjusted R Square | 0.9757642906 | |||||||
| Standard Error | 190.5426714678 | |||||||
| Observations | 104 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 150596757.808596 | 150596757.808596 | 4147.9271695346 | 1.96291271501722E-84 | |||
| Residual | 102 | 3703263.98430964 | 36306.5096500945 | |||||
| Total | 103 | 154300021.792905 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 10.0579478579 | 69.7386626646 | 0.1442234117 | 0.8856086269 | -128.2683588758 | 148.3842545916 | -128.2683588758 | 148.3842545916 |
| SP_PRODUCT_SEARCH | 1.2392037693 | 0.019240979 | 64.4044033396 | 1.96291271501733E-84 | 1.2010393788 | 1.2773681599 | 1.2010393788 | 1.2773681599 |
| SUMMARY OUTPUT - TV | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9831842991 | |||||||
| R Square | 0.966651366 | |||||||
| Adjusted R Square | 0.9663244186 | |||||||
| Standard Error | 501.0849570851 | |||||||
| Observations | 104 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 742360271.561032 | 742360271.561032 | 2956.5960457203 | 3.80870348630449E-77 | |||
| Residual | 102 | 25610785.6901294 | 251086.134216955 | |||||
| Total | 103 | 767971057.251161 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 268.0822161628 | 207.6016905899 | 1.291329639 | 0.1995081688 | -143.6947527918 | 679.8591851175 | -143.6947527918 | 679.8591851175 |
| SP_TV | 0.8857676461 | 0.0162901025 | 54.374590074 | 3.80870348630449E-77 | 0.853456305 | 0.9180789872 | 0.853456305 | 0.9180789872 |
Holiday Seg
| Row Labels | Sum of AVERAGE_PRICE | Sum of MEDIA_SPEND_of_competitor |
| 0 | 2453.2732667028 | 87039576 |
| 2013 | 1197.2143561717 | 43852332 |
| Qtr1 | 181.568162328 | 10960326 |
| Qtr2 | 308.3401889118 | 12250698 |
| Qtr3 | 436.7798133664 | 12669408 |
| Qtr4 | 270.5261915654 | 7971900 |
| 2014 | 1256.0589105312 | 43187244 |
| Qtr1 | 254.898820876 | 8482410 |
| Qtr2 | 281.2102851673 | 10653000 |
| Qtr3 | 434.4738845417 | 17360034 |
| Qtr4 | 285.4759199461 | 6691800 |
| 1 | 1401.5585412274 | 66085994 |
| 2013 | 670.719897362 | 30675410 |
| Qtr1 | 247.4315743657 | 11396810 |
| Qtr2 | 127.8265247143 | 3636000 |
| Qtr3 | 75.744092138 | 4491000 |
| Qtr4 | 219.7177061439 | 11151600 |
| 2014 | 730.8386438654 | 35410584 |
| Qtr1 | 233.7166259159 | 10612002 |
| Qtr2 | 176.4776542555 | 8677302 |
| Qtr3 | 81.3004899517 | 4320000 |
| Qtr4 | 239.3438737424 | 11801280 |
| Grand Total | 3854.8318079302 | 153125570 |
Sum of AVERAGE_PRICE Qtr1 Qtr2 Qtr3 Qtr4 Qtr1 Qtr2 Qtr3 Qtr4 Qtr1 Qtr2 Qtr3 Qtr4 Qtr1 Qtr2 Qtr3 Qtr4 2013 2014 2013 2014 0 1 181.56816232803749 308.34018891183797 436.77981336635514 270.52619156542062 254.89882087601251 281.21028516728984 434.47388454174484 285.47591994610593 247.4315743657321 127.82652471433019 75.744092138006195 219.7177061439252 233.7166259158879 176.4776542554516 81.300489951713402 239.34387374236763 Sum of MEDIA_SPEND_of_competitor Qtr1 Qtr2 Qtr3 Qtr4 Qtr1 Qtr2 Qtr3 Qtr4 Qtr1 Qtr2 Qtr3 Qtr4 Qtr1 Qtr2 Qtr3 Qtr4 2013 2014 2013 2014 0 1 10960326 12250698 12669408 7971900 8482410 10653000 17360034 6691800 11396810 3636000 4491000 11151600 10612002 8677302 4320000 11801280
Sales_Promotion
| Row Labels | Sum of Sales |
| 0 | 1104404.89428586 |
| 1 | 1008466.77731512 |
| 2 | 2613672.39519316 |
| 3 | 6930526.14922058 |
| 4 | 8845133.58992279 |
| 5 | 11404151.2580276 |
| 6 | 3620271.84023714 |
| 7 | 22907048.8074833 |
| Grand Total | 58433675.7116855 |
Total 0 1 2 3 4 5 6 7 1104404.89428586 1008466.77731512 2613672.3951931568 6930526.149220584 8845133.5899227932 11404151.258027555 3620271.8402371369 22907048.807483282
Marketing ROI
| (Sales Growth - Marketing Cost) / Marketing Cost = Marketing ROI | |||||||
| Year | Sum of SP_EMAIL | Sum of SP_PAID_SEARCH | Sum of SP_ONLINE_DISPLAY | Sum of SP_PRODUCT_SEARCH | Sum of SP_TV | Sum of Sales | Sale Growth |
| 2013 | 50412.4430009581 | 646438.008154709 | 90318.1947734088 | 189060.220491197 | 607587.749668779 | 28247886.2027624 | |
| 2014 | 67168.7734092824 | 841704.872267233 | 71155.6650709988 | 174105.820851898 | 680134.690748112 | 30185789.5089231 | 1937903.30616075 |
| Grand Total | 117581.21641024 | 1488142.88042194 | 161473.859844408 | 363166.041343095 | 1287722.44041689 | 58433675.7116855 | |
| Marketing ROI | 27.851253459 | 1.3023548633 | 26.2347016113 | 10.1306060686 | 1.8492934304 | ||
Q1
| IMP_TV | SP_TV | IMP_EMAIL | SP_EMAIL | IMP_PAID_SEARCH | SP_PAID_SEARCH | IMP_ONLINE_DISPLAY | SP_ONLINE_DISPLAY | SP_PRODUCT_SEARCH | IMP_PRODUCT_SEARCH | |
| IMP_TV | 1 | |||||||||
| SP_TV | 0.9831829353 | 1 | ||||||||
| IMP_EMAIL | 0.5106202727 | 0.5022129152 | 1 | |||||||
| SP_EMAIL | 0.5062792966 | 0.4928763789 | 0.984795989 | 1 | ||||||
| IMP_PAID_SEARCH | 0.7032092324 | 0.6912201662 | 0.712337261 | 0.690833809 | 1 | |||||
| SP_PAID_SEARCH | 0.7062120501 | 0.6947073543 | 0.7047840977 | 0.6841764664 | 0.9899738898 | 1 | ||||
| IMP_ONLINE_DISPLAY | 0.3865658395 | 0.3842020607 | -0.1836883333 | -0.196821118 | 0.1504470065 | 0.1614838248 | 1 | |||
| SP_ONLINE_DISPLAY | 0.4223023141 | 0.4125028339 | -0.1511796558 | -0.1644104397 | 0.1834772356 | 0.2014152429 | 0.9767536673 | 1 | ||
| SP_PRODUCT_SEARCH | 0.3480511215 | 0.3419035312 | 0.2742237298 | 0.2658354132 | 0.304645691 | 0.2893546032 | 0.3690792922 | 0.3592349135 | 1 | |
| IMP_PRODUCT_SEARCH | 0.3768787625 | 0.3651336741 | 0.2782444697 | 0.2688814728 | 0.3190971843 | 0.3077663273 | 0.3928641861 | 0.3851434904 | 0.9879261282 | 1 |
