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.
Regular Field List
| id | Field | Type | Purpose |
|---|---|---|---|
| 1 | iis_date | (RAW) | IIS raw date of hit field. |
| 2 | iis_time | (RAW) | IIS raw time of hit field. |
| 3 | apache_time | (RAW) | Apache raw date & time of hit field. |
| 4 | c_ip | (RAW) | Client IP Address. |
| 5 | cs_username | (RAW) | Client username (if any) |
| 6 | cs_request | (RAW) | Apache raw entire request field. |
| 7 | cs_method | (RAW) | IIS raw request method field. |
| 8 | cs_uristem | (RAW) | IIS raw request stem field. |
| 9 | cs_uriquery | (RAW) | IIS raw request query field. |
| 10 | sc_status | (RAW) | Return status code from server. |
| 11 | sc_bytes | (RAW) | Number of bytes transferred for request. |
| 12 | c_host | (RAW) | Client hostname (converts to c_ip if necessary). |
| 13 | cs_useragent | (RAW) | Browser user-agent information. |
| 14 | cs_cookie | (RAW) | Cookies sent by browser. |
| 15 | cs_referer | (RAW) | Raw Referral information (could be internal). |
| 16 | custom_date | (RAW) | Used for datestamp in Custom Logs. |
| 17 | custom_time | (RAW) | Used for timestamp in Custom Logs. |
| 19 | cs_host | (RAW) | Requested virtualhost by Client. |
| 20 | s_port | (RAW) | Server port number. |
| 21 | cs_version | (RAW) | IIS Raw HTTP version. |
| 22 | s_sitename | (RAW) | IIS Server site name. |
| 23 | s_computername | (RAW) | IIS Computer name. |
| 24 | s_ip | (RAW) | IIS Server IP address. |
| 25 | elf_orderid | (RAW) | E-commerce order id number. |
| 26 | elf_store | (RAW) | E-commerce store name. |
| 27 | elf_sessionid | (RAW) | E-commerce session id. |
| 28 | elf_total | (RAW) | E-commerce transaction amount. |
| 29 | elf_tax | (RAW) | E-commerce tax amount. |
| 30 | elf_shipping | (RAW) | E-commerce shipping amount. |
| 31 | elf_billcity | (RAW) | E-commerce customer city. |
| 32 | elf_billstate | (RAW) | E-commerce customer state. |
| 33 | elf_billzip | (RAW) | E-commerce customer zip code. |
| 34 | elf_billcountry | (RAW) | E-commerce customer country. |
| 35 | elf_productcode | (RAW) | E-commerce product code. |
| 36 | elf_productname | (RAW) | E-commerce product name. |
| 37 | elf_variation | (RAW) | E-commerce product variation. |
| 38 | elf_price | (RAW) | E-commerce product price. |
| 39 | elf_quantity | (RAW) | E-commerce product quantity. |
| 40 | elf_upsold | (RAW) | E-commerce upsold variable. |
| 76 | referral_protocol | (AUTO) | Referral protocol (http/https/etc.) |
| 77 | referral_host | (AUTO) | Referral complete hostname. |
| 78 | referral_domain | (AUTO) | Referral domain name. |
| 79 | referral_port | (AUTO) | Referral port number (if any). |
| 80 | referral_url | (AUTO) | Referral complete URL. (includes host) |
| 81 | referral_uri | (AUTO) | Referral complete URI. (no host) |
| 82 | referral_stem | (AUTO) | Referral URI stem without query info. |
| 83 | referral_query | (AUTO) | Referral Query info by itself. |
| 84 | referral_anchor | (AUTO) | Referral information after # tag. |
| 85 | referral_directory | (AUTO) | Referral directory up to filename. |
| 86 | referral_filename | (AUTO) | Referral filename without directory. |
| 87 | referral_mime | (AUTO) | Referral mime type (file extension) |
| 88 | referral_keywords | (AUTO) | Referral search engine keywords |
| 89 | referral_domainandstem | (AUTO) | Referral domain and URI stem together. |
| 90 | referral_errordetail | (AUTO) | Referral error detail information. |
| 91 | request_method | (AUTO) | Request method (GET/POST/etc.). |
| 92 | request_url | (AUTO) | Request complete URL (if provided). |
| 93 | request_version | (AUTO) | Request protocol version. |
| 94 | request_protocol | (AUTO) | Request protocol (HTTP/etc.). |
| 95 | request_host | (AUTO) | Request hostname (if any). |
| 96 | request_port | (AUTO) | Request port number (if any). |
| 97 | request_uri | (AUTO) | Request URI with query. |
| 98 | request_stem | (AUTO) | Request URI without query. |
| 99 | request_query | (AUTO) | Request query information (e.g., after ?) |
| 100 | request_anchor | (AUTO) | Request information after # tag |
| 101 | request_directory | (AUTO) | Request directory without filename. |
| 102 | request_filename | (AUTO) | Request filename without directory. |
| 103 | request_mime | (AUTO) | Request mime type (file extension). |
| 104 | request_origfilepath | (AUTO) | Request original uri stem if UTM. |
| 105 | request_origmime | (AUTO) | Request original mime type if UTM. |
| 106 | request_errordetail | (AUTO) | Request detail for error hits. |
| 107 | useragent_complete | (AUTO) | Complete user- agent. |
| 108 | browser_base | (AUTO) | Browser name (e.g., Netscape). |
| 109 | browser_version | (AUTO) | Browser version. |
| 110 | platform_base | (AUTO) | Platform (e.g., Windows). |
| 111 | platform_version | (AUTO) | Platform version. |
| 112 | domain_primary | (AUTO) | First level domain. (e.g. com). |
| 113 | domain_complete | (AUTO) | Complete domain. (e.g. urchin.com). |
| 114 | sid | (AUTO) | Session id (if any). |
| 115 | utm_cookiea | (AUTO) | UTM-2 cookie-a |
| 116 | utm_cookieb | (AUTO) | UTM-2 cookie-b |
| 117 | utm_cookiec | (AUTO) | UTM-2 cookie-c |
| 119 | utm_cookie1 | (AUTO) | UTM-1 cookie-1 |
| 120 | utm_cookie2 | (AUTO) | UTM-2 cookie-2 |
| 121 | utm_cookie3 | (AUTO) | UTM-3 cookie-3 |
| 122 | utm_unique_id | (AUTO) | UTM unique visitor id. |
| 123 | utm_new_campaign | (AUTO) | new campaign variables detected |
| 124 | utm_page | (AUTO) | UTM page variable (used for request_ variables). |
| 125 | utm_referral | (AUTO) | UTM Referral (used for referral_ variables). |
| 126 | utm_screen_resolution | (AUTO) | Screen resolution (e.g., 800x600). |
| 127 | utm_screen_available | (AUTO) | Available screen resolution in pixels. |
| 128 | utm_browser_size | (AUTO) | Browser size in pixels. |
| 129 | utm_screen_colors | (AUTO) | Screen color bit depth. |
| 130 | utm_language | (AUTO) | Browser language code setting. |
| 131 | utm_java_enabled | (AUTO) | yes|no if java is enabled. |
| 132 | utm_cookies_enabled | (AUTO) | yes|no if cookies are enabled. |
| 133 | utm_timezone_offset | (AUTO) | +/-HHMM timezone offset value of browser. |
| 134 | utm_js_version | (AUTO) | Javascript version info. |
| 135 | utm_session_number | (AUTO) | Number of sessions for this visitor. |
| 136 | utm_repeat_campaign | (AUTO) | Repeat campaign detected. |
| 137 | utm_campaign | (AUTO) | same as utm_campaign in a link. |
| 138 | utm_medium | (AUTO) | same as utm_medium in a link. |
| 139 | utm_source | (AUTO) | same as utm_source in a link. |
| 140 | utm_term | (AUTO) | same as utm_term in a link. |
| 141 | utm_content | (AUTO) | same as utm_content in a link. |
| 142 | utm_campaign_session | (AUTO) | session number of this campaign. |
| 143 | utm_campaign_number | (AUTO) | Number of responses in __utmz. |
| 144 | utm_campaign_time | (AUTO) | Time in seconds of the current campaign. |
| 145 | elf_region | (AUTO) | E-Commerce region drilldown information. |
| 146 | utm_campaign_srcmedium | (AUTO) | utm_campaign [utm_medium]. |
| 147 | utm_campaign_srcmedtrm | (AUTO) | utm_campaign [utm_medium] | utm_term. |
| 148 | utm_campaign_sesdelta | (AUTO) | difference in current session number and campaign session number. |
| 149 | utm_campaign_daysdelta | (AUTO) | difference in days between the hit viewtime and the campaign time. |
| 150 | utm_campaign_hour | (AUTO) | hour of the day the campaign occurred. |
| 151 | utm_campaign_goal | (AUTO) | campaign goal that was met. |
| 152 | log_source_name | (AUTO) | Log source name in Log Source Wizard. |
| 153 | utm_ipandvisitorid | (AUTO) | IP address or host - visitor key. |
| 154 | utm_id | (AUTO) | same as utm_id in a link. |
| 155 | utm_type | (AUTO) | used for email impressions. |