1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[TUT] Finding niches & keywords the pro way - Mass Keyword find method

Discussion in 'White Hat SEO' started by NLhead38, Nov 29, 2013.

  1. NLhead38

    NLhead38 Jr. VIP Jr. VIP Premium Member

    Joined:
    Jan 10, 2010
    Messages:
    547
    Likes Received:
    383
    Location:
    Western Europe
    I've been an active reader of BHW forums for some years, but almost never contributed really usefull information, mostly because most info is already present at BHW.

    While reading Jerry's SEOtraffichacks blog, I found a little keyword research gem, which I modified to make it even better. This method gives you:
    - A fast way to find niches in Google
    - Most detailed stats about competition and CPC (competition on a 1/100 scale)
    - Filter between exact, match and broad keywords (yes, with this method it's still possible)
    - It will cost you 3 minutes max.




    Let's go ahead and see how it works:

    1. Go to Ubersuggest.org and insert your keyword
    2. Run the tool and it will give you around 350 results. You can run this tool multiple times for all the keywords you'd like to scrape. This tool scrapes Google suggest, use keywords like 'cheap', 'best', 'buy' or be creative and find keywords suited to your niche.
    3. Click select all keywords and click 'Get' at the right.
    4. Save all keywords in a .txt file and go to Google Keyword planner
    5. Now, click the 3rd option: Get estimations for a list of keywords.
    6. Upload your .txt file and click the blue button.
    7. This is important: Segment to keyword and, if you'd like to see exact searches, click edit search types >> all ad groups >> exact keywords (this tool is german in my browser, so it could be named a little differently to what I'm calling it here).
    8. This will give you a list of all keywords. Google doesn't provide any data so it seems, but don't be dissapointed: Select all keywords and press the Download button at the right.
    9. Click the final option: Download to Excel (CSV). You now have the gold sitting on your computer.

    Open the file and you will see all data: Keyword Avg., Monthly Searches, Competition and Suggested bid.

    A nice little trick to calculate the most interesting keywords is to perform this formula =E2*(F2-1) (copy to all rows). This will formula will give you the number (in -) of the keyword with most searches * the competition.

    Here's an example of what I mean:
    [​IMG]

    Anyway, share this trick with fllow BHW members and click like if you like my small tutorial, I will do more if I am of help to anyone :).
     

    Attached Files:

    • Thanks Thanks x 52
  2. phpbuilt

    phpbuilt Jr. VIP Jr. VIP

    Joined:
    May 16, 2011
    Messages:
    1,650
    Likes Received:
    5,208
    Occupation:
    $ from websites I own.
    Location:
    putting monkeys in paypal
    Nice. Very unfortunate suggest doesn't provide adult keywords. Showed good results on everything except what I wanted lol.
     
    • Thanks Thanks x 4
  3. NLhead38

    NLhead38 Jr. VIP Jr. VIP Premium Member

    Joined:
    Jan 10, 2010
    Messages:
    547
    Likes Received:
    383
    Location:
    Western Europe
    Yeah, unfortunately there isn't a workaround for this.
     
  4. abhi007

    abhi007 Jr. VIP Jr. VIP

    Joined:
    Aug 31, 2010
    Messages:
    5,306
    Likes Received:
    3,741
    Location:
    snip.li/TubH
    This gotta be one of my favourite when it comes to finding golden keywords :)
     
  5. PrinceVisi

    PrinceVisi Elite Member

    Joined:
    Jan 11, 2012
    Messages:
    1,916
    Likes Received:
    1,009
    Occupation:
    BusinessMan
    Location:
    Tropoja

    Been using this for a long time, but its wonderful.

    It bores you a lot sometimes, but its better then any program.

    Good Job OP.
     
  6. techblog

    techblog Jr. VIP Jr. VIP

    Joined:
    Feb 12, 2013
    Messages:
    1,222
    Likes Received:
    383
    Occupation:
    Freelancer
    Location:
    Email Server
    informative. bookmarked!
     
  7. abhi007

    abhi007 Jr. VIP Jr. VIP

    Joined:
    Aug 31, 2010
    Messages:
    5,306
    Likes Received:
    3,741
    Location:
    snip.li/TubH
    OP can you link us to Jerry's traffic hacks blog cant seem to find it on google or did you mean Terry?
     
  8. NLhead38

    NLhead38 Jr. VIP Jr. VIP Premium Member

    Joined:
    Jan 10, 2010
    Messages:
    547
    Likes Received:
    383
    Location:
    Western Europe
    Yes, sorry about that, I mean Terry. Just google site:seotraffichacks.com and you'll find his blog.
     
  9. henhen10

    henhen10 Regular Member

    Joined:
    Nov 18, 2010
    Messages:
    411
    Likes Received:
    83
    Occupation:
    a student
    Location:
    israel
    Awesome man! thanks for sharing!

    I have one question though - can you explain how to add the formula to the excel file?

    Thanks in advance :D
     
  10. Breakk82

    Breakk82 Registered Member

    Joined:
    Nov 16, 2013
    Messages:
    52
    Likes Received:
    10
    I do this with keywordshitter, also then I throw it in the trial of longtailpro or market samurai and check the difficulty of the keyword to make sure if I have the tools to rank it.
     
  11. ultrahumor

    ultrahumor Newbie

    Joined:
    Sep 11, 2013
    Messages:
    29
    Likes Received:
    7
    Home Page:
    I am stuck on your fomula. What's your point for that fomula?
     
  12. trungpt2

    trungpt2 Newbie

    Joined:
    Jun 26, 2013
    Messages:
    19
    Likes Received:
    6
    For who don't know anything about excel. Add =E2*(F2-1) to Row 2 Column H. Use Fill Handle to copy to all rows

    shot-apply-formula-1.png
     
  13. hatimyal

    hatimyal Senior Member

    Joined:
    Sep 14, 2011
    Messages:
    874
    Likes Received:
    152
    Occupation:
    Internet Marketer.
    Location:
    India
    hey great share actually.

    This could help in ranking and finding some damn good keywords.

    Will give it a try.

    Thank for the share man :)
     
  14. dazk2002

    dazk2002 Power Member

    Joined:
    Oct 23, 2012
    Messages:
    706
    Likes Received:
    220
    Location:
    Here and There
    I've used the formula and now I have the numbers, but what exactly do they represent? You say the number of searches but we already know that. Can you please explain?
     
  15. hatimyal

    hatimyal Senior Member

    Joined:
    Sep 14, 2011
    Messages:
    874
    Likes Received:
    152
    Occupation:
    Internet Marketer.
    Location:
    India
    Hi

    I tried it and it gives good number of keywords.

    Really helpful as you can get good amount of keywords with just one word

    Really liked it.

    Thanks man

    Yes I also want to know what does it mean?

    Thanks
     
    Last edited: Dec 1, 2013
  16. TheUnborn

    TheUnborn Elite Member

    Joined:
    Feb 21, 2013
    Messages:
    3,041
    Likes Received:
    1,672
    Occupation:
    SEO Consultant
    Home Page:
    This is goldmine,excellent share OP,gonna give this tutorial a try now.
     
  17. sibhe7

    sibhe7 Registered Member

    Joined:
    Nov 26, 2013
    Messages:
    61
    Likes Received:
    8
    Nice share OP, very clear information
     
  18. xpofkex

    xpofkex Junior Member

    Joined:
    Aug 18, 2010
    Messages:
    158
    Likes Received:
    35
    Thanks for nice share! :)
     
  19. dazk2002

    dazk2002 Power Member

    Joined:
    Oct 23, 2012
    Messages:
    706
    Likes Received:
    220
    Location:
    Here and There
    Great method, thanks. Can you explain though the formula =E2*(F2-1) idea. I've implemented it but what do the numbers in the results actually represent? If it's the KW competition then does it mean that the lower the number the less competition?
     
  20. izkech

    izkech Regular Member

    Joined:
    Jun 7, 2012
    Messages:
    433
    Likes Received:
    116
    Thank you for sharing those tips!!