This document provides detailed calculation rules for various analytics charts.
The CSV or OData data exported by the Wedia APIs should be used to build these charts.
...
Each title corresponds to an entry in the menu located on the left side of the analytics module. Each subtitle corresponds to a tab located at the top of an entry in the menu. Each number within a subtitle corresponds to a chart.
Users and
...
Assets
All charts in this section are the result of batch processing. Therefore, they cannot be reproduced as mentioned in the introduction.
...
These charts are not meant to be reproduced. They combine the 50 latest download and search actions, which are not meaningful when using an export with a minimum granularity of a day.
Internal
...
Asset Usage
Usage
To build eligible charts, in the case of using CSV export, the endpoint format is: /api/wedia/analytics/odataools/dam/csv*.
...
Number -> Sum of the number of rows after filtering
Evolution -> Distribution of the sum over the period of your choice
Distribution of media asset creations by asset -> Group by asset_objectname
Distribution of creations by user -> Group by surfer_uid
List of created mediaassets -> Group by asset_name
Update
...
Number -> Sum of the number of rows after filtering
Evolution -> Distribution of the sum over the period of your choice
Distribution of media asset updates by asset -> Group by asset_objectname
Distribution of updates by user -> Group by surfer_uid
List of updated mediaassets -> Group by asset_name
Deletion
...
Number -> Sum of the number of rows after filtering
Evolution -> Distribution of the sum over the period of your choice
Distribution of actions by asset -> Group by asset_objectname
Distribution of actions by user -> Group by surfer_uid
List of updated mediaassets -> Group by asset_name
Rankings
To build eligible charts, in the case of using CSV export, the endpoint is in the following format: /api/wedia/analytics/odataools/dam/csv*
Most viewed media:
action_id | mustEquals | view |
session_type | mustNotEquals | admin |
asset_objectname | mustObjectHaveTagName | damobject |
Aggregation is then performed on the asset_name or asset_uid field.
...
action_id | mustEquals | download |
session_type | mustNotEquals | admin |
asset_objectname | mustObjectHaveTagName | damobject |
Aggregation is then performed on the asset_name or asset_uid field.
Videos
(Only present if MediaCloud is used in the environment):
action_id | mustEquals | playfinish |
session_type | mustNotEquals | admin |
asset_objectname | mustObjectHaveTagName | damobject |
asset_type | mustEquals | video |
...
_objectname | mustObjectHaveTagName | damobject |
asset_type | mustEquals | video |
Average completion percentage of a video is calculated as follows:
the player sends "playFinish" events every X% (default is 5, but configurable via an existing option of the player called "wediaStatsPlayFinishStep"),
we calculate the average of the "playFinish_percentage" events.
For the calculation, we determine the completion rate throughout the playback using the formula 100.0 * self.position() / duration.
It's important to note that if the user seeks back during playback, the sent completion rate will be the highest value calculated previously.
Average percentage of video completion: Calculate the average of "playfinish_percentage" over the period.
List of viewed videos: Group by asset_name or asset_uid.
List of fully viewed videos: Add a condition "playfinish_percentage".mustEquals(100) and group by asset_name or asset_uid.
Distribution of views by reference: The complete referer is not exported, only the domain (see next point).
Distribution of views by domain: Group by referer.
Portal
Connections
...
session_type | mustEquals | portal |
asset_objectname | mustObjectHaveTag | damobject |
action_id | mustEquals | view |
Number of viewed mediaassets: Sum of the number of rows.
Distribution of media asset views by country: Group by country.
Distribution of media asset views by role: Group by user_role_id.
Distribution of media asset views by asset: Group by asset_objectname.
List of top media asset viewers: Group by surfer_uid.
| Info |
|---|
In addition to these charts, a chart is displayed for each property that has the tag "analytics_extra" (see Wedia Analytics documentation for the functioning of this tag). No additional queries are applied to these charts. There is also a chart for the property "analytics_surfer_extra" (see Wedia documentation again). |
Downloads
To build eligible charts, in the case of using CSV export, the endpoint is in the following format: /api/wedia/analytics/odataools/dam/csv*
session_type | mustEquals | bo |
asset_objectname | mustObjectHaveTag | damobject |
action_id | mustEquals | download |
Number of downloaded mediaassets: Sum of the number of rows.
Distribution of downloads by country: Group by country.
Distribution of downloads by role: Group by user_role_id.
Distribution of downloads by asset: Group by asset_objectname.
Ranking of users by number of downloads: Group by surfer_id.
| Info |
|---|
In addition to these charts, a chart is displayed for each property that has the tag "analytics_extra" (see Wedia Analytics documentation for the functioning of this tag). No additional queries are applied to these charts. There is also a chart for the property "analytics_surfer_extra" (see Wedia documentation again). |
Search
The data used to build these charts is not exported.
...
To build eligible charts, in the case of using CSV export, the endpoint is in the following format: /api/wedia/analytics/odataools/connexion/csv*
session_type | mustEquals | bo |
Number of logged-in users: Sum of unique values of surfer_uid.
Number of connections: Sum of the number of rows.
Evolution of the number of connections: Sum of the number of rows and distribution per chosen period.
Distribution of connections by location: Group by country.
Distribution of connections by user role: Group by user_role_id.
Views
...
session_type | mustEquals | bo |
asset_objectname | mustObjectHaveTag | damobject |
action_id | mustEquals | view |
Number of viewed media: Sum of the number of rows.
Distribution of media views by country: Group by country.
Distribution of media views by role: Group by user_urole_id.
Distribution of media views by asset: Group by asset_objectname.
List of top media viewers: Group by surfer_uid.
| Info |
|---|
In addition to these charts, a chart is displayed for each property that has the tag "analytics_extra" (see Wedia Analytics documentation for the functioning of this tag). No additional queries are applied to these charts. There is also a chart for the property "analytics_surfer_extra" (see Wedia documentation again). |
Downloads
To build eligible charts, in the case of using CSV export, the endpoint is in the following format: /api/wedia/analytics/odataools/dam/csv*
session_type | mustEquals | bo |
asset_objectname | mustObjectHaveTag | damobject |
action_id | mustEquals | download |
Number of downloads: Sum of the number of rows.
Distribution of downloads by country: Group by country.
Distribution of downloads by role: Group by user_role_id.
Distribution of downloads by asset: Group by asset_objectname.
Ranking of users by number of downloads: Group by surfer_uid.
| Info |
|---|
In addition to these charts, a chart is displayed for each property that has the tag "analytics_extra" (see Wedia Analytics documentation for the functioning of this tag). No additional queries are applied to these charts. There is also a chart for the property "analytics_surfer_extra" (see Wedia documentation |
...
). |
Search
To build eligible charts, in the case of using CSV export, the endpoint is in the following format: /api/wedia/analytics/odataools/fulltext/csv*
session_type | mustEquals | bo |
asset_objectname | mustObjectHaveTag | damobject |
action_id | mustEquals | search |
Number of searches: Sum of the number of rows.
Distribution of searches by success: Group by actionid.
Distribution of full-text searches by language: Group by fulltextLocales.
Distribution of searches by user: Group by surfer_uid.
Most searched terms in full-text: Group by fulltext.
Filters
...
session_type | mustIn | “cdnakamai”,“cdnamazon” |
asset_objectname | mustObjectHaveTag | damobject |
referer | mustNotEquals | “your server name” |
Number of hits: Sum of the number of rows.
Evolution of the number of hits: Sum and distribution per chosen period.
Distribution of hits by country: Group by country.
Distribution of hits by pages: Not exported in the CSV, only reference domains.
Distribution of hits by referring domain: Group by referer.
Distribution of hits by media: Group by asset_name or asset_uid.
...
session_type | mustNotEquals | admin |
asset_objectname | mustEquals | monodoc |
Number of created documents: Add a condition "actionid".mustEquals("insert") and sum the number of rows.
Number of users who created a document: Add a condition "actionid".mustEquals("insert") and sum the number of unique values in the surferuid field.
Number of check-ins: Add a condition "actionid".mustEquals("w2p_cico_checkint") and sum the number of rows.
Number of checkouts: Add a condition "actionid".mustEquals("w2p_cico_checkout") and sum the number of rows.
Evolution of the number of created documents: Add a condition "actionid".mustEquals("insert") and distribute by period.
Evolution of the number of compositions: Add a condition "actionid".mustEquals("w2p_user_sendwxml") and distribute by period.
Users with the most check-ins and checkouts: Add a condition "actionid".mustIn("w2p_cico_checkin", "w2p_cico_checkout") and group by the surfer_uid field.
Documents with the most check-ins and checkouts: Add a condition "actionid".mustIn("w2p_cico_checkin", "w2p_cico_checkout") and group by asset_uid or asset_name.
Users who created the most documents: Add a condition "actionid".mustEquals("insert") and group by surfer_uid.
Documents with the most compositions during the period: Add a condition "actionid".mustEquals("w2p_user_sendwxml") and group by asset_uid or asset_name.
...
session_type | mustNotEquals | admin |
asset_objectname | mustIn | monodocmodel, zsnippet |
Number of created modelstemplates: Add a condition "actionid".mustEquals("insert") and sum the number of rows.
Number of users who created a modeltemplate: Add a condition "actionid".mustEquals("insert") and sum the number of unique values in the surferuid field.
Number of check-ins: Add a condition "actionid".mustEquals("w2p_cico_checkint") and sum the number of rows.
Number of checkouts: Add a condition "actionid".mustEquals("w2p_cico_checkout") and sum the number of rows.
Users with the most check-ins and checkouts: Add a condition "actionid".mustIn("w2p_cico_checkin", "w2p_cico_checkout") and group by the surfer_uid field.
Models Templates with the most check-ins and checkouts: Add a condition "actionid".mustIn("w2p_cico_checkin", "w2p_cico_checkout") and group by asset_uid or asset_name.
Users who created the most modelstemplates: Add a condition "actionid".mustEquals("insert") and group by surfer_uid.
Most used snippets in a document: Add a condition "objectname".mustEquals("zsnippet") and group by asset_uid or asset_name.
Most used models templates to create a project: Add a condition "actionid".mustEquals("used_media_created") and group by asset_uid or asset_name.
...