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 quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---