Custom Date with Call Metrics Call Details Report

[jarms...@stringenterprises.com]

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!

[Josh Radcliff (AdWords API Team)]

Hi,

At the moment, it seems that the CALL_METRICS_CALL_DETAILS report always returns data for ALL_TIME.  We're aware of this issue and are looking into it.

Cheers,

Josh, AdWords API Team

[Christopher Taylor]

Is there any update to this? It fails even if we don't pass a date range with:

Type = 'ReportDownloadError.MISSING_PARAMETER', Trigger = 'Start and End date are required for CUSTOM_DATE and ReportType: CALL_METRICS_CALL_DETAILS_REPORT', FieldPath = ''. 

When we specify startDate and endDate, we receive this error:

Type = 'ReportDownloadError.INVALID_REPORT_DEFINITION_XML', Trigger = 'Invalid ReportDefinition Xml: cvc-complex-type.2.4.a: Invalid content was found starting with element 'startDate'. One of '{"https://adwords.google.com/api/adwords/cm/v201406":fields, "https://adwords.google.com/api/adwords/cm/v201406":predicates, "https://adwords.google.com/api/adwords/cm/v201406":dateRange, "https://adwords.google.com/api/adwords/cm/v201406":ordering, "https://adwords.google.com/api/adwords/cm/v201406":paging}' is expected.', FieldPath = ''. 

[Christopher Taylor]

Nevermind, changed dateRangeType to ALL_TIME and it works now. Let us know when we can filter by date range because there's a lot of data we're going to have to sift through nightly..

[Jeff Siebach]

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?

[Josh Radcliff (AdWords API Team)]

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

[eugegim]

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

[Josh Radcliff (AdWords API Team)]

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

[Tiana S.]

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

[Josh Radcliff (AdWords API Team)]

Hi Tiana,

You are correct: we recently made an improvement to that report so that it supports the DURING clause. We're working on updating the docs.

Thanks,

Josh, AdWords API Team