La función ___________ se puede usar para anexar una cadena a campos de ID (como campaign_id), lo que evita problemas al leer los valores de ID precisos dentro de Excel.

The CONCAT function is used to combine two or more strings into a single string. When dealing with ID fields like campaignid in Amazon Marketing Cloud (AMC), Excel may sometimes misinterpret long numerical IDs as scientific notation or lose leading zeros, altering the precise value. By concatenating a non-numeric character (e.g., a letter or a special symbol) to the ID, you force Excel to treat the entire field as text, preserving the exact ID value. SUM is for adding numerical values, and COLLECT is typically used in other programming contexts to gather elements into a collection, neither of which addresses the data type interpretation issue in Excel.