Do the same for "Meta Description", but this time pick the first 4 columns, then 8-10.Repeat this for each section to end up with the different sheets as follows: This number of sheets may look like overkill, but in my experience working with smaller amounts of data is much easier than trying to work on one large, data heavy spreadsheet. Well, we’ll need to go and open Current Site Crawl for Editing.Now you have the data in Excel format, and you can see what works on the test site, and what doesn't.This allows you to understand what's missing from the test site that is on the current site.
Your SEO crawl will give you a roadmap of how your entire site is currently set out.Now that you have the test site’s Page Titles next to the current site’s Page Titles, you can highlight the duplicates. You’ll need to manually move things around and get them in the right place.Highlight both Title 1 columns and go to Conditional Formatting Duplicate Values. I go about this by looking at the Page Title 1 closest to the left, (the one from the test site) then copy the text.Then when you launch the new site, the new content will have no value because it will be duplicate.A site can be noindexed in two ways by your developers. If you have Word Press, for example, you simply check the box that reads: of every page: 2 – Your second option is to block the site in the file.This is a little trickier; hence, why most CMS have a box-ticking option.If your CMS doesn't allow for this, you can put the following in your file: User-agent: * Disallow: / No CMS?Also, hold onto the very first crawl we did of the test site (Test Site Crawl).At the end, you’ll have these docs: Okay, you made it.This can help you spot any problems areas, in addition to enabling you to see which areas must be retained. Sometimes it’s worth checking more, but these are top-level checks: Using your Screaming Frog data, I advise checking the following: This stage is simple; yet it’s the point where many redesigns go awry.If you’re working on your test site, the last thing you want is for Google et al. If you’ve added great new content, it will get indexed.