Marketing Cloud Administrator Certification Study Guide–Part 5: Maintenance

This section of the exam makes up 15% of the overall exam, ~9 questions and tests these topics.
• Data cleanup
• Reports
• Other Marketing Cloud products
• Managing Marketing Cloud accounts

Data Extracts: The Automation Studio data extract activity creates one or more zipped files for your use outside the Marketing Cloud application. It can also be used to convert an XML file into a comma-delimited, tab-delimited, or pipe-delimited file for import into your account.

Tracking Extract

Tracking extracts provide granular tracking data for import from Email Studio into external systems. Use tracking extracts to export granular data regarding several different aspects of email send jobs, such as clicks, bounces, and survey data, from Marketing Cloud. Then, import that information into an automation or system.

Range of time to include in the tracking extract.

  • For a Rolling Range, set the dropdown to 1, 7, 30, 60, or 90 days, to include every time you run the data extension extract.
  • For a Specific Range, enter the start and end dates in the calendar fields under the radio button. Select up to 30 days in your range.

Tracking extract outputs:

  • Attributes
  • Bounces
  • ClickImpressions
  • Clicks
  • Conversions
  • ListMembershipChanges
  • Lists
  • NotSent
  • Opens
  • SendJobImpressions
  • SendJobs
  • Sent
  • SentImpression
  • StatusChanges
  • Subscribers
  • SurveyResponses
  • Unsubs

Data Extension Extract: This data extract type extracts information from a Marketing Cloud data extension and places it in a delimited file.

Automation Studio Errors and Notifications: Add your email address so that you are notified when a Marketing Cloud automation’s run is skipped, encounters an error, or completes in Automation Studio.

Send Logs:  Send logging gives you access to data not available via standard tracking functions and to obtain run-time information about email send attributes for use in reports and data extracts. To use send logging, 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. Each data extension includes required fields with values used to identify the send, subscriber, and other information. 


Account Send Summary: This report shows total send and response data for your account. 

Discover Reports: You can use the Discover Reporting Tool in Marketing Cloud Analytics Builder to quickly and easily create reports. The Discover templates include measures and attributes to answer a specific business question. You can use one of the templates or start from scratch and build your own report

DataViews: Query data views using Automation Studio for up to six months of Marketing Cloud subscriber and journey information.

SQL Query: A query is an activity that retrieves data extension or data view information matching your criteria, then includes that information in a data extension

When you create an SQL Query activity, you write the SQL statement that defines the query. You can write the query against a data extension or the data views provided in the system. 

Marketing Cloud Trust Site

The Salesforce Trust site is made up of three sections.

  • System Status provides a visual representation of the health of her instances.
  • Security gives her an overview of Salesforce security practices.
  • Compliance shows her the standards that Salesforce is in compliance with.

You can access the Marketing trust site at:

Additional Resources:

Links to other topics:

6 thoughts on “Marketing Cloud Administrator Certification Study Guide–Part 5: Maintenance

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s