Questions tagged [data-extract]
The data-extract tag has no usage guidance.
65
questions
8
votes
1
answer
4k
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 ...
- 30.2k
7
votes
2
answers
3k
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 ...
- 2,605
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,888
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 ...
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 ...
2
votes
5
answers
4k
views
Extract unsubscribes
I need to export all our unsubscribes in Marketing Cloud and I'm having trouble doing this.
I have tried exporting All Subscribers, but due to the volume of records ~15M Marketing Cloud takes almost ...
- 125
2
votes
2
answers
790
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
2
votes
1
answer
7k
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
2k
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
2
votes
2
answers
1k
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 ...
- 16k
2
votes
0
answers
596
views
SFMC XML data extract - input file name wildcards
We are using an automation that is triggered by a file drop on the FTP. In this automation there is a Convert XML Data Extract Activity to convert the dropped XML file to a CSV file which can be ...
- 148
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
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....
- 630
1
vote
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, ...
- 13
1
vote
1
answer
732
views
Does anybody know how to update Data Extract Activity via SOAP API?
I have a question on how to update Data Extract Activity using SOAP API.
I found a document about the Supported Methods of SOAP API in Marketing Cloud:
https://developer.salesforce.com/docs/atlas.en-...
- 35
1
vote
1
answer
1k
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
1
vote
1
answer
1k
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?...
- 2,164
1
vote
1
answer
76
views
The name of the file resulted from a Mobile Push Data Extract to use in SQL for file transfer
I need some help with understanding how to build an SQL from Mobile Push Extract that needs some transformation to the data like time zone, before being transferred to a AWS bucket.
I have an ...
- 9
1
vote
1
answer
1k
views
Transferring data from Salesforce MC to GCS
My company asked me to find a way to transfer a data extract from Salesforce Marketing Cloud in a Google Cloud Storage bucket, so that they can bring it into Data Studio or Analytics.
I've done some ...
- 11
1
vote
1
answer
391
views
Import Tracking Extract into DE
I'm attempting to create my own DE's of the tracking exports so that I have a consolidated view of tracking data since I can only pull 30 days at a time using the Tracking Extract (Data Extract ...
1
vote
1
answer
810
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 ...
- 563
1
vote
1
answer
209
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 ...
- 181
1
vote
0
answers
95
views
Translation of formula field code into SQL
I am building a DWH and am currently working on our Salesforce data extractions. In order to improve data quality I would like to extract the formulas from custom fields and translate them into SQL ...
- 11
1
vote
1
answer
228
views
Data Extract activity is changing the physical order of records
I have the next issue when exporting a CSV file to a SFTP location:
It's about a daily automation, the process consists in three steps, one for data extract, a second one to convert the file to UTF8 ...
1
vote
2
answers
435
views
Include The journey name in Data extract file
I'm working on a data extraction. I implemented it with a file transfer to my FTP, it's for "Sent" journey feedbacks. My customer would like to have the "journey name" in the ...
1
vote
1
answer
327
views
Data Extension or Data Export log
I would like to see who has been exporting data from our data extensions in the past year but I am not sure if this functionality is available in Marketing Cloud.
I have tried with Audit Trail (I have ...
1
vote
0
answers
1k
views
Extracting and exporting (file transfer) SQL query from automation/data extension in Marketing Cloud
There is a database extension in salesforce marketing cloud that I need to export from the automation. I didn't create the DE and am unsure how to export it for use outside of salesforce marketing ...
1
vote
0
answers
1k
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 ...
- 185
1
vote
0
answers
708
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
0
answers
42
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
1
vote
1
answer
468
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 ...
- 807
0
votes
1
answer
159
views
Is there any way to extract email list data along with the rendered subject line where dynamic subject line is used
In all the email, subject line is never hardcoded and dynamic (not individual for each subscriber) but usually our audience list consist of:
Customer Type 1 - subjectline 1
Customer Type 2 - ...
- 317
0
votes
1
answer
7k
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 ...
- 6,553
0
votes
1
answer
735
views
Rest API to create/update data extract activity is not working
Could someone please point out the mistake in the below script?
var restapi_url = "https://XXXXX.rest.marketingcloudapis.com/automation/v1/dataextracts";
var restapi_payload = '{"name&...
- 1
0
votes
1
answer
1k
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 ...
- 3
0
votes
1
answer
587
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 ...
- 630
0
votes
1
answer
1k
views
salesforce Dataloader : field 'Description' can not be filtered in a query call
I am using dataloader to look for and extract certain emails(tasks) that must have the word "igloo" in them, I tried to do 'description' contains "igloo" and got an error saying ...
- 11
0
votes
1
answer
1k
views
Export a data extention to FTP using automation?
I searched around for this and found a thread Using Automation Studio to Export a Data Extension
But it did not really answer my question. I have a data extension that is created and an automation ...
- 127
0
votes
1
answer
163
views
Is Data Extract necessary if there is already a File Transfer? [closed]
Because FileTransfer already is able to do encryption/decryption, I wonder if it is necessary Data Extract in combination with it, in such 2 use case scenarios:
posting encrypted list to MC
file is ...
- 305
0
votes
1
answer
69
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
0
votes
1
answer
424
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 ...
- 125
0
votes
1
answer
134
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 ...
- 1,345
0
votes
0
answers
34
views
Data Extract and Fie Transfer Activity failing sometimes in Automation Studio due to an hour change
We are running two automations each automation is with 2 Data Extract activities followed by a File Transfer activity in Marketing Cloud Automation Studio.
These two automations are running ...
- 39
0
votes
0
answers
67
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","...
- 21
0
votes
2
answers
226
views
Not sent (data extract) vs bounce data view
For a specific email name, a subkey did not receive the email. I started to investigate and i saw that the subkey was in the not sent table (data extract) => field Reason equals to "Held"....
0
votes
1
answer
78
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
0
answers
38
views
Marketing Cloud Email Studio Total Email Sent is Less Than Data Extension Created [duplicate]
We created a Salesforce Data Extension that contained 12,855 unique email addresses and SF ID's. Once the email was deployed through Email Studio, the total sent was only to 12,023..6.5% of my list ...
- 1
0
votes
0
answers
209
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
0
answers
200
views
Is there any other way to store SFMC historical tracking data'(sends, open, clicks) other than using data view & tracking data extract
I want to store historical SFMC tracking data beyond 6 months. We can opt for data view export or tracking data extract to accomplish this. Do we have any other way in marketing cloud to store/fetch ...
- 3
0
votes
1
answer
571
views
File Name Pattern in Data Extract Activity
In the Data Extract activity, we can use the File Name Pattern to define the exported file name, but we can only use the following personalization strings in the filename: %%Year%% %%Month%% %%Day%% %%...
