Hello, I struggled with this exact question a year and a half ago. You are talking about InStream video ads. For those ads, metric Impressions states the number of videos that were started. VideoQuartile25Rate is the percentage of those starts, where the video was shown for at least 25 percent, VideoQuartile50Rate is the percentage where the video was shown for at least 50 percent etc.
So, your calculation is (in SQL notation): SUM(Impressions * VideoQuartile25Rate) / SUM(Impressions) But... Video campaigns may have two different types of video ads: InStream and VideoDiscovery. VideoDiscovery are ads shown in the search page, and there Impressions have a different meaning for those ads: the number of times that the ad was shown in the search results page. However, VideoDiscovery does not support VideoQuartileXXXRate metrics. In other words, the calculation breaks when a campaign has both InStream and VideoDiscovery ads. So how do you distinguish the number of Impressions for InStream ads, from Impressions for VideoDiscovery ads? See my question *in this topic* <https://groups.google.com/d/msg/adwords-api/m-9HNKWwdu0/pynoK2MvBgAJ> 18 months ago. In short: AdWords Web UI features a segmentation called "View Type" allowing to separate InStream metrics from VideoDiscovery metrics, and allows to distinguish the impressions between the video types. This segmentation is exactly what we need for our calculations. Is this segmentation "Video Type" supported in AdWords API as well? The answer was no, there is no timeframe, check the blog, blablabla. To my knowledge this has not been added (yet). So the answer is: if you have campaigns with both InStream ads, and VideoDiscovery ads, there is no way. But there is a workaround. Although campaigns can contain both InStream and VideoDiscovery ads, ad groups can only contain one of those - not both. You can nowadays look that distinction up in attribute AdGroupType, it has value YOUTUBE_WATCH for InStream ads, and YOUTUBE_SEARCH for VideoDiscovery ads. (Note: those values appeared a few months after my question, so that's why this workaround was not described in forementioned topic). Thus, the workaround is to use ADGROUP_PERFORMANCE_REPORT with a predicate on AdGroupType=YOUTUBE_WATCH, then do the same calculation. If you also want to show Impressions, Clicks, Cost etc. as well, you need to omit the predicate, and also request AdGroupType, and change the calculation accordingly. When I tested this the numbers matched exactly. I hope this helps. I would appreciate if you posted your findings - when they match or not match, in the latter case I have to look at this again as well... On Friday, November 30, 2018 at 12:20:12 PM UTC+1, [email protected] wrote: > > I am fetching last 7 days campaign performance reports through API. Now I > want to calculate the all metric values at the current day from last 7 days. > To calculate video_view_rate I have added all VideoViews divided by sum of > impressions( from docs) which will gives me the exact answer. > > In the same way I want to calculate for other metrics which are > video_played_to_25%, video_played_to_50%. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/3cec8033-c369-4665-b99d-9a9b5e0b77f5%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
