Hi adsapi team, We are having an issue with match rate between Google Ads API and Google Ads UI
Reproduce steps: 1. Get raw data from local DWH with PHONE(in E.164 format) and EMAIL(with lower and uppercase) columns 2. Hash both columns with SHA256 encryption without normalizing the email (yes, I'm aware that the doc told me to normalized it before hashing) and write to csv file 3. Manually upload the csv file to audience A - got match rate of 91-100% and audience size of 1M-1.2M 4. Using Google Ads API to upload the same csv file to audience B - got match rate of 81-90% and audience size is 760K - 850K I've tried normalized the data before hashing, for the Google Ads UI it stay the same, but Google Ads API method drop drastically both in match rate and audience size I got some problems with "429 Resource has been exhausted (e.g. check quota)" before, but i've fixed it by rerun "AddOfflineUserDataJobOperationsRequest" to the same "offline_user_data_job_resource_name", not sure if it cause some operations to miss out I can provide you the user list ids, request-response logs and the python script if necesary Best regards, Ryan -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/5c8c4b6a-8e07-4500-bf02-787d41cb6483n%40googlegroups.com.
