Hi Euge, I was just experimenting with the report a bit more and after some trial and error I realized that you *can* filter by *CallStartTime* by using a date in the format *yyyyMMddHHmmss*. For example, this AWQL report query will only return calls with a start time on or after October 12, 2014 9:30 AM.
SELECT CampaignId, CampaignName, CallType, CallStatus, CallDuration, CallStartTime FROM CALL_METRICS_CALL_DETAILS_REPORT WHERE CallType IN ["GOOGLE_SEARCH", "HIGH_END_MOBILE_SEARCH"] AND CallStartTime >= "20141012093000" I realize this is a bit non-standard since we're not using a *DURING* clause here, but please let me know if this is a viable work-around for you while we are waiting for *DURING* clause support for this report. Thanks, Josh, AdWords API Team On Wednesday, October 15, 2014 6:02:38 PM UTC-4, eugegim wrote: > > Hi Josh, > > Is there any timetable available for when this may be resolved. Not having > the during clause work is causing us quite a lot of difficulty. Do you have > any recommendations for how we may be able to reduce the scope of the > output to only contains a month or two of data? > > Thanks much! > > Euge > > On Friday, October 10, 2014 12:34:19 PM UTC-7, Josh Radcliff (AdWords API > Team) wrote: >> >> Hi, >> >> You cannot filter on *CallStartTime* or *CallEndTime*. However, you can >> filter by *CampaignId* or *AdGroupId* if you want to break the report up >> into multiple runs. >> >> We're still working on the issue of allowing specific dates in the >> *DURING* clause. I'll post here when I have an update. >> >> Thanks, >> Josh, AdWords API Team >> >> On Thursday, October 9, 2014 12:57:37 PM UTC-4, Jeff Siebach wrote: >>> >>> Is there a way that this can be circumvented using the WHERE clause with >>> a date comparison on CallStartTime? >>> >>> Or is this issue going to be resolved? >>> >>> On Friday, April 4, 2014 10:54:36 AM UTC-7, >>> jarms...@stringenterprises.com wrote: >>>> >>>> I'm trying to use the Call Metrics Call Details Report with a custom >>>> date range and the response tells me it is not supported. I've used >>>> custom >>>> date ranges successfully with other ad hoc reports, but I haven't been >>>> able >>>> to get this one to work. >>>> >>>> Also, if i used any of the predefined values for dateRangeType, e.g. >>>> LAST_MONTH, or LAST_7_DAYS it always seems to return data outside of the >>>> specified range. >>>> >>>> Any suggestions on how I can use custom date ranges with this report? >>>> >>>> Here's my XML: >>>> >>>> <reportDefinition xmlns=\" >>>> https://adwords.google.com/api/adwords/cm/v201402\";> >>>> <selector> >>>> <fields>CampaignId</fields> >>>> <fields>CampaignName</fields> >>>> <fields>CallStartTime</fields> >>>> <fields>CallEndTime</fields> >>>> <fields>CallStatus</fields> >>>> <fields>CallDuration</fields> >>>> <fields>CallerNationalDesignatedCode</fields> >>>> <fields>OfflineInteractionCost</fields> >>>> <fields>CallType</fields> >>>> <dateRange> >>>> <min>20140315</min> >>>> <max>20140331</max> >>>> </dateRange> >>>> </selector> >>>> <reportName>Custom Performance Report</reportName> >>>> <reportType>CALL_METRICS_CALL_DETAILS_REPORT</reportType> >>>> <dateRangeType>CUSTOM_DATE</dateRangeType> >>>> <downloadFormat>XML</downloadFormat> >>>> </reportDefinition> >>>> >>>> And here is the response: >>>> >>>> <?xml version="1.0" encoding="UTF-8" >>>> standalone="yes"?><reportDownloadError><ApiError><type>SelectorError.FILTER_BY_DATE_RANGE_NOT_SUPPORTED</type><trigger>Filtering >>>> >>>> by date range not >>>> supported.</trigger><fieldPath></fieldPath></ApiError></reportDownloadError> >>>> >>>> Any help would be appreciated. >>>> >>>> Thanks! >>>> >>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/da93e3cf-35bf-40ba-ac5e-88312e4b41ab%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
