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.
