New answers tagged automationstudio
0
votes
ImportDefinition File Name
For people checking this question in 2024, you might need to consider the "slightly" new data view Automation Instance. It contains a field named FilenameFromTrigger:
file drop and trigger ...
- 4,741
0
votes
help on Automation SQL query time out
It would be faster and more efficent to append rathar then update.
First create a backup of your "Contacts_ChangeLog" for security
Use the following steps:
Establish the Update rows and the ...
- 26
1
vote
help on Automation SQL query time out
You'll have to split your query into multiple queries. My preferred method is to utilize the hidden _customObjectKey identity value and the modulo (%) operator.
NOTE: I don't recommend select * ...
- 30.9k
0
votes
help on Automation SQL query time out
The numbers you cite aren't exactly huge for SFMC standards, so the bottleneck should not be DE size alone;
The chatGPT solution (WHERE NOT EXISTS instead of LEFT JOIN WHERE target key IS NULL) ...
- 10.1k
1
vote
How is the link generated for automation
For the ones who need this, here is an explanation:
There is an unofficial endpoint that SFMC uses:
https://baseURL.rest.marketingcloudapis.com/legacy/v1/beta/automations/automation/definition?$skip=0&...
- 49
1
vote
Using SSJS to change block in an email
This can be a sum of many parts. We probably cannot write the full code for you, but I can give you some indication on what works and what doesn't.
First of all set up: You could just build one ...
- 10.1k
0
votes
SFMC import failure
Double check status of DataExtension is still active using ContactBuilder --> DataExtension UI or Email Studio --> Subscribers --> DataExtension.
There is a validation to confirm ...
-1
votes
Import contacts SFMC via API vs FTP
There are new set of modern data imports API avialable now. refer to these public docs for more details.
Top 50 recent answers are included