At Google Ads Customer Match offer execution, if the offer's Mode of operation is set to 'Create new list', a new audience list with the specified name is created in the Google Ads account. If a list with the same name already exists, it is used instead of creating a new one. Records are then added to the list. When Mode of operation is set to 'Append to existing list', records are added to the audience list specified at the offer. Google Ads ignores records that are already in the list. When Mode of operation is set to 'Delete from existing list', records are removed from the audience list specified at the offer. Google Ads ignores records that are not in the list.
Successful uploads will add rows to the OfferHistory_GoogleAdsCustomerMatchTracking data warehouse table. Its structure is as follows:
•Audience List ID: the ID of the audience list where the record was inserted/removed
•Channel Execution ID
•Date Sent
•Channel ID
•Contact Info: pre-hashed value of the email or phone number, or non-pre-hashed value of third-party ID or mobile device ID
•First Name
•Last Name
•Country Code
•Postal Code
•City
•State