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

Deleting contacts in data extension - Automation Studio

I was wondering if anyone has had any experience in using Automation Studio to delete contacts in a DE? Or, know of a better way? Essentially what I'm looking to do, is collect data using a Cloud Page ...
0
votes
0answers
17 views

SSJS Platform.function.deleteData() taking longer to delete data while doing bulk operation

I've to delete millions of contacts from all existing data extensions to follow GDPR and CCPA. I somehow list out all Data Extensions and contacts list to be deleted. Since most of the data extensions ...
0
votes
1answer
25 views

Update or Overwrite in SQL Automation when using Contact Data Attribute Group in Journey? [closed]

I have a Journey using Attribute Group / Contact Data. ContactKey:1:N The Journey Entry data extension (:1) in the Attribute Group, has a Today minus -2 days filtering in the SQL query in Automation ...
1
vote
1answer
48 views

SQL LIKE statement results in unexpected behavior when field is delimited

I'll say that using LIKE or NOT LIKE works great when splitting out emails. I usally do '%@%', but something strange is going on here... I have a field and it has delimited values for example: Do not ...
0
votes
1answer
44 views

Query running hourly failing with primary key violation intermittently

I have a SQL query that is trying to pull three records and insert them into one. On table A, affiliation ID is the primary key, and a contact can have more than one affiliation. On table B, Contact ...
0
votes
1answer
32 views

SQL Query Error: Record Type ID' is a required for the Target Data Extension. Ensure this field is specified

SELECT c.AccountId as SubscriberID , c.DoNotCall , c.Email , c.FirstName as First_Name , c.LastName as Last_Name , c.HasOptedOutOfEmail as Email_Opt_Out , c.Phone , a.id , a.RecordTypeId as ...
0
votes
1answer
21 views

Invalid column name in row_number() function

Why am I getting this error? An error occurred while checking the query syntax. Errors: Invalid column name 'Id'. SELECT (L.Id) as 'SubscriberKey', L.ID__c as 'ID_C', L.Email as '...
0
votes
1answer
19 views

Unable to create File Locations in SFMC

The documentation for Create a File Transfer Location (https://help.salesforce.com/articleView?id=sf.mc_overview_create_file_transfer_location.htm&type=5) says to navigate to: Click Setup. Under ...
0
votes
1answer
49 views

How to update DE records (>10 years AND <1990)equal to NULL in SFMC Using SQL

How to null birthday records below 10 years and birthday records of those born before 1990 using SQL in Salesforce marketing cloud. Here in my DE Birthday is text field.
0
votes
1answer
52 views

SQL-Bounce data in Marketing Cloud

I am an not a pro when it comes to SQL.I am looking for help write a single query that gives me bounce data for my sends in last 90 days. When I try the below I hit an error "Unable to create ...
0
votes
0answers
55 views

Determine Locale of Mobile Number in Salesforce Marketing Cloud Mobile Connect

I'm attempting to automate an SMS Mobile number import into marketing cloud from an external database. We have a CSV file that has the columns ContactID, Locale (null), MobileNumber. The export from ...
0
votes
1answer
41 views

SQL issue in populating a Data extension in Marketing Cloud

Could anyone help identify why this SQL won't populate to a data extension: Select l.Id , l.Email , l.FirstName , l.LastName , l.MC_Lead_Mobile_Phone__c as MobilePhone , l.Salutation , e....
1
vote
1answer
49 views

CHARINDEX(“(”,ColumnName)-1) errors

I'm trying to clean a column data by deleting what comes after the open parentheses: LEFT(columnName, CHARINDEX("(",columnName)-1) as columnName But I keep getting this error: An error ...
0
votes
0answers
20 views

File encoding in UTF8 is truncating my file

I need to extract a Data Extension of Contacts with several million lines in UTF8. It works properly when I extract Sent, Open or Click data views but, here, I really can't figure out what is going on....
0
votes
0answers
37 views

Error in Salesforce SQL query activity setup

I needed some help in writing this SQL query. I had it valid when I tried a different data extension as test. But when I tried to apply it to the needed DE. I got the below error message Error saving ...
0
votes
1answer
45 views

SQL birthday reminder, leap year in Marketing cloud [closed]

i'm trying to sort out a result set that sorted by upcoming birthday. This works perfectly until leap years comes into play. For example: Nov 14 1991 - 200Days left Nov 13 1988 - 200Days left Here ...
0
votes
1answer
19 views

Journey Activity View timestamp of activity

In Journey Builder there is Journey History, this view is random order and I have 3000+ records. Making it incredibly difficult to try and figure out the flow. My plan was to join Journey and Journey ...
1
vote
1answer
81 views

How to use string_agg/group_concat in salesforce marketing cloud

I am trying to write something similar in query studio on SFMC. But keep getting string_agg is not recognized as a built-in function name. Please help. Also, what could be the alternative. Thanks ...
0
votes
0answers
21 views

I want to update subscribers profile attributes in Salesforce Marketing Cloud with respect to their business units

I have two business units A and B and both are sending out emails to the subscribers I have. I have created two profile attributes MID_A and MID_B which will store the MID of A and B respectively. I ...
1
vote
0answers
34 views

Contact Deletion in Automation Studio with SSJS

Basing on the article here I prepared a code snippet to run in Automation Studio. Unfortunately we receive Bad Request(400) error for second API call everytime even though all passed parameters are ...
1
vote
0answers
42 views

Using Journey Builder to update campaign member for both leads and contacts

We have a journey which both contacts and leads are injected into it. We would like to add both of those to a SF campaign without using using multiple decision splits and update campaign member ...
0
votes
0answers
19 views

Exporting Report to File Location using Automation Builder

I have a report generated on a schedule and being dropped into my /reports directory in the Enhanced FTP server. I would like to then take that csv file and send it to an external SFTP File Location ...
0
votes
0answers
44 views

Mix Automation Studio and Journey Builder

I'm trying to find a way to fire a Journey only if an Automation ran with success, and then again other steps in the Automation. More details : I need to run a SQL query to populate a DE every night ...
0
votes
2answers
44 views

Pushing data from one data extension to another

In Marketing Cloud, I have two data extensions. Both Data Extensions are being populated via entries in a journey. One runs off of the contact object and the other runs off the opportunity object. The ...
0
votes
0answers
37 views

SQL query to find the name of the Sendable Data extension that was used to send a email

I am checking if there is a way to fetch the name of Sendable Data Extension to which the Email was being sent to using query. I have used Data Views to find the ListName. But I want get Data ...
1
vote
1answer
52 views

Marketing Cloud Query Activity SQL Syntax Error [closed]

New to SQL so be nice! :) I'm trying to run a simple SQL query in Automation studio, unfortunately I am getting this error - "An error occurred while checking the query syntax. Errors: Incorrect ...
-1
votes
1answer
42 views

SQL query to find Job ID and email name for triggered & scheduled email sends

I was trying to implement this answer given in StackExchange - Query for Emails sent in the past month, unsubscribes opens, clicks for each If you look at, “III-C. SQL Query”, Paragraph in the answer, ...
0
votes
0answers
38 views

Marketing Cloud File Convert Data Extract Type adding empty rows

Does anyone experience the following using the file convert extract type? When i use this, the file convert to UTF8 extract will add empty rows between each valid rows, even when I use the Line Feed ...
0
votes
1answer
40 views

Find the ‘total sent’ for each JOB IDs in last 1 month along with ‘list name’ it was sent to [closed]

Currently by using this query, I get the number of total_sends for a particular JOB id. But I want to modify the Query so that it shows total_sends , ListName , Date for that each job ID within a ...
0
votes
1answer
24 views

Salesforce Marketing Cloud Sending Data Extracts to Another (non-SFMC) SFMC Site

Is it possible for Salesforce Marketing Cloud to send a data extract (from a data extension) from SFMC Safehouse location at the business unit's sFTP to a completely different sFTP site located on ...
0
votes
0answers
29 views

'Journey Email Send By Day Report' (CSV file) cant be added into data extension

I am saving the ‘Journey Email Send Summary by Day’ as a CSV file into FTP. Which looks like this.. Then I am importing it using Automation Studio using ‘import activity’. My target DE has these ...
1
vote
1answer
60 views

SQL query to find unengaged subscriber confusion

I want to exclude subscribers who have not ‘opened’ or ‘clicked’ email in last 6 months. I have the below sql query. Is this SQL query correct? Does the final results of this sql query results have ...
0
votes
0answers
18 views

SQL Query Activity into FLE Data Extension

SQL Query activities will insert the literal string into a data extension field, even if Field Level Encryption is enabled. I want to select data from a view and insert it into a data extension, while ...
0
votes
1answer
66 views

How to store Journey Report into a Data Extension

I have a Journey through which I am sending emails. I can extract the journey report from Analytics Builder (as a Excel file). Where is this report data stored in SFMC ? Can I access this data in a ...
0
votes
1answer
52 views

Unable to get percentage value in SQL Marketing cloud

Everyone The below query is working fine without bounce_rate condition. When I am adding the bounce_rate it is throwing an error. Anyone please suggest on this. SELECT j.emailname, j.emailsubject, s....
1
vote
1answer
40 views

SQL to not insert line if RecordTypeID = “123” or “123”

I have the below SQL in Marketing Cloud. I want to stop a new line being entered into my data extension if it contains one of two RecordTypeId's. Thanks in advanced! SELECT Contacts.Id, Accounts....
0
votes
1answer
80 views

Append a value to a Data Extension Field using SQL

I tried to follow the example used in this link, but I'm having trouble getting it to work. I get an err msg (Error saving the Query field.An unmatched parenthesis occurs in the query.). for ...
1
vote
2answers
56 views

Birthday Journey with no event entry source [closed]

I´m solutioning a Birthday journey and was wondering if this idea will work before running it by my client. Entry source: DE_[Tier]_BirthdayJourney This DE is populated by an SQL query that runs ...
0
votes
2answers
68 views

how to automatically send email to contact who did not open or clicked email in marketing cloud?

For our monthly newsletters, we get a new list every month. Original send - We have 20 different newsletter every month. Resend - Each newsletter also need to go out to contacts who did not open or ...
0
votes
0answers
21 views

Update Auto suppression List

I want to update the auto suppression list as a result of a query activity I used this script activity https://gist.github.com/eliotharper/d3673ce31c79e2ccd3b31843a5724f6c ` <script language="...
1
vote
1answer
58 views

Landing Page preview REST API in Marketing Cloud

We have a static landing page (no forms to submit) with some dynamic content like disclosures. The static content doesn't change much, but the disclosures do and the disclosure have all the legal ...
0
votes
1answer
37 views

Is there any existing way to move a CSV file from SFTP to a media folder for recipient to download?

I have a specific business need for an automation that would be triggered by a CSV file being sent to our SFTP. I then would like the SAME file to be, not necessarily attached, but a download link to ...
0
votes
0answers
36 views

Error: Violation of PRIMARY KEY constraint - How can I avoid inserting changed data with same PK?

I'm having an issue with a primary key violation that is a little different than others posted. I have a Contact, who can have one or more Reservations. I need to pull a list for a Journey very ...
1
vote
2answers
26 views

Salesforce DEs are not visible in Automation Studio when configuring an Email Send

Does anyone know what happened to Salesforce Data Extensions in Automation Studio Email Sends? We can't find it... I've looked at a few client accounts and it seems to have disappeared? For existing ...
0
votes
1answer
31 views

Display multiple Trigger sends email names on landing page

I want to display the names of all the trigger send emails present in the account on landing page. A user should be able to select the one name from this list (Like dropdown list). I have tried for ...
0
votes
1answer
69 views

SQL query to exclude subscribers

I'm trying to pull the data from orderDE, where purchaseddate is (day - 1). if the customer only purchased a single product in a day, include him in results. If a customer purchases more than 1 ...
0
votes
1answer
64 views

How to delete rows from DataExtension having no Primary Key, and exist in different Business Unit?

I refered this approach to delete rows from Data Extensions having no primary key. But this require to put SSJS script into every business unit. I tried with WSProxy by setting different clientId , ...
0
votes
1answer
29 views

SFMC CC an email address in a User Initiated Send definition

I know this is possible on a triggered send definition to CC an email address, but I can't find out if this is possible for a "User Initiated Send". I have a file drop automation that ...
-1
votes
1answer
30 views

Best Practice to send out list by different owner in SFMC

I'm trying to send Monthly birthday list to every store manager from SFMC. I'm thinking that there might have 2 ways to achieve it though I'm still not quite sure how to complete it. Is there any ...
0
votes
0answers
25 views

Can Journey Builder be used to send an email three days prior to a dynamic date?

We are setting up a journey that will send to multiple contacts with different date stamps. A start dat, and and end date, We want to send a message three days prior to the end date. Is there a good ...

1
2 3 4 5
13