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.

135 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
200 views

Update Marketing Cloud Automation tasks with SOAP API returns “OK” response but doens't update

I'm trying to update the AutomationTasks of an automation in Marketing Cloud with the SOAP API. The docs don't indicate whether this is possible (the example SOAP envelope for updating an automation ...
3
votes
1answer
201 views

Automation Studio - Imports old file data or same data into Data extension again in file Drop automation with import activity?

Actually, I created File Drop automation to import data into Data Extension. I dropped different files into the same file location. After the completion of automation flow - it imports data of the ...
3
votes
1answer
200 views

How do i set a field to null in journey builder contact interaction

JB supports adding a value to a field, but does not seem to support clearing a value. Does anyone know what to add to field criteria to clear a value? Just entering null does not work. It applies ...
3
votes
0answers
406 views

Sending marketing cloud mails from Salesforce instantly

We have a unique problem in Sending marketing cloud mails from Salesforce. Contact records are available in Salesforce and the logic to select which contact should receive the marketing cloud mail is ...
2
votes
0answers
20 views

automation studio - daylight savings

I have automations scheduled in EST in automation studio. Emails cant send during these automations. Users were told not to send at 5am and 5pm EST. They reporting since daylight savings earlier this ...
2
votes
1answer
100 views

Using Marketing Cloud API to Activate, not Run, an Automation

I am looking for a way to use the Marketing Cloud API to activate an Automation in a manner that is equivalent to pressing the "Active" button in the UI (next to the "Paused" button). Eliot Harper ...
2
votes
0answers
142 views

Left Join query

I'm trying to left join a table in Marketing Cloud Automation Studio Query. I don't receive any errors but the expected data is not pulling into the data extension. The bolded statements are what are ...
2
votes
0answers
115 views

Send Throttling + Wait Activities in Automation Studio

I'm creating an automation that has user-initiated sends and wait activities. After the first user-initiated send at 9am, there is a wait activity for 24 hours, then another user-initiated send, then ...
2
votes
1answer
84 views

Two vastly different counts using queries found here… what's the difference?

As a SQL neophyte, I know enough to be dangerous. I have two queries, both found here... the first is the one I'm directed to to answer "who hasn't opened an email in xx days". SELECT s....
2
votes
0answers
405 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
0answers
560 views

How Do I Properly Offset GETDATE() in Marketing Cloud Query Activities for US Eastern Time Year-Round?

I want to use a Query Activity within Automation Studio to find all of our app's users who last logged in between 24 and 25 hours ago. When I run the below query into a data extension, I instead get ...
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 ...
2
votes
1answer
105 views

Move Tracking Extract to Export Subfolder

I have a data extract (Standard Tracking Extract) that I created in Email Studio under Interactions. I built an automation that I'd like to schedule on a recurring frequency daily. However, the ...
2
votes
0answers
320 views

ExactTarget - Automation - SOAP API deserialization

When using the C# library and SOAP to retrieve an automation, the AutomationTasks property will always be null even though the SOAP envelop of the response actually contains the AutomationTasks Node. ...
1
vote
0answers
28 views

Save %%FILENAME_FROM_TRIGGER%% as field value

Is there a way to get the value of %%FILENAME_FROM_TRIGGER%% from an import activity and save it somewhere, maybe in a DE? I am building a dashboard (cloudpage) that will display what file is ...
1
vote
0answers
67 views

Marketing Cloud SSJS update to data extension

I have a data extension that I use for a newsletter. This newsletter will consist of a monthly automation to update the DE and a journey to send emails (12 months). My DE has a number field "...
1
vote
1answer
66 views

How to conditionally delay a scheduled automation run in Automation Studio

I have an automation process which is scheduled to run on the first Monday of every month. This automation has a "Journey Builder Trigger" activity for injecting contacts to a journey. I need to ...
1
vote
1answer
66 views

How to Prevent Automation from Skipping

I have an file drop automation set up to import files dropped in a specific folder on the FTP. These files are very large and take a while to import so I have enabled queuing on the automation. The ...
1
vote
0answers
50 views

Setting a Scheduled Automation to Active with REST API

I can activate scheduled automations through soap but only if their schedule is not already configured. Does anyone know how to activate a scheduled automation through REST API? I think the "isActive" ...
1
vote
1answer
47 views

Connect Multiple Journey to a Single Automation in a batch process

I'd like to know if it is possible to connect more than one journey within a single automation. The Automation studio receives a large amount of data on a regular basis and sends it to different ...
1
vote
0answers
217 views

Getting something more than “Error while parsing query. Please check the syntax” in SQL Query Activity

I am creating a Query Activity in the Automation Studio. The query gives the following message in red: An error occurred while checking the query syntax. Errors: Error while parsing query. ...
1
vote
0answers
54 views

automation FTP file location

I'm trying to create an automation to fetch a CSV from the FTP and populate a Data Extension. After the File Drop and setting up the Path from the FTP import folder to the correct file name I use the ...
1
vote
0answers
29 views

How to query Failed Email Sends over each business unit?

I have a request asking to send out an email with the failed send JobId's (lookback last 2 days) - I would like to automate this process by logging the failed send data to triggered send data ...
1
vote
0answers
288 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
0answers
65 views

Salesforce Marketing Cloud: How to restrict access to All Subscriber from Child BU

We have Production BU and UAT BU in our implementation,We want our developer not to access All Subscriber in UAT BU because of PII issue. I can control it with Custom role with deny access to All ...
1
vote
1answer
151 views

Fill a DE thanks to SSJS in Script Activity using an external API

What I'm trying to do, is to fill a Data Extension using SSJS on weather column. (For the test I'm using nodeJS) Data Extension : "Weather API" weather | city name | country code (empty)...
1
vote
0answers
61 views

How do I order rows in columns using AutomationStudio SQL

I am performing a SQL query in Automation Studio and I want the following: Populate a data extension with ID of the Account_salesforce table with the ListName (Lists) bound to the ID of the first ...
1
vote
1answer
58 views

Trying To Setup An Auto Loan ReCapture Program

We are trying to create an auto loan recapture program. The program goal is to target Members, who are close to paying off their current auto loan with us (within let's say 2-3 months), to open ...
1
vote
0answers
77 views

How to add a Send Email Activity to an Automation with FuelSDK-Python?

I unable to associate an Email Send Activity when creating an automation in Fuel-SDK Python. Below is my props dictionary setup. When posted the Automation is created but there is no Send Email ...
1
vote
0answers
211 views

Email Send Activity in Automation Studio is not able to send Emails to duplicate Subscribers

We are trying to implement an event notification system in SFMC. When a subscriber subscribes for an event he is getting a confirmation email. 3 days prior to the event I need to send a Reminder email ...
1
vote
1answer
144 views

Load Data from Synchronized data extension to data extensions by SQL Query

I am trying to get Synchronized data extensions data to Data extensions in salesforce marketing cloud, I need a custom field from campaigns Synchronized data extensions. I made a query as select Id, ...
1
vote
1answer
100 views

Using SQL to compare and update data extension

I need to use SQL in an automation to compare the data from the "TemporaryDE" with the Data from the "CompareDe". If the CompanyName value from the "TemporaryDE" is not present in the "CompareDe" - to ...
1
vote
0answers
225 views

Insert a delay of a few seconds in SSJS script after a function call

Use case: Send emails based on personlization data of a few records using SSJS script. I have an email that will pull personlization data of off a non sendable Data Extension. The email will pull the ...
1
vote
1answer
76 views

SQL Won't Populate Salesforce Data Extension

I am trying to dump data from a Salesforce object into a Salesforce Data Extension. I am not getting an errors but the data refuses to populate. I can't figure out what I am doing wrong! I have tried ...
1
vote
2answers
725 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
62 views

Generic System Error when I use a Left Join

I'm creating an automation that uses a series of SQL queries to identify people who were potentially targeted for a dynamic content block in an email, determine if they were included in a job that ...
1
vote
0answers
128 views

Create Automation using Fuel SDK API in node.js

I need to create an automation in Marketing Cloud using fuelSDK-node. I cannot find any documentation regarding the same but I got documentation for .NET code Can anyone please help me with the same?
1
vote
0answers
473 views

What's wrong with this “HTTP.Get” in SSJS?

In activities I am running this script: <script runat="server"> Platform.Load("Core", "1.1.1") var NewReq = HTTP.Get("http://samplesite.com/sample.html"); </script> It always throws ...
1
vote
1answer
51 views

Journey Builder

Is it possible to trigger a journey when i only have the record id in the data extension and that record id is also present in the CRM and i need to fetch the email address from CRM and trigger a ...
1
vote
1answer
408 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
1answer
775 views

Query Journey Builder Sends

I want to run a query to pick up all subscribers who received a JB email in the last 7 days from a specficic Journey. I found this article but it is not filling the data extension! https://help....
1
vote
0answers
444 views

Import File Activity - File Naming Pattern / Wildcards - How far will the default go back in time?

My question is about wildcards / file name pattern inside automation studio. When you define a file name pattern inside an import file activity like FULL_IMPORT_%%Day%%%%Month%%%%Year%%.csv how will ...
1
vote
0answers
40 views

Import Activity locking file before import starts

I have created an automation that has an Import Activity from my SFTP. What we have noticed is that the automation seems to have been writing over the file prior to the automation running (it's set 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 ...
1
vote
1answer
548 views

How to import records into Marketing cloud from Salesforcce

I want to import records in Marketing cloud from Salesforce objects or reports because I'm not able to see the option of IMPORT in the interactions tab in Marketing cloud?
1
vote
1answer
299 views

How to access fields from entry DE in Journey Builder via AMPscript?

I want to send a push message via MobilePush from inside a customer journey. The content of the push message should personalised with AMPscript, based on the entry audience of the journey, which is a ...
1
vote
0answers
74 views

Automation Trigger Options

We currently trigger automations via a file drop to a FTP Location. This works well as the file drops, processes and waits until 9am before it sends the mail. Sometimes are file drops are late and ...
1
vote
1answer
449 views

ExactTarget Automation Monitoring

I had a question about how folks monitor their automations' successes and failures. We currently have a very manual process that I'm hoping to automate (no pun intended). Currently we: Receive ...
1
vote
0answers
80 views

How do I perform an automation immediately by PHP?

I found that can perform an automation immediately on Marketing Cloud via soap API. (see: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/...
1
vote
0answers
49 views

Customer enter directly to day 10 rather than going through day 1,2,5

I would like to know, if it is possible for a customer to enter the journey at later date and continue the journey from that day. Example - I am going live today, my journey is scheduled from Day 1, ...