Thanks @crokkon!

It was very manual (deep shame).

I put all the locations into a pivot table, sorted by count, and then went through the list from the top. I think the first one was Indonesia, so I searched all the other strings for Indonesia, and summed the count if there was a hit (so Berlin, Germany would be a hit for Germany for example).

And then I went down the list, making sure not to double count, and grouping cities into the right country etc (i.e. Berlin by itself in with Germany). Very manual!

I'm not a big fan of the location analyses, just because they rely on user input, and not enough people enter the details for it to be scientific. So I didn't want to spend too long developing something more complex. But for eSteem it's one of their aims to reach developing countries so I thought it was important to see whether that was the case. There's enough data for it to be interesting and indicative but not enough to prove any firm conclusions.

I'd be interested if @good-karma and the team have better data themselves, from it being a mobile app, and whether that correlates to the data above or if it's wide of the mark.