Toggle Side Panel
Close search

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