Hello Rohit, If you specify Daily aggregation then all the report data should be, well, aggregated by each specific day. So yes, you would have to separate out the performance data, but all the data from 2009-04-24 should be clearly marked and distinct from data for other days.
Cheers, -Jeff Posnick, AdWords API Team On Apr 29, 9:38 am, rohitc <rohit.col...@gmail.com> wrote: > Thanks Jeff - appreciate the response. > This is certainly applicable to our accounts i.e. their timezone is > setup as Cairo and DST may have kicked in. > > Question I have is ... if we use the proposed workaround of scheduling > a daily aggregation from 4/23 to 4/25, that would also include > performance data from 4/23 and 4/25 and we'd then have to separate > them out for the 3 days in the range? > > On Apr 28, 1:09 pm, AdWords API Advisor <adwordsapiadvi...@google.com> > wrote: > > > Hello, > > > This is, unfortunately, the same issue that cropped up last October > > and is described here: > > > http://groups.google.com/group/adwords-api/browse_thread/thread/d1f64... > > > I took a look at Hari's request, and the account in question is in > > Cairo's time zone, which just had DST kick in at what would have been > > midnight on April 24. I'm assuming that Rohit's account also falls in > > a time zone that just had a DST event. > > > There really should have been a resolution between last October and > > now, but unfortunately there hasn't been. I've made sure that our > > engineering team knows that this is once again affecting our > > developers. Until the issue is resolved, though, I'd recommend working > > around the issue by, for example, scheduling a report with Daily > > aggregation and a start day of 2009-04-23 and end date of 2009-04-25. > > > Apologies, > > -Jeff Posnick, AdWords API Team > > > On Apr 28, 12:56 pm, rohitc <rohit.col...@gmail.com> wrote: > > > > We seem to have run into this problem as well. > > > > To summarize, an attempt to retrieve performance data for 04/24 for > > > some of our accounts generate this strange error: > > > > The day is in an unrecognized format. It must match the form > > > YYYY-MM-DD with an optional timezone offset. > > > > Note: our request correctly contains ... > > > > <startDay xsi:type="xsd:date">2009-04-24</startDay> > > > <endDay xsi:type="xsd:date">2009-04-24</endDay> > > > > ... even though the request appears perfect. > > > > Is there anybody in Google that can respond to this issue? > > > > Thanks in advance. > > > > - Rohit > > > > --- > > > > On Apr 27, 12:02 pm, SEM <sem...@gmail.com> wrote: > > > > > Hi There, > > > > > We seem to be getting the following API error when we try to retrieve > > > > the daily creative report for 2 of our accounts. This seems to fail > > > > only for the 24th of April 2009. > > > > -- > > > > xception in thread "main" AxisFault > > > > faultCode: {http://schemas.xmlsoap.org/soap/envelope/} > > > > Server.userException > > > > faultSubcode: > > > > faultString: The day is in an unrecognized format. It must match the > > > > form YYYY-MM-DD with an optional timezone offset. > > > > faultActor: > > > > faultNode: > > > > faultDetail: > > > > {https://adwords.google.com/api/adwords/v13}fault: > > > > <ns1:code>70</ns1:code> > > > > > <ns1:message>The day is in an unrecognized format. It must > > > > match the form YYYY-MM-DD with an optional timezone offset.</ > > > > ns1:message> > > > > > <ns1:trigger>2009-04-24</ns1:trigger> > > > > -- > > > > > I have also pasted the request and response below. Any help is greatly > > > > appreciated. > > > > > ======================================================= > > > > = Elapsed: 4469 milliseconds > > > > = In message: <?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope > > > > xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" > > > > xmlns:xsd="http://www.w3.org/2001/XMLSchema" > > > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><soapenv:Header><ns1:email > > > > soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" > > > > soapenv:mustUnderstand="0" xmlns:ns1="https://adwords.google.com/api/ > > > > adwords/v13">x...@xx.com</ns1:email><ns2:password soapenv:actor="http:// > > > > schemas.xmlsoap.org/soap/actor/next" soapenv:mustUnderstand="0" > > > > xmlns:ns2="https://adwords.google.com/api/adwords/v13">xx</ > > > > ns2:password><ns3:useragent soapenv:actor="http://schemas.xmlsoap.org/ > > > > soap/actor/next" soapenv:mustUnderstand="0" xmlns:ns3="https:// > > > > adwords.google.com/api/adwords/v13">xx</ > > > > ns3:useragent><ns4:applicationToken soapenv:actor="http:// > > > > schemas.xmlsoap.org/soap/actor/next" soapenv:mustUnderstand="0" > > > > xmlns:ns4="https://adwords.google.com/api/adwords/ > > > > v13">gDZ7WLMPARyNmO2Iu7Oc6w</ns4:applicationToken><ns5:developerToken > > > > soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" > > > > soapenv:mustUnderstand="0" xmlns:ns5="https://adwords.google.com/api/ > > > > adwords/v13">xx</ns5:developerToken></ > > > > soapenv:Header><soapenv:Body><scheduleReportJob xmlns="https:// > > > > adwords.google.com/api/adwords/v13"><job > > > > xsi:type="ns6:DefinedReportJob" xmlns:ns6="https://adwords.google.com/ > > > > api/adwords/v13"><endDay xsi:type="xsd:date">2009-04-24</endDay><name > > > > xsi:type="xsd:string">CMReportDetail-New {AID=-1}</name><startDay > > > > xsi:type="xsd:date">2009-04-24</startDay><aggregationTypes > > > > xsi:type="xsd:string">Daily</aggregationTypes><selectedColumns > > > > xsi:type="xsd:string">CampaignId</selectedColumns><selectedColumns > > > > xsi:type="xsd:string">Campaign</selectedColumns><selectedColumns > > > > xsi:type="xsd:string">AdGroupId</selectedColumns><selectedColumns > > > > xsi:type="xsd:string">AdGroup</selectedColumns><selectedColumns > > > > xsi:type="xsd:string">MaxContentCPC</selectedColumns><selectedColumns > > > > xsi:type="xsd:string">KeywordId</selectedColumns><selectedColumns > > > > xsi:type="xsd:string">Keyword</selectedColumns><selectedColumns > > > > xsi:type="xsd:string">KeywordTypeDisplay</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">KeywordStatus</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">KeywordMinCPC</ > > > > selectedColumns><selectedColumns > > > > xsi:type="xsd:string">DescriptionLine1</ > > > > selectedColumns><selectedColumns > > > > xsi:type="xsd:string">DescriptionLine2</ > > > > selectedColumns><selectedColumns > > > > xsi:type="xsd:string">DescriptionLine3</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">VisibleUrl</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">DestinationURL</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">CreativeId</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">CreativeType</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">AdStatus</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">AdWordsType</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">DailyBudget</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">MaximumCPC</ > > > > selectedColumns><selectedColumns > > > > xsi:type="xsd:string">KeywordDestUrlDisplay</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">AdGroupStatus</ > > > > selectedColumns><selectedColumns > > > > xsi:type="xsd:string">CreativeDestUrl</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">CampaignStatus</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">Impressions</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">Clicks</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">CTR</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">CPC</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">Cost</ > > > > selectedColumns><selectedColumns > > > > xsi:type="xsd:string">AveragePosition</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">TopPosition</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">BottomPosition</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">FirstPageCpc</ > > > > selectedColumns><selectedColumns xsi:type="xsd:string">QualityScore</ > > > > selectedColumns><selectedReportType xsi:type="xsd:string">Creative</ > > > > selectedReportType></job></scheduleReportJob></soapenv:Body></ > > > > soapenv:Envelope> > > > > = Out message: <soapenv:Envelope xmlns:soapenv="http:// > > > > schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/ > > > > XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> > > > > <soapenv:Header> > > > > <responseTime soapenv:actor="http://schemas.xmlsoap.org/soap/actor/ > > > > next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/ > > > > adwords/v13">523</responseTime> > > > > <operations soapenv:actor="http://schemas.xmlsoap.org/soap/actor/ > > > > next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/ > > > > adwords/v13">1</operations> > > > > <units soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" > > > > soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/ > > > > adwords/v13">500</units> > > > > <requestId soapenv:actor="http://schemas.xmlsoap.org/soap/actor/ > > > > next" soapenv:mustUnderstand="0" xmlns="https://adwords.google.com/api/ > > > > adwords/v13">0da372dbf7d6ef4def274ce064f7f129</requestId> > > > > </soapenv:Header> > > > > <soapenv:Body> > > > > <soapenv:Fault> > > > > <faultcode>soapenv:Server.userException</faultcode> > > > > > <faultstring>The day is in an unrecognized format. It must match > > > > the form YYYY-MM-DD with an optional timezone offset.</faultstring> > > > > > <detail> > > > > <ns1:fault xmlns:ns1="https://adwords.google.com/api/adwords/ > > > > v13"> > > > > <ns1:code>70</ns1:code> > > > > > <ns1:message>The day is in an unrecognized format. It must > > > > match the form YYYY-MM-DD with an optional timezone offset.</ > > > > ns1:message> > > > > > <ns1:trigger>2009-04-24</ns1:trigger> > > > > > </ns1:fault> > > > > > </detail> > > > > > </soapenv:Fault> > > > > </soapenv:Body> > > > > </soapenv:Envelope> > > > > ======================================================= > > > > > Thanks, > > > > Hari- Hide quoted text - > > > - Show > > ... > > read more » --~--~---------~--~----~------------~-------~--~----~ 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 adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en -~----------~----~----~----~------~----~------~--~---