Overview
During processing, each hit in the log file is separated and calculated into different fields. These fields are then used to update data tables which are queried for report views. Some reports have special storage and are not included in the data tables.
The following table lists all of the predefined reports and which data table is queried for each.
Regular Field List
| View# | Report Name | Data Table | Fields Used |
|---|---|---|---|
| 1100 | Traffic | ||
| 1102 | Sessions Graph | - | - |
| 1103 | Pageviews Graph | - | - |
| 1104 | Hits Graph | - | - |
| 1105 | Bytes Graph | - | - |
| 1110 | Summary | - | - |
| 1900 | Visitors & Sessions | ||
| 1903 | Visitors by Day | - | - |
| 1907 | Sessions by Day | - | - |
| 1901 | Unique Visitors | - | - |
| 1905 | Unique Sessions | - | - |
| 1904 | Visitor Loyalty | 37 | utm_session_number vs. sessions |
| 1906 | Session Frequency | - | - |
| 1902 | Summary | - | - |
| 1200 | Pages & Files | ||
| 1201 | Requested Pages | 7 | request_stem vs. pageviews |
| 1211 | Downloads | 17 | request_stem vs. downloads |
| 1206 | All Files | 12 | request_origfilepath vs. hits |
| 1202 | Directory by Pages Drilldown | 7 | request_stem vs. pageviews |
| 1207 | Directory by Files Drilldown | 12 | request_origfilepath vs. hits |
| 1208 | Directory by Bytes Drilldown | 18 | request_stem vs. bytes |
| 1203 | File Types by Hits | 13 | request_origmime vs. hits |
| 1209 | File Types by Bytes | 19 | request_origmime vs. bytes |
| 1210 | Page Query Terms | 11 | request_stem|request_query vs. hits |
| 1205 | Posted Forms | 8 | request_stem vs. hits |
| 1204 | Status and Errors | 14 | sc_status|request_errordetail vs. hits |
| 1600 | Navigation | ||
| 1601 | Entrance Pages | 20 | request_stem vs. pageviews |
| 1602 | Exit Pages | 20 | request_stem vs. pageviews |
| 1609 | Click Paths | 21 | request_stem vs. sessions |
| 1603 | Click To and From | 7 | request_stem vs. pageviews |
| 1610 | Length of Pageview | 22 | request_stem vs. time |
| 1604 | Depth of Session | - | - |
| 1608 | Length of Session | - | - |
| 1606 | Click To and From Report | 20 | request_stem vs. pages |
| 1300 | Referrals | ||
| 1301 | Referrals | 1 | referral_domainandstem vs. sessions |
| 1303 | Referral Drilldown | 1 | referral_domainandstem vs. sessions |
| 1302 | Search Terms | 2 | referral_domain|referral_keywords vs. sessions |
| 1304 | Search Engines | 2 | referral_domain|referral_keywords vs. sessions |
| 1305 | Referral Errors | 23 | referral_errordetail|referral_domainandstem vs. hits |
| 1400 | Domains & Users | ||
| 1401 | Domains | 4 | domain_primary|domain_complete |
| 1402 | Domain Drilldown | 4 | domain_primary|domain_complete vs. sessions |
| 1403 | Countries | 4 | domain_primary|domain_complete vs. sessions |
| 1404 | IP Addresses | 6 | c_ip vs. sessions |
| 1405 | IP Drilldown | 6 | c_ip vs. sessions |
| 1406 | Usernames by Hits | 10 | cs_username vs. hits |
| 1407 | Usernames by Bytes | 16 | cs_username vs. bytes |
| 1409 | Usernames by Sessions | 5 | cs_username vs. sessions |
| 1500 | Browsers & Robots | ||
| 1501 | Browsers by Sessions Drilldown | 3 | useragent_complete vs. sessions |
| 1504 | Browsers by Hits Drilldown | 9 | useragent_complete vs. hits |
| 1505 | Browsers by Bytes Drilldown | 15 | useragent_complete vs. bytes |
| 1502 | Platforms by Sessions Drilldown | 3 | useragent_complete vs. sessions |
| 1506 | Platforms by Hits Drilldown | 9 | useragent_complete vs. hits |
| 1507 | Platforms by Bytes Drilldown | 15 | useragent_complete vs. bytes |
| 1503 | Combos by Sessions | 3 | useragent_complete vs. sessions |
| 1510 | Robots by Hits Drilldown | 24 | browser_base vs. hits |
| 1511 | Robots by Bytes Drilldown | 25 | browser_base vs. bytes |
| 1800 | Client Parameters | ||
| 1801 | Screen Resolution | 31 | utm_screen_resolution vs. sessions |
| 1804 | Screen Colors | 32 | utm_screen_colors vs. sessions |
| 1805 | Languages | 33 | utm_language vs. sessions |
| 1806 | Java Enabled | 34 | utm_java_enabled vs. sessions |
| 1808 | Timezone Offset | 35 | utm_timezone_offset vs. sessions |
| 1809 | Javascript Version | 36 | utm_js_version vs. sessions |
| 2100 | E-Commerce | ||
| 2101 | Revenue | - | - |
| 2102 | Number of Transactions | - | - |
| 2103 | Products by Revenue | 42 | elf_productname|elf_productcode vs. revenue |
| 2104 | Products by Quantity | 41 | elf_productname|elf_productcode vs. items |
| 2105 | Products by Revenue Drilldown | 42 | elf_productname|elf_productcode vs. revenue |
| 2106 | Products by Quantity Drilldown | 41 | elf_productname|elf_productcode vs. items |
| 2107 | E-Commerce Summary | - | - |
| 2100 | Revenue Source | ||
| 2101 | Revenue by Region Drilldown | 43 | elf_region vs. revenue |
| 2102 | Revenue by City | 43 | elf_region vs. revenue |
| 2103 | Revenue by Referrals | 44 | referral_domainandstem vs. revenue |
| 2104 | Revenue by Search Terms | 45 | referral_domain|referral_keywords vs. revenue |
| 2105 | Revenue by Search Engines Drilldown | 45 | referral_domain|referral_keywords vs. revenue |
| 2106 | Revenue by Domains Drilldown | 46 | domain_primary|domain_complete vs. revenue |
| 2200 | Campaign Tracking | ||
| 2201 | Lead Source-Acquisition | 56, 57, 53 | source(medium) vs clicks, impressions, new leads |
| 2202 | Lead Source-Quality | 56, 52, 51 | source(medium) vs clicks, pages, sessions |
| 2203 | Lead Source-Conversion | 56, 55, 81 | source(medium) vs clicks, goals, transactions |
| 2204 | Lead Source-ROI | 56, 82, 54 | source(medium) vs clicks, revenue, cost |
| 2206 | Lead Source-Conversion | 56, 55 | source(medium) vs clicks, goals |
| 2206 | Lead Source-cost breakdown | 54 | source(medium) vs cost |
| 2211 | Keyword Analysis-Acquisition | 70, 71, 67 | source (medium) vs clicks, impressions, new leads |
| 2212 | Keyword Analysis-Quality | 70, 66, 65 | source(medium) | term vs clicks, pages, sessions |
| 2213 | Keyword Analysis-Conversion | 70, 69, 85 | source (medium) | term vs clicks, goals, transactions |
| 2214 | Keyword Analysis-ROI | 70, 86, 68 | source(medium) | term vs clicks, revenue, cost |
| 2215 | Keyword Analysis-Conversion | 70, 69 | source(medium) | term vs clicks, goals |
| 2216 | Keyword Analysis-cost breakdown | 68 | source(medium) | term vs clicks |
| 2221 | Keyword Comparison-Acquisition | 70, 71, 67 | source (medium) vs clicks, impressions, new leads |
| 2222 | Keyword Comparison-Quality | 70, 66, 65 | source (medium) | term vs clicks, pages, sessions |
| 2223 | Keyword Comparison-Conversion | 70, 69, 85 | source (medium) | term vs clicks, goals, transactions |
| 2224 | Keyword Comparison-ROI | 70, 86, 68 | source(medium) | term vs clicks, revenue, cost |
| 2225 | Keyword Comparison-Conversion | 70, 69 | source (medium) | term vs clicks, goals |
| 2226 | Keyword Comparison-cost breakdown | 68 | source (medium) | term vs clicks |
| 2231 | Campaign Comparison-Acquisition | 56, 57, 53 | campaign name | source(medium) vs clicks, impressions, leads |
| 2232 | Campaign Comparison-Quality | 56, 52, 51 | campaign name | source(medium) vs clicks, pages, sessions |
| 2233 | Campaign Comparison-Conversion | 56, 55, 81 | campaign name | source(medium) vs clicks, goals, transactions |
| 2234 | Campaign Comparison-ROI | 56, 82, 54 | campaign name | source(medium) vs clicks, revenue, cost |
| 2235 | Campaign Comparison-Conversion | 56, 55 | campaign name | source(medium) vs clicks, goals |
| 2236 | Campaign Comparison-cost breakdown | 54 | campaign name | source(medium) vs cost |
| 2241 | Medium Comparison-Acquisition | 56, 57, 53 | campaign name | source(medium) vs clicks, impressions, leads |
| 2242 | Medium Comparison-Quality | 56, 52, 51 | campaign name | source(medium) vs clicks, pages, sessions |
| 2243 | Medium Comparison-Conversion | 56, 55, 81 | campaign name | source(medium) vs clicks, goals, transactions |
| 2244 | Medium Comparison-ROI | 56, 82, 54 | campaign name | source(medium) vs clicks, revenue, cost |
| 2245 | Medium Comparison-Conversion | 56, 55 | campaign name | source(medium) vs clicks, goals |
| 2246 | Medium Comparison-cost breakdown | 54 | campaign name | source(medium) vs cost |
| 2251 | Content Testing-Acquisition | 63, 64, 60 | campaign name | source(medium) vs clicks, impressions, leads |
| 2252 | Content Testing-Quality | 63, 59, 58 | campaign name | source(medium) vs clicks, pages, sessions |
| 2253 | Content Testing-Conversion | 63, 62, 83 | campaign name | source(medium) vs clicks, goals, transactions |
| 2254 | Content Testing-ROI | 63, 84, 61 | campaign name | source(medium) vs clicks, revenue, cost |
| 2255 | Content Testing-Conversion | 63, 62 | campaign name | source(medium) vs clicks, goals |
| 2256 | Content Testing-cost breakdown | 61 | campaign name | source(medium) vs cost |
| 2265 | Goal Conversion by Hour | 73, 72 | term | hour vs goals, clicks |
| 2266 | Sales Conversion by Hour | 87, 72 | term | hour vs transactions, clicks |
| 2267 | Repeat Clicks by IP | 76 | IP-VisitorID | source (medium) vs |term repeat responses |
| 2268 | Repeat Clicks by IP | 76 | IP-VisitorID | source (medium) vs |term repeat responses |
| 2261 | Time To Goal | 75 | days delta vs goals |
| 2262 | Sessions To Goal | 74 | session delta vs goals |
| 2263 | Time To Transaction | 89 | days delta vs transactions |
| 2264 | Sessions To Transaction | 88 | session delta vs transactions |