Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [automationstudio]

The tag has no usage guidance.

0
votes
0answers
15 views

Creating auto-refreshing filtered data extensions through the SFMC APIs

Given a folder of filters, is it feasible to create filtered data extensions and for each filter, and an automation that automatically refreshes them through the APIs? This old thread seems to imply ...
0
votes
1answer
24 views

Marketing Cloud - SQl logic

I am writing a bunch of queries to update All Subscribers list, and was surprised to see that when I put the condition xxx != yyy it only works if there are values in both columns. I was hoping that ...
0
votes
2answers
33 views

Adding filter to INNER JOIN with 3 tables

I would like to perform a SQL in Marketing Cloud on 3 data extensions, but for each join I would like to create a filter (a WHERE). I'm worried about the positioning because the WHERE clause would ...
0
votes
0answers
30 views

Time Zone issue in automation [closed]

When I run automation in IST I got the data in DE but when our client (GMT+10 Syndney) runs the automation they don’t get data in DE I know it’s around 4.30 hr difference but if it’s on same day that ...
1
vote
1answer
42 views

Pulling Data from _Subscribers at BU level with SQL Query

I have a 2 Business Units setup, with a parent BU. Data is not meant to be shared between the 2. The purpose: I want to understand how to differentiate Subscribers from different BUs as they are not ...
2
votes
1answer
41 views

Delete Subscriber records in Salesforce Marketing Cloud

We want to delete all subscriber records from "All Subscribers" which are not "Unsubscribed" or "Bounced" and created before last six months. How can we do it using automation studio?
1
vote
1answer
37 views

Query failed during execution | Error: Violation of PRIMARY KEY constraint

I have SQL Activy below and some days ago happens the errored: Query failed during execution. Error: Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'Clientes_RDB'. The ...
1
vote
0answers
36 views

How do I order rows in columns using AutomationStudio SQL

I am performing a SQL query in Automation Studio and I want the following: Populate a data extension with ID of the Account_salesforce table with the ListName (Lists) bound to the ID of the first ...
1
vote
1answer
41 views

One-to-many in SQL joins

we would like to join 2 data extensions in Marketing Cloud based on the 1-to-many relationship. To make it simple, among other attributes, the first DE contains the FederationID, as PrimaryKey, and ...
1
vote
1answer
48 views

Trying To Setup An Auto Loan ReCapture Program

We are trying to create an auto loan recapture program. The program goal is to target Members, who are close to paying off their current auto loan with us (within let's say 2-3 months), to open ...
1
vote
2answers
46 views

Marketing Cloud SQL not executing

In Marketing Cloud's Automation Studio, we keep getting an error for SQL we wrote that is supposed to combine the data from 2 separate SHARED data extensions in a child Business Unit. The error ...
1
vote
1answer
22 views

How can I relate a Journey Exit to an Email Send in Automation Studio (Marketing Cloud)?

When a subscriber exits a personalized Journey, I would like to send an Email to a Data Extension containing several people. How can I achieve this? Is it possible to relate a Journey Exit to an ...
0
votes
1answer
22 views

Importing data with primary key duplicates

We have a file that's dropped on the FTP regularly to update our master database, which has FEDId as its primary key. On rare occasions, the receiving file can contain a few records with identical ...
1
vote
1answer
43 views

Automation SQL or Filter Activities with MCC Synchronized Data Extension

Sales cloud and Marketing cloud are integrated using MCC. Entities have been setup under Data Sources and sendable Data Extensions are populated. In addition, the Salesforce entities are in an ...
1
vote
1answer
32 views

Automated Email Campaign with filtered data

In my current environment, we have multiple automated email campaigns setup in this way. For one such campaign, there is a designated source DE which will be only be growing on demand which contains ...
4
votes
1answer
73 views

Create or update Automation with Marketing Cloud REST API new endpoint

there is an endpoint to retrieve automation using Rest API with OAuth2 token and GET method: https://{{tenant}}.rest.marketingcloudapis.com/automation/v1/automations/{{id}} In the response you will ...
1
vote
0answers
17 views

How to add a Send Email Activity to an Automation with FuelSDK-Python?

I unable to associate an Email Send Activity when creating an automation in Fuel-SDK Python. Below is my props dictionary setup. When posted the Automation is created but there is no Send Email ...
1
vote
1answer
46 views

How to perform data extract hourly for current day

When configuring a Data Extract Activity in Automation Studio there are two date options available : Rolling Date Range This option allows you to choose a 1 Day rolling range at it's most specific, ...
1
vote
1answer
27 views

in exact target can we retrieve contacts in business unit, the contacts being from Europe only?

I need to retrieve contacts who are from Europe I have looked into all standard reports and contact reports is there automation to run which gives only contact email ids with the email ending in ....
1
vote
1answer
38 views

How to update a field in a DE using sql?

I have a DE where i have 3 fields(cost price , selling price and on sale).If the selling price>cost price...then on sale field should be updated as "True"(on sale is boolean field.).What is the query ...
1
vote
0answers
28 views

Email Send Activity in Automation Studio is not able to send Emails to duplicate Subscribers

We are trying to implement an event notification system in SFMC. When a subscriber subscribes for an event he is getting a confirmation email. 3 days prior to the event I need to send a Reminder email ...
1
vote
1answer
27 views

Load Data from Synchronized data extension to data extensions by SQL Query

I am trying to get Synchronized data extensions data to Data extensions in salesforce marketing cloud, I need a custom field from campaigns Synchronized data extensions. I made a query as select Id, ...
1
vote
1answer
44 views

Using SQL to compare and update data extension

I need to use SQL in an automation to compare the data from the "TemporaryDE" with the Data from the "CompareDe". If the CompanyName value from the "TemporaryDE" is not present in the "CompareDe" - to ...
4
votes
1answer
37 views

Will a Suppression List increase send time?

Background: I have a daily batch process that creates a sendable Data Extension from a query on a Synchronized Data Extension. The automation runs a query that overwrites the sendable Data Extension ...
2
votes
1answer
64 views

Automation skipped

I just create two automation to build a loop process in which I don't have to wait 1 hour as it has to be when the Automation is scheduled. Automation A: One script activity that calls the Automation ...
1
vote
1answer
42 views

Marketing cloud sql query execution error - Violation of PRIMARY KEY constraint

I'm getting following error during update activity. Query failed during execution. Error: Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'Enq_opp_Parallel_ContactView'. The ...
0
votes
1answer
40 views

Retrieve all sends to a specific records in Marketing Cloud [closed]

How the query shall look like if we want to retrieve all emails a specific contact received?
3
votes
1answer
37 views

Query association to automation viewable?

Is it possible to see which automation a query activity is part of?
1
vote
1answer
33 views

How to access Report FTP Folder in Automation Studio?

I saved a Account Send Summary report from "Analytics Builder" > "Reports" to FTP using the option "FTP Result". I can only choose the option "ExactTarget Enhanced FTP". How I am supposed now to ...
3
votes
0answers
62 views

Update Marketing Cloud Automation tasks with SOAP API returns “OK” response but doens't update

I'm trying to update the AutomationTasks of an automation in Marketing Cloud with the SOAP API. The docs don't indicate whether this is possible (the example SOAP envelope for updating an automation ...
3
votes
2answers
54 views

Remove characters after @ in email address and replace with new domain

I have four brands that all use different email domains however our SF only has one email allocated per user with a random branded domain. eg usera@brand-a.com also uses @brand-b.com, @brand-c.com and ...
1
vote
1answer
33 views

Error on completion of Data Extract and File Transfer

I'm currently experiencing an error on the Automation Studio with related to the Data Extract - One of the activity get failed by "Error has occurred" and File Transfer - one of the activity flagged "...
0
votes
1answer
29 views

How to perform lead conversion activity based on the email click in marketing cloud?

I want to send an email to my leads with a clickable button with unique url. I want to put a trigger base activity which converts lead into opportunity as soon as user clicks on that button. I know ...
0
votes
1answer
76 views

Verification to skip an activity in Automation Studio

I have an automation with several activities across 7 steps. This automation is used to update subscriber statuses in our publication lists. We use a vendor for enterprise preferences which syncs with ...
2
votes
1answer
53 views

Saving Server Side JavaScript Functions

Is it possible to create SSJS functions as code resources in Web Studio and then use those functions in other CloudPages or Script Activities? For example, if I created a function that generates an ...
-1
votes
1answer
44 views

Creating an email which populates an image based on Data Extension upload

I'm trying to send a survey to recipients with an image in the email. Ideally I could upload a list to Data extensions that would populate an image and some text. Each row would have an ID that would ...
1
vote
0answers
66 views

Insert a delay of a few seconds in SSJS script after a function call

Use case: Send emails based on personlization data of a few records using SSJS script. I have an email that will pull personlization data of off a non sendable Data Extension. The email will pull the ...
0
votes
1answer
87 views

SystemDateToLocalDate inside SQL Automation

I know the function SystemDateToLocalDate is not available inside SQL but i would like exactly that feature inside an SQL query to convert the Date records of data_views (which are CST Central ...
0
votes
0answers
26 views

Export list of Automations from Automation Studio

Is it possible to export a data file containing all the Active Automations - as much detail as possible. We're actually migrating away from SF and I need to get an understanding of our existing ...
0
votes
1answer
69 views

Do automations have a time limit where they crash?

I am uncertain if this question was asked somewhere but atleast I did not find a post that covers it within a few minutes of searching on documentation and stackexchange. Closest question I found Do ...
0
votes
1answer
18 views

Automation Studio create activities via REST API

I need to create and save an activities with REST API in Automation Studio. How can I do it? many thanks
0
votes
1answer
49 views

Automation Studio: create a new automation from PHP

I'm very new about Salesforce and Marketing Cloud. I've seen it's possible to use two sets APIs (REST and SOAP) to interact with it. In the official MC documentation Web Services SOAP API are used to ...
0
votes
1answer
53 views

Is it possible to trigger a file drop automation with a file transfer activity?

I have a file drop automation in place that enables me to remove a contact record and all other records that are related to that contact from my data model in Contact Builder. The import file for this ...
0
votes
1answer
92 views

Script Activity error in Automation Studio

I'm trying to run a Script Activity to update specific fields of a Lead in Salesforce (Marketing Cloud connector is already configured and working properly). Once I click on 'Validate Syntax' it ...
2
votes
3answers
50 views

Optimize a query that is timing out

I have two data extensions that I need to join and filter. One stores member data for a product, the other stores opt-in status for all products. The DE with opt-in status can have multiple instances ...
0
votes
1answer
39 views

Remove Special Characters SQL

I am currently trying to run an SQL qeuery that strips out special characters and then adds a '1' in front to have all numbers correctly formatted. For what ever reason my REPLACE doesn't seem to work ...
1
vote
2answers
86 views

SFMC Automation Studio to download CSV into FTP

How can I use SFMC automation studio to download a csv from a site into the import ftp folder and import that csv into a data extension? Do I need to use SJSS? Or is there an activity that does that ...
1
vote
1answer
39 views

SQL Won't Populate Salesforce Data Extension

I am trying to dump data from a Salesforce object into a Salesforce Data Extension. I am not getting an errors but the data refuses to populate. I can't figure out what I am doing wrong! I have tried ...
1
vote
1answer
51 views

What is the correct syntax for using “Begins With” when setting a Filename Pattern in an import automation?

I am new to Salesforce and I am trying to setup an import automation. I am having trouble figuring out the correct syntax when using the "Begins with" option in the filename pattern. The docs say you ...
1
vote
1answer
102 views

Can I move files between Marketing Cloud FTP SUB-folders?

Our usecase: after import we want to move a file (using automation) from one (enhanced)FTP sub-folder to another(enhanced)FTP sub-folder (archive). The sub-folders are both in the main folder \import. ...