# Hackathon | 14.06 — Data

来源：https://www.kaggle.com/competitions/hackathon-14/data

本地 Meta Kaggle 快照；不是本次实时页面。

# Dataset Description

### What is the table schema?
- **fullVisitorId**: The unique visitor ID.
- **visitStartTime**: The timestamp (expressed as POSIX time).
- **date**: The date of the session.
- **deviceCategory**: The type of device (Mobile, Tablet, Desktop).  
- **isMobile**: If the user is on a mobile device, this value is true, otherwise false.	
- **operatingSystem**: The operating system of the device (e.g., "Macintosh" or "Windows").	
- **browser**: The browser used (e.g., "Chrome" or "Firefox").
- **country**: The country from which sessions originated, based on IP address.
- **city**: Users' city, derived from their IP addresses or Geographical IDs  
- **trafficSource**: The source of the traffic source. Could be the name of the search engine, the referring hostname, or a value of the utm_source URL parameter.  
- **trafficMedium**: The medium of the traffic source. Could be "organic", "cpc", "referral", or the value of the utm_medium URL parameter.	
- **trafficCampaign**: The campaign value. Usually set by the utm_campaign URL parameter.  	
- **isFirstVisit**: 1 if this is the first visit made by the visitor, otherwise 0.
- **isBounce**: 1 if the visitor went to only one webpage and did not come back, otherwise 0.
- **totalVisits**: The total number of visits by the visitor across sessions.  
- **totalHits**: The total number of interactions across sessions. 
- **totalPageviews**: The total number of page views across sessions. 	
- **totalTimeOnSite**: The total time on site.
- **totalTransactions**: The total number of interactions across sessions. 	
- **productPagesViewed**: The number of product pages viewed in the session.
- **addedToCart**: If the visitor added an item to the cart or made further downstream actions (checkout, transaction), otherwise 0 (if the visitor only browsed but never added an item to the cart).  

### What does the training data look like?
```
 SELECT   
   *   
 FROM  
   kaggleworkshops.google_analytics_sample_eu.train  
 LIMIT 20
```

### What does the testing data look like?
```
 SELECT   
   *   
 FROM  
   kaggleworkshops.google_analytics_sample_eu.test  
 LIMIT 20
```