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

Same-day email-specific reporting

Default send reports allow a date window of the previous full day. I need to be able to automate a report that pulls the deliverability of an email shortly after it sends. Is this possible?
0
votes
1answer
656 views

SQL Incorrect syntax near ')'

I'm trying to write a SQL query in a marketing cloud automation studio activity SELECT * FROM [table 1] WHERE [field 1] IN ( 'a2F6F000002WUVmUAO', 'a2F6F000002WTqbUAG', '...
1
vote
1answer
274 views

Possible to query _ListSubscribers and _EnterpriseAttributes and not use All Subscribers?

I have an E2.0 account with parent/child MIDs and I'm trying to pull in a population for a Journey. When I combine _ListSubscribers with _EnterpriseAttribute and declare ListID = 'All Subs List ID" ...
0
votes
1answer
300 views

how to set the TimeZone

I am trying set the time zone in ScheduleRequest its not working but automation is scheduled timezone is not set its taking default time zone this is my code <soapenv:Envelope xmlns:soapenv="...
0
votes
1answer
84 views

Customer Journeys with varying cadence

With my current client, I find a lot of their journeys (in non-SFMC terminology - these can be built in Journey Builder or Automation Studio, or both) are focused around delivering a certain number of ...
0
votes
2answers
129 views

Create automation folder using soap api

How to create automation folder through soap api.i used below code for creating automation folder but i am getting error. how to achieve this requirement could you please give clear info about folder ...
2
votes
1answer
2k views

SQL Query in Marketing Cloud Today = date

I'm trying to query using a where clause such as this: WHERE Today = a specific date . This is what I have right now: DateAdd(day, 0, GetDate()) = '2018-02-12' (because it was 2/12 when I posted/...
0
votes
1answer
264 views

Add clicked link's alias to Data Extension

I've got an Automation populating a Data Extension with all clicks for an email send, but I need to append the alias for each link as well. Is there any way to achieve this? I can't see any way to ...
0
votes
1answer
52 views

Best way to pull real-time email data, but also allowing enough time for an email to gather tracking

I need advice on best way to pull daily tracking data from SFMC. I currently have a set of monthly queries that run on the 1st of every month and pull in tracking data to a data extension. This works ...
0
votes
1answer
603 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
97 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
178 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
136 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
361 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
78 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
125 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
545 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
188 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
244 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
677 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
320 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
215 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
142 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 ...
0
votes
2answers
1k 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
32 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
517 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
193 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
287 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
449 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
231 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
303 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
397 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
306 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
44 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
88 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
68 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
245 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
81 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
509 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
279 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
394 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
387 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
305 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
337 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 ...
0
votes
1answer
311 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
360 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
212 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
0answers
822 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 ...
0
votes
2answers
807 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
1k 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 ...