geolocation services are tripping!

hey everyone, just launched our saas a few weeks back and we’re finally getting around to diving deep into user analytics and personalization. exciting times, mostly.

but man, we’re seeing some truly wild ip geolocation data, and it's making our localized content look like a bad joke. users are appearing in completely wrong states, sometimes even continents away! like, someone from sunny california showing up in, uh, germany. it's really messing with our ip address mapping and, consequently, our analytics and geo-targeting efforts. we wanna deliver relevant content, but if we can't even tell where they are, it's a bit of a problem, innit?

[2023-10-26 14:35:01] INFO: User IP 192.0.2.10 detected.
[2023-10-26 14:35:01] WARN: GeoIP lookup returned 'Germany' for 192.0.2.10 (expected 'USA, California').
[2023-10-26 14:35:02] INFO: Attempting secondary lookup...
[2023-10-26 14:35:03] ERROR: Secondary GeoIP lookup failed for 192.0.2.10: 'Inconsistent data across providers.'
[2023-10-26 14:35:03] INFO: User 12345 (from California) served German content.

so yeah, as you can see, our ip address mapping is, well, not mapping correctly. what are the community's best practices, tools, or strategies for significantly improving ip geolocation accuracy? how do you guys deal with the common headaches like vpn users, proxies, or just generally unreliable geolocation services? are there specific providers that are way better than others for this kind of thing?

any wisdom or tips you can share would be super helpful. thanks in advance!