N-Grams basically tell us how many times a word or a sequence are repeated in our keyword list. With N-Gram data, you’ll able to optimize your content strategy by understanding the most popular and repetitive set of keywords in your Google Search Console (GSC) data. For example:
“cheap flight ticket to Germany” and “cheap plane ticket to Germany” are practically same queries with the same intent. But Google doesn’t rank websites in the same order, so it’s important to decide which terms to focus on by analyzing your own GSC data.
In this post, I’m going to explain how to do N-Gram analysis for your GSC data with our free Keyword N-Gram Analyzer tool.
Step 1: Get your data from Search Console
First, we need data. Luckily, GSC provides Export option to Google Sheets, Excel or CSV.
There’re two approaches to get the data. You can either copy the first 500 queries of your GSC or export your data to Google Sheets.
First approach: Copy and paste
On your GSC panel, go to Performance tab. After setting your date and search type filter, simply copy all the data as shown below.
Second approach: Export your data to Google Sheets
This method is more suited for you if selecting and copying data manually sounds hard.
Go to Performance tab on left panel. There, you’ll see Export on right-top of your page, then click on Google Sheets.
- Then you’ll get a Google Sheet filled with your GSC data. You’ll only need the Queries page, as shown below.
Step 2: Run the N-Gram Analyzer
Until this step, you’ve prepared your data and copied to clipboard. Now, you can run the tool by following the steps on the screenshot below.
- First, paste your data to the left bar with CTRL + V for Windows and Command + V for Mac.
- Select your Delimeter as Tab
- Keep the Use Column Header Names option, and click on Analyze N-Grams
- After you’ve clicked on Analyze N-Grams, just wait a couple seconds and you’ll get your N-Gram results listed.
Step 3: Analyze or export N-Gram results
Now, you can see the results of N-Gram analysis.
By clicking on the “arrow” next to each header, you can re-order the list per category stats like clicks, count, and impressions.
Or, you can now simply export your N-Gram results as .csv file or copy to your clipboard.
With Keyword N-Gram Analyzer results, it’s now quite easy to determine winner and loser N-Grams by simply making use of your GSC data.
- Go to the Google Search Console
- Get your data ready in tab separated format
- Run the tool
- Get your N-Gram analysis results
- Detect winner and loser N-Grams