Cannot upload offline conversions.

[moshe....@888holdings.com]

Hi,

We're using the latest Php Api source code example (/examples/AdWords/v201309/AdvancedOperations/UploadOfflineConversions.php) to test upload offline conversions, but we keep getting the same error:

[OfflineConversionError.UNPARSEABLE_GCLID @ operations[0].operand]

The source was downloaded from here: https://github.com/googleads/googleads-php-lib.

Why is this happening?

lease assist..

Thanks!

[Danial Klimkin]

Hello,

This error means the GLCID string provided is not a valid Google Click ID. Did you get the ID from the CLICK_PERFORMANCE_REPORT?

-Danial, AdWords API Team.

[tra...@888holdings.com]

Hello Daniel,

Thanks for the response.

The I tried several sources, none of them from the report you mentioned:

- from our data warehouse

- directly from on of our ads (clicked on an ad and extracted the gclid from the url query string)

Could it be some charset encoding issue?

What should I try to do?

Thanks.

[Danial Klimkin]

Hello,

Have you tried pulling the click performance report and comparing strings from it with your URL parameters?

If still in doubt, please send me the exact XML request and server response for the error over email (reply to author button).

-Danial, AdWords API Team.

[Austin Bergstrom]

Hi Danial,

I am getting the same error, but not through an example application. I am using the java client libraries (jaxws) on Google App Engine. The click ID I am using to test was copy/pasted from the URL (we have tried a few different click ids) and all have the same result. I am not sure if there might be some encoding that needs to be done on the gclid before being added to the `OfflineConversionFeed` as the `googleClickId`. I have also asked the MCC account manager to look at the click perf report and compare and see no differences in the values. Our current example gclid is `CIaJu9GTl7wCFacDOgodcWwA3g`.

Thank you!

Below is the stack trace:

Uploading - OpportunityName: Test, StageName: Closed Won, CreatedDate: 2014-01-23T23:08:12.000Z, GCLID: CIaJu9GTl7wCFacDOgodcWwA3g com.google.api.ads.adwords.jaxws.v201309.cm.ApiException_Exception: [OfflineConversionError.UNPARSEABLE_GCLID @ operations[0].operand] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:33) at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:141) at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:119) at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:89) at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:118) at com.sun.proxy.$Proxy51.mutate(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:45) at com.google.api.ads.common.lib.soap.SoapClientHandler.invoke(SoapClientHandler.java:109) at com.google.api.ads.common.lib.soap.jaxws.JaxWsHandler.invokeSoapCall(JaxWsHandler.java:242) at com.google.api.ads.common.lib.soap.SoapServiceClient.callSoapClient(SoapServiceClient.java:64) at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:93) at com.sun.proxy.$Proxy52.mutate(Unknown Source) at front.DailyServlet.doGet(DailyServlet.java:152) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:923) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at com.google.tracing.TraceContext$TraceContextRunnable.runInContext(TraceContext.java:437) at com.google.tracing.TraceContext$TraceContextRunnable$1.run(TraceContext.java:444) at com.google.tracing.CurrentContext.runInContext(CurrentContext.java:188) at com.google.tracing.TraceContext$AbstractTraceContextCallback.runInInheritedContextNoUnref(TraceContext.java:308) at com.google.tracing.TraceContext$AbstractTraceContextCallback.runInInheritedContext(TraceContext.java:300) at com.google.tracing.TraceContext$TraceContextRunnable.run(TraceContext.java:441) at java.lang.Thread.run(Thread.java:724)

[Danial Klimkin]

Hello Austin,

Looking at the log, you have the same issue as Moshe. The timestamp format in the conversionTime field is incorrect. Try to skip the timezone or use the following format:

"20140101 010101 Europe/London"

-Danial.

[Austin Bergstrom]

Thanks Danial,

I am omitting the timezone and no longer see the UNPARSEABLE_GCLID fault. I would ultimately like to include the timezone. The two formats I used with timezone included are below:

new SimpleDateFormat("yyyyMMdd HHmmss z");

new SimpleDateFormat("yyyyMMdd HHmmss zzzz"); 

Neither worked until I removed the 'z' option entirely.

Also, are you planning on giving more detailed error information when the date time format is (apparently) invalid? It is confusing that the formats with timezone do not trigger invalid date/time faults.

Thank you again!

-Austin

[Danial Klimkin]

Hello Austin,

The string format depends on your language / library. I assume you need a string like:

  "20140101 010101 America/Los_Angeles"

for Pacific time. We'll update the error message for this case as soon as possible.

-Danial, AdWords API Team.

[Ahmed Kamal]

hi guys,

i'm using the Latest .NET API For offline conversion and i'm having the same problem.

some GCLID are working properly and some getting me that error.

so if anyone know the solution to that problem it would be great

thanks

[Dhanya Sundararaju (AdWords API Team)]

Hi,

As this is an old thread, could you please create a new thread on the forum explaining the issue and also SOAP logs with sensitive data redacted?

Regards,
Dhanya, AdWords API Team

[vanes...@stylelounge.de]

Hello Danial, I have encountered the same error OfflineConversionError.UNPARSEABLE_GCLID @ operations[0].operand

my gclid is in this format CjKCQjwidPcBRCGARIsALMeNsWxRFTvFTFONzamsqclwGeweFuhnqVUGZuFrbgGLxAHjoaAlVpEALwwcB

[Dhanya Sundararaju (AdWords API Team)]

Hi there,

OfflineConversionError.UNPARSEABLE_GCLID, it means that your click id could not be decoded. Could you try running Click Performance Report for around that Date and see if you are able to pull up the gclid? Please refer to this blog post for better clarity. If you have further questions, could you open a new thread and then reply privately to author with complete SOAP logs including request and response of the above upload, so that I can troubleshoot further?