Stephane, if I understand you correctly, you're saying that when looking at your Adwords user interface, you can filter campaigns a certain way and when you do, you will see a "total filtered average position" represented as one number at the bottom of your filtered list of campaigns. However, when you try to run a Campaign Performance Report using the Adwords AP, using similar filters/predicatesI, it only shows you an average position per campaign without showing you an overall "total filtered average position"?
If I understand you correctly, I don't think you are going to find an exact match for that "total filtered average position" you see on the Adwords user interface from anything the Adwords API can provide. I absolutely _hate_ it when someone answers my questions by telling me I don't need what I'm asking for, but, I'm still going to say it, I don't think you need what you're asking for. If you read that article, even the per campaign average position can be very misleading. If you are basing decisions on some further "average of averages", I would think you're headed in the wrong direction. I may have completely misunderstood what you're asking, and if so, my apologies. Also, please forgive me in advance for telling you that you don't need what you seem to be asking for. I really do hate it when people tell me that. But please, take the time to read that article. On Wednesday, September 4, 2013 6:57:25 PM UTC-5, Stephane wrote: > > Hi Brett, > > Thanks for the reply and for your article. I agree the division isn't the > best idea. Actually, I'm wondering if there's a way to get the bottom line, > i.e. one row of result for the whole query, instead of 15 separate results > when we don't query any dimension. There must be a way to get only one row > with the desired metric. Maybe the campaign report isn't the right one to > query for, but I don't see what report we could use when we filter on the > campaign name. > > In short, we want to get the 1.9 of the attached file. ie. the overall > avg. position for the query, not all rows with every specific avg. position. > > Any idea is welcome! > > Thanks, > > Stéphane > > > > On Wednesday, September 4, 2013 5:46:37 PM UTC-4, Brett Baggott wrote: >> >> I think this article will help: >> >> >> http://searchenginewatch.com/article/2257046/Say-Goodbye-to-AdWords-Average-Position-Hello-to-Top-of-Page-Rate >> >> I think the problem here is that you are assuming that "sum all the above >> and divide by 15" is the correct math. I don't think it is. >> >> On Wednesday, September 4, 2013 1:00:34 PM UTC-5, Stephane wrote: >>> >>> Hi, >>> >>> We are having some trouble getting the global Average position for >>> filtered campaigns. >>> >>> Here's how it goes: >>> >>> Report: CAMPAIGN_PERFORMANCE_REPORT >>> >>> Predicates: >>> >>> #1 Campaign name doesn't include "some text" >>> #2 Ad Network is Search >>> >>> Fields: Average Position >>> >>> *Response:* >>> >>> <?xml version='1.0' encoding='UTF-8' standalone='yes'?> >>> <report> >>> <report-name name='CAMPAIGN_PERFORMANCE_REPORT'/> >>> <date-range date='Aug 1, 2013-Aug 31, 2013'/> >>> <table> >>> <columns> >>> <column name='avgPosition' display='Avg. position'/> >>> </columns> >>> <row avgPosition='2.0'/> >>> <row avgPosition='2.3'/> >>> <row avgPosition='1.7'/> >>> <row avgPosition='1.2'/> >>> <row avgPosition='1.8'/> >>> <row avgPosition='1.4'/> >>> <row avgPosition='1.7'/> >>> <row avgPosition='2.2'/> >>> <row avgPosition='2.2'/> >>> <row avgPosition='1.8'/> >>> <row avgPosition='2.3'/> >>> <row avgPosition='3.6'/> >>> <row avgPosition='2.4'/> >>> <row avgPosition='1.9'/> >>> <row avgPosition='2.6'/> >>> </table> >>> </report> >>> >>> Obviously, we get Avg. Position for all of our campaigns. What we want >>> is the global average position like we see in Adwords reports within the >>> "Total - filtered" row. >>> >>> If we sum all the above and divide the result by 15, we get 2.1, but in >>> Adwords, it shows 1.9 (see attached). How can we get this 1.9? >>> >>> Is there any way we can get that result given the predicates we have to >>> use? Account report doesn't work because of the campaign name filter. >>> >>> Any idea is appreciated. Thanks in advance. >>> >>> Stéphane >>> >>> >>> >>> >>> >>> >>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords 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 Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
