customermatchlist with email phone and addresss identifiers

111 views
Skip to first unread message

Ramakumar Adavakkad

unread,
Jul 8, 2022, 7:45:38 AM7/8/22
to Google Ads API and AdWords API Forum
Hi
We extended the code using google c# example and populated the customerlists from csv
our csv file contains the following columns to populate  email, first name , last name , phone , zip , country

suppose if we have 1000 records in the csv file then we end up adding 3000(1000*3) useridentifier one each for email , phone and address
is there a way to include all the info in one useridentifier , we tried that but it was giving very low parentage of match rate when compares to manual upload using UI

referred google's sample code below , please suggest if there is a way to include all the user info in one identifier that will give the same match rate as manual upload


            UserData userDataWithEmailAddress = new UserData()
            {
                UserIdentifiers = {
                    new UserIdentifier()
                    {
                        // Hash normalized email addresses based on SHA-256 hashing algorithm.
                        HashedEmail = NormalizeAndHash("cust...@example.com")
                    }
                }
            };

            // Creates a second user data based on a physical address.
            UserData userDataWithPhysicalAddress = new UserData()
            {
                UserIdentifiers =
                {
                    new UserIdentifier()
                    {
                        AddressInfo = new OfflineUserAddressInfo()
                        {
                            // First and last name must be normalized and hashed.
                            HashedFirstName = NormalizeAndHash("John"),
                            HashedLastName = NormalizeAndHash("Doe"),
                            // Country code and zip code are sent in plain text.
                            CountryCode = "US",
                            PostalCode = "10011"
                        }
                    }
                }
            };
            // [END add_customer_match_user_list_2]

            // Creates the operations to add the two users.
            return new OfflineUserDataJobOperation[]
            {
                new OfflineUserDataJobOperation()
                {
                    Create = userDataWithEmailAddress
                },
                new OfflineUserDataJobOperation()
                {
                    Create = userDataWithPhysicalAddress
                }
            };
           
           
            Thanks
            Ramakumar

Google Ads API Forum Advisor

unread,
Jul 8, 2022, 11:21:56 AM7/8/22
to ramakumar...@more2.com, adwor...@googlegroups.com
Hi Ramakumar,

Each UserData which maps to one user can have many UserIdentifiers with each UserIdentifier having only one identifier.  For example, if you have an email address, a physical address and a phone number for each of your 1,000 users, then you will have 1,000 UserData each one having 3 separate new  UserIdentifiers with each one of the UserIdentifiers being a specific type of identifier. If one of the users has another  phone number then that user's UserData will have an extra new UserIdentifier being a hashed_phone_number identifier.

If the above doesn't help, could you send us a 'DEBUG' log level request and response log of raw API communications of your upload?

The request and response appears similar to the JSON Mappings in our REST documentation with additional headers and information such as request Id. Here are logging instructions for our .NET Ads API Client Library.

You may send the requested information via "Reply to author" or via googleadsa...@google.com with a link to this forum post added to the new thread.

Regards,

Google Logo
Aryeh
Google Ads API Team
 


ref:_00D1U1174p._5004Q2cTvmj:ref
Reply all
Reply to author
Forward
0 new messages