Why are Search Console indicators inadequate and how to deal with it? How to get adequate statistics on conversions from Google?

Question

Google

When sorted by clicks, it is clear that for 3 months there were only 5 clicks in total. At the same time, the graph shows that over the past 3 months there were clearly more than 5 clicks. Why is Search Console so inaccurate and self-contradictory? And how to understand for what requests and in what quantity people actually came from Google?
According to a summary from Yandex Metrica, over the past 3 months, 97 people have come to the site from the Google search engine, but unfortunately Google search queries are not displayed in Yandex Metrica .. and they are incorrectly displayed in the console - well, how do you collect statistics on clicks from Google ...?