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 ...
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'...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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'
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.
...
2
votes
Accepted
Salesforce MC - How to data extract in UTF8 to FTP
Here are some screenshots of an UTF8 DataExtract Activity:
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 ...
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 ...
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 ...
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 ...
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, ...
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.
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 ...
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.
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 ...
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"...
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 ...
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.
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
...
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 ...
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, ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
data-extract × 54marketing-cloud × 47
automationstudio × 23
dataextensions × 8
tracking-extract × 7
ftp × 5
automation × 4
data-export × 4
sftp × 4
sql × 3
journeybuilder × 2
soap-api × 2
data-loader × 2
data × 2
import × 2
data-views × 2
unsubscribe × 2
encoding × 2
community × 1
rest-api × 1
api × 1
query × 1
formula-field × 1
opportunity × 1
rest × 1