How to download your Search Query Report using Google Analytics Plugin for Google Sheets
To extract your Search Query Report, you can use the Google Analytics Plugin for Google Sheets. 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 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 Google Analytics, then Create new report,
The Create a new report window is shown on the right side of your screen
Name your report (Ex: Search Query Report) and Select the view to extract your data from.
On the Metrics text box, type the metrics we need to extract for Bob’s Keywords function properly:
- Clicks
- Impressions
- CPC (Cost Per Click)
- Cost Per Conversion
- Goal Completions
- Goal Conversion Rate
On the Dimensions text box, type Search Query
On the Segments text box, type Paid Traffic, then click on Create Report.
The plugin will create a new Google Spreadsheet on your Google Drive account. Don’t forget to name your Spreadsheet.
Before we run our report, we need to pay attention to some parameters we need to change: Start Date, End Date and Limit.
Type the date range you want to extract data into the Start Date and End Date parameters. Use YYYY-MM-DD as the date and time format (ex: 2022/01/01).
For the Limit parameter, type a number larger than the number of rows you are expecting, like 50,000, for example.
You also need to fill in the Report Name parameter.
After changing the parameters, you can run your report. Click on the menu option Extensions, then Google Analytics, then Run Reports.
When the report finishes its execution, you should see the following message:
The report generator adds some extra rows at the top that we don’t need. In the image below, these rows are 1 to 14.
Select all these rows until you reach the Header row (row 15 in the image above) and delete them. Click on the right button of your mouse and select the Delete rows command to delete the selected rows.
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 Start Date and End Date parameters accordingly and Run the Report again.