Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs
7 votes
Accepted

Marketing Cloud Data Extract into the correct File Encoding format

I did a file export from a dataextension like this: DataExtract Activity1: Pattern: TEST_SAFEHOUSE_%%Day%%%%Month%%%%Year%%.csv ExtractType: Data Extension Extract Column Delimiter: ; Has Column ...
Johannes Schapdick's user avatar
6 votes
Accepted

How to perform data extract hourly for current day

You can use the SOAP API to programmatically define and execute a data extract, analogous to creating the data extract activity in automation studio, but with the benefit of being able to set the ...
Clayton VonDras's user avatar
5 votes
Accepted

Limitations for Import from Enhanced FTP in SFMC

File Imports are the most tried and true method of getting large amounts of data into SMFC. As for limitations -- most of the issues I've seen with imports haven't been with size or row counts -- it'...
Adam Spriggs's user avatar
  • 30.7k
4 votes
Accepted

Updating All Subscribers List with query, extract and import

Since you wanting to update the All Subscribers list (not a data extension), the correct field name is Email Address (note: the space). You will need to rename the header in your file to match or ...
David Devoy's user avatar
  • 2,615
4 votes

Extract unsubscribes

To get the statuses from a child business unit, run a tracking extract and include 'Extract Subscribers' and 'Include All Subscribers'. Typically I'll add this to an automation that then imports the ...
AnonWonderer's user avatar
  • 2,131
4 votes

Extract unsubscribes

Query the _Subscribers data view. Subscribers is not restricted to 6 months as other data views are. SELECT SubscriberKey FROM _Subscribers WHERE Status = 'Unsubscribed'
Josh de Blank's user avatar
4 votes

Is there any way to extract email list data along with the rendered subject line where dynamic subject line is used

Unfortunately the personalized content is not stored in Marketing Cloud unless the Send Log DE is already active. For the future sends you can use SendLog future though, that's the cleanest way to ...
Ali Eroglu's user avatar
3 votes
Accepted

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

I've never managed to do this with the SOAP API. However, you can hack the internal route pretty easily. Get the Data Extension Extract ID by inspecting the traffic in your browser while opening the ...
Macca's user avatar
  • 8,246
3 votes
Accepted

Salesforce MC - How to data extract in UTF8 to FTP

Here are some screenshots of an UTF8 DataExtract Activity:
Johannes Schapdick's user avatar
3 votes
Accepted

Data extract to SFTP subfolder

welcome to SFSE! I am afraid you are overthinking it. To set it to a subfolder, you need to create a file location specific to it. Here are the steps: Go to File Locations in Admin tab Click on ...
Gortonington's user avatar
  • 30.6k
3 votes

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

Exactly as @EazyE commented, you are doing a POST which is a 'create' and to update you need to do a PATCH which is update. Although the Endpoint is mostly the same, the Method has to be different. ...
Gortonington's user avatar
  • 30.6k
2 votes

Data Extension Extract using API

I know this is a late answer, but in case you haven't already solved this. Retrieveing data from a Data Extension The below sample includes a 'filter' to a specific email address, which is not ...
Gortonington's user avatar
  • 30.6k
2 votes

Help with incomplete Tracking Extract documentation

The answer is all there in the name of those two fields. Unique Clicks are uniqueness across everything. So if I click three different links in the email, I'm counted once under this. Unique Clicks ...
David Murphy's user avatar
2 votes
Accepted

Extract mobile connect list of unsubscribes

Probably the closest thing you can get to something like a Tracking Extract Activity would be to schedule a "SMS Message Detail Report" from within Analytics Builder and schedule it to save the file ...
Macca's user avatar
  • 8,246
2 votes
Accepted

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

I am assuming you are taking a tracking extract, so please see below for necessary tasks to export onto an FTP location and unzip: Create and execute your data extract / tracking extract Create a ...
Gortonington's user avatar
  • 30.6k
2 votes

Error on completion of Data Extract and File Transfer

The file is likely in use by another process. You can: Retry the activity or the automation that it's a part of if this error does not typically occur. If this error continues, ensure that the file ...
Jackson Chen's user avatar
  • 4,715
2 votes
Accepted

Tracking Extracts not available under the Data Extracts activity

This is explained further in documentation, under Extract Output Reference. Extract types must be provisioned for your account. Contact your Marketing Cloud representative for more information. ...
Rain's user avatar
  • 5,775
2 votes

Extract unsubscribes

Marketing Cloud unsubscribe has 2 settings: Unsubscribe subscribers from all Business Units Unsubscribe subscribers from this specific BU only. Assuming option 1 is in place the unsubscribe is ...
Peter Irving's user avatar
2 votes
Accepted

What is the permission set required to query all FlowInterview details?

Go to your Setuo > Sharing Settings. More likely than not, your Flow Interview is Org Wide Default Private Scroll down the page and create a Flow Interview sharing rule where the flow interviews (...
cropredy's user avatar
  • 71.8k
1 vote
Accepted

Extract unsubscribes

In All Subscribers, you can search by Subscriber Status. I searched all 'Unsubscribed' and was able to extract just unsubscribers with their unsubscribed date and reason.
gpribudi's user avatar
  • 125
1 vote

Export a data extention to FTP using automation?

You have to use a Data Extract and File Transfer activities to export a Data Extension: Data Extract configuration: The External Key field can be empty as it refers to the Data Extract activity ...
fromero's user avatar
  • 1,041
1 vote
Accepted

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

If you had your file in MC SFTP already, you can use "File Transfer" activity (you have to configure it property though) followed by an import one for instance (this could be automated by leveraging ...
jc_mc's user avatar
  • 802
1 vote
Accepted

Import Tracking Extract into DE

One way to get around this is to add multiple Primary Keys to your import data extension(s). This will allow for multiple unique values per record. For example, you could set both "SubscriberKey&...
ropedog's user avatar
  • 392
1 vote
Accepted

Data Extract Audience Studio Format

I'm not aware of a way to model your output in this fashion. Extract output formatting is pretty limited. For some reason you even need to raise a support ticket to enable UTF8 encoding. However, ...
Stephan de Paly's user avatar
1 vote
Accepted

Write to LIST from a DATA EXTENSION

There are only two ways to go about it - Using Data Extract and the Import (as you described) Writing an SSJS activity. You can read from a DE and write to a List SQL doesn't allow writing to a ...
Maneesh's user avatar
  • 2,176
1 vote

Data Extract of data extension to Enhanced FTP

In case it's useful for anyone else having this issue - to extract as a CSV, tick the 'Has Header Column' and leave others as false.
Salvara's user avatar
  • 97
1 vote

Click data view wont' save in data extension

Typically if Query Activities fail, it's one of these 4 things: Primary key violation -- your query results in duplicate rows not allowed by the primary key Inserting a null value into a non-nullable ...
Adam Spriggs's user avatar
  • 30.7k
1 vote

Zip data extract and push to an external FTP

Recently I communicated with SF Support and they say that 'Custom DE Extract With Zip2' is outdated. Instead, ask them to enable data type "Data Extension Extract with File Encoding and gzip"...
Elizaveta Trofimuk's user avatar
1 vote

Zip data extract and push to an external FTP

I discovered there is a custom extract that support can enable. It is named 'Custom DE Extract With Zip2'. The extract type will perform a data extract on a data extension and zip the file that it ...
David Devoy's user avatar
  • 2,615
1 vote

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

Be sure you have not checked the 'File is compressed' checkbox in the File Transfer Activity. It could be that the file you are opening is a .zip file.
SebOB's user avatar
  • 807

Only top scored, non community-wiki answers of a minimum length are eligible