Marketing Cloud : Programmatically Export Data Extension

Exporting a Data Extension through Marketing Cloud interface is possible through Email Studio or through Contact Builder. Bulk exporting of Data Extensions is not yet available as of this writing and is painful when we have to export them.

Marketing Cloud : Version Control System for Developers

Apart from Configurations, Email Templates, Code Snippets in Content Blocks, Cloud Pages with SSJS, AMPScript are developer oriented items. A developer like me who always have worked with the version control system would prefer the same in Marketing Cloud. Unfortunately, it does not have an out-of-the box feature that supports Git or other source control systems.

But thanks to the Visual Studio Code extension – vscode-ampscript. There is a workaround for this!

Marketing Cloud : Trigger Journey Builder From Automation Studio

There are times when we need to integrate both Automation Studio and Journey Builder like sending an email to a set of audience after running a script in a data extension. There are some reasons we need Journey Builder and not Automation Studio to send email:

1. Utilizing the Splits – Decision, Random, Engagement
2. Do some updates to the connected SFDC environment like creating a task or a case or updating an object.

However, we cannot execute a script or run an SQL query in Journey Builder. Say, to clean up the Data Extension or merge the Data Extensions before sending the bulk email. In such cases, we may need to rely on the Automation Studio and then call the Journey Builder upon these activities gets completed.

Marketing Cloud : Custom Preference/Profile Center

Marketing Cloud comes with the default preference center to manage the subscription and profile information of the subscribers. It is possible to create a custom page to create it!

(This is a skeleton or boilerplate without any fancy styles. You can use this to build one for your requirement)

Extracting Audit Trail from Marketing Cloud

Downloading Audit Trail is not a direct or a single step process in Marketing Cloud. We need to utilize the Automation Studio to achieve this.

Marketing Cloud : File Transfer Activity in Automation Studio

File Transfer activity in the Automation Studio is used to securely transfer files between the file locations – Safehouse and FTP Locations. Read more to know the how to create the activity and manage the files.

Audit Trail in Marketing Cloud

Audit Trail is required in various scenarios even as part of compliance. Tracking user logins, changes made by the users to the roles and permissions and security settings is available as an additional feature (optional) in Salesforce Marketing Cloud. You can enable Audit Trail in Setup > Security > Security Settings. You can find “Enable Audit Logging Data Collection” – Enable it.

Connect VS Code with Marketing Cloud

For Marketing Cloud developers who used to and wanted to have the features of IDE, the default browser based editor is a nightmare to edit long scripts. Here comes a savior for those!

Now you can connect your Marketing Cloud with your local Visual Studio Code with a super simple extension – AMPscript by Agadzhanov Sergey.