Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [automationstudio]

The tag has no usage guidance.

0
votes
0answers
15 views

Marketing cloud sql query execution error - Violation of PRIMARY KEY constraint

I'm getting following error during update activity. Query failed during execution. Error: Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'Enq_opp_Parallel_ContactView'. The ...
-1
votes
1answer
22 views

Retrieve all sends to a specific records in Marketing Cloud

How the query shall look like if we want to retrieve all emails a specific contact received?
3
votes
1answer
34 views

Query association to automation viewable?

Is it possible to see which automation a query activity is part of?
0
votes
0answers
17 views

How to access Report FTP Folder in Automation Studio?

I saved a Account Send Summary report from "Analytics Builder" > "Reports" to FTP using the option "FTP Result". I can only choose the option "ExactTarget Enhanced FTP". How I am supposed now to ...
3
votes
0answers
41 views

Update Marketing Cloud Automation tasks with SOAP API returns “OK” response but doens't update

I'm trying to update the AutomationTasks of an automation in Marketing Cloud with the SOAP API. The docs don't indicate whether this is possible (the example SOAP envelope for updating an automation ...
2
votes
2answers
42 views

Remove characters after @ in email address and replace with new domain

I have four brands that all use different email domains however our SF only has one email allocated per user with a random branded domain. eg usera@brand-a.com also uses @brand-b.com, @brand-c.com and ...
0
votes
0answers
13 views

Error on completion of Data Extract and File Transfer

I'm currently experiencing an error on the Automation Studio with related to the Data Extract - One of the activity get failed by "Error has occurred" and File Transfer - one of the activity flagged "...
0
votes
1answer
25 views

How to perform lead conversion activity based on the email click in marketing cloud?

I want to send an email to my leads with a clickable button with unique url. I want to put a trigger base activity which converts lead into opportunity as soon as user clicks on that button. I know ...
0
votes
1answer
49 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
38 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
35 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
39 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
54 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
20 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
35 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
12 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
37 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
36 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
47 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
43 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
30 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
57 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
31 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
30 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 ...
0
votes
0answers
48 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
35 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 ...
1
vote
0answers
30 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
152 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
61 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 ...
2
votes
2answers
84 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
152 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
34 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
60 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
69 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
58 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
24 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
49 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
32 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?
1
vote
0answers
44 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
116 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
24 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
21 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
36 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
78 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
37 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
40 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
89 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
0answers
86 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
120 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
125 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 ...