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
1answer
24 views

Automation to exit contacts mid-journey [closed]

I'm looking to create an automation that exits contacts contained in a data extension from an active journey. I came across the contact exit API documentation (https://developer.salesforce.com/docs/...
1
vote
1answer
382 views

Problem to Updating All Subscribers via Import Activity

I have a sync data extension and I want to update records in All Subscribers. I've completed these steps using automation: Data Extract Activity; A File Transfer Activity to put the file in FTP; An ...
0
votes
0answers
22 views

Import file name into DE as field value

Do you know if it is possible to 'read' a file name from a triggered automation/import activity and then use the string in the filename to populate a field in a DE in which the records from that file ...
0
votes
1answer
18 views

Specify a fie path for External SFTP Marketing Cloud

I need to drop a file on an External SFTP from Marketing Cloud which I know I can do with a file transfer activity but I can only choose a pre-defined file destination. In that destination setup in ...
0
votes
2answers
37 views

Inner Join with Data view and data extension in SFMC not working

I am trying to do a inner join with one data extension and the data view _sent, inner join on subscriber key from _sent and contactid from data extension. I want to fetch the max event date i.e the ...
1
vote
1answer
56 views

Update multiple data extensions

I have 15 data extensions. All of the data extensions have 2 important columns (OpenId, ContactId) I need to update ContactId against OpenId for all Data Extensions. Is there any way to do it?
0
votes
1answer
25 views

Send Email from Batch File in SFMC

I wanted to send out the email with Below process, is possible if yes, could you please give me some reference, Create an Email Template in SFMC Load CSV file in SFMC sFTP server (All Personalized ...
0
votes
2answers
46 views

UpdateData AMPScript function not working for Shared Data Extension

I have Data Extension in Child Business Unit which has been shared with Parent Business Unit. This Data Extension has 3 Primary Keys SubScriberKey, JobId, EventDate. It also has a "Processed" flag ...
1
vote
1answer
28 views

Joining _JourneyActivity and _Sent Data Views in Salesforce Marketing Cloud

Did anyone here manage to successfully join the data from _JourneyActivity and _Sent data views? The documentation says that they can be joined on _JourneyActivity.JourneyActivityObjectID = _Sent....
0
votes
0answers
56 views

CreateSalesforceObject AMPScript method is failing

I am using Cloud Page to sync Marketing Cloud Data Extension records from SFMC to Salesforce CRM custom Object. I am using CreateSalesforceObject AMPScript method to create salesforce object. ...
0
votes
1answer
30 views

How to find a date X% between two dates using SQL [closed]

I need to find what the date is X% between two date fields. The use case is I want to send an email to someone who is 70% of the way through their tenancy. For example, Move-in date = 01/01/20 Move-...
0
votes
2answers
38 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 ...
0
votes
2answers
43 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.
0
votes
0answers
25 views

One hard bounce should mark subscriber to Held status instead of waiting for 3 bounces to happen. Is it possible in SFMC

Can We mark one Hard bounce to Held status to avoid further bounces to happen and if they update their email address then I should able to mark them Active again. How to achieve this in SFMC
0
votes
1answer
21 views

“Old style JOIN (ANSI JOINs) syntax” error in a simple query without subqueries and joins

Validating the following query: SELECT GetDate() as Valid_From, 'Lorem Ipsum' as Filler FROM SampleSourceDE shows this error: An error occurred while checking the query syntax. ...
0
votes
0answers
39 views

Programmatically adding activities to automation

Creating activities using SSJS, e.g. Query Activities is relatively well described. However, when a newly created activity needs to be added to an existing automation, I fail to find any documentation ...
-1
votes
1answer
32 views

How to create an outbound API call from SFMC using SSJS

Use Case - get data from external web services and store the data (response) inside SMFC data extension field. *New to API Calls - detailed step by step guidance would be really helpful. The ...
1
vote
1answer
45 views

Retrieve mobilepush contacts

Is there a way to retrieve SFMC mobilepush contact data/activity history data via ssjs/script that is generated in automation studio? For example, mobile contacts who are opted in who have been in a ...
0
votes
1answer
31 views

Salesforce Marketing Cloud Query - Count by Date and Appointment Status, Group By CustomerID

I'm not proficient in SQL Query. I'm hoping someone on here can help me write this query for Saleforce Marketing Cloud, which uses a "limited" SQL Server 2016. Problem: I'm trying to extract month ...
0
votes
0answers
30 views

Import Activity Issue

I am facing a very weired issue with my import activity. My client drops a file on FTP everyday with more than 100k records on daily basis. The import was working fine, until since few days it has ...
0
votes
0answers
25 views

Automation that will start as soon as file get drop on client FTP [duplicate]

I am trying to create File drop automation when the file will get drop on client FTP and automation will import that data into Data Extension. As of now client FTP credential is yet to come, so I ...
1
vote
1answer
31 views

SQL Query Timeout Salesforce Marketing Cloud

I have a query running in Automation studio that times out. The dataViewSubscribers data extension contains 20 million users. Is there a way this can be optimised? SELECT ds.emailaddress , case ...
0
votes
1answer
34 views

Create useful Data Extension via Filter Activity in

I am creating a simple happy birthday email sending automation. However I am having an issue with the Filter Activity in Automation Studio. I am unable to configure the Filter Activity to create a ...
0
votes
0answers
22 views

SFMC Audience Builder Audience into Journey

We have just implemented SFMC Audience Builder and I want an audience to be injected into journey builder after it is published. What is the best way to do this? I thought I could use automation ...
0
votes
0answers
32 views

Setting up birthday emails

What's the best way to initiate a birthday trigger campaign in SFMC, i'm fairly new to this process and i wanted to see what is the best route to take. The email cadence is fairly simple and i want to ...
0
votes
2answers
24 views

Can I access Content Builder API using script activity in automation studio? If yes, is there some good documentation that I can follow?

I wanted to use the marketing cloud REST API using script activity to perform various tasks such as uploading content in content builder, changing the customer key for that content based on values in ...
0
votes
1answer
25 views

page Action in pardot not working

Please help me I created a page action in pardot so that i can track that page view but it is not working "https://netrocon.com/how-to-get-the-most-out-of-pardot-page-actions/" is the link that i ...
0
votes
0answers
30 views

Script Activity Outputs

I creasted a SSJS in Marketing Cloud under --> Automation Studio --> Activities --> Script , I was curious to know how I can view the results of Write statements in the script? I am able to store data ...
0
votes
2answers
539 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 ...
0
votes
1answer
29 views

Updating click and open data in salesforce from journeys

I have a journey in marketing cloud and few email steps in them each one week apart. I would like to check the open and clicks of email sent before sending the next email so that the data can be sent ...
0
votes
2answers
47 views

Skip records with duplicate Primary Key while querying data using SQL activity in SFMC

I am trying to query some specific email activities using SQL Activity and Data Views in SFMC. I am trying to fetch data from Subscriber, Sent and Job data view. I need EmailName, EmailAddress, ...
0
votes
2answers
34 views

Salesforce Marketing Cloud - Stop Automation Activity based on Run

In Salesforce Marketing Cloud, I'm trying to determine a way to stop or pause an automation if it's run within a certain amount of time. Essentially, there's a Marketing Cloud bug where a single file ...
1
vote
1answer
732 views

Query Journey Builder Sends

I want to run a query to pick up all subscribers who received a JB email in the last 7 days from a specficic Journey. I found this article but it is not filling the data extension! https://help....
0
votes
0answers
29 views

Create an automation Wait activity via API

Is it possible to create a wait activity step in an automation via preferably SOAP API or I know there is an undocumented REST API. Could a single wait activity be used on multiple automations?
0
votes
0answers
29 views

Node SDK Create an Automation

I'm trying to create an Automation with the Node Fuel SDK. I can create an empty one, but I can't seem to specify the <ActivityObject xsi:type="QueryDefinition"> part. I'm not sure how you ...
0
votes
1answer
66 views

SQL query from _subscribers is not retrieving any records

I have below SQL query in Automation: select top(10) emailaddress , dateunsubscribed , status , subscriberkey , subscriberid from _subscribers It doesn't populate any records in Data Extension ...
1
vote
2answers
664 views

Can I move files between Marketing Cloud FTP SUB-folders?

Our usecase: after import we want to move a file (using automation) from one (enhanced)FTP sub-folder to another(enhanced)FTP sub-folder (archive). The sub-folders are both in the main folder \import. ...
0
votes
0answers
23 views

SQL Query Activity Update vs. Overwrite Target DE

I have a scenario in which we: SQL Query to Sendable DE. SQL Selects Contacts based on a specific Status. Fire an event in an automation to inject to a Journey We need to hold the injected contacts ...
0
votes
1answer
30 views

SQL NOT LIKE PARAMETER

I have the below queries in my automation. Query 1: SELECT s.SubscriberKey, FORMAT(DATEADD(hh,6,s.EventDate),'MM/dd/yyyy hh:mm:ss tt') AS EventDate, s.JobID, s.batchID AS BatchID, s....
0
votes
1answer
24 views

CC in Marketing Cloud - Send All Campaign Members the same Email - all in CC ? (Marketing Cloud)

We're trying to automate Client Meeting Notes sent from Marketing Cloud without leaving the CRM; The recipients are SF Campaign Members who constitute the Key Stakeholders of the meeting. An ...
0
votes
1answer
47 views

ERROR: Query failed: Timeout SFMC

Anyone knows what is the cause of the error in my Stuff SQL? i run the query many times and keep receiving this error. This query will get all the ProductCode based on every customer and i want to ...
0
votes
1answer
15 views

Automation Studio - Will Fire Event wait for SQL query to complete?

I have an automation in which I have to run an SQL Query to update a DE, and then notify Journey Builder for the eventually added contacts. 2 questions please: Provided I do it in a one step ...
1
vote
2answers
38 views

How can I remove my company's email address from a data extension?

How can I remove my company's email addresses from a data extension? and add then to a new data extension. If I'm supposed to use a SQL query, can you help me with that? I want to remove a few ...
0
votes
1answer
50 views

SQL Query for getting distinct domain and count

I have a Data Extension which has email address. I want to store all distinct domains and counts of these emails in another DE For eg: I have someth@som.com, test@test.com, 123@test.com. So my o/p ...
1
vote
1answer
532 views

How to import records into Marketing cloud from Salesforcce

I want to import records in Marketing cloud from Salesforce objects or reports because I'm not able to see the option of IMPORT in the interactions tab in Marketing cloud?
0
votes
1answer
740 views

Query Journey Goals and Exits

There appears to be little documentation around these functions in Journey Builder, so hoping someone may have some insight. Can this data be accessed through the Journey Data Views or any other ...
0
votes
2answers
55 views

Marketing Cloud: Removing multiple rows from a data extension via SSJS [duplicate]

In Marketing Cloud, we would like to remove multiple rows based on the EmailAddress column, which is the primary key in our permission data extension. Now, we tried using the code snippet for Server-...
0
votes
1answer
27 views

Adding contacts and leads to a DE and receive a Violation of PRIMARY KEY constraint error message when running query

I'm attempting to add leads and contacts into a DE from a synced data extension that receives contacts and leads when a quiz is completed. The quiz can be taken multiple times which is why there is a ...
0
votes
1answer
38 views

Tips for using SQL skills efficiently in Automation Studio [closed]

As a Marketing Cloud marketeer I really see queries as very powerful in creating strong segments. So, I've dived into SQL and query writing using codeacademy and w3schools, but even though I find ...
0
votes
1answer
41 views

Data extract 'Delete file from ET FTP or Safehouse' not deleting file on enhancedFTP

The Data Extract Type 'Delete file from ET FTP or Safehouse' is enabled in the account and I have created the Data Extract Activity. However, when I am running the automaton, it is not deleting the ...

1
2 3 4 5
11