Geolocation parameters

Geolocation parameters identify cities, countries, and regions. These parameters are added to Oracle Infinity data after collection by a data augmentation service. They are visible in streams data.

Area Code

ext.geo.area indicates the US telephone area code.

Valid value Alphanumeric string
Syntax ext.geo.area=area_code
Example ext.geo.area=503

CBSA code

ext.geo.cbsac indicates the core-based statistical area (CBSA) internal lookup code (US only).

Valid value Alphanumeric string
Syntax ext.geo.cbsac=CBSA_lookup_code
Example ext.geo.cbsac=17460

CBSA title

ext.geo.cbsan indicates the CBSA title for the location, such as San Francisco-Oakland-Fremont, CA.

Valid value Alphanumeric string
Syntax ext.geo.cbsan=CBSA_title
Example ext.geo.cbsan=Cleveland-Elyria-Mentor,OH

CBSA type

ext.geo.cbsat indicates the type of CBSA, which can be a metropolitan (metro) or a micro area.

Valid value Alphanumeric string
Syntax ext.geo.cbsat={metro|micro}
Example ext.geo.cbsat=metro

City code

ext.geo.cic identifies the numeric code for the city, such as 4782 for London, UK, which is useful for filtering.

Valid value Alphanumeric string
Syntax ext.geo.cic=city_code
Example ext.geo.cic=107

City

ext.geo.city identifies the full name of the city, such as London.

Valid value Alphanumeric string
Syntax ext.geo.city=city_name
Example ext.geo.city=cleveland

Company

ext.geo.co indicates the name of the company. If no specific company name exists, the ISP name appears.

Valid value Alphanumeric string
Syntax ext.geo.co=company_name
Example ext.geo.co=

Continent code

ext.geo.cnc indicates the numeric code for the continent.

Valid value Alphanumeric string
Syntax ext.geo.cnc=continent_code
Example ext.geo.cnc=4

Continent name

ext.geo.continent indicates the continent name.

Valid value Alphanumeric string
Syntax ext.geo.continent=continent_name
Example ext.geo.continent=Asia

Country

ext.geo.country indicates the full name of the country.

Valid value Alphanumeric string
Syntax ext.geo.country=country_name
Example ext.geo.country=pakistan

Country three-letter code

ext.geo.cc3 indicates the ISO 3166-1 alpha-3 country code, such as GBR.

Valid value Alphanumeric string
Syntax ext.geo.cc3=country_code
Example ext.geo.cc3=CAN

Country two-letter code

ext.geo.cc2 indicates the ISO 3166-1 alpha-2 country code, such as US.

Valid value Alphanumeric string
Syntax ext.geo.cc2=country_code
Example ext.geo.cc2=US

CSA code

ext.geo.csac identifies the combined statistical area (CSA) code, which is similar to the core-based statistical area (CBSA).

Valid value Alphanumeric string
Syntax ext.geo.csac=CSA_code
Example ext.geo.csac=266

CSA title

ext.geo.csan indicates the combined statistical area (CSA) title, such as San Jose-San Francisco-Oakland.

Valid value Alphanumeric string
Syntax ext.geo.csan=CSA_title
Example ext.geo.csan=Portland-Vancouver-Salem

Daylight saving time

ext.geo.dst indicates whether the region is observing daylight saving time (y) or not (n).

Valid value y or n
Syntax ext.geo.dst={y|n}
Example ext.geo.dst=n

Home or business

ext.geo.hb indicates whether the hit is from a home or business based on registration of the IP address with an ISP.

Valid value Alphanumeric string
Syntax ext.geo.hb=IP_registration_type
Example ext.geo.hb=business

ISP domain

ext.geo.ispd indicates the internet service provider (ISP) domain name, such as comcast.net.

Valid value Alphanumeric string
Syntax ext.geo.ispd=ISP_domain
Example ext.geo.ispd=example.net

ISP name

ext.geo.isp indicates the name of the ISP.

Valid value Alphanumeric string
Syntax ext.geo.isp=ISP_company_name
Example ext.geo.isp=Example

Latitude

ext.geo.latitude indicates the approximate latitude coordinate, such as -051.506.

The value of this parameter is derived from the ZIP code associated IP address when available. It is not derived from the value of the wt.gc parameter.

Valid value Alphanumeric string
Syntax ext.geo.latitude=latitude_coordinate
Example ext.geo.latitude=69.1209

Longitude

ext.geo.longitude indicates the approximate longitude coordinate, such as -000.127.

The value of this parameter is derived from the ZIP code associated IP address when available. It is not derived from the value of the wt.gc parameter.

Valid value Alphanumeric string
Syntax ext.geo.longitude=longitude_coordinate
Example ext.geo.longitude=44.5504

Metro code

ext.geo.mtc indicates the 2-6 digit metro codes, such as 505 for Detroit.

Valid value Alphanumeric string
Syntax ext.geo.mtc=metro_code
Example ext.geo.mtc=510

Metropolitan area name

ext.geo.metro indicates the name of the metropolitan area.

Valid value Alphanumeric string
Syntax ext.geo.metro=metro_name
Example ext.geo.metro=london

Network type

ext.geo.nt indicates the type of network connection, such as broadband, xdsl, cable, or mobile.

Valid value Alphanumeric string
Syntax ext.geo.nt=network_connection_type
Example ext.geo.nt=mobile

Region

ext.geo.rc identifies the two-letter region code, such as NY.

Valid value Alphanumeric string
Syntax ext.geo.rc=region_code
Example ext.geo.rc=OR

Region name

ext.geo.region indicates the name of the region.

Valid value Alphanumeric string
Syntax ext.geo.region=region_name
Example ext.geo.region=saopaulo

Region language

ext.geo.plang indicates the primary language in the region.

Valid value Alphanumeric string
Syntax ext.geo.plang=primary_language
Example ext.geo.plang=english

State

ext.geo.mts indicates the state of the visitor's designated market area (DMA).

Valid value Alphanumeric string
Syntax ext.geo.mts=state
Example ext.geo.mts=NY

Time zone offset

ext.geo.tz identifies the UTC offset.

Valid value Alphanumeric string
Syntax ext.geo.tz=UTC_offset
Example ext.geo.tz=+5

Zip Code

ext.geo.zip indicates the postal code.

Valid value Alphanumeric string
Syntax ext.geo.zip=postal_code
Example ext.geo.zip=03301

Learn more

Full Parameter Reference

geolocation, geographic, ext.geo.area, ext.geo.cbsan, ext.geo.cbsat, ext.geo.cic, ext.geo.city, ext.geo.co, ext.geo.cnc, ext.geo.continent, ext.geo.country, ext.geo.cc3, ext.geo.cc2, ext.geo.csan, ext.geo.dst, ext.geo.hb, ext.geo.ispd, ext.geo.isp, ext.geo.latitude, ext.geo.longitude, ext.geo.mtc, ext.geo.metro, ext.geo.nt, ext.geo.zip, ext.geo.rc, ext.geo.region, ext.geo.plang, ext.geo.mts, ext.geo.tz, mobile, device, app, latitude, longitude, lat, lon