Stack Exchange Network

Stack Exchange network consists of 174 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.

1
vote
1answer
28 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
12 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
0answers
15 views

Frequent automation failure

I am facing an issue with the automation, one particular automation will get failed frequently as there are other automations which are running in the similar time. Can someone help me with this? how ...
0
votes
1answer
30 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
35 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
66 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
69 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
24 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
36 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
40 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
41 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
22 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
29 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
21 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
36 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
52 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
22 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
33 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
58 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
1answer
22 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
32 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
60 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
62 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
59 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
65 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
0answers
32 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
66 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
45 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
117 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
39 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
30 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
37 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 ...
1
vote
2answers
212 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 ...
0
votes
1answer
42 views

can I get a list of all customers who have not opened any emails for the past 3 months in SalesForce Marketing Cloud

May I ask if you have any ideas on how can I get or pull a list of people who have not opened any emails for the past 3 months?
0
votes
1answer
41 views

How to get the Exclusion List via SQL Query in Automation Studio

I need to exclude List to whom the particular email has been sent previously from Automation Studio via SQL Activity (Data views). select distinct s.SubscriberKey from _sent s ...
0
votes
1answer
37 views

Dont stop subsequent activites in Automation if step fails

I have an Automation which has a series of activities, one of them being an import of a file into my Subscribers list (after being generated by SQL and a data extract). After the import is completed ...
0
votes
0answers
43 views

Send to Salesforce Data Extension using Automation Studio

We need to automate the send to Salesforce Data Extension. For that, i have created a Salesforce Send Definition. Now i need to automate this send. I went Automation studio to achieve this but could ...
-1
votes
1answer
20 views

Sending data from Marketing cloud Data Extension to External Database on real time

My requirement is to update external database real time or equivalent to real time from my Data Extension. My Data extension get updated on a basis on real time so now I want the same to be happened ...
0
votes
1answer
41 views

SQL Query Openers Fail

I am trying to run a query of all of our email openers that are older than 64.5. My SQL looks right but I keep getting the following "Automation failed due to system error." is this on my end or on ...
0
votes
1answer
44 views

SQL count not working as expected

I have a query that aims to pull counts for: total subscriber records, total for each subscriber status, total optins, total optins for each source, total unsubs, total unsubs for each source. I am ...
0
votes
1answer
112 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
1answer
182 views

Automation Studio File Drop source from external FTP

Setting up an automation to occur on file drop but it appears the only options for directory choice are in the import folder or the legacy triggered automations folder. The file that I'm dropping ...
0
votes
1answer
21 views

Managing FTPs for multiple business units

I've run into an issue with the amount of licenses I have available to use in out ETL generator (Dell Boomi). Using this to push data into a 5 different business units and file dropping to the ...
0
votes
0answers
46 views

Help with Automation studio Query - Primary Key Constraint

Getting the following error: Query failed during execution. Error: Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'LIVE_ClearToClose'. The duplicate key value is (...
1
vote
1answer
124 views

How to improve this SSJS

Recently started to learn SSJS and wrote the script (for automation studio) which is located below. What i am interested in is: How can i improve this Server Side JavaScript performance wise? For ...
2
votes
1answer
101 views

Optimizing SQL queries

I've set up an automation that resends an altered version of a mail to all who recieved it the first time it was sent, but didn't open it. This is done in Automation Studio using 3 SQL Query and a ...
0
votes
1answer
27 views

Data Filter in marketing cloud

I have a question related to data filter. Can we check the filtered record into marketing cloud? I created an automation with below activities - Query activity: This activity will update my sync ...
0
votes
1answer
89 views

How to setup Birthday Email on Automation Studio?

I want to send a birthday email. So I already connect both the cloud and get the record of contact object into the sync data extension and I also created a standard data extension in marketing cloud. ...
1
vote
1answer
31 views

Promotional Email to Sales Cloud contacts using Automation Studio [closed]

I want to create an automation which will send email to all the contacts from sales cloud. So it will be a promotional holiday email like (Fathers day , New year ,Good friday etc). I already connect ...