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
1answer
3k views

Trying to automate contact deletion with SSJS

with the GDPR laws in place, it's important to have the possibility to remove contacts from Marketing Cloud. I'm trying to automate the process with existing tools and am looking for possible ...
4
votes
1answer
5k 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
419 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 ...
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 ...
0
votes
1answer
4k views

Date manipulation Function SSJS

I want to delete the records from Data Extension based on Date Field in my DE i.e. I want to delete record which were created date before 30 days.But I didn't find date manipulation function in SSJS ...
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 ...
0
votes
1answer
1k views

Starting Automation Program using SOAP API

I have struggling to get the SOAP API work to start the Automation Program. Below is the call I am using. It is returning OK status but the program doesn't start. <soap:Envelope xmlns:soap="http:...
0
votes
1answer
5k views

File Transfer Activity Encrypt and Decrypt with PGP

Using a File Transfer Activity and Import File Activity in an automation (File Drop), I am trying to read a CSV file into one of my data extensions. Halfway through the process, there is an update to ...
4
votes
1answer
659 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
3answers
478 views

Update Data Extension by using SQL Query in Automation Studio of Marketing Cloud

i am new to Marketing Cloud i am just learning it, i want to do the following things: I am having 4 Data Extension De1, De2, De3, De4 De1 having 4 fields(fieldA, fieldB, fieldC, fieldD) De2 having 2 ...
3
votes
1answer
3k 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
133 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
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....
2
votes
1answer
403 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 ...
1
vote
1answer
834 views

Automation studio send email and sending tracking to salesforce

is it possible to use automation studio to send an email and send tracking information back to salesforce? We can't see an option to send tracking data back to salescloud as we do in Journey builder. ...
1
vote
1answer
711 views

How to improve this SSJS

Recently started to learn SSJS and wrote the script (for automation studio) which is located below. What i am interested in is: How can i improve this Server Side JavaScript performance wise? For ...
0
votes
1answer
332 views

SystemDateToLocalDate inside SQL Automation

I know the function SystemDateToLocalDate is not available inside SQL but i would like exactly that feature inside an SQL query to convert the Date records of data_views (which are CST Central ...
0
votes
1answer
796 views

Export all contacts with automation issue

I want to export all subscribers to extract the "status" column on every subscriber. I want to automate the steps as in this official documentation. I know how i do it manually but it needs to be ...
0
votes
2answers
569 views

Target vs Control using Automation Studio

We are creating campaigns using automation studio due to campaign complexity. However, in these campaigns we are trying to implement Target vs control population. The issue is we can't use the random ...
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 ...
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 ...
1
vote
2answers
848 views

Emailing Report - Automation Studio

Is there a way to Email a Scheduled Report (created using SQL) in Marketing Cloud Automation Studio?
1
vote
2answers
3k views

How to move data from a list to a data extension

I need to create a automation that extracts and drops a entire list onto the FTP each day. My issue is that the data lies within a list. Is it possible to create a query that populates a data ...
1
vote
1answer
37 views

_Journey Data View query only listing Journeys with a VersionNumber of 1

I've been attempting to join up a query between the _JourneyActivity and _Journey data views on VersionID but am noticing that I am unable to successfully Join up on anything beyond a VersionNumber of ...
1
vote
1answer
237 views

Status codes of Program object?

I am retrieving the status of an Automation and do not know what the status codes represent. I've seen documentation on this, but can no longer find it. 2 and 3 are being returned most frequently: &...
1
vote
1answer
363 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? ...
1
vote
1answer
2k views

Limitations for Import from Enhanced FTP in SFMC

I am using Data Extract -> File Transfer -> Import via an automation to upload my synchronized data extensions to All Subscribers in Marketing Cloud. Currently everything seems to work fine, however ...
0
votes
2answers
52 views

I am trying to update a field of a data extension via SSJS within a script in automation but it does not update me

Platform.Load("core","1"); var subs = DataExtension.Init('cambio_estado'); var data = subs.Rows.Retrieve(); try {for (var i = 0 ; i < data.length ; i ++) { var ...
0
votes
2answers
66 views

Mass remove records from suppression list

I have a case where I am being requested that any record that has received an email in the last 3 days needs to be suppressed from additional emails. This includes single mass sends, and any journey ...
0
votes
1answer
829 views

Trigger entry event when new rows are added to data extension [Salesforce Marketing Cloud]

We're using a Facebook lead capture form, which loads new entries through to a data extension in real time. We've then set up a Journey Builder journey to send an email to records that enter the data ...
0
votes
1answer
241 views

Marketing Cloud Automation Studio Scripty Activity getting time out

We have script activity which is posting (HTTP post) messages to another system. However, Script activity is getting time out after 30 mins as per default timeout setting. Is it possible to override ...
0
votes
2answers
531 views

Activating Multiple Triggered Automations across Business Units?

Has anyone ever had any success in starting multiple triggered automations across multiple business units based on a single file drop? It would appear that only a single triggered automation can be ...
0
votes
0answers
180 views

URL Concatenation is not working in the content area generated by SSJS

URL conacatenation is not working in the content area generated through SSJS script .The scenario is we are generating a content through SSJS and its stored in the content area and its then pulled ...
0
votes
1answer
366 views

Auto Generate Subscriber Key

I a have a file drop automation which is importing data into specific data extension - there is no subscriber info in the data and I do not want to set one to email address. What would be the best way ...
0
votes
2answers
717 views

Does IsUnique in the _Click data view dedupe subscribers over multiple jobs?

I want to write a SQL query that will find the total clicks and unique clicks for 1 URL across multiple email sends. Total clicks is easy, but I'm not sure about the unique clicks. I want to basically ...
0
votes
1answer
991 views

SSJS Functions in Automation Studio

I am trying to create a Data Extension using SSJS Script through Automation Studio. My script is as follows: <script runat="server"> platform.load("core","1.1"); var deObj = { "...