Hello, Apologies that this is causing frustration. It's true that it's not possible to filter out entries in your AdWords API scheduled reports with the same control available for reports scheduled via the web interface. I believe that the rationale for that is to give developers as much information as possible, with the understanding that they can post-process and filter out whatever information they don't need-- something that is usually not the case with non-developers who are running reports via the web interface.
As for the size of your report, an obvious first recommendation is to make sure that you're not requesting zero-impression keywords, as they obviously will also have zero clicks. In addition to that, there are a couple of other filtering options you can use to limit your results, including requesting keywords for campaigns and ad groups that are active (as presumably there will be zero clicks for keywords in inactive campaigns/ad groups). All of these are options on the DefinedReportJob object: http://code.google.com/intl/ja/apis/adwords/docs/developer/DefinedReportJob.html Finally, instead of requesting one large cross-client report you can split your reports up into two or three reports with a half or a third of the clientEmails listed for each one. Cheers, -Jeff Posnick, AdWords API Team On Dec 11, 4:12 am, api dev cz <[EMAIL PROTECTED]> wrote: > I need to run a report via the API that contains keyword id and number > of clicks across all our accounts. I am not interested in keywords > which have 0 clicks. I can run the report and get all keywords and > associated click count but cannot filter for 0 clicks, and the end > result is nearly a 1 gig of xml (there are many accounts with many > keywords) which causes problems with our ETL process and I only need > about 10 percent of that data. > > The second approach I looked at was to run a scheduled report via > report center and have it emailed and then run our ETL process on the > attachment. In report center you can filter out all keyword where > number of clicks is 0, but you cannot add keyword id to the report > that is generated. > > Can anyone advise if they have found a way to run the report that I > need? > > Can anyone from google advise why this is not possible? > > Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
