Summary:
- Type - Dashboard Usage Summary
- Granularity - DAY
- Computation Level - Level 2
- Frequency - Runs Daily
Purpose:
The Dashboard summariser is used to compute the
Unique Devices - The total number of unique devices that have ever accessed Diksha (across portal and app)
Learning Experiences - The total number of content play sessions across portal and app to current date.
Hours of interaction - The total time spent on Diksha (i.e. total session time, inclusive of but not limited to content play sessions)
Inputs:
Derived Event : ME_WORKFLOW_SUMMARY
Output
Schema of dashboard summary
{ "eid":"ME_DASHBOARD_SUMMARY", "ets":1535417736822, "syncts":1535390695986, "ver":"1.0", "mid":"25791B1E895129968CBECD7A39C0822E", "context":{ "pdata":{ "id":"AnalyticsDataPipeline", "ver":"1.0", "model":"DashboardSummary" }, "granularity":"DAY", "date_range":{ "from":1535390585259, "to":1535390684744 } }, "dimensions":{ "pdata":{ "id":"prod.diksha.app" } }, "edata":{ "eks":{ "start_time":1535390585259, "end_time":1535390684744, "noOfUniqueDevices":100, "totalDigitalContentPublished": 10, "totalContentPlaySessions":200, "totalTimeSpent":500.96, "telemetryVersion":"3.0" } } }
Algorithm
Field | Description | Computation |
---|---|---|
noOfUniqueDevices | This metric tracks the total number of unique devices that have accessed Diksha(Portal and App) | Group by/Reduce by with below fields and compute the total distinct count app filter(dimensions.pdata.id = "prod.diksha.app") and distinctCount(did) portal filter(dimensions.pdata.id = "prod.diksha.portal") and distinctCount(did) |
totalContentPlaySessions | This metric tracks the total number of content play sessions (Portal and App). | Group by/Reduce by with below fields and aggregating the edata.eks.time_spent field app filter(dimension.pdata.id = "prod.diksha.app" and dimensions.type = "content" and dimensions.mode = "play") and aggregate(edata.eks.time_spent) Portal filter(dimension.pdata.id = "prod.diksha.portal" and dimensions.type = "content" and dimensions.mode = "play") and aggregate(edata.eks.time_spent ) |
totalTimeSpent | This metric track the total time spent on Diksha(Portal and App) | Group by/Reduce by with below fields and aggregating the edata.eks.time_spent field app filter(dimension.pdata.id = "prod.diksha.app") and aggregate( edata.eks.time_spent) portal filter(dimension.pdata.id = "prod.diksha.portal") and aggregate(edata.eks.time_spent) |