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
2
votes
1answer
32 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 ...
0
votes
1answer
27 views

Marketing Cloud to s3

I have an s3 bucket I would like to transfer data to daily via automation. It currently doesn't look like there is a native way to transfer data into s3 via a file transfer activity. Has anyone had ...
0
votes
1answer
1k views

Query activity for records created today not working

I'm in the process of setting up a triggered automation that follows the process Upload to FTP > Import > Wait > Query > Wait > Send Email (to the target data extension of the query). I'm currently ...
1
vote
0answers
132 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 ...
0
votes
1answer
16 views

Data Extract Audience Studio Format

We are currently implementing Audience Studio, one piece needed in our project is a first-party import. My initial thought for this was to use a data extract activity in the marketing cloud to do this ...
0
votes
0answers
19 views

List of Failed Automations

Is there a way to create a list of f ailed Automations on daily basis and dump those records into any DE? Or any Data view to looks for failed automations?
1
vote
1answer
36 views

Automation doesn't run through SSJS when it is in a Paused state

I was able to run an automation which is in "scheduled" staus using SSJS, but when I pause it manually (status changed to "Paused") and execute the same script, the automation doesn't run. The script ...
0
votes
0answers
25 views

Checking Filter Condition in Another Data Extension in Marketing Cloud

In the Marketing Cloud parent BU level, to which our external data comes in, we have 2 data extensions: one is "Customer_Data" and the other is "Master_Consent". Our goal is to "download" the entire ...
1
vote
1answer
46 views

Create an automation to fetch data from FTP and create a DE that updates every day

I want to create an automation that pulls the data from the FTP to salesforce and creates a data extension that gets updated every day. The problem is that the folder where the data is located is ...
0
votes
1answer
357 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
1answer
26 views

Automation Update action failed due to Violation of PRIMARY KEY constraint. Cannot insert duplicate key

Can anyone help me out why the automation is failing? If I'm using Overwrite activity and query work perfectly. When I'm trying to update the target DE it is failing. below is my query. SELECT a....
6
votes
3answers
56 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 (...
0
votes
1answer
1k views

Query Activity - Merge Data Extensions

I am trying to merge two DE (Accounts& Leads) into 1 Master DE. I want to exclude the leads already imported when importing the accounts. This is the SQL: SELECT T1.Email AS EmailAddress, ...
0
votes
1answer
977 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
46 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 ...
-3
votes
1answer
42 views

How to create a Sendlog functionality using in AMPScript [on hold]

Whenever an email is sent to target audience , client wants to know which email has been sent to customers and at what time its sent. Kindly provide a solution for it.
1
vote
0answers
21 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 ...
0
votes
1answer
25 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
1answer
21 views

I'm attempting to union 8 Data Extensions in Marketing Cloud but I'm getting errors on the syntax

I have 8 data extensions that I want to union all into one master data extension. All the column headers are the same for each DE and the master DE. The only differences in the 8 DEs are the records....
0
votes
1answer
28 views

Consequences of emptying and refilling Data Extensions of Contact Model

After a lot of wrestling with the Script Activities containing SSJS for removing unwanted rows from my DEs and noticing that there are limits on the number of rows they can delete in a for-loop (2500) ...
0
votes
0answers
32 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
1answer
39 views

Contacts with multiple email addresses tied to single ID - SQL Join

We have 2 data extensions which we would like to join. The first called "MasterContacts" has contact information, including multiple email addresses tied to one FederationID, which is present in the ...
0
votes
2answers
608 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 ...
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
36 views

SQL to get the most recently created record based on Datetime from Data extension in SFMC? [closed]

How to get the most recently created record based on datetime using SQL in marketing cloud? Sql: SELECT TOP 1 Name, Email, DateTime FROM DateBasedDE ORDER BY DateTime DESC
1
vote
1answer
394 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
44 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
383 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?
2
votes
2answers
75 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, ...
-3
votes
1answer
43 views

SQL query to track non openers in the last 90 days (Marketing Cloud)

Wondering if anyone would be able to help me. I need to build an sql query in Marketing Cloud that allows us to track anyone who hasn't opened an email within the last 90 days. We have tried to use ...
0
votes
2answers
402 views

Does refreshing a filtered data extension reset the high watermark?

I have an automation which runs every hour, checking to see if contacts have clicked or opened a number of emails. This runs a filter, which updates a data extension. Is this interaction completely ...
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): ...
-4
votes
3answers
76 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 ...
0
votes
1answer
24 views

Where to run query activity for Journey

I have a query activity which populates a Data Extension, this data extension is then used within a Journey to populate entries. When activating the journey, MC creates an automation when a schedule ...
0
votes
1answer
39 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
1answer
564 views

Query Journey Goals and Exits

There appears to be little documentation around these functions in Journey Builder, so hoping someone may have some insight. Can this data be accessed through the Journey Data Views or any other ...
0
votes
2answers
34 views

Is it possible to update data extesnion from the another data extensions having different no of fields?

I am having 4 Data Extension with different number of fields but 1 field that is common in all(EmailField) is my primary key. I want to update my 5th Target Data Extension with the data that is in ...
0
votes
1answer
210 views

Schedule SFMC Automation via API

If I try to schedule an automation I use Schedule method and works perfectly if I'm working on the parent business unit of an enterprise account. If I try to schedule an Automation that is created on ...
-1
votes
1answer
50 views

How can i update my master data extension from another data extensions in marketing cloud

I am having as data extension name as MasterDe and i want to add and update it with the data that is in other data extension named as DataDeA, DataDeB and DataDeC. All these Dataextension having two ...
1
vote
1answer
40 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 ...
3
votes
3answers
141 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 ...
0
votes
1answer
63 views

How to Setup an File Drop Trigger for an Automation via the API?

I created an automation triggered by a file drop in SFMC using the API but the file drop section still needs to be configured. The closest thing to an answer I could find was this post in which ...
1
vote
1answer
597 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 ...
2
votes
2answers
177 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 ...
1
vote
2answers
78 views

SQL Query for Inactive Users- Send Log DE Code

This question is in relation to a previous question I had asked. To summarize: I am trying to run a SQL Query in automation studio to evaluate contacts in a data extension who have not opened an ...
0
votes
1answer
42 views

ExactTarget : sql query from _subscribers is not retriving any record

I have below SQL query in Automation: SELECT TOP(10) EmailAddress AS EmailAddress,DateUnsubscribed AS DateUnsubscribed, Status AS Status,SubscriberKey AS SubscriberKey,SubscriberID AS SubscriberID ...
0
votes
1answer
43 views

SQL Querying subscribers older than 6 months

I am trying to query data from an existing data extension into a new data extension and filter out the subscribers that were added within the last six months. The existing data extension does not have ...
0
votes
1answer
55 views

Automation Studio with Journey

I tried to create an Automation Studio with a journey and when I placed an audience the option did not work out anymore. Can someone please tell me how it is done now? How can I create a journey and ...
0
votes
1answer
40 views

Workaround: Report (CSV) -> SFTP -> Data Extension

I created a 'discover' report that my goal is send this data to a Data Extension. I tried to create an automation that the report goes to ftp like csv and after report run, this automation get the ...
1
vote
1answer
43 views

Send a Second email to subscribers that didnt open 1st email sent via automation studio

I need to create an automation to: 1- Send and Email (from a created email template) to subscribers and informations from a Data Extension DocCobranca. 2- After 2 days has passed I need to make a ...