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 <bliss.j...@gmail.com> 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 <m...@bridgeleaf.com> 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:335172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
