see also / based on : /wiki/spaces/KASRLCS/pages/2777088016
Objective | special exports for aggregated data in customized format |
Start Date | 07.06.2021 |
Due date |
|
Delivery Date to customer | 07.06.2021 |
Key outcomes | aggregated data export |
Status | delivered |
JIRA | IAM-6057, IAM-6124 https://kantarware.visualstudio.com/KT-KantarTagging/_workitems/edit/977984 |
Dependencies | /wiki/spaces/RESEARCH/pages/1538916548 Azure feature: 847806 |
export data for site
tv2stream
per day
Emedia is procduced with flag “de.spring.mapreduce.streaming.processPlayStates.version=V2”
(= The so called “1s-patch” is included and active)
...
Specification for FTP-delivery from TNS Scores to TV 2 V1.1.
Table structure:
Field name | Type | Comment |
Stack_NO | INTEGER | (1,2) |
Program-id | STRING |
|
Stream | STRING |
|
Content type | STRING |
|
Total_Playtime | FLOAT |
|
Total_Playtime_Client | FLOAT |
|
Views | FLOAT |
|
Views_client | FLOAT |
|
Clients | FLOAT |
|
Date | DATE |
|
All fields are as defined in https://scores.tns-cs.net/ report generation tool.
Naming convention for field names is as used in http://scores.tns-cs.net
...
Stack_NO is a generated field that divides two parts of the delivery.
It can either be 1 or 2:
Stack_NO: 1 | Stack_NO: 1 We want the unique clients and usage numbers for each node in the stream-parameter starting from the node tv2/live/* Program-id-parameter: No PROGRAM-ID-parameter.
Stream-parameter: /tv2/live/tv_2_val/linad/ It should be included in the following Stream -nodes: /tv2/live/ /tv2/live/tv_2_val / /tv2/live/tv_2_val /linad/ Content type-parameter: It should be divided by Content type at the deepest available node.
This part of the dataset should be marked with |
Stack_NO: 2 | Stack_NO: 2 We want the unique clients and usage numbers for each node in the stream-parameter starting from the node UPDATE: changed to tv2/* in March 2022 https://kantarware.visualstudio.com/KT-KantarTagging/_workitems/edit/977984 UPDATE: changed to * in March 2024 Program-id-parameter: With program-id-parameter for all program-id with registered viewing.
Stream-parameter: Most detailed stream-parameter
Most detailed content type-parameter. (Including versions for content type)
|
Expected outcome
Export example / description
Based on the request “Specification for FTP-delivery from TNS Scores to TV 2 V1.1”
Delivery-frequency: | daily |
Timerange: |
Localtime Norway 03:00 - 03:00 UPDATE: changed in March 2022 https://kantarware.visualstudio.com/KT-KantarTagging/_workitems/edit/977984 |
Format | Txt, tab separated |
Files per day | 1 |
Location |
The export is following the specification above.
...