Advertising dropout statistics

Modified on Wed, 30 Aug 2023 at 02: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

Parameter	Format	Description	Mandatory
from	date (yyyy-mm-dd)	Set report start date	Yes
days	integer (> 0)	Define report analysis duration	Yes
format	json	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"
    }
}