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

ERROR: Query failed: Timeout SFMC

Anyone knows what is the cause of the error in my Stuff SQL? i run the query many times and keep receiving this error. This query will get all the ProductCode based on every customer and i want to ...
0
votes
1answer
6 views

Automation Studio - Will Fire Event wait for SQL query to complete?

I have an automation in which I have to run an SQL Query to update a DE, and then notify Journey Builder for the eventually added contacts. 2 questions please: Provided I do it in a one step ...
0
votes
1answer
36 views

SQL Query for getting distinct domain and count

I have a Data Extension which has email address. I want to store all distinct domains and counts of these emails in another DE For eg: I have someth@som.com, test@test.com, 123@test.com. So my o/p ...
1
vote
2answers
28 views

How can I remove my company's email address from a data extension?

How can I remove my company's email addresses from a data extension? and add then to a new data extension. If I'm supposed to use a SQL query, can you help me with that? I want to remove a few ...
0
votes
2answers
43 views

Marketing Cloud: Removing multiple rows from a data extension via SSJS [duplicate]

In Marketing Cloud, we would like to remove multiple rows based on the EmailAddress column, which is the primary key in our permission data extension. Now, we tried using the code snippet for Server-...
0
votes
1answer
32 views

Tips for using SQL skills efficiently in Automation Studio [closed]

As a Marketing Cloud marketeer I really see queries as very powerful in creating strong segments. So, I've dived into SQL and query writing using codeacademy and w3schools, but even though I find ...
0
votes
1answer
33 views

Push Data Extension records into Salesforce CRM custom object

I am working on the requirement where we want to push records from the Data Extension into Salesforce CRM custom Object. Source Data Extension is updated every 24 hours. We are thinking to create a ...
1
vote
2answers
33 views

Clear Data Extension from Automation - Marketing Cloud

I have created automation with the following attributes: file drop Import the data to DE from the CSV file (Which I have dropped on FTP client) Send Email activity (Sends the email to that person ...
0
votes
1answer
23 views

Adding contacts and leads to a DE and receive a Violation of PRIMARY KEY constraint error message when running query

I'm attempting to add leads and contacts into a DE from a synced data extension that receives contacts and leads when a quiz is completed. The quiz can be taken multiple times which is why there is a ...
0
votes
1answer
26 views

Data extract 'Delete file from ET FTP or Safehouse' not deleting file on enhancedFTP

The Data Extract Type 'Delete file from ET FTP or Safehouse' is enabled in the account and I have created the Data Extract Activity. However, when I am running the automaton, it is not deleting the ...
0
votes
1answer
28 views

Create an Automation that exports Data Extension data only from the previous day

I have an Automation containing a Data Extract and File Transfer that exports the contents of a Data Extension each day. Is there a way to only export data from the previous day, rather than ...
0
votes
1answer
16 views

Export records from data extension automatically [closed]

Need to export records from data extension automatically and send this exported file trough email. Is there any way to do this?? Thanks and Regards, Usha Nagaraj
0
votes
1answer
20 views

Import Activity in date variables

I created an import activity to import a csv with today's date file on our FTP using date variables. Currently, three csv files with different date ("test_20200313.csv", "test_20200312.csv" and "...
0
votes
1answer
35 views

Multi-part specification SQL error

I am trying to pull bounce information for subscribers of a particular data extension using the following SQL: Select o.JobID, o.SubscriberKey, o.EventDate, o.BounceCategory, o.SMTPCode, o....
0
votes
1answer
53 views

Business Case: #Extract reason for unsubscribe using SQL SFMC (list-unsubscribe)

I would like to extract the reason (unsubscribed Reason) attribute as part of my SQL query to one of the data views (_Subscribers), but it shows as invalid column which is right but i need this badly ;...
1
vote
1answer
53 views

Delete contacts through rest api

I am trying to automate the deletion of contacts based on a data extension. I am using this script but it keeps giving me the error "ERROR: Error has occurred". Any idea what I might be doing wrong? ...
0
votes
1answer
36 views

Using SQL CASE statement to convert TEXT to BOOLEAN value

is it possible to change multiple field values when using CASE statement? I have a Text field with several values ( 5 differnt ones) and each of this value has its own Boolean field in tragt Data ...
0
votes
1answer
40 views

How to send Transaction Email when record added in marketing cloud data extension?

How we can send an transaction email when record added in DE, we can send email via journey builder but I want to send on quick basis like record inserted and email send. We are adding record in DE ...
0
votes
1answer
31 views

If constructor in SFMC query

How to do if conditioning within SQL statements SELECT su.emailAddress, IF C.SubscriberKey IS alphanumeric THEN '' ELSE C.SubscriberKey AS SUBSCRIBERKEY FROM from [_CLICK] C join [_SUBSCRIBERS] su on ...
0
votes
0answers
50 views

How to retrieve automation name of a query via API?

I've been trying to identify the automation name for a query via API. Looks like theres't a way straight forward way to filter the 'AutomationInstance' objecttype upon query name. I tried using ...
0
votes
0answers
15 views

How can I programmatically create/change the tracking destination for emails in an automation? [duplicate]

I've been working on a few scripts that can build out all the pieces of an automation that I need to create fairly often. I can create/update DEs, queries, email send activities, but I CAN'T seem to ...
0
votes
2answers
51 views

PGP Encryption Marketing Cloud File Transfer

I'm attempting to setup a file transfer activity from the Marketing Cloud Safehouse to our FTP Export Folder, encrypted. However, to do this, I have to enable a 'Customer Public Key'. On the activity ...
0
votes
1answer
34 views

file trigger automation filepart error

I first set up an import definition where the file naming pattern matches exactly a csv placed on our FTP. The definition runs and data is imported exactly how i want it into a data extension. Once i ...
0
votes
1answer
43 views

Randomly select 5 rows from a synchronized Data Extension

I am wondering if it’s possible to randomly select 100 rows from a Synchronized Data Extension over 500 thousands records, without adding extra columns to it and using ampscript to do so at send time? ...
0
votes
1answer
28 views

Journey Activation - No longer creates an automation?

When activating a new Journey with a schedule type of 'Run Now' or 'Recurring' the system used to automatically create an automation with the Journey. The automation name was the Journey name with a ...
0
votes
1answer
35 views

Marketing Cloud Data Views status and documentation [closed]

What is the current status of Data Views on Salesforce Marketing Cloud? The official documentation at here returns a 404 error. Is the functionality being phased out? Or is that an error on SF ...
0
votes
1answer
30 views

Encrypting Marketing Cloud Reports

So I'm creating a reporting definition to run in an automation. I would like the report to be .pgp encrypted and dropped onto the SFTP. The reporting definition in Marketing Cloud allows a drop onto ...
0
votes
1answer
17 views

Can I trigger a journey from an automation?

I think I know the answer to this, but I have an automation that runs daily and sends an email. In this email the user can click on a certain link and if they do I want to trigger an email to send a ...
1
vote
0answers
52 views

Marketing Cloud SSJS update to data extension

I have a data extension that I use for a newsletter. This newsletter will consist of a monthly automation to update the DE and a journey to send emails (12 months). My DE has a number field "...
0
votes
1answer
98 views

Mass Delete “Unspecified” Contacts in Marketing Cloud

Hi Experts, Is there a way to get "unspecified" contacts in Marketing Cloud - e.g. orphaned contact from setContactKey in mobilePush - in order to mass delete them from Automation Studio? I tried to ...
0
votes
0answers
48 views

Automation pulling data from multiple Data Extensions runs but nothing happens

I have an automation that pulls data from multiple Data Extensions, (one at a time) since the target Data Extension is the same. Select Email, CONVERT(NVARCHAR(MAX), HASHBYTES('SHA2_256', CAST([...
0
votes
2answers
43 views

Import definition in Automation Studio

I created an Import Definition in a Data Extension to import Data from another Data Extension. In Create an Import Definition docs, says: Once you complete your import definition, you can include ...
0
votes
1answer
42 views

File transfer activity to transfer file to custom FTP folder

In the FTP of marketing cloud we have three folders Import ,Export and Triggered automation . Just wondering if it is possible to create new folders in FTP and transfer file to those folders through ...
0
votes
0answers
12 views

Categorize URLs and count them on subscriber level

Is there a way, or best practice to categorize URL clicks and count them on subscriber level? We want to capture the number of clicks per content categorie on subscriber level. The categories ...
0
votes
1answer
51 views

How to push files into Enhanced FTP instead of Safehouse using Automation Studio

I have written using automation studio where sql query and data extract activity that successfully ran and is tied to the dataextension that is defined as part of data extract activity. In the third ...
0
votes
2answers
46 views

Problem with CSV file format from Marketing Cloud SFTP

I don't know if someone will be able to solve my problem but let's try it anyway. Here is my situation : I have an automation that contains a filter activity (step 1), a data extract activity (...
0
votes
0answers
38 views

I would like to give value to a field with values ​from a field in another table

I have two data extension, in the first one I have an empty field called codigo, to which I would like to give values ​​that are stored in the second data extension in the IdCodigo field, with the ...
3
votes
1answer
48 views

Using SSJS in Automation Studio to unsubscribe contacts from All Subscribers [duplicate]

We are using a custom preference center and an automation that extracts contacts from our Master Permission DE, who have Opt-in set as 'false'. This DE that contains opt-outs is evaluated and later ...
0
votes
1answer
42 views

Updating a DE with no Primary Keys

This might be a stupid question but is there a way to update records (yes many records and duplicate ones) in a DE without a primary key? I am not the owner of the DE which is already structured for ...
4
votes
2answers
160 views

Subscribers currently in a Journey

What ways could you create a data extension that contains all the subscribers (SubscriberKeys) that are currently “in” a Journey (Journey Builder)? The Journey I would like to do this for is a ...
0
votes
2answers
58 views

Primary Key combination for _Click data view

I am building replications of some system data views in order to be able to hold data that goes back further than 6 months (we are a seasonal business so want to look back at least 13 months). I ...
0
votes
3answers
47 views

How to write SQL query to pull only not matching Email IDs

I need to write a query to pull records which Email IDs are not matching in another table. For example, I have a two tables whose structures looks something like this: Table1 ID | Name | ...
0
votes
1answer
34 views

Do not Transfer File when Data Extension is empty!

I think the title says it all. Is it possible in Automation Studio to prevent a File Transfer Activity from the file to FTP if the designated Data Extension contains no rows? UPDATE: Screenshot of ...
0
votes
1answer
40 views

DISTINCT is not working as expected in Marketing Cloud

I'm experiencing problems with adding distinct in SQL automation. With SQL shown below I still receive duplicate clientids. Primary key would not work for me since during the next run of this ...
4
votes
2answers
43 views

SQL Query on reverting data from DE based on a filter condition and modify it before i put it into another DE

I am trying to retrieve multiple Columns from a DE and split a column into multiple columns and insert into another DE along with the original column. Ex : I have a DE-1 with Full name, Email and ...
0
votes
1answer
75 views

Please make sure to create a Relative Folder Path within the EnhancedFTP root

I am attempting to create a File Location that is a directory in which I will be dropping off a data extension extract. I have selected the following settings: Name: File_Location_Name ...
0
votes
1answer
21 views

Credibility of data when getting time out error in an update

If my query is updating a data extension and gives a time out error, does the destination data extension suffer any changes to its data or is it exactly the same as before running the activity? ...
0
votes
1answer
34 views

File drop Automation _ Exception mechanism

I am trying to get a solution for a unique exception case of File drop automation. The scenario is, a file(with wrong data) is dropped into FTP, overwrites a Data extension and waits for 2 hours and ...
1
vote
1answer
43 views

Data View queries optimization

Some simple Queries joining together some Email Data Views are timing out and I'm having a bit of a hard time understanding why. They're simple and concrete enough.. Any ideas to tackle this would be ...
0
votes
0answers
17 views

Repercussions of adding new field to journey entry data extension

I'd like to add a nullable field to a data extension that's used as an entry source for an active journey. I know this is possible, but what are the repercussions of adding the nullable field if the ...

1
2 3 4 5
10