If you set up a Google Adwords account, you can access a magical report called the "Paid & Organic Keywords" report.
Tl;DR Exporting Search Queries from Google Search Console limits you to 2,000. The Paid & Organic Search Report from Adwords gives you every single organic keyword that produced a visitor to your site. Yes, every single stinking one. Yay.
Don't worry, you don't actually have to spend money on campaigns to access this report. Simply set up a campaign, set your bid to $0.01 and pause the campaign.
THEN - you must connect your Google Search Console account to your Adwords account. This is a simple setting that can be enabled in the Admin area.
Downside - Data doesn't start being collected until the two tools are connected. You can't get historical data.
Instructions for setting up the Paid & Organic Search Report can be found here.
Google says (emphasis added by me): "Organic results are not constrained by your AdWords campaigns’ ad targeting settings. In other words, your ads are limited by the languages and locations you target in your AdWords account, but your organic search listings are not. That means it’s possible to have more organic impressions than paid impressions even if your campaigns have 100% impression share. For example, if your ad campaign for a given keyword is targeted just to the United States, an organic impression occurring in Canada would still show up in your paid & organic report for that keyword even though you don't advertise there."
Here are some helpful screenshots:
1. Where to go to set this up
2. What you see once successfully connected
3. How to navigate to the Paid & Organic report.
There you have it. Access to all of the keywords that have sent traffic to your site. The report is updated once a day. Date ranges are available back to the day you first connected your accounts.
Hope that helps! Hit me up if you have questions.
Dana
1vTq82n iSsbXfw 7MS4jHn