6 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 ...
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'...
user avatar
  • 27.7k
5 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 ...
user avatar
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 ...
user avatar
  • 2,585
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 ...
user avatar
  • 27.8k
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. ...
user avatar
  • 27.8k
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 ...
user avatar
  • 27.8k
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 ...
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 ...
user avatar
  • 7,706
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 ...
user avatar
  • 27.8k
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 ...
user avatar
  • 4,323
2 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 ...
user avatar
  • 2,085
2 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'
user avatar
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. ...
user avatar
  • 5,267
2 votes
Accepted

Salesforce MC - How to data extract in UTF8 to FTP

Here are some screenshots of an UTF8 DataExtract Activity:
user avatar
2 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 ...
user avatar
  • 7,706
1 vote

Transferring data from Salesforce MC to GCS

It is not possible to connect a Google Cloud Storage bucket to MC, as the only methods available for GCS are (as per documentation): Write and read files from Cloud Storage buckets by using the ...
user avatar
  • 16.9k
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 ...
user avatar
  • 1,019
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 ...
user avatar
  • 770
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, ...
user avatar
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.
user avatar
  • 115
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 ...
user avatar
  • 2,104
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.
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 ...
user avatar
  • 27.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"...
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 ...
user avatar
  • 2,585
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.
user avatar
  • 831
1 vote
Accepted

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

Found the answer after I posted, thought others may want to know. I created a query that looked at the _ListSubscribers data view. Example below: Select [EmailAddress] FROM _ListSubscribers WHERE ...
user avatar
  • 171
1 vote

Is Document Body Blob field value encoded in Base64 when extracted by Dataloader? Can this encoding be used for insert or update?

You can export files in base-64 format, but you can only import files using files, as documented in Uploading Attachments. Basically, the Body needs to be specified as a file path. The three required ...
user avatar
  • 429k
1 vote

Is Document Body Blob field value encoded in Base64 when extracted by Dataloader? Can this encoding be used for insert or update?

No, I can't use Base64 to insert Documents. Received Exceeded Max Field size Also there is mention in the documentation that VersionData for ContentVersion is automatically converted into Base64, ...
user avatar
  • 13.2k

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