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
|