One SEO professional asked John Mueller during his Question and Answer segment in a hangout about Google Search Console data.
They were concerned about the difference in data between the Search Console interface and data retrieved from the API.
Their main question is: is it the case that the API data should be considered more reliable?
John answered that – just as an answer, he specified – the API and the data that the user interface is built from use the exact same data and database tables.
It’s not that there’s anything more in-depth or reliable about the URL that’s in the API.
Sometimes that is useful to get more rows of examples via the API than you can when you download things via the interface.
Sometimes this is useful, especially if you have more detailed information.
John also explained that the other thing that’s a bit more confusing with the API and the data in Search Console is that, when you’re looking at a report in Search Console, you will see numbers on top that give you so many impressions or so many clicks overall.
The data that they provide in the API is the individual rows that are kind of visible in the table below the overall data in Search Console.
For privacy, and many other reasons, they filter out queries that have very few impressions.
In the UI in Search Console, on top with a number will include the aggregate full count, but the rows that are shown there don’t include the filtered information.
So as a result of this, what can happen is that if you look at the overall total in Search Console, it will be a different number than if you take the totals from API.
This happens at approximately the 34:14 mark in the video.