On the AdWord webpage what is the formula for aggregated percent viewed statistics?
I choose a date range of just one day the 25%, 50%, 75% and 100% video played to numbers on the web page and the corresponding numbers a downloaded xls file agree. But if I do the calculation by hand, the numbers do not match what's displayed on the web page (or in the "totals" row of the download.)
"Calculating by hand" means, for example,
for each row multiply the 25% view column by video views column to get the number of 25% views.
Sum all of these for all campaigns and divide by the total number of views. (/100 to convert to percent finally)
Happy to privately share send an xls demonstrating the problem.