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

Populating Data Extension with tracking aliases

I have a welcome journey in which the subscriber at a point chooses which room needs a redesign. The links for these 3 rooms have tracking aliases like this: Image_RoPLivingRoom CTA_RoPLivingRoom ...
0
votes
2answers
45 views

Schedule an Automation through the API without a Recurrence(“Repeat”) Value

Is this possible to do? Each time I schedule an automation through the API it only seems to work if I set a "Recurrence" value, although I only want the automation to run once. To get around this I'...
0
votes
2answers
43 views

DateDiff not working

I am using the datediff function and it doesn't seem to be working. What I am currently using DATEDIFF(year, creation_date__c, SYSDATETIMEOFFSET()) AS AnniversaryYears It just gives an empty ...
1
vote
1answer
28 views

How to Activate a File Drop Triggered Automation through the API

This question has been asked a few times over the years but has yet to receive an answer. I am trying to figure out how to activate a file drop triggered automation through the API(Changing it from "...
1
vote
2answers
68 views

Account Activity or Object Activity in Journey Builder has limits to update like Data Loader?

I have the Marketing Cloud Connector working fine and I have a little issue to start to use the Journey Builder to update the records in CRM. In first moment i want to udpate 1 million records to ...
1
vote
1answer
24 views

Inserting Into Data Extension From External Key In Another Data Extension With SSJS Not Working

I am attempting to insert data into a DE, which I create from the FuelSDK, using a Script Activity, I created as part of an Automation, in Automation Studio. The script runs, but no data is inserted ...
0
votes
1answer
26 views

During overwrite, Marketing Cloud picks first PK record instead of prompting PrimaryKey violation

We have a peculiar case where we are joining 3 different data extensions (i.e. Consent_DE, Address DE and Channels DE) via SQL in Automation Studio. We have Global_ID as unique customer identifier ...
0
votes
1answer
57 views

Convert Birthdate to Getdate

I am trying to send a message to everyone whose birthdate is in two weeks but the date is of a different format and the query thus returns 0 rows. The query I am currently using is the following ...
0
votes
1answer
48 views

Is it Possible to Add Email Addresses to the Notification Settings of an Automation via the API?

I am creating automations through the API and would like to add email addresses to the "Notification Settings" fields in the "Activity" tab. Is this possible to do through either SOAP or REST?
0
votes
1answer
30 views

How do define what data updates in a data extension when using “Update” query in Marketing Cloud

I have a data extension that is built by a SQL query. The automation runs daily to add/update data. Its appointment data so what im trying to understand is what defines if a field is updated or not? ...
1
vote
1answer
87 views

SFMC Query Timing Out

I have a query that's assigns engagement definition to subscribers based on their interaction with the email. The dataViewSubscribers DE contains 16million users. However, the query times out now ...
0
votes
1answer
52 views

Birthday Journey with Sql query in Automation

I have created a Journey with Automation for birthday. I have a data extension with birthday field, using which I have created an automation to include only the customer's having birthday's on the ...
2
votes
1answer
62 views

Add business days to a date - exclude saturday and sunday [closed]

I have a variable called "BILL_ISSUE_DATE" and I would like to add 3 business days to this date. I need the new date for a "Wait by Attribute" in the journey. So lets say BILL_ISSUE_DATE = November ...
0
votes
1answer
37 views

Updating records from the base DE in Marketing Cloud

We are doing a big SQL that combines data from 3 synced data extensions (objects from CRM) and 3 local data extensions in Marketing Cloud. The data lands in the target DE, that's OK. However, we need ...
0
votes
0answers
6 views

Connect unsubscribes from custom preference centre to all subscribers in marketing cloud?

How do we go about reflecting the subscriber status that is recorded within our sales cloud data from a custom preference centre to our all subscribers list in marketing cloud? I understand this can ...
0
votes
0answers
44 views

GROUP BY in Marketing Cloud to get aggregate opens

We have queried _Sent and _Open data views to get the openers / non-openers for the last 30 days. In the second step, we would like to inner join it with _Job data view to get emailname and emailid. ...
2
votes
1answer
29 views

How does Select Distinct work on a Primary Key in Marketing cloud's SQL?

How does Marketing Cloud's SQL in Automation Studio works when having a DISTINCT operator on a data extensions that has a Primary Key (in my case "Customer_Key")? Specifically, does it look for unique ...
0
votes
2answers
39 views

How to prevent a subscriber from entering multiple journeys at the same time in Journey Builder?

We have multiple journeys built using journey builder in our SFMC instance. We are trying to enforce a new business rule which should prevent the same subscriber from entering multiple journeys at the ...
0
votes
1answer
34 views

Filtering Opens and non-Opens in Data View SQL

We would like to get all opens data together with email sent/delivered data for the last 6 months. The goal is to separate openers from non-openers by filtering the resulting data extension. We are ...
1
vote
1answer
33 views

Marketing Coud: Always use CAST and CAST with date fields from Data Views?

When querying SF Marketing Cloud data views, specifically its date-type fields (e.g. EventDate), Salesforce support suggested we should always use SQL functions : CONVERT (e.g. varchar,EventDate, 20),...
1
vote
1answer
26 views

Bad data notification without stopping automation

I have an automation that imports a csv from an external SFTP and processes it by splitting and augmenting the data into 2 data extensions. There is a chance that some rows in the original csv might ...
0
votes
1answer
45 views

Delete records from a Data Extension created by Journey on the basis of date

I have a journey in which entry criteria is Salesforce Data. Whenever a contact enters into a journey, the journey puts its details into a DE(created by the journey itself). I want to write automation ...
0
votes
1answer
78 views

Is there a BASE64 Encoding Function using SQL in Automation Studio? [closed]

We'd like to BASE64 Encode our Email Addresses so we can send them to an external third-party (it's the third-party's requirement). We know how to do it using AMPscript, but not in SQL. Ultimately, ...
0
votes
0answers
46 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
35 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
28 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
36 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
37 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
44 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
49 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
32 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
36 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
42 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
41 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
63 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
43 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
41 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
129 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
176 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
45 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
21 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
60 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
96 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
62 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
26 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
22 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
48 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
33 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
55 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
40 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....