I dealt with this some time ago - see https://groups.google.com/g/adwords-api/c/oYvpfH1HsvY/m/8pkMydT7AwAJ and for background (also mentioned in previous message) https://groups.google.com/d/msg/adwords-api/KLLiGbhnHAA/EnUhS7_LBgAJ
So that was three to five years ago, and we had to use AdGroup reports to figure out how to aggregate these numbers. In the mean time Google Ads changed, in the UI the segment "View Type" no longer exists, and segment "Network" seems to fulfill this function. In the API you could try to segment on ad_network_type which now has enums for the youtube networks: What was previous called "In-stream" is now called YOUTUBE_WATCH, and previous "Discovery" is now YOUTUBE_SEARCH If you can't get the numbers right, try the workaround with AdGroup reports. On Tuesday, June 21, 2022 at 10:34:29 AM UTC+2 Oksana Sulyma wrote: > Hi! > Any insight on my question will be highly appreciated. > Thanks! > > On Friday, June 17, 2022 at 6:40:05 PM UTC+3 Oksana Sulyma wrote: > >> Yes I know about summary_row_setting >> <https://developers.google.com/google-ads/api/reference/rpc/v11/SearchGoogleAdsStreamRequest?hl=en> >> to SUMMARY_ROW_WITH_RESULTS >> <https://developers.google.com/google-ads/api/reference/rpc/v11/SummaryRowSettingEnum.SummaryRowSetting?hl=en> >> . >> In our system we store daily data and use formulas like summary, average, >> etc to show totals for any date range customer requests WITHOUT making new >> API calls. So I'm interested in formula to get the same summary row values >> based at daily values. >> For Video played to 25% total value for May, I get 42.23% using daily >> values and formula SUM(video_quartile25_rate*impression)/SUM(impression) >> while summary row has 41.73%. So I wonder what is wrong with my formula. >> How is summary calculated at GOogle Ads API side? >> Thanks again for looking at this! >> Oksana >> On Friday, June 17, 2022 at 6:24:55 PM UTC+3 adsapi wrote: >> >>> Hi Oksana, >>> >>> Thank you for the log and the screenshot. I set the summary_row_setting >>> <https://developers.google.com/google-ads/api/reference/rpc/v11/SearchGoogleAdsStreamRequest?hl=en> >>> to SUMMARY_ROW_WITH_RESULTS >>> <https://developers.google.com/google-ads/api/reference/rpc/v11/SummaryRowSettingEnum.SummaryRowSetting?hl=en> >>> and >>> your query results match your UI results. This looks like it is working as >>> intended. >>> >>> Regards, >>> >>> [image: Google Logo] >>> Aryeh >>> 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/6930201a-e255-4442-89ae-4208086db72fn%40googlegroups.com.
