Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Web analytics at quality alloys inc case solution

06/12/2021 Client: muhammad11 Deadline: 2 Day

How many people visit the website? How do they come to the website?
During the period observed, there were 69431 visits to the website. During the initial period, there were an average 1055 visits per day. During the pre-promo period, the average was 563. During the promotional period the average was 1814. During the post-promotional period the average was 857. Prior to the promotion, QA used direct mail, advertising in trade magazines, and paid listings on two industrial product web portals. During the promotional period, QA used brochures to reach their target audience.
Is the website generating interest, and how does this interest yield actual sales?
During the website's launch, it generated sales, but sales & profits have been on a downward trend throughout the year. There was a spike during promotial period but the decline continued after the initial peak. The number of visits to the website does not seem to affect sales.
Do traditional promotions drive web traffic and in turn drive incremental sales?
Traditional promotions drive traffic but do not have positive long-term impacts on sales.
How can visits to the website be modeled?
Histograms break down the visits into even periods which makes the data easier to interpret
Where and how should QA advertise?
QA should expand into more industrial product web portals.
Columbia CaseWorks
Web Analytics at Quality Alloys, Inc.
Author: Rob Weitz and David Rosenthal
Columbia CaseWorks ID: 110203
Copyright Information
© 2010 by The Trustees of Columbia University in the City of New York. All rights reserved.
Neither this spreadsheet nor the associated case can be used or reproduced
Abstract: without explicit permission from Columbia CaseWorks.
This spreadsheet accompanies the Web Analytics at Quality Alloys, Inc case. To obtain permission, please visit:
www.gsb.columbia.edu/CaseWorks
or e-mail:
ColumbiaCaseWorks@gsb.columbia.edu
ColumbiaCaseWorks@gsb.columbia.edu
www.gsb.columbia.edu/CaseWorks
Weekly Visits
Quality Alloys
Weekly Web Analytics Initial "Shakedown" Period Pre and Post Promotion Periods
May 25, 2008 - August 29, 2009 Promotion Period are unshaded.
Week (2008-2009) Visits Unique Visits Pageviews Pages/Visit Avg. Time on Site (secs.) Bounce Rate % New Visits
May 25 - May 31 1,632 1,509 3,328 2.04 71 72.67% 88.54%
Jun 1 - Jun 7 1,580 1,450 3,097 1.96 56 75.51% 87.34% Question 2 Initial
Jun 8 - Jun 14 1,441 1,306 3,202 2.22 79 73.98% 84.32% Visits Unique Visits Revenue Profit Lbs. Sold
Jun 15 - Jun 21 1,452 1,301 3,170 2.18 81 73.62% 84.37% mean 1055.214 957.9286 608250.1 200233.4 18736.73
Jun 22 - Jun 28 1,339 1,255 2,366 1.77 50 76.40% 89.25% median 899 845.5 586169.7 208193 17269.7
Jun 29 - Jul 5 892 841 1,865 2.09 71 73.65% 87.56% std. dev 355.0333 319.5972 155930.4 60691.55 5427.393
Jul 6 - Jul 12 797 731 1,885 2.37 80 61.48% 85.70% miniminum 626 594 274567.6 62580.4 8633.059
Jul 13 - Jul 19 744 706 1,916 2.58 96 59.27% 88.84% maximum 1632 1509 890076.7 275218.1 28052.92
Jul 20 - Jul 26 1,044 976 2,670 2.56 82 60.34% 86.69%
Jul 27 - Aug 2 906 850 2,189 2.42 78 63.36% 87.42% Pre-Promotion
Aug 3 - Aug 9 849 791 1,947 2.29 91 64.43% 87.04% Visits Unique Visits Revenue Profit Lbs. Sold
Aug 10 - Aug 16 737 685 1,746 2.37 98 62.82% 87.25% mean 563 517 534313.52 159932.03 18440.77
Aug 17 - Aug 23 734 668 1,946 2.65 100 62.40% 84.33% median 558 510 534541.68 152476.40 17215.12
Aug 24 - Aug 30 626 594 1,540 2.46 91 61.98% 86.58% std. dev 80.871179162 70.9391422613 150502.82 42682.68 5965.63
Aug 31 - Sep 6 577 537 1,489 2.58 83 62.05% 86.66% miniminum 383 366 315647.10 100388.40 8992.42
Sep 7 - Sep 13 562 508 1,428 2.54 82 58.90% 81.32% maximum 795 734 951216.20 273174.70 31968.98
Sep 14 - Sep 20 563 495 1,547 2.75 112 58.61% 78.51%
Sep 21 - Sep 27 652 585 1,792 2.75 101 56.13% 80.98% Promotion
Sep 28 - Oct 4 611 549 1,928 3.16 109 53.52% 81.18% Visits Unique Visits Revenue Profit Lbs. Sold
Oct 5 - Oct 11 561 500 1,784 3.18 113 53.65% 79.86% mean 1814.35 1738.82 456398.8 131929.9 17112.92
Oct 12 - Oct 18 558 525 1,455 2.61 97 61.29% 86.02% median 1663 1585 413937.1 114328.4 17299.12
Oct 19 - Oct 25 570 520 1,562 2.74 95 57.37% 84.91% std. dev 758.1017 743.0253 161741.1 47776.85 6519.071
Oct 26 - Nov 1 551 511 1,560 2.83 109 56.62% 83.85% miniminum 1000 930 268159.5 81841.4 7814.05
Nov 2 - Nov 8 537 507 1,450 2.7 93 56.98% 87.15% maximum 3726 3617 897163.7 266476.7 31496.26
Nov 9 - Nov 15 543 500 1,527 2.81 109 58.38% 83.61%
Nov 16 - Nov 22 558 511 1,495 2.68 96 57.71% 81.18% Post-Promotion
Nov 23 - Nov 29 536 510 1,515 2.83 102 57.65% 87.31% Visits Unique Visits Revenue Profit Lbs. Sold
Nov 30 - Dec 6 549 498 1,367 2.49 87 61.20% 81.79% mean 856.5714 800.789 371728 111045.8 14577.79
Dec 7 - Dec 13 545 499 1,464 2.69 106 59.08% 82.39% median 847.5 800 348397.1 104530.5 13646.89
Dec 14 - Dec 20 591 535 1,469 2.49 91 62.44% 82.74% std. dev 70.889 72.356 145728.3 49065.27 5941.556
Dec 21 - Dec 27 383 366 793 2.07 76 68.93% 90.08% miniminum 772 709 133966.9 32825.3 3825.748
Dec 28 - Jan 3 402 385 827 2.06 62 70.15% 89.30% maximum 963 912 615950.2 206441.2 23761.61
Jan 4 - Jan 10 547 495 1,659 3.03 120 54.66% 81.90%
Jan 11 - Jan 17 631 583 1,745 2.77 103 56.58% 85.42% Question 3 Means
Jan 18 - Jan 24 795 734 1,824 2.29 67 65.79% 85.28% Visits Unique Visits Revenue Profit Lbs. Sold
Jan 25 - Jan 31 1,000 930 2,259 2.26 66 65.80% 86.50% Initial 1055.214 957.9286 608250.1 200233.4 18736.73
Feb 1 - Feb 7 1,207 1,136 2,376 1.97 68 73.07% 88.15% Pre-Promo 563 517 534313.52 159932.03 18440.77
Feb 8 - Feb 14 2,317 2,229 3,814 1.65 38 82.26% 93.09% Promotion 1814.35 1738.82 456398.8 131929.9 17112.92
Feb 15 - Feb 21 2,013 1,946 3,303 1.64 42 81.27% 93.14% Post Promotion 856.5714 800.789 371728 111045.8 14577.79
Feb 22 - Feb 28 2,324 2,228 3,836 1.65 40 80.72% 92.13%
Mar 1 - Mar 7 3,726 3,617 5,291 1.42 28 85.78% 94.79%
Mar 8 - Mar 14 2,563 2,482 3,729 1.45 31 84.78% 93.76% Question 4 Our findings so far have shown that revenue as well as the quantity sold throughout the year have been declining continuously. This had a negative impact on the profits which have also been declining steadily throughout the year. The promotion created a momentary spike in the quantity of unique visits to the website, which even carried into the the post-promotilonal period, but was not able to reverse the long term trend of the other financial metrics.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Accounting & Finance Master
Math Exam Success
Accounting & Finance Mentor
Engineering Exam Guru
Finance Homework Help
Calculation Guru
Writer Writer Name Offer Chat
Accounting & Finance Master

ONLINE

Accounting & Finance Master

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$31 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$33 Chat With Writer
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$19 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$49 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$22 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$36 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Difference between midi and audio - Bob marley & the wailers get up stand up - Bmc knowledge check answers - Y 3x 2 2 - 500-700 word philosophy paper - How to find the volume of a semicircle prism - South village new york - Sedimentary rock flow chart - Ib paper 1 mark scheme - Which of the following people is incorrectly matched with his/her environmental contribution? - Research, identify, and briefly describe the evolution of information systems infrastructure. - Creating a satisfied workforce guarantees successful organizational performance - Do food safety assessment answers - Sppa teachers opt out form - Chapter One, - Respect Timing - Introduction to sociology seagull 10th edition pdf - An external website permitting users to browse and purchase widgets - Fair pricing in business ethics - Rabbit proof fence cinematography - Entrepreneurial potential self assessment - The sea the sea analysis - Trevor noah plays who d you rather - Fifth avenue uptown james baldwin pdf - Nur512-Reply to this discussion johanne - Quantitative data collection/analysis - When was john flynn born - Old testament survey workbook pdf - How to write a report on an observation - Which type of variance causes operating income to be greater than the budgeted operating income? - Dolch and fry sight words list - Discussion: Suicide, Stigma, and Substance Abuse-wk8-6212 - Achilles and briseis love scene - Www bplans com bakery business plan - Module 1 Discussion Forum OT - Consolidation of less than wholly owned subsidiaries solutions - Ct temporal bone cpt - Debut emcee script introduction - 15 72 in simplest form - I Need 1500 words on solution a International Management (BUSS 1006)-CW3-Fall-19-QP - Apa code of ethics psychology - Embedded systems design unimelb - PPT Project - Rhondda valley pigeon federation - Bsbwor502 lead and manage team effectiveness assessment answer - Chest pullover athlean x - Hills alarm master code - William shakespeare thesis statement - Market drayton infant school - Conservation of linear momentum experiment answers - Design of snubber circuit for thyristor - Kitchen equipment word search - What argument is frisch making this is the thesis statement - Scott barber performance testing - In praise of the new knighthood - Swatch case analysis - Course project part 2 - Tls ssl server supports rc4 cipher algorithms cve 2013 2566 - Www talentsmart com me welcome - Upside of irrationality pdf - Research Paper on Cloud Computing - The main variables of the tvm equation are - Smoke detector for arduino - Human resource process - Interdisciplinary Inquiry Essay on Maslow’s Hierarchy of Needs - Draw erd in visio - Http www stress org uk individual stress test - Spiritual gifts test lifeway - Unit 3 IP - V belt design guide - Managing a Project Paper - Springfield lakes state school - Carriage outwards in income statement - Section 5 - Quantitative determination of an empirical formula lab answers - What is the exchange rate for the euro at asda - Prin of Mgnt D/B 5 - The norton introduction to literature 12th edition online - Crab eating fox diet - Boardworks of mice and men - Following is a partial process cost summary for mitchell manufacturing's canning department. - Market research - Wil's grill case study - Aiou m phil urdu fee structure - Week 4 6640 - Greece uncovered katie and terri - What is the purpose of a windshield survey - Bosch ddu 10 price - Case study on smartphones - Homework for lab 6 gravitational forces answers - Tame raji rahejo swami - Public Traded Company - Suppose that the equilibrium price in the market for widgets - Capsim drift rates - 05.04 holocaust: assignment - California pizza kitchen case study pdf - Excel simulation add in - Lintrose nominees pl v king - Industry standards suggest that 10 percent of new vehicles - Discussion questions WITH one reference per questions - Iturralde v. hilo medical center usa