Activity › Forums › Salesforce® Discussions › How do I extract data from Salesforce Marketing Cloud?

  • Pooja

    Member
    July 27, 2020 at 6:49 am
    1. Click Create Activity.
    2. Select Data Extract.
    3. Add a name, external key, and description for the activity.
    4. Enter a file naming pattern so that the activity knows what to name the file it creates. Use the following personalization strings in your filename:<div>
      <div>NOTE Ensure that the filename patterns match in the Data Extract Activity and the File Transfer Activity.

      1. Use when you’ve set up a workflow to drop a file whose auto-generated filename matches a pattern into the file location.
      2. Enter a static name or include placeholders for the date, keeping in mind that they are case-sensitive. If a filename includes personalization strings that are capitalized, capitalize them in the file naming pattern.
      3. Include a .zip extension for tracking extract and .csv to a data extension extract.

      </div></div>

    5. To determine the web analytics tools used to interpret the extracted file, select an extract type. The value you select determines the data you can include in the files.<div>
      <div>NOTE Extract types must be provisioned for your account. Contact your Salesforce Marketing Cloud representative for more information.

      </div></div>

    6. To determine the date range for information to include in the extract file, select an extract range. Choose 1 day, 7 days, or 30 days.
    7. Select a type of file encoding to use.
    8. Configure the extract by choosing the fields that appear in the data extract file.
      1. Select a field name to include it in the data extract file.
      2. If the data extract you choose includes the columnDelimiter field, insert the character you wish to use as a delimiter within the data extract.
      3. Valid choices include the following characters:<div>
        • ,
        • tab
        • I

        <div>
        <div>NOTE When setting time zone for a tracking extract output file, select Use Local TZ in Query. When this option is not selected, the output file defaults to Central Standard Time and does not observe Daylight Savings Time. This option is not available for data extension extracts.

        </div></div></div>

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos

Report

Harassment or bullying behavior
Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Mobile App Reported Contents
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .