This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
"query": "SELECT COUNT(userSessionId) AS [User Sessions], city AS [City], region as [State/Province], country AS [Country] FROM usersession GROUP BY city, country,region ORDER BY count(userSessionId) DESC",
"type": "TABLE",
"limit": 50
},
{
"name": "User Sessions Query",
"tileType": "DTAQL",
"configured": true,
"bounds": {
"top": 190,
"left": 684,
"width": 190,
"height": 190
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "Unique Users in Selected Timeframe",
"query": "SELECT COUNT(DISTINCT userId) AS [Users] FROM usersession",
"type": "SINGLE_VALUE",
"timeFrameShift": "dynamic",
"limit": 50
},
{
"name": "User Sessions Query",
"tileType": "DTAQL",
"configured": true,
"bounds": {
"top": 190,
"left": 418,
"width": 266,
"height": 190
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "New Users in Selected Timeframe",
"query": "SELECT COUNT(newUser) AS [New Users] FROM usersession where newUser = true AND userType IS \"REAL_USER\"",
"type": "SINGLE_VALUE",
"timeFrameShift": "dynamic",
"limit": 50
},
{
"name": "User Sessions Query",
"tileType": "DTAQL",
"configured": true,
"bounds": {
"top": 380,
"left": 684,
"width": 342,
"height": 304
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "User Sessions by Browser Version",
"query": "SELECT COUNT(userSessionId) AS [User Sessions], browserMajorVersion AS [Browser Version] FROM usersession where userType = \"REAL_USER\" GROUP BY browserMajorVersion",
"type": "TABLE",
"limit": 50
},
{
"name": "User Sessions Query",
"tileType": "DTAQL",
"configured": true,
"bounds": {
"top": 380,
"left": 1026,
"width": 304,
"height": 304
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "User Sessions by Browser Type",
"query": "SELECT COUNT(userSessionId) AS [User Sessions], browserType AS [Browser Type] FROM usersession WHERE userType IS \"REAL_USER\" GROUP BY browserType",
"type": "TABLE",
"limit": 50
},
{
"name": "User Sessions Query",
"tileType": "DTAQL",
"configured": true,
"bounds": {
"top": 684,
"left": 684,
"width": 342,
"height": 304
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "User Sessions by Browser Family",
"query": "SELECT COUNT(userSessionId) AS [User Sessions], browserFamily AS [Browser Family] FROM usersession WHERE userType IS \"REAL_USER\" GROUP BY browserFamily",
"type": "TABLE",
"limit": 50
},
{
"name": "User Sessions Query",
"tileType": "DTAQL",
"configured": true,
"bounds": {
"top": 684,
"left": 1026,
"width": 304,
"height": 304
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "User Sessions by Client OS",
"query": "SELECT COUNT(userSessionId) AS [User Sessions], osVersion AS [OS Version], osFamily AS [OS Family] FROM usersession WHERE userType IS \"REAL_USER\" GROUP BY osVersion, osFamily",
"type": "TABLE",
"limit": 50
},
{
"name": "Key User Actions Duration (Avg.) - XHR Actions",
"query": "SELECT DISTINCT userId AS [User], COUNT(DISTINCT userSessionId) AS [Sessions] FROM usersession where userType =\"REAL_USER\" and userId IS NOT NULL GROUP BY userId",
"query": "SELECT COUNT(usersession.startTime) AS [Pages] FROM useraction ",
"type": "SINGLE_VALUE",
"limit": 50
},
{
"name": "User Sessions Query",
"tileType": "DTAQL",
"configured": true,
"bounds": {
"top": 228,
"left": 1938,
"width": 608,
"height": 494
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "Top Pages",
"query": "SELECT DISTINCT name AS [Page], COUNT(requestStart) AS [Count], AVG(duration) AS [Avg Duration] FROM useraction GROUP BY name ORDER BY Count DESC",
"type": "TABLE",
"limit": 50
},
{
"name": "User Sessions Query",
"tileType": "DTAQL",
"configured": true,
"bounds": {
"top": 722,
"left": 1938,
"width": 608,
"height": 494
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "Slowest Pages",
"query": "SELECT DISTINCT name AS [Page], COUNT(requestStart) AS [Count], AVG(duration) AS [Avg Duration] FROM useraction GROUP BY name ORDER BY avg(duration) DESC",