Deduplication question uploading missed conversions from a Website tag via OfflineConversionUpload via API

[Val Vaschetto]

I have a question regarding best practices for uploading missed Purchase conversions from my Google Ads traffic.

When a purchase event fires on my website, I include a transaction_id in the script tag. I record the gclid and the transaction_id in a database.

On any given day, we will have for example 100 orders that we know came from Google, but only about 70 of them show up in reporting.

We're using last click attribution, and are passing &gclid={gclid} into our tracking templates.

I would like to take those 100 purchases on my website, and upload them via the Google Ads API using the Upload Offline Conversions method, or whichever method is best to suite my needs. I need to capture those missing 30 orders into my ad campaigns, or else my ad campaigns will not optimize effeciently.

I have tried adding ORDER_ID to my API calls and still 100 orders show up under my "Import purchase gclid from website" conversion action. They are not being de-duplicated against the "Website purchase tag" conversion action. I understand that 

The documentation here is confusing: https://support.google.com/google-ads/answer/6386790?sjid=12739517396281232436-NC

I have tried uploading offline conversions via API, but they do not deduplicate. I have tried doing upload conversion adjustment, and I always get the same response: "Partial failures occurred: 'The conversion for this conversion action and conversion identifier can't be found. Make sure your conversion identifiers are associated with the correct conversion action and try again., at conversion_adjustments[0].order_id'."

So, what is the best practice for getting those 30 missed conversions into my campaign as a primary objective? I know that keeping the purchase tag on my website and including the transaction_id is correct, but what am I doing wrong with regards to upload the missing conversions? I know that I am using the right gclid and transaction_id and conversion_time.

The documentation referenced above is not clear on how to exactly do this. It seems like advertisers are only able to either use the google ads script tag on their website to track purchases, but there is no fallback server to server implementation that does not create duplicate conversions.

Is there a completely different way to go about this? Can I use the API to pull conversions and transaction_ids for a day, and deduplicate those myself against my database, and upload the missing ones? I'm able to get the gclids for an entire day using GAQL, but data privacy limitation I believe are the reason why there is no option to have a "Converted" or "Conversion value" for me to know if Google has counted them as conversions.

Any help is greatly appreciated.

Thanks

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

After reviewing your query, I understand that you are getting the response "Partial failures occurred” while using the upload conversions via Google Ads API.

In order to investigate, kindly provide us with the complete API logs (request and response logs with request-id and request header) generated at your end along with the uncropped UI screenshot (with visible customer Id) to better assist you on this request. 

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag. 

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02qAdrE:ref"

Thanks,
 

Google Ads API Team