Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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
0answers
23 views

Marketing Cloud: Convert STRING to INTEGER(NUMBER) using SQL

We would like to do a SQL query on a master data extension from which there is a data column which was set as "Text" instead of "Number". We would like to make a conversion into the target DE from ...
1
vote
1answer
23 views

Emails sent via Automation not in Individual email results [duplicate]

I'm new to Marketing Cloud. I started with Journey Builder and now moving to Automation Studio. Emails sent through a journey are synced with Contacts in Sales Cloud in the Individual Email Result ...
1
vote
1answer
25 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 ...
0
votes
1answer
31 views

Is there a way to Retrieve the ID of an Automation Instance via API?

As far as I know the only way to link directly to a specific automation is with the Automation Instance ID (ex. https://mc.exacttarget.com/AutomationStudioFuel3/?hub=1#Instance/...
0
votes
1answer
36 views

Getting sent data for a specific time frame using Query

I am trying to pull send data from some scheduled sends. I am using below query: SELECT s.SubscriberKey as Email_Address, s.EventDate as SendTime, s.JobID as JobID, d.VER as VER, d.CellMarket as ...
0
votes
1answer
41 views

Multiple SELECT in subquery

In Marketing Cloud, we would like to check for the existence of records from one table in multiple other tables based on the unique identifier - Customer_ID. However, I'm not sure whether I can ...
2
votes
1answer
42 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 ...
0
votes
1answer
29 views

Automated way to set SEND VOLUME by day?

We have a list of 100K subscribers and we want to send a maximum number of emails per day - but the max volume changes by specific day. For example we want to send more emails Tuesday through ...
0
votes
1answer
27 views

Import Definition - File not found (automation studio)

I want to import a csv file by using the automation studio. the csv looks like that: WERBEKO-2019_10_15 Starting source: File drop (use filename Pattern "Begins with" - "WERBEKO-" Import Definition: ...
0
votes
1answer
29 views

Monitoring Daily Run automation / Notification if the Automation is not run

I have a file drop automation which runs everyday around 10:00am. In the background an ETL process runs where it gets the file from another system and process to FTP. Sometimes If the file is received ...
1
vote
1answer
39 views

Update All Subscribers Profile Attribute

I want to update an 'all subscribers' custom attribute in the parent bu to match what is in my sending DE in my child unit. Currently i have a custom attribute in 'all subscribers' called '...
0
votes
3answers
59 views

Query did not opens in the past 180 days

I have the following query to find all subscribers that have not opened in the past 180 days: Target Data extension has: SUBSCRIBER RELATIONSHIP ContactKey relates to Subscribers on Subscriber Key ...
1
vote
0answers
31 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
35 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
1answer
112 views

Replace semi-colon not allowed in SQL - alternatives?

Looking for solutions to my Replace() issue outlined here, I thought an alternative might be a replace within SQL when moving data to the deployment data extension. However, I've discovered that we ...
0
votes
1answer
69 views

Converting date/time to string in Marketing Cloud's SQL - string to date conversion error

We are trying to convert a string field to a date field using the CAST function in Marketing Cloud. Our goal is to use the newly converted date records to segment our subscribers based on the date of ...
0
votes
1answer
22 views

Connect to a database of an X system to get information for my journey

I have a question. If I wanted to connect to a database of an X system to get information for my journey. Is it necessary to create a webservices or is it only configuration through automation studio ...
0
votes
0answers
19 views

Validating File Date on Data Import Activity

We use an automation activity to import a file from an FTP location to a Marketing Cloud data extension. The activity uses wildcards to pull in a file with the most recent date. Question: is there a ...
1
vote
1answer
46 views

Call an automation from Journey Builder? [closed]

I was wondering if there is a way to call an automation from the Journey Builder. I'm new to Marketing Cloud and need some help here. Thanks !
1
vote
1answer
46 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 ...
3
votes
1answer
54 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
0answers
21 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?
0
votes
1answer
18 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 ...
1
vote
1answer
44 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
28 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
51 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 ...
1
vote
1answer
33 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
60 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 (...
-3
votes
1answer
43 views

How to create a Sendlog functionality using in AMPScript [closed]

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
22 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
22 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
30 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
1answer
33 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
0answers
59 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
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
41 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
0answers
60 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 ...
2
votes
2answers
99 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
50 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
1answer
27 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 ...
1
vote
1answer
40 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): ...
0
votes
2answers
35 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 ...
2
votes
1answer
54 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 ...
-4
votes
3answers
93 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 ...
-1
votes
1answer
66 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 ...
0
votes
1answer
47 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
82 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
42 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 ...
0
votes
1answer
47 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
46 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 ...