Get Granular Bounce Data in Bulk for CMCA Exam | Salesforce Marketing Cloud

A

As a Marketing Cloud Administrator, you have been asked to retrieve granular bounce data in bulk in a pre-defined format for the last 30 days. To achieve this, you have three options to consider:

A. Automation Studio Tracking Extract: One option is to use Automation Studio Tracking Extract. Automation Studio is a tool within Marketing Cloud that enables users to automate and schedule a wide range of tasks. By creating a tracking extract in Automation Studio, you can retrieve the bounce data from your Marketing Cloud account.

To get started with Automation Studio Tracking Extract, you will need to:

1. Create a data extension that contains the fields you want to extract.
2. Create a tracking extract definition.
3. Schedule the tracking extract to run at a time that suits you.
4. Download the resulting file.

This option is suitable for extracting large amounts of data from Marketing Cloud in bulk. The extracted data can be in a pre-defined format, such as CSV or TXT.

B. CSV download of bounce data in My Tracking: Another option is to download a CSV file of bounce data from the My Tracking section of Marketing Cloud. To access this data, follow these steps:

1. Navigate to Email Studio in Marketing Cloud.
2. Click on My Tracking.
3. Select Bounces from the dropdown menu.
4. Specify the date range you want to retrieve data for.
5. Click Export Data.

This option is suitable for smaller amounts of data and is quick and easy to use. However, the data will not be in a pre-defined format.

C. Sent Data View Query: The third option is to use a query against the Sent Data View to retrieve the bounce data. The Sent Data View contains all the data related to the email sends, including the bounce data. This option requires a knowledge of SQL.

To get started with this option, you will need to:

1. Navigate to Query Studio in Marketing Cloud.
2. Create a new query.
3. Select the Sent Data View as the source.
4. Filter the query to only retrieve data for the last 30 days.
5. Select the fields you want to extract.
6. Run the query.

This option is suitable for more advanced users who have experience with SQL queries. The data extracted from the Sent Data View can be in a pre-defined format, such as CSV or TXT.

In summary, as a Marketing Cloud admin, you have three options to retrieve granular bounce data in bulk in a pre-defined format: Automation Studio Tracking Extract, CSV download of bounce data in My Tracking, or Sent Data View Query. Choose the option that best suits your needs and level of expertise.