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
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
19 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
0answers
21 views

Salesforce Marketing Cloud Unsubscribe from “All Subscriber” List? [closed]

When a user click on unsubscribe from email template user will get a email saying you are unsubscribed but at the same time user should get unsubscribe from "All Subscribers list"?
0
votes
1answer
25 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
-1
votes
0answers
40 views

What are Considerations/limitations for making REST API call from Script activity? [closed]

I'm new to SFMC so would appreciate any help. I'm trying to make REST API call from SSJS script in automation studio as an extension to Journey builder to send data related to journey . Scenario : ...
0
votes
0answers
37 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
35 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
30 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
26 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
19 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
27 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
35 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
34 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
29 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
22 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
36 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
40 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
27 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
47 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
36 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
38 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
47 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
28 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
25 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
41 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
48 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
42 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
31 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
34 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
34 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
42 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
23 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 ...
0
votes
0answers
34 views

Setting up birthday emails

What's the best way to initiate a birthday trigger campaign in SFMC, i'm fairly new to this process and i wanted to see what is the best route to take. The email cadence is fairly simple and i want to ...
0
votes
2answers
30 views

Can I access Content Builder API using script activity in automation studio? If yes, is there some good documentation that I can follow?

I wanted to use the marketing cloud REST API using script activity to perform various tasks such as uploading content in content builder, changing the customer key for that content based on values in ...
0
votes
0answers
34 views

Script Activity Outputs

I creasted a SSJS in Marketing Cloud under --> Automation Studio --> Activities --> Script , I was curious to know how I can view the results of Write statements in the script? I am able to store data ...
0
votes
1answer
32 views

Updating click and open data in salesforce from journeys

I have a journey in marketing cloud and few email steps in them each one week apart. I would like to check the open and clicks of email sent before sending the next email so that the data can be sent ...
0
votes
0answers
66 views

CreateSalesforceObject AMPScript method is failing

I am using Cloud Page to sync Marketing Cloud Data Extension records from SFMC to Salesforce CRM custom Object. I am using CreateSalesforceObject AMPScript method to create salesforce object. ...
0
votes
2answers
51 views

Skip records with duplicate Primary Key while querying data using SQL activity in SFMC

I am trying to query some specific email activities using SQL Activity and Data Views in SFMC. I am trying to fetch data from Subscriber, Sent and Job data view. I need EmailName, EmailAddress, ...
0
votes
0answers
33 views

Create an automation Wait activity via API

Is it possible to create a wait activity step in an automation via preferably SOAP API or I know there is an undocumented REST API. Could a single wait activity be used on multiple automations?
0
votes
2answers
37 views

Salesforce Marketing Cloud - Stop Automation Activity based on Run

In Salesforce Marketing Cloud, I'm trying to determine a way to stop or pause an automation if it's run within a certain amount of time. Essentially, there's a Marketing Cloud bug where a single file ...
0
votes
0answers
32 views

Node SDK Create an Automation

I'm trying to create an Automation with the Node Fuel SDK. I can create an empty one, but I can't seem to specify the <ActivityObject xsi:type="QueryDefinition"> part. I'm not sure how you ...
0
votes
1answer
28 views

page Action in pardot not working

Please help me I created a page action in pardot so that i can track that page view but it is not working "https://netrocon.com/how-to-get-the-most-out-of-pardot-page-actions/" is the link that i ...

1
2 3 4 5
11