Marketing Cloud Engagement : Importing MobilePush Detail Extract Reports to a Data Extension

The Data Extract Activity for the MobilePush Detail Extract Report outputs results to the Safehouse as a .zip file. Before you can import this data into a Data Extension, you must configure a File Transfer Activity to unzip the file.

Use one of the following methods to configure your automation workflow in Automation Studio.

1. Import via Safehouse (Recommended)

This method keeps the file within the Safehouse for unzipping and importing, without transferring it to an external SFTP server.

1. Navigate to Setup > Data Management > File Locations and click Create.

2. For Location Type, select Safehouse. Give it a name and save.

3. In Automation Studio, create a File Transfer Activity to run immediately after your Data Extract Activity.

4. Configure the File Transfer Activity as follows:

   • File Action: Manage File

   • Manage File Action: Unzip Compressed File

   • Source File Location: Select the Safehouse location created in Step 2.

   • File Naming Pattern: Enter the exact output filename specified in your Data Extract Activity (e.g., Report.zip).

5. Create an Import Activity to run immediately after the File Transfer Activity.

6. In the Import Activity, set the File Location to the Safehouse location created in Step 2.

7. For the File Naming Pattern, enter the filename of the unzipped file (e.g., MobilePushDetailExtractReport.csv) and complete the configuration.

2. Import via SFTP

This method involves moving the file to the Enhanced FTP (SFTP) server before processing it.

1. Navigate to Setup > Data Management > File Locations and create a location that points to your desired directory on the SFTP server (or use an existing location).

2. In Automation Studio, create the first File Transfer Activity to run immediately after the Data Extract Activity.

3. Configure this first activity to move the file from the Safehouse to the SFTP:

   • File Action: Move a File From Safehouse

   • Destination: Select the SFTP location from Step 1.

   • File Naming Pattern: Enter the output filename specified in the Data Extract Activity (e.g., Report.zip).

4. Create a second File Transfer Activity to run after the first one.

5. Configure this second activity to unzip the file on the SFTP server:

   • File Action: Manage File

   • Manage File Action: Unzip Compressed File

   • Source File Location: Select the SFTP location from Step 1.

6. Create an Import Activity to run after the second File Transfer Activity.

7. Set the File Location to the SFTP location from Step 1 and use the unzipped filename to define the import.

Important Notes

• Ensure that the File Naming Pattern always includes the file extension (e.g., .zip or .csv).

• Verify that the filename specified in the Data Extract Activity matches the filename used in the File Transfer Activity exactly.