Questions tagged [automationstudio]
Automation Studio is a Marketing Cloud application used to execute multi-step marketing and data management activities on an immediate, triggered, or scheduled basis. Use Automation Studio's workflow canvas to build simple or multi-step automations.
884 questions
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
118
views
Journey Builder vs. Normal Send - Synchronized DE
I just setup Marketing Cloud Connect and am querying data from a parent account to a child BU using shared data extensions/query activities. In this instance, I am also pulling in newsletter ...
- 17
0
votes
1
answer
232
views
Import File Activity Automation - Change field data type to match Data Extension
I am setting up a File Import automation to ingest a file from the Marketing Cloud FTP to a Data Extension. I am running into an issue where the csv has a field for a newsletter preference say '...
- 17
0
votes
1
answer
764
views
How to use DE suppression list in the journey builder?
I created a journey in Journey Builder, and I have a suppression list in my data extension. However, when attempting to utilize the suppression list from the data extension, I encountered an issue as ...
- 11
0
votes
1
answer
202
views
Is there a way to process SQL queries in Salesforce Marketing Cloud based on criteria in another unrelated table?
I have a set of steps that I want to process in Salesforce Marketing Cloud, but I'd like to make it easier for my users. I have a set of steps I want to run if a column is "True" and a ...
0
votes
1
answer
108
views
File drop is being picked by the wrong automation due to similar names
We have an Import Customer automation which runs every hour via SFTP file drop - FileName Pattern SFMC_CUSTOMERS_10312023040011.csv and populates our customer DE.
We have another file drop automation ...
- 47
1
vote
1
answer
131
views
I want to create a Frequency Capping process on Number of Emails/ SMS/ Push messages sent to a customer in the last 1 or last 7 days
The basic process we are planning to use for achieveing this is:
Create a DE that has SubscriberKey and 6 columns "EmailsCount_7days" "EmailsCount_1day" "SMSCount_7days" ...
- 119
3
votes
2
answers
417
views
How to delete emojis using SQL in Marketing Cloud
I have a Data Extension named "Jobs", where I keep records from dataview Job. My team started to use emojis in subject lines of the e-mails, so also in my table "Jobs", I have ...
- 193
1
vote
1
answer
287
views
Sending Push Notifications Within Journeys Triggered By An API Event Without DeviceID
I have the following Use Case:
Journey is triggered from an API Event, It has PUSH Notification messages present.
This Event does not have the Device ID which is used to send Push Notification to the ...
- 257
1
vote
1
answer
189
views
How Do I Break Down a JSON Array Format CSV Column Into Individual Columns Within SFMC Data Extensions?
I have an interesting use-case where I am getting a Data Extension from CDP where one of the columns is in JSON Format.
Now I want to break down the last column of this DE into its individual columns....
- 257
0
votes
2
answers
380
views
Unable to decrypt a file securely from external file location and move it to a Safehouse in Marketing Cloud
I need some help with SFTP set up that I'm working on in Automation Studio. The issue I have an I'm trying to resolve is how to avoid exposing decrypted CSV file on the FTP Import folder and instead ...
-1
votes
2
answers
386
views
Creating a "File Transfer"-activity - Keeps loading?
I am trying to create an automation in SFMC and am currently stuck trying to make a new "File Transfer"-activity. All other activities are working fine.
I have tried using different ...
- 1
0
votes
1
answer
387
views
Performing File Transfer Activities using ssjs
i am currently trying to create and and start Activites in Automation Studio and i am stuck at performing File Transfer activities. i made sure to preform a series of Data Extracts so that the files ...
- 3
0
votes
0
answers
54
views
After inserting record's into SFMC Data extension, I see some unwanted texts are inserted along with normal text
I have inserted record's into DE. But after insertion, I can see some unwanted texts are also insered into the fields.
Expected:
question (field)
How are you I&I ? (Records)
uploaded records:
...
1
vote
3
answers
561
views
Dynamic SQL Top() clause in SFMC
I am looking to automate an IP Warm Up process. We have our plan that defines the number of contacts that should be sent to on each day across each domain group.
I would like to automate this, so am ...
- 33
0
votes
1
answer
147
views
SSJS to update query definition - stringify individual column names with loop
We have a script activity in automation studio to update the text of a query definition and target a new data extension. It currently selects all fields using the standard SELECT *, but we need to now ...
- 898
0
votes
1
answer
217
views
Updating an Email Send Definition with SSJS to update data extension AND publication list
As part of an automated email we have, I made an SSJS script block to update an Email Send Definition (User-Initiated) to target a new data extension. However when we do this, it resets the ...
- 898
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
-1
votes
1
answer
420
views
Can I convert string to datetime in Marketing cloud's SQL?
I have string data like '20230823143306'.
Is there any way to convert it to a datetime format, like '08/23/2023 02:33:06 PM', using SQL?
I've heard that it might be possible to perform this conversion ...
0
votes
1
answer
169
views
Can we Run An Automation for 24 Hours by adding repetitive activities to ensure we are processing data we captured in Data Extension
We need to continuously process data(need to make an API call using SSJS script activity to external system which is time sensitive) which we are capturing in Marketing Cloud Data Extension via SFMC ...
- 39
0
votes
1
answer
41
views
Same selection query is giving different results in terms of selected records
I have a 3 step automation:
Step 1 selects the audience for the journey entry data extension (this overwrites the DE Offer_Extension_Warmup_Journey_Entry)
Step runs the exact same query but logs the ...
- 3
-2
votes
1
answer
388
views
Javascript issue "Object reference not set to an instance of an object."
I have a JSON file from which I need to extract some information about ordered items. i believe my JSON is configured properly with an array called 'items'.
Whenever I try to run my code, it gives me ...
- 3
-2
votes
1
answer
231
views
Delete the FTP file after used in file import
How to add a step in Marketing cloud automation workflow to delete the FTP file automatically after using for import to data extension when expecting a new file drop everyday.
-1
votes
1
answer
100
views
Setting multiple First name in SFMC mobile connect
I tried to create multiple from name in mobile connect for a single Business Unit. But I can create only one in a bu. Do we have any other options to create multiple from name in a bu.
0
votes
1
answer
160
views
Marketing Cloud SQL String Formatting to Retrieve Only Part of Data
I am importing a file data which cannot be edited from the source. I am trying to modify and extract the only needed information via Marketing Cloud SQL.
Below is the original file field data and the ...
0
votes
1
answer
76
views
Can I add a wait step after journey and then add a query?
I have a question - I run an automation with 3 queries and a journey. The 3rd query is suppose to run after the journey, as this is the reporting query that logs users who entered the journey. Is it a ...
0
votes
1
answer
195
views
How to execute journey exists in child BU from parent automation?
I need to execute a journey which is created in child BU from parent automation. The automation option is disabled in Schedule Type in the child journey even the data extension is used in the parent ...
- 1,073
-1
votes
1
answer
55
views
How many Automation will Create & Run In marketing cloud For standard success plan? [closed]
How many automation run & create in a month?
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
65
views
SQL Automation Qry error [closed]
I'm following this example here (Query to Combine Data from 3 different Data View Tables) and when I try to run the ClickDataView SQL to a data extension I get and err. My DE (ClickDataView) has a ...
-1
votes
1
answer
239
views
SQL filter on Date doesn't work
In my Data Extension I have a column named 'CreatedDate'. This is formatted like this: Wednesday, May 03, 2023 9:20 AM
In my automation I want to select only records since 01/01/2023. Time parameter ...
- 3
0
votes
0
answers
1k
views
How to insert a row in a Data Extension using SSJS?
I'm trying to add a row in a Data Extension using the following code:
<script runat="server">
Platform.Load("Core","1");
try {
var deRows = {offer_id:&...
- 3
0
votes
1
answer
258
views
Extending my use of SQL and UNION to add information about source
I'm doing segments based on SQL and UNIONs, so ie.
first I determine everyone having interest in product group X based on 'website interaction'
next I determine everyone having interest in product ...
- 551
0
votes
1
answer
152
views
SFMC import failure
I have a file drop import automation that has recently started throwing a "Data Extension not found" error, but the import worked fine before and since. The automation has run successfully ...
- 59
0
votes
1
answer
175
views
How SSJS Script Can Be Execute Multiple times
I have a use case where I need to make a REST API call to the third-party application to get coupons. I was able to make API call and capture coupons into DE, but due to API limitations, I'm only able ...
- 111
0
votes
1
answer
77
views
Marketing Cloud SQL - Can we do maths using field values
I have a scenario which I want to understand if it's possible
I need to pull all contacts which are in a 'waitlist' where a matched property has a status of Available (all good so far)
Where it gets ...
-2
votes
1
answer
102
views
How to add categories based on two different variables in SQL Query in SFMC
I'm trying to create a data extension that extracts subscriber key and clicks based on specific criteria. Below is the script:
select c.[JobID]
, c.[SubscriberKey]
, c.[URL]
, j.[...
0
votes
1
answer
267
views
Can I still send back the tracking data of IER to Salesforce even after doing a send?
We have a Salesforce CRM and IER is enabled. I sent out an email using guided-send/user-initiated and the DE coming from the Data Extension folder only, is there a way to send the IER tracking data ...
0
votes
1
answer
336
views
I want to search the list of SQL Query Activities which uses my target data extension in Select statements without explicitly storing them in DEs
I'm trying to display the results in the form instead of storing the details in data extension which makes it accessible for everyone with the cloudpage URL.
Here the search is not happening as ...
- 3
0
votes
1
answer
105
views
SQL Query Not Working
I'm trying to have this query pull all subscribers into a data extension who are not within another data extension. I'm not sure why it's not working.
Select Status, Name, FirstName, LastName, ...
- 3
0
votes
0
answers
62
views
Writing 100k deletes SSJS in DE and applied filter to column SCD_FLG and value D. Below code got failed in automation. Any leads will be appreciated
<script runat="server">
Platform.Load("core", "1.1.1");
var config = {
name: "91D16891-FEEC-4C5C-A6E9-729D7E612B5A",
cols: ["OFFER_DK"]...
0
votes
1
answer
165
views
Error trying to retrieve Automations and inserting them into a Data Extension using SSJS
I am trying retrieve all Automations from a Business Unit and insert them in a Data Extension ussing SSJS. It works fine when I retrieve them in a Cloud Page but when I try to insert them into a Data ...
- 25
0
votes
1
answer
53
views
Get only the Clicks that has not been retrieved into the data extension
I have some emails that has been sent to the end customers and I want to track their interactions with the email which I have to send it back to the Sales cloud (CRM).
Following are the steps:
Step 1) ...
- 507
-2
votes
1
answer
152
views
My automation is successful even if there is no file placed in FTP
How can my automation be successful even when there is no file placed in SFTP? I have created a support ticket to confirm if there is blank file processing feature enabled, Support replied that this ...
0
votes
1
answer
290
views
Contacts are not being pushed to email activity after the wait activity, what can be possible issue. I can still see contacts in wait activity?
I have created a Journey, with decision split deciding If the contacts already registered should move to exit, If they are new then They will wait for a min after the automation triggering contacts to ...
0
votes
1
answer
206
views
Script to create a DE in MC automation studio enterprise edition
I am using this script to create a Data Extension in automation studio.
I checked my code on a landing page and the statuscode is 200. Whene running it on automation studio as a script it returns an ...
0
votes
1
answer
83
views
Clone data from one field to another in a data extension in marketing cloud
I have a Data Extension in Marketing Cloud and I am using Automation Studio to create a querie that copy the data from one field to another.
I want to pass all the event_id data to the new field ...
- 1
0
votes
0
answers
186
views
Problem with automation and Sql Query
I have a problem with an automation:
the query inside has no error and runs correctly, but no record is extracted. If I try to run it externally (via run once and query studio) the records are ...
0
votes
2
answers
2k
views
Automation Studio Activity (Journey Entry) not appearing. (Permissions?)
I am reviewing some activities in our SFMC instance that some previous coworkers built. In one automation activity, I am seeing an activity I can't find. I can't find the "Journey Entry" ...
- 1
1
vote
1
answer
122
views
Is it possible to replace a Data Extract file in an exported ZIP?
Creating a Tracking extract, but there are errors in the NOT SENT file. We have created a process to remove the bad data and create a new "NOTSENT.CSV" file, but is it possible to put this ...
- 1,040