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
39 views

Query Deleted Subscriber in All Subscriber List In MC

Is there a way to query MC to identify if a subscriber was deleted from the All subscriber list at any point in time? Thanks
0
votes
1answer
22 views

Multiply two fields if an ID is found in a separate table

Trying to create a Data Extension where we calculate the total spend in a category, if the category exists in a list of promotional categories. The point is that we want to provide an offer when a ...
0
votes
2answers
73 views

Week Number, where week starts on Monday (not Sunday)

I'm trying to calculate the number of new subscribers, unsubscribes, held, etc, by week where the week starts on Monday and ends on Sunday. I can get the query to work fine when the week starts on ...
1
vote
2answers
339 views

Marketing Cloud update activity fails for primary key violation

We have a daily Update query activity that is failing because of a primary key violation on the email field. I'm confused by this because I thought an Update activity should, well, update the target ...
0
votes
2answers
99 views

Why is my code querying All Subscribers producing results that don't exist in All Subscribers?

In Marketing Cloud - I'm trying to write an SQL that will pull everyone who has opened an email in the last 90 days. I'm getting results from the below SQL, but when I spot-check the data, I'm finding ...
0
votes
1answer
95 views

Showing Error while joining two synchronized data extensions in automation studio

I am trying to query two synchronized data extension and update the result to a data extension select O.CloseDate,O.StageName,O.Id, P.Contact__c.Id,P.Id From Plot__c_Salesforce P Join ...
0
votes
2answers
253 views

Marketing Cloud: Automation Studio Email to Sales Cloud Contact

I'm needing to send a couple emails using automation studio (we aren't paying for journey builder) to Contacts that are entered into Sales Cloud that match certain criteria. Here are the steps I've ...
2
votes
1answer
273 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 ...
1
vote
3answers
494 views

How do I move a Filtered Data Extension automation based off a Synchronized DE?

So, I've created several Data Filters off our Data Extension for the purposes of segmenting our audience. I've been manually refreshing these filtered DE's whenever sending, but I'll need to automate ...
1
vote
0answers
385 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
45 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
273 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
2answers
254 views

SSJS Error - Retrieving data from two DataExtensions and want to update the initial DataExtension

Anybody an idea what is wrong with this script? It is my first SSJS script in the automation studio but I just get the error message: An error has occured. I got the functions from the documentary. ...
1
vote
1answer
1k views

Query From Shared Data Extension

I have a shared Data Extensions across multiple Business Units. I need to run a query from it in a Child BU but every time I try to run I get "× An error occurred while checking the query syntax....
0
votes
1answer
75 views

Possible to REPLACE/REPLACE and then CAST a DE value in a SQL query?

We're writing SQL for an Automation to find orders that qualify for a promo based on spend. The source DE has a TEXT field with a dollar sign $, the order value and some HTML <br /> - i.e., $...
0
votes
0answers
53 views

Can't CAST TEXT field successfully into a DECIMAL (18,2) data type

Client is looking to send a coupon for any orders over $250. However, they are passing the order value as a TEXT field, not a DECIMAL. I'm trying to run the query by using CAST, but no luck. I've ...
1
vote
1answer
116 views

Two automations using the same file drop

Has anyone been successful in triggering two automations from one file drop? I'm testing it and it seems to be corrupting something on the back end. As soon as I try to create a second automation ...
3
votes
2answers
2k 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 ...
1
vote
1answer
82 views

can I get a list of all customers who have not opened any emails for the past 3 months in SalesForce Marketing Cloud

May I ask if you have any ideas on how can I get or pull a list of people who have not opened any emails for the past 3 months?
0
votes
1answer
179 views

How to get the Exclusion List via SQL Query in Automation Studio

I need to exclude List to whom the particular email has been sent previously from Automation Studio via SQL Activity (Data views). select distinct s.SubscriberKey from _sent s ...
0
votes
1answer
50 views

Dont stop subsequent activites in Automation if step fails

I have an Automation which has a series of activities, one of them being an import of a file into my Subscribers list (after being generated by SQL and a data extract). After the import is completed ...
-1
votes
1answer
56 views

Sending data from Marketing cloud Data Extension to External Database on real time

My requirement is to update external database real time or equivalent to real time from my Data Extension. My Data extension get updated on a basis on real time so now I want the same to be happened ...
0
votes
1answer
61 views

SQL Query Openers Fail

I am trying to run a query of all of our email openers that are older than 64.5. My SQL looks right but I keep getting the following "Automation failed due to system error." is this on my end or on ...
0
votes
1answer
65 views

SQL count not working as expected

I have a query that aims to pull counts for: total subscriber records, total for each subscriber status, total optins, total optins for each source, total unsubs, total unsubs for each source. I am ...
1
vote
1answer
542 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....
0
votes
1answer
730 views

Automation Studio File Drop source from external FTP

Setting up an automation to occur on file drop but it appears the only options for directory choice are in the import folder or the legacy triggered automations folder. The file that I'm dropping ...
0
votes
1answer
105 views

Managing FTPs for multiple business units

I've run into an issue with the amount of licenses I have available to use in out ETL generator (Dell Boomi). Using this to push data into a 5 different business units and file dropping to the ...
1
vote
1answer
504 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 ...
2
votes
2answers
231 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 ...
0
votes
1answer
131 views

Data Filter in marketing cloud

I have a question related to data filter. Can we check the filtered record into marketing cloud? I created an automation with below activities - Query activity: This activity will update my sync ...
0
votes
1answer
535 views

How to setup Birthday Email on Automation Studio?

I want to send a birthday email. So I already connect both the cloud and get the record of contact object into the sync data extension and I also created a standard data extension in marketing cloud. ...
1
vote
1answer
41 views

Promotional Email to Sales Cloud contacts using Automation Studio [closed]

I want to create an automation which will send email to all the contacts from sales cloud. So it will be a promotional holiday email like (Fathers day , New year ,Good friday etc). I already connect ...
0
votes
1answer
300 views

run automation SOAP API

I have created a automation with script activity which i need to run it through SOAP API. when i pass the payload i get a response as 200 ok but the automation is not running. Below is the payload.<...
0
votes
2answers
134 views

Trying to run a sql activity thourgh a curl SOAP request - SoapAction incorrect?

If I manual trigger/run the activity the destination Data Extension is being filled correctly. However when try a SOAP request using curl, nothing happens... I've tried 2 different SoapAction values. ...
0
votes
0answers
44 views

T-SQL Automation Studio activity by minutes period

I see there's no option to automate and run an sql activity in frequency of XY minutes... The shortest unit of time is the hour (hh). I know the T-SQL query supports the mi,n for minutes. But the ...
2
votes
0answers
83 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 ...
0
votes
1answer
489 views

Query MobileConnect Lists

I need to query a MobileConnect List to delete some Contact records. Following this documentation on MC they status creating a MobileConnect List can then be queried into a Data Extension using the ...
1
vote
0answers
280 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
1answer
500 views

How to write a SQL query with dynamic fields?

For example, I have a DE table(DE_A) with field a, b, c, d. The client may add e,f,g in the future due to their needs. My current SQL Query activity is : SELECT CONCAT("prefix", a) AS a, CONCAT(b, "...
0
votes
1answer
673 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 = { "...
0
votes
2answers
863 views

SSJS Rows.Retrieve not returning any rows

I'm having an issue where I'm unable to retrieve any rows from a DE that I know is populated inside an automation. Here is my code: <script runat="server"> Platform.Load("core","1"); var ...
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: ...
1
vote
2answers
278 views

Stop automation at a certain time

I'm looking to see if its possible to stop an automation if it goes past 4am? I have another job which runs at 4:30 and I don't want these jobs to clash.
2
votes
1answer
307 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
261 views

How's the performance differences between SSJS and AMPScript in Automation Studio?

I'm planning to process >100K records in a DE table using automation studio. I can write the correct logic using SSJS. However, I found out the performance of SSJS is really poor and always get ...
0
votes
1answer
147 views

Recycle bin in marketing cloud / SOAP call active objects

I'm using a SOAP call to perform an SQL Query and I get this error: QueryDefinition was unable to queue this task. This query definition is not active My call : <RetrieveRequestMsg xmlns="http:...
4
votes
1answer
3k 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 ...
1
vote
1answer
245 views

Send/Create an SQL request for Marketing Cloud with SOAP API

I'm working on a custom activity for JourneyBuilder in nodeJs and I need to make an SQL request like in automation studio to make a process easier. I found the package node-saleforce where you can do ...
2
votes
2answers
546 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
537 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 ...