Overview
When a hit or line 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. Once the Raw Fields are read, Urchin automatically calculates the 'Auto Fields', using the values in the 'Raw Fields'. Most reports use data in these Auto Fields for updating.
Filters can be applied to either Raw or Auto Fields. The following two tables provides insight into the purpose of each Field. The first table lists the Fields used for standard reports. A dash in the Fields Used column means that the report in question summarizes numbers generated in other reports and therefore is not tied specifically to the data in particular fields. The second table lists all available Fields and their purpose.
Report Field List
| Report Name | Fields Used |
|---|---|
| Traffic | |
| Sessions Graph | - |
| Pageviews Graph | - |
| Hits Graph | - |
| Bytes Graph | - |
| Summary | - |
| Visitors & Sessions | |
| Visitors by Day | - |
| Sessions by Day | - |
| Unique Visitors | - |
| Unique Sessions | - |
| Visitor Loyalty | utm_session_number |
| Session Frequency | - |
| Summary | - |
| Pages & Files | |
| Requested Pages | request_stem |
| Downloads | request_stem |
| All Files | request_origfilepath |
| Directory by Pages Drilldown | request_stem |
| Directory by Files Drilldown | request_origfilepath |
| Directory by Bytes Drilldown | request_stem |
| File Types by Hits | request_origmime |
| File Types by Bytes | request_origmime |
| Page Query Terms | request_stem|request_query |
| Posted Forms | request_stem |
| Status and Errors | sc_status|request_errordetail |
| Navigation | |
| Entrance Pages | request_stem |
| Exit Pages | request_stem |
| Click Paths | request_stem |
| Click To and From | request_stem |
| Length of Pageview | request_stem |
| Depth of Session | - |
| Length of Session | - |
| Click To and From Report | request_stem |
| Referrals | |
| Referrals | referral_domainandstem |
| Referral Drilldown | referral_domainandstem |
| Search Terms | referral_domain|referral_keywords |
| Search Engines | referral_domain|referral_keywords |
| Referral Errors | referral_errordetail|referral_domainandstem |
| Domains & Users | |
| Domains | domain_primary|domain_complete |
| Domain Drilldown | domain_primary|domain_complete |
| Countries | domain_primary|domain_complete |
| IP Addresses | c_ip |
| IP Drilldown | c_ip |
| Usernames by Hits | cs_username |
| Usernames by Bytes | cs_username |
| Usernames by Sessions | cs_username |
| Browsers & Robots | |
| Browsers by Sessions Drilldown | useragent_complete |
| Browsers by Hits Drilldown | useragent_complete |
| Browsers by Bytes Drilldown | useragent_complete |
| Platforms by Sessions Drilldown | useragent_complete |
| Platforms by Hits Drilldown | useragent_complete |
| Platforms by Bytes Drilldown | useragent_complete |
| Combos by Sessions | useragent_complete |
| Robots by Hits Drilldown | browser_base |
| Robots by Bytes Drilldown | browser_base |
| Client Parameters | |
| Screen Resolution | utm_screen_resolution |
| Screen Colors | utm_screen_colors |
| Languages | utm_language |
| Java Enabled | utm_java_enabled |
| Timezone Offset | utm_timezone_offset |
| Javascript Version | utm_js_version |
| E-Commerce | |
| Revenue | - |
| Number of Transactions | - |
| Products by Revenue | elf_productname|elf_productcode |
| Products by Quantity | elf_productname|elf_productcode |
| Products by Revenue Drilldown | elf_productname|elf_productcode |
| Products by Quantity Drilldown | elf_productname|elf_productcode |
| E-Commerce Summary | - |
| Revenue Source | |
| Revenue by Region Drilldown | elf_region |
| Revenue by City | elf_region |
| Revenue by Referrals | referral_domainandstem |
| Revenue by Search Terms | referral_domain|referral_keywords |
| Revenue by Search Engines Drilldown | referral_domain|referral_keywords |
| Revenue by Domains Drilldown | domain_primary|domain_complete |
Complete 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 | selected>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. |
| 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. |
| 145 | elf_region | (AUTO) | E-Commerce region drilldown information. |