If you\u2019ve been an web optimization for even a short while, you\u2019re possible acquainted with Google Search Console (GSC). It\u2019s a helpful device for getting details about your web site and its efficiency in natural search. That stated, it does have its limitations. <\/p>\n
In this text, you\u2019ll find out how to get better-connected knowledge out of Google Search Console in addition to improve the dimension of your exports by 400%.<\/p>\n
Google Search Console limitations<\/h2>\n
While GSC has various sections, we\u2019ll be specializing in the \u201cPerformance\u201d report. From the GSC dashboard, there are two methods you possibly can entry this report:<\/p>\n Once inside the \u201cPerformance\u201d report, knowledge for queries and pages will be accessed:<\/p>\n This reveals one in every of the points with GSC: Query and web page knowledge is separated. <\/p>\n In different phrases, if I would like to see the queries a particular web page is rating for, I’ve to first click on \u201cPages,\u201d choose the web page, after which click on \u201cback\u201d to \u201cQueries.\u201d It\u2019s a really cumbersome expertise.<\/p>\n The different (two-part) concern is with exporting:<\/p>\n We\u2019ll look to resolve these points by using the GSC API.<\/p>\n Now we all know the GSC person interface does have limitations: Connecting question knowledge with web page knowledge is difficult, and exports are restricted. <\/p>\n If the GSC UI represents the manufacturing facility default, the GSC API represents our customized settings. It takes a bit extra effort, however offers us extra management and opens up extra potentialities (not less than in the realm of question and web page knowledge).<\/p>\n The GSC API is a method for us to join to the knowledge inside our account, make extra personalized requests, and get extra personalized output. We may even bypass these manufacturing facility default settings like exports restricted to 1,000 rows, as an illustration.<\/p>\n Remember how I stated earlier that question and web page knowledge is separated in the \u201cvanilla\u201d GSC UI? Well, with the API, we are able to join question knowledge with the web page that question ranks for, so no extra clicking forwards and backwards and ready for issues to load.<\/p>\n Additionally, we noticed that exports are restricted to 1,000 rows. With the API, we are able to request up to 5,000 rows, a rise of 400%!<\/strong><\/p>\n So let\u2019s hook in, make our request, and get again a extra strong and significant knowledge set.<\/p>\n Log in to the applicable GSC account on this web page (higher proper nook). For occasion, if my web site is instance.com and I can view that Search Console account below admin@electronic mail.com, that\u2019s the account I\u2019ll signal into.<\/p>\n Enter the URL of the applicable GSC account:<\/p>\n Set up your request:<\/p>\n The web page shared in the first step makes all of this setup fairly simple, however it may be tedious and even complicated for some. I\u2019ve executed all the fussing for you and have created JSON you possibly can edit rapidly and simply to get the API return you\u2019d like.<\/p>\n The following request can be unfiltered. We\u2019ll set our most popular dates, dimensions, and a row restrict, after which make our request. <\/p>\n The order by which you place your dimensions is the order by which they\u2019ll be returned.<\/p>\n The API will return knowledge for desktop, cell, and pill, separated out. The numbers you see in the GSC person interface \u2014 clicks, as an illustration \u2014 are an mixture of all three (until you apply system filtering).<\/p>\n Remember, your dimensions also can embody \u201ccountry\u201d should you\u2019d like.<\/p>\n<\/p>\n This model of our request will embody filters so as to be extra particular about what’s returned. <\/p>\n Filters are said as dimension\/operator\/expression. Here are some examples to present what\u2019s doable:<\/p>\n It seems like you possibly can solely apply one filter per dimension, similar to in the regular GSC person interface, but when you already know otherwise, tell us in the feedback!<\/p>\n<\/p>\n Choose a template, unfiltered or filtered, and fill in your customized values (something after a colon must be up to date as your personal worth, until you want my presets).<\/p>\n So there you may have it! Two request templates for you to select from and edit to your liking. Now it\u2019s time to make the request. Click into the \u201cRequest body\u201d, choose all, and paste in your customized JSON:<\/p>\n This is the place you would manually arrange your request keys and values, however as I said earlier, this may be tedious and a bit complicated, so I\u2019ve executed that be just right for you.<\/p>\n Scroll down and click on \u201cExecute.\u201d You could also be prompted to sign-in right here as nicely.<\/p>\n If the whole lot was entered accurately and the request could possibly be happy, the API will return your knowledge. If you get an error, audit your request first, then some other steps and inputs if mandatory.<\/p>\n Click into the field in the decrease proper (that is the response from the API), choose all, and replica the info.<\/p>\n Excel or Sheets can be a significantly better method to work with the knowledge, so let\u2019s convert our JSON output to CSV. <\/p>\n Use a converter like this one and paste in your JSON output. You can now export a CSV. Update your column headers as desired.<\/p>\n Most SEOs are fairly comfy in Excel, so now you can question your request output any method you\u2019d like.<\/p>\n One of the most typical duties carried out is searching for knowledge related to a particular set of pages. This is completed by including a sheet along with your web page set and utilizing VLOOKUP to point out a match.<\/p>\n The API output being in a spreadsheet additionally permits for the most typical actions in Excel like sorting, filtering, and chart creation.<\/p>\n GSC presents necessary knowledge for SEOs, and the GSC API output presents not solely extra of that knowledge, however in a format that’s far much less cumbersome and extra cohesive.<\/p>\n Today, we overcame two obstacles we frequently face in the customary GSC person interface: the question\/web page connection and restricted exports. My hope is that using the Google Search Console API will take your analyses and insights to the subsequent degree.<\/p>\n While my JSON templates will cowl the most typical situations when it comes to what you\u2019ll be all in favour of requesting, Google does provide documentation that covers a bit extra floor should you\u2019re .<\/p>\n Do you may have one other method of utilizing the GSC API? Is there one other API you generally use as an web optimization? Let me know in the feedback!<\/p>\n<\/p><\/div>\n If you\u2019ve been an web optimization for even a short while, you\u2019re possible acquainted with Google Search Console (GSC). It\u2019s a helpful device for getting details about your web site and its efficiency in natural […]<\/a><\/p>\n<\/div>","protected":false},"author":4,"featured_media":5822,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3],"_links":{"self":[{"href":"https:\/\/internetmarketingoasis.com\/blog\/wp-json\/wp\/v2\/posts\/5820"}],"collection":[{"href":"https:\/\/internetmarketingoasis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/internetmarketingoasis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/internetmarketingoasis.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/internetmarketingoasis.com\/blog\/wp-json\/wp\/v2\/comments?post=5820"}],"version-history":[{"count":0,"href":"https:\/\/internetmarketingoasis.com\/blog\/wp-json\/wp\/v2\/posts\/5820\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/internetmarketingoasis.com\/blog\/wp-json\/wp\/v2\/media\/5822"}],"wp:attachment":[{"href":"https:\/\/internetmarketingoasis.com\/blog\/wp-json\/wp\/v2\/media?parent=5820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/internetmarketingoasis.com\/blog\/wp-json\/wp\/v2\/categories?post=5820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/internetmarketingoasis.com\/blog\/wp-json\/wp\/v2\/tags?post=5820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![](\"http:\/\/d2v4zi8pl64nxt.cloudfront.net\/how-to-query-google-search-console-api\/5e67fc74e45c60.51176881.png\")
<\/figure>\n![](\"http:\/\/d2v4zi8pl64nxt.cloudfront.net\/how-to-query-google-search-console-api\/5e67fc75a479e6.67960279.png\")
<\/figure>\n\n
What is the Google Search Console API?<\/h2>\n
Why use it?<\/h2>\n
Setup<\/h2>\n
![](\"http:\/\/d2v4zi8pl64nxt.cloudfront.net\/how-to-query-google-search-console-api\/5e67ff3f7a8dc6.37404526.png\")
<\/figure>\n\n
\n
\n
Unfiltered request<\/h3>\n
Filtered request<\/h3>\n
\n
Execute the request<\/h2>\n
![](\"http:\/\/d2v4zi8pl64nxt.cloudfront.net\/how-to-query-google-search-console-api\/5e67fc77149138.19607519.png\")
<\/figure>\n![](\"http:\/\/d2v4zi8pl64nxt.cloudfront.net\/how-to-query-google-search-console-api\/5e67fc77c59f00.94036289.png\")
<\/figure>\nConvert from JSON to CSV<\/h2>\n
Query your personal knowledge<\/h2>\n
Get extra out of Google Search Console<\/h2>\n
\n
Source hyperlink Internet Marketing<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"