ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
TaskAssigned ToDue
4
5
Get Sub-Site UsageLesley
5 sites by 2pm today
6
For each subsite:
all sites by EOD 6/4
7
In Google Analytics, go to Behavior > Site Content > All Pages (see note below)
8
Set time window to last 12 months
9
Filter for a sub-site & record % of Total in Column C "% Usage"
10
11
Do not include usage on any sites in development
12
Talk to Jacob Radford to ask for any usage info you can't find
13
Add any notes or questions in column H
14
15
Audit Each Sub-SiteRachael & Jakub
5 sites by 2pm today
16
For each sub-site:
all sites by EOD 6/4
17
Run in Experte Accessibility Tracker
18
Export Pages (will download to your computer)
19
Open a new Google sheet and place the cursor in top left cell
20
Choose File > Import > Upload
21
Drag the Accessibility CSV into the upload window
22
Import location = Replace Data at selected cell
23
Separator Type = Custom
24
Custom Seperator = ;
25
Convert text = selected
26
Click Import Data
27
Enter file name (subsite name) and file in Audits folder
28
Select all rows except for Row 1, choose Data > Sort Range by Column A
29
Delete any rows not in sub-site (with different top level URLs)
30
Replace C1 = average(C2:C[last row])
31
Enter that % in the Audit tab in column D
32
Replace A1 = countunique(A2:A[last row])
33
Enter that # in the Audit tab in column E
34
35
Add any notes or questions in column H
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100