We just have two CF scheduled processes. One that does #1 and #2 and the other that does #3, #4, and #5. And then, via the CF scheduler, we put *at least* 30 minutes between those two processes and...problem solved. Will that not work for you? Are you trying to do this in "real time" while an end-user waits for results or what? (For us, these are just nightly processes that pump data into our database.)
On Wed, Jul 7, 2010 at 9:11 PM, Matt Blatchley <[email protected]> wrote: > > I'm trying to figure out the best way to approach this and not really > coming up with anything "good". Most likely because I've been looking > at it all day today. > > In the Adwords API, there is a web service called ReportService used > to generate reports. > > It's a step by step process which I have managed to get working > manually and I'm trying to figure out the best way to automate this > one section. > > Here is the Breakdown of the steps used to generate a single report > from Adwords (and yes it's ridicules to have to do all this just to > get a daily report of impressions, clicks, cost, CPC, CTR, Avg Pos, > conversions, CR, and CPA): > > 1. First you have to validate the format of the SOAP request. > 2. Then you have to Schedule the Report to be generated using the > validated format from the previous step. > 3. Next you have to check the Status of the Report to make sure it's > available. This one step could take a number of minutes (Pending, In > Progress, Completed, or Failed) > 4 If the status of the report is Completed, you can use the ReportID > to Request the "download URL". > 5. Get the XML Report using the downloaded URL. > > So Step 3 is where my question is. > > In the sandbox environment that Google provides for testing, the > status changes once every minute until it hits "Failed". Not sure how > long it would take in a production setting but I'm hoping it's less > than a few minutes. > > What do you all think would be the best way to check the status of the > report? > I'm worried about the length of time it takes and the reliability of > something like this to just check the status of a report? > > I started out using Martin Orth's Adwords API library initially, but I > couldn't get anywhere with the ReportService.cfc. I continued to get > XML formatting errors for some reason. Everything else worked fine. > There is also something up with the download of the project. I > couldn't open the zip file in Windows, only Mac. > > I've already got the Google Analytics API working, but the Adwords > data doesn't flow over to the Analytics until about 48 hours after, so > it's hardly real time when you need the data that day... but hey, it's > free (for now). > > Using CF7 on a windows box. > > Thanks in advance for any thoughts or ideas that might help point me > in the right direction! > > Matt > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
