Re: Global Average Position for Filtered Campaign Report

2013-09-05 Thread Stephane
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:

Re: Global Average Position for Filtered Campaign Report

2013-09-05 Thread Dorian Kind
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 met

Re: Global Average Position for Filtered Campaign Report

2013-09-05 Thread Stephane
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 c

Re: Global Average Position for Filtered Campaign Report

2013-09-05 Thread Stephane
Hi Brett, You did understand correctly. And I agree with you. I'm dealing with telling the hard truth to the client and give him what he wants :) If there's no way to get that number than so be it. I'll send the article to the client as well :) Thanks so much for your time. Stéphane On Th

Re: Global Average Position for Filtered Campaign Report

2013-09-05 Thread Dorian Kind
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: "AveragePositio

Re: Global Average Position for Filtered Campaign Report

2013-09-04 Thread Brett Baggott
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,

Re: Global Average Position for Filtered Campaign Report

2013-09-04 Thread Stephane
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 ge

Re: Global Average Position for Filtered Campaign Report

2013-09-04 Thread Brett Baggott
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, Sept