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
0answers
11 views

Couldnt find data extract in automation studio activities [duplicate]

I was trying to extract data extention from marketing cloud but I couldnt find the data extract activity in the automation studio. Should it be opened by creating a support ticket or is there a way to ...
-4
votes
1answer
33 views

Decision Split Activity [closed]

Using decision split, how can I compare the product numbers dynamically inorder to send out an email to the customer. Let's take a use case: when Customer-1 bought a product in online and when the ...
-2
votes
0answers
34 views

Marketing Cloud Automation [closed]

I have a use case which needs send an email from marketing cloud and please help me with your ideas. Use Case: In Salesforce, I have a list of records on product object and contact has a lookup ...
0
votes
1answer
33 views

Get Send Job's name in Tracking Extracts file

We receive the JobID value in the SendJobs.csv file in our tracking extracts (generated using a Data Extract activity in Automation Studio). But is it possible to get the name of the Send (not Email) ...
1
vote
1answer
38 views

Getting duplicates from a data extension

We would need to extract duplicate values from our Marketing Cloud data extension and deliver them to our data team for review. The DE has about 34k contacts and only 3 fields: Account_ID, ...
0
votes
0answers
18 views

Journey Builder powered by Automation: Create lead in SFDC doesn't work

I have a Cloud page capturing Lead information from my website. On an hourly automation, I collect the latest enquiries (in the entry DE of Journey) and I create a LEAD in Salesforce, based on Journey ...
0
votes
1answer
44 views

Unzip file activity doesn't create any files but no errors found

I have created a Tracking Extract which generates a .zip file (annoyingly, despite having only one export type) which I am trying to extract and move into my Import folder to put into a Data Extension....
0
votes
1answer
56 views

How to select only the characters appearing before a specific symbol in a SQL Select statement

I have strings in a database like this: firstname.lastname@domain.com And I only need the characters that appear before the @ symbol. I am trying to find a simple way to do this in SQL.
0
votes
1answer
30 views

Getting all sends, and (unique) opens and clicks into one Data Extension

We would like to get the sends, (unique) opens and (unique) clicks from last 24 hours in the same data extension. I started with 2 LEFT JOINS, with the goal of getting all sends, and opens and clicks ...
1
vote
1answer
30 views

How to conditionally delay a scheduled automation run in Automation Studio

I have an automation process which is scheduled to run on the first Monday of every month. This automation has a "Journey Builder Trigger" activity for injecting contacts to a journey. I need to ...
0
votes
1answer
41 views

SSJS script to update query and start automation with 3 minute wait in between each loop iteration

I have a script that have nested loops that loop through some arrays. In those loops, I have a something that updates a SQL Query Activity, then something to start an automation. What I am trying to ...
0
votes
2answers
34 views

Import Automation - 'File Not Found' error

I am doing a file import activity into a DE with file drop trigger. While building the import activity, the file naming pattern determines this pattern FILENAME_%%Month%%%%Day%%%%year%%.csv ...
1
vote
1answer
45 views

How to Prevent Automation from Skipping

I have an file drop automation set up to import files dropped in a specific folder on the FTP. These files are very large and take a while to import so I have enabled queuing on the automation. The ...
-1
votes
2answers
36 views

Delay in Journey Email Send outs by 1 day [closed]

There are three journeys running in the SFMC org, one is with date based event as entry source for birthday and other two are with same date based event as entry sources. All the journeys are ...
0
votes
1answer
59 views

Query to find out contacts in DataExtensions who have clicked or opened Emails

Consider a scenario where all contacts from DataExtension receives an Email. I want a query to retrieve all contacts who opens the Email.
0
votes
1answer
43 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
37 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
12 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
50 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
52 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
50 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
44 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
72 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
38 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
63 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
48 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
32 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
95 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
41 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
61 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
31 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
93 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
59 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
65 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
47 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
33 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
45 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
45 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
38 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
47 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
81 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
58 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
41 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
37 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/...