Skip to main content

Questions tagged [data-extract]

The tag has no usage guidance.

28 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
0 answers
157 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 ...
user127987's user avatar
2 votes
0 answers
706 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 ...
Arthur Noort's user avatar
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....
Disasterkid's user avatar
1 vote
1 answer
370 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 ...
Alexandru Ciobanu's user avatar
1 vote
2 answers
668 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 ...
Ilyass Ait Moussa's user avatar
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. ...
user6079228's user avatar
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 ...
Jennifer Luby's user avatar
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 ...
K K's user avatar
  • 307
1 vote
0 answers
815 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 ...
Ricardo Silva's user avatar
1 vote
0 answers
51 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 ...
Mike's user avatar
  • 83
0 votes
0 answers
26 views

Data Extract to Add All Unsubscribed Contact to Auto-Suppression List Failing

We've changed our source data for MC which has updated everyone's Subscriber Key. In order to honour unsubscribes, we want to move all our old unsubscribed subscribers to an auto-suppression list. I'...
Gigi's user avatar
  • 3
0 votes
1 answer
104 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 ...
Krati Garg's user avatar
0 votes
0 answers
114 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 ...
PForsyth's user avatar
0 votes
0 answers
137 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 ...
JNC's user avatar
  • 39
0 votes
0 answers
195 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","...
Sam's user avatar
  • 33
0 votes
1 answer
347 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 ...
chorlesbarkley7's user avatar
0 votes
0 answers
268 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 ...
SFMCuser's user avatar
0 votes
1 answer
881 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%% %%...
Felix Song's user avatar
0 votes
1 answer
921 views

Minutes and seconds wildcard specifiers preventing file selection from Safehouse in automation Studio activity

Within Automation Studio we have a Data Extract activity that results in a csv file in safehouse. The issue we are experiencing is that the file naming pattern requires minutes and seconds eg ...
mozzy69's user avatar
  • 38
0 votes
1 answer
159 views

Data Extract not pulling unsubscribe record

I used a logunsubevent request to unsubscribe a subscriber and after that, I looked for this subscriberkey in the _unsubscribe data view. It shows up fine. I am running data extract with below steps ...
Alekhya's user avatar
  • 11
0 votes
1 answer
89 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 ...
KBrown-Blend360's user avatar
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), ...
Ilyass Ait Moussa's user avatar
0 votes
1 answer
526 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 ...
Luke Krausmann's user avatar
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 ...
rohitchavan's user avatar
0 votes
1 answer
333 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 ...
Francisco Lachavanne's user avatar
0 votes
0 answers
55 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 ...
Adam's user avatar
  • 3
0 votes
1 answer
269 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 ...
Steve's user avatar
  • 25
0 votes
2 answers
71 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 ...
Sarah's user avatar
  • 1