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.

104 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
123 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
155 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
1answer
60 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
105 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
95 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
77 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
83 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
343 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
440 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
956 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
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
0answers
362 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
299 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
37 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
28 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
46 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
42 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
23 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
110 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
45 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
80 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
109 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
48 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
55 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
54 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
140 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
97 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
70 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
164 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
51 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
412 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
49 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
350 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
250 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
500 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
230 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
35 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
436 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
270 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
73 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
357 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
1answer
688 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
79 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
91 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
308 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
1answer
28 views

Populating Data Extension with tracking aliases

I have a welcome journey in which the subscriber at a point chooses which room needs a redesign. The links for these 3 rooms have tracking aliases like this: Image_RoPLivingRoom CTA_RoPLivingRoom ...
0
votes
1answer
26 views

During overwrite, Marketing Cloud picks first PK record instead of prompting PrimaryKey violation

We have a peculiar case where we are joining 3 different data extensions (i.e. Consent_DE, Address DE and Channels DE) via SQL in Automation Studio. We have Global_ID as unique customer identifier ...
0
votes
1answer
54 views

Birthday Journey with Sql query in Automation

I have created a Journey with Automation for birthday. I have a data extension with birthday field, using which I have created an automation to include only the customer's having birthday's on the ...