Whether you’re launching a new site or figuring out what to write about that will bring a flood of perfect clients to your site, keyword research can help. And I’m not talking about the type of keyword research that requires a monthly subscription, or the top SEO (search engine optimization) minds to scientifically pinpoint.
Rather, let’s make it simple and fast, so that we can spend our time producing content rather than “planning to” produce content.
Here’s my fast, free and simple keyword research method to figure out what to write about that your perfect customers are looking for.
I used branding as my keyword. Press “Search.”
We find out that the keyword “branding” word has a monthly search volume of 90500, an SEO difficulty of 65 (where zero is the easiest and 100 is the most difficult to rank), a paid difficulty of 21 which means it's pretty easy to rank for if you're sending pay traffic to it, and a cost per click of $2.41. The fact that advertisers are willing to spend more than a dollar per click tells us that this keyboard is profitable.
Now let’s click on “Keyword Ideas.”
Ubersuggest returns 533 keywords. Even as I’m writing this, Neil is changing over Ubersuggest to a paid version. He will only let you download the first 100 keyword phrases as a .csv file.
Still, download them as a .csv file, open them, and build your keyword spreadsheet from there, or paste into Google Sheets.
Type in your starting keyword and it will return keyword suggestions.
Choose “Export All Keywords.”
A .csv file will be downloaded to your computer. Open the .csv file, copy all the keywords and add them to the bottom of the list you started in Step 1.
Again, type in your seed keyword and let it search.
Select all keywords.
Choose either to export to .csv or Excel, open the sheet, copy the keywords, and paste them into your growing list.
Type in your keyword and select “Search.”
Answer the Public returns longtail keywords based on questions stems, prepositions, comparisons, and alphabetical list and related. The alphabetical list is what would happen if you type your keyword into Google and then press space and then entered at the first letter of the alphabet it will return about 10 entries of branding space in the word that begins at eight and you can do that with each side of the alphabet. Instead of having to do that by hand, answer the public does that for you. As you scroll down the page you get really interesting visualizations of questions, prepositions, etc., but it’s not really useful in this form. What I suggest is to go back up to the top of the page and select download .csv.
Open the downloaded file select all the keywords copy them and paste them into your growing list.
Once you have a list of hundreds of keywords, now you want to figure out how much search volume these keywords are receiving. In other words, how many people are typing that keyword into Google search each month?
Start a new column in your spreadsheet, and type in the formula:
Notice that the range refers to the entire list of keywords, from cell B2 in this example to cell B349.
Notice how the list on the right populates with keyword phrases, automatically eliminating duplicates.
This new list on the right is the one you want to copy and paste into the next step.
Paste your entire list of keywords into the box at the top.
Searchvolume.io gives you a .csv file that is semicolon delineated, so do not open it straight away.
Rather, note its name and where it’s located on your hard drive.
Type import into the search bar of your keyword excel sheet.
It will direct you to find the file you want to import, and then will show you the results.
If everything looks correct, select “load.”
Rename the tab “Keyword Volume."
These are the topics your perfect clients are searching for in Google. These are their questions.
Start writing. Answer their questions better than anyone else. Be sure to include these keywords naturally in your content, as well as in the Title, Headlines, Images and SEO Metadata.
Over time, you’ll be found in the search engines. In the meantime, share your articles again and again to bring your content to those who need it most.
Whenever you're ready, here are the three best ways I can help you get more media attention.
1. Bulletproof Authority Secret Game Plan
2. Get Published Now 12-Week Coaching Program (complete form and schedule chat)
3. Get Media Placement Done-for-You Service (complete form and schedule chat)
When you join my list, I will send you weekly emails full of actionable information and the occasional special offer that will help you grow your visibility faster. I look forward to connecting with you.