ABCDEFGHIJKLMNOPQRSTUVWX
1
Source: Growth Machine Blog: How to Find 100+ Great Keywords in Less than 1 Hour
2
Root Term ↓ Theme →benefitshow to make#Guide
3
red teared tea benefitshow to make red tea1Add your root terms down column A
4
black teablack tea benefitshow to make black tea2Add your theme modifiers across row 1
5
green teagreen tea benefitshow to make green tea3Modify the =CONCATENATE formula to generate the keyword
6
oolong teaoolong tea benefitshow to make oolong tea4Make sure you lock the theme cell using $ symbols like the example:
7
 benefitshow to make Example (theme modifier first): =CONCATENATE($D$1," ",A2)
8
 benefitshow to make Example (root term first): =CONCATENATE(A2," ",$C$1)
9
 benefitshow to make 5Drag the formula down by the bottom right corner
10
 benefitshow to make 6Copy into ahrefs Keyword Explorer
11
 benefitshow to make 7Filter keywords by Traffic and Difficulty
12
 benefitshow to make 8Export keywords and add them to your list
13
 benefitshow to make
14
 benefitshow to make Do not delete the formulas in grey cells, they auto-generate your keywords
15
 benefitshow to make
16
 benefitshow to make
17
 benefitshow to make
18
 benefitshow to make
19
 benefitshow to make
20
 benefitshow to make
21
 benefitshow to make
22
 benefitshow to make
23
 benefitshow to make
24
 benefitshow to make
25
 benefitshow to make
26
 benefitshow to make
27
 benefitshow to make
28
 benefitshow to make
29
 benefitshow to make
30
 benefitshow to make
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100