All Questions
Tagged with marketing-cloud automation
194 questions
0
votes
1
answer
1k
views
SQL query to update field only if it is empty
I need to run a query which updates a target DE with some rows from another. There is a field called 'origin' which shows on the target data extension where the data came from.
I appreciate this may ...
CommunityBot
- 1
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'...
- 1
1
vote
1
answer
1k
views
Create automation by SSJS
Is it possible to create an automation by SSJS, object type CreateRequest does not exist and I don't know how create that entity in my system.
I using this code but last lines gives me an error.
<...
CommunityBot
- 1
0
votes
0
answers
35
views
Journey Builder with DE Entry contains duplicate Contacts for Reminders
We would like to create a Journey that sends a one-hour reminder email before each event starts. Since a contact can have multiple events in a day, we would like to send a separate email for each ...
- 1
0
votes
1
answer
2k
views
SSJS perform data extract
Running this script but getting the error : -
{"message":"Error executing perform call.","description":"ExactTarget.OMM.FunctionExecutionException: Error executing ...
CommunityBot
- 1
1
vote
2
answers
87
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, ...
- 31.1k
1
vote
1
answer
2k
views
Can we delete file from SFTP Import folder after import activity?
Can we delete file from SFTP Import folder after import activity?
I have an automation that picks up the file based on name. The file is uploaded frequently on SFTP import folder and I have noticed ...
CommunityBot
- 1
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/#...
- 49
0
votes
1
answer
139
views
How can I do pagination to retrieve all salesforce marketing cloud automations via rest api?
I'm trying to return all the automations from all the orgs I have in salesforce marketing cloud through the following method:
import { Injectable } from '@nestjs/common';
import { HttpService } from '@...
- 3,401
0
votes
1
answer
82
views
I want to update Salesforce Automotive Cloud Object and Marketing Cloud Data Extension using SSJS in Automation Studio
I have a data extension named "SMSUnsubLog" which includes SMS unsub data of customers.
I want to get data from the data extension and update salesforce object(ContactPointTypeConsent) and ...
- 11
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 ...
- 25.8k
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
- 25.8k
0
votes
0
answers
68
views
_AutomationInstance data view is not returning right data
can anyone lend me a hand?
I'm having trouble retrieving data about my automations using the data view _AutomationInstance. Automation Studio is returning incorrect data for certain automations in ...
- 3,835
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 ...
- 22.2k
-1
votes
1
answer
256
views
Max number of automation queue
I could not find anywhere the number of files that can be queued in a fileDrop automation.
I searched here: https://help.salesforce.com/s/articleView?id=sf.mc_as_define_a_triggered_automation.htm&...
- 22.2k
0
votes
0
answers
107
views
Triggering an Automation off an email send
I currently have an automation job set to run every hour to consolidate email tracking data to send to AEP. Im curious if instead of an hourly batch, is it possible to trigger the automation when an ...
0
votes
1
answer
7k
views
How to trigger an automation from another automation
I need to have 3 sets of automation.
The first one is a file drop automation.
Then I have a set of 10 automations which should run after the first one completes.
The final automation should run only ...
0
votes
1
answer
176
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 ...
0
votes
0
answers
121
views
Marketing Cloud Automated Email Send
We are wanting to create a solution within the Marketing Cloud that essentially allows us to input a SubjectLine and Body into a CloudPage, have that CloudPage update our data extension with those ...
3
votes
2
answers
421
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
-1
votes
1
answer
157
views
Is there any way to get the SMS Opt-Outs rate in account level?
Our client want to know sms opt out rate in account level, so that based on results they can plan campaign volume/KPIs.
Let me know is there any OOB features in MC? If no, Kindly let me know feasible ...
0
votes
1
answer
411
views
Contacts without Channel Addesses not working properly Record Count 0
I have been trying to delete Contacts from our Parent BU, which is as far I know the only BU where you can run an Automation with Data Extract "Contacts without Channel Addresses".
The ...
- 2,809
0
votes
1
answer
86
views
Import lots of files from ftp to update datas extensions
I need to import 81 one different files daily, from a sftp, at a especific time, and overwrite the respectives data extensions. How do I do that without building 81 automations? How do I use ssjs to ...
- 31.1k
-1
votes
1
answer
67
views
Automation for birthday adding contacts the day after instead the exact day
we're experiencing some issues with a birthday automation query.
Our query runs everyday and should filter contacts from 2 DE (contacts that are celebrating their birthday on that day) and put it in a ...
- 31.1k
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" ...
- 3,401
-1
votes
1
answer
153
views
Is there any way of automating a Journey to pause?
I would like to know if there is any possibility to automate a Journey to pause without manual interaction in Journey Builder. Has anyone done something similar?
- 14.5k
-1
votes
2
answers
394
views
Creating a "File Transfer"-activity - Keeps loading?
I am trying to create an automation in SFMC and am currently stuck trying to make a new "File Transfer"-activity. All other activities are working fine.
I have tried using different ...
- 1
1
vote
2
answers
4k
views
Update Salesforce object with a Script Activity
I would like to create a script activity in an automation to update a Salesforce Object.
Here is my example script. How can i update I get it accepted as A SSJS script in the Script Activity?
%%[
...
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 ...
- 3,835
-1
votes
1
answer
299
views
Using a Salesforce Data Extension as an entry source in Journey Builder
I have a Salesforce Data Extension in Marketing Cloud that is filtering through people with a specific name.
When I add someone with that name to my list they get picked up by that data extension.
How ...
- 3,835
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 ...
- 22.2k
0
votes
1
answer
93
views
How to get 2nd Saturday of Last Month in Where Clause
I am trying to setup an automation which will run daily and get the data from Capture DE which have a field name 'LastCapture' date type. The data is loaded on 2nd Saturday of each month.
I am trying ...
- 8,336
0
votes
1
answer
226
views
Re-Subscribe contacts who have unsubscribed on contact creation as a result of Journey using salesforce data entry
I have a journey with a SF data as entry source, this journey captures new contacts created in SF using SFMC connector. On Salesforce, when a contact is created, the initial state of emailoptout is ...
- 182
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 "...
- 837
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
-1
votes
1
answer
41
views
Is there a option to query data from the table that displays/stores list of query activities
Is there a option to query data from the table that displays/stores list of query activities ?
Kindly refer the image below. We want to query data from the table that usualy displays all the details ...
- 3,401
-1
votes
2
answers
306
views
Automate seedlist in SFMC
I have a question. We have been having issues making sure our entire DCOM team receives an email after each deployment (our seedlist) Is there a way that I can automate seedlists so i don’t have to ...
- 35
1
vote
1
answer
437
views
Data Extract activity is changing the physical order of records
I have the next issue when exporting a CSV file to a SFTP location:
It's about a daily automation, the process consists in three steps, one for data extract, a second one to convert the file to UTF8 ...
0
votes
1
answer
366
views
Is it possible to run an automation only when a data extension is re-populated with data? Not knowing when data is coming
Background: Currently, we have an automation job where audience is pushed to FTP and automation trigger is based on file drop. When file is pushed with a set naming convention on FTP, automation ...
0
votes
1
answer
89
views
Unable to update a second column value in data extension using wsproxy
I want to pull a data extension DE1 where it has two columns I used wsproxy to copy these column values to another data extension where one of the two column is encrypted and another column needs to ...
- 76
0
votes
1
answer
99
views
How to get records from sendable audience who did not make it to _SENT log without hardcoding the jobid
I have a DE extension where I have saved 1 record by querying:
DE NAME: DataView_Job_DE
Select top 1
JobID
,EmailName
,CreatedDate
,JobType
,JobStatus
,Row_Number() OVER (Partition by jobid ORDER BY ...
- 10.3k
0
votes
1
answer
285
views
How to selecting value from another data extension in select statement in SFMC
I have a DE extension where I have saved 1 record by querying:
Select top 1
JobID,
EmailName,
CreatedDate,
JobType,
JobStatus
from _job
Output is saved in data extension: DataView_Job_DE
Now, I am ...
- 10.3k
-2
votes
1
answer
153
views
My automation is successful even if there is no file placed in FTP
How can my automation be successful even when there is no file placed in SFTP? I have created a support ticket to confirm if there is blank file processing feature enabled, Support replied that this ...
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
1
answer
78
views
Specific Domain SQL Query result incorrect
I am trying to pull list of emails for a particular domain (which is aproblematic domain) and somehow my results does not make a sense--meaning that I'm getting way less than expected. To further ...
- 35
0
votes
1
answer
417
views
How to create a priority logic for email in SFMC based on data
Current Use-case:
We have a data extension with the following fields:
CustomerID
Customer_EmailAddress
Customer_Category
1
[email protected]
Category_101
1
[email protected]
Category_202
2
[email protected]
...
- 819
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
99
views
Automation to create separate data extensions of bounced contacts for each of our Business Units (Marketing Cloud)
I want to run a _Bounce data view in our Enterprise BU (Marketing Cloud), and then filter the data by Business Unit for each of our 120 Business Units. Is there a way to automate it to create one ...
- 22.2k
1
vote
1
answer
118
views
Check for existing records in Data Extension when appending data
We're sending anniversary mails to members every time they've lasted another year with us :)
This is the SOQL appending data to the Data Extension [Anniversary Flow - Trigger]
SELECT
ID as 'Subscriber ...
- 551
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?
- 22.8k