Which statement best describes the InsertDE function in Marketing Cloud?

• A. Inserts a row in a data extension and returns the inserted row value.
• B. Inserts a row in a data extension and returns the number of rows affected.
• C. Inserts a row in a data extension with the column values listed; returns no value.
• D. Updates an existing row in a data extension and returns the row count.

Answer: (C)

InsertDE is an AMPscript action that adds a new record to a Data Extension by supplying the extension and the values for its fields. You pass the column names and their corresponding values, and the function performs the insert without returning any data to the script. That’s why the best description is that it inserts a row with the column values listed and returns no value. It isn’t meant to return the inserted row or a count of affected rows, and updating an existing row is handled by a separate update/upsert operation. Use it when you simply want to create a new record and don’t need confirmation data back in your code.