Conversion Offline errors since Saturday

[Maurício Valente]

Hello,

Since this Saturday I have finding errors in my application trying to send Offline Conversions using PHP Google Adwords API. Before that everything was smoothly.

Here is my Soap Request:

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://adwords.google.com/api/adwords/cm/v201809"><SOAP-ENV:Header><ns1:RequestHeader><ns1:clientCustomerId>XXX-XXX-XXXX</ns1:clientCustomerId><ns1:developerToken>REDACTED</ns1:developerToken><ns1:userAgent>Hoplon (AwApi-PHP, googleads-php-lib/42.0.0, PHP/7.1.30-1+0~20190531112744.19+jessie~1.gbpab9d28)</ns1:userAgent><ns1:validateOnly>false</ns1:validateOnly><ns1:partialFailure>false</ns1:partialFailure></ns1:RequestHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:mutate><ns1:operations><ns1:operator>ADD</ns1:operator><ns1:operand><ns1:googleClickId>EAIaIQobChMI1-jN-LDV4gIV3oyyCh14pw3CEAEYASAAEgJJ2PD_BwE</ns1:googleClickId><ns1:conversionName>Conversao In Game</ns1:conversionName><ns1:conversionTime>20190720 201117 UTC</ns1:conversionTime></ns1:operand></ns1:operations></ns1:mutate></SOAP-ENV:Body></SOAP-ENV:Envelope>

This, the Response headers:

HTTP/1.1 500 Internal Server Error
Content-Type: text/xml; charset=UTF-8
Date: Sun, 21 Jul 2019 01:00:02 GMT
Expires: Sun, 21 Jul 2019 01:00:02 GMT
Cache-Control: private, max-age=0
X-Content-Type-Options: nosniff
X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
Server: GSE
Alt-Svc: quic=":443"; ma=2592000; v="46,43,39"
Accept-Ranges: none
Vary: Accept-Encoding
Connection: close

This is the Soap Response:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><ResponseHeader xmlns="https://adwords.google.com/api/adwords/cm/v201809"><requestId>00058e267ab2cfed0a3f0f0231087321</requestId><serviceName>OfflineConversionFeedService</serviceName><methodName>mutate</methodName><operations>1</operations><responseTime>149</responseTime></ResponseHeader></soap:Header><soap:Body><soap:Fault><faultcode>soap:Client</faultcode><faultstring>[OfflineConversionError.EXPIRED_CLICK @ operations[0].operand]</faultstring><detail><ApiExceptionFault xmlns="https://adwords.google.com/api/adwords/cm/v201809"><message>[OfflineConversionError.EXPIRED_CLICK @ operations[0].operand]</message><ApplicationException.Type>ApiException</ApplicationException.Type><errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="OfflineConversionError"><fieldPath>operations[0].operand</fieldPath><fieldPathElements><field>operations</field><index>0</index></fieldPathElements><fieldPathEl
 ements><field>operand</field></fieldPathElements><trigger></trigger><errorString>OfflineConversionError.EXPIRED_CLICK</errorString><ApiError.Type>OfflineConversionError</ApiError.Type><reason>EXPIRED_CLICK</reason></errors></ApiExceptionFault></detail></soap:Fault></soap:Body></soap:Envelope>

Can anyone help me to find a way?

Thank you!

[Google Ads API Forum Advisor Prod]

Hi Mauricio,

Thank you for reaching out.

The EXPIRED_CLICK error you are encountering means that the click you are trying to upload a conversion to is too old or have occurred before the conversion window for the specified combination of conversion date and conversion name (default is 90 days). You will need to check the ctcLookBackWindow duration to check the conversion window time. If it has indeed went past the duration, then there can no longer be any way to upload the said click into your account.

Regards,
Dannison
Google Ads API Team

ref:_00D1U1174p._5001UEG4o4:ref

[Maurício Valente]

Hello Dannison!

Thanks for your answer!

In fact, the click happened 4 hours before the system tried to send offline conversions. I'm trying other conversions that happened shortly after and are still causing the same error.

I don't think the problem is the window between click and conversion, must be something else.

The gclid EAIaIQobChMI1-jN-LDV4gIV3oyyCh14pw3CEAEYASAAEgJJ2PD_BwE for example had the clicked event in 2019-07-20 20:11:17. As showed in the header of the SOAP above, the first time I tried to send conversions was at "Date: Sun, 21 Jul 2019 01:00:02 GMT" 4 hours later, exactly the numbers of hours Google expect to wait for receive conversions.

I have more 15 gclids to send that happaned between saturday and today. I'm trying to send one by one, and I still got the same problem.

Could it be something else?

[Maurício Valente]

I found the problem! 

The user I was authenticating using token was removed from User Account Permission.

Thank you all.

Maurício

[Google Ads API Forum Advisor Prod]

Hi Mauricio,

Glad you have fixed the issue. Let me know if you have any further concerns regarding the AdWords API.

[Maurício Valente]

Hi Dannison!

I'm still having [OfflineConversionError.EXPIRED_CLICK @ operations[0].operand] in some gclid when trying to informe Conversions Offline using PHP in AdWords.

This is the one of GClids I'm getting this error:

EAIaIQobChMIp6CepZ2C4wIVgRPTCh3E8ggiEAEYASAAEgJiJ_D_BwE

Can you identify in the AdWords plataform why I'm getting this error?

My conversion window is set to 30 days and that click happened at 2019-07-25 04:08:06 GMT.

My first try sending conversions with that ID was at 2019-07-25 09:00:02 GMT

This is the SOAP response:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Header>
        <ResponseHeader xmlns="https://adwords.google.com/api/adwords/cm/v201809">

            <requestId>00058e7da6b4b3470a628181940670d5</requestId>

            <serviceName>OfflineConversionFeedService</serviceName>
            <methodName>mutate</methodName>
            <operations>1</operations>

            <responseTime>198</responseTime>

Thank you!

Maurício

[Google Ads API Forum Advisor Prod]

Hi Mauricio,

Thank you for providing the logs. I will check this with the team and get back to you with insights once available.

[Google Ads API Forum Advisor Prod]

Hi Maurício, after some investigation, I was able to determine that the click ID you provided was from a click that occurred on June 24. However, it looks like you tried to upload the click on July 25. I took a look at your account, and there is a 30 day window set up for this conversion type, so you uploaded this click just outside of the 30 day conversion window, which explains the error.

All the best,
Devin
The Google Ads API Team

ref:_00D1U1174p._5001UEG4o4:ref

[Maurício Valente]

Thank You Devin!!