25

I work for a UK-based digital-focused company.

We have a few thousand US-based users but it is by no means our primary region.

However, an excessively large amount of US traffic is supposedly coming from Coffeyville, Kansas - so much so that it is showing as the city with the most sessions worldwide.

Is there a specific reason that Coffeyville Kansas is over-represented? A cursory search suggests that Google has some history with Coffeyville (apparently it was once the default position on Google Maps API)

Is this a consequence of Google incorrectly ascertaining US users' city? Or is something more sinister at play (e.g. false referrals/spam)?


UPDATE: I've dug deeper into the problem, and tried to look into some of the suggestions made here (thanks for the suggestions so far).

It turns out the 'Coffeyville' traffic is almost entirely referred from a content network/partner which drives primarily US traffic to our site. Consequently, the traffic has almost entirely occurred since June 2017, since the partnership began.

I've brought up the issue with the aforementioned partner and will update if they have any further information.

I do not yet have access to IP server logs, but will look into this if the partner can't shed light on the issue.

4
  • Over what period of time? Chances are it's a runaway program or infected computer causing the issue and will eventually be found out and shutdown.
    – Rob
    Oct 2, 2017 at 16:30
  • It would be helpful to post some example access from your web server log files. It could be a hack attack or some other issue you want to address. Cheers!!
    – closetnoc
    Oct 2, 2017 at 22:02
  • So we are all going to ignore "The Black Mailbox" right at these mysterious 38.0000, -97.0000 coordinates ?! OK :) ![enter image description here](i.stack.imgur.com/EiEgG.jpg)
    – adrianTNT
    Jan 14, 2020 at 2:50
  • 1
    I've long since left the company I was working at when I asked this question, but it feels worthwhile to update the information here. Interestingly, it emerged that the 'content partner' we were working with was driving masses of fake botnet traffic from colocated servers to our site under the guise of it being human website traffic. The reason Coffeyville was spiking was because Google Analytics had no location information on the programmatically created 'users' on these servers, so they were defaulting to the geographical centre of the US (as one of the answers here suggests).
    – Rhys Mills
    Mar 24, 2021 at 15:46

2 Answers 2

37
+200

It appears that you are a victim of what has been called "The Kansas Problem."

According to the U.S. Geological Survey, the geographical center of the conterminous United States is: 39°50'N 98°35'W, which is northwest of Lebanon, Kansas.

enter image description here

As a result, whenever a geolocation service searches for "United States," it essentially drops a pinpoint at predefined coordinates that is considers to be the center of the contiguous United States (somewhere in Kansas) and zooms out to show the full map.

As you pointed out in your question, the default zoom position for early Google Maps and Google Maps API was what Google defined as the center of the United States, 37.0625, -95.677068, which is located in Coffeyville, Kansas.

Is the abundance of traffic coming from Coffeyville, Kansas, a consequence of Google incorrectly ascertaining US users' city?

Not Exactly.

Google describes how Google Analytics determines the location of traffic sources:

Analytics provides a number of geographical dimensions, such as City, Country, Continent, etc. The values for these dimensions are automatically derived from the IP address of the hit...

Google also explains what happens if a location cannot accurately be determined:

Google Analytics uses a third-party datasource to determine your visitors' geographical locations. If our third-party vendor does not have an accurate record of the visitor location, Google Analytics displays a (not set) entry.

In other words, Google sends the IP address of the traffic source to a third-party datasource to determine location.

If the third-party source determines that it has an accurate record of the visitor location, Google Analytics will populate the fields with the location data. If the third-party source determines that the location cannot be found, the value in the corresponding fields will be: (not set).

Therefore, if Coffeyville, Kansas, is an incorrect location for your traffic sources, it appears that this would be the fault of one of the third-party datasources that Google uses, rather than Google itself.

Google does not provide which IP address geolocation database/service they use, but it appears that some of the most popular databases include:

MaxMind wrote on their website:

More than 5,000 businesses worldwide use GeoIP2 Intelligence, including the majority of the top 50 web properties (as ranked by Alexa - July 2017).

On the other hand, on April 6, 2017, Neustar wrote on their website:

Neustar, Inc. (NYSE: NSR), a trusted, neutral provider of real-time information services, today announced a new advanced marketing analytics partnership with Google.

This means that Google could very well be partnered (at least in part) with MaxMind and/or Neustar for Google Analytics IP address geolocation data.

MaxMind has had issues in the past regarding their default coordinates they had set up for the geographic center of the United States, which used to be 38.0000, -97.0000.

This is located in Potwin, Kansas (only about 100 miles away from Coffeyville, Kansas), and this location was pointed to when an unknown location inside the U.S. presented itself.

enter image description here

Image Source: https://techviral.net/600-million-ip-addresses-are-linked-to-this-house/

Consider the following SQL query:

SELECT
    *
FROM
    database.maxmind_geoip
WHERE
    location_id = 12345

MaxMind might yield something like the following result:

+-------------+---------+--------+------+-------------+----------+-----------+----------+-----------+
| location_id | country | region | city | postal_code | latitude | longitude | dma_code | area_code |
+-------------+---------+--------+------+-------------+----------+-----------+----------+-----------+
|       12345 | US      |        |      |             |       38 |       -97 |          |           |
+-------------+---------+--------+------+-------------+----------+-----------+----------+-----------+

Source: http://p5k6.github.io/blog/2014/08/09/understanding-your-geoip-data/

According to an article on Splinter, on April 12, 2016, MaxMind has changed this location, after being sued by angry property owners, to the middle of Cheney Reservoir, Kansas. This is located slightly further: about 130 miles away from Coffeyville, Kansas.

Conclusion:

I believe that, based on the above evidence, one of Google's third-party IP address geolocation datasources is not accurately detecting the specific location of certain IP addresses, while still determining that the IP address is within the United States.

Instead of responding with a 'not found' response, the source is relaying an improper result denoting the 'center coordinates' of the United States (Coffeyville, Kansas) to Google Analytics.

5
  • 2
    Superb answer and sourcing, it's not often I learn something new from answers these days like I did from this. Good job.
    – dan
    Apr 7, 2018 at 6:30
  • 1
    It may be worth noting that this seems to happen with the IP address for Google's crawler bot: whatismyipaddress.com/ip/66.249.79.135 Dec 2, 2018 at 19:45
  • 2
    The person leaving at that house can do literally anything online :) no way to pin-point him as being the IP that did something.
    – adrianTNT
    Jan 14, 2020 at 2:52
  • "Google does not provide which IP address geolocation database/service they use" IP addresses are personally identifiable information, and according to GDPR, they need to disclose with which subcontractors they share this data. So someone who uses Google Analytics in the EU (I don't) just needs to check their "data processing agreement".
    – Heinzi
    Mar 25, 2021 at 9:55
  • Is there not an "accuracy radius" or similar column in the data? That's a really important piece of information. The data is totally worthless without it. I get one if I look up my IP here: maxmind.com/en/locate-my-ip-address.
    – rjmunro
    Apr 21, 2021 at 8:50
2

Take a look at your server logs and see if you can find an IP address (or small range) that are sending a lot of hits your way. Try looking up the IPs in an online tool like ip-lookup.net which will give you a location and a domain or ISP the IP is associated with.

In your server logs the lines with those IPs should have a user-agent string (browser name). That may give you a clue what's happening, if for example it says "Googlebot". If not then try searching the IPs in Google itself to see if they belong to a well-known company.

Not the answer you're looking for? Browse other questions tagged or ask your own question.