5 messages in com.googlegroups.adwords-apiRe: Best way to get cost and click da...| From | Sent On | Attachments |
|---|---|---|
| dq | 28 Mar 2008 13:56 | |
| AdWords API Advisor | 31 Mar 2008 09:04 | |
| dyuti | 16 Apr 2008 04:36 | |
| Jan | 16 Apr 2008 05:40 | |
| dshevnock | 16 Apr 2008 10:33 |
| Subject: | Re: Best way to get cost and click data daily |
|---|---|
| From: | AdWords API Advisor (adwo...@google.com) |
| Date: | 03/31/2008 09:04:27 AM |
| List: | com.googlegroups.adwords-api |
Hello,
It is actually possible to schedule a repeating report via the AdWords web interface and then download and process the results each day via the AdWords API. However, this isn't strictly speaking the intended use case for reports scheduled via the AdWords web interface, and there are a few things that don't behave entirely as expected. For instance, when you call getAllJobs() to try to find the most recent scheduled report, you'll see that all instances of that scheduled report are listed as having the same start and end dates. In general the first one listed sequentially will be the newest one, but it isn't foolproof.
In any case, veering back into more supported waters, scheduling and retrieving the report via the API is the more recommended solution. As long as you're looking for information about keywords that actually receive impressions and clicks for a given day, you should only be talking about a small subset of the several million active across the various client accounts. You might be able to get away with scheduling a single cross-client report using your MCC account if the number of keywords with impressions is small enough; otherwise, scheduling one report per client account (or one report for every two or three client accounts) would be the way to go.
You can't schedule reports ahead of time via the API, but you can obviously schedule your code to run at certain times of the day, using something like cron in an UNIX-y environment or a Scheduled Task in Windows.
Given your account size I would recommend not making calls to getCriterionStats.
Cheers, -Jeff Posnick, AdWords API Team
On Mar 28, 4:56 pm, dq <kaya...@gmail.com> wrote:
I've looked at a couple posts that touched on this topic, but didn't quite answer this...
I want a daily report for all of our keywords with total # of clicks and total cost for each day. I need to download these with my application that's using the Adwords API.
There are 3 mechanisms I see that produce this information: - Scheduled daily reports through the web interface - Reports that can be scheduled through the API - getCriterionStats on the CriterionService
In my ideal world I would be able to set up the job once to run daily so that the report is generated automatically daily, then use the API to find out if it was ready and download it. It sounds like this isn't possible. That leaves the second two options. Which is the fastest/most predictable timewise and which is the cheapest (considering that we have several million keywords split amongst ~10 client accounts).
If I were to schedule a report, my understanding is that it would cost 1000 units per report (and I'd need 1 per account). Can I schedule a report to be run in the future (on May 10th at 1 pm I schedule a report with a start time of 00:00 on May 10 and an end time of 00:00 on May 11)?
If I were to getCriterionStats for every adgroup, passing in an array of every keyword id in the adgroup, the api cost would be 1 million for 1 million keywords, but how long would this operation take in comparison to running a report? Is this frowned upon for performance