one to two pages in length

Page 2 Questions

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:
					[email protected]

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.
Mar 15 - Mar 21	3,006	2,896	4,510	1.5	35	84.30%	93.11%
Mar 22 - Mar 28	1,663	1,585	3,037	1.83	52	76.55%	90.92%
Mar 29 - Apr 4	1,779	1,689	2,881	1.62	37	78.86%	91.29%
Apr 5 - Apr 11	1,086	1,030	2,313	2.13	63	69.34%	88.49%
Apr 12 - Apr 18	1,231	1,166	2,714	2.2	69	70.59%	89.20%
Apr 19 - Apr 25	1,248	1,178	2,414	1.93	59	73.16%	89.50%
Apr 26 - May 2	1,674	1,613	2,959	1.77	49	78.55%	92.77%
May 3 - May 9	1,514	1,452	2,676	1.77	48	77.61%	90.55%
May 10 - May 16	1,302	1,246	2,219	1.7	45	77.57%	90.63%
May 17 - May 23	1,191	1,137	2,400	2.02	59	73.47%	89.76%
May 24 - May 30	957	912	1,904	1.99	54	70.85%	89.45%
May 31 - Jun 6	963	909	2,156	2.24	76	68.33%	86.92%
Jun 7 - Jun 13	882	848	1,827	2.07	50	69.95%	88.89%
Jun 14 - Jun 20	942	896	2,068	2.2	73	68.58%	88.43%
Jun 21 - Jun 27	835	789	1,739	2.08	77	66.35%	87.66%
Jun 28 - Jul 4	802	762	1,764	2.2	73	65.71%	89.65%
Jul 5 - Jul 11	806	750	1,741	2.16	81	65.26%	84.62%
Jul 12 - Jul 18	900	828	2,074	2.3	65	64.56%	85.56%
Jul 19 - Jul 25	860	811	1,922	2.23	75	64.65%	86.86%
Jul 26 - Aug 1	924	828	2,131	2.31	78	64.18%	81.93%
Aug 2 - Aug 8	792	737	1,615	2.04	67	68.18%	85.48%
Aug 9 - Aug 15	781	718	1,598	2.05	69	66.33%	83.99%
Aug 16 - Aug 22	776	714	1,849	2.38	70	63.79%	84.15%
Aug 23 - Aug 29	772	709	1,767	2.29	72	61.92%	85.23%

Financials

Quality Alloys
Weekly Financial Data		Initial "Shakedown" Period			Pre and Post Promotion Periods
May 25, 2008 - August 29, 2009		Promotion Period			are unshaded.
											Question 1
Week (2008-2009)	Revenue	Profit	Lbs. Sold	Inquiries
May 25 - May 31	$480,728	$118,684	16,585	13
Jun 1 - Jun 7	$641,155	$269,605	18,906	7
Jun 8 - Jun 14	$890,077	$275,218	28,053	5
Jun 15 - Jun 21	$552,674	$204,153	19,382	3
Jun 22 - Jun 28	$750,777	$256,091	24,274	3
Jun 29 - Jul 5	$553,055	$178,135	15,309	5
Jul 6 - Jul 12	$274,568	$62,580	8,633	16
Jul 13 - Jul 19	$619,285	$248,458	17,216	7
Jul 20 - Jul 26	$674,485	$238,498	17,309	6
Jul 27 - Aug 2	$762,559	$230,238	24,571	6
Aug 3 - Aug 9	$479,084	$156,660	14,390	4
Aug 10 - Aug 16	$528,271	$186,776	17,231	9
Aug 17 - Aug 23	$540,676	$164,499	13,802	10
Aug 24 - Aug 30	$768,109	$213,673	26,653	8
Aug 31 - Sep 6	$403,820	$135,191	12,403	8
Sep 7 - Sep 13	$388,745	$148,951	11,695	11
Sep 14 - Sep 20	$622,367	$153,422	26,362	9
Sep 21 - Sep 27	$456,012	$158,316	15,772	6
Sep 28 - Oct 4	$951,216	$273,175	31,969	8
Oct 5 - Oct 11	$534,542	$167,637	15,531	10
Oct 12 - Oct 18	$537,652	$134,115	19,734	1
Oct 19 - Oct 25	$623,710	$228,045	17,193	5
Oct 26 - Nov 1	$764,839	$202,703	22,591	9
Nov 2 - Nov 8	$315,647	$119,860	8,992	8
Nov 9 - Nov 15	$610,985	$170,026	19,104	6
Nov 16 - Nov 22	$563,525	$189,705	21,455	6
Nov 23 - Nov 29	$555,497	$123,129	18,784	4
Nov 30 - Dec 6	$432,657	$121,400	14,298	9
Dec 7 - Dec 13	$488,986	$152,476	17,215	4
Dec 14 - Dec 20	$689,428	$215,421	27,257	7
Dec 21 - Dec 27	$343,105	$100,388	11,292	3
Dec 28 - Jan 3	$605,155	$119,903	20,148	1
Jan 4 - Jan 10	$407,277	$134,854	16,454	8			Question 5		Correlation Coefficient (r):			0.8689297129				Question 6		Correlation Coefficient:			-0.0593918305
Jan 11 - Jan 17	$405,484	$129,974	12,703	7
Jan 18 - Jan 24	$519,934	$179,884	26,303	6
Jan 25 - Jan 31	$614,455	$113,249	22,199	4
Feb 1 - Feb 7	$516,270	$193,465	16,535	5
Feb 8 - Feb 14	$297,813	$89,803	7,814	7
Feb 15 - Feb 21	$692,677	$184,368	28,041	7
Feb 22 - Feb 28	$897,164	$266,477	31,496	11
Mar 1 - Mar 7	$417,727	$111,835	10,181	9
Mar 8 - Mar 14	$326,969	$122,687	9,727	4
Mar 15 - Mar 21	$326,482	$114,328	18,323	8
Mar 22 - Mar 28	$508,027	$159,945	17,299	6
Mar 29 - Apr 4	$413,937	$143,254	13,862	7
Apr 5 - Apr 11	$422,488	$81,841	19,007	5
Apr 12 - Apr 18	$376,751	$137,256	23,284	9
Apr 19 - Apr 25	$410,241	$90,175	17,374	3
Apr 26 - May 2	$549,750	$138,599	18,195	5
May 3 - May 9	$268,160	$98,680	9,176	5			Question 7
May 10 - May 16	$322,730	$84,806	12,881	7			The negative correlation between revenue and number of visits implies that QA receives the majority of its orders from a small group of people. Looking at the graph of unique visits and the graphs of profit and revenue, it appears that a small number of customers (possibly "regulars") buy the product cyclically with spikes in purchases occuring every 2-3 months. While there is a spike in profit & revenue during the promotional period, the spike matches the previous two spikes in revenue & profit, and occurrs at roughly the same distance apart from the previous spikes. This implies that the spike during the promotional period may not have been caused by the promotion, and rather that a core group of customers purchases increased number of products roughly every 2-3 months. Additionally, it appears that QAs customer base is steadily declining. Unique visits were declining prior to the promotional period. After the temporary spike, it appears that visits are again on the decline. This decline is mirrored in the revenue, profit, and pounds sold data.
May 17 - May 23	$397,140	$112,040	15,524	6
May 24 - May 30	$370,914	$102,976	15,406	5
May 31 - Jun 6	$299,425	$89,826	14,536	3
Jun 7 - Jun 13	$297,326	$106,085	10,397	3
Jun 14 - Jun 20	$336,762	$110,672	11,054	6
Jun 21 - Jun 27	$419,302	$100,319	17,855	2
Jun 28 - Jul 4	$191,172	$46,906	7,197	6
Jul 5 - Jul 11	$133,967	$32,825	3,826	7
Jul 12 - Jul 18	$615,713	$166,568	22,821	11
Jul 19 - Jul 25	$360,033	$121,356	12,758	4
Jul 26 - Aug 1	$573,918	$187,699	22,325	4
Aug 2 - Aug 8	$397,550	$124,641	18,566	5
Aug 9 - Aug 15	$282,045	$75,557	12,294	5
Aug 16 - Aug 22	$310,116	$82,771	11,293	7
Aug 23 - Aug 29	$615,950	$206,441	23,762	8

Financials

Lbs. Sold

Quality Alloys
Lbs. of Material Sold Per Week
Week of Jan. 3, 2005 through week of July 19, 2010.
Week	Lbs. Sold				Question 8A					Question 8B	(Chart to the right)
7/5/09	3,826				Mean	18,682					Max	44740
7/1/07	4,173				Median	24,283					Min	3826
7/3/05	4,536				SD	6840.5079395209
7/4/10	5,380				Min	3826							Bins
9/6/09	6,662				Max	44740							3500
12/20/09	6,715												7500
6/28/09	7,197				Question 8C								11500				Bin	Frequency
2/8/09	7,814				The histogram appears to have a bell shape								15500				3500	0
10/7/07	7,828												19500				7500	7
2/4/07	8,085				Question 8D								23500				11500	31
1/3/10	8,102				Interval	Theoretical % of Data	Theoretical No. of Obs	Actual No. of Obs					27500				15500	65
3/11/07	8,492				mean +1 St.Dev	68%	197.2	201					31500				19500	70
12/30/07	8,569				mean +2 St.Dev	95%	275.5	276					35500				23500	55
7/6/08	8,633				mean +3 St.Dev	99%	287.1	288					39500				27500	29
8/5/07	8,736												43500				31500	20
11/20/05	8,741												47500				35500	7
11/19/06	8,821																39500	4
11/2/08	8,992																43500	1
5/3/09	9,176																47500	1
4/15/07	9,299																More	0
12/17/06	9,557
12/16/07	9,663
3/8/09	9,727
1/14/07	10,036
3/1/09	10,181
6/7/09	10,397
10/15/06	10,420
9/16/07	10,668
11/1/09	10,741
5/14/06	10,841
6/14/09	11,054
5/18/08	11,076
9/2/07	11,135
12/21/08	11,292
8/16/09	11,293
11/6/05	11,307
8/30/09	11,308
9/10/06	11,398
3/14/10	11,532
9/7/08	11,695
11/8/09	11,722
6/11/06	11,785
8/7/05	11,804
7/15/07	11,964
6/6/10	12,274
8/9/09	12,294
8/19/07	12,353
1/1/06	12,383
8/31/08	12,403
7/31/05	12,409
3/18/07	12,426
12/9/07	12,456
4/8/07	12,558
1/7/07	12,683
1/9/05	12,699
1/11/09	12,703
7/19/09	12,758
10/9/05	12,779
5/10/09	12,881
3/28/10	12,908
11/12/06	13,139
8/20/06	13,208
5/6/07	13,354
3/16/08	13,394
10/14/07	13,435
11/18/07	13,680
8/17/08	13,802
3/29/09	13,862
9/30/07	13,886
10/8/06	13,902
1/10/10	13,969
5/11/08	14,145
7/2/06	14,172
11/30/08	14,298
7/18/10	14,307
8/3/08	14,390
1/29/06	14,435
4/30/06	14,443
4/3/05	14,492
2/14/10	14,516
5/31/09	14,536
12/10/06	14,567
4/17/05	14,678
3/13/05	14,748
9/27/09	14,764
5/16/10	14,793
11/11/07	14,836
6/13/10	14,862
6/10/07	14,905
10/4/09	14,905
9/13/09	14,995
11/29/09	15,038
8/13/06	15,125
4/9/06	15,146
1/8/06	15,179
5/8/05	15,220
3/4/07	15,258
9/3/06	15,273
12/31/06	15,284
6/29/08	15,309
4/29/07	15,326
6/4/06	15,389
5/24/09	15,406
5/15/05	15,504
11/22/09	15,513
5/17/09	15,524
10/5/08	15,531
1/21/07	15,723
5/9/10	15,729
4/13/08	15,735
9/21/08	15,772
6/5/05	15,901
2/7/10	15,911
8/12/07	16,107
5/29/05	16,153
11/4/07	16,170
2/11/07	16,282
10/29/06	16,320
6/17/07	16,386
1/4/09	16,454
2/1/09	16,535
6/19/05	16,538
5/25/08	16,585
11/26/06	16,599
10/11/09	16,611
3/6/05	16,655
12/18/05	16,668
3/19/06	16,733
2/12/06	16,746
1/6/08	16,856
12/4/05	16,858
7/29/07	16,925
9/17/06	17,026
4/20/08	17,188
10/19/08	17,193
12/7/08	17,215
7/13/08	17,216
8/10/08	17,231
3/22/09	17,299
7/20/08	17,309
9/4/05	17,369
4/19/09	17,374
2/17/08	17,411
11/15/09	17,457
1/31/10	17,645
5/1/05	17,701
7/11/10	17,776
6/21/09	17,855
5/4/08	17,902
7/17/05	18,003
1/20/08	18,139
3/20/05	18,159
4/26/09	18,195
12/25/05	18,211
3/15/09	18,323
10/18/09	18,343
11/27/05	18,382
4/16/06	18,491
8/2/09	18,566
1/22/06	18,630
4/2/06	18,688
11/23/08	18,784
6/1/08	18,906
4/5/09	19,007
4/10/05	19,012
7/9/06	19,088
11/9/08	19,104
4/4/10	19,234
6/15/08	19,382
10/21/07	19,429
6/20/10	19,431
3/2/08	19,459
10/1/06	19,499
5/27/07	19,585
1/24/10	19,592
10/12/08	19,734
3/5/06	19,803
1/13/08	19,903
12/3/06	19,955
2/13/05	20,023
4/11/10	20,026
7/8/07	20,030
12/28/08	20,148
11/5/06	20,178
9/25/05	20,309
6/24/07	20,385
1/30/05	20,516
3/7/10	20,585
12/6/09	20,636
2/5/06	20,673
9/11/05	20,737
12/13/09	20,792
10/16/05	20,803
11/13/05	20,819
3/12/06	20,948
10/23/05	20,969
12/2/07	21,080
9/20/09	21,218
2/3/08	21,289
5/13/07	21,417
4/6/08	21,431
11/16/08	21,455
10/30/05	21,603
8/28/05	21,608
6/27/10	21,976
4/1/07	21,981
6/25/06	22,022
7/22/07	22,061
3/27/05	22,149
1/25/09	22,199
6/18/06	22,207
12/27/09	22,207
4/18/10	22,317
7/26/09	22,325
2/19/06	22,465
10/26/08	22,591
9/18/05	22,595
7/12/09	22,821
7/16/06	22,882
10/2/05	22,996
8/14/05	23,045
1/16/05	23,095
10/28/07	23,102
3/9/08	23,140
7/30/06	23,144
2/18/07	23,178
4/12/09	23,284
2/28/10	23,285
2/27/05	23,615
1/2/05	23,662
12/23/07	23,735
8/23/09	23,762
7/23/06	23,800
5/22/05	23,957
6/22/08	24,274
7/27/08	24,571
3/21/10	24,894
5/7/06	24,897
2/25/07	24,919
10/25/09	25,017
2/21/10	25,250
1/28/07	25,288
1/15/06	25,430
4/22/07	25,516
5/20/07	25,529
2/6/05	25,546
2/26/06	25,554
1/18/09	26,303
12/24/06	26,341
9/14/08	26,362
6/26/05	26,581
6/12/05	26,637
8/24/08	26,653
7/10/05	26,737
12/11/05	26,865
12/14/08	27,257
8/27/06	27,332
10/22/06	27,658
5/30/10	27,704
1/23/05	27,944
2/15/09	28,041
5/28/06	28,048
6/8/08	28,053
2/24/08	28,128
4/25/10	28,181
8/26/07	28,451
9/9/07	28,543
9/23/07	28,752
8/21/05	28,865
6/3/07	28,865
5/2/10	28,906
8/6/06	29,106
7/24/05	30,773
5/23/10	30,790
4/24/05	30,844
3/30/08	31,014
2/22/09	31,496
9/28/08	31,972
3/25/07	32,266
9/24/06	32,999
3/26/06	33,023
2/10/08	34,252
3/23/08	34,894
2/20/05	35,247
1/17/10	35,669
5/21/06	35,834
1/27/08	36,322
4/23/06	36,856
11/25/07	40,447
4/27/08	44,740

Lbs. Sold

Daily Visits

Quality Analytics
Daily Visits
May 25, 2008 - August 29, 2009
Day	Visits
Sunday, May 25, 2008	182
Monday, May 26, 2008	195
Tuesday, May 27, 2008	304
Wednesday, May 28, 2008	282
Thursday, May 29, 2008	263
Friday, May 30, 2008	218
Saturday, May 31, 2008	188
Sunday, June 1, 2008	195
Monday, June 2, 2008	244
Tuesday, June 3, 2008	241
Wednesday, June 4, 2008	252
Thursday, June 5, 2008	241
Friday, June 6, 2008	209
Saturday, June 7, 2008	198
Sunday, June 8, 2008	195
Monday, June 9, 2008	247
Tuesday, June 10, 2008	231
Wednesday, June 11, 2008	224
Thursday, June 12, 2008	198
Friday, June 13, 2008	180
Saturday, June 14, 2008	166
Sunday, June 15, 2008	179
Monday, June 16, 2008	218
Tuesday, June 17, 2008	227
Wednesday, June 18, 2008	228
Thursday, June 19, 2008	228
Friday, June 20, 2008	204
Saturday, June 21, 2008	168
Sunday, June 22, 2008	178
Monday, June 23, 2008	167
Tuesday, June 24, 2008	192
Wednesday, June 25, 2008	199
Thursday, June 26, 2008	219
Friday, June 27, 2008	206
Saturday, June 28, 2008	178
Sunday, June 29, 2008	184
Monday, June 30, 2008	193
Tuesday, July 1, 2008	204
Wednesday, July 2, 2008	90
Thursday, July 3, 2008	94
Friday, July 4, 2008	60
Saturday, July 5, 2008	67
Sunday, July 6, 2008	91
Monday, July 7, 2008	140
Tuesday, July 8, 2008	129
Wednesday, July 9, 2008	142
Thursday, July 10, 2008	129
Friday, July 11, 2008	110
Saturday, July 12, 2008	56
Sunday, July 13, 2008	68
Monday, July 14, 2008	127
Tuesday, July 15, 2008	116
Wednesday, July 16, 2008	127
Thursday, July 17, 2008	114
Friday, July 18, 2008	125
Saturday, July 19, 2008	67
Sunday, July 20, 2008	91
Monday, July 21, 2008	139
Tuesday, July 22, 2008	232
Wednesday, July 23, 2008	165
Thursday, July 24, 2008	185
Friday, July 25, 2008	148
Saturday, July 26, 2008	84
Sunday, July 27, 2008	74
Monday, July 28, 2008	163
Tuesday, July 29, 2008	159
Wednesday, July 30, 2008	178
Thursday, July 31, 2008	126
Friday, August 1, 2008	111
Saturday, August 2, 2008	95
Sunday, August 3, 2008	85
Monday, August 4, 2008	150
Tuesday, August 5, 2008	149
Wednesday, August 6, 2008	139
Thursday, August 7, 2008	111
Friday, August 8, 2008	124
Saturday, August 9, 2008	91
Sunday, August 10, 2008	77
Monday, August 11, 2008	122
Tuesday, August 12, 2008	115
Wednesday, August 13, 2008	125
Thursday, August 14, 2008	110
Friday, August 15, 2008	112
Saturday, August 16, 2008	76
Sunday, August 17, 2008	74
Monday, August 18, 2008	107
Tuesday, August 19, 2008	134
Wednesday, August 20, 2008	115
Thursday, August 21, 2008	122
Friday, August 22, 2008	108
Saturday, August 23, 2008	74
Sunday, August 24, 2008	73
Monday, August 25, 2008	111
Tuesday, August 26, 2008	103
Wednesday, August 27, 2008	98
Thursday, August 28, 2008	97
Friday, August 29, 2008	77
Saturday, August 30, 2008	67
Sunday, August 31, 2008	64
Monday, September 1, 2008	59
Tuesday, September 2, 2008	91
Wednesday, September 3, 2008	108
Thursday, September 4, 2008	107
Friday, September 5, 2008	83
Saturday, September 6, 2008	65
Sunday, September 7, 2008	59
Monday, September 8, 2008	85
Tuesday, September 9, 2008	91
Wednesday, September 10, 2008	102
Thursday, September 11, 2008	95
Friday, September 12, 2008	81
Saturday, September 13, 2008	49
Sunday, September 14, 2008	57
Monday, September 15, 2008	95
Tuesday, September 16, 2008	98
Wednesday, September 17, 2008	105
Thursday, September 18, 2008	81
Friday, September 19, 2008	77
Saturday, September 20, 2008	50
Sunday, September 21, 2008	52
Monday, September 22, 2008	84
Tuesday, September 23, 2008	137
Wednesday, September 24, 2008	122
Thursday, September 25, 2008	103
Friday, September 26, 2008	98
Saturday, September 27, 2008	56
Sunday, September 28, 2008	59
Monday, September 29, 2008	94
Tuesday, September 30, 2008	111
Wednesday, October 1, 2008	98
Thursday, October 2, 2008	105
Friday, October 3, 2008	86
Saturday, October 4, 2008	58
Sunday, October 5, 2008	51
Monday, October 6, 2008	91
Tuesday, October 7, 2008	87
Wednesday, October 8, 2008	84
Thursday, October 9, 2008	99
Friday, October 10, 2008	96
Saturday, October 11, 2008	53
Sunday, October 12, 2008	51
Monday, October 13, 2008	88
Tuesday, October 14, 2008	81
Wednesday, October 15, 2008	101
Thursday, October 16, 2008	88
Friday, October 17, 2008	103
Saturday, October 18, 2008	46
Sunday, October 19, 2008	59
Monday, October 20, 2008	86
Tuesday, October 21, 2008	92
Wednesday, October 22, 2008	101
Thursday, October 23, 2008	94
Friday, October 24, 2008	85
Saturday, October 25, 2008	53
Sunday, October 26, 2008	47
Monday, October 27, 2008	91
Tuesday, October 28, 2008	99
Wednesday, October 29, 2008	95
Thursday, October 30, 2008	89
Friday, October 31, 2008	83
Saturday, November 1, 2008	47
Sunday, November 2, 2008	39
Monday, November 3, 2008	84
Tuesday, November 4, 2008	90
Wednesday, November 5, 2008	94
Thursday, November 6, 2008	93
Friday, November 7, 2008	86
Saturday, November 8, 2008	51
Sunday, November 9, 2008	48
Monday, November 10, 2008	84
Tuesday, November 11, 2008	91
Wednesday, November 12, 2008	103
Thursday, November 13, 2008	96
Friday, November 14, 2008	74
Saturday, November 15, 2008	47
Sunday, November 16, 2008	52
Monday, November 17, 2008	94
Tuesday, November 18, 2008	91
Wednesday, November 19, 2008	116
Thursday, November 20, 2008	74
Friday, November 21, 2008	80
Saturday, November 22, 2008	51
Sunday, November 23, 2008	58
Monday, November 24, 2008	75
Tuesday, November 25, 2008	131
Wednesday, November 26, 2008	106
Thursday, November 27, 2008	56
Friday, November 28, 2008	57
Saturday, November 29, 2008	53
Sunday, November 30, 2008	58
Monday, December 1, 2008	78
Tuesday, December 2, 2008	102
Wednesday, December 3, 2008	93
Thursday, December 4, 2008	82
Friday, December 5, 2008	83
Saturday, December 6, 2008	53
Sunday, December 7, 2008	52
Monday, December 8, 2008	96
Tuesday, December 9, 2008	85
Wednesday, December 10, 2008	86
Thursday, December 11, 2008	98
Friday, December 12, 2008	84
Saturday, December 13, 2008	44
Sunday, December 14, 2008	58
Monday, December 15, 2008	81
Tuesday, December 16, 2008	117
Wednesday, December 17, 2008	81
Thursday, December 18, 2008	111
Friday, December 19, 2008	81
Saturday, December 20, 2008	62
Sunday, December 21, 2008	49
Monday, December 22, 2008	70
Tuesday, December 23, 2008	67
Wednesday, December 24, 2008	57
Thursday, December 25, 2008	53
Friday, December 26, 2008	41
Saturday, December 27, 2008	46
Sunday, December 28, 2008	53
Monday, December 29, 2008	74
Tuesday, December 30, 2008	55
Wednesday, December 31, 2008	53
Thursday, January 1, 2009	53
Friday, January 2, 2009	49
Saturday, January 3, 2009	65
Sunday, January 4, 2009	50
Monday, January 5, 2009	85
Tuesday, January 6, 2009	84
Wednesday, January 7, 2009	87
Thursday, January 8, 2009	105
Friday, January 9, 2009	84
Saturday, January 10, 2009	52
Sunday, January 11, 2009	37
Monday, January 12, 2009	96
Tuesday, January 13, 2009	97
Wednesday, January 14, 2009	92
Thursday, January 15, 2009	122
Friday, January 16, 2009	106
Saturday, January 17, 2009	81
Sunday, January 18, 2009	67
Monday, January 19, 2009	113
Tuesday, January 20, 2009	108
Wednesday, January 21, 2009	132
Thursday, January 22, 2009	135
Friday, January 23, 2009	116
Saturday, January 24, 2009	124
Sunday, January 25, 2009	80
Monday, January 26, 2009	141
Tuesday, January 27, 2009	165
Wednesday, January 28, 2009	165
Thursday, January 29, 2009	175
Friday, January 30, 2009	135
Saturday, January 31, 2009	139
Sunday, February 1, 2009	145
Monday, February 2, 2009	144
Tuesday, February 3, 2009	186
Wednesday, February 4, 2009	145
Thursday, February 5, 2009	173
Friday, February 6, 2009	177
Saturday, February 7, 2009	237
Sunday, February 8, 2009	262
Monday, February 9, 2009	319
Tuesday, February 10, 2009	309
Wednesday, February 11, 2009	330
Thursday, February 12, 2009	329
Friday, February 13, 2009	361
Saturday, February 14, 2009	407
Sunday, February 15, 2009	392
Monday, February 16, 2009	277
Tuesday, February 17, 2009	276
Wednesday, February 18, 2009	288
Thursday, February 19, 2009	216
Friday, February 20, 2009	247
Saturday, February 21, 2009	317
Sunday, February 22, 2009	240
Monday, February 23, 2009	307
Tuesday, February 24, 2009	428
Wednesday, February 25, 2009	248
Thursday, February 26, 2009	357
Friday, February 27, 2009	375
Saturday, February 28, 2009	369
Sunday, March 1, 2009	538
Monday, March 2, 2009	545
Tuesday, March 3, 2009	448
Wednesday, March 4, 2009	546
Thursday, March 5, 2009	624
Friday, March 6, 2009	518
Saturday, March 7, 2009	507
Sunday, March 8, 2009	315
Monday, March 9, 2009	664
Tuesday, March 10, 2009	478
Wednesday, March 11, 2009	189
Thursday, March 12, 2009	238
Friday, March 13, 2009	209
Saturday, March 14, 2009	470
Sunday, March 15, 2009	476
Monday, March 16, 2009	541
Tuesday, March 17, 2009	436
Wednesday, March 18, 2009	485
Thursday, March 19, 2009	518
Friday, March 20, 2009	419
Saturday, March 21, 2009	131
Sunday, March 22, 2009	213
Monday, March 23, 2009	308
Tuesday, March 24, 2009	234
Wednesday, March 25, 2009	224
Thursday, March 26, 2009	232
Friday, March 27, 2009	221
Saturday, March 28, 2009	231
Sunday, March 29, 2009	220
Monday, March 30, 2009	251
Tuesday, March 31, 2009	267
Wednesday, April 1, 2009	169
Thursday, April 2, 2009	253
Friday, April 3, 2009	285
Saturday, April 4, 2009	334
Sunday, April 5, 2009	132
Monday, April 6, 2009	170
Tuesday, April 7, 2009	185
Wednesday, April 8, 2009	178
Thursday, April 9, 2009	157
Friday, April 10, 2009	147
Saturday, April 11, 2009	117
Sunday, April 12, 2009	120
Monday, April 13, 2009	186
Tuesday, April 14, 2009	175
Wednesday, April 15, 2009	176
Thursday, April 16, 2009	203
Friday, April 17, 2009	186
Saturday, April 18, 2009	185
Sunday, April 19, 2009	108
Monday, April 20, 2009	159
Tuesday, April 21, 2009	184
Wednesday, April 22, 2009	166
Thursday, April 23, 2009	159
Friday, April 24, 2009	293
Saturday, April 25, 2009	179
Sunday, April 26, 2009	242
Monday, April 27, 2009	192
Tuesday, April 28, 2009	242
Wednesday, April 29, 2009	241
Thursday, April 30, 2009	271
Friday, May 1, 2009	283
Saturday, May 2, 2009	203
Sunday, May 3, 2009	218
Monday, May 4, 2009	248
Tuesday, May 5, 2009	216
Wednesday, May 6, 2009	204
Thursday, May 7, 2009	233
Friday, May 8, 2009	222
Saturday, May 9, 2009	173
Sunday, May 10, 2009	186
Monday, May 11, 2009	200
Tuesday, May 12, 2009	184
Wednesday, May 13, 2009	176
Thursday, May 14, 2009	205
Friday, May 15, 2009	197
Saturday, May 16, 2009	154
Sunday, May 17, 2009	176
Monday, May 18, 2009	199
Tuesday, May 19, 2009	166
Wednesday, May 20, 2009	176
Thursday, May 21, 2009	162
Friday, May 22, 2009	175
Saturday, May 23, 2009	137
Sunday, May 24, 2009	137
Monday, May 25, 2009	139
Tuesday, May 26, 2009	161
Wednesday, May 27, 2009	158
Thursday, May 28, 2009	129
Friday, May 29, 2009	137
Saturday, May 30, 2009	96
Sunday, May 31, 2009	112
Monday, June 1, 2009	144
Tuesday, June 2, 2009	148
Wednesday, June 3, 2009	148
Thursday, June 4, 2009	145
Friday, June 5, 2009	159
Saturday, June 6, 2009	107
Sunday, June 7, 2009	107
Monday, June 8, 2009	144
Tuesday, June 9, 2009	132
Wednesday, June 10, 2009	138
Thursday, June 11, 2009	135
Friday, June 12, 2009	130
Saturday, June 13, 2009	96
Sunday, June 14, 2009	118
Monday, June 15, 2009	145
Tuesday, June 16, 2009	146
Wednesday, June 17, 2009	139
Thursday, June 18, 2009	150
Friday, June 19, 2009	143
Saturday, June 20, 2009	101
Sunday, June 21, 2009	89
Monday, June 22, 2009	134
Tuesday, June 23, 2009	131
Wednesday, June 24, 2009	132
Thursday, June 25, 2009	139
Friday, June 26, 2009	116
Saturday, June 27, 2009	94
Sunday, June 28, 2009	96
Monday, June 29, 2009	134
Tuesday, June 30, 2009	135
Wednesday, July 1, 2009	121
Thursday, July 2, 2009	128
Friday, July 3, 2009	100
Saturday, July 4, 2009	88
Sunday, July 5, 2009	105
Monday, July 6, 2009	149
Tuesday, July 7, 2009	121
Wednesday, July 8, 2009	119
Thursday, July 9, 2009	118
Friday, July 10, 2009	115
Saturday, July 11, 2009	79
Sunday, July 12, 2009	122
Monday, July 13, 2009	150
Tuesday, July 14, 2009	140
Wednesday, July 15, 2009	128
Thursday, July 16, 2009	146
Friday, July 17, 2009	120
Saturday, July 18, 2009	94
Sunday, July 19, 2009	100
Monday, July 20, 2009	136
Tuesday, July 21, 2009	156
Wednesday, July 22, 2009	142
Thursday, July 23, 2009	107
Friday, July 24, 2009	122
Saturday, July 25, 2009	97
Sunday, July 26, 2009	88
Monday, July 27, 2009	119
Tuesday, July 28, 2009	193
Wednesday, July 29, 2009	150
Thursday, July 30, 2009	139
Friday, July 31, 2009	141
Saturday, August 1, 2009	94
Sunday, August 2, 2009	86
Monday, August 3, 2009	143
Tuesday, August 4, 2009	111
Wednesday, August 5, 2009	147
Thursday, August 6, 2009	128
Friday, August 7, 2009	108
Saturday, August 8, 2009	69
Sunday, August 9, 2009	84
Monday, August 10, 2009	141
Tuesday, August 11, 2009	126
Wednesday, August 12, 2009	120
Thursday, August 13, 2009	113
Friday, August 14, 2009	106
Saturday, August 15, 2009	91
Sunday, August 16, 2009	95
Monday, August 17, 2009	109
Tuesday, August 18, 2009	122
Wednesday, August 19, 2009	151
Thursday, August 20, 2009	138
Friday, August 21, 2009	101
Saturday, August 22, 2009	60
Sunday, August 23, 2009	80
Monday, August 24, 2009	137
Tuesday, August 25, 2009	147
Wednesday, August 26, 2009	132
Thursday, August 27, 2009	101
Friday, August 28, 2009	112
Saturday, August 29, 2009	63

Demographics

Quality Alloys
Source and Other Data
May 25, 2008 - August 29, 2009
1)	All Traffic Sources
		Visits
	Referring Sites	38,754
	Search Engines	20,964
	Direct Traffic	9,709
	Other	4
2)	Top Ten Referring Sites
		Visits
	googleads.g.doubleclick.net	15,626
	pagead2.googlesyndication.com	8,044
	sedoparking.com	3,138
	globalspec.com	693
	searchportal.information.com	582
	freepatentsonline.com	389
	thomasnet.com	379
	mu.com	344
	mail.google.com	337
	psicofxp.com	310
3)	Top Ten Search Engine Sources of Visits
		Visits
	google	17,681
	yahoo	1,250
	search	592
	msn	424
	aol	309
	ask	268
	live	145
	bing	122
	voila	63
	netscape	26
4)	Top Ten Geographic Sources by Sub Continent Region
		Visits
	South America	22,616
	Northern America	17,509
	Central America	6,776
	Western Europe	5,214
	Eastern Asia	3,228
	Northern Europe	2,721
	Southern Asia	2,589
	South-Eastern Asia	1,968
	Southern Europe	1,538
	Eastern Europe	1,427
5)	Top Ten Browsers Used
		Visits
	Internet Explorer	53,080
	Firefox	13,142
	Opera	938
	Safari	850
	Chrome	792
	Mozilla	478
	Netscape	47
	Konqueror	31
	SeaMonkey	24
	Camino	9
6)	Top Ten Operating Systems Used
		Visits
	Windows	67,063
	Macintosh	1,184
	Linux	1,045
	(not set)	48
	iPhone	29
	SymbianOS	20
	FreeBSD	18
	iPod	8
	Playstation 3	4
	Playstation Portable	3

Sheet1

Pre-Promotion
	Visits	Unique Visits	Revenue	Profit	Lbs. Sold
mean	1,055
median
std. dev
miniminum
maximum
Promotion
	Visits	Unique Visits	Revenue	Profit	Lbs. Sold
mean
median
std. dev
miniminum
maximum
Post-Promotion
	Visits	Unique Visits	Revenue	Profit	Lbs. Sold
mean
median
std. dev
miniminum
maximum