In this final part of our series on how to analyze the content interaction data available on SmartUp, you will learn the Hour of Day and Day of Week analyses.
If you haven't already read the first 2 parts of this series, you can find out how to calculate user adoption and find out which users have not logged in in Part 1 and how to calculate total the total number of content and the content completion rate in Part 2.
The Hour of Day and Day of Week analyses are useful to see the content consumption trends for users in your community. The Hour of Day analysis breaks down your users' content interaction by the hours of the day. This is particularly helpful to see if your users are consuming content outside of office hours.
In contrast, the Day of Week analysis breaks down user interaction with the community content based on what days content is being consumed. Similar to the Hour of Day analysis, the Day of Week analysis is helpful when you want to find out how much content is being consumed outside of the workweek i.e. Saturdays and Sundays.
Before you run the two analyses, you will need to add additional columns into your content interaction data on Excel. The steps can be found in Part 1.
Hour of Day
To begin the analysis, highlight any cell in your content interaction data and insert a PivotChart into a new worksheet.
In the PivotChart Fields, add the Hour of Day field into the Axis (Categories) section and Action into the Values section.
The resulting chart will show you the distribution of the hours that users in your community have consumed content. The horizontal axis shows the hour of the day (based on 24 hours) and the vertical axis shows the number of pieces consumed at each hour.
Day of Week
The Day of Week analysis is very similar to Hour of Day, but with some very minor differences.
To start, click on any cell in your original content interaction data and insert a PivotTable into a new worksheet.
Next, add the Day of Week field into the Rows section and the Action field into the Values section.
The resulting table will look like the example below.
To convert the data into days of the week, copy the data into a separate section of the same sheet without headers and the Grand Total, and replace 1-7 with Monday-Sunday respectively.
Next, highlight the data in the newly copied cells and insert a new chart, specifically the Clustered Column type, which can be found under 2-D Column.
You will then be able to see the Day of Week graph, based on which days of the week users are consuming content in your community.
That brings us to the end of the series on how to analyze the content interaction data that is available on SmartUp. If you require more assistance or have suggestions on further analytics guides you would like to see, feel free to write into our support team at support@smartup.io.