Create a Chat Messaging Data Extract in Marketing Cloud Engagement

Use Automation Studio and Contact Builder to create Chat Messaging Data Extracts and learn more about your message metrics.

1. In Automation Studio, click New Automation.
2. Drag the Data Extract activity to the Automation canvas.
3. Click Choose.
4. Click Create New Data Extract and create a data extract file.
   1. Select ChatMessagingDetailExtract.
      If you’re using wildcards in your file name, only use trailing ones. For example, test_mo_log_%%Year%%%%Month%%%%Day%%.zip.
   2. Channel ID: The phone number for your WhatsApp channel. Use the country code and phone number with no symbols.
   3. Channel Type: WHATSAPP.
   4. Include MOLog: Provides a raw data file with inbound messages from customers.
   5. Include Tracking Detail: Provides detail disposition for Sends and the corresponding Inbound Tracking. If you choose to not include tracking details, some delivery receipts aren’t included if they’re near the end of the set sending time period. If you use a rolling range, you get a complete dataset.
   6. Include Potential Bounces: WhatsApp doesn’t provide unsubscribe information. If a user hasn’t received a message three times in the last 30 days, they’re counted as bounced users. It’s possible bounced users opted out and blocked the brand’s WhatsApp channel.
5. Create a File Transfer activity. Use the same file-naming pattern as the Data Extract activity.
   When you run the data extract, the file is stored in a Salesforce Safehouse. The file transfer activity moves the file to a configure file location.
6. Retrieve your files from the SFTP server.
   
   • Tracking file name: chat_{filename}_tracking.csv
   • Inbound messages file name: chat_{filename}_inboundmessagelogs.csv
   • Potential unsubscribes file name: chat_{filename}_potentialunsubs.csv
   • Example log file name with date: chat_test_mo_log%%Year%%%%Month%%%%Day%%_tracking.csv
7. Import your information into a data extract.
   1. In Contact Builder, create a data extension.
   2. In Contact Builder, create an import definition.