If you look at the top row, you see seven impressions, of which 50% was a top impression. That is a red flag. More rows have this problem.
You should realize that top impressions are only available on the search network. This particular adgroup probably shows ads on other networks as well, like the display network, and/or the shopping network, and/or search partners, and/or YouTube. These networks do have impressions but not top impressions - so these impressions should be discarded from your calculation. To see if this is the case: in the web interface, try looking at the numbers with segmentation on Network. To get the right calculation: Try adding a filter on NetworkType (AdNetworkType2 in AdWords API), and see how that works out. Let us know if you find other explanations! On Thursday, November 26, 2020 at 11:55:00 AM UTC+1 fru...@adzlocal.de wrote: > Hi all, > > given the metrics data of the last 14 days of an adgroup (e.g. > metrics.impressions, metrics.absolute_top_impression_percentage for each > single day) > i'm trying to calculate the cumulated absolute_top_impression_percentage > value for that period. > I know i can get that value simply via api request - but i'd like to > understand the logic / calculation behind that values. > > For example i have following datasets, copied from a specific adgroup via > performance data report in My Client Centre (MCC) segmented by day: > > day impressions absolute_top_impression_percentage > impressions*absolute_top_impression_percentage > 20201125 7 50 350 > 20201124 5 66.67 333.35 > 20201123 12 25 300 > 20201122 0 0 0 > 20201121 0 0 0 > 20201120 31 50 1550 > 20201119 9 66.67 600.03 > 20201118 4 66.67 266.68 > 20201117 13 87.5 1137.5 > 20201116 13 77.78 1011.14 > 20201115 0 0 0 > 20201114 0 0 0 > 20201113 9 40 360 > 20201112 5 60 300 > > I put those numbers in a spreadsheet, if you like: > https://docs.google.com/spreadsheets/d/1FNMpNLKWi8Jz4yft--_rjQHtMMxFhn2conZcwU6RGe8/edit?usp=sharing > > What i would do to calculate the cumulated > absolute_top_impression_percentage (weighted average value): > > absolute_top_impression_percentage_14days > = SUM(impressions*absolute_top_impression_percentage) / SUM(impressions) > = (7*50 + 5*66.67 + 12*25 + 0*0 + 0*0 + 31*50 + 9*66.67 + 4*66.67 + > 13*87.5 + 13*77.78 + 0*0 + 0*0 + 9*40 + 5*60) / 108 > = 6208.7/108 > = 57.4879... % > > But the mcc shows 59.32% for that adgroup.. so can anyone throw some light > on how this value is calculated? > > Regards > Frank > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/81477226-cd0e-4b57-bc12-709cfc00896an%40googlegroups.com.
