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

[METHOD] How to find your perfect EMD

Discussion in 'Domain Names & Parking' started by roki4ka, Nov 10, 2016.

  1. roki4ka

    roki4ka Senior Member

    Joined:
    Jun 20, 2016
    Messages:
    887
    Likes Received:
    644
    Hello,

    Maybe some of you know or maybe don't know that for 2-3 days I was struggling to find my best EMD names.

    Well, I finally did...

    EMD without dashes, 74k searches per month, low competition long tail keyword (3 words) exact match for my niche!

    2nd and 3rd EMD DOMAINS 20k+ searches per month, low competition long tail keywords (3 words)!

    I will tell you, how to find you dream EMD in few easy steps.

    1. Go to leandomainsearch.com and enter 1-2 words that you want to include in your domain, with space between them. Even make combinations, for example, make 1 search for word1 word2, 2nd for word1 word3, 3rd for word1 word4, etc., whatever you want.

    2. Copy the lists one by 1 to the clipboard (should be 3k+ domains per list - all available for registration)!

    3. Paste the list in excel

    4. Press alt+f11 and press INSERT > MODULE. Copy-paste this:

    Code:
    Function AddSpaces(pValue As String) As String
    'Update 20140723
    Dim xOut As String
    xOut = VBA.Left(pValue, 1)
    For i = 2 To VBA.Len(pValue)
       xAsc = VBA.Asc(VBA.Mid(pValue, i, 1))
       If xAsc >= 65 And xAsc <= 90 Then
          xOut = xOut & " " & VBA.Mid(pValue, i, 1)
       Else
          xOut = xOut & VBA.Mid(pValue, i, 1)
       End If
    Next
    AddSpaces = xOut
    End Function
    It's a function that will add space before a capital letter.

    Save and close visual basic.

    5. Return to your list (which should be in A) and make the function in the 1st cell in B "=addspaces (A1)". Drag it to the end of the list so it can make the function for all the cells in B.

    6. Copy and paste everything in B in Keywords Everywhere.

    7. Export the newly generated list in new excel file and make filters for the columns.

    8. Arrange the results by search VOLUME and make it show everything above 1000 searches.

    9. Check all keywords in MOZ or/and use inanchor/intitle functions in google search to find the best keyword

    ENJOY!!!
     
    • Thanks Thanks x 5
    Last edited: Nov 10, 2016
  2. HsSnFire

    HsSnFire Junior Member

    Joined:
    Jan 27, 2016
    Messages:
    144
    Likes Received:
    36
    Gender:
    Male
    leandomainsearch.com
     
  3. roki4ka

    roki4ka Senior Member

    Joined:
    Jun 20, 2016
    Messages:
    887
    Likes Received:
    644
    ty
     
  4. bold rapunzel

    bold rapunzel Newbie

    Joined:
    Feb 29, 2016
    Messages:
    28
    Likes Received:
    16
    Very nice guide

    I'd also like to add how to get the volume results for that many keywords:
    - this works for chrome and firefox
    - search for keywords everywhere addon and install it in your browser
    - get an api key by giving any email (it can be temporary email)
    - click on the icon of the addon => "update settings" => insert the key they sent you and validate
    - again click on the icon => "bulk upload keywords" => paste the list and get the results
    - sort by search volume

    voila you have a lot of results
    i'm not associated with the addon at all
     
    • Thanks Thanks x 1
  5. company B

    company B Newbie

    Joined:
    Dec 12, 2016
    Messages:
    37
    Likes Received:
    1
    Gender:
    Male
    Thanks
     
  6. Purush

    Purush Senior Member

    Joined:
    Jul 12, 2016
    Messages:
    1,163
    Likes Received:
    187
    Gender:
    Male
    Its too techincal for me. Some people may find useful.
     
  7. Mex

    Mex Jr. VIP Jr. VIP

    Joined:
    Aug 31, 2016
    Messages:
    187
    Likes Received:
    67
    Maybe it's easier going to expireddomains.net, type a keyword and order results by search volume, you can activate the filter to show only available domains.
     
  8. roki4ka

    roki4ka Senior Member

    Joined:
    Jun 20, 2016
    Messages:
    887
    Likes Received:
    644
    This just sounds technical - in reality it's super easy.
     
  9. daica85

    daica85 Regular Member

    Joined:
    Jun 19, 2010
    Messages:
    476
    Likes Received:
    99
    Gender:
    Male
    Occupation:
    Freelancer
    Location:
    US
    Home Page:
    It's too technical for me too. I usually use expireddomain and justdropped instead.
     
    Last edited: Dec 19, 2016
  10. AustinNash5

    AustinNash5 Jr. VIP Jr. VIP

    Joined:
    Jun 9, 2016
    Messages:
    526
    Likes Received:
    117
    Gender:
    Male
    Nice post :) Looking forward to seeing your wordpress themes post.
     
  11. terrycody

    terrycody Supreme Member

    Joined:
    Sep 29, 2012
    Messages:
    1,455
    Likes Received:
    400
    Occupation:
    marketer
    Location:
    Hell
    Thanks for share this method, its cool have to say, I am sure someone mentioned this site b4, I forget it for a long time, now re-remember this!

    Though I am run into a problem, after I paste these code into my Excel 2007, and saved as Excel+macro, when I re-open it, nothing happened lol.

    Anyway, good method!