MARKETING-CLOUD-EMAIL-SPECIALIST practice question 21 of 25

Northern Trail Outfitters' marketing manager wants to schedule a report to be sent weekly to an Azure Blob regarding the performance of a holidays campaign. Which tool should they use?

Full set: 161 questions
Answer options
A: Campaign Email Tracking Report
B: Datorama pivot Table
C: Tracking Data Extract file transfer Correct answer
Correct Answer:
C. Tracking Data Extract file transfer
Explanation

The most effective method to meet this requirement is using Automation Studio. A Tracking Data Extract activity is designed to pull raw email performance data (sents, opens, clicks, etc.) for specific campaigns into a file. This file is placed on the Marketing Cloud SFTP. Subsequently, a File Transfer activity within the same automation can move this extracted file from the Marketing Cloud SFTP to an external location, such as an Azure Blob storage account configured as a file location. This entire process can be scheduled to run weekly, fully automating the delivery of the performance report.

Why Incorrect

A. Campaign Email Tracking Report: This is a standard report in Analytics Builder. While it can be scheduled for email delivery, it is not designed for automated file transfers to external storage systems like Azure Blob.
B. Datorama pivot Table: Datorama (Marketing Cloud Intelligence) is a powerful analytics and visualization platform. It is not the primary tool for simple, scheduled raw data file extractions and transfers to an external file location.

References

1. Salesforce Help: Tracking Extract: "Use the tracking extract to find data related to your Marketing Cloud emails... This extract puts the results in a ZIP file that you can deliver to your FTP site." This confirms the use of a tracking extract for performance data. (Salesforce Help, Document: Data Extract Activity, Section: Tracking Extract).

2. Salesforce Help: File Transfer Activity: "Use the file transfer activity to... move a file from the Marketing Cloud's secure file transfer location... to a designated FTP location." This confirms the ability to move the extracted file. (Salesforce Help, Document: File Transfer Activity).

3. Salesforce Help: Azure Blob Storage as a File Location: "You can use Microsoft Azure Blob Storage as a file location in Marketing Cloud. Use Azure Blob Storage to transfer files to and from your Marketing Cloud account." This confirms Azure Blob is a supported destination for the File Transfer activity. (Salesforce Help, Document: Microsoft Azure Blob Storage).

4. Salesforce Help: Automation Studio: "Automation Studio is a Marketing Cloud application used to execute multi-step marketing and data management activities on an immediate, triggered, or scheduled basis." This confirms that the extract and transfer process can be scheduled weekly. (Salesforce Help, Document: Automation Studio).

Scroll to Top