Live Content Consumption Report
Introduction
This report will provide you the total list of Live contents created or uploaded in that state with the consumption matrixes for those content.
JTBD
- Jobs To Be Done: As a state admin, I want to have a look at various aspects of the content such as creation failures, etc.
- User Personas: The logged-in users who have State Admin role, Report Viewer role can access this report.
- System or Environment: Works on for desktops with Chrome browser only.
Requirement Specifications
This content consumption report generates in 3 types, For all these reports the data fields will be the same as bellow.
- Content Consumption Aggregated metrics till date
- Content Consumption Metrics for the last 6 weeks
- Content Consumption Metrics for the last weeks
STATE | BOARD | MEDIUM | Class | SUBJECT | Content-Type | CONTENT ID | Content Name | Creator (User Name) | CONTENT MIME TYPE | Created On | Last Published Date | Linked Textbook Id | Linked Textbook Name | No. of Downloads (App only) | No. of Plays (on App and Portal) | No. of Plays on App | No. of Plays on Portal | Average Play Time in mins (on App and Portal) | Average Play Time in mins on App | Average Play Time in mins on Portal | Total No of Ratings | Average Rating (Out of 5) | End Date of the Week |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Rajasthan | RJ | ENGLISH | 10 | ENGLISH | Resource | do_123456 | XYZ | MP4 | 04/10/2017 | 24/11/2017 | do_7890 | Science |
Key points:
- Display records for all published content
- The report will have one record for each content which is in "LIVE" status
- Explanation of specific fields in the report:
- [Creation Date]: The date when the content was created first time irrespective of the number of publishing cycles it might have gone
- [Creator (User Name)]: The user who created or uploaded the content on Diksha
- [Last Publish Date]: Date of publishing of current Live version
- [Linked Textbook Id]: Textbook id in which that content is linked.
- [Linked Textbook Name]: Name of the textbook for which the content is linked.
- [Total Content Downloads]: Number of times the content was downloaded on App.
- [No. Of Plays (On App and Portal)]: No. of Plays on App + No of Plays on Portal
- [Content Plays on APP]: The number of times the content was played on App.
- [Content Plays on Portal]: The number of times the content was played on the Portal.
- [Average Play Time in mins (On App and Portal)]: Average Play Time in mins on App + Average Play Time in mins on Portal.
- [Average Play Time in mins on App]:
- [Average Play Time in mins on Portal]:
- [Total No of Ratings]: Number of users rated the content.
- [Average Rating (Out of 5)]: The overall average rating rated for that content by the users.
- [End Date of the Week]:
- This will have all the contents sorted by State, Board, Medium, Class, Subject.
- This report is generated based on the state tenant.
- This report should be updated on a weekly basis.
- Last updated on Field should be shown on the top in the "content consumption metric for the last 6 weeks" report.
- This report will have only 1 table, No graphs are shown.
- In the table, the overall "Content Consumption Aggregated metrics till date" will be shown and there will be 3 download buttons on the top, One is for "content consumption Aggregated metrics till date" and followed by the other two reports.
- No table view for "Content Consumption Metrics for the last 6 weeks" and "Content Consumption Metrics for the last weeks", Only Download CSV option.
- Whenever the report is updated in portal the Last "updated on" field should show that date.
- In the portal, This report should be shown below the "Daily Usage " Report.
- When the report is downloaded the file name should be as follows
- Content aggregated metrics:- content_aggregated
- Content Consumption Metrics for the last 6 weeks:- content_consumption
- Content Consumption Metrics for the last weeks:- content_consumption_lastweek
Sample Report
- Content Consumption Aggregated metrics till date
https://docs.google.com/spreadsheets/d/1tMDUwDjwD-6x3U4Fmiu1CEQeBOIyL1em2R3lQIEOT8k/edit?usp=sharing
2. Content Consumption Metrics for the last 6 weeks
3. Content Consumption Metrics for the last weeks
Wireframes
JIRA Ticket ID
- SB-13557Getting issue details... STATUS - SB-17458Getting issue details... STATUS - SB-17609Getting issue details... STATUS
Title and the Description
Title: Content Consumption Report
Report Description: This report provides details about all content that are published and their consumption statistics. The details are specific to each state and is updated on a weekly basis.
Localization Requirements
N/A
Telemetry Requirements
Event Name | Description |
---|---|
Open Reports Page | This event is generated when a user opens Reports page in a Program. Apart from common set of data, Program Id should be captured in the event. |
Download Aggregated Metrics | This event is generated when a user clicks on "Download Aggregated Metrics" option in the Reports page. Apart from common set of data, Program Id should be captured in the event. |
Download Metrics for the last 6 weeks | This event is generated when a user clicks on "Download Metrics for the last 6 weeks" option in the Reports page. Apart from common set of data, Program Id should be captured in the event. |
Download Metrics for the last weeks | This event is generated when a user clicks on "Download Metrics for the last weeks" option in the Reports page. Apart from common set of data, Program Id should be captured in the event. |
Non-Functional Requirements
Performance / Responsiveness Requirements | Load/Volume Requirements | Security / Privacy Requirements |
---|---|---|
Report should work correctly for English and Non-English content | NA |
Impact on other Products/Solutions
N/A
Impact on Existing Users/Data
N/A
Key Metrics
Srl. No. | Metric | Purpose of Metric |
---|---|---|
Number of users downloading the Reports | Track the effectiveness of features through their usage. |