Start preparing for your Next Exam | Use coupon – TOGETHER | Avail 30% discount

Describe data extraction and report generation solutions

  1. Home
  3. Describe data extraction and report generation solutions

Data extraction in Salesforce Marketing Cloud is important.

Data Extract Activity or Data Extraction

  • It is in the Automation Studio
  • The activity creates zipped files for using outside the Marketing Cloud
  • It convert an XML file into
    • comma-delimited
    • tab-delimited
    • pipe-delimited file
  • File Transfer Location is needed
  • Fields included depend on the Extract Type
  • Extract Range or date, can be set
  • Every extract types does not use date range

Send Logging

  • It is in Email Studio
  • Gives information on email send attributes
  • Data is used in reports and data extracts.
  • Dat can also be used in send log for highly available clicks.
  • Send logging data is not available by standard tracking functions.
  • Data retention can be set
  • Data extension with send logging template is needed

SQL Query Activity

  • Get data extension / data view information
  • It is in Automation Studio
  • query gets data extension / data view as per criteria
  • use SQL for developing the query
  • Executes SQL statements for maximum 30 minutes
    • if more time is needed, error status is given

Data Views

  • A maximum of 6 months of cloud journey
  • Used by Automation Studio

Email Studio Reports

  • A/B Test Summary
  • Account Send Summary
  • Attribute by Tracking Event
  • Campaign Email Job Tracking Summary
  • Campaign Email Tracking Summary
  • Carrier Deactivation Summary Report
  • Conversion Tracking Statistics
  • Email Message Frequency
  • The Email Performance by Attribute
  • Email Performance by Domain
  • Report on Email Performance by List
  • Email Performance for All Domains
  • The Email Performance Over Time
  • Email Send
  • The Email Sends by User
  • Email Send Performance by Audience Builder Segment
  • Forwarding Activity Details
  • Impression Tracking by Job
  • Impression Tracking for Triggered Send by Period
  • List Demographics
  • The List Performance Over Time
  • List Size Over Time
  • Multi-Campaign Tracking Summary
  • Recent Email Sends Summary
  • Region Performance for Triggered Sends Over Time
  • Region Performance Over Time
  • Response Trend Analysis for Email Send
  • The Send Classification by Email Tracking Report
  • Sendable Data Extension Demographics
  • The Sendable Data Extension Performance Over Time
  • Single Email Performance by Device
  • Spam Complaints Over Time
  • Subscriber Engagement
  • Subscriber Most Recent Activity
  • Subscribers Not Sent To

Discover Reports

  • Audience Engagement Over Time
  • Best Performing Send Day
  • Deliverability Complaint Rate
  • Device Performance by Email Sends
  • Email Performance by Device
  • Email Sending Performance
  • Recent Email Send Summary
  • Time Between Send and Engagement

Reference: Salesforce

Menu