Get my Free Digital Marketing Jumpstart Kit<\/a><\/div>\n<\/div>\n\n\n\nHow to filter longtail keywords<\/h2>\n\n\n\n
So what we’re gonna do is we’re gonna go ahead and import this all into a spreadsheet. To do this, all you need to do is go to file and then import, and then from there, click upload. From here, I drag my file and then I’m gonna be given the option to either create a new spreadsheet or replace the current spreadsheet. In this case, I’m going to go ahead and replace the current sheet.<\/p>\n\n\n\n
From here. You’re gonna get the import of all of the data from SEMRush and all you need to do from here. It start to comb through these keywords and then flag out potential ideas. So right now let’s go ahead and take a look at what some of these keywords are.<\/p>\n\n\n\n
And then the first thing that I’m gonna do is I’m going to go ahead and set up a data filter in order for me to parse through some of these a little bit more intently. One of the first things I’m gonna do is I’m gonna filter out for keywords that have at least a hundred or more in keyword volume. So I’m gonna go here, go to filter by condition, and then I’m gonna do greater than 99. From here, this leaves me with 71 keywords. So I have still potentially a ton of great ideas in this mix. All I need to do here is I need to go ahead and either create a new column to the right or to the left of the respective long tail keyword. And then what I can do is I can just go ahead and mark for myself, whether or not this is a good keyword.<\/p>\n\n\n\n
So I’m gonna put in pursue into this respective. But now all I need to do is just comb through these respective phrases. To do this, what I like to do is I actually like to sort it by alpha order, just because it’s easier to read through it. But in your respective example, you might want to keep things a little bit simpler and just keep it in the raw export.<\/p>\n\n\n\n
In this particular case, we can see are private soccer lessons worth it? That is definitely what I’d wanna pursue. I’m gonna mark an X there. Are there timeouts in soccer? I’m gonna mark that. Let’s go ahead and see, can you use soccer cleats for lacrosse? I like that question. Do DC, urban moms soccer, not so much as in this particular case, as I don’t really know what that is. Do Canadians call it soccer? I love that particular idea. Here you can see how much can soccer players squat? Love that as well. How to get a soccer bond fortnite creative. Maybe. How to get into soccer? Sure. Is baseball harder than soccer? Of course, that sounds nice. And what I’m looking for as I go through these particular ideas is I’m looking for some long tail questions that people have.<\/p>\n\n\n\n
Look for questions people ask for<\/h2>\n\n\n\n
The reason why is because these are gonna be the people also ask phrases that people like to search for. So I’m just gonna go ahead and continue going through this. And what you can see is that there are a number of things that we can go through just to see whether or not this is something interesting to us. So I’m looking for things like what does 3\/4 mean in soccer betting? What does AFC stand for? What does real mean in soccer? What lights up a soccer stadium? So these are all, some potential questions. Why do soccer players grab each other’s crotch? Oh man. And then why do they water turf soccer fields. Okay. And so right here, what you can see is that just from this preliminary scroll through, I’ve identified 17 ideas.<\/p>\n\n\n\n
The reason why I say 17 is because it includes the top column when I select that. And so what I can then do is I can go ahead and either do an export from Quora where I repeat these methods, or what I can do is I can go ahead and look for greater than 50, but less than a hundred, so greater than or equal to 50 and, or I’ll do is between 50 and a hundred. So I’ll do 49 and a hundred. All right.<\/p>\n\n\n\n
So in this case, I am looking for a couple more. So do football players wear soccer cleats? I like that. That’s number 18. What is handicapped draw on soccer. I like that. That’s number 19 average two minute mile for soccer players. That’s an interesting question or statistic that people might look for. So that’s number 20 I believe. I’m looking for five more, four more, three more. What do soccer players say? I like that one. Two more. Do they sell jerseys at soccer games? I like that one as well. One more. How to lock your ankle in soccer? And there you go.<\/p>\n\n\n\n
So just like that, what I can do is I can go ahead and remove my filter, or I can go ahead and look at a filter view and then go ahead and just sort by the ones that are X’s. And so there you have it just like that, what I’ve done is I’ve gone ahead and identified 25 ideas for my particular imaginary soccer niche site.<\/p>\n\n\n\n
And what you can see is that the search volume and total here is over 4,000 search. And so there’s definitely a lot of potential here based off of just these keywords that I did at quick filter on. You can take this sort of approach with all, all sorts of different websites. But the other one that comes to mind is quora.com. Or even major forums for different niches.<\/p>\n\n\n\n
If you liked this article, be sure to check out my YouTube channel<\/a> to get new videos every single week. I\u2019ll help take you from zero to self-starter as you grow your business, get more customers, and hone your business acumen. Also, feel free to share this with anybody that you think might benefit from learning about being patient when it comes to SEO.<\/p>\n\n\n\n