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

Old style JOIN (ANSI JOINs) syntax is not allowed. Split DATE

I'm using a simple SQL query to get DAY, MONTH, YEAR out of a Date field (BIRTH_DATE) in Automation Studio (of marketing cloud). SELECT CUST_CODE , EXCLUDED_FROM_NPS , BIRTH_DATE , DATEPART(DD,...
1
vote
1answer
257 views

How to Batch update Salesforce Sales Cloud from Marketing Cloud using SSJS?

We have to perform a batch update in Salesforce CRM custom object based on changes within Salesforce Marketing Cloud Data Extension. How can we do this using SSJS? Although Journey Builder can ...
3
votes
1answer
160 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 ...
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
1answer
34 views

Automation studio to select certain DE's

I have my target data extension for my journey, however,the data extension which will inject data into it will change every day. For example, my DE name will be 123456_EM_1 on the Monday, on the ...
0
votes
1answer
659 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
0answers
212 views

How to execute a query activity once contacts enter the journey

I have a Journey which Salesforce contacts as entry point. Once they enter the journey i have a 1 hr wait time. Before sending an email i need to run the query activity as i am getting some signature ...
-2
votes
1answer
404 views

Marketing Cloud Email Openers and Non Email openers

I want to create a 2 new list from existing data extension of the people who has opened the email and not opened the emails of the journey email which I have sent recently. Can you please help. ...
0
votes
1answer
604 views

Which is first? Activate Journey or Activate Automation

What's the proper order of operations on Activating a journey that injects contacts right away? I have an automation audience that I can set to a daily interval. Do I activate the journey and delay ...
1
vote
1answer
283 views

Moving True and False values in DE stored as text into Boolean

I am trying to run a query that looks like this: SELECT Email_Address As emailAddress, Firstname As firstName, OptIn_Education As optInEdu, OptIn_Commercial As optInCom FROM [Old_DE] The problem I ...
1
vote
1answer
352 views

Time / Date constraints in Journey Builder

I am trying to set up some automated journeys in JB and would like them to only send on specific days and within specific timeframes. E.g. After a lead is submitted, send an email after 5(ish) days, ...
1
vote
1answer
507 views

Update to “undeliverable” status from subscribers

I was facing the issue of importing a list to "All Subscribers" with the status Undeliverable. The problem is that the keyword "Undeliverable" do not exist in order to update the subscriber status. I'...
0
votes
1answer
346 views

JourneyBuilder Audience Rejection: Failed - ContactPreviouslyInSameInteraction

I have an audience that was completely rejected in the activation stage. Brand new Journey with a no reentry clause. I have a support ticket in, but I'm wondering why this static audience would get ...
0
votes
1answer
48 views

Daily send to Hourly Send

I have a new user welcome journey occurring on a daily basis which was originally built because our ETL process was handled nightly. We've now changed that to an hourly ETL process so that I can ...
0
votes
1answer
94 views

How to send emails quickly after an open occurs

I am trying to use Marketing Cloud to solve for the specific need of sending an email quickly after an open occurs. This is part of an overall, wait-based campaign that sends certain messaging days ...
1
vote
0answers
73 views

Automation Trigger Options

We currently trigger automations via a file drop to a FTP Location. This works well as the file drops, processes and waits until 9am before it sends the mail. Sometimes are file drops are late and ...
0
votes
1answer
273 views

Marketing Cloud - Wait Activity - Automation Studio

I have created an Automation and Journey Builder Customer Journey. What I want to happen is 3 days before a Due Date I would like to send a reminder to the customer. Daily at 7:55 Automation Studio ...
2
votes
1answer
83 views

Two vastly different counts using queries found here… what's the difference?

As a SQL neophyte, I know enough to be dangerous. I have two queries, both found here... the first is the one I'm directed to to answer "who hasn't opened an email in xx days". SELECT s....
1
vote
1answer
677 views

Errors: Incorrect syntax near 'LIMIT'

I am trying to query only 10 records and using LIMIT in query, but it is giving me the following error : An error occurred while checking the query syntax. Errors: Incorrect syntax near 'LIMIT'. ...
0
votes
2answers
299 views

Populate data extension of subscribers who completed a journey in ExactTarget

Is there a way to query whether a subscriber has completed a certain journey and populate that subscriber information in a Data Extension in Marketing Cloud? Or any other way to retrieve this data??
0
votes
2answers
468 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 ...
0
votes
1answer
467 views

SQL: How to to SUM two values from different tables

I want to find SUM of Table 1 & Table 2 in Result Table. As shown in the above Result table. I have tried with the query below Select Sum(t2.[Lead Score] + t1.[Lead Score]) [Lead Score], t2....
2
votes
0answers
346 views

Automation generates yesterday's data and file name when run early morning (fine under other hours)

We have an automation to export the people in a Data Extension with the LastDeliveryDate value equal to 21 days ago. The file will end up on an SFTP server that is not Salesforce's own Enhanced server....
2
votes
0answers
469 views

How Do I Properly Offset GETDATE() in Marketing Cloud Query Activities for US Eastern Time Year-Round?

I want to use a Query Activity within Automation Studio to find all of our app's users who last logged in between 24 and 25 hours ago. When I run the below query into a data extension, I instead get ...
1
vote
1answer
368 views

ExactTarget Automation Monitoring

I had a question about how folks monitor their automations' successes and failures. We currently have a very manual process that I'm hoping to automate (no pun intended). Currently we: Receive ...
0
votes
1answer
479 views

Emailing a file from Enhanced FTP using Automation Studio

I have an automation in place that exports data from a data extension and then uploads the file to our FTP account. Is there was a process within Automation Studio to have that file emailed as an ...
0
votes
1answer
259 views

How to send reminder emails using journey builder?

I have 3 tables namely Customer, cust_activity, meetings and I have already sent emails to Customers regarding meetings happening in their city.(using journey builder). Now i want to send reminder ...
2
votes
1answer
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 ...
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
2k views

Data Extract of data extension to Enhanced FTP

I am trying to extract Contact Keys from a data extension so that I can load them back into the system to unsubscribe them. I am gathering these contact keys from multiple SQL Queries to different ...
1
vote
1answer
718 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 ...
0
votes
1answer
70 views

Some query help - SQL passes validation but returns no records

Admittedly, I'm not an expert in SQL. Below is code I wrote to pull all clicks for a specific subscriber and nothing is coming back. I tried adding a date criteria to limit the search to 6 months, ...
0
votes
2answers
637 views

Filtering out entries from one data extension to another

Currently I have a subscription form that is sending all new subscriptions to one data extension. One of the options they select on the subscription form is "Customer Type." I have four different ...
1
vote
1answer
675 views

Trying to find out a record that does not exists in a data extension by query

So, I total 4 data extensions. I have records in 3 data extension and I want to save result in data extension# 4. Here is a sample of how my data extensions looks like: Desired result: CustID is ...
0
votes
1answer
819 views

Marketing Cloud query activity syntax error

I've recently tried to create a query activity. Our Marketing Cloud is connected to our Salesforce via Marketing Cloud Connector, and we are syncing contact data. I'm trying to flag our contacts who ...
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 ...
2
votes
2answers
116 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 ...
1
vote
1answer
1k views

How to refresh a filter data extension using automation?

I want to refresh a filtered data extension everyday, I have a main data extension "abc" and a filtered data extension named "worldwide" which is filtered from "abc" What I have already done is, ...
1
vote
1answer
2k views

What is Interaction Studio [duplicate]

Iam about to configure roles and permissions now i saw a fuction called "INTERACTION STUDIO" what is the so called "Interaction Studio" I never heard of it before! Could you kindly explain? Thank ...
0
votes
1answer
141 views

SFMC Query Activity Update records

I have a query that uses an inner join. The query will ultimately be used in an automation for a journey (to add new subscribers in daily, as they meet criteria). The query works when I do a data '...
0
votes
1answer
5k views

Using Automation Studio to Export a Data Extension

I am working with a client to try to create an automated subscriber list export process. Is there a way use Exact Target's Automation Studio to export data from a Data Extension to either FTP or sent ...
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 ...
0
votes
1answer
140 views

Dropping heavy file and File drop trigger using automation Studio

My question will, let's assume I have 20 GB file to be dropped in SFTP which usually takes 5 min to upload, Since we are using File drop/ trigger which listen to the file being dropped, how does SFMC ...
0
votes
1answer
497 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 ...
0
votes
2answers
118 views

Query Question to retrieve sub folders / subset lists

Is there a query activity to query Publication Lists to find out what the subfolders are and the lists they contain? If I do this: SELECT DISTINCT (ls.ListName) AS 'ListName' , ls.ListID as 'ListID' ...
3
votes
1answer
354 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 ...
1
vote
1answer
444 views

System error when running a query with unions to join multiple data extensions

I am trying to pull the data from multiple data extensions to another DE and i am using union to achieve it.Also I have subscriber key as a primary key in the target data extension.However i get ...
1
vote
1answer
518 views

Extract mobile connect list of unsubscribes

I have tried to find information about how to automate the export of MobileConnect status for unsubscribes with stop-code. I've found this official documentation about querying data views as ...
0
votes
1answer
591 views

Custom Personalization Strings in Content Builder

I am trying to add the ability to the marketing team to have custom personalization strings in Content Builder. I managed to create them but I have an issue to fill the Email Demographics table with ...
1
vote
2answers
503 views

Export all subscribers file content is in hexadecimal, I need it to be readable text

I have an automation to export all subscribers to fetch the "status" column. My shceduled automation extracts the all subscribers list and then drops the file on the dedicated FTP with correct name ...