Tips for international SEO strategy and reporting — Whiteboard Friday
Summary
Here, were saying when this column has a URL that contains this specific phrase, then I want it to target the UK. What we then do with this target country is we run another case statement to compare it to the actual country that the user landed from, and again thats data that comes straight from Search Console. But even if youre using just a country subfolder, the beauty of SQL is it gives us a lot of flexibility, and it allows us to target even just "en". Were using the column from Search Console that has the country that the user landed on. This then gives us a broad example of which countries were getting the most mistargeted traffic from, which can then help us drive our content strategies, and it also helps us measure the effectiveness of the strategies for international SEO.