GCM360 - Error(s) inserting conversion for encrypted user in Python API call .batchinsert

[Tony Luo]

Hello,

I'm using the sample code insert_offline_user_conversion.py to create an conversion record on GCM360, authentication are ok.

googleads-dfa-reporting-samples/python/v4 at master · googleads/googleads-dfa-reporting-samples (github.com)

However, I got Error(s) inserting conversion for encrypted user ID acc56602-2349-4fc5-8b04-d679af6366a8.

I can provide my testing code with private key access.

Thanks

Tony

[DCM API (DoubleClick Campaign Mgr)]

Hello Tony,

 

This is Maia from the DCM API team. Thank you for reaching out to us.

 

I would like to note that our API team can only provide support to direct technical issues in using the API. However, for us to have a clear understanding of your errors/issue, we can further look into your concern. Kindly provide us with the information below:

 

• DCM Account ID
• Profile ID used in the execution/request call
• Floodlight Activity ID
• Request body & URL endpoint request with path param values
• Complete API response showing the issue/error 
• You can also include the testing code with private key access

 

Please send the requested details privately via the "Reply To Author" button. If the said option is not available on your end, then kindly send the requested information through this email <dcmapi-...@google.com> instead.

 

Best Regards,

Angel Maia DCM API Team

 

ref:_00D1U1174p._5004Q2eOsF3:ref

[Tony Luo]

Hi Angel,

Thanks for the reply, I already provided the code and private key in private email.

Look forward to hearing from you.

Regards

Tony

[DCM API (DoubleClick Campaign Mgr)]

Hello Tony,

 

Michael here and I work along with Angel.

 

I can see that you are encountering an internal error message of: Error processing the request. Usually, the error is due to multiple operations affecting the same entity (whether directly or indirectly). For this error, our team suggest the following:

 

• Generally retrying to submit a request can help resolve it.
• Create a mechanisms that will retry the request up to 10 times when getting this error.
• Increasing the threshold of your uploader to retry a request (The suggested threshold is 10).
• Adding a timeout/pause between attempts.

 

However, should the issue be persistent on your end, would you be able to confirm that you are also encountering the same error using our API Explorer? Asking this because if you only encounter this using the sample code from our client library, we would highly suggest that you reach out to the developer's support specialist as they are the one who maintains our client libraries and would be the best people to help with your integration.

 

On the other hand, if you encounter this error directly from our API Explorer, kindly let us know and we will raise it to our wider team for further investigation.

Regards,

Michael Angelo DCM API Team

ref:_00D1U1174p._5004Q2eOsF3:ref

[Tony Luo]

Hi Michael,

I have added the retry/pause code as advised  GCM360-PUBTest/insert_offline_user_conversionNew.py at main · tonyluo7/GCM360-PUBTest (github.com).

Unfortunately, issue is still persistent. 

Regarding API Explorer above, I'm testing with a service account. The API Explorer doesn't seem to work with service account, and only accept user account. 

Please can you confirm if the error is from the code or at Google CM360 API back end? The response says below, 

INTERNAL: Error processing the request

Regards

Tony

[DCM API (DoubleClick Campaign Mgr)]

Hello Tony,

 

Thank you for responding back to us.

 

We cannot conclude as of the moment where the issue is coming from since this is an internal error that needs to be raised to our wider team for further investigation. But for the meantime before we do that, can you ensure that you are using the latest version of the API which is v4? or atleast the v3.5 of the API? Asking this as you have not provided to us the URL endpoint of your request call similar to this: POST https://dfareporting.googleapis.com/dfareporting/v4/userprofiles/{profileId}/conversions/batchinsert for inserting conversions. You may send to us the exact url request endpoint you are calling with path param values. We have to ensure that this is not because of incorrect version of the API or profile ID used in the request call.

 

Upon submitting the requested information, we will raise this to our team for immediate action.

Regards,

[Tony Luo]

Hi Michael,

Yes, I can confirm that the v4 of API is being used. 

In my test code copied from the Google sample code  https://github.com/googleads/googleads-dfa-reporting-samples/blob/master/python/v4/insert_offline_user_conversion.py, 

it's using version 4 of 'dfareporting'.

  # Construct a service object via the discovery service.

    service = discovery.build('dfareporting', 'v4', http=http)

The URL endpoint is build by the googleapiclient library method above. Debugged and stepped through above routine, can see the _baseurl attribute as following,  

https://dfareporting.googleapis.com/dfareporting/v4/

request = service.conversions().batchinsert(profileId=profile_id,

                                                    body=request_body)

Stepped through above routine can see the URL attribute of above request object has following,

https://dfareporting.googleapis.com/dfareporting/v4/userprofiles/5654144/conversions/batchinsert?alt=json

Thanks

Tony

[DCM API (DoubleClick Campaign Mgr)]

Hello Tony,

 

Thank you for that confirmation. With this, allow me to raise this issue to the rest of the team for further investigation. We will get back to you on this thread the soonest we have more information.

Regards,

[Tony Luo]

Hi Michael,

Any update on this yet? I'm wondering how long this usually takes to have a solution from your team?

Many thanks

Tony

[DCM API (DoubleClick Campaign Mgr)]

Hello Tony,

 

Thank you for responding back to us. Currently, this issue is still under investigation and we cannot give definitive time when we could arrive to resolution. Rest assured that our team is doing its best in investigation and resolving the issue. We will update you on this thread the soonest we have some results.

Regards,

[DCM API (DoubleClick Campaign Mgr)]

Hi Tony,

I hope you are doing well.

As per our investigation, you are using encrypted user ids (setting the field encryptedUserId). However, you aren’t specifying encryption info in your requests: https://developers.google.com/doubleclick-advertisers/guides/conversions_upload#specify_encryption_info. Thus, it led to a request error.

In regards to surfacing the error, we are currently working on a request error with a useful error message.

Best Regards,

Angel Maia DCM API Team

ref:_00D1U1174p._5004Q2eOsF3:ref