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
-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
0answers
26 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 ...
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 ...
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
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 ...
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
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
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
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
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 ...
0
votes
1answer
42 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
2answers
45 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
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 ...
0
votes
1answer
25 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 ...
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
59 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
59 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 ...
2
votes
1answer
50 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
52 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 ...
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
38 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
71 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. ...
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 ...
2
votes
1answer
35 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 ...
1
vote
1answer
30 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
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 ...
0
votes
2answers
50 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 ...
0
votes
0answers
7 views

Change the FTP Folder for File Import Error Text Files

When a "File Import" Activity fails in an automation or completes partially with few errors. Automatically the Text file including the error records and error reason is pushed to the /Import ...
0
votes
1answer
27 views

SQL Query returning null values for Boolean fields from Data Extension

I have 2 Standard Data Extensions and an automation written to get values from one DE to other. The issue I am facing is Boolean values from one DE is not copying exactly in the other DE. False values ...
0
votes
1answer
33 views

Is possible to increase timeout for automation studio?

I have several SQL activities that are facing timeouts and I would like to know if it is possible to increase the time to get timeouts and why? Thanks
0
votes
0answers
142 views

Salesforce Marketing Cloud - Making REST API Call to send data from marketing cloud to External

I have coupon details in marketing cloud . Once email is sent out of Marketing cloud via journey,i need to send email sent date to external . Post journey acitivty i'm planning to trigger ssjs ...
0
votes
2answers
50 views

Why are JobIDs missing from _Job Data View?

We have pulled out email history from _Open Data View. However, for most records - TriggererSendDefinitionObjectID is empty. To understand which email was opened, we had no choice - but match on ...
0
votes
2answers
67 views

How to query Last Opened Date, Last Send Date, Last Clicked Date from _Open, _Click and _Send Data Views

Recently, I have queried the subscriber tracking information from data views for _Open, _Click and _Send Data Views and the final data extension holds the Unique Contact Data (Criteria : contact ...
0
votes
1answer
24 views

Query activity returning rows that it shouldn't

I have a query activity that is returning rows that it shouldn't I'm guessing there is a problem with my sql but cannot figure it out. The idea of the query is to create a 'dormant' list, with these ...
0
votes
1answer
44 views

Exporting a file from a data extention automation in salesforce marketing cloud

There is a database extension in salesforce marketing cloud that I need to export from the automation. I didn't create the DE and am unsure how to export it for use outside of salesforce marketing ...
0
votes
0answers
15 views

Get Number of Files in Queue for Triggered Automation

Is there a way to get the number of files in queue for File Drop Automation? I have a constantly running file drop automation and I'm planning to create a dashboard (cloudpage) to show how many files ...
0
votes
1answer
34 views

SFMC Backup data view into DE: error Cannot insert a NULL value into a non-nullable

I'm trying to backup the data views, using automation. As they get deleted once in 6 months, and we need the data. I have following the files and PK according to the documentation: documentation But I ...
1
vote
0answers
38 views

Save %%FILENAME_FROM_TRIGGER%% as field value

Is there a way to get the value of %%FILENAME_FROM_TRIGGER%% from an import activity and save it somewhere, maybe in a DE? I am building a dashboard (cloudpage) that will display what file is ...
0
votes
1answer
16 views

Why does my conditional average query return 0 in MC Query?

I have a table that I am trying to calculate average values based on conditional statements. I have used conditional statements before so I know the function is supported, but for this particular ...
0
votes
0answers
21 views

Trying to retrieve status of Automation in a particular folder

I am trying to retrieve status of all Automations in a particular folder in my instance. I am using the below code. However, I can see in the output that the category id is null. I am expecting a ...
0
votes
1answer
39 views

SQL Case Statement

I'm trying to write a SQL Query for the below. I have list of email address in table. I need to pull Subscriber key associated to that email address from another table if that email address is not ...
0
votes
1answer
45 views

Havving issues updating fields in Data Extension with SSJS

In Marketing Cloud -> Automation Studio -> Script Activity, I am trying to run a script that updates a column named "age" (dtype: integer) based on another column named "date of birth" (dtype: date). ...
0
votes
1answer
34 views

Schedule Automation using script activity

I have a case where I built a file drop automation that contains an import followed by a script activity. Inside this file I'll be uploading a date. If the date matches current date, I want one ...
0
votes
2answers
33 views

Create an automation without a PK

I'm trying to create an automation with a file import to update a data extension. The problem is that my data extension doesn't have a PK and in order to create a query activity to populate the data ...
0
votes
1answer
32 views

What is the best way to export journey audiences?

I would like to understand if there is a standard best practice to export the list of subscribers enter a journey whose audience is refreshed in a daily basis (and, as a plus, to combine that ...
0
votes
0answers
26 views

Import file name into DE as field value

Do you know if it is possible to 'read' a file name from a triggered automation/import activity and then use the string in the filename to populate a field in a DE in which the records from that file ...

1
2 3 4 5
12