Re: Custom Date with Call Metrics Call Details Report

Hi Josh,

I just tried fetching data from the `CALL_METRICS_CALL_DETAILS_REPORT` using the DURING clause and it seems to work, I only get calls returned from within the date range, but the documentation still says it shouldn't work. Could anyone confirm this has been added?

Thanks,

Tiana

On Thursday, 16 October 2014 14:32:57 UTC+2, Josh Radcliff (AdWords API Team) wrote:

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+unsubscribe@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+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ef6b2ea5-1032-4d94-8cb0-9c4a5a913c65%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.