Advertising dropout statistics

Modified on Wed, 30 Aug, 2023 at 2:28 PM

Change history:
                     11-15-2022         Initial version
                    02-16-2023      Add JSON output format 


Case study for : 


- Hourly advertising volume

  • Per day
  • Over a given period


- Detailed statistics

  • Number of breaks per day
  • Total duration per day (ms / hh:mm:ss)
  • Average per hour

 

 

Limitations :

  • Be an Okast customer 
  • Have an Okast Channels instance + credentials
  • One call per owned instance



General usage syntax for _getSCTEInfo

The call URL is as follows

https://<URL_de_mon_instance>/synthesia/okast-channels/webservices/getSCTEInfo.php


Paramètres généraux

ParameterFormatDescriptionMandatory
fromdate (yyyy-mm-dd)Set report start dateYes
daysinteger (> 0)Define report analysis durationYes
formatjson

Define specific data format for output

No


Example queries

1 week report - Raw data

https://okast.easytools.tv/synthesia/okast-channels/webservices/getSCTEInfo.php?from=2022-11-01&days=30https://okast.easytools.tv/synthesia/okast-channels/webservices/getSCTEInfo.php?from=2023-10-01&days=30


Answer

Break Stats
2023-01-01
# of breaks    Total duration (ms)    Total duration (time)    Adv. minutes per hour
37    8880000    02:28:00    6.1666666666667
2023-01-02
# of breaks    Total duration (ms)    Total duration (time)    Adv. minutes per hour
38    9120000    02:32:00    6.3333333333333
2023-01-03
# of breaks    Total duration (ms)    Total duration (time)    Adv. minutes per hour
43    10320000    02:52:00    7.1666666666667


1-week report - JSON

https://okast.easytools.tv/synthesia/okast-channels/webservices/getSCTEInfo.php?from=2023-01-01&days=3&format=json

Answer

{
    "2023-01-01": {
        "breaks_number": 37,
        "breaks_global_duration_ms": 8880000,
        "breaks_minutes_per_hour": 6.166666666666667,
        "breaks_global_duration_time": "02:28:00"
    },
    "2023-01-02": {
        "breaks_number": 38,
        "breaks_global_duration_ms": 9120000,
        "breaks_minutes_per_hour": 6.333333333333333,
        "breaks_global_duration_time": "02:32:00"
    },
    "2023-01-03": {
        "breaks_number": 43,
        "breaks_global_duration_ms": 10320000,
        "breaks_minutes_per_hour": 7.166666666666667,
        "breaks_global_duration_time": "02:52:00"
    }
}