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

Recycle bin in marketing cloud / SOAP call active objects

I'm using a SOAP call to perform an SQL Query and I get this error: QueryDefinition was unable to queue this task. This query definition is not active My call : <RetrieveRequestMsg xmlns="http:...
4
votes
1answer
4k views

Making a REST API call from a Script Activity in Automation Studio

We are trying to update a service cloud custom object from marketing cloud. Can we make a REST api call within a script in Automation Studio.It will be great if someone in this forum can confirm they ...
1
vote
1answer
349 views

Send/Create an SQL request for Marketing Cloud with SOAP API

I'm working on a custom activity for JourneyBuilder in nodeJs and I need to make an SQL request like in automation studio to make a process easier. I found the package node-saleforce where you can do ...
2
votes
2answers
684 views

Remove subscriber(s) from list via script

I'm pretty new at SSJS, but I'm trying to run a script in automation studio that removes a subscriber from a list via the unsubscribe function (see: https://developer.salesforce.com/docs/atlas.en-us....
2
votes
1answer
813 views

Create a data extension with the number of clicks and opened emails

I'm working on a feature for marketing cloud and I need to create a Data Extension with those fields : NumberOfOpenMails,NumberOfClicks and all the other fields relative to the subscriber. I found ...
1
vote
1answer
346 views

MC - Script Activity - Can I add/update/upsert some content to a DE using a Script Activity?

I have a script in SSJS that works fine inside a CloudPage (I use it for debug). For some unknown reason the same script doesn't work in Script Activity inside the automaton, without any error and ...
0
votes
2answers
51 views

Why is the email field getting imported to a data extension as text?

I use an import activity + automation studio to import the data from a salesforce report to marketing cloud daily at a given time in the morning so after importing it an email can be sent to those ...
1
vote
1answer
70 views

How many concurrent import activities to DE

In the documentation here it is said: Concurrent Imports to a Data Extension ,Normal: 1, Aggresive: 2, Extreme: 3 or more. Does anyone know if it means that its not recommended to perform 3 or more ...
0
votes
1answer
67 views

Find Missing Date Ranges in SQL

Is there any way to Find Missing Date Ranges in SQL? Basically, I'm trying to find out how I can identify any missing days the last 3 months. I've already got a list of dates and volumes but unable ...
2
votes
1answer
885 views

What timezone is used for Data Extract Activity filename date placeholders/parameters and is it configurable?

Assume we have a Data Extract Activity in a SFMC Automation workflow. In those activities, you can specify the output filename with date parameters/placeholders: Enter a file naming pattern so that ...
1
vote
1answer
2k views

Journey Builder Automation Audience - Journey entry activity

Can I have multiple Journeys reference the same automation for entry into those journeys? I know that's not BEST practice, but we have an onboarding campaign that utilizes "accelerators" if the ...
2
votes
2answers
439 views

How do I cancel an automation from a script being run by the automation?

I have a scenario where we want to send the same email from multiple business units every day. The email should get updated daily, but I wanted to have a check in the automations in each business ...
1
vote
1answer
146 views

Violation of Primary Key - SQL query

I'm copying a data view (_unsubscribe) to a standard data extension so I can view it and manipulate it for our preference center. It a simple query but I'm getting a violation of primary key error. ...
1
vote
0answers
40 views

Import Activity locking file before import starts

I have created an automation that has an Import Activity from my SFTP. What we have noticed is that the automation seems to have been writing over the file prior to the automation running (it's set to ...
0
votes
1answer
216 views

Why is my UpdateDE function in AMPscript not working?

I'm sending a mail using automation studio. In the mail content I included this line of AMPscript: UpdateDE('Orders',1,'FactSalesHeaderSurrkey',FactSalesHeaderSurrkey,'InvoiceSentDate',NOW()) After ...
0
votes
1answer
673 views

Salesforce Data Extensions not available for Contact Builder Data Model

Why are data extensions in Salesforce Data Extension folder/sub-folder not available to be added in the contact builder data model? Is this a very specific design restriction? To the best of my ...
1
vote
1answer
453 views

SQL Statement to insert a count by email and date

I have an issue which I'm trying to solve. We contact customers a number of times during an application. We don't count how many times we call them. I want to get an SQL statement which this by date. ...
1
vote
1answer
20 views

Error in the Date that appear in SMS

I have a DE with the field PaymentDueDate, and I used convert in the query to when it fills the field it doesn't show the hour, but only with the day. For example, I have the day set to 31 May 0:00 (...
1
vote
1answer
473 views

Import Automation for Mobile Studio [Solved]

I'm creating an automation to import people from a CSV list into a MobileConnect Contact List. I've created the Import Definition. After i dragged "Import Mobile Contacts" to "Step 1", i got empty SMS ...
-1
votes
1answer
54 views

Getting Top X % based on total spend

What do you think is the best way to extract from a Marketing CLoud Data Extension the top 10 Percentage of customers based on total spend (CustTotalSpend). The bottom 15 percentage also based on ...
2
votes
1answer
1k views

Marketing Cloud Journey Builder tracking data isn't returning to Salesforce

We configured Marketing Cloud Connect v5 to sync data between Salesforce and Marketing Cloud. Everything works fine. I can send individual emails in Sales Cloud, using Marketing Cloud Email templates. ...
1
vote
1answer
286 views

Salesforce Marketing Cloud to Salesforce Send Tracking (Non Journey Builder Sends)

I researched this topic through Salesforce and was able to find only one thread as attached below Automation studio send email and sending tracking to salesforce The reply from Kenneth suggests that ...
0
votes
1answer
460 views

Replacing first two digits in a phone number using SQL

I'm trying to replace the first two digits of the phone numbers we store from a 61 to a 0 using a SQL automation in Marketing Cloud, however, nothing has worked so far. The field name is ...
2
votes
2answers
352 views

Multiple “Journey Entry: Audience” steps in an automation?

Is it possible for one automation to have multiple "Journey Entry: Audience" steps? I have an automation that will be running a few queries, and from there I want some contacts to enter Journey A, and ...
1
vote
1answer
139 views

SQL set default when no row returned | Data Views

I am running SQL activity which grabs rows from last 2 hours. However, there will be instances when there is no rows found in last 2 hours and I'd like to set Default values in that case. Attempt 1: ...
0
votes
1answer
2k views

Marketing Cloud SQL to update Data Extension

I'm trying to update a DE in marketing cloud based on a query in Automation Studio. It validates and appears to run when I click Run Once but my target DE never updates any records. I'm relatively new ...
1
vote
2answers
2k views

SSJS to delete rows from a data extension via a lookup table

Is there a way to delete selected rows from a Data extension(MASTER_DE) by looking up another data extension as a lookup (to identify the subscriber keys that need to be deleted) using SSJS? I have ...
0
votes
1answer
192 views

MobileConnect Import Definition to create new list each time

I've just started using an automation which imports a list of MobileConnect contacts into a list called SMS_Master. The mapping works fine and the file drop trigger works great. However, we run ...
2
votes
1answer
213 views

Primary Key Violation where there is no violation

I have a primary key violation occurring where there is no duplicate record within the target extension, nor the source extension (which is a synchronized data extension). Data Action type is ...
1
vote
1answer
78 views

How to exclude a positive record on a related, but negative record in SQL Query?

I'm trying to make a query that checks to see if a user's value for [PaperlessBillingOptIn] is equal to "N" for a promotional email for a new feature. However, because users can have multiple records ...
0
votes
1answer
348 views

Schedule SFMC Automation via API

If I try to schedule an automation I use Schedule method and works perfectly if I'm working on the parent business unit of an enterprise account. If I try to schedule an Automation that is created on ...
1
vote
0answers
19 views

Filtering link tracing/checking from click data extracts?

In early February, my company noticed a significant uptick in click activity in our data extracts. Deliveries, opens, bounces, and everything else remained normal. I opened a ticket with SFMC ...
2
votes
1answer
199 views

Date and Time function not usable anymore

Good day, I use in Automation Studio, an SQL query using functions like dateAdd() and Datediff(). Since yesterday, this activity is errored with this message : " An error occured while checking the ...
0
votes
1answer
1k views

Journey Builder with updated data

I have an onboarding journey that helps clients activate their new SaaS product. We send them a series of 5 emails with next steps and accelerate them through the journey if they do more than 1 of ...
0
votes
1answer
305 views

Deleting records from a DE 3 months after they are added

I want to write an automation which deletes records from a certain DE after the present date is 3 months after their date_added attribute. I know this is possible with DELETE FROM and DATEADD() in SQL,...
0
votes
1answer
71 views

Automation Studio - Query Activity: _Subscribers.EmailAddress not populated for any record

I am trying to run an SQL query (below) to get a list of all Clicks for all Jobs that were started this year, but I'm having some difficulty querying the Email Address associated with each click. ...
0
votes
1answer
47 views

Same-day email-specific reporting

Default send reports allow a date window of the previous full day. I need to be able to automate a report that pulls the deliverability of an email shortly after it sends. Is this possible?
0
votes
1answer
978 views

SQL Incorrect syntax near ')'

I'm trying to write a SQL query in a marketing cloud automation studio activity SELECT * FROM [table 1] WHERE [field 1] IN ( 'a2F6F000002WUVmUAO', 'a2F6F000002WTqbUAG', '...
1
vote
1answer
409 views

Possible to query _ListSubscribers and _EnterpriseAttributes and not use All Subscribers?

I have an E2.0 account with parent/child MIDs and I'm trying to pull in a population for a Journey. When I combine _ListSubscribers with _EnterpriseAttribute and declare ListID = 'All Subs List ID" ...
0
votes
1answer
387 views

how to set the TimeZone

I am trying set the time zone in ScheduleRequest its not working but automation is scheduled timezone is not set its taking default time zone this is my code <soapenv:Envelope xmlns:soapenv="...
0
votes
1answer
110 views

Customer Journeys with varying cadence

With my current client, I find a lot of their journeys (in non-SFMC terminology - these can be built in Journey Builder or Automation Studio, or both) are focused around delivering a certain number of ...
0
votes
2answers
250 views

Create automation folder using soap api

How to create automation folder through soap api.i used below code for creating automation folder but i am getting error. how to achieve this requirement could you please give clear info about folder ...
2
votes
1answer
4k views

SQL Query in Marketing Cloud Today = date

I'm trying to query using a where clause such as this: WHERE Today = a specific date . This is what I have right now: DateAdd(day, 0, GetDate()) = '2018-02-12' (because it was 2/12 when I posted/...
0
votes
1answer
359 views

Add clicked link's alias to Data Extension

I've got an Automation populating a Data Extension with all clicks for an email send, but I need to append the alias for each link as well. Is there any way to achieve this? I can't see any way to ...
0
votes
1answer
58 views

Best way to pull real-time email data, but also allowing enough time for an email to gather tracking

I need advice on best way to pull daily tracking data from SFMC. I currently have a set of monthly queries that run on the 1st of every month and pull in tracking data to a data extension. This works ...
0
votes
1answer
908 views

Is there a System View for Mobile Connect Contacts / Subscribers?

For Email All Subscribers, we have _Subscribers data view and I am looking for similar data view for All Mobile Connect Contacts. Basically, i would like to access all mobile numbers with their ...
0
votes
0answers
170 views

URL Concatenation is not working in the content area generated by SSJS

URL conacatenation is not working in the content area generated through SSJS script .The scenario is we are generating a content through SSJS and its stored in the content area and its then pulled ...
0
votes
1answer
250 views

Creating new Portfolio object through SSJS but the status shows error

I am trying to create a portfolio object in the scrip activity using SSJS portfolio add function.I am following this link for creating portfolio but the status shows error. var newPortfolio = { ...
1
vote
1answer
250 views

Use a Not in for insert in Marketing Cloud Sql Query

I need to add only unique rows to a data extension even though the same row in source data extension might keep being pulled. In Automation studio if the same primary key is pulled it errors the ...
1
vote
1answer
553 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?