If you have a website that have multiple international territories hosted in subfolder. Use the formula below to exclude the subfolders. This will give you cleaner data to isolate and sort. An example usage URL remapping for migrations.
Code:
=not(regexmatch(A:A, "(?i)/au/|/ca/|/ie/|/de/|/ie/|/es/|/it/|/fr/|/nz/"))
Last edited: