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.
884 questions
8
votes
2
answers
6k
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 ...
- 2,423
6
votes
1
answer
2k
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 ...
- 193
6
votes
3
answers
701
views
Child Automation run as step in Parent Automation?
Any ideas on using this SSJS Automation Trigger (or some other method) to Trigger a Child Automation as a middle step in a Parent Automation that once complete continues to process?
I have a long (...
- 128
6
votes
0
answers
920
views
Using a Shared SSJS functions in my Automation Script Activity
Let me preface this by saying that I am not looking at cloud pages. I am looking to either use Content Blocks or other Activity Scripts to store JS functions which I can load into an Automation Script ...
- 198
5
votes
1
answer
10k
views
Making a REST API call from a Script Activity in Automation Studio
We are trying to update a service cloud custom object from marketing cloud.
Can we make a REST api call within a script in Automation Studio.It will be great if someone in this forum can confirm they ...
- 236
5
votes
3
answers
2k
views
Retrieving Contact Key on MobilePush Demographics
I need Contact Keys of contacts on MobilePush Demographics. Can someone explain how can I manage to retrieve Contact Key on the custom attribute on MobilePush Demographics?
I've tried these, but none ...
- 81
4
votes
2
answers
8k
views
Query on system data views in Automation Studio
I was wondering if someone perhaps know how we can identify the system data views we use/have in our account?
According to this article we should be able to query for instance the data view: ...
- 41
4
votes
1
answer
3k
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?
- 43
4
votes
1
answer
7k
views
Marketing Cloud Data Extract into the correct File Encoding format
I have created a Data Extract activity exports a .csv file containing records from my Data Extension.
The file is in the wrong File Format so I have requested Salesforce activate additional encoding ...
- 4,906
4
votes
1
answer
11k
views
SQL Query in Marketing Cloud Today = date
I'm trying to query using a where clause such as this: WHERE Today = a specific date .
This is what I have right now:
DateAdd(day, 0, GetDate()) = '2018-02-12' (because it was 2/12 when I posted/...
4
votes
2
answers
413
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 ...
- 41
4
votes
1
answer
64
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 ...
- 107
4
votes
1
answer
598
views
Using Marketing Cloud API to Activate, not Run, an Automation
I am looking for a way to use the Marketing Cloud API to activate an Automation in a manner that is equivalent to pressing the "Active" button in the UI (next to the "Paused" button).
Eliot Harper ...
- 231
4
votes
3
answers
5k
views
Cannot Query Synchronized Data Extension
I have created a Query to consolidate data from 2 Synchronized Data Extensions into one Sendable DE, but upon running it I get an "Automation failed due to system error".
At first I thought my query ...
4
votes
1
answer
489
views
Update Marketing Cloud Automation tasks with SOAP API returns "OK" response but doens't update [duplicate]
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 ...
- 41
3
votes
3
answers
4k
views
Can Automation studio be scheduled less than once a hour
Due to one of the critical requirement, we would need to run the automation studio, less than once a hour. Has anyone have an idea if Salesforce support would be able to enable running automation ...
- 514
3
votes
3
answers
966
views
How to identify object type using contactkey in marketing cloud?
I've synchronized two objects (from sales cloud) as Contacts in salesforce marketing cloud. These two objects are "Lead" & "Account" and both are mutually exclusive.
I want to update bounce ...
- 556
3
votes
2
answers
1k
views
Optimizing SQL queries
I've set up an automation that resends an altered version of a mail to all who recieved it the first time it was sent, but didn't open it.
This is done in Automation Studio using 3 SQL Query and a ...
- 551
3
votes
4
answers
5k
views
Marketing Cloud to s3
I have an s3 bucket I would like to transfer data to daily via automation. It currently doesn't look like there is a native way to transfer data into s3 via a file transfer activity. Has anyone had ...
- 491
3
votes
1
answer
3k
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
...
3
votes
2
answers
7k
views
Updating All Subscribers from Data Extension
Is there a way to update a record in the AllSubscribers List from a Data Extension Import?
I'm hoping to set up a daily automation that imports data file into a Data Extension on the subscriber key ...
3
votes
2
answers
3k
views
Automation studio SFTP file drop trigger to Import Activity
Background: We have a simple automation studio workflow defined that would trigger when file with a certain name pattern is dropped and that then initiates the import activity (which also relies on a ...
- 33
3
votes
1
answer
423
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 ...
- 538
3
votes
1
answer
7k
views
Query From Shared Data Extension
I have a shared Data Extensions across multiple Business Units.
I need to run a query from it in a Child BU but every time I try to run I get
"× An error occurred while checking the query syntax....
- 491
3
votes
1
answer
4k
views
Limitations for Import from Enhanced FTP in SFMC
I am using Data Extract -> File Transfer -> Import via an automation to upload my synchronized data extensions to All Subscribers in Marketing Cloud.
Currently everything seems to work fine, however ...
3
votes
1
answer
907
views
Automation Studio Query not accepting parentheses in combined AND OR
We've run into a problem which prevents us from combining ANDs and ORs in the WHERE clause of a SQL statement. This is the syntax of our WHERE statement:
SELECT
s.subscriberKey
FROM
...
- 175
3
votes
2
answers
3k
views
Query Inner Joins followed by a Left Join
I have a query that I am running that joins a few other data extensions and filters based on Role and Created_At date.
Also I need to remove subscribers that are in this group that are also in ...
- 1,407
3
votes
2
answers
417
views
How to delete emojis using SQL in Marketing Cloud
I have a Data Extension named "Jobs", where I keep records from dataview Job. My team started to use emojis in subject lines of the e-mails, so also in my table "Jobs", I have ...
- 193
3
votes
1
answer
525
views
There is a record count difference between the Job Data View and the SendJobs Tracking Extract
My Configurations:
Job Data View
SQL Query to select the last 90 Days of records from the _Job Data View (here) based on SchedTime.
Send Jobs Tracking Extract (here)
Setup to generate a CSV with the ...
- 198
3
votes
1
answer
267
views
WSProxy - is it possible to move categories / automations?
With the new year I am trying to create a fresh start by cleaning up old folders and files from our MID. It's quite a tedious job to move folders and files manually within automation studio. I am ...
- 63
3
votes
2
answers
3k
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
[email protected] also uses @brand-b.com, @brand-c.com and ...
- 69
3
votes
1
answer
976
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 ...
- 63
3
votes
1
answer
2k
views
Create a data extension with the number of clicks and opened emails
I'm working on a feature for marketing cloud and I need to create a Data Extension with those fields : NumberOfOpenMails,NumberOfClicks and all the other fields relative to the subscriber. I found ...
- 354
3
votes
1
answer
932
views
Creation of a Filter Activity via API
After digging, I have found the API object for FilterActivities, and have been able to Perform, Retrieve, etc. from them, but have been unable to Create one from scratch.
I have received the ...
- 30.8k
3
votes
1
answer
2k
views
Automation Studio error: Automation cannot be Performed. Automation has been marked as deleted
I have an issue where I can no longer start an Automation using the Fuel SOAP API. This used to work but has stopped working and I'm wondering if it's working for anyone else.
I've created a new ...
- 16.7k
3
votes
1
answer
395
views
Create an automation Wait activity via API
Is it possible to create a wait activity step in an automation via preferably SOAP API or I know there is an undocumented REST API. Could a single wait activity be used on multiple automations?
- 206
3
votes
1
answer
94
views
Query association to automation viewable?
Is it possible to see which automation a query activity is part of?
- 1,407
3
votes
2
answers
2k
views
Automation Studio - Imports old file data or same data into Data extension again in file Drop automation with import activity?
Actually, I created File Drop automation to import data into Data Extension. I dropped different files into the same file location. After the completion of automation flow - it imports data of the ...
- 61
3
votes
1
answer
3k
views
Data Extract of data extension to Enhanced FTP
I am trying to extract Contact Keys from a data extension so that I can load them back into the system to unsubscribe them. I am gathering these contact keys from multiple SQL Queries to different ...
3
votes
0
answers
74
views
Automation studio behaviour on months that don't have a 29th day
I've got a specific use case where we need to send emails out on the 29th of every month.
I'm using a scheduled Automation Studio SQL to kick off a journey on the 29th of each month. However, I'm ...
- 31
3
votes
0
answers
4k
views
Save %%FILENAME_FROM_TRIGGER%% as field value
Is there a way to get the value of %%FILENAME_FROM_TRIGGER%% from an import activity and save it somewhere, maybe in a DE?
I am building a dashboard (cloudpage) that will display what file is ...
- 83
3
votes
0
answers
377
views
Send Throttling + Wait Activities in Automation Studio
I'm creating an automation that has user-initiated sends and wait activities. After the first user-initiated send at 9am, there is a wait activity for 24 hours, then another user-initiated send, then ...
3
votes
1
answer
798
views
How do i set a field to null in journey builder contact interaction
JB supports adding a value to a field, but does not seem to support clearing a value.
Does anyone know what to add to field criteria to clear a value?
Just entering null does not work. It applies ...
- 324
3
votes
0
answers
560
views
Sending marketing cloud mails from Salesforce instantly
We have a unique problem in Sending marketing cloud mails from Salesforce.
Contact records are available in Salesforce and the logic to select which contact should receive the marketing cloud mail is ...
- 137
2
votes
1
answer
14k
views
Trying to automate contact deletion with SSJS
with the GDPR laws in place, it's important to have the possibility to remove contacts from Marketing Cloud. I'm trying to automate the process with existing tools and am looking for possible ...
- 3,401
2
votes
2
answers
8k
views
Query Activity system error in Automation Studio
Why am I getting a system error with this Query Activity in Automation Studio?
Select
o.AccountID
, o.JobID
, o.SubscriberKey
, o.EventDate
, o.isUnique
, o.Domain
, o.SubscriberID
, o....
- 594
2
votes
1
answer
879
views
Optimizing SQL for large volumes
We're working with somewhat large sets of data, around 15M - 35M records per DE, each row with 150+ attributes.
What are some ways to optimize SQL queries when handling many records?
For an exaple, ...
- 5,794
2
votes
1
answer
324
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 ...
2
votes
3
answers
4k
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 ;...
2
votes
1
answer
11k
views
Date manipulation Function SSJS
I want to delete the records from Data Extension based on Date Field in my DE i.e. I want to delete record which were created date before 30 days.But I didn't find date manipulation function in SSJS ...
- 31