That's weird... I try the CSV and I get the total line, but without the value. See:
"CAMPAIGN_PERFORMANCE_REPORT (Aug 1, 2013-Aug 31, 2013)" Avg. position 2.0 2.3 1.7 1.2 1.8 1.4 1.1 1.7 2.2 2.2 1.8 2.3 3.6 2.4 1.9 2.6 *Total* Even if I add a dimension like campaign name I don't get the result: "CAMPAIGN_PERFORMANCE_REPORT (Aug 1, 2013-Aug 31, 2013)" Avg. position,Campaign 2.0,Gants/Manchettes [...] 1.9,Métiers - Peintres 2.6,Métier *Total, --* But! If I put the dimension first, we get the total: "CAMPAIGN_PERFORMANCE_REPORT (Aug 1, 2013-Aug 31, 2013)" Campaign,Avg. position Gants/Manchettes,2.0 [...] Métiers - Peintres,1.9 Métier,2.6 *Total,1.4* However, we need to work with the XML file so that's not going to work. Thanks for your help. I just learn something new :) Stéphane On Thursday, September 5, 2013 9:17:25 AM UTC-4, Dorian Kind wrote: > > AFAIK, every report is at least segmented by the entity it is associated > with, i.e. there is no way to get a CAMPAIGN_PERFORMANCE_REPORT not > listing metrics for individual campaigns. But like I mentioned, you can > just ignore every line except for the "Total" one, where you'll find > aggregated metrics for all the (possibly filtered) entities. > > Cheers, > Dorian > > On Thursday, September 5, 2013 3:06:33 PM UTC+2, Stephane wrote: >> >> Hi Dorian, >> >> Thank you for your reply. I did try some variations of weighed averages >> (clicks and impression), but I still can't get the right number. >> >> I guess the trick would be to group results in the Adwords report when we >> don't query for a dimension. I don't understand why we get results by >> campaign when we don't add any dimension to the query. Unless we can use >> another report than CAMPAIGN PERFORMANCE and still be able to filter on >> campaign's name? >> >> Thanks for your time. >> >> Stéphane >> >> >> >> >> On Thursday, September 5, 2013 3:10:33 AM UTC-4, Dorian Kind wrote: >>> >>> If you still want to display an average of average position, the CSV >>> reports have a total line where this metric is available. I think it's just >>> average position per campaign weighted by impressions, but it might be more >>> complicated than that. Here's an example of such a report: >>> >>> "AveragePositionTest (Sep 4, 2013-Sep 5, 2013)" >>> Campaign ID,Avg. position >>> 103660117,0.0 >>> 105956677,0.0 >>> <snip> >>> 54471157,1.3 >>> 74850877,0.0 >>> 101361157,0.0 >>> Total,1.8 >>> >>> Cheers, >>> Dorian >>> >>> >>> On Thursday, September 5, 2013 7:07:31 AM UTC+2, Brett Baggott wrote: >>>> >>>> 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.
