TNS-NO - NRK special report
see also / based on : Statement of Work - TNS-NO - NRK special report - KASRL - Client Service - Confluence (atlassian.net)
Objective | special exports for aggregated data in customized format |
Start Date |
|
Due date |
|
Delivery Date to customer |
|
Key outcomes | Scores-like exports due to the deactivation of Scores as analysis tool |
Status | delivered, active |
JIRA | Epic with Substories : SOU-3387 |
Dependencies | Azure feature: 847829 |
Workstream Statement
Scores-like exports due to the deactivation of Scores as analysis tool.
The customer NRK requested data-exports, basically 4 reports
See attachment “Data Extraction Specifiaction for NRK“ as initial description of the requirement
Export-location:
All exports should be available on our sftp,
Folder: /tns-nosftp/api/nrk/
Expected outcome
As Scores will be shut done in a while, there is a request to deliver the Scores-lookalike-exports to NRK directly.
All exports need to be done for localtime Norway 00:00-00:00 (same as Scores is reporting)
Report 1) streaming, for day
Report 2) streaming, for day+hour
Report 3) IAM web: for day
Report 4) IAM app: for day
Report 1:
The client is asking for a report of all PROGRAMID (CQ) in a single day reported as follows:
DATE – PROGRAMID - DEVICETYPE – CHANNEL – STREAMTYPE – VIEWS – PLAYTIME
Credentials:
streaming-report
per day
site: nrkstream & nrkradio
cq-values (basis)
Filter for CQ is
nrkstream: Channels "klipp", "programspiller" or "superspiller".
nrkradio: Channels “klipp” or “programspiller”Results splitted per devicetype (ct-variable) ‘mobil’, ‘tablet’, ‘desktop’ or ‘tv’
TOTALS: Note: the “Total” is NOT using any content-type filter. The report cannot summarize the total based on the lines containing mobil, tablet, desktop or tv because in some cases the devicetype is not set and the traffic will not be reported by any devicetype but the traffic should be included in the total in any case.
Report 2:
The client is asking for a report based on streampaths
date OR datehour | Streampath | content type - level 1 | content type - level 2 | content type - level 3 | Views | clients | total playtime |
13.08.2021 New column for splitting date and time
date | time | Streampath | content type - level 1 | content type - level 2 | content type - level 3 | Views | clients | total playtime |
Credentials:
streaming-report
hourly and daily resolution (=2 exports)
site: nrkstream
streampaths (basis)
Filter for streampaths is attached in EPIC-task (tab Report_2)
Results to be delivered for "views", "clients", “total-playtime"
Results should be partially splitted per all available ct-values. The CT-sub-values are separated by "/" in the tagging, each of them is to be reported
Example for CT-value (content-type) : ct=tv/atv/tvos
Export-example:
Report 3:
Client is asking for a report of their site-centric measurement (IAM)
Date | Site Path | Unique Clients | Unique Sessions | PageViews |
Credentials:
IAM-report
site: nrk
daily resolution, localtime 00:00 - 00:00
IAM-paths (basis)
Totals and results per Path (sections)
Results to be delivered for "unique clients", "sessions", "pageviews"
paths are attached to this task
networks are attached to this task
Additional possibility to discuss:
Instead of dealing with a fixed list of paths we could deliver a more variable approach and deliver:
every path !="mobile" beginning with the second “/” and if it’s started with “mobile” the third “/”
Note:
This will not help with the static list of paths that are currently in the "networks"
Export-example:
Report 4:
[IAM-6143] (TNS-NO) NRK: Report_4 - NRK-APP-report - spring GmbH & Co. KG (2cnt.net)
Client is asking for a reporting of their mobile apps
date | app name | app event | Views | clients |
Credentials:
IAM-APP-report
site: nrk
daily resolution, localtime 00:00 - 00:00
Appname as basis of the reporting
Appnames to be taken into consideration:
yr
nrk-tv
nrk-tv/stb
nrk-tv/tv
nrk-tv/ps
nrk-tv/ios
nrk-radio
NRK-No
NRK-Super
fantorangen
Export-example:
