Content Audit Template by @lucyalicedodds - BrightonSEO Autumn 22

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1				Content Audit Template by @lucyalicedodds
2				How to Use 1. Download this as an Excel file. 2. Add data from different sources into the Raw Data tab, e.g., Analytics, Search Console, etc. 3. Use a VLOOKUP formula to pull your data through into the Audit Master tab (it's already set up here). 4. Apply Conditional Formatting > Colour Scales to visualise your content's performance (if this doesn't remain applied). 5. Start your content audit, choosing to Keep/Improve/Remove/Merge your URLs.
3
4	URL	Keep/Improve/Remove/Merge	Status Code	Clicks	Impressions	CTR	Backlinks	Primary Keyword	Search Volume	Device	Rank	Sessions	New Users	Bounce Rate	Avg. Session Duration	Transactions	Leads	Revenue	Conversion Rate
5	/URL-1	Keep	200	5000	10000	2.00%	10	Content	1000	Smartphone	1	40000	7000	20.00%	00:02:35	500	2000	£300000	2.45%
6	/URL-2	Improve	200	6000	13000	2.16%	15	Audit	2000	Smartphone	2	50000	8000	30.00%	00:03:25	1000	2500	£400000	2.75%
7	/URL-3	Merge	200	7000	16000	2.28%	20	Template	3000	Smartphone	3	60000	9000	40.00%	00:05:45	1500	3000	£500000	3.00%
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
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