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.

94 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
93 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
142 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 ...
2
votes
0answers
34 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
69 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
1answer
68 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 ...
2
votes
0answers
67 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
81 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
302 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
332 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
0answers
819 views

Cannot Query Synchronized Data Extension

I have created a Query to consolidate data from 2 Synchronized Data Extensions into one Sendable DE, but upon running it I get an "Automation failed due to system error". At first I thought my query ...
2
votes
1answer
1k 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
0answers
335 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
292 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
33 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
1answer
32 views

Marketing Cloud: pulling bounces at business-unit level

We would like to pull all the bounces from a business unit via SQL to a single target data extension. The target DE has the following data columns from 3 data views DEs (_Subscribers, _Job, _Bounce): ...
1
vote
1answer
37 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
51 views

Send SMS to updated mobile number via Journey

I'm working on a use case, in which a contact enters a journey. The purpose of Journey is only to send sms. 1st SMS sent as contact enters the journey. After 3 days, contact changes his mobile ...
1
vote
1answer
92 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
43 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
53 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
34 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
70 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
49 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
54 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
110 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
45 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
1answer
214 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
47 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
257 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
186 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
351 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
153 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
33 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
17 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
359 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
244 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
68 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
566 views

Link a synchronised data extension in Data Designer

I am currently working in a multicloud project (Service and Marketing) and I will use the Data Stream to stream objects from Service Cloud to Marketing Cloud. I want to know what is the best ...
1
vote
0answers
76 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, ...
1
vote
1answer
87 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 ...
1
vote
1answer
264 views

How can an Automation be deleted using ExactTarget SOAP API?

I have a delete request coded using the SOAP API and the response back is: AutomationDelete:["Delete Access is denied!", 0]"Error" Is the action truly denied or am I not writing the code properly? ...
0
votes
0answers
16 views

RSS Email Campaign for MarketingCloud

I've been using an AMPscript to bring RSS Content into an email for some time now. That work's without issua and I'm ready to try the next step to actually automate a subscription service... It looks ...
0
votes
0answers
14 views

Import File Activity . field not found validation error

In Marketing Cloud's Automation Studio, we created an automated import file activity based on a file drop trigger (i.e. file naming pattern, not the folder-based drop). Even though the automation runs ...
0
votes
0answers
21 views

How to know where an automation is used?

Please I need to know In which Journey Builders, an Automation is used in the entire Business Unit. What is the quickest way to do that?
0
votes
1answer
34 views

Special Characters replaced in data extension with SQL Query

I used a series of queries in automation studio and filter activities in automation studio. What I did: Using SQL: copied my original data extension into a new one, added a new column and used a case ...
0
votes
0answers
48 views

SQL to post + 30 days by Date/Time attribute

Goal is to find rows where the date is exactly 30 days from today. Source is a Salesforce Date/Time field from a Synchronised Data Extension and posted to a regular Data Extension to Date attribute. ...
0
votes
2answers
38 views

SSJS Activity of automation - Split String using javascript

I am trying to split string variable in ssjs script but my automation always turns into error below is my code to split the string: var str = '<CreatedDate>2018-10-24T04:31:00</CreatedDate&...
0
votes
0answers
11 views

Which of the many files with the same naming pattern will be read into the Data Extension in an Import File activity?

I am using an Import File Activity to read data into one of my Data Extension. Every day a new file will be dropped into the FTP folder with the following pattern: Customers_%%Year%%%%Month%%%%Day%%....
0
votes
0answers
29 views

Unable to add data to Data Extension using Automation script Activity

I am trying add data that come from response of SOAP API to get data from list in data extension If response contains 2500 records then I am using for loop to add this data one by one in data ...