Congratulations on getting started with THE most important aspect of SEO – keyword research! Perhaps you signed up to get one of our example keyword research packages – or maybe you’ve chosen to purchase one of our ‘done-for-you’ keyword research packages. Either way, this page will walk you through how to access your data and what to do with it.
How to Access Your Keyword Research Data
Your keyword research data arrives in the form of a Google Spreadsheet. Check your email inbox – it should arrive via email almost instantly after you sign up or purchase. Check your spam folder if you don’t see the email within a few minutes. The email will contain a link to a spreadsheet which contains the latest updated data.
Note: You will NOT be able to edit or make changes to this original spreadsheet
Make Your Own Copy of the Original Spreadsheet
Important: In order to be able to edit, sort, make changes, etc – YOU MUST create your own copy of the spreadsheet.
While viewing the original Google Spreadsheet – click on the File menu then select Make a copy…
Rename your copy of the spreadsheet to whatever you want and it will automatically save within your own Google Drive account.
If you would rather not use Google Sheets – click on the File menu then select Download as and choose whichever option is most suitable for you (Microsoft Excel is a popular alternative).
The Keyword Research Data Explained
First of all – you should be aware that there are 2 (or 3) separate spreadsheets delivered within the same data file. As part of your keyword research package, you will receive extensive data from two of the very best keyword research tools – Long Tail Pro and SECockpit. As an added bonus – if your niche promotes products sold on Amazon – you will also receive a list of the top rated products currently being sold on Amazon (extracted from the powerful AmaSuite software). Simply access each of these sheets by clicking one of the tabs as shown in the picture below…
The Long Tail Pro Data
Each column displays data pulled in from Long Tail Pro. This data will be updated periodically and the last date that we updated it will be displayed on the title (name) of the spreadsheet itself (at the very top). Below are brief descriptions of what the data in each column represents.
Keywords are terms that an end user would type into a search engine, such as Google.
- Tip: Use the search function (Ctrl-F on a PC) to find similar keywords and group those together to possibly use in the same article.
This particular search volume metric displays local search volume (not worldwide) data based on using United States as the location and Google as the search engine. This is the average number of times per month that users have searched for this exact keyword, averaged out over a 12-month period.
The Adwords bid is calculated by taking into account the costs-per-click (CPC’s) that advertisers are paying for Google Adwords advertising in the United States for that particular keyword. The amount is only a forecast and actual CPC’s may vary.
- Tip: Use this metric just to get a general idea for how much money is being spent online to advertise for this particular keyword. Higher amounts here generally indicate more profitable keywords.
A value of Low, Medium or High – indicating the amount of advertisers for each keyword relative to all keywords across Google for United States and Google Adwords targeting. Low means less advertisers are spending on that particular keyword and High means more advertisers are spending money on that exact keyword.
- Tip: Try to go after keywords that have High or Medium Adwords Competition metrics. More advertisers for a particular keyword usually means that there is more money to be made for website owners in that niche.
The total number of words in the keyword. “Long tail” keywords generally have more words and are usually lower in competition and easier to rank for.
An estimated monthly value of ranking in the top organic search result. By default, this calculation uses the Adwords suggested bid and an estimated click-through-rate.
- Tip: If you use Long Tail Pro for keyword research, you can customize this value by setting it to use any monetization value (Amazon or other Affiliate sources) and any estimated click-through-rate. For Amazon niches – use the average price (on Amazon) for the product that will be promoted for that particular keyword.
Average Keyword Competitiveness – a number from 0 to 100 that measures how difficult it is to rank on the first page of Google for the keyword. This metrice is calculated using the page title, Majestic Trust Flow and Citation Flow, links, site age and other factors of the top 10 results found in Google for the keyword. Higher numbers indicate a higher level of keyword difficulty.
- Tip: KC scores have been a standard metric in the world of SEO for several years. Most experienced site builders agree that KC scores of 30 or below are generally the best (easiest) keywords to go after. The following graphic displays a great overview…
The language setting used in Long Tail Pro when analyzing these keywords and compiling this list. All lists on Niche Wolf use English as the language.
The location setting used in Long Tail Pro when analyzing these keywords and compiling this list. All lists on Niche Wolf use United States as the location.
The SECockpit Data
The SECockpit sheet provides a TON of data. I’m not going to explain every data column in detail here. If you want to see exactly what each of those columns represents – feel free to take a look at the official SECockpit Manual (starting on page 7).
The two most important columns on this sheet are the Phrase (keywords) column and the Monthly Searches column. SECockpit has some really cool features built in that enable you to come up with way more (and better) keywords than other popular keyword tools are able to generate. For this reason – we include every single keyword (phrase) that SECockpit generates. Even the keywords that have zero search volume are valuable and will give you some really great ideas for topics to write about on your site.
The AmaSuite Data (Top Amazon Products)
Again, this spreadsheet tab is only included for niches that have Amazon products to promote. This data is VERY important, powerful and useful. Using the incredible AmaSuite software, we collect data for the most popular (top selling) products on Amazon for the particular search term. We then filter that data to show ONLY the products that have minimum ratings of 4 stars from at least several hundred live reviews.
AmaSuite provides way more information than we need for niche site purposes. Focus your attention on the following columns in the ‘Top Rated Amazon Products’ tab of your spreadsheet…
- Search Rank – position on Amazon (for search phrase)
- Product Link – to see the live listing on Amazon
- Sale Price – most products on Amazon have a sale price (if not, look at List Price)
- Commissions – this is the commission you would receive (based on a 7% rate assumption)
- Rating – current average star rating on Amazon
- Reviews – the number of live reviews on Amazon
Note: All AmaSuite data is subject to change daily. The data provided in the spreadsheet is accurate only on the day that it was extracted. All AmaSuite data provided by Niche Wolf applies only to Amazon.com (United States).
Consider picking up your own copy of AmaSuite if you want to do detailed Amazon product analysis and have the ability to filter the data.
How to Sort the Data by Columns
Sorting data by columns in Google Sheets is very easy. For example… say you want to sort all of the data to display in order by lowest KC Score to highest KC Score. All you need to do is highlight the column that you want to sort by, then click the Data menu and select which option you want to sort by.
Important: ALWAYS use the Sort sheet option (NEVER use Sort range) so that all of the horizontal data corresponds correctly and stays intact. The image below depicts very clearly how to do this…
Reading This Page but Haven’t Purchased Yet?
Coming soon… Our Keyword Research Packages For Sale page is still in its infancy. Maybe you can be one of the early-bird buyers!