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
6
votes
3answers
119 views

Child Automation run as step in Parent Automation?

Any ideas on using this SSJS Automation Trigger (or some other method) to Trigger a Child Automation as a middle step in a Parent Automation that once complete continues to process? I have a long (...
4
votes
1answer
4k views

Making a REST API call from a Script Activity in Automation Studio

We are trying to update a service cloud custom object from marketing cloud. Can we make a REST api call within a script in Automation Studio.It will be great if someone in this forum can confirm they ...
4
votes
2answers
5k views

Query Activity system error in Automation Studio

Why am I getting a system error with this Query Activity in Automation Studio? Select o.AccountID , o.JobID , o.SubscriberKey , o.EventDate , o.isUnique , o‌​.Domain , o.Subscriber‌​ID , o....
4
votes
2answers
237 views

Subscribers currently in a Journey

What ways could you create a data extension that contains all the subscribers (SubscriberKeys) that are currently “in” a Journey (Journey Builder)? The Journey I would like to do this for is a ...
4
votes
1answer
581 views

Create or update Automation with Marketing Cloud REST API new endpoint

there is an endpoint to retrieve automation using Rest API with OAuth2 token and GET method: https://{{tenant}}.rest.marketingcloudapis.com/automation/v1/automations/{{id}} In the response you will ...
4
votes
2answers
49 views

SQL Query on reverting data from DE based on a filter condition and modify it before i put it into another DE

I am trying to retrieve multiple Columns from a DE and split a column into multiple columns and insert into another DE along with the original column. Ex : I have a DE-1 with Full name, Email and ...
4
votes
1answer
45 views

Will a Suppression List increase send time?

Background: I have a daily batch process that creates a sendable Data Extension from a query on a Synchronized Data Extension. The automation runs a query that overwrites the sendable Data Extension ...
4
votes
2answers
1k 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 ...
3
votes
3answers
2k views

Can Automation studio be scheduled less than once a hour

Due to one of the critical requirement, we would need to run the automation studio, less than once a hour. Has anyone have an idea if Salesforce support would be able to enable running automation ...
3
votes
3answers
284 views

How to identify object type using contactkey in marketing cloud?

I've synchronized two objects (from sales cloud) as Contacts in salesforce marketing cloud. These two objects are "Lead" & "Account" and both are mutually exclusive. I want to update bounce ...
3
votes
2answers
3k views

Updating All Subscribers from Data Extension

Is there a way to update a record in the AllSubscribers List from a Data Extension Import? I'm hoping to set up a daily automation that imports data file into a Data Extension on the subscriber key ...
3
votes
1answer
64 views

Using SSJS in Automation Studio to unsubscribe contacts from All Subscribers [duplicate]

We are using a custom preference center and an automation that extracts contacts from our Master Permission DE, who have Opt-in set as 'false'. This DE that contains opt-outs is evaluated and later ...
3
votes
1answer
113 views

Automation Studio Query not accepting parentheses in combined AND OR

We've run into a problem which prevents us from combining ANDs and ORs in the WHERE clause of a SQL statement. This is the syntax of our WHERE statement: SELECT s.subscriberKey FROM ...
3
votes
2answers
2k views

Query Inner Joins followed by a Left Join

I have a query that I am running that joins a few other data extensions and filters based on Role and Created_At date. Also I need to remove subscribers that are in this group that are also in ...
3
votes
2answers
141 views

Remove characters after @ in email address and replace with new domain

I have four brands that all use different email domains however our SF only has one email allocated per user with a random branded domain. eg usera@brand-a.com also uses @brand-b.com, @brand-c.com and ...
3
votes
1answer
407 views

Creation of a Filter Activity via API

After digging, I have found the API object for FilterActivities, and have been able to Perform, Retrieve, etc. from them, but have been unable to Create one from scratch. I have received the ...
3
votes
1answer
37 views

Query association to automation viewable?

Is it possible to see which automation a query activity is part of?
3
votes
1answer
1k views

Automation Studio error: Automation cannot be Performed. Automation has been marked as deleted

I have an issue where I can no longer start an Automation using the Fuel SOAP API. This used to work but has stopped working and I'm wondering if it's working for anyone else. I've created a new ...
3
votes
0answers
199 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
198 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
2answers
3k views

Query on system data views in Automation Studio

I was wondering if someone perhaps know how we can identify the system data views we use/have in our account? According to this article we should be able to query for instance the data view: ...
2
votes
2answers
296 views

Optimizing SQL queries

I've set up an automation that resends an altered version of a mail to all who recieved it the first time it was sent, but didn't open it. This is done in Automation Studio using 3 SQL Query and a ...
2
votes
1answer
456 views

Delete Subscriber records in Salesforce Marketing Cloud

We want to delete all subscriber records from "All Subscribers" which are not "Unsubscribed" or "Bounced" and created before last six months. How can we do it using automation studio?
2
votes
1answer
99 views

How does Select Distinct work on a Primary Key in Marketing cloud's SQL?

How does Marketing Cloud's SQL in Automation Studio works when having a DISTINCT operator on a data extensions that has a Primary Key (in my case "Customer_Key")? Specifically, does it look for unique ...
2
votes
2answers
362 views

Can i get latest record from data extension having duplicate records

I am updating my target data extension from the data extensions having multiple records by using sql query by union all in automation studio of marketing cloud. my query is SELECT FieldA, ...
2
votes
1answer
993 views

Marketing Cloud Journey Builder tracking data isn't returning to Salesforce

We configured Marketing Cloud Connect v5 to sync data between Salesforce and Marketing Cloud. Everything works fine. I can send individual emails in Sales Cloud, using Marketing Cloud Email templates. ...
2
votes
2answers
2k views

Automation studio SFTP file drop trigger to Import Activity

Background: We have a simple automation studio workflow defined that would trigger when file with a certain name pattern is dropped and that then initiates the import activity (which also relies on a ...
2
votes
1answer
209 views

Automation skipped

I just create two automation to build a loop process in which I don't have to wait 1 hour as it has to be when the Automation is scheduled. Automation A: One script activity that calls the Automation ...
2
votes
1answer
3k views

SQL Query in Marketing Cloud Today = date

I'm trying to query using a where clause such as this: WHERE Today = a specific date . This is what I have right now: DateAdd(day, 0, GetDate()) = '2018-02-12' (because it was 2/12 when I posted/...
2
votes
2answers
1k views

How to suppress contacts from marketing cloud email sends if they already got an email

My business is trying to implement 2 rules on marketers about the frequency they can email our contacts in marketing cloud. I am looking for a solution to do this perhaps in automation studio to ...
2
votes
1answer
132 views

How to obtain error status of automation via SSJS

I have the below SSJS which gives the status of scheduling in automation. But it doesn't give the status of automation: For example, if my automation errored, then am getting the status '6' which is ...
2
votes
1answer
122 views

Workaround to start an Automation from a Journey?

I have a requirement that has to do with adding/deleting subscribers from Auto-suppression list based on a Sales Cloud checkbox. Unfortunately I cannot make any development in Sales Cloud, it all has ...
2
votes
2answers
127 views

How to keep data up to date across Data Extensions

I am trying to get my head around how to keep all data extensions up to date with the most recent information in Marketing Cloud. For example, if I create a data extension to store form submission ...
2
votes
2answers
121 views

Delete Automations through API

Is it true that you can only create new automations through API, and not deleting them? We have a client, that by mistake made 9000 automations, and now we want to remove them through the API, instead ...
2
votes
1answer
708 views

Pulling Data from _Subscribers at BU level with SQL Query

I have a 2 Business Units setup, with a parent BU. Data is not meant to be shared between the 2. The purpose: I want to understand how to differentiate Subscribers from different BUs as they are not ...
2
votes
1answer
333 views

Marketing cloud sql query execution error - Violation of PRIMARY KEY constraint

I'm getting following error during update activity. Query failed during execution. Error: Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'Enq_opp_Parallel_ContactView'. The ...
2
votes
1answer
277 views

Error on completion of Data Extract and File Transfer

I'm currently experiencing an error on the Automation Studio with related to the Data Extract - One of the activity get failed by "Error has occurred" and File Transfer - one of the activity flagged "...
2
votes
1answer
2k views

Marketing Cloud Data Extract into the correct File Encoding format

I have created a Data Extract activity exports a .csv file containing records from my Data Extension. The file is in the wrong File Format so I have requested Salesforce activate additional encoding ...
2
votes
1answer
373 views

How to unpause an automation via API?

I'm trying to find a way to "unpause" a paused automation via API (using SSJS). When an automation is in "Ready" status (status code 2), you're able to invoke a perform (InvokePerform) to kick off the ...
2
votes
1answer
781 views

Create a data extension with the number of clicks and opened emails

I'm working on a feature for marketing cloud and I need to create a Data Extension with those fields : NumberOfOpenMails,NumberOfClicks and all the other fields relative to the subscriber. I found ...
2
votes
2answers
427 views

How do I cancel an automation from a script being run by the automation?

I have a scenario where we want to send the same email from multiple business units every day. The email should get updated daily, but I wanted to have a check in the automations in each business ...
2
votes
1answer
211 views

Primary Key Violation where there is no violation

I have a primary key violation occurring where there is no duplicate record within the target extension, nor the source extension (which is a synchronized data extension). Data Action type is ...
2
votes
1answer
161 views

Saving Server Side JavaScript Functions

Is it possible to create SSJS functions as code resources in Web Studio and then use those functions in other CloudPages or Script Activities? For example, if I created a function that generates an ...
2
votes
1answer
432 views

Marketing Cloud Automation studio won't update data extension

We are having trouble updating records in a data extension from an automation. It creates new records but it won't update. We have the salesforce custom object ID set up as the primary key and the ...
2
votes
2answers
668 views

Remove subscriber(s) from list via script

I'm pretty new at SSJS, but I'm trying to run a script in automation studio that removes a subscriber from a list via the unsubscribe function (see: https://developer.salesforce.com/docs/atlas.en-us....
2
votes
1answer
193 views

Date and Time function not usable anymore

Good day, I use in Automation Studio, an SQL query using functions like dateAdd() and Datediff(). Since yesterday, this activity is errored with this message : " An error occured while checking the ...
2
votes
2answers
2k views

How to export multiple HTML emails(entirely) with all properties(such as Images) from one Exact Target instance to another

I'm trying to find a solution as to migrate all of my HTML emails with their properties i.e. Jpeg/PNG files in them from one instance of Exact Target to another instance , considering these are to ...
2
votes
1answer
648 views

Email Send Error - Skip bad sends only or Have Email alert sent on error

I had a small error in my email sends recently that stopped over 50K emails from going out because there was a crazy unlikely Ampscript error on 2 of the messages. I completely understand that this is ...
2
votes
1answer
387 views

Fire Event Activity REST

Is there any way I can trigger the journey builder event via API, the same way you do using automation. I know you can fire event using this REST call https://code.exacttarget.com/apis-sdks/rest-api/...

1
2 3 4 5
11