> You think that would still be something that would work if I had multiple tasks setup for each client on the system?
Probably. Or else have one task responsible for doing 1 & 2 for any/all clients currently requiring reports and have another task responsible for doing 3, 4, & 5 for those same set of clients and then make sure there's at least 30 minutes between the two tasks. Something like that. > You ever run into reliability issues with the Reports coming back empty or generating an error etc? No, we have not. > I kept reading on old threads that it wasn't very reliable, but that was from a thread in 2006 or something. We did not have this stuff set up back then. This part (at least) has been rock-solid since about Q4 2008. On Wed, Jul 7, 2010 at 9:35 PM, Matt Blatchley <[email protected]> wrote: > > It for a SaS, so it would have to run reports continuously for x > number of clients on the system. You think that would still be > something that would work if I had multiple tasks setup for each > client on the system? > > You ever run into reliability issues with the Reports coming back > empty or generating an error etc? I kept reading on old threads that > it wasn't very reliable, but that was from a thread in 2006 or > something. > > Matt > > > > On Wed, Jul 7, 2010 at 8:21 PM, John M Bliss <[email protected]> wrote: > > > > 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:335173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
