Content Marketing

How best to use APIs

We should be working smarter, not harder. If you want to get into technical SEO and data to gain actionable business insights, the gateway…
blank
blank

How best to use APIs

No Comments
We should be working smarter, not harder. If you want to get into technical SEO and data to gain actionable business insights, the gateway drug is the Google Search Console…
blank

How best to use APIs

We should be working smarter, not harder. If you want to get into technical SEO and data to gain actionable business insights, the gateway drug is the Google Search Console…
blank

Tea Time SEO – Website Migrations

Tea Time is back! Get your favourite brew and snack ready for our first Tea Time SEO episode in 2021. If you’re looking forward to joining us in March, why…

How best to use APIs

We should be working smarter, not harder. If you want to get into technical SEO and data to gain actionable business insights, the gateway drug is the Google Search Console…
blank

Tea Time SEO – Website Migrations

Tea Time is back! Get your favourite brew and snack ready for our first Tea Time SEO episode in 2021. If you’re looking forward to joining us in March, why…
blank

How best to use APIs

Content Marketing
0
blank
We should be working smarter, not harder. If you want to get into technical SEO and data to gain actionable business insights, the gateway drug is the Google Search Console API. The great thing about the Search Console API is that it gives you a lot more granular information than…

Tea Time SEO – Website Migrations

Content Marketing
0
blank
Tea Time is back! Get your favourite brew and snack ready for our first Tea Time SEO episode in 2021. If you’re looking forward to joining us in March, why not bake yourself a snack to share with us on Twitter? We have three great speakers, Ben Beckwith, James Bavington…

How best to use APIs

We should be working smarter, not harder. If you want to get into technical SEO and data to gain actionable business insights, the gateway drug is the Google Search Console API. The great thing about the Search Console API is that it gives you a lot more granular information than you’d get through the interface. For example, if you use the Search Console interface, you can only get 1000 rows worth of data, whereas the API will give you 5000 rows. 

The API lets you combine different metrics and segments; this helps to answer more complicated questions. So for example, you can find out page-level keyword rankings, along with clicks/impressions per keyword, per page. That is useful, and you can’t do it through the interface. To experiment with the Search Console API, but not necessarily be a coder, the place to start is the API Explorer that Google provides. It’s available at developers.google.com, and it lets you access your search console data through an API key, but you don’t have to write code to do it. 

You can construct a query, send it to the API, get the information back and do it all in a browser. Now, once you do that, what will happen is you’ll get a response which is a JSON object. JSON, when you first look at it is kind of scary, but it isn’t really. It is just a concise way for computers to communicate with each other efficiently. Many APIs respond with JSON, and it is relatively ubiquitous. You can make a JSON object more human-readable with a variety of tools. The tool I recommend is called konklone.io, and you can paste your JSON data into it, and it will convert it to a CSV, which can be ready by Excel. You can then parse the data however you need to, to gain insight.

If you don’t want to experiment with the API and you want a solution that works, an excellent plug-in for Google Sheets is the Search Analytics plug-in. This plug-in will just let you put your Search Console log-in details in and let you construct a query and set it all up as a timed task. The Google Sheet is then populated periodically depending upon the query you’ve set up. You can use it to do an analysis or back up your Search Console data.

All of this is easy to do, and you can get some interesting insights from the data. An example of something you can do if you categorise your content is to highlight which parts of your site get the highest click-through-rate. Something else you can do is to work out the average click-through-rate by position for your site content and build a custom click-through-rate curve for your site. That would be useful for forecasting and making predictions about future performance.

Combine Google Search Console data with another source of data like whether the search engine positions are visible above the fold or the type of results shown (e.g. maps, rich snippet result, local pack etc.) you can get useful insight. All of that information (and a lot more besides) is available from the Authoritas API.

Also, if you want to experiment with this type of thing without having to code a solution, you could use Screaming Frog to access other APIs. Screaming Frog is useful because it offers access to several different APIs, including:

  • Google Analytics, 
  • Google Search Console, 
  • Google PageSpeed Insights
  • MOZ
  • Ahrefs
  • Majestic SEO 

Some of these APIs are not free, requiring at least an API to access them. The good thing about Screaming Frog is that once you’ve got a list of URLs that you’re interested in, you can put them into Screaming Frog via list mode and then pull all the data on a page-by-page level. That type of data is beneficial for answering interesting questions. You can even use the data you get to build a custom data set to answer questions. 

For example, at Purplex Marketing, we are always trying to answer questions in a data-led way. Using this approach, we’ve built our a custom dataset using six months worth of data to try and answer questions like:

  • Does word count have an impact on rankings?
  • Has Core Web Vitals started to affect rankings?
  • What page speed factors are the most beneficial for ranking well?
  • Is <title> length a factor in ranking?

Trying to work out if there is a correlation between these things and position is interesting, but complicated mathematically. So this is something we are building up over time, and we are hoping to build a mathematical model to try and answer all of these questions. That will allow us to get into the nuts-and-bolts of this and is super interesting. Mathematical models are an advanced topic, but it is the type of places you can end up on the slippery slopes of accessing APIs. It all starts with a straightforward web request, and if you get hooked, that is it. Good luck!

Thank you Sandy Lee for all of your great tips on how to best use APIs! You can watch the full Tea Time SEO talk here:



 

Featured image by Lars Kienle on Unsplash

Tea Time SEO – Website Migrations

Tea Time is back! Get your favourite brew and snack ready for our first Tea Time SEO episode in 2021. If you’re looking forward to joining us in March, why not bake yourself a snack to share with us on Twitter? We have three great speakers, Ben Beckwith, James Bavington and Sarah Moccand-Sayegh who will be covering all of key areas of website migrations.

blank

Ben Beckwith joined Semetrical back in 2014 as one of the first employees and has since grown with the company where he is now Head of SEO. He has developed an award-winning department of SEO specialists at Semetrical and is passionate about all things SEO. Ben is an experienced SEO strategist, having a strong focus on technical SEO, website migrations, and user intent, implementing successful campaigns for clients such as OnTheMarket, Beano, JPI Media and Lexis Nexis. To keep Ben busy over the pandemic, he bought his first house and completely renovated it just in time for him and his wife who are expecting their first child in early May.

James Bavington is Technical Director at full-service agency StrategiQ who are based in both Warwickshire and Suffolk UK. James started his career in 2006 as a designer and front-end developer, gaining an affinity for SEO and Ecommerce prior to joining StrategiQ in 2015 to own the cohesion between the development and marketing teams. Remaining hands-on with clients of all shapes and sizes, James has worked with brands ranging from The Dorchester and Reuters to local businesses and charities including The Air Ambulance Service. Over the course of the pandemic James has stayed sane WFH by setting up a desk surrounded by Lego and taking up mountain biking.

Sara Moccand-Sayegh is an SEO specialist at Liip, a web & mobile development agency and Holacracy in Switzerland. She is the co-host of #SEOnerdSwitzerland Meetup and a big fan of taking technical classes but skipping the theory. Sara is also a mum of two, who often manage to show up on screen while she works and last month she gave in & subscribed to Nextflix, causing a drop in her night productivity.

Tune in to Tea Time SEO at 4pm on Thursday here on YouTube. If you want to be part of our mailing list and never miss a Tea Time again, sign up here:


    Photo Credit: Soyoung Han on Unsplash

    blank

    How best to use APIs

    0
    We should be working smarter, not harder. If you want to get into technical SEO and data to gain actionable…
    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank

    Great British Chefs

    blank

    Premier Inn

    blank

    JD Sports

    blank
    Great British Chefs
    blank
    Premier Inn
    blank
    JD Sports

    “Console Rocket astonished me with the level of data and insights it made easily available. Like most, I understand the importance of Google search console data, but taking the limits off in this way is truly game changing for SEOs.”

    blank

    Andy Gray

    SEO & Content Marketing Manager

    “We utilise Authoritas to help deliver the highest quality to our clients. I’m thrilled to see the incredible steps they’ve taken with their new user interface and look forward to continuing our strong partnership.”

     

    Nathan Barling

    Dentsu Aegis

    “More than happy with the service, and more than happy to get our clients to use it. Had some brilliant results using the FAQ Explorer and today I am yet again, using Visibility Explorer for another sales opportunity. Simply cannot live without the tools you provide.”

    Grant Whiteside

    Grant Whiteside

    Director

    “Console Rocket astonished me with the level of data and insights it made easily available. Like most, I understand the importance of Google search console data, but taking the limits off in this way is truly game changing for SEOs.”

    blank

    Andy Gray

    SEO & Content Marketing Manager

    “We utilise Authoritas to help deliver the highest quality to our clients. I’m thrilled to see the incredible steps they’ve taken with their new user interface and look forward to continuing our strong partnership.”

     

    Nathan Barling

    Dentsu Aegis

    “More than happy with the service, and more than happy to get our clients to use it. Had some brilliant results using the FAQ Explorer and today I am yet again, using Visibility Explorer for another sales opportunity. Simply cannot live without the tools you provide.”

    Grant Whiteside

    Grant Whiteside

    Director

    “Console Rocket astonished me with the level of data and insights it made easily available. Like most, I understand the importance of Google search console data, but taking the limits off in this way is truly game changing for SEOs.”

    blank

    Andy Gray

    SEO & Content Marketing Manager

    “We utilise Authoritas to help deliver the highest quality to our clients. I’m thrilled to see the incredible steps they’ve taken with their new user interface and look forward to continuing our strong partnership.”

     

    Nathan Barling

    Dentsu Aegis

    “More than happy with the service, and more than happy to get our clients to use it. Had some brilliant results using the FAQ Explorer and today I am yet again, using Visibility Explorer for another sales opportunity. Simply cannot live without the tools you provide.”

    Grant Whiteside

    Grant Whiteside

    Director

    blank

    “Console Rocket astonished me with the level of data and insights it made easily available. Like most, I understand the importance of Google search console data, but taking the limits off in this way is truly game changing for SEOs.”

    Andy Gray

    SEO & Content Marketing Manager

    blank

    “We utilise Authoritas to help deliver the highest quality to our clients. I’m thrilled to see the incredible steps they’ve taken with their new user interface and look forward to continuing our strong partnership.”

     

    Nathan Barling

    Dentsu Aegis

    Grant Whiteside

    “More than happy with the service, and more than happy to get our clients to use it. Had some brilliant results using the FAQ Explorer and today I am yet again, using Visibility Explorer for another sales opportunity. Simply cannot live without the tools you provide.”

    Grant Whiteside

    Director

    “Console Rocket astonished me with the level of data and insights it made easily available. Like most, I understand the importance of Google search console data, but taking the limits off in this way is truly game changing for SEOs.”

    blank

    Andy Gray

    SEO & Content Marketing Manager

    “We utilise Authoritas to help deliver the highest quality to our clients. I’m thrilled to see the incredible steps they’ve taken with their new user interface and look forward to continuing our strong partnership.”

     

    Nathan Barling

    Dentsu Aegis

    “More than happy with the service, and more than happy to get our clients to use it. Had some brilliant results using the FAQ Explorer and today I am yet again, using Visibility Explorer for another sales opportunity. Simply cannot live without the tools you provide.”

    Grant Whiteside

    Grant Whiteside

    Director

    “Console Rocket astonished me with the level of data and insights it made easily available. Like most, I understand the importance of Google search console data, but taking the limits off in this way is truly game changing for SEOs.”

    blank

    Andy Gray

    SEO & Content Marketing Manager

    “We utilise Authoritas to help deliver the highest quality to our clients. I’m thrilled to see the incredible steps they’ve taken with their new user interface and look forward to continuing our strong partnership.”

     

    Nathan Barling

    Dentsu Aegis

    “More than happy with the service, and more than happy to get our clients to use it. Had some brilliant results using the FAQ Explorer and today I am yet again, using Visibility Explorer for another sales opportunity. Simply cannot live without the tools you provide.”

    Grant Whiteside

    Grant Whiteside

    Director

    Menu