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/e9287cae-93b8-4d33-a6f2-719b80dfddden%40googlegroups.com.
