Skip to main content

How do you guys cull through or clean keyword research lists?

Hi and sorry if this is such a newbie question but there's nothing specific on Youbtube about this. I'm quite new to SEO and am using Ahrefs.

When you type in your seed keywords and the search results come up with so so many keywords that you know have nothing to do with the product, how exactly do you clean them up? For example, I am searching keywords for "mockups" as in within the context of product and packaging development. But the keyword results Im getting from Ahrefs are mostly people looking for like layout mockups that they can use as their phone or desktop background, or like how they themselves can create 3d mockups for free on photoshop. I can use intent modifiers, but even so, the results are just for a completely different context. I want to research keywords used by purchasing departments of companies, looking for mockup or comps suppliers, not individuals looking to DIY.

Right now what I do is I go through the list, type words that will exclude these other concepts that have nothing to do with my industry, words like "free, phone, mac, iphone, etc.". I copy paste this into Ahrefs' exclude tab and see what's left. If there are other irrelevant types I add them further to the exclude list. Sometimes I do the reverse and use the "include" tab, but I'm afraid this will limit the results to my biased view of what the keywords should be. So I use the exclude tab more often. I exclude and exclude until sometimes there's barely any left.

Am I doing this wrong? Is there a more efficient way to do this? Any video you can refer that talks about sorting/cleaning lists in general and not just generating them?

Thanks in advance.

submitted by /u/likhaanoushka
[link] [comments]

from Search Engine Optimization: The Latest SEO News https://ift.tt/kazoCSJh5
Labels:

Comments

Post a Comment

Popular posts from this blog

Legit Reviews

The google review thing is insane I have gotten 2 legit verified reviews that i ask client to screenshot and observe goolge not post them, pretend like they never happened and when i sent them the image a policy message was sent . As I was browsing through the google forum a lot of ppl are getting hit with legit reviews being removed. While all this is going on i have observe a company go from 12 reviews to 65 reviews in a two month period with some stuff that dont make sense on some of them. Seems like a new business or profile is being limited while aged accounts can have a free for fall but who really knows. Still waiting for a resolution on a if any. submitted by /u/Ok-Bowl-6167 [link] [comments] from Search Engine Optimization: The Latest SEO News https://ift.tt/zkbfgDH
Post a Comment
Read more

Local seo vs. natiowide seo?

I've done SEO for local businesses but I recently got my first client that sells an item nation wide. ​ Any suggestions for doing nationwide SEO? ​ I am used to making geopages for local towns. I was going to do the same with some input from the client about what cities or towns he would like to show up in? submitted by /u/Letmeinterviewyou [link] [comments] from Search Engine Optimization: The Latest SEO News http://bit.ly/2JHy0k0
Post a Comment
Read more

7 SEO Lessons I've Learned in 2025 (So Far) - From Building a Competitor Analysis Tool

Hey r/SEO , I've been spending a lot of time lately building a competitor keyword research tool (more on that below!), and it's really forced me to dig deep into how SEO works today . Here are some of the key lessons I've learned – hopefully, they're helpful to you too: Keyword Gaps Are Gold: It's not enough to just know what keywords your competitors rank for. You need to know what they rank for that you don't . This is where the real opportunities lie. Focusing on these "gap" keywords has been a game-changer for my own site. (This is actually why I built the tool – to make finding these gaps easier). Relevance > Volume (Sometimes): High search volume is great, but relevance is even more important. A keyword with 100 searches per month that's perfectly aligned with your niche and audience is often more valuable than a keyword with 10,000 searches that's only tangentially related. I've seen much better results targeting tho...
Post a Comment
Read more