Here’s what I’m seeing: if I go to “Visitors–>Locations & Provider” and view City data, city visits are not consolidated in the list of cities.
For example, I might see this:
Chicago, Illinois, United States: 53
Chicago, Illinois, United States: 42
Minneapolis, Minnesota, United States: 37
Chicago, Illinois, United States: 34
And so on.
This is only an issue with the City data. The State data does consolidate by state. So taking my above example and viewing by State, I would see:
Illinois, United States: 129
Minnesota, United States: 37
Yes, I noticed this today after installing GeoIP. I executed the geoipUpdateRows.php and deleted the piwik_archive_* tables to re-process the data. I see the same bug as rstein.
Sorry I misread the bug description! Can you please post a screenshot of this bug and explain if you have used the script import or only the standard javascript tag? any other special things that apply to your piwik?
The screenshot looks basically like rstein’s example.
The things I found out after taking some time to try and find the source of the bug (ultimately unsuccessful):
(after turning on sql debugging) There is an SQL statement executed that does result in unique locations (it does a proper ‘GROUP BY country, region, city’) but i’m not sure where the results are used because the debug output does not have a backtrace for each query
From what I can tell, it seems that each duplicate city has slightly different latitudes and/or longitudes
EDIT: these entries are not from apache log (etc) imports, but from the javascript client
Same issue here; and I did the same process as mscdex ( executed the geoipUpdateRows.php and deleted the piwik_archive_* tables to re-process the data ).
Just thinking aloud, I’m wondering if maybe it might be due to visitors from a given city coming through different Internet providers. Just more mud against the wall.
Whatever is causing it, would be far more useful if the data was consolidated.
And yes, for the regions (state) widget, it appears to be working fine.
File attached. As you will notice, there are multiple entries for Minneapolis and Saint Paul (and others).
Also, please notice the ‘Unknowns’ count. What can be done to dig into that group and parse for more accuracy???
Could it have to do with visitor privacy settings?
We do not include the last octet of the visitor’s IP address in the logs.
What are the rest of you collecting?
Maybe I spoke too early on this one… I’m just starting to try out the API and it’s giving me duplicated cities in the output when I have “idSite=all”. :S
Web Interface
(I’m not familiar with the direct access via API. Please point me to instructions for that.)
Please see my other thread at: 301 Moved Permanently.
In case it is related.
We need YOUR help! We are running a crowd funding campaign to raise funds to implement the detailed Visitors Maps of Countries, Regions and Cities (for all countries)!
These maps will be beautiful, usable, and built using open standards SVG+JS. They will show detailed visitor count, conversion rates, by Country but also (New!) by city and region.
We need YOUR help! We are running a crowd funding campaign to raise funds to implement the detailed Visitors Maps of Countries, Regions and Cities (for all countries)!
These maps will be beautiful, usable, and built using open standards SVG+JS. They will show detailed visitor count, conversion rates, by Country but also (New!) by city and region.
