Questions tagged [automationstudio]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

How to Setup an File Drop Trigger for an Automation via the API?

I created an automation triggered by a file drop in SFMC using the API but the file drop section still needs to be configured. The closest thing to an answer I could find was this post in which ...
1
vote
0answers
26 views

Salesforce Marketing Cloud: How to restrict access to All Subscriber from Child BU

We have Production BU and UAT BU in our implementation,We want our developer not to access All Subscriber in UAT BU because of PII issue. I can control it with Custom role with deny access to All ...
0
votes
1answer
30 views

ExactTarget : sql query from _subscribers is not retriving any record

I have below SQL query in Automation: SELECT TOP(10) EmailAddress AS EmailAddress,DateUnsubscribed AS DateUnsubscribed, Status AS Status,SubscriberKey AS SubscriberKey,SubscriberID AS SubscriberID ...
0
votes
1answer
34 views

SQL Querying subscribers older than 6 months

I am trying to query data from an existing data extension into a new data extension and filter out the subscribers that were added within the last six months. The existing data extension does not have ...
1
vote
1answer
38 views

Send a Second email to subscribers that didnt open 1st email sent via automation studio

I need to create an automation to: 1- Send and Email (from a created email template) to subscribers and informations from a Data Extension DocCobranca. 2- After 2 days has passed I need to make a ...
1
vote
2answers
60 views

SQL Query for Inactive Users- Send Log DE Code

This question is in relation to a previous question I had asked. To summarize: I am trying to run a SQL Query in automation studio to evaluate contacts in a data extension who have not opened an ...
0
votes
1answer
31 views

Workaround: Report (CSV) -> SFTP -> Data Extension

I created a 'discover' report that my goal is send this data to a Data Extension. I tried to create an automation that the report goes to ftp like csv and after report run, this automation get the ...
0
votes
1answer
40 views

Help to Change the Language for SQL Activity - Getdate

I tried to do a simple sintax, but i have a problem with the language and "getdate" I'm Brazillian and have an automation that update a Data Extension (Primary Key is month) with a FTP integration ...
0
votes
1answer
35 views

Import to Data Extension even if the CSV file has no rows (and has only header)

An import step of my automation fails. I tried to imitate that import manually and I realized that Salesforce does not continue the import when the file is empty. In my case, my file contains only the ...
0
votes
2answers
37 views

How to create multiple DE's from an array using SSJS (via an Automation Studio Script Activity)

Is there a way to dynamically generate multiple DE's based on an array? Something that might look like below? And, something that generates a new variable name (see line 6 & 27 should be the same ...
0
votes
1answer
23 views

Automation Activity report

Does someone know if it is possible to extract or query the information displayed in the activity tab of the Automation (status, started date, completed date...)? I would like to retrieve that ...
0
votes
1answer
31 views

Tracking extract with device type

Is it possible to create a Tracking Extract activity in Automation studio that includes the type of device the recipient has Opened or Clicked on? Or should this be done via an SQL Query Activity? If ...
0
votes
1answer
19 views

Tracking Extracts not available under the Data Extracts activity

As the title explains, in Automation Studio, when I create a new Data Extract activity I do not see the option to set it to "Tracking Extract". According to the documentation, I should be able to see ...
0
votes
1answer
42 views

SQL to post + 30 days by Date/Time attribute

Goal is to find rows where the date is exactly 30 days from today. Source is a Salesforce Date/Time field from a Synchronised Data Extension and posted to a regular Data Extension to Date attribute. ...
0
votes
2answers
25 views

SSJS Activity of automation - Split String using javascript

I am trying to split string variable in ssjs script but my automation always turns into error below is my code to split the string: var str = '<CreatedDate>2018-10-24T04:31:00</CreatedDate&...
0
votes
1answer
85 views

filtering sent from unsent emails

I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row, if any exists. I ...
0
votes
0answers
10 views

Which of the many files with the same naming pattern will be read into the Data Extension in an Import File activity?

I am using an Import File Activity to read data into one of my Data Extension. Every day a new file will be dropped into the FTP folder with the following pattern: Customers_%%Year%%%%Month%%%%Day%%....
0
votes
1answer
26 views

Marketing Cloud_ImportFile Activity error

We're trying to import a csv fial in a file-drop-to-our-FTP scenario and subsequent import file activity. We're keep getting this error sent by Marketing Cloud upon executing the automation: Results: ...
1
vote
1answer
52 views

Workaround to start an Automation from a Journey?

I have a requirement that has to do with adding/deleting subscribers from Auto-suppression list based on a Sales Cloud checkbox. Unfortunately I cannot make any development in Sales Cloud, it all has ...
0
votes
1answer
93 views

How can i know total number of sends from each BU

My goal is create a Data Extension in the Parent BU with a column for my 5 BUs where the record will populate by the total number of sent last 30 days from each BU i have. I utilize only a sender ...
0
votes
0answers
25 views

Unable to add data to Data Extension using Automation script Activity

I am trying add data that come from response of SOAP API to get data from list in data extension If response contains 2500 records then I am using for loop to add this data one by one in data ...
0
votes
1answer
22 views

How Can I retrieve SFMC Automation ObjectID using SOAP API

I am trying to fetch the ObjectID of an Automation created in Salesforce Marketing Cloud using SOAP API call. So that I can use that in starting the automation using API Call from a third party system....
0
votes
1answer
56 views

Salesforce MC - How to data extract in UTF8 to FTP

I'm having problems trying to export a data extension from Salesforce Marketing Cloud to FTP. I created an Automation to extract this file, but I want to extract in UTF-8, my database only import ...
0
votes
1answer
59 views

SQL Join Within Same Data Extension, Surveys

I made a survey in the Sales Cloud that I am pulling into the Marketing Cloud using automation studio and the responses are saved in a data extension. However every question response appears as a ...
0
votes
1answer
15 views

Getting remaining contacts after SQL JOIN in Marketing Cloud

I have 2 data extensions, audience_1 and audience_2, which I would like to compare to see what contacts in audience_1 are unique, meaning they do not exist in both audiences. The only field that has ...
0
votes
0answers
15 views

Fields not updated after an Append query

I added new fields into a Data Extension used for historical purposes (updated in an Append way through a SQL query in an Automation) but, after adding the fields also in the query to append the new ...
1
vote
1answer
31 views

Update multiple data extensions

I have 15 data extensions. All of the data extensions have 2 important columns (OpenId, ContactId) I need to update ContactId against OpenId for all Data Extensions. Is there any way to do it?
1
vote
1answer
41 views

Send SMS to updated mobile number via Journey

I'm working on a use case, in which a contact enters a journey. The purpose of Journey is only to send sms. 1st SMS sent as contact enters the journey. After 3 days, contact changes his mobile ...
0
votes
1answer
43 views

unable to create Data extension from existing fields of other data extension

Hi i am unable to create a dynamic data extension from the existing data extension fields. I am using the following code to get that <script runat="server"> Platform.Load("core","1.2"); var ...
0
votes
1answer
46 views

Automation Studio with Journey

I tried to create an Automation Studio with a journey and when I placed an audience the option did not work out anymore. Can someone please tell me how it is done now? How can I create a journey and ...
0
votes
1answer
43 views

Will Update SQL In Automation Studio Remove Records That Don't Satisfy Requirement?

I am attempting to automate our payment failures to alert consumers their subscription payment hasn't processed. My initial thought was to run a SQL activity once a day and inject new records into a ...
0
votes
1answer
32 views

Creating an Automation for Unsubscribe using Automation Studio- Marketing Cloud

I am trying to create an automation process to filter out my least active subscribers and then unsubscribe them from my communications (my subscribers are saved as a salesforce data extension). I was ...
0
votes
1answer
36 views

Retrieve all properties for a specific Automation in a child Business Unit

I would like to retrieve all properties of an Automation at Child Business Unit. When I run this SOAP Call, with a Child Business Unit MID, I get all properties for active Automations but of the ...
1
vote
1answer
45 views

SFMC - Get all existing automation

I want to create a landing page to list of all my existing automations in my SFMC account. Get the automation name, status, created date, activated data and last modified and owner. I checked if ...
0
votes
1answer
51 views

Auto Generate Subscriber Key

I a have a file drop automation which is importing data into specific data extension - there is no subscriber info in the data and I do not want to set one to email address. What would be the best way ...
0
votes
2answers
34 views

Query with configurable column as where condition

I am trying to write a SQL query in automation studio but one column in where clause should be variable or configurable. Means, we should not hard code the value for a particular column and we should ...
1
vote
1answer
85 views

Fill a DE thanks to SSJS in Script Activity using an external API

What I'm trying to do, is to fill a Data Extension using SSJS on weather column. (For the test I'm using nodeJS) Data Extension : "Weather API" weather | city name | country code (empty)...
0
votes
1answer
34 views

Find email address that are part of a domain exclusion data extension

I'm looking to find all email addresses in our database where the email address domain is included in one of our domain exclusion data extension. I thought of using something like the below, but it ...
0
votes
0answers
32 views

Contacts with multiple email addresses tied to single ID - SQL Join

We have 2 data extensions which we would like to join. The first called "MasterContacts" has contact information, including multiple email addresses tied to one FederationID, which is present in the ...
0
votes
0answers
17 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
30 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
43 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 ...
1
vote
1answer
67 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
61 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
54 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
41 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
44 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
53 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
57 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
25 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 ...