Why you should never trust Search Console data (Part 2)

In a previous post, I’ve worked on Search Console data regarding accuracy. However, this has been done on a brand new site – meaning with few traffic. This time, I’m going to do the same thing, but on a website with more traffic: 450 sessions/day. And it’s a not a brand new one as well.

Analysis Environment

Like the previous post, here is the situation:

  • period : from 7th of August to 13th of August 2017
  • Search Console and Google Analytics are set up on the website
  • I’ve used R.studio and the searchConsoleR library, to extract data from Search Console API.

Data in Google Search Console

search console site moyen

Here, the total number of clicks is 1571. However, when I sum all the clicks in the table, my total is 869. In order to do things right and to check, I’ve extracted these same data day by day. I’ve summed them and my total is still 869 (yeah !).

Data in the Search Console API

As in the part 1, I’ve extracted the data day by day, keyword by keyword.

api search console

My total number of clicks here is 970. It’s quite far away from the 1571 but quite close from the detail by keywords, given in the Search console interface.

Data in Google Analytics

Here is the screenshot, I’ve taken in Google Analytics: channel organic and split by date.

ga search console

1697 sessions. Close to the 1571 clicks. Let’s keep in mind we’re not taking about the same metric (session in GA and click in Search Console). But the values can be close. Nevertheless, we’re far away from the value at the keywords level.

In a nutshell

As seen previously, the trends are the same:

  • The data you’ve got in the API and in the interface stay close (keywords level). But in that case, the API has given more data. It was not the case with the smaller site.
  • These keywords data are far away from the total number of clicks given by Search Console and organic sessions in Google Analytics.
  • The good news is Google gave 61% of the the keywords. It’s much better than the 10%. Is it because the website gets more traffic (so more data) ?
  • A test on a even bigger website will confirm these thoughts.

You will like as well:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.