Find an Exact Match Domain

Edited by Djinu, Alexander Avdeev, Eng

You're watching VisiHow. In this video, we are going to show how to find an exact match domain using Google AdWords, Bulk Domain Name Search Tool by GoDaddy, and Microsoft Excel.


Ad

Steps

  1. 1
    To start with, we go to https://adwords.google.com
    .
    Advertisement
    Was this step helpful? Yes | No| I need help
  2. 2
    We click "Tools"
    .
    Advertisement
    Was this step helpful? Yes | No| I need help
  3. 3
    We click "Keyword Planner"
    .
    For example, our site may focus on gifts for women.
    Was this step helpful? Yes | No| I need help
  4. 4
    We click "Search for new keywords using a phrase, website or category"
    .
    Was this step helpful? Yes | No| I need help
  5. 5
    We click the "For example, flowers or used cars" input field
    .
    Was this step helpful? Yes | No| I need help
  6. 6
    For example, we type "gifts for women"
    .
    Was this step helpful? Yes | No| I need help
  7. 7
    We scroll down to the bottom
    .
    Was this step helpful? Yes | No| I need help
  8. 8
    We can target specific locations, languages, or Google and search partners
    .
    We leave "Targeting" at the default values.
    Was this step helpful? Yes | No| I need help
  9. 9
    We click "Get Ideas"
    .
    Initially, Google AdWords will show us groups of different keywords.
    Was this step helpful? Yes | No| I need help
  10. 10
    We click "Keyword ideas" to get all of the keywords listed
    .
    Keywords and average monthly searches will be shown to us.
    Was this step helpful? Yes | No| I need help
  11. 11
    We click "Download" to download all of the information
    .
    Was this step helpful? Yes | No| I need help
  12. 12
    We can click "AdWords Editor CSV" or "Excel CSV", depending on where we want to open the file
    .
    Was this step helpful? Yes | No| I need help
  13. 13
    We can check "Save to Google Drive"
    .
    Was this step helpful? Yes | No| I need help
  14. 14
    We click "Download"
    .
    Was this step helpful? Yes | No| I need help
  15. 15
    We click "Save file"
    .
    Was this step helpful? Yes | No| I need help
  16. 16
    We open the saved file
    .
    Was this step helpful? Yes | No| I need help
  17. 17
    We expand the column with the keywords
    .
    Was this step helpful? Yes | No| I need help
  18. 18
    We select all of the keywords between "B2" and "B500"
    .
    Bulk Domain Tool by GoDaddy allows us to search 500 keywords at a time.
    Was this step helpful? Yes | No| I need help
  19. 19
    We copy the selected cells by pressing "Command" and "C"
    .
    Was this step helpful? Yes | No| I need help
  20. 20
  21. 21
    We paste the copied cells by pressing "Command" and "V"
    .
    Was this step helpful? Yes | No| I need help
  22. 22
    We click "GO" to search for the keywords
    .
    Was this step helpful? Yes | No| I need help
  23. 23
    We go to the "B501" cell in the Excel document
    .
    Was this step helpful? Yes | No| I need help
  24. 24
    We select all of the cells between "B501" and "B805"
    .
    Was this step helpful? Yes | No| I need help
  25. 25
    We copy the selected cells by pressing "Command" and "C"
    .
    Was this step helpful? Yes | No| I need help
  26. 26
    We go back to GoDaddy
    .
    We will be shown unavailable domain names. At the bottom we have the domain names that are available.
    Was this step helpful? Yes | No| I need help
  27. 27
    We paste the new cells that we've just copied over to the "Bulk Registration" input box
    .
    Was this step helpful? Yes | No| I need help
  28. 28
    We click "GO"
    .
    We will get an updated list of unavailable domain names as well as the domain names that are available.
    Was this step helpful? Yes | No| I need help
  29. 29
    We click "Select All"
    .
    Was this step helpful? Yes | No| I need help
  30. 30
    We click "Copy All"
    .
    Was this step helpful? Yes | No| I need help
  31. 31
    We select all of the items by pressing "Command" and "A"
    .
    Was this step helpful? Yes | No| I need help
  32. 32
    We copy the items by pressing "Command" and "C"
    .
    Was this step helpful? Yes | No| I need help
  33. 33
    We insert a new "C" column into the Excel document
    .
    Was this step helpful? Yes | No| I need help
  34. 34
    We click the "C2" cell
    .
    Was this step helpful? Yes | No| I need help
  35. 35
    We paste the copied text by pressing "Command" and "V"
    .
    Now, we will clean up the data a bit because we need to find out which items are available from the "C" column and match them with the "B" column to see all of the relevant data.
    Was this step helpful? Yes | No| I need help
  36. 36
    We add one more additional "C" column
    .
    Was this step helpful? Yes | No| I need help
  37. 37
    We select the "B" column
    .
    Was this step helpful? Yes | No| I need help
  38. 38
    We press "Control" and "H" to find and replace text
    .
    Was this step helpful? Yes | No| I need help
  39. 39
    We press the space bar in the "Find what" field
    .
    We want to replace all spaces with nothing.
    Was this step helpful? Yes | No| I need help
  40. 40
    We click "Replace All"
    .
    Was this step helpful? Yes | No| I need help
  41. 41
    We click "OK"
    .
    Was this step helpful? Yes | No| I need help
  42. 42
    We click "Close"
    .
    Was this step helpful? Yes | No| I need help
  43. 43
    We click the "C2" cell
    .
    Was this step helpful? Yes | No| I need help
  44. 44
    We type "=CON" and click "CONCATENATE"
    .
    Was this step helpful? Yes | No| I need help
  45. 45
    We click the "B2" cell
    .
    Was this step helpful? Yes | No| I need help
  46. 46
    We type ",".com""
    .
    We press "Enter". This will add ".com" to the end of each keyword in the "B" column.
    Was this step helpful? Yes | No| I need help
  47. 47
    We double-click the lower right-hand corner of the "C2" cell after highlighting it
    .
    We will fill the "C" column down. Now, we will use a conditional formatting formula.
    Was this step helpful? Yes | No| I need help
  48. 48
    We click "Conditional Formatting"
    .
    Was this step helpful? Yes | No| I need help
  49. 49
    Was this step helpful? Yes | No| I need help
  50. 50
    We click the "Style" drop-down menu
    .
    Was this step helpful? Yes | No| I need help
  51. 51
    We click "Classic"
    .
    Was this step helpful? Yes | No| I need help
  52. 52
    We click the drop-down menu with "Format only top or bottom ranked values"
    .
    Was this step helpful? Yes | No| I need help
  53. 53
    We click "Use a formula to determine which cells to format"
    .
    Was this step helpful? Yes | No| I need help
  54. 54
    We type the "=countif($d$2:$d$500,c2)" formula
    .
    Was this step helpful? Yes | No| I need help
  55. 55
    We click the "Format with" drop-down menu
    .
    Was this step helpful? Yes | No| I need help
  56. 56
    We click "green fill with dark green text"
    .
    Was this step helpful? Yes | No| I need help
  57. 57
    We click "OK"
    .
    Excel will highlight the available domain names.
    Was this step helpful? Yes | No| I need help
  58. 58
    If we want to see only the available domain names, we can filter the list further
    .
    We click "Data".
    Was this step helpful? Yes | No| I need help
  59. 59
    We click "Filter"
    .
    Was this step helpful? Yes | No| I need help
  60. 60
    We click the drop down arrow for the "C" column
    .
    Was this step helpful? Yes | No| I need help
  61. 61
    We click "By color"
    .
    Was this step helpful? Yes | No| I need help
  62. 62
    We move the cursor to "Cell Color"
    .
    Was this step helpful? Yes | No| I need help
  63. 63
    We click the color that we've just added
    .
    Was this step helpful? Yes | No| I need help
  64. 64
    We close the filter window
    .
    We will see the filtered items.
    Was this step helpful? Yes | No| I need help
  65. 65
    We can also highlight the "D" and "E" columns
    .
    Was this step helpful? Yes | No| I need help
  66. 66
    We right-click the selected columns and click "Hide"
    .
    We will directly see the average number for monthly searches. Hopefully, we can find one of the exact match domains that has a large number of searches and is relatively short in its name length. We can go from there and build a successful web site that, for example, will sell gifts for women.
    Was this step helpful? Yes | No| I need help
    Advertisement

If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!

Video: Find an Exact Match Domain

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.

Article Info

Categories : Online & Web Job Related

Recent edits by: Alexander Avdeev, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 175 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No