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
161 views

Verification to skip an activity in Automation Studio

I have an automation with several activities across 7 steps. This automation is used to update subscriber statuses in our publication lists. We use a vendor for enterprise preferences which syncs with ...
2
votes
1answer
84 views

Saving Server Side JavaScript Functions

Is it possible to create SSJS functions as code resources in Web Studio and then use those functions in other CloudPages or Script Activities? For example, if I created a function that generates an ...
-1
votes
1answer
72 views

Creating an email which populates an image based on Data Extension upload

I'm trying to send a survey to recipients with an image in the email. Ideally I could upload a list to Data extensions that would populate an image and some text. Each row would have an ID that would ...
1
vote
0answers
132 views

Insert a delay of a few seconds in SSJS script after a function call

Use case: Send emails based on personlization data of a few records using SSJS script. I have an email that will pull personlization data of off a non sendable Data Extension. The email will pull the ...
0
votes
1answer
138 views

SystemDateToLocalDate inside SQL Automation

I know the function SystemDateToLocalDate is not available inside SQL but i would like exactly that feature inside an SQL query to convert the Date records of data_views (which are CST Central ...
0
votes
0answers
44 views

Export list of Automations from Automation Studio

Is it possible to export a data file containing all the Active Automations - as much detail as possible. We're actually migrating away from SF and I need to get an understanding of our existing ...
0
votes
1answer
162 views

Do automations have a time limit where they crash?

I am uncertain if this question was asked somewhere but atleast I did not find a post that covers it within a few minutes of searching on documentation and stackexchange. Closest question I found Do ...
0
votes
1answer
33 views

Automation Studio create activities via REST API

I need to create and save an activities with REST API in Automation Studio. How can I do it? many thanks
0
votes
1answer
87 views

Automation Studio: create a new automation from PHP

I'm very new about Salesforce and Marketing Cloud. I've seen it's possible to use two sets APIs (REST and SOAP) to interact with it. In the official MC documentation Web Services SOAP API are used to ...
0
votes
1answer
111 views

Is it possible to trigger a file drop automation with a file transfer activity?

I have a file drop automation in place that enables me to remove a contact record and all other records that are related to that contact from my data model in Contact Builder. The import file for this ...
0
votes
1answer
196 views

Script Activity error in Automation Studio

I'm trying to run a Script Activity to update specific fields of a Lead in Salesforce (Marketing Cloud connector is already configured and working properly). Once I click on 'Validate Syntax' it ...
2
votes
3answers
54 views

Optimize a query that is timing out

I have two data extensions that I need to join and filter. One stores member data for a product, the other stores opt-in status for all products. The DE with opt-in status can have multiple instances ...
0
votes
1answer
79 views

Remove Special Characters SQL

I am currently trying to run an SQL qeuery that strips out special characters and then adds a '1' in front to have all numbers correctly formatted. For what ever reason my REPLACE doesn't seem to work ...
1
vote
2answers
183 views

SFMC Automation Studio to download CSV into FTP

How can I use SFMC automation studio to download a csv from a site into the import ftp folder and import that csv into a data extension? Do I need to use SJSS? Or is there an activity that does that ...
1
vote
1answer
45 views

SQL Won't Populate Salesforce Data Extension

I am trying to dump data from a Salesforce object into a Salesforce Data Extension. I am not getting an errors but the data refuses to populate. I can't figure out what I am doing wrong! I have tried ...
1
vote
1answer
87 views

What is the correct syntax for using “Begins With” when setting a Filename Pattern in an import automation?

I am new to Salesforce and I am trying to setup an import automation. I am having trouble figuring out the correct syntax when using the "Begins with" option in the filename pattern. The docs say you ...
1
vote
1answer
273 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. ...
1
vote
1answer
48 views

Generic System Error when I use a Left Join

I'm creating an automation that uses a series of SQL queries to identify people who were potentially targeted for a dynamic content block in an email, determine if they were included in a job that ...
2
votes
0answers
75 views

Left Join query

I'm trying to left join a table in Marketing Cloud Automation Studio Query. I don't receive any errors but the expected data is not pulling into the data extension. The bolded statements are what are ...
0
votes
1answer
972 views

Marketing Cloud Data Extract into the correct File Encoding format

I have created a Data Extract activity exports a .csv file containing records from my Data Extension. The file is in the wrong File Format so I have requested Salesforce activate additional encoding ...
0
votes
2answers
249 views

Does IsUnique in the _Click data view dedupe subscribers over multiple jobs?

I want to write a SQL query that will find the total clicks and unique clicks for 1 URL across multiple email sends. Total clicks is easy, but I'm not sure about the unique clicks. I want to basically ...
3
votes
3answers
141 views

How to identify object type using contactkey in marketing cloud?

I've synchronized two objects (from sales cloud) as Contacts in salesforce marketing cloud. These two objects are "Lead" & "Account" and both are mutually exclusive. I want to update bounce ...
0
votes
1answer
523 views

Marketing Cloud SSJS: trying to automate contact deletion

with the GDPR laws in place, it's important to have the possibility to remove contacts from Marketing Cloud. I'm trying to automate the process with existing tools and am looking for possible ...
0
votes
1answer
73 views

Marketing Cloud Automation Studio Scripty Activity getting time out

We have script activity which is posting (HTTP post) messages to another system. However, Script activity is getting time out after 30 mins as per default timeout setting. Is it possible to override ...
0
votes
1answer
122 views

SQL Convert String to Integer

In our Marketing Cloud instance we have a column that is a string and needs to be converted to an integer. I have tried the following query but get the following error: Query: UPDATE TableName ...
0
votes
1answer
145 views

Automation Studio and Journey Builder - Unsubscribes

I've created a Journey that has a data entry source that feeds from an SQL query in Automation Studio that runs daily. The Journey sends three emails, a week in between each send. I am unsubscribing ...
0
votes
1answer
163 views

How to use a SFMC SJS Script Activity to pull data with httpget and then store it in a Data Extension?

I have figured out how to use HttpGet to display JSON directly in an email body, but instead I want to store this JSON data from an external URL in a data extension, and then use AMPscript lookups to ...
0
votes
1answer
28 views

Score Lead Account based on email opens / clicks from Marketing Cloud

Overview We have some custom 'scoring' fields on leads, accounts. The actual 'score' comes from a custom settings field and users get a score based on opens, clicks, etc and campaign; some campaigns ...
1
vote
1answer
129 views

Resubscribe to Publication List

I have an automation that extracts a specific set of records, daily, with the end goal of having their status in a publication list updated from 'Unsubscribed' to 'Active.' All steps of the automation ...
0
votes
0answers
82 views

Create Automation using Fuel SDK API in node.js

I need to create an automation in Marketing Cloud using fuelSDK-node. I cannot find any documentation regarding the same but I got documentation for .NET code Can anyone please help me with the same?
2
votes
1answer
76 views

Automation Studio - Imports old file data or same data into Data extension again in file Drop automation with import activity?

Actually, I created File Drop automation to import data into Data Extension. I dropped different files into the same file location. After the completion of automation flow - it imports data of the ...
1
vote
2answers
227 views

Journey builder, best practices in marketing cloud post journey completion

What are the best practices for a journey, post completion in marketing cloud. In marketing cloud, once a journey is complete i.e. all communications have been delivered, tracking is available and ...
0
votes
1answer
37 views

Query Deleted Subscriber in All Subscriber List In MC

Is there a way to query MC to identify if a subscriber was deleted from the All subscriber list at any point in time? Thanks
0
votes
1answer
22 views

Multiply two fields if an ID is found in a separate table

Trying to create a Data Extension where we calculate the total spend in a category, if the category exists in a list of promotional categories. The point is that we want to provide an offer when a ...
0
votes
2answers
50 views

Week Number, where week starts on Monday (not Sunday)

I'm trying to calculate the number of new subscribers, unsubscribes, held, etc, by week where the week starts on Monday and ends on Sunday. I can get the query to work fine when the week starts on ...
1
vote
2answers
199 views

Marketing Cloud update activity fails for primary key violation

We have a daily Update query activity that is failing because of a primary key violation on the email field. I'm confused by this because I thought an Update activity should, well, update the target ...
0
votes
2answers
71 views

Why is my code querying All Subscribers producing results that don't exist in All Subscribers?

In Marketing Cloud - I'm trying to write an SQL that will pull everyone who has opened an email in the last 90 days. I'm getting results from the below SQL, but when I spot-check the data, I'm finding ...
0
votes
1answer
65 views

Showing Error while joining two synchronized data extensions in automation studio

I am trying to query two synchronized data extension and update the result to a data extension select O.CloseDate,O.StageName,O.Id, P.Contact__c.Id,P.Id From Plot__c_Salesforce P Join ...
0
votes
2answers
177 views

Marketing Cloud: Automation Studio Email to Sales Cloud Contact

I'm needing to send a couple emails using automation studio (we aren't paying for journey builder) to Contacts that are entered into Sales Cloud that match certain criteria. Here are the steps I've ...
1
vote
1answer
180 views

Marketing Cloud Automation studio won't update data extension

We are having trouble updating records in a data extension from an automation. It creates new records but it won't update. We have the salesforce custom object ID set up as the primary key and the ...
1
vote
3answers
344 views

How do I move a Filtered Data Extension automation based off a Synchronized DE?

So, I've created several Data Filters off our Data Extension for the purposes of segmenting our audience. I've been manually refreshing these filtered DE's whenever sending, but I'll need to automate ...
1
vote
0answers
277 views

What's wrong with this “HTTP.Get” in SSJS?

In activities I am running this script: <script runat="server"> Platform.Load("Core", "1.1.1") var NewReq = HTTP.Get("http://samplesite.com/sample.html"); </script> It always throws ...
0
votes
1answer
43 views

Journey Builder

Is it possible to trigger a journey when i only have the record id in the data extension and that record id is also present in the CRM and i need to fetch the email address from CRM and trigger a ...
1
vote
1answer
198 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 ...
1
vote
2answers
161 views

SSJS Error - Retrieving data from two DataExtensions and want to update the initial DataExtension

Anybody an idea what is wrong with this script? It is my first SSJS script in the automation studio but I just get the error message: An error has occured. I got the functions from the documentary. ...
1
vote
1answer
811 views

Query From Shared Data Extension

I have a shared Data Extensions across multiple Business Units. I need to run a query from it in a Child BU but every time I try to run I get "× An error occurred while checking the query syntax....
0
votes
1answer
67 views

Possible to REPLACE/REPLACE and then CAST a DE value in a SQL query?

We're writing SQL for an Automation to find orders that qualify for a promo based on spend. The source DE has a TEXT field with a dollar sign $, the order value and some HTML <br /> - i.e., $...
0
votes
0answers
47 views

Can't CAST TEXT field successfully into a DECIMAL (18,2) data type

Client is looking to send a coupon for any orders over $250. However, they are passing the order value as a TEXT field, not a DECIMAL. I'm trying to run the query by using CAST, but no luck. I've ...
1
vote
1answer
103 views

Two automations using the same file drop

Has anyone been successful in triggering two automations from one file drop? I'm testing it and it seems to be corrupting something on the back end. As soon as I try to create a second automation ...
3
votes
2answers
1k views

Updating All Subscribers from Data Extension

Is there a way to update a record in the AllSubscribers List from a Data Extension Import? I'm hoping to set up a daily automation that imports data file into a Data Extension on the subscriber key ...