How to analyze winning and losing search patterns

Keeping up with the performance of all the queries in Google Search Console might be time-consuming. It’s also bad for your eyes 🙂

Of course, there’re many paid tools available that create charts where you see the performance difference in time. But, we offer a free solution with the help of our Keyword N-gram Analyzer.

Comparing query performance in time (28 days, 3 months, or a custom time) helps you keep track of your overall Google Search performance. You’ll see which queries and N-grams are performing the best or where you lack impressions and traffic.

In this post, I’m going to explain how to see all your winning & losing queries and N-grams in seconds.

On this page

    Step 1: Get search data from Google Search Console

    You first need to fetch comparable performance data from Google Search Console (GSC).

    gsc panel

    On your GSC panel, go to Performance tab. Then proceed to Date button

    set data range

    Now, choose whichever time range is the most suitable for you and click on Apply. I selected three months comparing for this tutorial.

    Step 2: Export to Google Sheets and modify your data

    export to google sheet

    Go to Performance tab on left panel. There, you’ll see Export on right-top of your page, then click on Google Sheets. GSC data do not provide the Clicks and Impressions difference between two time periods. So, we need to manually modify the Google Sheets page, simply get rid of columns like CTR. Then, create two new columns (Click & Impression Difference) as shown below by using simple formula: B2-C2 and E2-F2

    google sheet data
    • Now you’ll get a Google Sheet filled with your GSC data. You’ll only need the Queries page, as shown above. Ideally, you can arrange your data further per your need. For instance, I deleted CTR and Position data as I only need query and keyword performance.

    Step 3: Paste your data and run the tool

    run the tool

    Now, you can run the tool by following the steps on the screenshot above.

    • First, paste your data to the left bar, select your Delimeter as Tab, keep the Use Column Header Names option, and click on Analyze N-Grams, then just wait a couple seconds and you’ll get your N-Gram results listed.

    Step 4: Analyze or export your winning & losing N-grams

    analyze the result page

    Now, you can see the comparable queries in N-gram format. By clicking on the “arrow” next to each header, simply re-order the list per category stats like clicks and impressions. Or, you can now simply export your N-Gram results as .csv file or copy to your clipboard.

    On the result sheet, I can easily determine which N-grams & Search Patterns are winning or losing over time. For instance;

    • As you see, some of my queries & impressions are considerably winning while the rest with low volume seem stable or losing a bit.
    • This way, you’ll have an overview of which search patterns or N-grams tend to perform better or which ones lose interest and performance over time.
    • With this method, you can adapt your content strategy to fill the gaps that occurs over time.

    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.

    Keyword Scaling, SEO Tools

    More Similar Posts

    Menu