Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated: 1 1 00:00:00,500 --> 00:00:03,150 So now we finished the keyword research process. 2 2 00:00:03,150 --> 00:00:05,210 It's a good idea to go through our spreadsheet 3 3 00:00:05,210 --> 00:00:08,150 and remove any irrelevant or duplicate keywords. 4 4 00:00:08,150 --> 00:00:09,700 As I'm not sure about you, 5 5 00:00:09,700 --> 00:00:11,460 but when it comes to keyword research, 6 6 00:00:11,460 --> 00:00:13,950 I get super, super excited. 7 7 00:00:13,950 --> 00:00:15,830 I come across a great keyword and I'm like, 8 8 00:00:15,830 --> 00:00:17,830 yep, let's check that on a spreadsheet. 9 9 00:00:17,830 --> 00:00:20,600 I'll come across some more keywords. They will get added. 10 10 00:00:20,600 --> 00:00:23,160 It goes on and on and on. And before I know it, 11 11 00:00:23,160 --> 00:00:25,830 I've got tons and tons of keywords on my spreadsheet. 12 12 00:00:25,830 --> 00:00:27,200 Which as you can imagine, 13 13 00:00:27,200 --> 00:00:28,590 makes your life a little bit harder 14 14 00:00:28,590 --> 00:00:30,480 when it comes to reviewing all the data. 15 15 00:00:30,480 --> 00:00:31,690 As the more keywords you have, 16 16 00:00:31,690 --> 00:00:33,830 the more data you have to review, right? 17 17 00:00:33,830 --> 00:00:35,220 So it's always best practice 18 18 00:00:35,220 --> 00:00:36,720 to just clean up your spreadsheet 19 19 00:00:36,720 --> 00:00:38,810 and make sure that all the keywords you have on it, 20 20 00:00:38,810 --> 00:00:41,190 are indeed relevant to your website. 21 21 00:00:41,190 --> 00:00:43,130 So for example without even scrolling, 22 22 00:00:43,130 --> 00:00:46,750 I can see an irrelevant keyword right here on row 27, 23 23 00:00:46,750 --> 00:00:48,920 travel yoga mat Amazon. 24 24 00:00:48,920 --> 00:00:51,130 Now the search intent behind this keyword 25 25 00:00:51,130 --> 00:00:52,810 obviously relates to Amazon. 26 26 00:00:52,810 --> 00:00:55,410 If someone types in travel yoga mat Amazon, 27 27 00:00:55,410 --> 00:00:57,430 then they are looking for a travel yoga mat, 28 28 00:00:57,430 --> 00:00:59,180 which is sold on Amazon. 29 29 00:00:59,180 --> 00:01:00,380 As we are not Amazon, 30 30 00:01:00,380 --> 00:01:01,760 then this is not really a good keyword 31 31 00:01:01,760 --> 00:01:03,010 to have on our spreadsheet 32 32 00:01:03,010 --> 00:01:05,270 as it's not relevant to our website. 33 33 00:01:05,270 --> 00:01:07,980 So let's go ahead and see if we have any other keywords, 34 34 00:01:07,980 --> 00:01:10,120 which reference the word Amazon. 35 35 00:01:10,120 --> 00:01:11,500 So to do that, it's very easy. 36 36 00:01:11,500 --> 00:01:13,740 Just go over to our filters. 37 37 00:01:13,740 --> 00:01:16,340 Again, change that to contains 38 38 00:01:16,340 --> 00:01:18,690 and simply enter the word Amazon. 39 39 00:01:18,690 --> 00:01:19,600 And as you can see, 40 40 00:01:19,600 --> 00:01:22,030 we have a few more occurrences of keywords 41 41 00:01:22,030 --> 00:01:23,880 that mentioned the word Amazon. 42 42 00:01:23,880 --> 00:01:25,190 So all I'm going to do is simply 43 43 00:01:25,190 --> 00:01:27,020 delete these from our spreadsheet. 44 44 00:01:27,020 --> 00:01:29,550 As like I said, these are not relevant. 45 45 00:01:29,550 --> 00:01:31,560 So let's go back and clear that filter 46 46 00:01:31,560 --> 00:01:33,120 and that should have removed all the keywords 47 47 00:01:33,120 --> 00:01:34,560 which mentioned Amazon. 48 48 00:01:34,560 --> 00:01:35,393 And you can see it's done that 49 49 00:01:35,393 --> 00:01:37,300 because we have clear gaps in our rows. 50 50 00:01:37,300 --> 00:01:40,320 So just blank rows where the keyword was initially. 51 51 00:01:40,320 --> 00:01:41,460 So that's really good. 52 52 00:01:41,460 --> 00:01:43,100 So again, it's a kind of the same process. 53 53 00:01:43,100 --> 00:01:44,840 You just go for your keywords, 54 54 00:01:44,840 --> 00:01:47,690 see which ones are relevant and which ones are not relevant 55 55 00:01:47,690 --> 00:01:50,100 and simply get those removed from our spreadsheet. 56 56 00:01:50,100 --> 00:01:52,200 Now, when it comes to removing duplicates, 57 57 00:01:52,200 --> 00:01:55,440 the thing I like to do is go to the top of the spreadsheet, 58 58 00:01:55,440 --> 00:01:58,570 make sure you go to data and then filter by A to Z. 59 59 00:01:58,570 --> 00:01:59,900 And what this is going to do is show you 60 60 00:01:59,900 --> 00:02:02,110 all the keywords in alphabetical order. 61 61 00:02:02,110 --> 00:02:04,080 And anytime you see a duplicate keyword, 62 62 00:02:04,080 --> 00:02:06,430 you simply just remove it from your spreadsheet. 63 63 00:02:06,430 --> 00:02:11,020 For example, I can see a duplicate on row 26 and on row 27. 64 64 00:02:11,020 --> 00:02:13,010 Anti-slip yoga mat towel. 65 65 00:02:13,010 --> 00:02:15,350 Let's go ahead and delete one of those. 66 66 00:02:15,350 --> 00:02:17,290 As that is a duplicate. 67 67 00:02:17,290 --> 00:02:19,790 Let's scroll down and see if we can find any more. 68 68 00:02:21,300 --> 00:02:24,800 These two look pretty similar, but a little bit different. 69 69 00:02:24,800 --> 00:02:26,870 We've got two cheap yoga mats. 70 70 00:02:26,870 --> 00:02:28,420 So again, let's delete one of these 71 71 00:02:28,420 --> 00:02:30,020 and hopefully get the idea here. 72 72 00:02:30,020 --> 00:02:31,640 You just go through all of your keywords 73 73 00:02:31,640 --> 00:02:33,690 and remove all of the duplicates. 74 74 00:02:33,690 --> 00:02:36,270 Now this applies to your theme tabs as well. 75 75 00:02:36,270 --> 00:02:38,140 So where we have towels, 76 76 00:02:38,140 --> 00:02:40,000 you can see we've got tons of keywords. 77 77 00:02:40,000 --> 00:02:41,910 It would be exactly the same thing, 78 78 00:02:41,910 --> 00:02:43,403 filter it by A to Z, 79 79 00:02:44,420 --> 00:02:46,080 remove any duplicates that you have. 80 80 00:02:46,080 --> 00:02:47,870 So we've got best yoga mat towel here, 81 81 00:02:47,870 --> 00:02:48,970 and we've got it here again. 82 82 00:02:48,970 --> 00:02:50,810 So of course we need to remove one of them. 83 83 00:02:50,810 --> 00:02:52,980 So it's no longer a duplicate. 84 84 00:02:52,980 --> 00:02:55,520 And go through the same thing for all of your tabs. 85 85 00:02:55,520 --> 00:02:57,000 And of course, check the tabs as well 86 86 00:02:57,000 --> 00:02:59,100 to see if you have any relevant keywords 87 87 00:02:59,100 --> 00:03:02,630 such as Amazon, maybe a keyword like this Australia. 88 88 00:03:02,630 --> 00:03:04,310 Maybe you're not targeting Australia, 89 89 00:03:04,310 --> 00:03:05,970 maybe your based in the United States 90 90 00:03:05,970 --> 00:03:07,800 and you only service United States. 91 91 00:03:07,800 --> 00:03:08,850 So if that is the case, 92 92 00:03:08,850 --> 00:03:11,550 then this is obviously going to be an irrelevant keyword. 93 93 00:03:11,550 --> 00:03:13,670 So it is really important to do. 94 94 00:03:13,670 --> 00:03:15,670 Please do make sure you take quite a bit of time 95 95 00:03:15,670 --> 00:03:17,070 going through your keywords, 96 96 00:03:17,070 --> 00:03:19,400 as it's going to make a life so much more easier 97 97 00:03:19,400 --> 00:03:21,610 when it comes to doing the on-page SEO, 98 98 00:03:21,610 --> 00:03:24,110 which we're going to cover later on in the course. 8329