Hi, Thanks for your workaround. It works for me as we are using only InStream video ads. I can match the all values.
On Tuesday, December 4, 2018 at 6:18:23 AM UTC+5:30, Zweitze wrote: > > 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, kis...@citizennet.com > 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. 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/17465a21-9b14-46a0-849a-9adcb94058f7%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
