Questions tagged [data-extract]

The tag has no usage guidance.

20 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
432 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
2k 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
0answers
54 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 ...
1
vote
0answers
341 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 ...
1
vote
2answers
802 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. ...
1
vote
1answer
462 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 ...
1
vote
0answers
78 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
0answers
19 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 ...
0
votes
0answers
30 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 ...
0
votes
0answers
70 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. ...
0
votes
1answer
33 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 ...
0
votes
0answers
16 views

Can Marketing Cloud transfer a file to a OneDrive account?

When I pass files to vendors, normally I drop then to a SFTP. The request I have now is can I drop a file to a OneDrive Account. Can a OneDrive Account be set up as a File Location for Marketing ...
0
votes
1answer
11 views

Exporting Pardot Campaigns

I need to extract the whole information included in Pardot Campaigns and elements inside them like prospects actions and any other activity results. The user is synced to Salesforce, so it seems that ...
0
votes
0answers
36 views

SFMC API add Script Activity and Data Extract Activity to Automation

I am creating an automation via API and understand you cannot create Script activities or Data Extract activities. I have created the script and data extract separately using the API and have the ...
0
votes
0answers
19 views

SDK - Soap Client Request Extract

I am using the SDK within a C# application and I am attempting to request a data extract using the soap client within the SDK. The SDK provides the following method sdkClient.SoapClient.Extract ...
0
votes
0answers
31 views

If a data extract is perfomed via api will it be displayed in automation studio?

I want to trigger a data extract activity in marketing cloud using SOAP api but i don't want that activity to be visible under automation studio activities(suppose i'm an ISV, I dont want my client to ...
0
votes
1answer
51 views

Extract Record data from the record Id

All, Quick question! A custom Order object and Order lines are generated via a trigger from the Opportunity and Opportunity Products. Opportunity and Order have lookup relations between each ...
0
votes
2answers
48 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

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 ...
0
votes
1answer
864 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?