Get all website URLs together 1. 2. 3. 4.
Crawl the website in Screaming Frog Pull all pages viewed from Google Analytics over the last year Get indexed Urls with an advanced Google query like site:www.wella.com Clean data: standardise lowercase URLs if possible, http or https, remove URL tagging, remove faulty syntax and 404s, then de-duplicate 5. Keep everything in one tab with all markets on columns a) Remove the from each URL b) Since all URLs are in English, highlight duplicate entries for the whole table c) Order entries by colour, meaning duplicates are on top d) Manually put the remaining Urls in correspondence between markets (same URL across different markets, some rows will be empty) e) Fill in the empty spaces with the default location appropriate for that URL, like a category, subcategory or homepage 6. Put the URLs back together by adding the https://www.wella.com/professional/country-language/ prefix 7. Split URLs for each market in different tabs