PROJECT PLAN

Project Plan

Remember that for this project, you will need to create a dashboard that gives the user a snapshot of how well the organization is doing. Dashboards allow users to view easily view several charts or other visual indicators on one page or screen. Dashboard examples are included at the end of this document. You will also want to view the video tutorial on dashboards. See details of the dashboard project here. 

For this assignment, you are to create a plan for your dashboard. The purpose of the plan is to ensure you are on track with a good idea of what you want to do with the data. You do not need to create any charts at this point, only describe in words the following points: 

What dataset are you going to use (you must select one of the datasets provided to you in Module 14 in the project description)

What questions do you want the dashboard to answer?

What charts/visualizations will fit the data and help answer your questions? 

A good start to a dashboard plan is, “I will focus on the revenues and expenses of this company and how they track over time and among the regions. There are three questions I would like this dashboard to address. The first is, how do the differences between revenues and expenses compare over time? To answer this question, I will use a line chart to graph the data…” 

Your plan should be between 250 and 500 words. Be complete, but be direct.

2

>Worksheet

umber

Training Completed

Insurance

Insurance

man Resources

0

Y Y N

Y

1

N N Y

4

N

2 1 Y Y N

Y

0

N Y Y

Customer Service

N

N Y N

Hu

N

2 20 N N Y

$15 Y

0 4 N N N

0

Y 94 1 1 N Y Y

$15 N 89 2 3 Y Y Y

Media Relations $10 N

1 4 N Y N

Jamalia Sales and Marketing $15 Y 99 2 0 N Y N

Advertising $25 N

0

Y N N

n

Advertising $10 Y

1 8 Y Y N

3

$25 Y 89 3 0 Y Y N

100

Legal Department $15 N 82 2 2 N N Y

Sales and Marketing $10 N

0 12 Y Y Y

$25 Y 99 0 5 Y N N

Advertising $15 N

0 11 N Y N

Payroll $15 Y 89 3 6 N N N

$15 N 78 1 1 N N Y

Accounting $15 Y 75 2 20 Y Y N

Media Relations

N 78 0 8 N Y N

Quality Assurance $10 N 84 2 0 Y Y Y

286

Payroll $10 N

3 3 N N Y

Quality Assurance $15 Y 76 2 12 N N Y

Accounting $10 Y 78 1

N N N

Ciara Customer Relations $15 Y

3 2 N Y Y

Sales and Marketing $10 Y 78 2 1 N Y N

Research and Development $25 N 90 2 5 Y Y N

Human Resources $25 N

0 6 N Y Y

287

Sales and Marketing $25 Y 79 1 1 Y Y Y

Payroll $15 N

2 15 N N N

ward

Accounting $10 Y

3 12 N N Y

Quality Assurance $25 N 87 0 6 N Y Y

264

Accounting $25 Y 77 2 2 Y Y Y

$25 N 94 2 11 Y Y N

Sales and Marketing $15 N 94 1 18 N N Y

Tech Support $10 N 76 1 14 Y Y Y

Tech Support $25 Y 80 0 2 Y N Y

Media Relations $25 Y 95 2 9 Y Y N

Tech Support $25 Y

0 5 Y Y Y

Tech Support $25 N 82 0 14 Y N Y

Payroll $20 N

0 18 N N N

287

Accounting $20 Y 87 0 1 N Y Y

Quality Assurance $10 N 98 1 16 Y N Y

Sales and Marketing $15 Y 80 1 11 Y Y N

Advertising $10 Y

0 12 Y Y N

Tech Support $25 Y

3 18 Y Y N

Conley

Research and Development $15 N 92 2 10 N Y N

Advertising $15 N 85 2 6 N Y N

Customer Relations $15 Y 100 1 11 N Y Y

Advertising $10 N 81 2 14 N Y N

Research and Development $10 Y 96 0 3 N Y N

253

Payroll $25 N 82 2 0 N N Y

156

Media Relations $15 N 97 3 13 N N Y

Research and Development $20 Y 78 2 3 Y N N

Research and Development $20 Y 88 2 5 Y Y N

Research and Development $25 N 87 0 9 N Y N

156

Sales and Marketing $15 N 83 2 3 N Y N

Accounting $20 N 99 3 11 Y Y Y

Advertising $20 Y 90 1 2 N Y Y

Advertising $10 N 90 3 20 Y Y Y

173

Orli Customer Relations $20 Y 81 3 14 Y Y Y

Media Relations $15 N 84 0 15 Y Y N

Sales and Marketing $20 N 98 3 5 N N N

Research and Development $20 Y 96 0 6 Y N Y

Customer Relations $25 Y 85 2 13 Y N Y

Advertising $15 N 77 3 6 Y Y N

Accounting $10 Y 88 2 9 N N N

Payroll $10 N 99 3 18 Y N N

Tech Support $25 Y 78 1 10 Y Y N

Legal Department $25 N 86 0 9 N Y N

Human Resources $10 Y 91 1 12 Y Y N

Bates

Human Resources $20 N 100 1 13 N Y Y

Advertising $25 Y 96 3 17 N Y N

Human Resources $15 N 80 2 7 N N Y

Research and Development $20 Y 95 2 18 N N Y

Quality Assurance $10 Y 81 2 1 N Y N

Accounting $15 Y 84 1 14 N Y N

182

Quality Assurance $15 N 100 2 9 N N Y

136

Media Relations $20 Y 83 0 3 N Y Y

Tanner

Quality Assurance $15 N 82 1 17 N N Y

281

Advertising $10 Y 96 0 1 Y Y N

170

Tech Support $10 N 97 1 12 Y Y N

217

Accounting $20 N 90 0 4 Y Y Y

Sales and Marketing $10 Y 88 0 17 N N N

132

Sales and Marketing $25 Y 86 0 12 Y Y N

Customer Service $25 Y 76 2 8 Y N Y

Wood

Accounting $15 N 83 3 11 N Y Y

Customer Service $10 Y 83 2 17 N N Y

129 Murphy

Accounting $15 Y 77 2 19 N Y Y

Holden

Customer Relations $15 Y 100 1 19 Y N N

Quality Assurance $20 Y 94 1 6 Y Y N

Quality Assurance $20 Y 80 2 13 N N Y

Research and Development $15 Y 95 2 3 N N Y

Merrill Darrel Tech Support $15 Y 95 2 16 N N Y

Research and Development $15 N 84 0 9 Y Y Y

Sales and Marketing $15 Y 86 0 15 N N N

Ingram

Legal Department $20 Y 93 3 2 Y N N

Quality Assurance $10 N 95 0 12 Y Y Y

Performance Index

0 0
70

80

90

100

Insurance

Dental $ 200
Vision $ 250
Medical

Department Open Positions
Media Relations 5
Sales and Marketing 3
Payroll 3
Advertising 2
Research and Development 7
Legal Department 5
Quality Assurance 2
Accounting 3
Customer Relations 1

Hourly Employees

Employee

N

Last Name

First Name

Department

Hourly Pay Rate

Customer Service

Performance Index

Unexcused Absenses

Accrued Vacation

Vision

Insurance

Dental

Medical

1

4

0

Hooper

Jamalia

Hu

$2

5

Y

7

9

12

251

Buck

William

Human Resources

$

10

100

19

1

8

Patel

Bernard

Legal Department

$25

81

2

98

Webster

Desirae

Advertising

$

20

89

18

257

Herman

Cara

$

15

99

3

6

223

Rivas

Customer Relations

$15

75

281

Hutchinson

Wynne

Media Relations

94

11

Marshall

Eleanor

Sales and Marketing

$10

2

86

Chapman

Ryan

Payroll

121

Anthony

Rooney

87

287

Cruz

2

82

Cook

Lilah

95

13

231

Flores

Ciara

77

17

Mcleod

Liberty

Research and Development

Wilder

Alisa

294

Conley

Hanae

76

118

Cooper

Risa

Quality Assurance

1

78

Mccarthy

Kasper

84

247

Bates

Cadman

264

Schmidt

Breanna

Accounting

253

Cabrera

Flavia

237

Reid

Juliet

$20

132

Santana

Amena

Mosley

Amela

90

112

Carey

Brody

177

Cortez

Doris

14

141

Carver

83

179

Gilliam

Ignacia

101

Clay

Azalia

255

Barrera

Hasad

80

Price

Orli

122

Hinton

Delilah

93

136

Wood

Porter

88

193

Donovan

Kristen

Velez

Rigel

182

Atkins

Justin

Tech Support

145

Salazar

Blythe

248

Thompson

Leo

2

16

Fischer

Aurora

2

85

Byrd

Jackson

2

70

Morrison

Haley

92

220

Warner

Nerea

252

Williamson

Quinn

96

Morgan

Jolene

156

Holden

MacKenzie

169

Molina

Zelda

125

Weber

Ross

91

283

Avila

Raja

97

114

Rhona

137

Pierce

Avye

219

Houston

Charissa

217

Armstrong

Darrel

139

Ferrell

Ronan

Burnett

Cameran

Head

Susan

267

Gonzales

Scarlet

268

Oliver

Thaddeus

128

Horton

Dai

Workman

Donna

224

Flynn

Gail

170

Patterson

Hakeem

192

Baxter

Gage

Ingram

143

Irwin

Ryder

290

Murphy

Reagan

117

Hurley

Steven

185

Barlow

Zenia

225

Becker

Amy

284

Welch

Merrill

242

Lowe

Ferdinand

235

Leblanc

Tanner

129

Joyce

John

209

Browning

Tamara

250

Yael

178

Rodriquez

Meredith

207

Bowman

Jemima

105

Norris

Brennan

162

Collier

Sydney

148

Rowland

Igor

Mann

Arthur

Howard

Noel

203

Isaiah

Mckay

Elaine

Fleming

Maggy

Dorsey

Miranda

282

Zimmerman

Allegra

Hammond

Ray

198

Cain

Odysseus

300

Noah

212

Britt

Lucius

Shea

172

Fleur

274

Horn

Xyla

230

Mendoza

Iona

295

Bradshaw

Ira

232

280

Clarke

Dennis

127

Montgomery

Branden

120

Fuller

108

Duke

Declan

Bonus if customer service training is completed

$ 250

Performance Bonus Lookup Table

Amount

$ 200

$ 300

$ 400

$ 500

Benefits Expenses

This company pays for 100% of vision and dental, and 70% of medical

Premium paid for by company

$ 12,000

Open Positions

2

>Data

%

North

0

0

0

%

c

South

East

West

0

0

400

0

0

500 500 400

5

475 500

0

750

Mar

Cameron

80.00

5.00

,890.00

.00

,180.00

,

4.00

,

8.00

,996.00

,202.00

Jackie

4.00

8.00

,997.00

6.00

.00

,

0.00

Jose

,936.00

5.00

$ 40,260.00

.00

8.00

$ 28,665.00

2.00

.00

.00

,6

.00

.00

.00

Heidi

Matthew

5.00

9.00

Alison

0.00

6.00

9.00

Derek

Linda

$ 20,280.00

$ 36,600.00

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Cameron 64 59

50 35 37 67 69 44 56 40 48

Jackie 61

44

55 45 61

43 36 60 72

Jose 41 51 72 72 63 41 34 67 54 58 43 73
Marc 56 66 41 34 50 57 68 46 58 69 54 39
Heidi 49 54 61 71 53 62 61 45 64 73 54 38
Matthew 63 35 65 45 64 37 44 42 55 44 65 49
Alison 64 44 68 37 67 36 38 65

55 47 62

Derek 66 74 48 36 34 35 59 40 63 54 65 58
Linda 72 56 39 58 51 43 66 43 71 65 65 46

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

North

South

East

West

Midwest $ 31,746.00 $ 27,216.00 $ 20,280.00 $ 50,688.00 $ 40,401.00 $ 44,092.00 $ 36,144.00 $ 26,910.00 $ 32,424.00 $ 36,600.00 $ 46,221.00 $ 46,386.00

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

North

South

East

West

Midwest

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

North

7% 8%

11% 11%

10% 8%

South 10% 9%

9% 11%

12% 7% 15% 9% 15% 7%

East 9% 12% 8% 10% 11% 15% 11% 11% 8% 15% 8% 13%
West 11% 12% 9% 13% 9% 15% 7% 7% 15% 10% 11% 13%
Midwest 11% 13% 12% 12% 7% 12% 10% 11% 9% 14% 8% 12%

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

North

South

East

West

Midwest

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

North 4 9 6 9 5 6 10 10 7 5 5 6
South 7 6 7 7 10 6 8 8 5 5 6 10
East 7 9 9 7 8 7 7 7 8 9 6 6
West 6 7 8 8 7 6 8 6 8 12 6 5
Midwest 7 7 10 9 7 7 8 6 9 7 7 5

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

North 4 4 2 3 2 1 4 3 4 1 1 3
South 2 2 1 2 2 4 4 2 3 4 2 1
East 4 1 4 1 1 2 2 3 2 1 2 2
West 1 2 3 2 1 3 3 4 2 3 3 1
Midwest 2 3 1 2 3 3 2 1 3 2 1 4

														Company Data for CRM Technologies
Salesperson Region Assignment	Commission rates lookup Table
		Cameron								North	20000															3
		Jackie	3												5	5%
		Jose								South	50000																								7
								Mar
		Heidi								East
		Matthew
		Alison								West
		Derek
		Linda							Midwest
	750																	4															6			47				55
Monthly Sales by Salesperson
							Jan								Feb								Apr								May								Jun								Jul								Aug								Sep								Oct								Nov								Dec
$ 47,									8	$ 27,			66	$															1							9	$ 23,8			34		$ 40,260.00	$			36	$			37					44	$	42		69	$ 26,055.00	$		39	$			41	$ 34,160.00
$ 32,376.00	$ 26,					10	$ 37,000.00	$ 39,				64	$ 30,050.00	$ 36,300.00	$			35	$ 42,		48		$ 28,6						65	$ 22,876.00	$ 42,315.00	$		51	12
$	57	$ 21,844.00	$ 21,		71	$ 31,020.00	$ 33,550.00	$ 34,0		68	$ 19,				61	$ 20,			67	$ 37,4		49	$ 34,850.00
	Marc	$ 47,992.00	$ 34,8			45			$ 20,280.00	$ 36,920.00	$ 26,840.00	$ 32,778.00	$ 19,304.00	$		38		59	$ 32,2			56	$ 37,8			63	$ 32,550.00	$ 29,138.00
$ 48,507.00	$ 27,486.00	$ 33,198.00	$ 44,667.00	$ 33,055.00	$ 41,344.00	$ 29,913.00	$ 40,810.00	$ 33,408.00	$ 38,241.00	$ 38,704.00	$ 59,202.00
$ 48,963.00	$ 17,102.00	$ 24,	74	$ 33,888.00	$ 31,356.00	$ 28,896.00	$ 21,		62	$ 33,345.00	$ 20,808.00	$ 22,914.00	$ 26,160.00	$ 62,488.00
$ 41,184.00	$ 31,815.00	$ 23,		46	$ 29,		73	$ 40,128.00	$ 25,326.00	$ 31,626.00	$ 38,860.00	$ 34,456.00	$ 23,				43	$ 34,112.00	$ 43,000.00
$ 35,994.00	$ 22,396.00	$ 31,049.00	$ 45,056.00			$ 36,600.00	$ 30,350.00	$ 35,210.00	$ 38,793.00	$ 38,592.00	$ 20,706.00	$ 39,000.00	$ 47,190.00
	$ 31,746.00		$ 27,216.00		$ 50,688.00		$ 40,401.00		$ 44,092.00		$ 36,144.00		$ 26,910.00		$ 32,424.00		$ 46,221.00		$ 46,386.00
Number of Sales Calls per Month
	53
					54					58					72
52
Monthly Revenues by Region
$ 80,256.00	$ 53,769.00	$ 56,890.00	$ 63,482.00	$ 70,310.00	$ 72,480.00	$ 73,441.00	$ 85,184.00	$ 54,720.00	$ 62,872.00	$ 83,517.00	$ 85,280.00
$ 105,928.00	$ 56,689.00	$ 41,995.00	$ 67,940.00	$ 67,100.00	$ 66,328.00	$ 53,372.00	$ 58,277.00	$ 60,921.00	$ 58,535.00	$ 69,999.00	$ 63,988.00
$ 97,470.00	$ 44,588.00	$ 57,943.00	$ 78,555.00	$ 64,411.00	$ 70,240.00	$ 51,542.00	$ 74,155.00	$ 54,216.00	$ 61,155.00	$ 64,864.00	$ 121,690.00
$ 77,178.00	$ 54,211.00	$ 54,509.00	$ 74,792.00	$ 76,728.00	$ 55,676.00	$ 66,836.00	$ 77,653.00	$ 73,048.00	$ 44,145.00	$ 73,112.00	$ 90,190.00
Monthly Expenses by Region
$ 73,960.00	$ 48,794.67	$ 52,718.18	$ 58,710.91	$ 63,497.78	$ 64,420.00	$ 65,260.88	$ 75,536.00	$ 47,902.86	$ 53,393.33	$ 75,237.33	$ 78,527.27
$ 95,158.22	$ 51,390.22	$ 35,995.83	$ 62,146.00	$ 59,712.50	$ 57,852.57	$ 46,747.43	$ 54,420.58	$ 51,767.50	$ 53,031.11	$ 59,332.50	$ 59,655.67
$ 88,723.00	$ 39,218.29	$ 53,148.70	$ 70,826.67	$ 57,359.63	$ 59,533.33	$ 46,099.25	$ 65,885.63	$ 49,794.40	$ 51,962.50	$ 59,377.60	$ 105,305.71
$ 68,530.75	$ 47,466.57	$ 49,452.44	$ 65,107.43	$ 70,055.20	$ 47,396.67	$ 62,266.33	$ 72,181.92	$ 61,873.33	$ 39,626.88	$ 64,973.00	$ 78,305.71
$ 28,210.86	$ 23,680.00	$ 17,900.00	$ 44,446.86	$ 37,728.18	$ 38,793.14	$ 32,626.00	$ 24,065.71	$ 29,371.00	$ 31,500.00	$ 42,598.90	$ 40,759.43
Monthly Profit Margin
						8%								9%						10%											11%								12%							15%
	14%					13%
Monthly Marketing Expenses by Region
$ 24,879.36	$ 13,442.25	$ 13,653.60	$ 12,696.40	$ 16,171.30	$ 21,744.00	$ 19,094.66	$ 18,740.48	$ 13,680.00	$ 17,604.16	$ 16,703.40	$ 23,025.60
$ 29,659.84	$ 10,770.91	$ 13,018.45	$ 20,382.00	$ 14,762.00	$ 15,918.72	$ 13,876.72	$ 12,238.17	$ 14,011.83	$ 11,707.00	$ 18,899.73	$ 14,717.24
$ 28,266.30	$ 10,255.24	$ 16,803.47	$ 20,424.30	$ 19,323.30	$ 21,072.00	$ 11,339.24	$ 14,831.00	$ 12,469.68	$ 14,677.20	$ 18,161.92	$ 23,121.10
$ 18,522.72	$ 16,805.41	$ 13,082.16	$ 17,202.16	$ 21,483.84	$ 15,032.52	$ 17,377.36	$ 21,742.84	$ 16,801.04	$ 13,243.50	$ 16,815.76	$ 21,645.60
$ 9,841.26	$ 6,804.00	$ 3,853.20	$ 14,192.64	$ 11,716.29	$ 8,818.40	$ 10,481.76	$ 5,382.00	$ 8,754.48	$ 6,954.00	$ 13,404.09	$ 12,988.08
Number of New Customers added Monthly
Number of customers lost Monthly

Dashboard

2

>Dashboard

Data

umber of Pages viewed

:

Mobile

N

Android

Y

1

Y

Android Chrome Mobile Y United States 4

Y

Mobile

Y

8 Link

N 0.00

Safari N

8 Direct Request Monday Y

Chrome N

3 Google

N 0.00

Max OS X Safari N United States 7 Direct Request Friday Y

.25

Max OS X Safari N

6

Tuesday Y

Chrome N United States 4 Direct Request Thursday N 0.00

Android Chrome Mobile Y United States 5 Bing Tuesday Y

Android Chrome Mobile Y Indonesia 2 Direct Request Tuesday N 0.00

Android Chrome Mobile Y

6 Google Monday Y

iPhone

Y United States 8 Direct Request Wednesday N 0.00

Android Chrome Mobile Y United States 1 Link Friday N 0.00

Android Chrome Mobile Y United States 4 Link Wednesday N 0.00

Android Chrome Mobile Y United States 3 Google Wednesday Y

Android Chrome Mobile Y United States 5 Link

N 0.00

Max OS X Safari N

6 Link Tuesday N 0.00

Android Chrome Mobile Y United States 3 Direct Request Saturday N 0.00

iPhone Safari Mobile Y

1 Link Monday N 0.00

Android Chrome Mobile Y United States 7 Google Wednesday N 0.00

Windows 10 Chrome N United States 8 Google

N 0.00

Max OS X Safari N

7 Direct Request Friday N 0.00

iPhone Safari Mobile Y United States 4 Google Friday Y

iPhone Safari Mobile Y Indonesia 5 Link Sunday N 0.00

iPhone Safari Mobile Y United States 7 Direct Request Monday N 0.00

Windows 8 Chrome N

4 Bing Thursday N 0.00

Windows 8 Chrome N United States 6 Bing Thursday Y

0:01:40 Windows 8 Chrome N Congo, Democratic Republic of the 4 Google Friday Y

iPhone Safari Mobile Y Germany 2 Bing Monday N 0.00

0:00:06 iPhone Safari Mobile Y United States 2 Direct Request Thursday N 0.00

iPhone Safari Mobile Y

1 Google Tuesday Y

Android Chrome Mobile Y

1 Google Tuesday N 0.00

iPhone Safari Mobile Y United States 3 Google Friday Y

iPhone Safari Mobile Y United States 2 Link Tuesday N 0.00

Max OS X Safari N United States 8 Bing Wednesday N 0.00

Windows 8 Chrome N United States 8 Direct Request Monday N 0.00

iPhone Safari Mobile Y

7 Direct Request Monday N 0.00

iPhone Safari Mobile Y

3 Link Monday N 0.00

iPhone Safari Mobile Y

8 Google Saturday N 0.00

iPhone Safari Mobile Y Turkey 8 Google Friday N 0.00

0:03:16 iPhone Safari Mobile Y Bangladesh 3 Link Thursday Y

0:02:20 iPhone Safari Mobile Y United States 5 Google Tuesday N 0.00

Android Chrome Mobile Y

6 Link Friday N 0.00

0:02:24 iPhone Safari Mobile Y Iran 6 Google Friday Y

Windows 10 Chrome N Nigeria 7 Direct Request Thursday N 0.00

iPhone Safari Mobile Y Egypt 4 Direct Request Friday N 0.00

Android Chrome Mobile Y United States 2 Google Thursday N 0.00

iPhone Safari Mobile Y United States 3 Direct Request Thursday N 0.00

iPhone Safari Mobile Y Egypt 8 Direct Request Monday Y

iPhone Safari Mobile Y Congo, Democratic Republic of the 5 Direct Request Tuesday N 0.00

0:02:30 iPhone Safari Mobile Y Iran 1 Google Wednesday Y

0:00:06 Android Chrome Mobile Y Germany 7 Direct Request Thursday N 0.00

iPhone Safari Mobile Y

2 Link Wednesday Y

Windows 10 Chrome N Bangladesh 7 Direct Request Wednesday Y

0:01:28 Max OS X Safari N China 7 Direct Request Wednesday Y

iPhone Safari Mobile Y United States 8 Link Wednesday N 0.00

0:02:30 iPhone Safari Mobile Y United States 1 Link Thursday Y 6.50
0:02:24 Android Chrome Mobile Y United States 6 Direct Request Monday Y

Max OS X Safari N United States 1 Direct Request Monday N 0.00

Windows 10 Chrome N Japan 4 Google Friday N 0.00

Android Chrome Mobile Y Germany 1 Google Wednesday Y

Android Chrome Mobile Y United States 2 Bing Tuesday N 0.00

Android Chrome Mobile Y United States 1 Google Wednesday N 0.00

Android Chrome Mobile Y Japan 2 Google Wednesday N 0.00

Windows 8 Chrome N Thailand 7 Link Wednesday Y

0:03:56 iPhone Safari Mobile Y United States 7 Link Monday N 0.00

Windows 10 Chrome N United States 5 Bing Wednesday N 0.00

iPhone Safari Mobile Y United States 3 Direct Request Friday N 0.00

0:00:06 Max OS X Safari N United States 1 Bing Monday N 0.00
0:01:40 Android Chrome Mobile Y United States 7 Google Thursday Y

iPhone Safari Mobile Y Congo, Democratic Republic of the 7 Google Monday Y

Max OS X Safari N United States 7 Link Tuesday N 0.00

iPhone Safari Mobile Y Pakistan 3 Bing Tuesday Y

0:02:24 Windows 8 Chrome N United States 3 Link Tuesday N 0.00

Android Chrome Mobile Y Thailand 5 Bing Friday Y

0:01:04 Android Chrome Mobile Y United States 3 Direct Request Tuesday N 0.00
0:06:36 Android Chrome Mobile Y Congo, Democratic Republic of the 1 Google Tuesday N 0.00
0:01:28 Max OS X Safari N United States 2 Google Friday N 0.00

Android Chrome Mobile Y United States 5 Direct Request Sunday Y

Android Chrome Mobile Y

5 Link Tuesday N 0.00

Android Chrome Mobile Y Germany 7 Google Thursday N 0.00

0:00:32 Android Chrome Mobile Y Germany 6 Link Thursday N 0.00
0:02:30 Max OS X Safari N Thailand 3 Link Wednesday N 0.00
0:01:12 Android Chrome Mobile Y United States 1 Google Wednesday Y

Android Chrome Mobile Y Bangladesh 6 Bing Friday N 0.00

iPhone Safari Mobile Y United States 3 Bing Thursday Y

iPhone Safari Mobile Y Mexico 6 Google Wednesday N 0.00

iPhone Safari Mobile Y United States 2 Google Thursday N 0.00

iPhone Safari Mobile Y United States 5 Google Monday N 0.00

0:00:56 iPhone Safari Mobile Y United States 5 Bing Tuesday N 0.00

Android Chrome Mobile Y United States 6 Google Wednesday Y

Android Chrome Mobile Y Russia 4 Bing Tuesday N 0.00

Android Chrome Mobile Y Pakistan 1 Link Tuesday N 0.00

Windows 10 Chrome N United States 6 Direct Request Friday N 0.00

Windows 10 Chrome N United States 6 Link Friday N 0.00

Android Chrome Mobile Y United States 1 Google Tuesday N 0.00

Website visitor data for RXS Clothing, LLC

Duration

OS

Browser

Mobile

Country

N

Traffic Source

Day of the week

Sale made

Total sale amount

0:0

4

1

8

Android

Chrome

Y

Indonesia

7

Link

Monday

0.00

0:01:0

3

Chrome Mobile

United States

Direct Request

Thursday

20.78

0:04:02

Google

Friday

18.2

5

0:03:57

iPhone

Safari

Nigeria

Wednesday

0:01:15

Max OS X

China

12.25

0:01:30

Windows 10

Egypt

Tuesday

0:04:03

1

6

0:08:03

Bangladesh

Bing

44.50

0:02:03

Windows 8

0:02:27

6.50

0:00:06

0:03:02

Philippines

19.00

0:06:00

Safari Mobile

0:01:19

0:03:16

0:02:44

21.33

0:02:12

Saturday

0:04:12

Congo, Democratic Republic of the

0:01:40

0:01:51

Iran

0:00:13

0:01:18

Sunday

0:00:52

Germany

0:06:16

40.78

0:02:52

0:01:24

0:00:50

Mexico

0:02:28

15.00

4.67

0:02:24

0:02:14

Thailand

32.17

0:01:12

Turkey

0:02:30

15.33

0:00:48

0:03:56

0:02:20

0:01:28

Ethiopia

0:01:02

Russia

0:01:00

Brazil

0:06:36

6.56

0:00:01

Pakistan

11.44

0:01:01

0:01:38

0:00:20

0:03:45

0:00:42

48.00

0:02:26

43.50

0:02:33

Japan

6.58

0:00:28

10.33

5.25

0:05:36

16.50

0:02:08

0:04:44

0:01:04

18.00

0:03:00

0:04:42

0:00:38

0:02:00

23.50

0:00:39

0:00:24

39.00

0:00:32

3.67

0:06:04

0:00:57

11.33

0:04:27

39.25

0:01:48

35.00

0:04:36

India

0:00:56

14.00

0:02:36

0:04:45

48.56

0:01:10

0:00:14

0:01:54

0:04:32

22.33

0:00:49

0:00:18

0:04:09

0:01:06

0:01:32

Glossary

Duration

OS

Browser

Mobile

Country

Traffic Source

Day of the week

Sale made

Total sale amount

Website Traffic Glossary
The legnth of time the visitor visited the site
The operating system used by the visitor’s device
The browser used by the visitor’s device
Did the visitor visit the site using a mobile device such as a phone or tablet
The country from where the visitor visited the site
Number of Pages viewed	The total number of pages viewed by the visitor
How the visitor arrived at the site. Direct means the visitor entered the website address. Link means the visitor clicked on a link on a different site. Google or Bing means the visitor found the site through that specific search engine.
On which day of the week the visitor visited the site
Did the visitor make a purchase on the site
The total amount of the purchase made by the visitor