[Requesting Advice] Missing conversions in the web console after sending Offline Conversions using the Ruby API

[mark.d...@simplybusiness.co.uk]

Hi Adwords Team,

We are having a few problems with the Offline Conversion API and are seeking some advice. This relates to the use of the Ruby API library - https://github.com/googleads/google-api-ads-ruby.

Intro

Our event stream captures the GCLID when a customer lands on our website, it stores the ID along with a UTC timestamps.

We have recently implemented a daily script that will run between 04:00 UTC - 06:00 UTC in the morning. It will collect a list of conversions that the company has made over the past X days, but ignoring those conversions that took place in the past 24 hours due to the recommended delay specified in the API documentation. 

The script closely followed the example: https://github.com/googleads/google-api-ads-ruby/blob/master/adwords_api/examples/v201609/remarketing/upload_offline_conversions.rb and will submit the data via the API.

The data that is submitted to google will preserve the timezone information and check to make sure that the Google Offline Conversion Feed Service returns no errors. If errors are returned our data engineering team will be automatically alerted and we will step in to resolve the errors.

Here is a cut down version of what we have: https://gist.github.com/markdessain/9a9374109206fb1bf44d8ca835fed2b4

Problem

For the past week we have been running out script and no errors have been raised when sending this data via the API. Thus we expected Google to have received and processed all our conversions.

• On the 25th we sent: 1 conversion
  
• On the 26th we sent: 139 conversions
  
• On the 27th we sent: 109 conversions
  
• On the 30th we sent: 312 conversions

When we look at the conversion dashboard in google and select it to show All conversions this morning it showed 589, two were missing.

After refreshing it a few hours later we see this number has now dropped to 588, so three are now missing.

Question

• How reliable is data in the Adwords web console? It appears to fluctuate, at what point is it stable?
• We would like to run a reconciliation at the click level to see which clicks are missing. I'm able to access all the necessary data in our internal systems, please can you suggest how I can see click level data so I can verify the IDs of the missing conversions?
  

If you have any other suggestions for the above problems please let me know.

Regards,

Mark Dessain

Senior Data Engineer at Simply Business

[Shwetha Vastrad (AdWords API Team)]

Hi Mark,

Do you happen to have the SOAP request and response logs for your offline conversion uploads, so I can have a look? Please note that a conversion is registered for the date of the original click, not when you sent the upload request. If your OfflineConversionFeed has duplicate conversions, no error is returned, but only the first instance is recorded. Please note that it takes up to 3 hours for imported conversions to appear in your AdWords account. Could you also provide the clientCustomerId and the dates that you are checking? Please use Reply privately to author when responding. 

Thanks,

Shwetha, AdWords API Team.