Well, my point was that your aggregation formula SUM(video_quartile25_rate*impression)/SUM(impression) is essentially correct, but beware of the field impression. Make sure you ONLY include impressions for YOUTUBE_WATCH, and NEVER include impressions of the other networks.
What you could try is use the Web UI, select the fields like you have in your opening post. Then add segmentation for Network. Add a filter for one campaign. Try to see if you can figure out the summary results for the quartile - shouldn't be hard because there's only one campaign. Next, change the filter, add a second campaign. See if you can still determine the summary results. Then a third. Try a campaign that contains not only youtube network, but also other networks. Remember: segmenting is the important thing to do here. Without segmenting you probably cannot validate the aggregation formula. On Wednesday, June 22, 2022 at 3:58:40 PM UTC+2 Oksana Sulyma wrote: > > @Zweitze, thanks for information. > I've made different experiments based at our comment, but unfortunately > still see the discrepancy. > For account I look at we have data for CONTENT and YOUTUBE_WATCH networks, > no data for YOUTUBE_SEARCH. > Speaking of ad_group.type > <https://developers.google.com/google-ads/api/fields/v11/ad_group#ad_group.type>, > > I've tried different combinations of filters for > VIDEO_BUMPER > VIDEO_EFFICIENT_REACH > VIDEO_NON_SKIPPABLE_IN_STREAM > VIDEO_OUTSTREAM > VIDEO_RESPONSIVE > VIDEO_TRUE_VIEW_IN_DISPLAY > VIDEO_TRUE_VIEW_IN_STREAM > and still with no luck. > This way I still need assistance here. > Is this possible For Google Ads API team to check the formula for > SUMMARY_ROW and provide it here, as SUMMARY_ROW matches Google Ads UI. > Thanks! > Oksana > On Tuesday, June 21, 2022 at 6:43:00 PM UTC+3 adsapi wrote: > >> Hi, >> >> @Zweitze >> Thank you for giving a workaround solution to the problem encountered by >> Oksana. We gratefully appreciate it. >> >> @Oksana >> If you have additional questions, feel free to send those over to our >> team and we would be happy to assist you further. >> >> Best regards, >> [image: Google Logo] >> Heidi >> Google Ads API Team >> >> >> ref:_00D1U1174p._5004Q2bwxlr:ref >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/d92aeb57-7c0d-4249-928a-980eeb91049fn%40googlegroups.com.
