Hi Fella, Same issue here. I am facing this issue over and year ago and it's still same.
https://mail.google.com/mail/u/0/#search/forum/FMfcgzGpGBGPrqdtvZrsnWRjgxQvlgbZ Need help on me please On Wednesday, July 6, 2022 at 4:08:43 PM UTC+5:30 Oksana Sulyma wrote: > > Hello! Just wanted to confirm this issue is still actual for me. > If it is this possible for Google Ads API team to check the formula for > SUMMARY_ROW and provide it here? > Will it be more suitable to reach product team for this calculation > confirmation? > Thanks! > Oksana > On Thursday, June 23, 2022 at 12:06:25 PM UTC+3 Oksana Sulyma wrote: > >> Hi @Zweitze, thank you, this was exactly what I've tried. >> For account I check we have data in YOUTUBE_WATCH and CONTENT Networks >> only, and no matter if I aggregate data for only YOUTUBE_WATCH or >> both YOUTUBE_WATCH and CONTENT I can't get data match. The difference is >> small, like 1% - 2%, but it exists. This is why I wanted to confirm if it >> 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 Wednesday, June 22, 2022 at 6:08:07 PM UTC+3 Zweitze wrote: >> >>> 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 [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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/179d7a11-6b33-4178-b385-52df8c0429a5n%40googlegroups.com.
