Audience and Audience HH fields = 0

[sergi0aranda]

As we discussed on the last Friday call , Advocado reported that they are finding several occurrences where Audience and Audience HH fields are 0 (zero) . After some analysis, I found out the following:

• The 24 National WEST channels are 0 because these are redundant channels, so it is explained.
• There are additional (at least) 220 channels that have had 0 audience values in 2023)
• Of these 220: 105 channels have all Occurrences with audience values equal 0.
• The remaining 115 channels have certain % of Occurrences with audience values equal 0.

The summary of this findings is attached. The data I used for the 2023 analysis are samples of the daily files from the following days: 2023-01-08, 2023-04-30, 2023-05-01, 2023-05-02, 2023-05-03, 2023-05-04, 2023-05-05, 2023-10-11, 2023-10-13.

Audience & Audience hh 0_values.xlsx

[sergi0aranda]

@sergi0aranda - to check again if issue is still present.