Here's what I do. We used to pull the keyword performance data via
the API, but the costs (both in Google bills and processing time)
became an issue. We still use the API to pull the campaign and
adgroup information each night for all customers' accounts (those are
"cheap" calls to the API and the data isn't all that huge), as well as
the Structure Report for a keyword level breakdown (you only need one
report per account, as opposed to the keyword report whcih was one
report per adgroup, so the cost is still "cheap"), but now use daily
scheduled reports on the GUI side of adWords to email us a keyword
performance report for each account. It is in CSV format and we can
process huge files very fast. When we need the campaign or adgroup ID
information, we can get it from either the Structure Report's data or
the data that came down from the campaign (criterion) or adgroup
requests. Using the scheduled report sped things up tremendously (5+
hours to about 30 minutes or less) because the data was is a
consistent CSV format (which ETL tools love) instead of the XML format
which was both cpu-intensive to parse and inconsistent in the presence/
absence of certain elements. We do this for about 2.5 million
keywords every night and it works like a champ.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
