How to download your Organic Searches Report using Search Analytics for Sheets plugin
Before generating your report, please ensure your Google Ads and Google Analytics accounts are already linked.
To extract your Organic Searches Report, we will present to you the easiest option, which is using the Search Analytics for Sheets plugin. Using this plugin, you’re able to export more than the 5,000 rows limit currently imposed by Google Analytics. Please note that this plugin requires you have access to a Google Drive account, as the reports generated by the plugin are always saved on Google Drive.
Click here to access the plugin installation page.
Click on Install. The plugin will ask you permission to have access to your Google account. After installing the plugin, you should see the image below.
Go to your Google Drive account, click the New button, and choose Google Sheets. Now you have an empty Google Sheet.
Open the menu option Extensions, then the menu option Search Analytics for Sheets, then choose Open Sidebar
The configuration panel for this report is quite simple. Choose the domain/website you want to generate your report using the Verified Site option. Change the date range and then type Query on the Group By text box. Then click on the Request Data button.
Now you can download your report as a CSV file, which is the format required by Bob’s Keywords. Click on the menu File, Download, then Comma-separated values.
You should be able to open your report in any text editor like Windows Notepad or Notepad++.
You can run this report as many times as you want. Change the Date Range parameters accordingly and Run the Report again.