All Questions
Tagged with automationstudio data-extract
27 questions
0
votes
1
answer
170
views
Data Extract Activity could not start issue
I migrated automations from one Business Unit to another (newly created) using Package Manager. Some of these automations have Data Extract activity. The Extract type is 'Data Extension Extract'. All ...
- 957
0
votes
0
answers
160
views
Data Conversion & date/time wildcards
I have a data conversion step in an automation that follows this file naming convention:
MemberCommunication_%%Year%%%%Month%%%%Day%%%%Hour%%0000.csv
I needed the timestamp to facilitate the ETL ...
- 59
0
votes
0
answers
303
views
SFMC Automation File transfer splits a single row into multiple lines due to line feed char
I have an issue with a DE data extract followed by a Transfer file activity that splits a single row into multiple lines on the file transfer.
Expecting 1 row as below":
"1","...
- 45
0
votes
1
answer
268
views
Extracting data for _sent Data View via FTP
I have multiple journey builder emails using transactional API and I want to extract daily data for sends and clicks. Using sends as an example, I have created an Automation with these steps:
...
- 9
0
votes
1
answer
463
views
Email Send Definition Key - Data Extract - Automation Studio
I want to perform a data extract activity so that I can pull subscriber-level data regarding a particular send that occurred more than 6 months ago (no data views).
The send in question occurred in ...
- 134
0
votes
1
answer
97
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 ...
0
votes
1
answer
1k
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), ...
0
votes
1
answer
452
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 ...
user80446
0
votes
1
answer
584
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 ...
0
votes
0
answers
2k
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 ...
1
vote
0
answers
1k
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.
...
- 87
0
votes
1
answer
70
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 ...
- 491
1
vote
0
answers
2k
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 ...
- 309
0
votes
1
answer
671
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 ...
- 664
2
votes
1
answer
9k
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 ...
- 23
2
votes
1
answer
1k
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, ...
- 23
2
votes
1
answer
3k
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 "...
- 21
4
votes
1
answer
7k
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 ...
- 4,906
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 ...
- 121
1
vote
0
answers
55
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 ...
- 83
3
votes
1
answer
4k
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
0
answers
1k
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....
- 664
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 ...
1
vote
1
answer
2k
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 ...
- 266
2
votes
2
answers
827
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 ...
- 266
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 ...
- 6,613
1
vote
1
answer
262
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 ...
- 191