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

Parsing Array JSON response using SSJS activity in the automation. not giving any output- Parsing array inside the array [closed]

<script runat=server> Platform.Load("Core","1.1.1"); try{ var newpay = Stringify({"failedRecords":[ { "customerId":"qXTjiIDaG", "productCode":"1", "journeyName":"1", ...
0
votes
1answer
48 views

Stop duplicate emails with different subscriber keys from entering a journey at different intervals

I have a journey that is triggered by an automation that runs hourly. At the moment, I have the issue that issue where a contact has the same email address but different subscriber key. As a result ...
1
vote
0answers
13 views

One automation with 2 SQLs triggering 2 separate journeys [closed]

We want to design an automation in Automation Studio that would comprise 2 SQLs. Both queries will populate data into separate data extensions, which we would like to use in 2 separate journeys as ...
1
vote
1answer
65 views

Journey Builder is not pulling the correct data from data extension

I have a journey which is not pulling data from our data extension correctly. The data in the data extension is correct but the email that has been sent out has a previous value. I update the data ...
1
vote
1answer
85 views

Updating Notification Email Address in Automation

I have around 100 automations in my business unit. I want to update the error notification email address to my email address for all of them. Is there a way to do it through API or ssjs?
0
votes
2answers
144 views

MC REST API for starting Automation

I am looking for REST API to start Automation. I see following endpoint with POST it helps to create Automation. Is there any REST endpoint to start Automation? I do see there are SOAP API available ...
1
vote
0answers
49 views

Setting a Scheduled Automation to Active with REST API

I can activate scheduled automations through soap but only if their schedule is not already configured. Does anyone know how to activate a scheduled automation through REST API? I think the "isActive" ...
0
votes
3answers
97 views

Marketing cloud SQL Query Deduplication

I am trying to deduplicate my entry data extension based on the completeness of field values. For Instance, i have the a data extension with same email address, the record that has maximum field ...
0
votes
1answer
56 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 ...
1
vote
2answers
107 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
151 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
45 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
396 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
100 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
39 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
67 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
55 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
32 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
117 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
107 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
83 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
39 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
15 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
55 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
75 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
125 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
57 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
82 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
36 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
78 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
104 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
197 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
63 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
40 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
55 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
40 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
64 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
109 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
35 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
111 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
66 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
60 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
89 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
182 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
53 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
200 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
821 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
48 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
24 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
156 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 2
3
4 5
11