What information do the filter fields represent?
Overview
When a hit or entry in a log file is read during processing, the hit is broken down into 'Raw Fields'. Fields are generally separated by spaces, tabs, or commas. The Log Format determines how these Raw Fields are assigned internally. Once the Raw Fields are read, Urchin calculates a number of 'Auto Fields' based on the 'Raw Fields'. Most reports use these Auto Fields for updating.
Filters can be applied to either Raw or Auto Fields. The following table lists all available Fields and their purpose.
Complete Field List
Field |
Type |
Purpose |
apache_time |
(RAW) |
Apache raw date & time of hit field. |
browser_base |
(AUTO) |
Browser name (e.g., Netscape). |
browser_version |
(AUTO) |
Browser version. |
c_host |
(RAW) |
Client hostname (converts to c_ip if necessary). |
c_ip |
(RAW) |
Client IP Address. |
client_hostname |
(AUTO) |
Client hostname. |
client_ipaddress |
(AUTO) |
Client IP Address. |
cs_cookie |
(RAW) |
Cookies sent by browser. |
cs_host |
(RAW) |
Requested virtualhost by Client. |
cs_method |
(RAW) |
IIS raw request method field. |
cs_referer |
(RAW) |
Raw Referral information (could be internal). |
cs_request |
(RAW) |
IIS raw request URI |
cs_uriquery |
(RAW) |
IIS raw request query field. |
cs_uristem |
(RAW) |
IIS raw request stem field. |
cs_useragent |
(RAW) |
Browser user-agent information. |
cs_username |
(RAW) |
Client username (if any) |
cs_version |
(RAW) |
IIS Raw HTTP version. |
custom_date |
(RAW) |
Used for datestamp in Custom Logs. |
custom_time |
(RAW) |
Used for timestamp in Custom Logs. |
domain_complete |
(AUTO) |
Complete domain. (e.g. urchin.com). |
domain_primary |
(AUTO) |
First level domain. (e.g. com). |
ecommerce_affiliation |
(AUTO) |
E-commernce transaction id. |
ecommerce_bill_city |
(AUTO) |
Billing city for e-commernce transaction. |
ecommerce_bill_country |
(AUTO) |
Billing country for e-commernce transaction. |
ecommerce_bill_region |
(AUTO) |
Billing region (state/province) for e-commernce transaction. |
ecommerce_orderid |
(AUTO) |
E-commerce order id number. |
ecommerce_product_code |
(AUTO) |
E-commerce product code. |
ecommerce_product_name |
(AUTO) |
E-commerce product name. |
ecommerce_quantity |
(AUTO) |
E-commerce product quantity. |
ecommerce_shipping |
(AUTO) |
E-commerce shipping amount. |
ecommerce_tax |
(AUTO) |
E-commerce tax amount. |
ecommerce_total |
(AUTO) |
E-commerce transaction amount. |
ecommerce_unit_price |
(AUTO) |
E-commerce product unit price. |
ecommerce_variation |
(AUTO) |
E-commerce product variation. |
elf_billcity |
(RAW) |
E-commerce customer city. |
elf_billcountry |
(RAW) |
E-commerce customer country. |
elf_billstate |
(RAW) |
E-commerce customer state. |
elf_billzip |
(RAW) |
E-commerce customer zip code. |
elf_orderid |
(RAW) |
E-commerce order id number. |
elf_price |
(RAW) |
E-commerce product price. |
elf_productcode |
(RAW) |
E-commerce product code. |
elf_productname |
(RAW) |
E-commerce product name. |
elf_quantity |
(RAW) |
E-commerce product quantity. |
elf_region |
(AUTO) |
E-Commerce region drilldown information. |
elf_sessionid |
(RAW) |
E-commerce session id. |
elf_shipping |
(RAW) |
E-commerce shipping amount. |
elf_store |
(RAW) |
E-commerce store name. |
elf_tax |
(RAW) |
E-commerce tax amount. |
elf_total |
(RAW) |
E-commerce transaction amount. |
elf_unit_price |
(RAW) |
E-commerce product unit price. |
elf_upsold |
(RAW) |
E-commerce upsold variable. |
elf_variation |
(RAW) |
E-commerce product variation. |
geo_country |
(AUTO) |
Visitor Country |
geo_city |
(AUTO) |
Visitor City |
geo_connection_speed |
(AUTO) |
Visitor Connection Speed |
geo_isp |
(AUTO) |
Visitor ISP |
geo_latitude |
(AUTO) |
Visitor Latitude |
geo_longitude |
(AUTO) |
Visitor Longitude |
geo_organization |
(AUTO) |
Visitor Organization or Network Location |
geo_region |
(AUTO) |
Visitor Region |
iis_date |
(RAW) |
IIS raw date of hit field. |
iis_time |
(RAW) |
IIS raw time of hit field. |
organic_source |
(AUTO) |
Organic source |
log_source_name |
(AUTO) |
Name of the log source |
platform_base |
(AUTO) |
Platform (e.g., Windows). |
platform_version |
(AUTO) |
Platform version. |
referral_anchor |
(AUTO) |
Referral information after # tag. |
referral_directory |
(AUTO) |
Referral directory up to filename. |
referral_filename |
(AUTO) |
Referral filename without directory. |
referral_host |
(AUTO) |
Referral complete hostname. |
referral_keywords |
(AUTO) |
Referral search engine keywords |
referral_mime |
(AUTO) |
Referral mime type (file extension) |
referral_port |
(AUTO) |
Referral port number (if any). |
referral_protocol |
(AUTO) |
Referral protocol (http/https/etc.) |
referral_query |
(AUTO) |
Referral Query info by itself. |
referral_stem |
(AUTO) |
Referral URI stem without query info. |
referral_uri |
(AUTO) |
Referral complete URI. (no host) |
referral_url |
(AUTO) |
Referral complete URL. (includes host) |
request_anchor |
(AUTO) |
Request information after # tag |
request_directory |
(AUTO) |
Request directory without filename. |
request_download |
(AUTO) |
Download requests. |
request_filename |
(AUTO) |
Request filename without directory. |
request_form |
(AUTO) |
Requested "posted form". |
request_host |
(AUTO) |
Request hostname (if any). |
request_method |
(AUTO) |
Request method (GET/POST/etc.). |
request_mime |
(AUTO) |
Request mime type (file extension). |
request_origfilepath |
(AUTO) |
Request original uri stem if UTM. |
request_origmime |
(AUTO) |
Request original mime type if UTM. |
request_port |
(AUTO) |
Request port number (if any). |
request_protocol |
(AUTO) |
Request protocol (HTTP/etc.). |
request_query |
(AUTO) |
Request query information (e.g., after ?) |
request_stem |
(AUTO) |
Request URI without query. |
request_uri |
(AUTO) |
Request URI with query. |
request_url |
(AUTO) |
Request complete URL (if provided). |
request_version |
(AUTO) |
Request protocol version. |
robot_agent |
(AUTO) |
Robot (crawlers) requests. |
s_computername |
(RAW) |
IIS Computer name. |
s_ip |
(RAW) |
IIS Server IP address. |
s_port |
(RAW) |
Server port number. |
s_sitename |
(RAW) |
IIS Server site name. |
sc_bytes |
(RAW) |
Number of bytes transferred for request. |
sc_status |
(RAW) |
Return status code from server. |
sid |
(AUTO) |
Session id (if any). |
user_defined_variable |
(AUTO) |
User defined var extracted from utm_cookiev variable. |
username |
(AUTO) |
Client username (if any). |
utm_campaign |
(AUTO) |
UTM campaign name. |
utm_campaign_clicks |
(RAW) |
UTM compaign clicks. |
utm_campaign_cost |
(RAW) |
UTM compaign cost. |
utm_campaign_goal |
(AUTO) |
UTM compaign goals met. |
utm_campaign_hour |
(AUTO) |
Hour of the day when that compaign hit occured. |
utm_campaign_impressions |
(RAW) |
UTM compaign impressions count. |
utm_campaign_uri |
(RAW) |
URI for UTM compaign. |
utm_content |
(AUTO) |
UTM compaign content. |
utm_cookiea |
(AUTO) |
UTM-2 cookie-a |
utm_cookieb |
(AUTO) |
UTM-2 cookie-b |
utm_cookiec |
(AUTO) |
UTM-2 cookie-c |
utm_cookiev |
(AUTO) |
UTM-2 cookie-v |
utm_cookiez |
(AUTO) |
UTM-2 cookie-z |
utm_flash_version |
(AUTO) |
Flash version info |
utm_id |
(AUTO) |
UTM campaign id |
utm_java_enabled |
(AUTO) |
yes|no if java is enabled. |
utm_js_version |
(AUTO) |
Javascript version info. |
utm_language |
(AUTO) |
Browser language code setting. |
utm_medium |
(AUTO) |
UTM medium (cpc|cpm|link|email|organic) |
utm_new_campaign |
(AUTO) |
UTM new campaigns. |
utm_page |
(AUTO) |
UTM page variable (used for request_ variables). |
utm_page_title |
(AUTO) |
UTM page title |
utm_referral |
(AUTO) |
UTM Referral (used for referral_ variables). |
utm_request_hostname |
(AUTO) |
Host name of the compaign hit. |
utm_screen_colors |
(AUTO) |
Screen color bit depth. |
utm_screen_resolution |
(AUTO) |
Screen resolution (e.g., 800x600). |
utm_source |
(AUTO) |
UTM compaign source. |
utm_term |
(AUTO) |
UTM compaign term. |
utm_type |
(AUTO) |
UTM type (transaction, item, var) |
utm_unique_id |
(AUTO) |
UTM unique visitor id. |
visitor_type |
(AUTO) |
New vs Returning visitors |