View Google Search Console data in months
23 February 2023·
It’s nice to see your blog recognized by Google but checking the number of clicks becomes addictive. It’s important to remember that SEO is a very long game. Checking every day is really disheartening because the data fluctuates a lot on a daily basis. It’s important to zoom out and take a look at the larger trends.
We want to look at clicks and impressions on monthly intervals instead of daily but the Google Search Console doesn’t do this. Fortunately, it let’s you export the data.
Export to Google Sheets
The search console is integrated nicely with another Google product: Google Sheets. We can export the data there and summarize it into months.
From the console overview navigate to the performance tab:
Set the date range for your data and export it to Google Sheets:
Now we have the data in Google sheets we can summarize it into months.
Google Sheets pivot table
The impressions and clicks by date get put into a tab called ‘Dates’ in the Google sheet.
Navigate to the tab, select all of the data and insert a new pivot table through the ‘Insert’ menu option:
Adding a pivot table opens the Pivot table editor which is where we can define our table.
Add the Date data to the table rows and the Impressions data to the Values:
Finally, we can group the data by date by right-clicking the date column and selecting “Create pivot date group”:
And that should be it. Data is now be grouped into whatever increment you like.