I'm using http://ip-api.com/csv/ in a Google worksheet formula to pull up geolocation data about IP addresses listed in the Activity Log. The result includes a bunch of info about the IP address (e.g., country, city, state, zip code, longitude and latitude, etc.), though the city/state is usually enough. I've compared the results of ip-api.com to other sites that show geolocation info about an IP and it seems to be accurate.
Upon looking at a recent Activity Report for all of 2017 I see that one PC appears in the report as being frequently accessed from a few local IP addresses, when in reality the user of that PC rarely if ever uses GoToMyPC while in town. Yet the IP address for this user's second home in a distant city appears in the report only 4 times in all of 2017, even though he uses GotomyPC extensively while there.
I figured that if Google uses IP Location as a means of detecting "unauthorized activity" IP geolocation must have some validity, but the geolocation results for this particular PC are the opposite of what I would expect.
How reliable is the "Client IP" shown in the Access Activity report? (note that the aforementioned user runs GotomyPC on a desktop PC in his second home, connected to the Internet via Time Warner Cable, so we're not dealing with cell phone or tablet access.)
How reliable is geolocation information one can get about an IP address?