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

Is there a System View for Mobile Connect Contacts / Subscribers?

For Email All Subscribers, we have _Subscribers data view and I am looking for similar data view for All Mobile Connect Contacts. Basically, i would like to access all mobile numbers with their ...
0
votes
0answers
170 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
250 views

Creating new Portfolio object through SSJS but the status shows error

I am trying to create a portfolio object in the scrip activity using SSJS portfolio add function.I am following this link for creating portfolio but the status shows error. var newPortfolio = { ...
1
vote
1answer
251 views

Use a Not in for insert in Marketing Cloud Sql Query

I need to add only unique rows to a data extension even though the same row in source data extension might keep being pulled. In Automation studio if the same primary key is pulled it errors the ...
1
vote
1answer
555 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?
0
votes
1answer
102 views

Create new contact in Salesforce CRM from Salesforce Marketing Cloud Data Extension

I have a situation need to create new contacts in Salesforce CRM from Salesforce Marketing Cloud Data Extension. The Data Extension is getting updated every 24 hours from an external system. ...
0
votes
2answers
143 views

Drip campaign help in automation studio

I have already set up a campaign in automation studio exacttarget where data is pulled form the SFTP and filtered into the language category and a welcome email is sent to the customers who are ...
1
vote
2answers
771 views

Automation Activity Fail - Auto Start Again?

If any activity fails in automation studio, is there a way to automatically retry failed activity again after certain time, or retry again if fails?
0
votes
1answer
217 views

Daily Reminder - Journey Builder or Automation Studio

I have a daily email that will be going out (it has some dynamic fields on it - thanks again to those that helped). The email will go out as a daily reminder for them to visit a landing page to re-...
1
vote
1answer
308 views

How to access fields from entry DE in Journey Builder via AMPscript?

I want to send a push message via MobilePush from inside a customer journey. The content of the push message should personalised with AMPscript, based on the entry audience of the journey, which is a ...
1
vote
2answers
830 views

Journey Builder vs Automation Builder studio

Need some direction on the best way to approach this use case in SFMC: Sweepstakes campaign that runs for 60 days. Once someone enters they receive a confirmation of entry. That's the easy part. ...
0
votes
1answer
575 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
305 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
207 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
794 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
229 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 ...
-1
votes
1answer
540 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
743 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
333 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
421 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
605 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
388 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
51 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
105 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
75 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
324 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
84 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
854 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
315 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??
1
vote
2answers
528 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
569 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
414 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
574 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
459 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
617 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
330 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 ...
4
votes
2answers
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 ...
0
votes
1answer
72 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
708 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
822 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
1k 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
129 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
148 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 '...