All Questions
Tagged with marketing-cloud automation
194 questions
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
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, ...
- 11
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 '@...
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
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
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
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 ...
-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&...
- 837
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
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 ...
- 957
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 ...
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
-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 ...
- 11
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 ...
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 ...
-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 ...
- 1
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
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
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?
- 1
-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
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
-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 ...
- 1
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
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 ...
- 557
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 ...
-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 ...
-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 ...
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 ...
- 353
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 ...
- 1
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 ...
- 353
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 ...
- 353
-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
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]
...
- 353
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 ...
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
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?
1
vote
1
answer
453
views
Update Marketing Cloud Automation tasks with SOAP API
I'm having some issue with something I'm trying to do using SOAP,
What I want is to add a Task to an existing automation, the documentation shows how to update the name but nothing else. I want to add ...
- 13
0
votes
0
answers
154
views
Data Extract definition change filename pattern
Can I programmatically change Data Extract definition? I cannot find any example.
I am looking for something similar to QueryDefinition change example:
var qd = QueryDefinition.Init('my_definition'),
...
- 148
0
votes
0
answers
60
views
UpdateSingleSFObject function is not working correctly
I need help with my code snippet. It's part of an automation that first of all use a query to get the emails from contacts that I need to update in Salesforce CRM. Next to get the emails, I execute a ...
- 1
0
votes
0
answers
423
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
99
views
How to Create Testable DE from Existing Filtered DE?
Have some filtered DE's from Synchronized DE's. I need to test these audiences and would like to create filtered/duplicate's for testing as a snapshot in time to test. The issue with these filtered DE'...
2
votes
2
answers
790
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
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
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
1
answer
731
views
how to use SSJS to extract all distinct values (may require looping) and push it to sql query in marketing cloud?
I am new to SSJS and have not used it yet.
I have a use case where I need to extract JobID and Data Extention Name from SendLog Data Extension.
I use JobID and DE_Name in SQL query but right now I ...
- 353
2
votes
0
answers
363
views
How to manage automation via ampscript API - second part
I would like to close the discussion thread on this related topic Manage automation via ampscript API. If you have additional information to complement it would be great to hear on the answers!
Here ...
- 123
0
votes
1
answer
2k
views
SQL Error - "Field name cannot be blank"
We are trying to run the following query:
SELECT
a.nihrm__BookingContact__c as "BOOKING_CONTACT",
a.Name as "ACCOUNT_NAME",
b.Email as "EMAIL",
b.FirstName as "...
- 1