If you happen to’re previous in search engine optimisation years, you bear in mind the day [not provided] was launched. It was a darkish, darkish day. SEOs misplaced an unlimited quantity of trusty info. Click on information. Conversion information. This was extremely worthwhile, permitting SEOs to prioritize their targets.
Google mentioned the data was eliminated for safety functions, whereas suspicious SEOs thought this was a push in direction of spending extra on AdWords (now Google Adverts). I get it — since AdWords would provide the key phrase information SEOs cherished, the “controversy” was warranted, in my view. The reality is on the market.
However we’ve moved on, and discovered to reside with the state of affairs. Then just a few years later, Google Webmaster Instruments (now Search Console) began offering a few of the key phrase information within the Search Analytics report. By way of the years, the report obtained higher and higher.
However there’s nonetheless a finite set of key phrases within the interface. You possibly can’t get greater than 999 in your report.
Guess what? Google has extra information for you!
The Google Search Console API is your pal. This summer season it turned even friendlier, offering 16 months price of knowledge. What chances are you’ll not know is that this API may give you greater than 999 key phrases. By means of instance, the API gives greater than 45,000 for our Greenlane web site. And we’re not even a really giant web site. That’s proper — the API may give you key phrases, clicks, common place, impressions, and CTR %.
simply leverage the API
If you happen to’re not very technical and the considered an API frightens you, I promise there’s nothing to worry. I’m going to indicate you a option to leverage the information utilizing Google Sheets.
Here’s what you will have:
If you happen to haven’t heard of Google Sheets, it’s one in all a number of instruments Google gives totally free. This immediately competes with Microsoft Excel. It is a cloud-based spreadsheet that works exceptionally effectively.
If you happen to aren’t aware of Supermetrics, it’s an add-on for Google Sheets that enables information to be pulled in from different sources. On this case, one of many sources can be Google Search Console. Now, whereas Supermetrics has a free trial, paid is the best way to go. It’s price it!
Set up of Supermetrics:
- Open Google Sheets and click on the Add-On possibility
- Click on Get Add-Ons
- A window will open the place you’ll be able to seek for Supermetrics. It can appear like this:
From there, simply observe the steps. It can instantly ask to hook up with your Google account. I’m certain you’ve seen this type of dialog field earlier than:
You’ll be greeted with a message for launching the newly put in add-on. Simply observe the prompts to launch. Subsequent you’ll see a brand new window to the best of your Google Sheet.
At this level, you need to see the next notice:
Nice, you’re logged into Google Search Console! Now let’s run your first question. Decide an account from the listing beneath.
Subsequent, all you must do is figure down the listing in Supermetrics. Knowledge Supply, Choose Websites, and Choose Dates are fairly self-explanatory. Once you attain the “Choose metrics” toggle, select Impressions, Clicks, CTR (%), and Common Place.
Once you attain “Break up by,” select Search Question because the Break up to rows possibility. And decide a big quantity for variety of rows to fetch. If you happen to additionally need the web page URLs (maybe you’d like your information divided by the web page degree), you simply want so as to add Full URL as effectively.
You possibly can play with the opposite Filter and Choices in case you’d like, however you’re able to click on Apply Adjustments and obtain the information. It ought to compile like this:
Bought the information. Now what?
Generally optimization is about taking one thing that is working, and making it work higher. This information can present you which of them key phrases and matters are necessary to your viewers. It’s additionally a clue in direction of what Google thinks you’re necessary for (thus, rewarding you with clicks).
SEMrush and Ahrefs can present rating key phrase information with their estimated clicks, however impressions is an attention-grabbing metric right here. Excessive impression and low clicks? Perhaps your title and outline tags aren’t compelling sufficient. It’s additionally enjoyable to VLOOKUP their information towards this, to see simply how correct they’re (or aren’t). Or you should use a device like PowerBI to append different buyer or paid search metrics to color an even bigger image of your guests’ mindset.
Generally the littlest hacks are essentially the most enjoyable. Google generally holds some information again by means of their free merchandise (the Greenlane Indexation Tester is an efficient instance with the previous interface). We all know Search Planner and Google Analytics have greater than they share. However in these instances, the place directional info can typically be sufficient, digging out much more of your impactful key phrase information is pure gold.