How to setup Send Log Data Extension

Send Logging

Used in Email Studio to obtain run-time information about email send attributes for use in reports and data extracts
NOTE: Your account must be enabled to use the send logging and data extension features. If they are not enabled contact your account executive to enable this features

 

To use send logs

  1. create a data extension using the send logging template (Each account can use one template and data extension for email messages and one template and data extension for SMS messages)
  2. Each data extension includes required fields with values use to identify the send, subscriber, and other information. To keep additional information in the send logging data extension, create a column in the data extension to contain it
  3. The names of the columns in the send logging data extension must exactly match the names of the attributes or the fields in the sendable data extensions to log any values

 

Create a Email Send Logging Data Extension

Create a data extension in Email Studio to store email send log data

1. Click Subscribers.
2. Click Data Extensions

               

 3. Click Create From Template.

4. Select the checkbox for SendLog template

5. Click OK

6. Enter the name, external key and description for this data extension.

7. Leave the checkbox next to Used for Sending unchecked

8. Create additional fields for list attributes or data extension fields you would like to record in the send logging data extension

9.Select the Use Data Retention feature if desired

10. Click Save

 

Send Logging Best Practices and Tips

 

Here is a list of best practices for use of send logging in Email Studio.
  • Use data retention to limit the amount of data stored. Limit data storage to 10 days.
  • Add 10 or fewer custom fields to the send log.
  • Minimize the size of the fields used in a send log to the size required for the expected data.
  • Limit the number of activities concurrently using a data extension. For example, schedule a query activity or report that is reading from the Send Log to run at a different than a send that uses the Send Log.
  • Dates added are in UTC-6

Source: https://help.salesforce.com/articleView?id=mc_es_send_logging_best_practices.htm&type=5

Leave a Reply