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