Excel spreadsheets can be very powerful tools when domaining. One of my favorite ways to use them is to collect terms that can be combined with various keywords. I am making a sample file available for free at the end of this post.
This works well by picking a particular niche and browsing through web pages, magazines and other information about that niche and picking out associated keywords.
Let me give you an example
| depression | agency | depressionagency |
| attack | depressionattack | |
| books | depressionbooks | |
| burden | depressionburden | |
| cases | depressioncases | |
| causes | depressioncauses | |
| clinic | depressionclinic | |
| control | depressioncontrol | |
| cure | depressioncure | |
| day | depressionday | |
| diagnosis | depressiondiagnosis | |
| doctor | depressiondoctor | |
| drugs | depressiondrugs | |
| education | depressioneducation | |
| expert | depressionexpert |
In the center column are a list of terms you have collected as you browsed the subject. In this case, they are medical related. The single term at the top left “depression” is the term you enter and it will automatically be combined with all the terms in the center column and the output is in the third column.
Checking registration
I use Moniker to check multiple domains. You can get to Moniker’s bulk domain checker here (opens in new window) and by clicking on the Multiple Domains link below the list of extensions. You can then cut and paste everything from column three above (up to 500) and check for registration.
Spreadsheets for each niche
I create spreadsheets for each niche with terms collected for that particular niche. This helps me build up a much more powerful set of terms for each particular area. It also limits the numer of combined terms in column three that I have to look through. If you have only one spreadsheet you can quickly exceed 500 combined terms and many of them will be useless.
Get the spreadsheet here
I am making a sample spreadsheet available here which you can get at the link below. To adapt the spreadsheet, you can change the terms in column 2 to new ones by just typing them in. To extend the list in column 3, copy the last combined term and paste it into the empty cells in column 3. This will copy the formula into those cells and combine the term in column 1 with the term in column 2.
If you need any help, feel free to email me. You can find contact information at the bottom of the About PredictiveDomaining.com page
Other Sample Excel sheets:
Using multiple columns to cover multiple keywords
Using multiple sheets to cover multiple keywords
All combinations of keywords Warning: This is processor intensive calculation
{ 11 comments… read them below or add one }
This is awesome. Thanks!
How do you make a spreadsheet with 2 columns of keywords like a multiplication table in case one doesn’t want to deal with multiple spreadsheets?
Hi Tony. Glad you liked it. Tell me a little more about what you want. If you mean all combinations of keywords from two columns, then that number of combinations grows exponentially and would be too massive. For 100 keywords in column one combined (all combinations) with 100 keywords in column 2 then that would be 100 to the power of 2 = 10,000 concatenated words.
If you want more though, there are tabs at the bottom of the page labeled sheet 1, sheet 2 etc. You could have a different sheet with different terms on it. Alternatively you could add multiple columns going across.
I will make some other examples and add them to the bottom of the post and you can choose which one you want.
Hi admin,
I was thinking of the 100×100 spreadsheet with the 10,000 combinations example. What I have in mind is being able to cut and paste a list of terms in column A, doing the same but with a different set in B and Column C would be the resulting combinations. I know Moniker has a 500 domain limit for its bulk search but I can always just cut and paste from column C in increments of 500.
Thanks for the speedy reply.
Tony,
I added a couple of other combinations. I will need a bit of time to do the “all combinations” one. I will post it tomorrow at the latest.
Barry (admin)
Barry,
Thanks for the great work. I look forward to the NxN spreadsheet.
Tony,
The all combinations example is posted. It should be good up to 100×100. It uses a formula and can take a little bit of time to calculate depending on your processor speed.
All the best
Barry
how do you guys efficiently delete duplicates, that is rows with duplicate keywords?
i need a remove duplicate rows macro
Hi Namer, I usually don’t remove duplicates and just paste the whole, list duplicates and all into Moniker’s multiple domain registration check. It will ignore duplicates.
If you still need a de-duplicate macro, I can either make one or look for one for you.
Barry,
I have been looking for something like this for a while now. This will save me a lot of time going
forward. Thanks so much!
Tony,
Glad to help. Hope it works ok for you.
Barry
Awesome advice. Love the concatenate.
Well done!