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

Removing surplus characters in a Phone Number column in Marketing Cloud using SQL

In Marketing Cloud, we receive phone numbers from our CRM in a following format: +3xx yyyyzzzz or 003xx yyyyzzzz. We would need to remove the extra '+' or '00' as well as the extra spacing inserted ...
0
votes
2answers
26 views

SFMC Query Error “An error occurred while checking the query syntax. Errors: Error while parsing query. Please check the syntax”

I am creating this SQL query in Automation Studio. This query gives me an error: An error occurred while checking the query syntax. Errors: Error while parsing query. Please check the syntax When ...
0
votes
0answers
44 views

SSJS failed to process 500K records

The script activity is getting timeout while processing 500K records. I have 2 data extensions. First data extension: Contains the 10 programs mapped to each account numbers. Account number is primary ...
-1
votes
3answers
38 views

error message on sql: “Violation of PRIMARY KEY constraint. Cannot insert duplicate key.”

I'm getting this error for the SQL below: Violation of PRIMARY KEY constraint. Cannot insert duplicate key. Select DISTINCT SubscriberKey, Source From ( Select Email, ...
1
vote
1answer
53 views

Customer enter directly to day 10 rather than going through day 1,2,5

I would like to know, if it is possible for a customer to enter the journey at later date and continue the journey from that day. Example - I am going live today, my journey is scheduled from Day 1, ...
1
vote
1answer
515 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
22 views

Marketing Cloud SQL Query - Removing Rows containing certain values

So I'm trying to query data extension Data123, and I want to grab all rows where Email_Address doesn't contain 'TEST'. I thought the proper syntax would be Select * from Data123 Where Email_Address ...
0
votes
0answers
22 views

SQL activity fails in Automation

I have a DE with 5 Primary Key columns. We are trying to insert data into DE by the SQL activity in Automation Studio with UPDATE Data Action. First time the data was loaded correctly, second time ...
1
vote
0answers
39 views

Can suppression lists be updated from Automation Studio?

Our Marketing Cloud hierarchy consists of 170 child business units and a single parent business unit. Local marketing emails are sent from the 170 child business units. We track opens and clicks in ...
3
votes
3answers
2k views

Can Automation studio be scheduled less than once a hour

Due to one of the critical requirement, we would need to run the automation studio, less than once a hour. Has anyone have an idea if Salesforce support would be able to enable running automation ...
2
votes
1answer
51 views

SMS opt-out using mobile connect import activity

We are using a mobileconnect data import activity in automation studio in order to opt-out contacts orignited from another external marketing platform. We have noticed that after importing those ...
0
votes
2answers
812 views

Marketing Cloud_ImportFile Activity error

We're trying to import a csv fial in a file-drop-to-our-FTP scenario and subsequent import file activity. We're keep getting this error sent by Marketing Cloud upon executing the automation: Results: ...
0
votes
1answer
17 views

Is there any way to identify filter in creating new Filter Activity?

I have this situation when I saved a filter to list in either Mobile Studio or Contact Builder with the name of a list (pic.1 above). When I try to create a Filter Activity in Automation Studio for ...
0
votes
1answer
35 views

How to delete rows from DE based on another DE

I'm a bit new to SSJS so I'm having trouble understanding how I would go about this. I've started by referencing this: https://sprignaturemoves.com/prune-rows-data-extension-ssjs/ I created two Data ...
0
votes
1answer
27 views

Automation Studio SSJS execution context

I have a Script task in Automation Studio that sends a small JSON payload to a rest api. The payload consists of the business unit, the Automation job name, a status and timestamp. My account has ...
0
votes
1answer
32 views

Admit contact to journey via API if entry source is Data Extension

We have a Journey set up with a Data Extension as the entry source with an automation. Now we are exploring the possibilities to admit contacts to the same journey via the API on an ad-hoc basis. So ...
0
votes
0answers
32 views

Data Extract File Convert activity throwing error

While converting File format from UTF-16le to UTF-8 in Automation studio using Data Extract (File Convert), I am getting error but not able to understand what error is coming as Automation Studio ...
1
vote
1answer
360 views

How to create an Automation Studio exclusion AMPScript to filter the users of the last hour?

I would like to send an email to the users of my Exact Target list after a certain amount of time. In order to do this, I set up a workflow in Automation Studio with a Send Email task. Inside the ...
2
votes
1answer
234 views

Import contacts SFMC via API vs FTP

We are implementing SFMC for a client without Salesforce CRM but with a legacy loyalty database where all the 1M+ contacts live. My proposal is to do an hourly job to send the changes in a csv file to ...
0
votes
1answer
971 views

SSJS Functions in Automation Studio

I am trying to create a Data Extension using SSJS Script through Automation Studio. My script is as follows: <script runat="server"> platform.load("core","1.1"); var deObj = { "...
0
votes
2answers
46 views

Tracking Extract via SOAP API - where to find exported file?

I'm trying to perform a Tracking Extract via the SOAP API and all seems fine from the API response. However, I'm not sure where I should find the file (in this case shorttimespan.zip). Should it be in ...
0
votes
1answer
44 views

SQL query Error Violation of PRIMARY KEY

I run this SQL Query Activity SELECT a.Id, a.Active__c, a.Age__c, a.Email, a.FirstName, a.Salutation, a.PreferredLanguage__c, a.HasOptedOutOfEmail, FROM ent.Contact_Salesforce_43 a LEFT JOIN ent....
0
votes
1answer
30 views

Issue Merging Two DE's with SQL in Marketing Cloud Automation Studio

For some reason I cannot figure out how to merge elements of two DE's into one for use in journey builder using SQL. For reference, I work with a higher ed org, and we're looking to bring in contact ...
0
votes
1answer
27 views

How to put in SQL to see only records that in the field do not have specific data in the marketing cloud?

I am facing a problem when trying to filter the leads and contacts that come from CRM to be used in email marketing. The idea is that the filter does not add people who have the field conta.Name equal ...
1
vote
1answer
31 views

_Journey Data View query only listing Journeys with a VersionNumber of 1

I've been attempting to join up a query between the _JourneyActivity and _Journey data views on VersionID but am noticing that I am unable to successfully Join up on anything beyond a VersionNumber of ...
1
vote
1answer
901 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
19 views

Change Import File Logic

Is there a form to change the logic for IMport File in Automation? Everyday i received a file that named with the day -1 (eg: today i received a file like invoice_20200812). I want to import the data ...
0
votes
2answers
60 views

Using a sql query in Marketing Cloud to update a date (birthday) value in the DE to the date this year

I have an automation (running monthly) which adds records into a data extension if their birthday falls within the next month Records are then added into a journey which uses the Birthdate date field ...
0
votes
1answer
60 views

SSJS API call to retrieve XML and parse it

We need to perform following using SSJS in Automation studio: We need to do a API call to get a XML response. We need to parse that that XML response and store values in data extension. I am are ...
0
votes
2answers
36 views

Where does automatically refreshed DE go?

I've been trying to create an automation in Automation Studio to refresh some Data Extensions based on a simple filter. https://help.salesforce.com/articleView?id=000320525&type=1&mode=1 At ...
1
vote
2answers
808 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. ...
2
votes
1answer
55 views

Retrieving Contact Key on MobilePush Demographics

I need Contact Keys of contacts on MobilePush Demographics. Can someone explain how can I manage to retrieve Contact Key on the custom attribute on MobilePush Demographics? I've tried these, but none ...
0
votes
1answer
53 views

Why is my RowNumber partition creating duplicate rows on the same information

I need to allow entrants into a journey in Journey Builder multiple times depending on the country of their booking and then preserve the entry and exit dates at a country level. I have created a ...
0
votes
2answers
215 views

How to Setup an File Drop Trigger for an Automation via the API?

I created an automation triggered by a file drop in SFMC using the API but the file drop section still needs to be configured. The closest thing to an answer I could find was this post in which ...
1
vote
1answer
570 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
829 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 ...
1
vote
0answers
34 views

Import Activity is failing

Am getting this error in the import activity Results: Inserted: 0 Warnings: Warning: Import aborted while processing Batch 10 in DsvFileSourceReader. One or more errors indicating why the ...
0
votes
2answers
39 views

Query performance | stuck if more than 2 joins are in sql query

I'm trying to get Total number of clicks per each URL for Newsletters and joining 3 data views: click, job and sent. The query was successfully executed when I tested with 2 joins on click and job ...
0
votes
2answers
50 views

I am trying to update a field of a data extension via SSJS within a script in automation but it does not update me

Platform.Load("core","1"); var subs = DataExtension.Init('cambio_estado'); var data = subs.Rows.Retrieve(); try {for (var i = 0 ; i < data.length ; i ++) { var ...
0
votes
0answers
72 views

Data export: Views vs Tracking Extract

If we have to make a choice at this moment, on which process we are going to use to extract daily campaign data from SFMC to an external data warehouse, what would be the best (future proof) solution. ...
2
votes
1answer
36 views

automation studio - daylight savings

I have automations scheduled in EST in automation studio. Emails cant send during these automations. Users were told not to send at 5am and 5pm EST. They reporting since daylight savings earlier this ...
0
votes
0answers
38 views

Marketing Cloud Automations Failing - Transfer Activity - Eye Symbol

We started experiencing a group of automations failing. Automations that hadn't failed in the past but for some reason began to fail upon the file transfer activity. When I look at the file transfer ...
0
votes
2answers
59 views

Mass remove records from suppression list

I have a case where I am being requested that any record that has received an email in the last 3 days needs to be suppressed from additional emails. This includes single mass sends, and any journey ...
1
vote
1answer
32 views

Using Overwrite for SQL Query Activity on DE for Journey Builder

If a DE is used as the entry for Journey Builder, and that DE is updated daily using an SQL Query in Automation Studio, using the Overwrite option, upon refresh will existing contacts keep re-entering ...
1
vote
1answer
89 views

Journey Builder is not pulling the correct data from data extension

I have a journey which is not pulling data from our data extension correctly. The data in the data extension is correct but the email that has been sent out has a previous value. I update the data ...
1
vote
2answers
49 views

How can I get conversion stats via SQL in Marketing Cloud?

I can get this data using Extract Data in Automation: https://help.salesforce.com/articleView?id=mc_as_create_a_data_extract_file.htm&type=0 but I was wondering, If I can get clicks via SQL with ...
-1
votes
2answers
164 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 ...
0
votes
2answers
74 views

Randomly select 5 rows from a synchronized Data Extension

I am wondering if it’s possible to randomly select 100 rows from a Synchronized Data Extension over 500 thousands records, without adding extra columns to it and using ampscript to do so at send time? ...
0
votes
1answer
3k views

Date manipulation Function SSJS

I want to delete the records from Data Extension based on Date Field in my DE i.e. I want to delete record which were created date before 30 days.But I didn't find date manipulation function in SSJS ...
0
votes
2answers
53 views

Is there a way to log specific rows with bad data from an Import Activity in Marketing Cloud?

So I have an import activity, bringing in approximately 72 rows into a table. When I run the automation with "Skip rows with bad data" checked, I import 70 out of the 72 rows. I can manually ...

1
2 3 4 5
12