The Schema

The Scitylana Data extraction consists of the following dimesions and metrics

The data is delivered in 1 table. Each dimension or metric is represented by a single column. Each row is equal to a hit. A hit is either a Page View, Screen view, Event, Transaction or Other.
The schema is designed to be fact only. This means it is trimmed for deducted/filtered dimensions. But there are some filtered metrics (bounces, goals) which we added for your convenience – but we recommend bulding these metricsĀ  in SQL or favorite query language. Google Analytics metrics are very broad-purposed and typically not what your business needs.

Scitylana Hit Level
sl:ident
sl:sessionid
sl:hitorder
sl:pagevieworder
sl:hittype
sl:timeStamp
sl:propertyId
sl:viewId

User
ga:userType
ga:clientId
ga:sessionCount
ga:userBucket

Session 
ga:bounces
ga:sessionDuration

Traffic Sources
ga:fullReferrer
ga:campaign
ga:source
ga:medium
ga:keyword
ga:adContent
ga:campaignCode

Adwords
ga:adwordsCreativeID

Goal Conversions
ga:goalXXCompletions (XX = 1-20)

Platform or Device
ga:browser
ga:browserVersion
ga:operatingSystem
ga:operatingSystemVersion
ga:deviceCategory
ga:browserSize

Geo Network
ga:continent
ga:subContinent
ga:country
ga:region
ga:metro
ga:city
ga:latitude
ga:longitude
ga:networkLocation
ga:countryIsoCode
ga:regionIsoCode
ga:subContinentCode

System
ga:language
ga:screenResolution

Page Tracking
ga:hostname
ga:pagePath
ga:pageTitle
ga:landingPagePath
ga:secondPagePath
ga:exitPagePath
ga:previousPagePath
ga:timeOnPage

Event
ga:eventCategory
ga:eventAction
ga:eventLabel
ga:eventValue
ga:totalEvents

Ecommerce
ga:productSku
ga:productName
ga:currencyCode
ga:transactionRevenue

Custom Dimensions
ga:dimensionXX (XX = 1-20)

Channel Grouping
ga:channelGrouping

App Tracking
ga:screenName
ga:appName
ga:appId
ga:appVersion
ga:appInstallerId
ga:timeOnScreen

// Type writer effect