Upload a customer list to the audience manager using google ads api

[chaithanya M S]

Hi Team,

I am trying to upload a new customer list on the audience manager dashboard via an API call 

I was able to upload 33333 customers at once (considering each row in my csv as 1 customer) successfully however if my customer list is any bigger than that I am getting the following error  

Request with ID 'FVQ6A4****gcXC8w' failed with status 'INVALID_ARGUMENT' and includes the following errors: Error with message 'Maximum number of user identifiers allowed per request is 100,000.'.

My data has

Email, First Name, Last Name, Country, Zip, Phone columns and I referred the information on this website to build my data operation list. https://ads-developers.googleblog.com/2021/10/userdata-enforcement-in-google-ads-api.html

so each customer in my list would have 3 user_identifiers and the current limit is 100000 so 100000/3 = 33333 is the customer limit. I read in Jan the limit will be reduced to 20 does it mean the number of customers I can upload through 1 API call would be 6 (20/3) ?

Is my understanding correct? Please help me understand the change. I am attaching below my implementation for build_offline_data_job_operations method and the output of the same for further reference and understanding

Also if I want to upload customer list 50k customers would it be possible? If yes, what is the right approach? Is there a limitation associated with that ?

Thanks in advance,

Chaithanya

[Google Ads API Forum Advisor]

Hello,

Thanks for reaching out. For the upcoming change in January, the only difference is that only 20 user identifiers may be specified per UserData object. This is to emphasize that data representing different users are not grouped together in a single UserData object. The same amount of data can be transmitted for each request, but you must break up your OfflineUserDataJobOperations so that each UserData set represents a single user. This should resolve the error. 

If you continue to have issues with this, please privately send us your complete request and response logs.

Regards,
Matt
Google Ads API Team

 
Reminder: Share your feedback about the Google Ads (AdWords) API! Take the 2021 Google Ads API and AdWords API Annual Survey
 

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2Scdit:ref

[chaithanya M S]

Thanks for your reply Matt, I am taking reference of the following code https://github.com/googleads/google-ads-python/blob/main/examples/remarketing/add_customer_match_user_list.py for uploading a new customer 

My list has 38k customers. Each customer has email, phone and address data. 

I am confused about how I could  break up the OfflineUserDataJobOperations. 

Is it supposed to be done in _build_offline_user_data_job_operations or _add_users_to_customer_match_user_list ?

It would be great if you are able to give me a reference of how I could add  OfflineUserDataJobOperations for multiple users.  

[chaithanya M S]

Also, If my developer token has Basic access either in Test or production accounts there is a limit of 15,000 operations / day & 1,000 requests /day. Does it mean I can upload a list of max size 15000 considering each user has a 1 operation ?

Best,

Chaithanya 

[Google Ads API Forum Advisor]

Hello,

User lists are not supported in test accounts. You are limited to 15,000 operations per day with Basic Access. However, the 1,000 request limit only applies to GET requests, so limit is not relevant here.

The function, _build_offline_user_data_job_operations, should be used to create a user data set for just one user and one operation. That operation is then added on line 137:

    response = offline_user_data_job_service_client.add_offline_user_data_job_operations(
        request=request

However, for Python client library specific questions, please reach out to the client library owners here.

[chaithanya M S]

So you mean with basic access I can only upload 15000 customers to my list per day?

[Google Ads API Forum Advisor]

Hi,

Thanks for getting back to us.

Based on this document, it says that the basic access level allows the developer token to execute up to 15,000 operational requests per day and 1,000 get operations per day only. With this, if you want to have unlimited operational requests per day, then upgrading to the standard access tier does not have operations per day limit, but is subject to the global limits. For more information on requests, you may refer to this guide.

Let us know if you have any further questions.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2Scdit:ref

[chaithanya M S]

perfect thank you.

so one operation per customer it is !!

(please correct if I am wrong ) 

[Google Ads API Forum Advisor]

Hi, 

I work with Yasar and will assist you. Each userdata created or mutated is one operation so basica access can do 15,000 a day.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2Scdit:ref

[chaithanya M S]

Hi All,

Let say I have 2M records and I created 2M operations. How many API calls is required to process these 2M operations?

Is it 1 API call or 2M API calls?

If it is 1 API call how do we modify the attached call to accommodate 2M operations?

Thank you,

Chaithanya

[Google Ads API Forum Advisor]

Hi Chaithanya,

Thank you for reaching out to us.

The mutate method lets you send a single API call that contains multiple operations on different resources. You check this documentation for more information, but please note that the Google Ads API enforces limits on API operations, such as the number of operations that can be sent in a single mutate request, kindly check this documentation to see the API Limits and Quotas.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2Scdit:ref

[Jonhatan David Fajardo Portillo]

Hi, I'm getting the same issue

'Maximum number of user identifiers allowed per request is 100,000 and per operation is 20., at operations[0].create'

Is there another method for uploading it?