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
-2
votes
0
answers
18
views
Does an automation with various sql activities, on automation studio, still writes on the target Data Extension if the activity gets an error?
What apparently is happening is that my activity on step 3 still writes some records on the target Data extension, despite getting an error (Cannot insert null values). The error is simple and is ...
0
votes
1
answer
38
views
Retrieve Data extensions in Salesforce marketing cloud
I was wondering if there's any way to get all the data extention available in different BUs with created date and last modified data - so I can delete those which are not in use.
Is there any way ...
0
votes
1
answer
41
views
Possible to update a User-Initiated Send to target a different email?
Basically what I'm trying to do is set up an automation with a send definition and be able to update which email that send definition sends out.
Automation runs on a weekly basis so I want to be able ...
- 1
1
vote
2
answers
85
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
79
views
Marketing Cloud export multiple csv files into one zip file
I have 3 data extension that I would like to export into SFTP individually as csv, and then combine them into one zip file. I get exhausted of researching this and thought I ask experts here to help. ...
- 35
-1
votes
1
answer
50
views
HI, I want to retrieve the total number of contacts from Salesforce Marketing Cloud
I want to retrieve the total number of contacts from Salesforce Marketing Cloud. I would like to do this using SoQL and Automation Studio, so that every month I can insert the total number of MKT ...
0
votes
3
answers
75
views
help on Automation SQL query time out
looking for suggestions on how to optimize a query for updating a table with 2M records from a table that has 500k records.
I have a daily automation that has an sql step query that is used to update ...
- 11
0
votes
1
answer
54
views
Using SSJS to change block in an email
I have folder containing multiple emails that share a common block. Is there any way I could build a SSJS script inside automation studio that would automatically change this specific block from all ...
- 11
0
votes
1
answer
64
views
best way to send message to any channel in batch in SFMC
how are you?
I have a flow that at times will need to send at least 1 million messages (in this case emails).
Today there is a transactional api where I can send up to 2000 (500 with attributes) at ...
0
votes
1
answer
74
views
Changing the name of an Active journey
I have a customer journey that is linked to an automation. I want to change the name of this journey, and here are the steps I'm suggesting:
Click on New Version.
Update the name of the version with ...
- 3
-1
votes
1
answer
106
views
Mobile Opt-In campaign
We want to start sending text messages to new leads inviting them to opt-in.
From what I have researched, this cannot be done in Journey Builder and the recommended way is to use the Mobile Opt-In ...
0
votes
0
answers
139
views
SFMC | Create SFTP User | Impact on Existing SFTP based automations
Can anyone explain this warning! which appears while creating a new SFTP User.
Especially what does this 'Default Location' points to?
- 2,040
0
votes
1
answer
34
views
Update a field as 'TRUE' if exist in the other data extensions and 'FALSE' otherwise
I have a data extension A with a field "Exist_in_SF".
I already have records residing in DE A, and I want to update the records in the same data extension with "TRUE" value in &...
0
votes
0
answers
121
views
File drop automation not working (not getting triggered)
I'm trying to transfer .txt file with ; as a delimiter from SFTP server to a Data Extension in SFMC, but my file drop automation is not being triggered when this happens. The process should look like ...
- 1
-2
votes
1
answer
139
views
Trigger automation when row added to Data Extension (without external API)
I want to trigger an automation when a new row is added to a Data Extension.
I can trigger it via the API, but building this trigger inside the Marketing Cloud would be much better because otherwise, ...
- 664
0
votes
1
answer
42
views
Marketing Cloud - SQL Query to Return all Subscribers Who've been sent an email
I want to find out how many of my subscribers (who've been sent an email) have opened an email within the last 5 years. I want to include subscribers who've been sent an email and haven't opened an ...
0
votes
0
answers
53
views
How to make Verification activity not skipping queued automation in Automation studio File drop
I have a file drop automation in marketing cloud with a verification activity in the middle.
3 files will be dropped in the sftp folder location which will trigger and queue 3 instances of this ...
- 51
-1
votes
1
answer
41
views
marekting cloud - can we automate to send all subscriber data to my subcriber list in marketing cloud in order to automation subs-unsub..helpplssss
I have a scenarion where I am not using connector first of all and I am sending my salescloud data account/contact to marekting cloud data extension through rest api.
Now the tricky part is we have 2 ...
0
votes
0
answers
52
views
file drop sftp automation
I am using Cyberduck to access FTP.
Is there any possibility of detecting file drops when downloading files in FTP?
I have had an event where automation is triggered even though there is no evidence ...
- 29
0
votes
1
answer
50
views
Query with Union of two Synchronized Data Extensions
I have a query using a Union to combine two Queries. In the Query editor I run into no errors but when I click finish, I get the error Cannot find table 0. So syntax errors show up so I am lost.
Here ...
- 5
0
votes
2
answers
80
views
Simple Queries - Sent
I'm new to writing queries but I thought this SENT query would be simple. I'm just trying to get All sends for the last 30 days. But when I run the query, nothing populates in the DE and nothing ...
- 1
0
votes
1
answer
101
views
DataExtension.Init not working
I have tried to use DataExtension.Init() several times with no avail. I can see the Data extension in both parent and child business Unit (it lives in the shared data extension folder). I've also ...
- 5
0
votes
1
answer
55
views
Send email only if attachment exists in import SFTP Marketing Cloud
I have an incoming zip file containing multiple csv files. I extract and run an automation activity on a specific file name pattern, this is the master data file containing which file goes as an ...
0
votes
1
answer
163
views
Tracking extract - attributes file
can someone help with including attributes in the tracking extract output?
My goal is to include in the tracking extract an internal list id that corresponds with a subscribers' event. That list id is ...
- 59
0
votes
1
answer
101
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
49
views
Incremental Data Export from SFMC to Adobe CDP
I wanted to talk through the logic for an automation I have, the issue im facing, and hopefully find a solution.
Approach: I have an automation in SMFC that 1)queries for email open data and sends to ...
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
23
views
Update the existing records in DE, which is appended by another SQL with existing automation
I have an automation in which one SQL is appending the dada in Target DE, latter I found that this SQL is not getting values for all fields.
So now I am updating my existing SQL to get values for ...
- 1
1
vote
1
answer
137
views
Removing contacts from a journey via script activity
I've written a script to remove a batch of contacts from a Journey since we've revised our criteria of who should enter. After testing it on a sample set of subscriberkeys, I searched for them in ...
- 309
0
votes
0
answers
42
views
SFMC Mobile Push Demographics - querying LastAppOpen, LastMessageOpen, LastSend, MessageOpenCount
I am working with a client that is looking to query MobilePush Demographics data such as LastAppOpen, LastMessageOpen, LastSend, MessageOpenCount. However, it seems these fields are not found in the ...
1
vote
1
answer
301
views
Marketing Cloud - SSJS Activity timing out. Not sure of error
I have an SSJS Activity I am trying to get to work wherein we are calling an API endpoint using basic authentication (obviously the user and pass are obscured in production). But I am having issues ...
- 11
0
votes
0
answers
152
views
AB Test on Journey Builder
In Content Builder there is a feature called as AB Testing now I created an Email for that AB test and gave a name.If I place that Email in Journey Builder the Subscribers only receiving the ABTest 1 ...
- 21
0
votes
0
answers
80
views
SQL Query to update DE field when "x" hours away from date/time field which is already formatted to the correct timezone
We are working on building a journey that is extremely dependent on utilizing a date/time field (StartDateTime) to determine when emails/sms are delivered. Given the constraints in Journey Builder ...
1
vote
0
answers
71
views
SF Process Builder Retiring RE MCC; what is the impact to activities in the SFMC (i.e., active journeys, automations, synchronized data extensions)?
Do any activities need to be stopped and restarted or will the MCC automate these processes? Are there any delays to be expected?
- 21
0
votes
1
answer
170
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
1
answer
161
views
How to Contact delete (All contacts) in Child BU
Is there a way to do contact delete in Child BU? (All contacts)
I want to delete the Contact in bulk.
All marketing activities (Journey, e-mail sending, etc.) take place in Child BU.
I would like to ...
0
votes
0
answers
31
views
BounceCategoryID from Bounce Dataview field doesn't return the right value to Boolean field
I have problems during SQL that it doesn't retrieve the right value to Boolean field.
Now I extract Bounce DataView and if BounceCategoryID(number type) is 1002,1003 then retrieve 'true' to Spam field(...
1
vote
2
answers
261
views
Transfer XML API response as file to FTP with SSJS
Context: I am looking to implement a daily automated import of a product catalog. I can only access the catalog via an API endpoint that cannot be filtered/paginated and gives ±100K rows of XML as ...
- 190
-1
votes
1
answer
39
views
want to access variable from one activity to another in automation in Marketing Cloud
I want to check whether, can we access the variable which defines at script activity across other steps within the same automation in marketing cloud.
0
votes
1
answer
189
views
Marketing Cloud | Automation Studio | Output SSJS WSProxy to Landing Page or other viewable place
I was trying to follow along with the write up here: https://ampscript.xyz/how-tos/how-to-retrieve-all-shared-data-extensions-using-ssjs/
In doing so, I know the script works, but I notice the write ...
1
vote
0
answers
72
views
Retrieve Activities that aren't being used in any Automations in Marketing Cloud
I'm cleaning unused Automations and Activities from a Marketing Cloud Account and I'm trying to find a way to retrieve the Activities that aren't being used in any Automation using SSJS. I have ...
- 25
0
votes
1
answer
140
views
Query for Subscribers Click Counts and SendLog
I'm in the process of building a query that will give me a count of all links a subscriber has clicked on from recent sends. I have a query written out using the salesforce documentation, and I have ...
- 5
0
votes
0
answers
123
views
Combining SFMC Job, Send and Click Tracking Extracts to create Impression Tracking by Job Report
I am trying to create a custom report in SQL to mimic following 'Impression Tracking by Job Report' in SFMC for all Jobs but currently testing with just one job ID to narrow down my testing by I am ...
- 134
0
votes
0
answers
211
views
How to rename a file on the SFMC FTP?
I am looking for a way to rename a file on the SFMC FTP using an automation. I have tried using the substitution strings %%FILENAME_FROM_TRIGGER_BASE%% and %%BASEFILENAME_FROM_TRIGGER%% with the "...
- 11
-1
votes
1
answer
72
views
Automation data into data extention
I found a script for retrieving automation data on https://www.ssjsdocs.xyz/automation-studio/automations/retrieve/all.html. I still learning SSJS and can't figure out how to store this kind of ...
- 143
0
votes
1
answer
140
views
SSJS code to add existing query activity to an existing automation fails
I am trying to add an existing Query Activity to an existing Automation using a SSJS script.
This is my code. I have referred the doc
<script runat="server">
Platform.Load("...
0
votes
1
answer
367
views
Journey Builder - Automation Schedule and Entry Criteria
I have a very simple journey setup to send an initial welcome email. I am using a multi-step journey in order to utilize the no re-entry criteria, so that new subscribers will not requalify for the ...
- 17
0
votes
1
answer
133
views
Using Einstein STO outside of Journey Builder
I know Einstein STO is designed to use within Journey Builder, but I also know I can use it to send ad hoc emails via an Automation Studio Send Email event.
My question is, once I create that event, ...
- 59
0
votes
1
answer
218
views
SSJS - Delete Row in DE based on another DE with flag
New to SSJS but based on what I've read, it looks like this could be possible. I am trying to write a script that will delete a row in a 'Secondary_DE' based on a defined 'Deleted' flag in a '...
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