Original subtitles

1 1

So now we finished the keyword research process. 2

2

It's a good idea to go through our spreadsheet 3

3

and remove any irrelevant or duplicate keywords. 4

4

As I'm not sure about you, 5

5

but when it comes to keyword research, 6

6

I get super, super excited. 7

7

I come across a great keyword and I'm like, 8

8

yep, let's check that on a spreadsheet. 9

9

I'll come across some more keywords. They will get added. 10

10

It goes on and on and on. And before I know it, 11

11

I've got tons and tons of keywords on my spreadsheet. 12

12

Which as you can imagine, 13

13

makes your life a little bit harder 14

14

when it comes to reviewing all the data. 15

15

As the more keywords you have, 16

16

the more data you have to review, right? 17

17

So it's always best practice 18

18

to just clean up your spreadsheet 19

19

and make sure that all the keywords you have on it, 20

20

are indeed relevant to your website. 21

21

So for example without even scrolling, 22

22

I can see an irrelevant keyword right here on row 27, 23

23

travel yoga mat Amazon. 24

24

Now the search intent behind this keyword 25

25

obviously relates to Amazon. 26

26

If someone types in travel yoga mat Amazon, 27

27

then they are looking for a travel yoga mat, 28

28

which is sold on Amazon. 29

29

As we are not Amazon, 30

30

then this is not really a good keyword 31

31

to have on our spreadsheet 32

32

as it's not relevant to our website. 33

33

So let's go ahead and see if we have any other keywords, 34

34

which reference the word Amazon. 35

35

So to do that, it's very easy. 36

36

Just go over to our filters. 37

37

Again, change that to contains 38

38

and simply enter the word Amazon. 39

39

And as you can see, 40

40

we have a few more occurrences of keywords 41

41

that mentioned the word Amazon. 42

42

So all I'm going to do is simply 43

43

delete these from our spreadsheet. 44

44

As like I said, these are not relevant. 45

45

So let's go back and clear that filter 46

46

and that should have removed all the keywords 47

47

which mentioned Amazon. 48

48

And you can see it's done that 49

49

because we have clear gaps in our rows. 50

50

So just blank rows where the keyword was initially. 51

51

So that's really good. 52

52

So again, it's a kind of the same process. 53

53

You just go for your keywords, 54

54

see which ones are relevant and which ones are not relevant 55

55

and simply get those removed from our spreadsheet. 56

56

Now, when it comes to removing duplicates, 57

57

the thing I like to do is go to the top of the spreadsheet, 58

58

make sure you go to data and then filter by A to Z. 59

59

And what this is going to do is show you 60

60

all the keywords in alphabetical order. 61

61

And anytime you see a duplicate keyword, 62

62

you simply just remove it from your spreadsheet. 63

63

For example, I can see a duplicate on row 26 and on row 27. 64

64

Anti-slip yoga mat towel. 65

65

Let's go ahead and delete one of those. 66

66

As that is a duplicate. 67

67

Let's scroll down and see if we can find any more. 68

68

These two look pretty similar, but a little bit different. 69

69

We've got two cheap yoga mats. 70

70

So again, let's delete one of these 71

71

and hopefully get the idea here. 72

72

You just go through all of your keywords 73

73

and remove all of the duplicates. 74

74

Now this applies to your theme tabs as well. 75

75

So where we have towels, 76

76

you can see we've got tons of keywords. 77

77

It would be exactly the same thing, 78

78

filter it by A to Z, 79

79

remove any duplicates that you have. 80

80

So we've got best yoga mat towel here, 81

81

and we've got it here again. 82

82

So of course we need to remove one of them. 83

83

So it's no longer a duplicate. 84

84

And go through the same thing for all of your tabs. 85

85

And of course, check the tabs as well 86

86

to see if you have any relevant keywords 87

87

such as Amazon, maybe a keyword like this Australia. 88

88

Maybe you're not targeting Australia, 89

89

maybe your based in the United States 90

90

and you only service United States. 91

91

So if that is the case, 92

92

then this is obviously going to be an irrelevant keyword. 93

93

So it is really important to do. 94

94

Please do make sure you take quite a bit of time 95

95

going through your keywords, 96

96

as it's going to make a life so much more easier 97

97

when it comes to doing the on-page SEO, 98

98

which we're going to cover later on in the course.