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
2
votes
1answer
19 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
43 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
0answers
29 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
32 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
47 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
57 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
34 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
51 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
33 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
22 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
40 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
42 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
23 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
28 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
64 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
41 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
49 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
31 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
14 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
24 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
31 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
15 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
20 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
38 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
39 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
32 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
31 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
30 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
23 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 ...
0
votes
1answer
47 views

Specify a fie path for External SFTP Marketing Cloud

I need to drop a file on an External SFTP from Marketing Cloud which I know I can do with a file transfer activity but I can only choose a pre-defined file destination. In that destination setup in ...
0
votes
2answers
44 views

Inner Join with Data view and data extension in SFMC not working

I am trying to do a inner join with one data extension and the data view _sent, inner join on subscriber key from _sent and contactid from data extension. I want to fetch the max event date i.e the ...
0
votes
1answer
34 views

Send Email from Batch File in SFMC

I wanted to send out the email with Below process, is possible if yes, could you please give me some reference, Create an Email Template in SFMC Load CSV file in SFMC sFTP server (All Personalized ...
0
votes
2answers
59 views

UpdateData AMPScript function not working for Shared Data Extension

I have Data Extension in Child Business Unit which has been shared with Parent Business Unit. This Data Extension has 3 Primary Keys SubScriberKey, JobId, EventDate. It also has a "Processed" flag ...
0
votes
1answer
31 views

How to find a date X% between two dates using SQL [closed]

I need to find what the date is X% between two date fields. The use case is I want to send an email to someone who is 70% of the way through their tenancy. For example, Move-in date = 01/01/20 Move-...
1
vote
1answer
49 views

Joining _JourneyActivity and _Sent Data Views in Salesforce Marketing Cloud

Did anyone here manage to successfully join the data from _JourneyActivity and _Sent data views? The documentation says that they can be joined on _JourneyActivity.JourneyActivityObjectID = _Sent....
0
votes
2answers
40 views

Automate looking up data based on subscriberkey and populating a data extension with extended info

Based on the subscribers website interaction, my guy handling our website can send me two types of data: SubscriberKey RoomOfPreference. I can have him add this data to a pick-up data extension via ...
0
votes
2answers
55 views

Checking for a non ascii character in SQL Query activity

I have certain records in my DE, where the first name contains '�'. I wish to extract such records. Obviously a like wouldn't work. Is there a way to do this in SQL Query Activity.
0
votes
0answers
29 views

One hard bounce should mark subscriber to Held status instead of waiting for 3 bounces to happen. Is it possible in SFMC

Can We mark one Hard bounce to Held status to avoid further bounces to happen and if they update their email address then I should able to mark them Active again. How to achieve this in SFMC
0
votes
1answer
26 views

“Old style JOIN (ANSI JOINs) syntax” error in a simple query without subqueries and joins

Validating the following query: SELECT GetDate() as Valid_From, 'Lorem Ipsum' as Filler FROM SampleSourceDE shows this error: An error occurred while checking the query syntax. ...
0
votes
0answers
45 views

Programmatically adding activities to automation

Creating activities using SSJS, e.g. Query Activities is relatively well described. However, when a newly created activity needs to be added to an existing automation, I fail to find any documentation ...
1
vote
1answer
56 views

Retrieve mobilepush contacts

Is there a way to retrieve SFMC mobilepush contact data/activity history data via ssjs/script that is generated in automation studio? For example, mobile contacts who are opted in who have been in a ...
-1
votes
1answer
46 views

How to create an outbound API call from SFMC using SSJS

Use Case - get data from external web services and store the data (response) inside SMFC data extension field. *New to API Calls - detailed step by step guidance would be really helpful. The ...
0
votes
0answers
26 views

Automation that will start as soon as file get drop on client FTP [duplicate]

I am trying to create File drop automation when the file will get drop on client FTP and automation will import that data into Data Extension. As of now client FTP credential is yet to come, so I ...
0
votes
1answer
33 views

Salesforce Marketing Cloud Query - Count by Date and Appointment Status, Group By CustomerID

I'm not proficient in SQL Query. I'm hoping someone on here can help me write this query for Saleforce Marketing Cloud, which uses a "limited" SQL Server 2016. Problem: I'm trying to extract month ...
0
votes
0answers
36 views

Import Activity Issue

I am facing a very weired issue with my import activity. My client drops a file on FTP everyday with more than 100k records on daily basis. The import was working fine, until since few days it has ...
1
vote
1answer
38 views

SQL Query Timeout Salesforce Marketing Cloud

I have a query running in Automation studio that times out. The dataViewSubscribers data extension contains 20 million users. Is there a way this can be optimised? SELECT ds.emailaddress , case ...
0
votes
1answer
56 views

Create useful Data Extension via Filter Activity in

I am creating a simple happy birthday email sending automation. However I am having an issue with the Filter Activity in Automation Studio. I am unable to configure the Filter Activity to create a ...
0
votes
0answers
25 views

SFMC Audience Builder Audience into Journey

We have just implemented SFMC Audience Builder and I want an audience to be injected into journey builder after it is published. What is the best way to do this? I thought I could use automation ...

1
2 3 4 5
11