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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
20 views

how to use child standard object data in the personalized mail while your journey salesforce data entry event is on parent object

I am creating a journey for which the entry event is a salesforce data event on a contact object. But I have to use child object field data in the mail to personalize the mail. For example Parent ...
user avatar
  • 1
0 votes
0 answers
14 views

what are limitation of synchronised data extension and where I can use synchronized DE [closed]

I have to create a welcome journey and a birthday journey. I have a synchronized data extension for all the required objects but there are multiple limitations to synchronized data extension. ...
user avatar
  • 1
0 votes
0 answers
22 views

APIProperty PartnerProperties for Activities Object

I would be so grateful if someone can help me with the below issue. I am trying to retrieve a list of all automations with Activities and activity types using the Retrieve function from Marketing ...
user avatar
0 votes
0 answers
23 views

How can I add a query activity on a running automation to start a new journey?

I am new at Marketing Cloud, so I am sorry if this is a silly question but I could use some help. I have an automation running with a query activity to combine different objects and populate a Data ...
user avatar
-1 votes
0 answers
32 views

How to look up Configuration DE to determine a specific destination DE to import the file [closed]

This is SFMC >> Automation Studio question : I need some help for a quick PoC to take an input file that lands into SFMC SFTP, look up a configuration DE to determine a specific destination DE ...
user avatar
0 votes
1 answer
22 views

Sql query to exclude related records in dataset

I am attempting to create an sql query in salesforce marketing cloud...I have a list of email addresses, the number of products they own, and the associated product codes. I would like to set up the ...
user avatar
0 votes
2 answers
81 views

How to track time spent in each stage of a custom detail object

So we have a custom detail object which uses a custom stage picklist field which we use for the path. We also have a custom status picklist field with values as unclaimed, In progress and completed to ...
user avatar
  • 53
0 votes
1 answer
15 views

Missing records after Marketing Cloud FTP Export in my local file

Today I did an Enhanced FTP export from a Data Extension that was holding 8,498,752 records with 166 MB. In the Enhanced FTP directory, a file for it was generated with the size of 203,632 KB. I ...
user avatar
0 votes
0 answers
17 views

Retrieving SQL Query Activity status with SOAP API returns "OLE DB provider unable to begin a distributed transaction" error

I need to know when a SQL Query Activity is done and ran without errors. Therefore I check the status every 10 seconds until it's completed based on the following solution: Checking the Status of the ...
user avatar
  • 1
0 votes
1 answer
27 views

Using constants in SQL Query activities?

for a particular automation that runs daily I have several SQL query activities that rely on the same integer in their SQL queries, a hardcoded "-1". Sometimes I need to manually run this ...
user avatar
0 votes
1 answer
28 views

ERROR: Query failed: Timeout in automation studio

I am running the query many times and keep receiving Time out error. Please help me to solve the issue. Below is my sql query. SELECT Opp.Id AS OpportunityId, payer.id as contactid, Payer....
user avatar
  • 55
0 votes
1 answer
35 views

Testing retrieving Automation Statuses in Batches. Error looping through results

I'm building an automation to retrieve the latest statuses for a number of specified automation instances. The flow is something like run SJSS to retrieve all statuses for the automation instance and ...
user avatar
  • 103
1 vote
1 answer
34 views

Running a script on row update or addition in marketing cloud

I have a DE in marketing cloud which has fields for marketing permission.The permission should be sent to an external database using an api whenever a new row is added or updated.I have to use server ...
user avatar
0 votes
1 answer
26 views

Can you pull unique documents into a email? [duplicate]

Is there anyway that when you send a email out you can attach a document which is unique to that person? As an example, sending 100 people each their own unique document with their personal ...
user avatar
  • 1
-1 votes
0 answers
18 views

How to extract unsubscribers from a particular data extension? [duplicate]

In a Data Extension, there are 5200 records, only 3000 received Emails,i want to know the reason, why 3000 records only received Emails?what happened to remaining records?
user avatar
0 votes
0 answers
22 views

SFMC Automation Studio Email Activity running (not errored) for over 12 hours

I have an automation that includes 2 email sends in step 4 and 2 email sends in step 5. The automation was activated about 18 hours ago and all of step 4 executed, and one of the email send activities ...
user avatar
0 votes
0 answers
33 views

Identify Query Activities within Automation using ssjs

I am trying to identify all the activity queries within an automation using ssjs. I came up with the following code but it seems not working rightnow. Have you guys ever had this problem? Did you ...
user avatar
0 votes
1 answer
28 views

SQL to see records if their value in one column has changed

I have the following four columns: DATE_OF_FIRST_SUB_AEST (the first time a person purchase a subscription, eg: 2008) Subscription_ID (Can have multiple subscriptions in the past, so multiple ...
user avatar
-1 votes
1 answer
33 views

Getting error message "Violation of PRIMARY KEY constraint. Cannot insert duplicate key "

Getting error while running this query in automation, customer key is set to be the Primary key. Below is the code : Select A.ContactKey, A.AccountId , A.ContactId , A.CreatedById , A.Email, A....
user avatar
  • 1
-2 votes
1 answer
33 views

How to retrieve the last 15 mins SMSSubscriptionLog records based on OptInDate using SQL Query?

I have a scenario that i need to retrieve the last 15 mins SMSSubscriptionLog (data view) created/updated records based on OptInDate using SQL Query. I will store the results in the created DE. If we ...
user avatar
  • 3
0 votes
1 answer
31 views

To get data of all automations created in BU with their status

I tried below code to run in my BU to retrieve records, but it does not publish anything. <head> <style> body, a, input, td, th {font-family:sans-serif; font-size:12px;} </style&...
user avatar
0 votes
1 answer
35 views

Creating Welcome Email in Automation Studio

Fairly new to SFMC, I don't have access to Journey Builder and want to send a 'Welcome Email' to a DE that captures subs from a signup form. How do I send out an every hour, recurring email to those ...
user avatar
0 votes
0 answers
35 views

Update date time in SFDC using SSJS and ampscript

I am trying to update the date time field in service cloud using automation studio script activity. So the code is updating date and time after automation is completed but the problem is minutes are ...
user avatar
0 votes
1 answer
41 views

SQL Does Not Apply In Automation

I want to know the behavior that when you apply the changes in the sql outside the Automation, It will be applied automatically in Automation? Ex. Automation[A] has sql activities. I did want to stop ...
user avatar
  • 5
0 votes
0 answers
35 views

Issue when creating a Data Extension within shared folder using SSJS

I could create a Data Extension successfully within any folder inside Data Extension parent folder using the below code. But when I do it for Shared Data Extension, I am not successful, could anyone ...
user avatar
0 votes
1 answer
40 views

Records duplicated on SQL Join (Marketing Cloud)

I'm trying to return the results of subscribers who have been sent emails, when they've been sent, if they've opened/clicked and whether or not is house bounced/they've unsubscribed. I'm using the ...
user avatar
0 votes
1 answer
22 views

Marketing Cloud SQL LinkName starts with instead of contains

I'm trying to use a query to identify LinkNames that start with a specific name, (Example_), but as a failsafe I don't want them included if the Example_ falls anywhere in the string other than the ...
user avatar
2 votes
0 answers
44 views

Unable to update Data Extract activity via /automation/v1/dataextracts/{{dataExtractDefId}}

I am facing an issue where I am not able to update the DataExtract (File Convert) activity via Rest below API in SSJS script activity. In the API response I am getting below error API Responsse : {&...
user avatar
0 votes
1 answer
83 views

SQL Query Timeout Help SFMC

I have the following query that is consistently timing out for the last few weeks. It had ran perfectly fine since 2019, previously. I know the query needs to be optimized, but I don't see anything ...
user avatar
1 vote
1 answer
40 views

How to use an SQL resultset as the name of a Data Extension in a query

I have two Data Extensions one with a field that contains the name of another data extension SetUp DE ID Audience 01 bigAudience 02 smallAudience smallAudience DE PersID 00001 00002 I would ...
user avatar
  • 13
0 votes
0 answers
33 views

Create Automation Studio Activities Custom Role

I have created a custom role which should be able to access Automation Studio Activities (CRUD). I have already granted permissions for Automation Studio, Subscribers, Activities and Shared Data ...
user avatar
0 votes
2 answers
54 views

SQL: deduplicate multiple rows by field 1 while keeping multiple row values for field 2 [closed]

I'm trying to deduplicate the following dataset so it can be used in a MC journey (Customer is currently showing multiple rows based on Contact ID). I want it so that there is only 1 row for each ...
user avatar
0 votes
0 answers
41 views

Convert function with date formatted as text

I have a DE1 with field named 'DATE_A' with datatype text. This field contains records that are formatted like this: yyyy-mm-dd hh:mm. Using sql query activity I should retrieve records with field ...
user avatar
  • 71
0 votes
1 answer
29 views

How to Unassociate Campaigns from Automations in Marketing cloud? [closed]

We have some automations which were tagged to a wrong campaigns. Now I dont find a way to un-tag/ unassociate those campaigns. Is there any way to do it via APIs or SSJS? I could not find anything on ...
user avatar
0 votes
0 answers
22 views

Email triggered 5 minutes before status changed to "DOCS OUT"

I have a journey builder that is taking DE from an automation process. It is running every 1 hour(7AM,8AM,9AM.....) The automation is having SQL queries and it segments the customers whose credit ...
user avatar
0 votes
2 answers
41 views

SQL query to add incrementing number for each group [closed]

I would like to create a SQL query in automation studio that adds an incrementing number to all animals of the same type. This is my current data extension: UID Animal 1 Cow 2 Pig 3 Cow 4 Bird 5 ...
user avatar
  • 5
0 votes
1 answer
48 views

SQL help needed - Marketing cloud

have a query that I would appreciate some help on, I'm not too sure why its not working. Select ContactID , CASE WHEN Special_credit = '0' AND Credit_Check_Status__c = 'Approve' THEN 'SENT' ...
user avatar
1 vote
0 answers
86 views

Is there a way to automate (API, SSJS script, etc.) stopping the journey when the last contact exits?

I am currently working on a case where I need to work on automating to stop the journey when the last contact exits it. It would be much easier to just manually stop the journey. However, I need to ...
user avatar
0 votes
0 answers
83 views

Correct Date format on import - Getting errors when importing csv file

I am getting constant errors when importing a csv file into marketing cloud. It seems that no matter which date format I choose, the file still errors although most of the records go in, but not all. ...
user avatar
  • 63
0 votes
1 answer
55 views

Can Auto-Suppression Configurations be targeted via SQL Query activity?

Auto-Suppression Configurations (ASCs) are actually Data Extensions behind the scenes. This can be established by retrieving all DEs in a BU, or by retrieving a specific auto suppression using the ...
user avatar
0 votes
0 answers
101 views

How instantly send email when record enters to Data Extension?

Who can explain in detail how to do so that when a record enters to the Data Extension (from DE Manager form), an email is instantly sent to her? I read this article, tried to set up api events, tried ...
user avatar
2 votes
0 answers
48 views

Sending multiple SMSes to a subscriber who has more than one number?

I'm using an Automation, a Data Extension, a Outbound Message to send SMS to customers. The data is using Salesforce Contact Id as Subscriber Key, and this data may have more than one record has the ...
user avatar
  • 136
1 vote
1 answer
88 views

Marketing Cloud - Decrypt File - "Secret key not found in key data"

We have an integration that is sending a .pgp encrypted file to our Marketing Cloud FTP. Once the file is dropped into our /import folder, we are attempting to import and decrypt, it into Marketing ...
user avatar
0 votes
1 answer
42 views

Workaround for SSJS activity that stop and pausing issue

I have this snippet that works partially (trying until 2000 records), but the automation or the cloudpage stop and finish before processing all the data; How to work with WS PROXY with the functions ...
user avatar
  • 43
2 votes
1 answer
119 views

Can you move Automation Studio activities to different folders programmatically?

I am currently trying to programmatically sort out Automation Studio activities (e.g. Email, SQL Query, Filter, and Script activities) into designated folders. I have started with Filters, based on ...
user avatar
  • 2,294
-1 votes
1 answer
72 views

File Drop Automation can't work

I have an automation triggered by File Drop. when the file is dropped , it will be imported to a staging data extention(overwrite). now here is an odd thing: when I upload a file name as "...
user avatar
0 votes
0 answers
19 views

Insert Data of SSJS result into Data extension [duplicate]

I've below script where it retrieves the automation status, I want to insert this data into a Data extension. How could I achieve this?.. I tried below this way.. but getting internal server error. ...
user avatar
-2 votes
1 answer
51 views

Query Editor and Automation Studio [closed]

I am fetching records using a query involving _Open and _Subscribers Data views. When I run it in Query editor, it is able to return results within 20 minutes. The same query when run as a SQL query ...
user avatar
2 votes
0 answers
44 views

SSJS Script Activity Fails to Update DE

Issue: Target DE, CustomerOrders, is not updating with the expected output, OrderId and CustomerId for all Orders. However, the script runs with no errors and logs the Success DE and the Error DE. DE'...
user avatar
0 votes
1 answer
177 views

Contact deletion in Child BU

I've successfully processed contact deletion in Parent business unit, but I'm having trouble with setting automation program for deleting contacts in Child BU. As far as I know, the contact deletion ...
user avatar
  • 5

1
2 3 4 5
15