Re: AdWords API Re: Slowness in Calling adWords API to download campaign/adgroup/keyword/ad

[von journ]

Hi,

Sorry for bothering you again. It seems the report does not have QualityScore and FirstPageCpc for keyword, is that by purpose or not? These two are important properties for a keyword so without them it is hard to just use this Account Structure report to retrieve all keywords

thanks


--- On Thu, 5/28/09, AdWords API Advisor <adwordsa...@google.com> wrote:

> From: AdWords API Advisor <adwordsa...@google.com>
> Subject: AdWords API Re: Slowness in Calling adWords API to download campaign/adgroup/keyword/ad
> To: "AdWords API Forum" <adwor...@googlegroups.com>
> Date: Thursday, May 28, 2009, 3:46 PM
>
> Hello Von,
>
> Account Structure reports (http://code.google.com/apis/adwords/docs/
> developer/adwords_api_report_structure.html) will provide
> you with
> most of the basic attributes of your AdWords objects,
> regardless of
> whether there is any performance data available for them.
> Of course, a
> Structure report won't return any metrics about performance
> data at
> all, so if your goal is to both get a complete picture of
> your
> accounts each day and also get performance data, a
> Structure report
> alone won't do it for you.
>
> While it's true that running a report to get what you
> describe as a
> small campaign object can be slower than the equivalent
> getXYZ()
> methods, in practical terms you wouldn't be running a
> report just
> against a single small campaign. You can run reports
> against a whole
> account's worth of campaigns, or multiple accounts (all
> report types
> other than Account Structure can be run across multiple
> clients at a
> time). The ReportService is designed to handle retrieving
> large
> amounts of data efficiently.
>
> To address your other question, the AdWords API v13 will
> always
> authenticate each SOAP request based on the values in the
> "email" and
> "password" headers. It's not possible to cache anything and
> bypass
> this authentication, but I don't think that would be much
> by way of
> performance gains if there was. If you're really looking to
> speed up
> your current approach instead of adopting reports, do make
> sure that
> you're running your getXYZ() requests in parallel, either
> from
> multiple threads within the same process or from multiple
> processes.
> We recommend that you stay under four concurrent AdWords
> API requests
> at any given time. If you're currently only making one
> request at a
> time, you should see a significant reduction in your
> overall run time
> with that approach.
>
> Cheers,
> -Jeff Posnick, AdWords API Team
>
>
> On May 27, 9:08 pm, von journ <vonjo...@yahoo.com>
> wrote:
> > There are a lot of limitations if we run reports to
> get object
> > 1) we cannot get all properties of objects
> > 2) it is slow to run reports to get small campaign
> objects
> > 3) if object has no performance data then it does not
> appear in reports. We need to find such bad perf objects and
> optimize them
> >
> > API call cost is surely a big concern to us, No other
> search engine charges that except for google ...
> >
> > back to the topic, we like to know if the slowness is
> by design, or if it is our own program has problems.
> >
> > thanks
> >
> > --- On Wed, 5/27/09, AdWords API Advisor <adwordsapiadvi...@google.com>
> wrote:
> >
> > > From: AdWords API Advisor <adwordsapiadvi...@google.com>
> > > Subject: AdWords API Re: Slowness in Calling
> adWords API to download campaign/adgroup/keyword/ad
> > > To: "AdWords API Forum" <adwor...@googlegroups.com>
> > > Date: Wednesday, May 27, 2009, 11:24 PM
> >
> > > Hello,
> >
> > >  I'd recommend running reports to retrieve that
> data rather
> > > than
> > > looping through all the object with various
> getXYZ() calls.
> > > The API
> > > units consumed should also be considerably less
> when
> > > running reports
> > > for an account of that size.
> >
> > >  http://code.google.com/apis/adwords/docs/developer/ReportService.html
> >
> > > Cheers,
> > > -Jeff Posnick, AdWords API Team
> >
> > > On May 27, 2:53 pm, "vonjo...@yahoo.com"
> > > <vonjo...@yahoo.com>
> > > wrote:
> > > > I have a customer with about 400K keywords,
> 80K text
> > > ads, 8k adgroups
> > > > and 200 campaigns. I use adWords API to
> download (loop
> > > through all the
> > > > objects) and save to sql database. It takes
> me about
> > > 1.5 hours to
> > > > finish the downloading. my CPU is about 20%
> on
> > > average. so I guess
> > > > most time is spend in the network of calling
> google
> > > adwords API.
> >
> > > > Is this slowness as expected, if not, what
> are the
> > > normal speed of
> > > > getting all these objects downloaded to my
> machine?
> >
> >
> >
>

[AdWords API Advisor]

Hello,

It is true that the Keyword Structure report does not support
QualityScore or FirstPageCpc columns. This is intentional, and they
will not be added in the future. Apologies for any inconvenience, but
you'd have to run a (zero impression) Keyword Report if you want to
get those values.

Cheers,
-Jeff Posnick, AdWords API Team

On Jul 2, 7:23 pm, von journ <vonjo...@yahoo.com> wrote:
> Hi,
>
> Sorry for bothering you again. It seems the report does not have QualityScore and FirstPageCpc for keyword, is that by purpose or not? These two are important properties for a keyword so without them it is hard to just use this Account Structure report to retrieve all keywords
>
> thanks
>