Forums Forums White Hat SEO How to find long-tail opportunities using Google Search Console

  • How to find long-tail opportunities using Google Search Console

    Posted by SEOPub on March 1, 2023 at 2:03 pm

    Here is a really simple way to find long-tail keyword opportunities using Google Search Console and a simple regex filter.

    \- Go to Google Search Console and select Search Results
    \- Select the past 28 days for your date range
    \- Add a query filter.
    \- Select Custom (regex)
    \- Select Matches regex
    \- Enter \^\[\\w\\W\\s\\S\]{25,}

    This will pull all queries that are 25 characters or longer. You can select a different length if you want by adjusting the 25 in the regex expression.

    Export this to Google Sheets. Select Column E (the column with Position data). In the menu go to Data >> Create filter.

    Now click on the filter icon and choose Filter by condition. In the dropdown menu, select ‘is between’. Select values of 10 and 20.

    This will give you all search queries that are 25 characters or more and have an average position of 10 to 20. These are potential long-tail opportunities that you can either adjust your existing content to try to target or possibly create new content to target more effectively.

    \* Instead of across the entire site, you can do this for a single page instead by adding it as a page filter. On larger sites with lots of well ranking search queries, you may need to do it by page because of the 1000 term limit in GSC.

    \* You could select a longer date range for the date filter. The reason I like to use 28 days is because it will give a large number of results, but be closer to where those terms are ranking today. If you select the past 12 months, you may end up with a lot of terms that have an average ranking of say 14, but have recently moved up much higher than that.

    SEOPub replied 1 year, 2 months ago 2 Members · 1 Reply
  • 1 Reply
  • Brunchables

    Guest
    March 1, 2023 at 5:35 pm

    thank you. i see some opportunities. saved!

Log in to reply.