Daniel Foley Carter’s Post

SEO Tip! Every site I analyse suffers from weak content - particularly weak content that shouldn't be indexed. Here is my advice: 👉 1. Go to Google Search Console 👉 2. Choose your domain 👉 3. Go to performance and set date to 16 months 👉 4. Export to Google Sheets 👉 5. Delete all rows with 100 or more clicks 👉 6. Sort by impressions 👉 7. Apply conditional formatting to CTR column (<1% RED, 1%-2% ORANGE, 2%+ GREEN) - You can change the CTR benchmarks based on averages for your niche 👉 8. Add an age status column, associated queries column, broken average position line and GSC link column 👉 9. In GSC, filter by each URL from your sheet - what you want to do is for each URL with low clicks - is to look at the age (6,12,18 months) and put them into the age status column - roughly chart the age of when the first average position is spotted 👉 10. In the GSC queries tab, look at the bottom of the table and note how many rows there are - put this into an ASSOCIATED QUERIES Column 👉 11. Look at the average position line over time - if it breaks, mark the column with a yes 👉 12. Copy the URL from search console to the GSC link column What you want to look for: ⚠️ URLS that are 12-16+ months old where the CTR is less than 1%, impressions are low + where the volume of associated queries is less than 100 ⚠️ Anything with a broken average position line, < 10 clicks and poor CTR with 6-12+ months of history + low associated query volume - these pages are usually struggling to gain traction and should be culled/reviewed to see if there is query prospect ⚠️ Anything with 16+ months of history and less than 100 clicks + poor CTR / low associated queries What you should do with URLS that are struggling to gain any traction: 🔍 Look at the URL's query profile - is the lead query by click/impression relevant to the pages content? how well aligned are the lead queries by click/impression? if queries aren't directly relevant or are generic/obscure then it's unlikely the content will ever gain traction 🔍 Does the page score well for its lead query in INLINKS? have you audited the content to evaluate NLP/Topical performance scores? 🔍 Does the page have enough internal links or is it close to being orphaned i.e. only one/two internal links or does it just survive via the sitemap? a page with very few internal links is more likely to struggle to gain momentum 🔍 Is there another page sharing similar queries - thus creating a child cannibalising result - these will struggle to gain query momentum IF CONTENT IS WEAK! AGED! and shows a broken average position line - FIX IT or BIN IT. If the content HAS to be on the website - META ROBOTS NOINDEX, FOLLOW it - if you cannot tackle the problem quickly then apply the tag and revisit it in the future. Weak content on a domain is BAD, it will drag down overall domain level performance.