Making Business Decisions II

The Yankee Group reports that 66 percent of companies determine Web site success solely by measuring the amount of traffic. Unfortunately, large amounts of Web site traffic do not necessarily indicate large sales. Many Web sites with lots of traffic have minimal sales. The best way to measure a Web sites success is to measure such things as the revenue generated by Web traffic, the number of new customers acquired by Web traffic, any reductions in customer service calls resulting from Web traffic.

3. As you deploy your e-business strategy you want to build a Web site that creates stickiness and a sense of community for The Broadway Cafes customers. Continually measuring Web site metrics is critical for determining the success of the Web site. You have one Excel file with 4 worksheets detailing Web site metrics from a website with different businesses.

Focus 3 requires research about website metrics because you want to analyze this data to determine which metrics will provide you with the greatest knowledge of your Web sites success.

After you have finished analyzing the spreadsheets, create a separate worksheet detailing the three Web site metrics (columns) you find most valuable and want to track along with any supporting data for why you choose them.

You may analyze the 3 columns you picked using pivot tables, charts, advanced sorting and filtering and conditional formatting.

You must do your analysis and submit the spreadsheet that shows and supports your reported analysis.

Explain in your report exactly what you found and why knowing that information could be important to your eBusiness.

Provide as much detail as possible. Explain the steps in Excel and the findings of this website metrics. Write a conclusion for the report. Thank you!

\begin{tabular}{|c|c|c|c|c|c|} \hline 1 & A Blue Cow Restaurant & & & & \\ \hline \\ \hline 3 & Monthly Summary & New Members & Most Online & Hits & \\ \hline 4 & Jul-23 & 2 & 4 & 2507 & \\ \hline 5 & Jun-23 & 17 & 4 & 18525 & \\ \hline 6 & May-23 & 6 & 6 & 18101 & \\ \hline 7 & Apr-23 & 17 & 5 & 16204 & \\ \hline 8 & Mar-23 & 22 & 6 & 22118 & \\ \hline 9 & Feb-23 & 31 & 7 & 16883 & \\ \hline 10 & Jan-23 & 210 & 13 & 12823 & \\ \hline 11 & Dec-22 & 2 & 5 & 3766 & \\ \hline 12 & Nov-22 & 8 & 3 & 1091 & \\ \hline 13 & Oct-22 & 15 & 6 & 2545 & \\ \hline 14 & Sep-22 & 53 & 9 & 2755 & \\ \hline 15 & Aug-22 & 114 & 15 & 4246 & \\ \hline 16 & Jul-22 & 1 & 2 & 113 & \\ \hline 17 & Jun-22 & 16 & 5 & 2444 & \\ \hline 18[ & & & & & \\ \hline 19 & & & & & \\ \hline 20 & & & & & \\ \hline 21 & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A & B & C & D & E & F & G & H & 1 & J & K & L \\ \hline 1 Rise \& Shine Caf & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline server time & device type & sessionid & userid & itemid & time logged in & appcode & osversion & is 5G & itemid & itemprice & producttype \\ \hline 12/13/1807:44 & android & 112333 & 4557 & 32970 & 12/13/1807:44 & 127 & latest & 1 & 26880 & 7 & 3040 \\ \hline 12/13/1807:45 & android & 503590 & 74788 & 7640 & 12/13/1807:45 & 44 & latest & 0 & 54939 & 4 & 6822 \\ \hline 12/13/1807:46 & android & 573960 & 23628 & 128855 & 12/13/1807:46 & 296 & latest & 1 & 40383 & 6 & 1619 \\ \hline 12/13/1807:47 & android & 121691 & 2430 & 12774 & 12/13/1807:47 & 207 & latest & 1 & 8777 & 6 & 5264 \\ \hline 12/13/1807:48 & android & 218564 & 19227 & 28296 & 12/13/1807:48 & 242 & latest & 1 & 113705 & 6 & 10239 \\ \hline 12/13/1807:48 & android & 635314 & 87387 & 86660 & 12/13/1807:48 & 207 & latest & 0 & 108843 & 10 & 703 \\ \hline 12/13/1807:49 & android & 482459 & 348 & 35370 & 12/13/1807:49 & 296 & old & 0 & 129807 & 10 & 2537 \\ \hline 12/13/1807:50 & android & 218564 & 19227 & 100065 & 12/13/1807:50 & 207 & intermediate & 0 & 44250 & 10 & 9641 \\ \hline 12/13/1807:50 & android & 947548 & 30183 & 86558 & 12/13/1807:50 & 260 & intermediate & 1 & 49862 & 7 & 842 \\ \hline 12/13/1807:51 & android & 941129 & 31754 & 127900 & 12/13/1807:51 & 207 & old & 1 & 77042 & 6 & 623 \\ \hline 12/13/1807:51 & android & 58445 & 76152 & 95823 & 12/13/1807:51 & 469 & old & 1 & 229 & 7 & 3248 \\ \hline 12/13/1807:52 & android & 264366 & 34712 & 11871 & 12/13/1807:52 & 207 & latest & 0 & 77286 & 8 & 6864 \\ \hline 12/13/1807:53 & android & 585539 & 39617 & 22859 & 12/13/1807:53 & 371 & latest & 0 & 31157 & 9 & 3328 \\ \hline 12/13/1807:54 & android & 876311 & 35913 & 15434 & 12/13/1807:54 & 190 & old & 0 & 107227 & 6 & 4181 \\ \hline 12/13/1807:55 & iphone & 785476 & 50421 & 43629 & 12/13/1807:55 & 318 & latest & 0 & 47099 & 4 & 7151 \\ \hline 12/13/1807:55 & iphone & 234784 & 1198 & 48334 & 12/13/1807:55 & 465 & latest & 0 & 95657 & 9 & 7233 \\ \hline 12/12/1820:39 & iphone & 234784 & 1198 & 2715 & 12/12/1820:39 & 504 & latest & 0 & 127016 & 6 & 4036 \\ \hline 12/12/1820:39 & iphone & 234784 & 1198 & 83751 & 12/12/18 20:39 & 151 & latest & 1 & 95953 & 9 & 7203 \\ \hline 12/12/1820:40 & iphone & 412485 & 25594 & 60668 & 12/12/1820:40 & 3 & latest & 1 & 131809 & 3 & 6936 \\ \hline 12/12/1820:41 & iphone & 412485 & 25594 & 60668 & 12/12/1820:41 & 207 & latest & 0 & 31202 & 4 & 7387 \\ \hline 12/12/1820:41 & iphone & 412485 & 25594 & 25968 & 12/12/1820:41 & 522 & intermediate & 1 & 118202 & 4 & 7631 \\ \hline 12/12/1820:42 & iphone & 830463 & 13252 & 76186 & 12/12/1820:42 & 421 & old & 0 & 2066 & 8 & 1008 \\ \hline 12/12/1820:42 & iphone & 830463 & 13252 & 67342 & 12/12/1820:42 & 385 & old & 0 & 116586 & 9 & 8836 \\ \hline 12/12/1820:42 & iphone & 830463 & 13252 & 76186 & 12/12/1820:42 & 244 & old & 1 & 105684 & 2 & 233 \\ \hline 12/12/1820:43 & iphone & 830463 & 13252 & 76186 & 12/12/1820:43 & 296 & old & 0 & 56109 & 9 & 3362 \\ \hline 12/12/1820:43 & iphone & 37426 & 58079 & 4785 & 12/12/1820:43 & 409 & latest & 1 & 36828 & 5 & 6822 \\ \hline 12/12/1820:44 & web & 853727 & 34770 & 36429 & 12/12/1820:44 & 422 & old & 0 & 131351 & 9 & 2563 \\ \hline 12/12/1820:44 & web & 133472 & 69682 & 120405 & 12/12/1820:44 & 386 & latest & 0 & 69889 & 5 & 2882 \\ \hline 12/12/1820:44 & web & 802068 & 75774 & 77164 & 12/12/1820:44 & 386 & latest & 1 & 94488 & 8 & 6939 \\ \hline 10/21/1812:19 & web & 154496 & 19413 & 32971 & 10/21/1812:19 & 207 & latest & 1 & 32971 & 3 & 6936 \\ \hline 10/21/1813:35 & web & 184918 & 81953 & 109289 & 10/21/1813:35 & 242 & latest & 1 & 109289 & 5 & 7387 \\ \hline 10/21/1815:52 & web & 448639 & 88355 & 58320 & 10/21/1815:52 & 207 & old & 0 & 58320 & 9 & 7631 \\ \hline 10/23/1813:46 & web & 82998 & 82970 & 21137 & 10/23/1813:46 & 296 & intermediate & 1 & 21137 & 7 & 1008 \\ \hline 10/23/1814:33 & web & 252658 & 27143 & 3500 & 10/23/1814:33 & 207 & intermediate & 0 & 3500 & 3 & 8836 \\ \hline 10/29/1813:42 & web & 614711 & 67674 & 91109 & 10/29/1813:42 & 260 & old & 0 & 91109 & 10 & 233 \\ \hline 10/30/1812:03 & web & 413319 & 71384 & 13572 & 10/30/1812:03 & 207 & old & 1 & 13572 & 7 & 3362 \\ \hline 11/4/1818:42 & web & 395801 & 39469 & 65819 & 11/4/1818:42 & 469 & latest & 1 & 65819 & 6 & 6822 \\ \hline 1 & & & & & & & & & & & \\ \hline 2 & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline 1 & A Blue Cow Restaurant & & & & \\ \hline \\ \hline 3 & Monthly Summary & New Members & Most Online & Hits & \\ \hline 4 & Jul-23 & 2 & 4 & 2507 & \\ \hline 5 & Jun-23 & 17 & 4 & 18525 & \\ \hline 6 & May-23 & 6 & 6 & 18101 & \\ \hline 7 & Apr-23 & 17 & 5 & 16204 & \\ \hline 8 & Mar-23 & 22 & 6 & 22118 & \\ \hline 9 & Feb-23 & 31 & 7 & 16883 & \\ \hline 10 & Jan-23 & 210 & 13 & 12823 & \\ \hline 11 & Dec-22 & 2 & 5 & 3766 & \\ \hline 12 & Nov-22 & 8 & 3 & 1091 & \\ \hline 13 & Oct-22 & 15 & 6 & 2545 & \\ \hline 14 & Sep-22 & 53 & 9 & 2755 & \\ \hline 15 & Aug-22 & 114 & 15 & 4246 & \\ \hline 16 & Jul-22 & 1 & 2 & 113 & \\ \hline 17 & Jun-22 & 16 & 5 & 2444 & \\ \hline 18[ & & & & & \\ \hline 19 & & & & & \\ \hline 20 & & & & & \\ \hline 21 & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A & B & C & D & E & F & G & H & 1 & J & K & L \\ \hline 1 Rise \& Shine Caf & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline server time & device type & sessionid & userid & itemid & time logged in & appcode & osversion & is 5G & itemid & itemprice & producttype \\ \hline 12/13/1807:44 & android & 112333 & 4557 & 32970 & 12/13/1807:44 & 127 & latest & 1 & 26880 & 7 & 3040 \\ \hline 12/13/1807:45 & android & 503590 & 74788 & 7640 & 12/13/1807:45 & 44 & latest & 0 & 54939 & 4 & 6822 \\ \hline 12/13/1807:46 & android & 573960 & 23628 & 128855 & 12/13/1807:46 & 296 & latest & 1 & 40383 & 6 & 1619 \\ \hline 12/13/1807:47 & android & 121691 & 2430 & 12774 & 12/13/1807:47 & 207 & latest & 1 & 8777 & 6 & 5264 \\ \hline 12/13/1807:48 & android & 218564 & 19227 & 28296 & 12/13/1807:48 & 242 & latest & 1 & 113705 & 6 & 10239 \\ \hline 12/13/1807:48 & android & 635314 & 87387 & 86660 & 12/13/1807:48 & 207 & latest & 0 & 108843 & 10 & 703 \\ \hline 12/13/1807:49 & android & 482459 & 348 & 35370 & 12/13/1807:49 & 296 & old & 0 & 129807 & 10 & 2537 \\ \hline 12/13/1807:50 & android & 218564 & 19227 & 100065 & 12/13/1807:50 & 207 & intermediate & 0 & 44250 & 10 & 9641 \\ \hline 12/13/1807:50 & android & 947548 & 30183 & 86558 & 12/13/1807:50 & 260 & intermediate & 1 & 49862 & 7 & 842 \\ \hline 12/13/1807:51 & android & 941129 & 31754 & 127900 & 12/13/1807:51 & 207 & old & 1 & 77042 & 6 & 623 \\ \hline 12/13/1807:51 & android & 58445 & 76152 & 95823 & 12/13/1807:51 & 469 & old & 1 & 229 & 7 & 3248 \\ \hline 12/13/1807:52 & android & 264366 & 34712 & 11871 & 12/13/1807:52 & 207 & latest & 0 & 77286 & 8 & 6864 \\ \hline 12/13/1807:53 & android & 585539 & 39617 & 22859 & 12/13/1807:53 & 371 & latest & 0 & 31157 & 9 & 3328 \\ \hline 12/13/1807:54 & android & 876311 & 35913 & 15434 & 12/13/1807:54 & 190 & old & 0 & 107227 & 6 & 4181 \\ \hline 12/13/1807:55 & iphone & 785476 & 50421 & 43629 & 12/13/1807:55 & 318 & latest & 0 & 47099 & 4 & 7151 \\ \hline 12/13/1807:55 & iphone & 234784 & 1198 & 48334 & 12/13/1807:55 & 465 & latest & 0 & 95657 & 9 & 7233 \\ \hline 12/12/1820:39 & iphone & 234784 & 1198 & 2715 & 12/12/1820:39 & 504 & latest & 0 & 127016 & 6 & 4036 \\ \hline 12/12/1820:39 & iphone & 234784 & 1198 & 83751 & 12/12/18 20:39 & 151 & latest & 1 & 95953 & 9 & 7203 \\ \hline 12/12/1820:40 & iphone & 412485 & 25594 & 60668 & 12/12/1820:40 & 3 & latest & 1 & 131809 & 3 & 6936 \\ \hline 12/12/1820:41 & iphone & 412485 & 25594 & 60668 & 12/12/1820:41 & 207 & latest & 0 & 31202 & 4 & 7387 \\ \hline 12/12/1820:41 & iphone & 412485 & 25594 & 25968 & 12/12/1820:41 & 522 & intermediate & 1 & 118202 & 4 & 7631 \\ \hline 12/12/1820:42 & iphone & 830463 & 13252 & 76186 & 12/12/1820:42 & 421 & old & 0 & 2066 & 8 & 1008 \\ \hline 12/12/1820:42 & iphone & 830463 & 13252 & 67342 & 12/12/1820:42 & 385 & old & 0 & 116586 & 9 & 8836 \\ \hline 12/12/1820:42 & iphone & 830463 & 13252 & 76186 & 12/12/1820:42 & 244 & old & 1 & 105684 & 2 & 233 \\ \hline 12/12/1820:43 & iphone & 830463 & 13252 & 76186 & 12/12/1820:43 & 296 & old & 0 & 56109 & 9 & 3362 \\ \hline 12/12/1820:43 & iphone & 37426 & 58079 & 4785 & 12/12/1820:43 & 409 & latest & 1 & 36828 & 5 & 6822 \\ \hline 12/12/1820:44 & web & 853727 & 34770 & 36429 & 12/12/1820:44 & 422 & old & 0 & 131351 & 9 & 2563 \\ \hline 12/12/1820:44 & web & 133472 & 69682 & 120405 & 12/12/1820:44 & 386 & latest & 0 & 69889 & 5 & 2882 \\ \hline 12/12/1820:44 & web & 802068 & 75774 & 77164 & 12/12/1820:44 & 386 & latest & 1 & 94488 & 8 & 6939 \\ \hline 10/21/1812:19 & web & 154496 & 19413 & 32971 & 10/21/1812:19 & 207 & latest & 1 & 32971 & 3 & 6936 \\ \hline 10/21/1813:35 & web & 184918 & 81953 & 109289 & 10/21/1813:35 & 242 & latest & 1 & 109289 & 5 & 7387 \\ \hline 10/21/1815:52 & web & 448639 & 88355 & 58320 & 10/21/1815:52 & 207 & old & 0 & 58320 & 9 & 7631 \\ \hline 10/23/1813:46 & web & 82998 & 82970 & 21137 & 10/23/1813:46 & 296 & intermediate & 1 & 21137 & 7 & 1008 \\ \hline 10/23/1814:33 & web & 252658 & 27143 & 3500 & 10/23/1814:33 & 207 & intermediate & 0 & 3500 & 3 & 8836 \\ \hline 10/29/1813:42 & web & 614711 & 67674 & 91109 & 10/29/1813:42 & 260 & old & 0 & 91109 & 10 & 233 \\ \hline 10/30/1812:03 & web & 413319 & 71384 & 13572 & 10/30/1812:03 & 207 & old & 1 & 13572 & 7 & 3362 \\ \hline 11/4/1818:42 & web & 395801 & 39469 & 65819 & 11/4/1818:42 & 469 & latest & 1 & 65819 & 6 & 6822 \\ \hline 1 & & & & & & & & & & & \\ \hline 2 & & & & & & & & & & & \\ \hline & & & & & & & & & & & \\ \hline \end{tabular}