Forum Discussion
separate single words from multiple words in tabs
1. yes here it is(it's an example of what I mean. To keep it organized for the people here;)
2 a. not daily .. but weekly. 😉
2 b. copy and paste
3.
The intended purpose is:
By taking these words apart. I can focus on the keywords that still need attention ..
for example:
Short tail keywords: fish ..
fish .. boat
fishing.. rod
fish .. shoes
fish.. bait
long tail key words: fishing with a boat that ..
fishing with a boat that ... goes fast
fishing with a boat that goes ... slow
fishing with a boat that is ... covered
fishing with a boat that is ... quiet
In the Exel document I normally also have the search volume. I have this from low to high. this way I can see where there is little competition. (on which keywords little is searched in google, the more specific the search terms / keyword combination .. the less competition there is)
this way I can process these long tail keywords in my blog posts.
Someone googled: fishing with a boat that goes fast ..
then there is a big chance that my blog article will be shown first in google. if I have processed these keywords in my blog post.
If there are 1000 people per month searching for this .. and my blog article is at the top of the Google search results .. then there is a big chance that a few hundred people will come to my blog. and so on my website;)
But why in this way?
Very simple .. by grouping these keywords under the number of words in 1 sentence .. you can select groups .. and enter them again in machines that after these keywords, paste new words, where people search again.
this way you end up with keywords / search terms that your competition is not yet using.
the disadvantage is that here very few people are probably looking for this. but these few people are very specific looking for something. so the sales chance is much greater than someone who searches google for: fish ..
it is difficult for you to sell a fishing boat to this person looking for fish ... maybe that person is looking for smoked fish;): P
I hope you understand me and that you can help me with this
With kind regards, Marco 😉
marco_osh So I took Sergei's formula and used it in the attached to make a helper column. Then using Data....Filter, I've copied the 1, 2, and 3 word collections. You can do the rest.
From what you've written, it sounds very much like this "manual" process--which doesn't take long--is sufficient for your weekly analysis. From here, again, from what you've written, you really need to just work through the lists to see what key-word combinations to aim for in your blog so as to attract customers. That is to say, it seems like more of a manual process once you've got the first sheet sorted into the various combinations. If that's not the case, come back with further explanations.
oh !!, that's exactly what I'm looking for! .. I just have to understand it all, thanks! 🙂
The Data.....Filter function is pretty simple. You see the little inverted triangle next to the word "Count" in column B? Click on that and you can select the description (number) that applies to the rows meeting that criterion. Then just copy them and paste them to the appropriate sheet.
- give me a few minutes hahaha 😉