Skip to main content

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
6 views

Trigger automation when row added to Data Extension (without external API)

I want to trigger an automation when a new row is added to a Data Extension. I can trigger it via the API, but building this trigger inside the Marketing Cloud would be much better because otherwise, ...
Disasterkid's user avatar
0 votes
1 answer
29 views

Marketing Cloud - SQL Query to Return all Subscribers Who've been sent an email

I want to find out how many of my subscribers (who've been sent an email) have opened an email within the last 5 years. I want to include subscribers who've been sent an email and haven't opened an ...
Jeremy Thabes's user avatar
0 votes
0 answers
32 views

How to make Verification activity not skipping queued automation in Automation studio File drop

I have a file drop automation in marketing cloud with a verification activity in the middle. 3 files will be dropped in the sftp folder location which will trigger and queue 3 instances of this ...
Khoa Nguyen's user avatar
-1 votes
0 answers
36 views

Formula field not showing up in Data Extension

I'm creating a Data extension in Marketing Cloud, that data extension is created using Automation by running SQL query. But it's not considering formula field for data extension fields. Below is my ...
salesforce Developer's user avatar
-1 votes
1 answer
33 views

marekting cloud - can we automate to send all subscriber data to my subcriber list in marketing cloud in order to automation subs-unsub..helpplssss

I have a scenarion where I am not using connector first of all and I am sending my salescloud data account/contact to marekting cloud data extension through rest api. Now the tricky part is we have 2 ...
arjunsoni's user avatar
0 votes
0 answers
44 views

file drop sftp automation

I am using Cyberduck to access FTP. Is there any possibility of detecting file drops when downloading files in FTP? I have had an event where automation is triggered even though there is no evidence ...
youkey's user avatar
  • 19
0 votes
1 answer
34 views

Query with Union of two Synchronized Data Extensions

I have a query using a Union to combine two Queries. In the Query editor I run into no errors but when I click finish, I get the error Cannot find table 0. So syntax errors show up so I am lost. Here ...
A S's user avatar
  • 5
0 votes
2 answers
47 views

Simple Queries - Sent

I'm new to writing queries but I thought this SENT query would be simple. I'm just trying to get All sends for the last 30 days. But when I run the query, nothing populates in the DE and nothing ...
userjlq's user avatar
0 votes
1 answer
47 views

DataExtension.Init not working

I have tried to use DataExtension.Init() several times with no avail. I can see the Data extension in both parent and child business Unit (it lives in the shared data extension folder). I've also ...
A S's user avatar
  • 5
0 votes
1 answer
46 views

Send email only if attachment exists in import SFTP Marketing Cloud

I have an incoming zip file containing multiple csv files. I extract and run an automation activity on a specific file name pattern, this is the master data file containing which file goes as an ...
IHaveAQuestion's user avatar
0 votes
1 answer
56 views

Tracking extract - attributes file

can someone help with including attributes in the tracking extract output? My goal is to include in the tracking extract an internal list id that corresponds with a subscribers' event. That list id is ...
PForsyth's user avatar
0 votes
1 answer
55 views

How to check for activated automation

Is there a way to check for activated automation? I want to extract it to DE: Automation Name Activation status Last Execution Date
youkey's user avatar
  • 19
0 votes
0 answers
42 views

Incremental Data Export from SFMC to Adobe CDP

I wanted to talk through the logic for an automation I have, the issue im facing, and hopefully find a solution. Approach: I have an automation in SMFC that 1)queries for email open data and sends to ...
Ryan Moravick's user avatar
0 votes
1 answer
46 views

creating an automation from Fillezila to SFMC using Automation Studio

I was creating an automation from Fillezila to SFMC using Automation Studio. The csv was in the Subpast called scheduler(as you can see at the screenshot attached). When a run the automation studio it ...
Weslei Carvalho Santos's user avatar
-1 votes
1 answer
23 views

Update the existing records in DE, which is appended by another SQL with existing automation

I have an automation in which one SQL is appending the dada in Target DE, latter I found that this SQL is not getting values for all fields. So now I am updating my existing SQL to get values for ...
Krish's user avatar
  • 1
1 vote
1 answer
61 views

Removing contacts from a journey via script activity

I've written a script to remove a batch of contacts from a Journey since we've revised our criteria of who should enter. After testing it on a sample set of subscriberkeys, I searched for them in ...
K K's user avatar
  • 307
0 votes
0 answers
22 views

SFMC Mobile Push Demographics - querying LastAppOpen, LastMessageOpen, LastSend, MessageOpenCount

I am working with a client that is looking to query MobilePush Demographics data such as LastAppOpen, LastMessageOpen, LastSend, MessageOpenCount. However, it seems these fields are not found in the ...
Ryan Moravick's user avatar
1 vote
1 answer
134 views

Marketing Cloud - SSJS Activity timing out. Not sure of error

I have an SSJS Activity I am trying to get to work wherein we are calling an API endpoint using basic authentication (obviously the user and pass are obscured in production). But I am having issues ...
seanhmartin's user avatar
0 votes
0 answers
64 views

AB Test on Journey Builder

In Content Builder there is a feature called as AB Testing now I created an Email for that AB test and gave a name.If I place that Email in Journey Builder the Subscribers only receiving the ABTest 1 ...
Vinu's user avatar
  • 21
0 votes
0 answers
47 views

SQL Query to update DE field when "x" hours away from date/time field which is already formatted to the correct timezone

We are working on building a journey that is extremely dependent on utilizing a date/time field (StartDateTime) to determine when emails/sms are delivered. Given the constraints in Journey Builder ...
Spencer Bard's user avatar
1 vote
0 answers
52 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
  • 21
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
1 answer
106 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
23 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
169 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
-1 votes
1 answer
35 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
104 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
1 vote
0 answers
47 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
93 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
  • 5
0 votes
0 answers
78 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
0 votes
0 answers
113 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
1 answer
57 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
92 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
190 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
75 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
111 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
68 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
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
82 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
155 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
412 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
155 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
87 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
136 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
100 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
272 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
180 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
160 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
255 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
272 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

1
2 3 4 5
18