search

iQMedia / tracker

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

TVision: Raw airing duration longer than creative length #10

Closed sergi0aranda closed 5 months ago

sergi0aranda commented 9 months ago

Hi @hollinger @jmylet , I was able to reproduce and dig into the issue reported by TVision:

A client brought light to a metadata issue we believe coming from Kinetiq. When looking at the raw airing data, we see that the airing duration in some records exceeds the creative length. This looks to be an ongoing occurrence across mainly unusual creative lengths.

TVision provided several OccurrenceID where this issue was present:

7035625789 7036322204 7036451655

After some analysis, I got the following numbers by calling the respective GetCreatives and GetOccurrences end points:

OccurrenceID | CreativeResourceID (GetOccu) | DurationSeconds (GetCreatives) | ADDBCreatives duration | DurationSeconds (GetOccu) | StartDateTimeUtc (GetOccu) | EndDateTimeUtc(GetOccu) | Detection Duration (End - Start) -- | -- | -- | -- | -- | -- | -- | --   |   |   |   |   |   |   |   7035625789 | AE16546-2019-45-02642 | 25 | :25 | 26 | 2020-06-19T23:40:33.657Z | 2020-06-19T23:41:00.510Z | 00:26.853 7036322204 | AE16546-2020-23-01179 | 60 | :60 | 74 | 2020-06-18T19:13:10.397Z | 2020-06-18T19:14:25.233Z | 01:14.837 7036451655 | AE16546-2019-45-02331 | 25 | :25 | 26 | 2020-06-20T07:51:09.590Z | 2020-06-20T07:51:36.443Z | 00:26.853 My Conclusion is the following: The Duration of the GetCreatives is reporting the Asset Duration (which is defined as "length of the ad to fixed values", instead of reporting the Asset Length (Length of the Asset) Approach to fixing it: I think that our best approach to fixing this issue is just to add an additional field to this table and end point that reports the actual duration of the creative and not the nominal value. This new field should be named like "DurationSecondsactual" or something like this, note that this field does exist in TTX. We should also add this value to respective tables like IQTTX.dbo.ADDBCreatives which I use all the time to query data. Please let me know if you have any questions,
sergi0aranda commented 5 months ago

This issue was resolved and customer was content with our explanation and changes proposed. Closing ticket.