Well, you can't accurately aggregate those results. To do so, you would need a replacement value for "<10%" and ">90%", and, whatever you do you know you will be wrong. And even if you have none of such values I doubt the numbers add up. For instance, on campaign level the number of missed impressions because of insufficient campaign budget is included. It's doubtful such numbers are also included on lower levels. But that is a discussion to be held outside this forum, as it's not related to API.
Anyway - the only solution is to download more reports, with different settings. In our case, we also have results segmented by date, and therefore we download aggregated by day, by month, and by quarter. Not nice but there is no other way. Although requested, we decided NOT to download per week or US-week, the latter goes from Sunday till Saturday. Sacrifices are needed here. In your case I suggest to download by keyword AND group AND campaign AND account (four reports). And, if necessary, download these reports with and without segments device and network, bringing you to sixteen reports per account. Further, you mentioned you are doing this because of the sunset of average position. You should realize impression share is a different metric. Hope this helps. On Tuesday, September 17, 2019 at 12:34:34 AM UTC+2, Jamie Tomkins wrote: > > We're trying to aggregate the data pulled from the keywords performance > report up through the hierarchy - keyword>ad group>campaign>account (the > data is also segmented by device and network). However we're having issues > with the various imp. share values as the ">10%" results are making it > impossible to aggregate upwards accurately. There are big discrepancies > between our numbers and what we're seeing in the online interface > > We need some sort of view on this for internal reporting and are > struggling to come up with a solution. Is anyone else looking at doing this > with the sunsetting of avg pos/does anyone know any way around the issue? > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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/60c65451-3de8-483c-a793-3b5f9611fc87%40googlegroups.com.
