Content-Audit-Template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	B2BContentOS — Content Audit Tracker
2	URL	Page Title	Content Type	Topic / Keyword	Funnel Stage	Monthly Sessions	Avg. Position	Clicks (GSC)	Backlinks	Word Count	Last Updated	Score	Impact (1–5)	Effort (1–5)	Priority	Owner	Deadline	Notes

3	https://yoursite.com/b2b-content-strategy/	B2B Content Marketing Strategy Guide	Pillar Page	b2b content marketing strategy	TOFU	1840	6.2	312	18	4200	2024-08-10	Update	5	2	2.5	Sarah	2026-03-28	Dropped from pos 4 to 6 in last 60 days. Refresh stats + add 2026 trends section.
4	https://yoursite.com/content-audit-template/	Free Content Audit Template	Resource/Tool	content audit template	MOFU	420	9.1	68	5	1800	2024-06-15	Update	4	2	2	Sarah	2026-04-04	Add new scoring section. Internal link from pillar page.
5	https://yoursite.com/2021-social-media-tips/	10 Social Media Tips for 2021	Blog Post	social media tips	TOFU	12	48.3	3	0	900	2021-03-01	Kill	1	1	1	Tom	2026-03-21	Zero relevant traffic. 301 redirect to social media pillar page.
6	https://yoursite.com/content-marketing-vs-content-strategy/	Content Marketing vs Content Strategy	Blog Post	content marketing vs content strategy	TOFU	95	22.4	14	2	1100	2023-11-20	Merge	3	2	1.5	Tom	2026-04-11	Cannibalising main pillar. Merge into strategy guide, 301 redirect.
7	https://yoursite.com/b2b-saas-case-study-acme/	How Acme Grew Pipeline 3x with Content	Case Study	b2b saas case study	BOFU	210	14.7	31	3	1500	2024-01-05	Keep	4	1	4	Sarah	2026-06-30	Strong BOFU signal. Review quarterly. Add to homepage featured block.
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