search

iQMedia / tracker

Repo to hold all customer facing platform and data issues.
0 stars 0 forks source link

GetCreatives reporting Duration = 0 for creatives from 17314(Australia) - reported by Nexxen #16

Closed sergi0aranda closed 7 months ago

sergi0aranda commented 7 months ago

Please check the GetCreatives endpoint as it is reporting Duration = 0 seconds for all creatives when filtering by the RegionIDs= [ 17314], below are some examples.... but from what I have seen , all creatives are being reported with Duration = 0 for this Region.

GetCreatives | Duration -- | --   |     |   AE17314-2023-48-00455 | 0 AE17314-2023-48-00457 | 0 AE17314-2023-48-00458 | 0 AE17314-2023-52-00353 | 0 AE17314-2023-52-00358 | 0
sergi0aranda commented 7 months ago

hi @hollinger , @jmylet just to confirm what I commented today, this issue is coming from our end, TTX does NOT report Duration (Seconds) = 0. Example below for AE17314-2023-51-00077:

The GetCreatives reports:

"Category": "Services", "CategoryID": "MF17314-008-O00015", "Category2": "", "Category2ID": "", "CreatedDateTimeUtc": "2023-12-18T06:41:34.957Z", "Description": "", "DurationSeconds": 0, "FirstAiringDateTimeUtc": "2023-12-17T19:29:23.557Z", "IsDeleted": false, "IsPromo": false, "LastAiringDateTimeUtc":

And Teletrax reports:

Screenshot 2024-02-28 at 4 13 25 PM

Perhaps for 17314 we are grabbing the field at the end on the example above, the one that is empty under "Asset: Duration"?

jmylet commented 7 months ago

GetCreatives Duration is pulled from a metadata field named "duration" for all creatives regardless of region. No Australian asset has an actual value for this field, which can be seen in the "Asset: Duration" column on teletrax whereas the "Asset: Length" column does have a value (likely from SQL civ.Assets.Length) though these values are not returned from GetCreatives.

In order for GetCreatives to report a non-0 duration for Australian creatives the duration metadata fields will need to be updated with real values.