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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

SF Process Builder Retiring RE MCC; what is the impact to activities in the SFMC (i.e., active journeys, automations, synchronized data extensions)?

Do any activities need to be stopped and restarted or will the MCC automate these processes? Are there any delays to be expected?
Lauren's user avatar
  • 11
0 votes
1 answer
34 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
1 answer
36 views

How to Contact delete (All contacts) in Child BU

Is there a way to do contact delete in Child BU? (All contacts) I want to delete the Contact in bulk. All marketing activities (Journey, e-mail sending, etc.) take place in Child BU. I would like to ...
Seungil Shin's user avatar
0 votes
0 answers
17 views

BounceCategoryID from Bounce Dataview field doesn't return the right value to Boolean field

I have problems during SQL that it doesn't retrieve the right value to Boolean field. Now I extract Bounce DataView and if BounceCategoryID(number type) is 1002,1003 then retrieve 'true' to Spam field(...
Nicole Jung's user avatar
1 vote
2 answers
53 views

Transfer XML API response as file to FTP with SSJS

Context: I am looking to implement a daily automated import of a product catalog. I can only access the catalog via an API endpoint that cannot be filtered/paginated and gives ±100K rows of XML as ...
Arthur Noort's user avatar
-2 votes
0 answers
24 views

I tried to send email to contacts without adding duplicate reocords to all subscribers using api

The request is we have one triggered send DE.we use api to triggered emails. One subscriber has 2 different email address but only one one time his contact should be added to the all subscribers. I ...
SFMC Developer's user avatar
-1 votes
1 answer
29 views

want to access variable from one activity to another in automation in Marketing Cloud

I want to check whether, can we access the variable which defines at script activity across other steps within the same automation in marketing cloud.
Sanket Autade's user avatar
0 votes
1 answer
42 views

Marketing Cloud | Automation Studio | Output SSJS WSProxy to Landing Page or other viewable place

I was trying to follow along with the write up here: https://ampscript.xyz/how-tos/how-to-retrieve-all-shared-data-extensions-using-ssjs/ In doing so, I know the script works, but I notice the write ...
Fernando Garcia's user avatar
0 votes
0 answers
34 views

Retrieve Activities that aren't being used in any Automations in Marketing Cloud

I'm cleaning unused Automations and Activities from a Marketing Cloud Account and I'm trying to find a way to retrieve the Activities that aren't being used in any Automation using SSJS. I have ...
pmleal07's user avatar
0 votes
1 answer
70 views

Query for Subscribers Click Counts and SendLog

I'm in the process of building a query that will give me a count of all links a subscriber has clicked on from recent sends. I have a query written out using the salesforce documentation, and I have ...
A S's user avatar
  • 1
0 votes
0 answers
51 views

Combining SFMC Job, Send and Click Tracking Extracts to create Impression Tracking by Job Report

I am trying to create a custom report in SQL to mimic following 'Impression Tracking by Job Report' in SFMC for all Jobs but currently testing with just one job ID to narrow down my testing by I am ...
Pardeep Singh's user avatar
-1 votes
0 answers
62 views

How to trigger transactional sms dynamically from api

I have 5 sms templates and need to create single definition key. Is it possible to create one definition key for multiple sms content dynamically to trigger it from api. I tried creating definition ...
SFMC Developer's user avatar
0 votes
0 answers
46 views

How to rename a file on the SFMC FTP?

I am looking for a way to rename a file on the SFMC FTP using an automation. I have tried using the substitution strings %%FILENAME_FROM_TRIGGER_BASE%% and %%BASEFILENAME_FROM_TRIGGER%% with the "...
AdamG's user avatar
  • 11
-1 votes
0 answers
38 views

How to fetch email address, encrypted email address in interaction studio

I created site map for a website. But user details like user name, email address, encrypted email address are not captured in interaction studio. Is site mapping alone enough to capture these data
SFMC Developer's user avatar
-1 votes
1 answer
40 views

Automation data into data extention

I found a script for retrieving automation data on https://www.ssjsdocs.xyz/automation-studio/automations/retrieve/all.html. I still learning SSJS and can't figure out how to store this kind of ...
Martijn e's user avatar
  • 143
0 votes
1 answer
60 views

SSJS code to add existing query activity to an existing automation fails

I am trying to add an existing Query Activity to an existing Automation using a SSJS script. This is my code. I have referred the doc <script runat="server"> Platform.Load("...
New Developer's user avatar
0 votes
1 answer
61 views

Journey Builder - Automation Schedule and Entry Criteria

I have a very simple journey setup to send an initial welcome email. I am using a multi-step journey in order to utilize the no re-entry criteria, so that new subscribers will not requalify for the ...
Tazzy1234's user avatar
0 votes
1 answer
39 views

Using Einstein STO outside of Journey Builder

I know Einstein STO is designed to use within Journey Builder, but I also know I can use it to send ad hoc emails via an Automation Studio Send Email event. My question is, once I create that event, ...
PForsyth's user avatar
0 votes
1 answer
65 views

SSJS - Delete Row in DE based on another DE with flag

New to SSJS but based on what I've read, it looks like this could be possible. I am trying to write a script that will delete a row in a 'Secondary_DE' based on a defined 'Deleted' flag in a '...
BeezB2020's user avatar
0 votes
1 answer
63 views

How is the link generated for automation

Hello I have created list of automations on cloud page and want to generate link to each automation Is there a way how to generate the link? https://mc.sx.marketingcloudapps.com/AutomationStudioFuel3/#...
martechnotes.com's user avatar
0 votes
0 answers
86 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
62 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 ...
Tazzy1234's user avatar
0 votes
1 answer
76 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 '...
Tazzy1234's user avatar
0 votes
1 answer
120 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 ...
Abeed Ahmed's user avatar
0 votes
1 answer
86 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 ...
Greg Whitaker's user avatar
0 votes
1 answer
67 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 ...
parleggirl's user avatar
0 votes
0 answers
77 views

Marketing Cloud File Drop Automation not triggering

I am fairly new to marketing cloud and attempting to start an automation via a file drop to our SFTP folder. I have double checked this several times and it is not triggering the automation to begin. ...
SFMarketingGirl's user avatar
1 vote
1 answer
72 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" ...
Anay Shrikar's user avatar
3 votes
2 answers
165 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 ...
Maciej Barnaś's user avatar
1 vote
1 answer
102 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 ...
aryashah2k's user avatar
1 vote
1 answer
120 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....
aryashah2k's user avatar
0 votes
2 answers
144 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 ...
Nikolay Nikolov's user avatar
-1 votes
2 answers
177 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 ...
JonasJLC's user avatar
0 votes
1 answer
143 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 ...
Leon's user avatar
  • 3
0 votes
0 answers
89 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
51 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: ...
SFMC Developer's user avatar
1 vote
3 answers
275 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 ...
Chris Hughes's user avatar
0 votes
1 answer
68 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 ...
TCassa's user avatar
  • 866
0 votes
1 answer
80 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 ...
TCassa's user avatar
  • 866
0 votes
0 answers
106 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
  • 23
-1 votes
1 answer
156 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 ...
Minkyeong Kwon's user avatar
0 votes
1 answer
111 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 ...
JNC's user avatar
  • 39
0 votes
1 answer
37 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 ...
Pruteik's user avatar
0 votes
0 answers
50 views

Automation Studio next run set less hour than starting time

I scehduled Automation that activte today 3pm And when I complete this set and check it, in automation, the next run is today 2pm. Is it right? I want to fix it.
Nicole Jung's user avatar
-2 votes
1 answer
179 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 ...
Frederik's user avatar
-2 votes
1 answer
104 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.
Sanket Patel's user avatar
-1 votes
1 answer
56 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.
SFMC Developer's user avatar
0 votes
1 answer
83 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 ...
Hannah Kim's user avatar
0 votes
1 answer
47 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 ...
Dhwani Shah's user avatar
0 votes
1 answer
103 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 ...
Prasad Ruwanpathirana's user avatar

1
2 3 4 5
18