Page MenuHomePhabricator

[Spike] Identify countries of contributions based on IP
Closed, ResolvedPublicSpike

Description

Background

Bigger picture: https://phabricator.wikimedia.org/T372357

Task

The output of this task should be an artifact (for example, spreadsheet, JSON, API call) that present info in the following format:
Wikibase domain - ISO country code - number of contributions in this instance coming from this country

Only non-deleted Wikibase instances are included.
Only countries that have at least 1 contribution in this instance are included.

Implementation Details

IPs are stored stored in _recentchanges.rc_ip table
It is up to the engineering team to choose an external service to identify countries based on IP, but we should probably re-use the approach already used for IP info:

Event Timeline

Restricted Application added a subscriber: Aklapper. ยท View Herald TranscriptAug 12 2024, 10:07 AM
Anton.Kokh renamed this task from [Technical Spike] Identify countries of contributions based on IP to [Spike] Identify countries of contributions based on IP.Aug 12 2024, 9:30 PM
Anton.Kokh updated the task description. (Show Details)
Anton.Kokh changed the subtype of this task from "Task" to "Spike".
Anton.Kokh moved this task from To do to Doing on the Wikibase Cloud (Kanban Board Q3 2024) board.

Made my own analysis using IPInfo and some ChatGPT-supported programming.

Results available here