Great point @Brian.Wheeldon !
Assuming event retention is taken into consideration you might try an ADQL query like below @Anonymous
SELECT appkey, geocountry AS "GEO", count(*) AS "CT" FROM browser_records WHERE geocountry != "United States" ORDER BY appkey DESC, GEO DESC, CT DESC LIMIT 1000, 1000, 1000
... View more
