All Questions
52 questions
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
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 ...
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
2
answers
422
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
2
votes
1
answer
1k
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,049
2
votes
2
answers
3k
views
How to suppress contacts from marketing cloud email sends if they already got an email
My business is trying to implement 2 rules on marketers about the frequency they can email our contacts in marketing cloud. I am looking for a solution to do this perhaps in automation studio to ...
- 324
2
votes
2
answers
394
views
Why is my code querying All Subscribers producing results that don't exist in All Subscribers?
In Marketing Cloud - I'm trying to write an SQL that will pull everyone who has opened an email in the last 90 days. I'm getting results from the below SQL, but when I spot-check the data, I'm finding ...
- 53
2
votes
2
answers
792
views
SSJS WSProxy code is unable to access SFMC object - AutomationActivityInstance
I am trying to work on SSJS script to fetch the details about the automation activities.
I found an object called AutomationActivityInstance - https://developer.salesforce.com/docs/marketing/...
- 23
2
votes
2
answers
827
views
Export all subscribers file content is in hexadecimal, I need it to be readable text
I have an automation to export all subscribers to fetch the "status" column. My shceduled automation extracts the all subscribers list and then drops the file on the dedicated FTP with correct name ...
- 266
2
votes
2
answers
2k
views
How do I cancel an automation from a script being run by the automation?
I have a scenario where we want to send the same email from multiple business units every day. The email should get updated daily, but I wanted to have a check in the automations in each business ...
- 145
2
votes
0
answers
1k
views
Automation generates yesterday's data and file name when run early morning (fine under other hours)
We have an automation to export the people in a Data Extension with the LastDeliveryDate value equal to 21 days ago. The file will end up on an SFTP server that is not Salesforce's own Enhanced server....
- 664
1
vote
2
answers
2k
views
Schedule an Automation through the API without a Recurrence("Repeat") Value
Is this possible to do? Each time I schedule an automation through the API it only seems to work if I set a "Recurrence" value, although I only want the automation to run once.
To get around this I'...
- 153
1
vote
3
answers
1k
views
Marketing cloud SQL Query Deduplication
I am trying to deduplicate my entry data extension based on the completeness of field values. For Instance, i have the a data extension with same email address, the record that has maximum field ...
- 1,693
1
vote
2
answers
588
views
How to Activate a File Drop Triggered Automation through the API
This question has been asked a few times over the years but has yet to receive an answer.
I am trying to figure out how to activate a file drop triggered automation through the API(Changing it from "...
- 153
1
vote
1
answer
131
views
I want to create a Frequency Capping process on Number of Emails/ SMS/ Push messages sent to a customer in the last 1 or last 7 days
The basic process we are planning to use for achieveing this is:
Create a DE that has SubscriberKey and 6 columns "EmailsCount_7days" "EmailsCount_1day" "SMSCount_7days" ...
- 119
1
vote
1
answer
1k
views
Time / Date constraints in Journey Builder
I am trying to set up some automated journeys in JB and would like them to only send on specific days and within specific timeframes.
E.g.
After a lead is submitted, send an email after 5(ish) days, ...
- 13
1
vote
1
answer
1k
views
Automation Monitoring
I had a question about how folks monitor their automations' successes and failures. We currently have a very manual process that I'm hoping to automate (no pun intended).
Currently we:
Receive email ...
- 11
1
vote
2
answers
880
views
Target vs Control using Automation Studio
We are creating campaigns using automation studio due to campaign complexity. However, in these campaigns we are trying to implement Target vs control population.
The issue is we can't use the random ...
- 121
1
vote
1
answer
264
views
Is it possible to create an automation that exports a list (not a DE) to an FTP?
I need a way to automatically export a list (not DE) to an FTP. I know this is possible when using DE's, data extracts, and file transfer activities. However, no documentation seems to exists when ...
- 191
1
vote
2
answers
89
views
How can I get Rows from a specific Data Extension and add them to another one using SSJS?
I want to insert the rows from an existing data extension with the same column structure into another one using SSJS within Automation-Studio. I am using SSJS because I want to add them dynamically, ...
- 11
1
vote
1
answer
10k
views
SQL Query : Using JOINS with CASE Statement [closed]
I've 3 DE
MASTER DE with fields SubscriberKey(PK), donottrack, Createddate, Modifieddate
Staging DE with field CustomerID(PK), Createddate
Reference DE with field donottrack default value false.
...
- 71
1
vote
1
answer
339
views
Automation doesn't run through SSJS when it is in a Paused state
I was able to run an automation which is in "scheduled" staus using SSJS, but when I pause it manually (status changed to "Paused") and execute the same script, the automation doesn't run. The script ...
- 13
0
votes
2
answers
805
views
Checking for a non ascii character in SQL Query activity
I have certain records in my DE, where the first name contains '�'. I wish to extract such records. Obviously a like wouldn't work. Is there a way to do this in SQL Query Activity.
- 1,693
0
votes
2
answers
3k
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 ...
- 134
0
votes
1
answer
12k
views
Using Automation Studio to Export a Data Extension
I am working with a client to try to create an automated subscriber list export process.
Is there a way use Exact Target's Automation Studio to export data from a Data Extension to either FTP or sent ...
0
votes
3
answers
4k
views
How to refresh a data extension on a timer?
How do I setup a filtered data extension to automatically refresh on a daily basis at a specific time? Can I use Automation Studio to achieve this?
0
votes
2
answers
104
views
Automate looking up data based on subscriberkey and populating a data extension with extended info
Based on the subscribers website interaction, my guy handling our website can send me two types of data:
SubscriberKey
RoomOfPreference.
I can have him add this data to a pick-up data extension via ...
- 551
0
votes
1
answer
424
views
Deleting records from a DE 3 months after they are added
I want to write an automation which deletes records from a certain DE after the present date is 3 months after their date_added attribute. I know this is possible with DELETE FROM and DATEADD() in SQL,...
- 175
0
votes
1
answer
1k
views
Export all contacts with automation issue
I want to export all subscribers to extract the "status" column on every subscriber. I want to automate the steps as in this official documentation. I know how i do it manually but it needs to be ...
- 266
0
votes
2
answers
2k
views
Automation Studio Activity (Journey Entry) not appearing. (Permissions?)
I am reviewing some activities in our SFMC instance that some previous coworkers built. In one automation activity, I am seeing an activity I can't find. I can't find the "Journey Entry" ...
- 1
0
votes
1
answer
899
views
SSJS code to fetch automation details issue
I am using the below SSJS WSproxy code to extract the automation details like name, status,start time etc. to create a dashboard
<script runat="server">
Platform.Load("Core",...
- 3
0
votes
2
answers
2k
views
Running Automations in 15minute intervals
I'm aware of the 2 methods of running the automation so that you can run it more frequently (less than 1 hour)
Adding wait periods between SQL activities within 1 automation
Cloning the automation ...
- 119
0
votes
2
answers
776
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 ...
- 153
0
votes
1
answer
50
views
creating an automation from Fillezila to SFMC using Automation Studio
I was creating an automation from Fillezila to SFMC using Automation Studio. The csv was in the Subpast called scheduler(as you can see at the screenshot attached).
When a run the automation studio it ...
0
votes
2
answers
91
views
How is the link generated for automation
Hello I have created list of automations on cloud page and want to generate link to each automation
Is there a way how to generate the link?
https://mc.sx.marketingcloudapps.com/AutomationStudioFuel3/#...
- 148
0
votes
1
answer
219
views
Updating an Email Send Definition with SSJS to update data extension AND publication list
As part of an automated email we have, I made an SSJS script block to update an Email Send Definition (User-Initiated) to target a new data extension. However when we do this, it resets the ...
- 898
0
votes
1
answer
169
views
Can we Run An Automation for 24 Hours by adding repetitive activities to ensure we are processing data we captured in Data Extension
We need to continuously process data(need to make an API call using SSJS script activity to external system which is time sensitive) which we are capturing in Marketing Cloud Data Extension via SFMC ...
- 39
0
votes
1
answer
178
views
How to created automated Journey for Google Analytics 360 contacts?
I have integrated Google Analytics 360 with my marketing cloud account. I see it as a Synchronized Data Source in Contact Builder and I can pull it into my Journey in Journey Builder. But, I want this ...
- 1
0
votes
1
answer
982
views
How to use a SFMC SJS Script Activity to pull data with httpget and then store it in a Data Extension?
I have figured out how to use HttpGet to display JSON directly in an email body, but instead I want to store this JSON data from an external URL in a data extension, and then use AMPscript lookups to ...
- 35
0
votes
1
answer
883
views
Schedule SFMC Automation via API
If I try to schedule an automation I use Schedule method and works perfectly if I'm working on the parent business unit of an enterprise account. If I try to schedule an Automation that is created on ...
- 147
0
votes
4
answers
2k
views
ExactTarget Automation Studio -- sending multiple emails in one automation
We are a large cultural institution that produces hundreds of events every year. I am trying to set up an automation inside of ExactTarget Automation Studio which would send "You are coming" emails to ...
0
votes
1
answer
104
views
How to check for activated automation
Is there a way to check for activated automation?
I want to extract it to DE:
Automation Name
Activation status
Last Execution Date
- 29
0
votes
1
answer
177
views
Data Extract Activity could not start issue
I migrated automations from one Business Unit to another (newly created) using Package Manager. Some of these automations have Data Extract activity. The Extract type is 'Data Extension Extract'. All ...
- 957
0
votes
0
answers
187
views
Problem with automation and Sql Query
I have a problem with an automation:
the query inside has no error and runs correctly, but no record is extracted. If I try to run it externally (via run once and query studio) the records are ...
0
votes
1
answer
39
views
Journey Builder - If I change the time of my automation which sends data in a journey, will the send time of the journey change?
If I change the time of my automation which sends data in a journey, will the send time of the journey change?
0
votes
0
answers
424
views
Is it possible to perform validation of data in data extensions in SFMC automatically?
Currently, we have a ton of AdHoc (one-time emails) each month and for each email:
the email creative is different
audience list and DE fields are different
So, every time we get the list imported ...
- 353
0
votes
1
answer
98
views
Data Loss in File Convert Data Activity Extract
Has anyone experienced a loss of data from "File Convert" Data Extract Activity?
I am exporting a synchronized data extension:
Step 1: Data Extract Activity - Export DE
Step 2: Data Extract ...
0
votes
1
answer
277
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
1
answer
25
views
How do I change the userID an automation routine (file import) runs under in Marketing Cloud?
How do I change the userID an automation routine (file import) runs under in Marketing Cloud? Employee left and we need to update the automation to be a support user ID.
-1
votes
2
answers
690
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 ...
