ABCDEFGHIJKLMNOPQRST
1
Instructions
2
3
1. Download this file as a .xslx file (File > Download as > Microsoft Excel), open it and enable editing
4
5
2. In Screaming Frog, filter the 'Internal' tab by HTML, click 'Export' and and open the CSV
6
7
3. Paste the entire sheet of the CSV into the 'Internal Links' sheet of the downloaded .xlsx file
8
9
4. Paste your list of pages that aren't ranking or indexed in the the 'Pages in Question' sheet of the .xlsx file
10
11
5. On the 'Pages in Question' sheet, fill down the formula in Column B so that it is populated for every corresponding cell in column A
12
13
6. Click on cell A2 in the 'Pivot Table' tab. Press Alt+F5 to refresh, then drag and drop the fields as shown to the right >>
14
15
7. Now in the pivot table, you should see your pages in question organized by the possible reasons why they aren't indexed
16
17
Note: This is a work in progress...
18
19
Current settings for the .xlsx file allow you to look for a maximum of 500 URLs within a crawl of 30,000 pages maximum.
20
If you wish to change the formulas for a larger site, do so at your own risk.
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Note: This is a work in progress...
41
42
Current settings for the .xlsx file allow you to look for a maximum of 500 URLs within a crawl of 30,000 pages maximum.
43
If you wish to change the formulas for a larger site, do so at your own risk.
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