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
6k views

Using Automation Studio to Export a Data Extension

I am working with a client to try to create an automated subscriber list export process. Is there a way use Exact Target's Automation Studio to export data from a Data Extension to either FTP or sent ...
2
votes
2answers
2k views

Automation studio SFTP file drop trigger to Import Activity

Background: We have a simple automation studio workflow defined that would trigger when file with a certain name pattern is dropped and that then initiates the import activity (which also relies on a ...
0
votes
1answer
149 views

Dropping heavy file and File drop trigger using automation Studio

My question will, let's assume I have 20 GB file to be dropped in SFTP which usually takes 5 min to upload, Since we are using File drop/ trigger which listen to the file being dropped, how does SFMC ...
0
votes
2answers
555 views

Target vs Control using Automation Studio

We are creating campaigns using automation studio due to campaign complexity. However, in these campaigns we are trying to implement Target vs control population. The issue is we can't use the random ...
0
votes
2answers
136 views

Query Question to retrieve sub folders / subset lists

Is there a query activity to query Publication Lists to find out what the subfolders are and the lists they contain? If I do this: SELECT DISTINCT (ls.ListName) AS 'ListName' , ls.ListID as 'ListID' ...
3
votes
1answer
426 views

Creation of a Filter Activity via API

After digging, I have found the API object for FilterActivities, and have been able to Perform, Retrieve, etc. from them, but have been unable to Create one from scratch. I have received the ...
1
vote
1answer
527 views

System error when running a query with unions to join multiple data extensions

I am trying to pull the data from multiple data extensions to another DE and i am using union to achieve it.Also I have subscriber key as a primary key in the target data extension.However i get ...
1
vote
1answer
605 views

Extract mobile connect list of unsubscribes

I have tried to find information about how to automate the export of MobileConnect status for unsubscribes with stop-code. I've found this official documentation about querying data views as ...
0
votes
1answer
696 views

Custom Personalization Strings in Content Builder

I am trying to add the ability to the marketing team to have custom personalization strings in Content Builder. I managed to create them but I have an issue to fill the Email Demographics table with ...
1
vote
2answers
552 views

Export all subscribers file content is in hexadecimal, I need it to be readable text

I have an automation to export all subscribers to fetch the "status" column. My shceduled automation extracts the all subscribers list and then drops the file on the dedicated FTP with correct name ...
0
votes
1answer
757 views

Export all contacts with automation issue

I want to export all subscribers to extract the "status" column on every subscriber. I want to automate the steps as in this official documentation. I know how i do it manually but it needs to be ...
0
votes
1answer
20 views

How do I change the userID an automation routine (file import) runs under in Marketing Cloud?

How do I change the userID an automation routine (file import) runs under in Marketing Cloud? Employee left and we need to update the automation to be a support user ID.
1
vote
1answer
522 views

File Trigger not working in Automation Studio

We had a successfully running file import running in Automation Studio that was working each time a file was placed onto the FTP. Our internal system failed to drop a new file, causing the import to ...
0
votes
1answer
110 views

It is possible to query the IPAddress in QueryActivity

It is possible to Query the IPAddress in QueryActivity iam trying this one but i didnt get IpAddress select FromName,FromEmail,IPAddress from _Job
0
votes
1answer
195 views

Automatically Export a Group | Marketing Cloud

I am wondering if there is a way to automatically export a Group to FTP in Marketing Cloud using an automation. I've created a Group, using Measures leveraged against our All Subscribers List, and ...
1
vote
1answer
817 views

Automation studio send email and sending tracking to salesforce

is it possible to use automation studio to send an email and send tracking information back to salesforce? We can't see an option to send tracking data back to salescloud as we do in Journey builder. ...
0
votes
1answer
77 views

Receive notification if automation resulted in audience volume greather than specific threshold

I would like to know if there is a way to be notified in SFMC automation if result in audience greater than 100k and halt the automation so that we can throttle the volume over multiple days if ...
1
vote
1answer
738 views

Can't fire Journey Event using Automation Studio

I know its very straightforward and I myself have done it many times before. But this time I don't know why its not working. Want to make sure if something has changed with the recent SFMC releases. I ...
0
votes
1answer
2k views

Query Activity - Merge Data Extensions

I am trying to merge two DE (Accounts& Leads) into 1 Master DE. I want to exclude the leads already imported when importing the accounts. This is the SQL: SELECT T1.Email AS EmailAddress, ...
0
votes
2answers
515 views

How do I check from Journey Builder if a record exists in SFDC?

I have a requirement where in I need to check from Journey Builder if a record exists in SFDC (we have marketing cloud connect in place to connect to SFDC). We have an Automation that checks an FTP ...
0
votes
1answer
517 views

Email data extension date daily, how?

If I want to receive data from a data extension on daily basis, how can I do that? By data I mean all data. It can be in an email body or attached excel file as a report.
0
votes
1answer
5k views

File Transfer Activity Encrypt and Decrypt with PGP

Using a File Transfer Activity and Import File Activity in an automation (File Drop), I am trying to read a CSV file into one of my data extensions. Halfway through the process, there is an update to ...
0
votes
1answer
1k views

Combined Data Extensions (3 DE's) SQL Query

I am attempting to build a combined data extension from 3 other related data extensions via Query & Automation Studio SQL Query. I have successfully (though I'm not sure that the # of records I ...
0
votes
1answer
483 views

Query Error - cannot convert nvarchar

I am trying to return details associated with a certain email address . I am using the query below: select emailaddress ,subscriberkey ,record_type_name__c from mastersubscriberde where ...
1
vote
2answers
104 views

IF statements causing long processing/send times for ~600k list

I'm trying to trim some time off of our newsletter sends. We have a daily newsletter that delivers to ~600k subscribers each morning. The content is populated by an RSS feed that is parsed with ...
0
votes
2answers
1k views

Tracking clicks on email

Is there a way to track the clicks in the email while on journey? and send the tracked links to specific email?
0
votes
1answer
126 views

How do I confirm automation perform status — running or not?

I want to confirm automation perform status. How do I confirm this by PHP via SOAP-API? PHP sample code is here. require('../ET_Client.php'); const OBJ_TYPE = "Automation"; const ...
0
votes
2answers
209 views

I could not perform an Automation immediately by PHP via SOAP

I created this PHP code and run this. PHP Code const OBJ_TYPE = "Automation"; const ACTION_TYPE = "start"; const OBJECT_ID = "[Automation's External Key]"; try { $authStub = new ...
0
votes
1answer
47 views

How does the new Data Extract interface compare to the old one?

I am trying to perform a data extract via the new "lightning enabled interface" in Automation Studio. I have the configuration below, but it keeps erroring. I have searched for documentation, but ...
1
vote
0answers
81 views

How do I perform an automation immediately by PHP?

I found that can perform an automation immediately on Marketing Cloud via soap API. (see: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/...
-1
votes
2answers
987 views

How do I get Email Performance by Device using a Query Activity [closed]

How to get Email Performance by Device to populate device name using SQL query in Marketing Cloud?
4
votes
2answers
5k views

Query Activity system error in Automation Studio

Why am I getting a system error with this Query Activity in Automation Studio? Select o.AccountID , o.JobID , o.SubscriberKey , o.EventDate , o.isUnique , o‌​.Domain , o.Subscriber‌​ID , o....
0
votes
1answer
352 views

Automation to be run only in the night

Is there a way I can start schedule an automation to be run for example from 6:00 pm to 12:00 am alone - every day? Seems to be a basic use case, can anyone tell me if its possible? I want my ...
0
votes
0answers
177 views

Data extension populated in second step (of automation) not showing for Journey Builder audience

I am trying to create a journey. The entry source I selected is : Audience -> Automation Studio Audience. The problem: The automation has 2 steps step 1: Import Activity : Pulls data from ...
2
votes
2answers
2k views

How to export multiple HTML emails(entirely) with all properties(such as Images) from one Exact Target instance to another

I'm trying to find a solution as to migrate all of my HTML emails with their properties i.e. Jpeg/PNG files in them from one instance of Exact Target to another instance , considering these are to ...
1
vote
2answers
1k views

can I use a SET statement in a Marketing Cloud QUERY?

I'm trying to write a query that will take unsubscribes from a child BU and write into a shared DE at the parent level. I know how to find the unsubscribes, but I'm trying to write into a DE field ...
0
votes
1answer
812 views

Trigger entry event when new rows are added to data extension [Salesforce Marketing Cloud]

We're using a Facebook lead capture form, which loads new entries through to a data extension in real time. We've then set up a Journey Builder journey to send an email to records that enter the data ...
3
votes
0answers
408 views

Sending marketing cloud mails from Salesforce instantly

We have a unique problem in Sending marketing cloud mails from Salesforce. Contact records are available in Salesforce and the logic to select which contact should receive the marketing cloud mail is ...
1
vote
1answer
561 views

Is it possible to interact with automation studio using REST APIs

I'm a .net developer and trying to grasp knowledge of Salesforce marketing cloud REST API's for my new project. We have an automation created in sf, after loading data into Data Extension, I want to ...
0
votes
1answer
204 views

Sending email to contact from automation studio

We are using salesforce reports to send email to contact from automation studio. the process seems to working fine i can see status as sent under tracking but no email was sent out. What might be the ...
0
votes
1answer
42 views

Is it possible to create an automation that exports a list (not a DE) to an FTP?

I need a way to automatically export a list (not DE) to an FTP. I know this is possible when using DE's, data extracts, and file transfer activities. However, no documentation seems to exists when ...
1
vote
1answer
188 views

Can we overwrite Filtered DE?

We are importing data from CRM to a DE. What I want to do is to send out a welcome email to newly added subscribers on real time. For this I have created a data filter using joindate = today on main ...
1
vote
2answers
3k views

How to move data from a list to a data extension

I need to create a automation that extracts and drops a entire list onto the FTP each day. My issue is that the data lies within a list. Is it possible to create a query that populates a data ...
1
vote
0answers
49 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
352 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 ...
1
vote
2answers
807 views

Emailing Report - Automation Studio

Is there a way to Email a Scheduled Report (created using SQL) in Marketing Cloud Automation Studio?
1
vote
1answer
729 views

Marketing Cloud Automation Studio Triggered Automation not sending to all emails on Data Extension

We have a Triggered Automation email setup through Automation Studio that's not sending to everyone in the Data Extension (DE). The trigger is the new csv file dropped into the Enhanced ftp. The ...
0
votes
1answer
714 views

DE manipulation in Automation Studio

I'm trying to write a SSJS script in Automation Studio. I want to retrieve column values from one DE, clear that table, and write that column data to another one. (Among other things.) In a prior step,...
0
votes
1answer
621 views

How to debug Automation Studio Audiences?

I've set up a triggered automation, that listens to csv-uploads and imports them into a data extension (using overwrite). Furthermore, I created a simple journey that uses this automation's audience ...
1
vote
1answer
742 views

Accessing Substitution Strings with SSJS in Automation Studio

I'm trying to drop a file into a particular FTP folder, and run a script that needs to access the file name. I know that %%BASEFILENAME_FROM_TRIGGER%% can give you the file name minus the extension, ...

1
7 8 9
10
11