All

Writing data

Docs
- Inserting data [general]
- Opentracker Implementation

Reading data

Visits
- classic
- Next generation
Trends
- trends
- hourly trends
- pages
- summary
Top lists
- pages
- paths
- referrers
- search engines
- search terms
- entry pages
- exit pages
- exit links
- properties
Technical data
Geo-location data
Management

Geo location - Country / Region / City

Display list of countries, regions and cities where your visitors come from.

API Usage

This API produces a json array.

Parameters

One or more of the following parameters are required:

date Calculate the top countries, regions or cities from the specified date entered as yyyy-MM-dd. Default is the current date.
unixTime Calculate the top countries, regions or cities from the specified unix timestamp. Default is the current unix timestamp.
period Specify the period:

d for days, eg: period=14d will show 14rows with daily trends, period=d defaults to 1 day
w for weeks, eg: period=12w will show 12 rows with weekly trends, period=w defaults to 1 week
m for months, eg: period=4m will show 4 rows with monthly trends, period=m defaults to 1 month

timeZone Calculate the top countries, regions or cities for the specified timezone. Default is site's defined timezone.
detailLevel Display data for the specified type of detail level. The values can be [country]|region|city.
countryCode Calculate the top regions or cities for the specified country code. You can get a list of country codes recorded, by calling a api call without providing any filters. See the examples section below. A list is also provided here.
regionCode Calculate the top cities for the specified region code. Note : top cities are calculated when both, country code and region code are specified. You can get a list of region codes recorded by specifying a country code you are interested in. See the examples section below. A list is also provided here.

Optional parameters:

login Your opentracker login email. Default is [demo@opentracker.net].
password Your password.
ticketId A ticketId can be used to provide credentials with an expiring token. A ticketId can be used instead of a login/ password combination. Further information can be found here.
segment This is the property field based on which you want to segment the data. By default there are no segments. You can find more information here.
filter You can choose to see no segments [none] (default), see all segments showAllSorts, or by specifying the name of the segment.
site The site for which to display data. Default is [www.opentracker.net].
locale The locale parameter is an identifier for a particular combination of language and region (e.g. en_US) and determines the format of the data returned. A list of locales can be found here.
ignoreLocale Display columns without language translation [false]|true.
dataType The dataType parameter determines the format of the data returned. Values can be [ json ] | html | jsondatatable | jsonjqgrid | csv | png

Examples

Display a top regions list of US for the website www.opentracker.net from 2024-04-26 and three weeks back display:
HTTP GET/ POST:/api/location/top_country_region_city.jsp?date=2024-04-26&login=demo@opentracker.net&password=demo123&site=www.opentracker.net&period=3w&dataType=html&detailLevel=region&countryCode=US
Display a top cities list in the California region (regionCode: CA) from the country United States (countryCode: US) for the website www.opentracker.net for 2024-04-26:
HTTP GET/ POST:/api/location/top_country_region_city.jsp?date=2024-04-26&detailLevel=city&countryCode=US®ionCode=CA&period=1d
Display a top countries list for the website www.opentracker.net for the user "demo@opentracker.net" with password "demo123":
HTTP GET/ POST:/api/location/top_country_region_city.jsp?period=1d&login=demo@opentracker.net&password=demo123&site=www.opentracker.net

Response

This last example returns a json array with 'n' entries starting from the specified period formatted as:

{ "resultsList": [
{
"No.":"1",
"flag":"",
"country / region / city":"United States",
"code":"US",
"users":"329",
"graph":"||||||||||||||||||||",
"percentage":"31.1%",
"sessions":"349"}
,
{
"No.":"2",
"flag":"",
"country / region / city":"India",
"code":"IN",
"users":"153",
"graph":"|||||||||",
"percentage":"14.5%",
"sessions":"180"}
,
{
"No.":"3",
"flag":"",
"country / region / city":"Philippines",
"code":"PH",
"users":"67",
"graph":"||||",
"percentage":"6.3%",
"sessions":"93"}
,
{
"No.":"4",
"flag":"",
"country / region / city":"Canada",
"code":"CA",
"users":"50",
"graph":"|||",
"percentage":"4.7%",
"sessions":"55"}
,
{
"No.":"5",
"flag":"",
"country / region / city":"Indonesia",
"code":"ID",
"users":"49",
"graph":"|||",
"percentage":"4.6%",
"sessions":"50"}
,
{
"No.":"6",
"flag":"",
"country / region / city":"Australia",
"code":"AU",
"users":"30",
"graph":"||",
"percentage":"2.8%",
"sessions":"32"}
,
{
"No.":"7",
"flag":"",
"country / region / city":"United Kingdom",
"code":"GB",
"users":"28",
"graph":"||",
"percentage":"2.6%",
"sessions":"28"}
,
{
"No.":"8",
"flag":"",
"country / region / city":"Germany",
"code":"DE",
"users":"22",
"graph":"|",
"percentage":"2.1%",
"sessions":"22"}
,
{
"No.":"9",
"flag":"",
"country / region / city":"Malaysia",
"code":"MY",
"users":"21",
"graph":"|",
"percentage":"2.0%",
"sessions":"24"}
,
{
"No.":"10",
"flag":"",
"country / region / city":"France",
"code":"FR",
"users":"15",
"graph":"|",
"percentage":"1.4%",
"sessions":"15"}
,
{
"No.":"11",
"flag":"",
"country / region / city":"Nigeria",
"code":"NG",
"users":"14",
"graph":"|",
"percentage":"1.3%",
"sessions":"16"}
,
{
"No.":"12",
"flag":"",
"country / region / city":"United Arab Emirates",
"code":"AE",
"users":"14",
"graph":"|",
"percentage":"1.3%",
"sessions":"16"}
,
{
"No.":"13",
"flag":"",
"country / region / city":"Cambodia",
"code":"KH",
"users":"13",
"graph":"|",
"percentage":"1.2%",
"sessions":"16"}
,
{
"No.":"14",
"flag":"",
"country / region / city":"Pakistan",
"code":"PK",
"users":"13",
"graph":"|",
"percentage":"1.2%",
"sessions":"13"}
,
{
"No.":"15",
"flag":"",
"country / region / city":"Netherlands",
"code":"NL",
"users":"12",
"graph":"|",
"percentage":"1.1%",
"sessions":"13"}
,
{
"No.":"16",
"flag":"",
"country / region / city":"Sweden",
"code":"SE",
"users":"11",
"graph":"|",
"percentage":"1.0%",
"sessions":"11"}
,
{
"No.":"17",
"flag":"",
"country / region / city":"Nepal",
"code":"NP",
"users":"10",
"graph":"|",
"percentage":"0.9%",
"sessions":"10"}
,
{
"No.":"18",
"flag":"",
"country / region / city":"South Africa",
"code":"ZA",
"users":"10",
"graph":"|",
"percentage":"0.9%",
"sessions":"10"}
,
{
"No.":"19",
"flag":"",
"country / region / city":"Italy",
"code":"IT",
"users":"10",
"graph":"|",
"percentage":"0.9%",
"sessions":"11"}
,
{
"No.":"20",
"flag":"",
"country / region / city":"Russian Federation",
"code":"RU",
"users":"9",
"graph":"|",
"percentage":"0.9%",
"sessions":"9"}
,
{
"No.":"21",
"flag":"",
"country / region / city":"Czech Republic",
"code":"CZ",
"users":"9",
"graph":"|",
"percentage":"0.9%",
"sessions":"12"}
,
{
"No.":"22",
"flag":"",
"country / region / city":"Egypt",
"code":"EG",
"users":"8",
"graph":"|",
"percentage":"0.8%",
"sessions":"8"}
,
{
"No.":"23",
"flag":"",
"country / region / city":"Turkey",
"code":"TR",
"users":"7",
"graph":"|",
"percentage":"0.7%",
"sessions":"7"}
,
{
"No.":"24",
"flag":"",
"country / region / city":"Saudi Arabia",
"code":"SA",
"users":"7",
"graph":"|",
"percentage":"0.7%",
"sessions":"7"}
,
{
"No.":"25",
"flag":"",
"country / region / city":"Poland",
"code":"PL",
"users":"7",
"graph":"|",
"percentage":"0.7%",
"sessions":"8"}
,
{
"No.":"26",
"flag":"",
"country / region / city":"Bangladesh",
"code":"BD",
"users":"7",
"graph":"|",
"percentage":"0.7%",
"sessions":"8"}
,
{
"No.":"27",
"flag":"",
"country / region / city":"Mexico",
"code":"MX",
"users":"7",
"graph":"|",
"percentage":"0.7%",
"sessions":"7"}
,
{
"No.":"28",
"flag":"",
"country / region / city":"Thailand",
"code":"TH",
"users":"6",
"graph":"|",
"percentage":"0.6%",
"sessions":"6"}
,
{
"No.":"29",
"flag":"",
"country / region / city":"Brazil",
"code":"BR",
"users":"5",
"graph":"|",
"percentage":"0.5%",
"sessions":"5"}
,
{
"No.":"30",
"flag":"",
"country / region / city":"New Zealand",
"code":"NZ",
"users":"5",
"graph":"|",
"percentage":"0.5%",
"sessions":"5"}
,
{
"No.":"31",
"flag":"",
"country / region / city":"Singapore",
"code":"SG",
"users":"5",
"graph":"|",
"percentage":"0.5%",
"sessions":"5"}
,
{
"No.":"32",
"flag":"",
"country / region / city":"Jordan",
"code":"JO",
"users":"5",
"graph":"|",
"percentage":"0.5%",
"sessions":"5"}
,
{
"No.":"33",
"flag":"",
"country / region / city":"Sri Lanka",
"code":"LK",
"users":"5",
"graph":"|",
"percentage":"0.5%",
"sessions":"10"}
,
{
"No.":"34",
"flag":"",
"country / region / city":"Switzerland",
"code":"CH",
"users":"5",
"graph":"|",
"percentage":"0.5%",
"sessions":"5"}
,
{
"No.":"35",
"flag":"",
"country / region / city":"South Korea",
"code":"KR",
"users":"4",
"graph":"|",
"percentage":"0.4%",
"sessions":"4"}
,
{
"No.":"36",
"flag":"",
"country / region / city":"Japan",
"code":"JP",
"users":"4",
"graph":"|",
"percentage":"0.4%",
"sessions":"4"}
,
{
"No.":"37",
"flag":"",
"country / region / city":"Serbia and Montenegro",
"code":"RS",
"users":"4",
"graph":"|",
"percentage":"0.4%",
"sessions":"4"}
,
{
"No.":"38",
"flag":"",
"country / region / city":"Myanmar",
"code":"MM",
"users":"3",
"graph":"|",
"percentage":"0.3%",
"sessions":"3"}
,
{
"No.":"39",
"flag":"",
"country / region / city":"Greece",
"code":"GR",
"users":"3",
"graph":"|",
"percentage":"0.3%",
"sessions":"3"}
,
{
"No.":"40",
"flag":"",
"country / region / city":"Algeria",
"code":"DZ",
"users":"3",
"graph":"|",
"percentage":"0.3%",
"sessions":"3"}
,
{
"No.":"41",
"flag":"",
"country / region / city":"Colombia",
"code":"CO",
"users":"3",
"graph":"|",
"percentage":"0.3%",
"sessions":"4"}
,
{
"No.":"42",
"flag":"",
"country / region / city":"Argentina",
"code":"AR",
"users":"3",
"graph":"|",
"percentage":"0.3%",
"sessions":"3"}
,
{
"No.":"43",
"flag":"",
"country / region / city":"Hungary",
"code":"HU",
"users":"3",
"graph":"|",
"percentage":"0.3%",
"sessions":"3"}
,
{
"No.":"44",
"flag":"",
"country / region / city":"Vietnam",
"code":"VN",
"users":"3",
"graph":"|",
"percentage":"0.3%",
"sessions":"3"}
,
{
"No.":"45",
"flag":"",
"country / region / city":"Romania",
"code":"RO",
"users":"3",
"graph":"|",
"percentage":"0.3%",
"sessions":"4"}
,
{
"No.":"46",
"flag":"",
"country / region / city":"Norway",
"code":"NO",
"users":"3",
"graph":"|",
"percentage":"0.3%",
"sessions":"3"}
,
{
"No.":"47",
"flag":"",
"country / region / city":"Paraguay",
"code":"PY",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"2"}
,
{
"No.":"48",
"flag":"",
"country / region / city":"Portugal",
"code":"PT",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"2"}
,
{
"No.":"49",
"flag":"",
"country / region / city":"Morocco",
"code":"MA",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"2"}
,
{
"No.":"50",
"flag":"",
"country / region / city":"Finland",
"code":"FI",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"2"}
,
{
"No.":"51",
"flag":"",
"country / region / city":"Honduras",
"code":"HN",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"2"}
,
{
"No.":"52",
"flag":"",
"country / region / city":"Peru",
"code":"PE",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"2"}
,
{
"No.":"53",
"flag":"",
"country / region / city":"Bolivia",
"code":"BO",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"2"}
,
{
"No.":"54",
"flag":"",
"country / region / city":"Costa Rica",
"code":"CR",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"2"}
,
{
"No.":"55",
"flag":"",
"country / region / city":"Ireland",
"code":"IE",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"2"}
,
{
"No.":"56",
"flag":"",
"country / region / city":"Qatar",
"code":"QA",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"3"}
,
{
"No.":"57",
"flag":"",
"country / region / city":"Bulgaria",
"code":"BG",
"users":"2",
"graph":"|",
"percentage":"0.2%",
"sessions":"2"}
,
{
"No.":"58",
"flag":"",
"country / region / city":"Cyprus",
"code":"CY",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"59",
"flag":"",
"country / region / city":"Armenia",
"code":"AM",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"60",
"flag":"",
"country / region / city":"Austria",
"code":"AT",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"61",
"flag":"",
"country / region / city":"Latvia",
"code":"LV",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"62",
"flag":"",
"country / region / city":"Iran",
"code":"IR",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"63",
"flag":"",
"country / region / city":"El Salvador",
"code":"SV",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"64",
"flag":"",
"country / region / city":"Iraq",
"code":"IQ",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"65",
"flag":"",
"country / region / city":"Chile",
"code":"CL",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"66",
"flag":"",
"country / region / city":"Ecuador",
"code":"EC",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"67",
"flag":"",
"country / region / city":"Réunion",
"code":"RE",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"68",
"flag":"",
"country / region / city":"Ukraine",
"code":"UA",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"69",
"flag":"",
"country / region / city":"Ghana",
"code":"GH",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"70",
"flag":"",
"country / region / city":"Belgium",
"code":"BE",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"71",
"flag":"",
"country / region / city":"Georgia",
"code":"GE",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"72",
"flag":"",
"country / region / city":"Puerto Rico",
"code":"PR",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"73",
"flag":"",
"country / region / city":"Hong Kong",
"code":"HK",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"74",
"flag":"",
"country / region / city":"China",
"code":"CN",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"75",
"flag":"",
"country / region / city":"Slovakia",
"code":"SK",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"3"}
,
{
"No.":"76",
"flag":"",
"country / region / city":"Kuwait",
"code":"KW",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"77",
"flag":"",
"country / region / city":"Kyrgyzstan",
"code":"KG",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"2"}
,
{
"No.":"78",
"flag":"",
"country / region / city":"Croatia",
"code":"HR",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"79",
"flag":"",
"country / region / city":"Bhutan",
"code":"BT",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"80",
"flag":"",
"country / region / city":"Uzbekistan",
"code":"UZ",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"81",
"flag":"",
"country / region / city":"Kenya",
"code":"KE",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"82",
"flag":"",
"country / region / city":"Spain",
"code":"ES",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"83",
"flag":"",
"country / region / city":"Lebanon",
"code":"LB",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"84",
"flag":"",
"country / region / city":"Nicaragua",
"code":"NI",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"85",
"flag":"",
"country / region / city":"Denmark",
"code":"DK",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"86",
"flag":"",
"country / region / city":"Dominican Republic",
"code":"DO",
"users":"1",
"graph":"|",
"percentage":"0.1%",
"sessions":"1"}
,
{
"No.":"",
"flag":"",
"country / region / city":"",
"code":"",
"users":"1,058",
"graph":"",
"percentage":"100%",
"sessions":"1,167"}
]
}

Errors

If errors are encountered, the first encountered error will be returned of form "Error: exception: message

Error: java.lang.RuntimeException: Login/ site combination is not valid

All