Questions tagged [data-extract]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
56 views

File Name Pattern in Data Extract Activity

In the Data Extract activity, we can use the File Name Pattern to define the exported file name, but we can only use the following personalization strings in the filename: %%Year%% %%Month%% %%Day%% %%...
user avatar
0 votes
0 answers
25 views

Data Extract activity is changing the physical order of records

I have the next issue when exporting a CSV file to a SFTP location: It's about a daily automation, the process consists in three steps, one for data extract, a second one to convert the file to UTF8 ...
user avatar
0 votes
0 answers
20 views

Minutes and seconds wildcard specifiers preventing file selection from Safehouse in automation Studio activity

Within Automation Studio we have a Data Extract activity that results in a csv file in safehouse. The issue we are experiencing is that the file naming pattern requires minutes and seconds eg ...
user avatar
  • 13
0 votes
1 answer
54 views

Data Extract not pulling unsubscribe record

I used a logunsubevent request to unsubscribe a subscriber and after that, I looked for this subscriberkey in the _unsubscribe data view. It shows up fine. I am running data extract with below steps ...
user avatar
0 votes
1 answer
35 views

Data Loss in File Convert Data Activity Extract

Has anyone experienced a loss of data from "File Convert" Data Extract Activity? I am exporting a synchronized data extension: Step 1: Data Extract Activity - Export DE Step 2: Data Extract ...
user avatar
0 votes
1 answer
129 views

File convert to UTF8

I'm trying to extract the journeys data with data views and put the generated file in FTP with UTF format. After configuring the query and the Data extract activity (Data extract from Data extension), ...
user avatar
0 votes
1 answer
377 views

salesforce Dataloader : field 'Description' can not be filtered in a query call

I am using dataloader to look for and extract certain emails(tasks) that must have the word "igloo" in them, I tried to do 'description' contains "igloo" and got an error saying ...
user avatar
0 votes
2 answers
82 views

Include The journey name in Data extract file

I'm working on a data extraction. I implemented it with a file transfer to my FTP, it's for "Sent" journey feedbacks. My customer would like to have the "journey name" in the ...
user avatar
0 votes
1 answer
115 views

SFMC FTP Delete is not working

Cannot seem to delete files from the SFTP in Automation Studio. It returns success but doesn't delete. Step 0) Transfer file hello_world_2021-05-27T17-06-19Z.csv to sftp import folder. Create ...
user avatar
  • 188
1 vote
1 answer
154 views

Data Extension or Data Export log

I would like to see who has been exporting data from our data extensions in the past year but I am not sure if this functionality is available in Marketing Cloud. I have tried with Audit Trail (I have ...
user avatar
0 votes
1 answer
167 views

Importing File from Marketing Cloud Safehouse with Field Level Encryption

We have automations that run nightly which export business-critical data extensions to our Safehouse in case Marketing Cloud takes a tumble and all our data is lost. Some of these fields in the data ...
user avatar
0 votes
1 answer
381 views

Rest API to create/update data extract activity is not working

Could someone please point out the mistake in the below script? var restapi_url = "https://XXXXX.rest.marketingcloudapis.com/automation/v1/dataextracts"; var restapi_payload = '{"name&...
user avatar
0 votes
0 answers
81 views

How to convert extracted .csv file from SFMC Data Extension to FTP location with UTF 8 Encoding? [duplicate]

I am successful in extracting data into .csv from data extension to ftp location using Data Extension Extract API. The issue I am facing here is extracted .csv file is having some other Encoding type ...
user avatar
1 vote
1 answer
579 views

Transferring data from Salesforce MC to GCS

My company asked me to find a way to transfer a data extract from Salesforce Marketing Cloud in a Google Cloud Storage bucket, so that they can bring it into Data Studio or Analytics. I've done some ...
user avatar
  • 11
0 votes
0 answers
755 views

Data Extract File Convert activity throwing error

While converting File format from UTF-16le to UTF-8 in Automation studio using Data Extract (File Convert), I am getting error but not able to understand what error is coming as Automation Studio ...
user avatar
0 votes
0 answers
499 views

Data export: Views vs Tracking Extract

If we have to make a choice at this moment, on which process we are going to use to extract daily campaign data from SFMC to an external data warehouse, what would be the best (future proof) solution. ...
user avatar
1 vote
1 answer
752 views

Extracting and exporting (file transfer) SQL query from automation/data extension in Marketing Cloud

There is a database extension in salesforce marketing cloud that I need to export from the automation. I didn't create the DE and am unsure how to export it for use outside of salesforce marketing ...
user avatar
1 vote
1 answer
493 views

Does anybody know how to update Data Extract Activity via SOAP API?

I have a question on how to update Data Extract Activity using SOAP API. I found a document about the Supported Methods of SOAP API in Marketing Cloud: https://developer.salesforce.com/docs/atlas.en-...
user avatar
0 votes
1 answer
173 views

Exporting Pardot Campaigns

I need to extract the whole information included in Pardot Campaigns and elements inside them like prospects actions and any other activity results. The user is synced to Salesforce, so it seems that ...
user avatar
2 votes
0 answers
391 views

SFMC XML data extract - input file name wildcards

We are using an automation that is triggered by a file drop on the FTP. In this automation there is a Convert XML Data Extract Activity to convert the dropped XML file to a CSV file which can be ...
user avatar
0 votes
1 answer
315 views

Export a data extention to FTP using automation?

I searched around for this and found a thread Using Automation Studio to Export a Data Extension But it did not really answer my question. I have a data extension that is created and an automation ...
user avatar
  • 113
0 votes
1 answer
71 views

Is Data Extract necessary if there is already a File Transfer? [closed]

Because FileTransfer already is able to do encryption/decryption, I wonder if it is necessary Data Extract in combination with it, in such 2 use case scenarios: posting encrypted list to MC file is ...
user avatar
  • 281
0 votes
0 answers
39 views

If a data extract is perfomed via api will it be displayed in automation studio?

I want to trigger a data extract activity in marketing cloud using SOAP api but i don't want that activity to be visible under automation studio activities(suppose i'm an ISV, I dont want my client to ...
user avatar
  • 3
1 vote
1 answer
244 views

Import Tracking Extract into DE

I'm attempting to create my own DE's of the tracking exports so that I have a consolidated view of tracking data since I can only pull 30 days at a time using the Tracking Extract (Data Extract ...
user avatar
0 votes
1 answer
66 views

Data Extract Audience Studio Format

We are currently implementing Audience Studio, one piece needed in our project is a first-party import. My initial thought for this was to use a data extract activity in the marketing cloud to do this ...
user avatar
2 votes
4 answers
3k views

Extract unsubscribes

I need to export all our unsubscribes in Marketing Cloud and I'm having trouble doing this. I have tried exporting All Subscribers, but due to the volume of records ~15M Marketing Cloud takes almost ...
user avatar
  • 125
0 votes
1 answer
131 views

Extract Record data from the record Id

All, Quick question! A custom Order object and Order lines are generated via a trigger from the Opportunity and Opportunity Products. Opportunity and Order have lookup relations between each ...
user avatar
  • 25
1 vote
0 answers
907 views

How to use a Data Extract to send tracking activity to an SFTP

I am trying to set up my first data extract activity, and I'm having a lot of trouble with the basic setup because I don't truly understand what the activities do. I'm trying to do a tracking export ...
user avatar
  • 162
0 votes
1 answer
457 views

Tracking Extracts not available under the Data Extracts activity

As the title explains, in Automation Studio, when I create a new Data Extract activity I do not see the option to set it to "Tracking Extract". According to the documentation, I should be able to see ...
user avatar
2 votes
1 answer
5k views

Salesforce MC - How to data extract in UTF8 to FTP

I'm having problems trying to export a data extension from Salesforce Marketing Cloud to FTP. I created an Automation to extract this file, but I want to extract in UTF-8, my database only import ...
user avatar
  • 23
1 vote
1 answer
770 views

How to perform data extract hourly for current day

When configuring a Data Extract Activity in Automation Studio there are two date options available : Rolling Date Range This option allows you to choose a 1 Day rolling range at it's most specific, ...
user avatar
  • 13
2 votes
1 answer
1k views

Error on completion of Data Extract and File Transfer

I'm currently experiencing an error on the Automation Studio with related to the Data Extract - One of the activity get failed by "Error has occurred" and File Transfer - one of the activity flagged "...
user avatar
  • 21
0 votes
1 answer
225 views

Write to LIST from a DATA EXTENSION

I am trying to pull subscriber information from a Data Extension, and then add it into a custom list. I understand that the ideal process is to create a data extract, then import the CSV into the ...
user avatar
  • 115
0 votes
1 answer
995 views

Data extract to SFTP subfolder

I'm trying to export a file to an external SFTP but there is no parameter to select a subfolder on the SFTP. there is no options either in the file location or in the data extract activity. it seems ...
user avatar
  • 3
1 vote
2 answers
2k views

Can I move files between Marketing Cloud FTP SUB-folders?

Our usecase: after import we want to move a file (using automation) from one (enhanced)FTP sub-folder to another(enhanced)FTP sub-folder (archive). The sub-folders are both in the main folder \import. ...
user avatar
4 votes
1 answer
5k views

Marketing Cloud Data Extract into the correct File Encoding format

I have created a Data Extract activity exports a .csv file containing records from my Data Extension. The file is in the wrong File Format so I have requested Salesforce activate additional encoding ...
user avatar
2 votes
1 answer
2k views

What timezone is used for Data Extract Activity filename date placeholders/parameters and is it configurable?

Assume we have a Data Extract Activity in a SFMC Automation workflow. In those activities, you can specify the output filename with date parameters/placeholders: Enter a file naming pattern so that ...
user avatar
  • 121
1 vote
0 answers
441 views

Extract Marketing Cloud Users Information in a CSV File

How can I extract all information of my users like username, rules and BUs access, but I heard that action it's only possible using API? I'm not a tecnical user. I searched for information on how to ...
user avatar
1 vote
1 answer
678 views

Click data view wont' save in data extension

So, I am seeing a very odd behaviour. When I run this query to dump all click data view data in a data extension, I see the record count going up...it goes into x millions and then suddenly the count ...
user avatar
  • 533
1 vote
0 answers
28 views

Filtering link tracing/checking from click data extracts?

In early February, my company noticed a significant uptick in click activity in our data extracts. Deliveries, opens, bounces, and everything else remained normal. I opened a ticket with SFMC ...
user avatar
  • 83
7 votes
2 answers
2k views

Zip data extract and push to an external FTP

I am needing to zip and push data extension extract files to an external ftp. I recently enabled the 'zip' extract type in the account, which allowed me to zip files stored on the marketing cloud FTP ...
user avatar
  • 2,585
3 votes
1 answer
3k views

Limitations for Import from Enhanced FTP in SFMC

I am using Data Extract -> File Transfer -> Import via an automation to upload my synchronized data extensions to All Subscribers in Marketing Cloud. Currently everything seems to work fine, however ...
user avatar
2 votes
0 answers
877 views

Automation generates yesterday's data and file name when run early morning (fine under other hours)

We have an automation to export the people in a Data Extension with the LastDeliveryDate value equal to 21 days ago. The file will end up on an SFTP server that is not Salesforce's own Enhanced server....
user avatar
3 votes
1 answer
3k views

Data Extract of data extension to Enhanced FTP

I am trying to extract Contact Keys from a data extension so that I can load them back into the system to unsubscribe them. I am gathering these contact keys from multiple SQL Queries to different ...
user avatar
1 vote
1 answer
986 views

Extract mobile connect list of unsubscribes

I have tried to find information about how to automate the export of MobileConnect status for unsubscribes with stop-code. I've found this official documentation about querying data views as ...
user avatar
2 votes
2 answers
715 views

Export all subscribers file content is in hexadecimal, I need it to be readable text

I have an automation to export all subscribers to fetch the "status" column. My shceduled automation extracts the all subscribers list and then drops the file on the dedicated FTP with correct name ...
user avatar
0 votes
2 answers
53 views

Exiting Salesforce

Our organisation has made a decision to stop using Salesforce which means i need to extract all of the data from the system. I have ran the Data Extract funcationality, however this extracts all of ...
user avatar
  • 1
0 votes
1 answer
51 views

How does the new Data Extract interface compare to the old one?

I am trying to perform a data extract via the new "lightning enabled interface" in Automation Studio. I have the configuration below, but it keeps erroring. I have searched for documentation, but ...
user avatar
  • 6,459
1 vote
1 answer
86 views

Is it possible to create an automation that exports a list (not a DE) to an FTP?

I need a way to automatically export a list (not DE) to an FTP. I know this is possible when using DE's, data extracts, and file transfer activities. However, no documentation seems to exists when ...
user avatar
  • 171
1 vote
1 answer
383 views

Data extract UserAgent with Mac

We are running data extract on a daily basis, recently we added the 'Include User Agent Information'. Checking the consistency of the data we have found a user who opens the email with a Mac and ...
user avatar
  • 831