Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [data-extract]

The tag has no usage guidance.

1
vote
1answer
50 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, ...
1
vote
1answer
40 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 "...
0
votes
1answer
29 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 ...
0
votes
1answer
77 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 ...
1
vote
1answer
135 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. ...
0
votes
1answer
491 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 ...
1
vote
1answer
155 views

Problem to Updating All Subscribers via Import Activity

I have a sync data extension and I want to update records in All Subscribers. I've completed these steps using automation: Data Extract Activity; A File Transfer Activity to put the file in FTP; An ...
2
votes
1answer
365 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 ...
1
vote
0answers
53 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 ...
1
vote
1answer
266 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 ...
1
vote
0answers
17 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 ...
5
votes
1answer
519 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 ...
0
votes
2answers
1k 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 ...
2
votes
0answers
277 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....
2
votes
1answer
1k 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 ...
1
vote
1answer
366 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 ...
1
vote
2answers
435 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 ...
0
votes
2answers
44 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 ...
0
votes
1answer
43 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 ...
0
votes
1answer
37 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 ...
1
vote
1answer
115 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 ...
1
vote
2answers
385 views

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

I want to use Salesforce DataLoader to extract and upload Documents. However, I don't understand in which format Blob Body values are stored, is it Base64 encoded? Looks like yes, but why it is not ...
0
votes
1answer
4k views

Updating All Subscribers List with query, extract and import

I have followed instructions from this link : How to Query a Data Extension and Update the Subscriber list at the Child Business Unit Level? Our current configuration allows existing users to update ...
0
votes
1answer
42 views

Extract Competitor Information from Opportunity

Salesforce Opportunities has the possibility to record competitor data for an opportunity. On an opportunity this is represented as a related list which allows you to select a competitor and then type ...
0
votes
1answer
466 views

Data Extension Extract using API

I would like to execute a Data Extension extract using API. Went through the below documentation but it asks for Start and End Date which doesn't make sense for Data Extension extract. Any suggestions?...
0
votes
1answer
544 views

How to associate campaign id with campaign name in Marketing Cloud ExactTarget

I'm pulling a data extract tracking file from ET which has a campaign id column. The values in this column are just numbers. How do I find out what campaign name associated with what campaign id?
4
votes
1answer
2k views

Help with incomplete Tracking Extract documentation

Would anyone out there be able to provide some additional documentation for these Include Options for a Data Extract of Tracking Data? I've requested an update to the one wiki page that has most of ...