Dec 11, 2022How to download SFMC data as a file via SlackFor many SFMC architects and consultants copying and pasting data from the SFMC UI in a translatable way can be a painful process. The way data is formatted and structured is often hard to manage and time consuming to rebuild into clean, easy to read structures (like a table in…5 min read5 min read
Sep 11, 2022Integrating Slack and SFMC (deployment and interfacing)In this article I outline how Slack Apps work and how you can build an application that will allow you to interact with SFMC via Slack. This specific solution is a small part of a personal project, but the concept and architecture can be applied to any use case where…6 min read6 min read
Sep 4, 2022Have you considered AWS AppFlow?Like most happy accidents, I stumbled across this product by chance whilst looking at integration options for Slack (more on this in future posts). It looks like this one slid through the cracks, It got a little bit of a mention from the SF CRM perspective but nothing for SFMC. In June…4 min read4 min read
Aug 26, 2022Connecting the Clouds ( Data Warehouses and SFMC)As a marketer I’ve felt the pain of only having access to the data that IT department provides, this is typically slow moving batch data that was built several years ago and not updated or enhanced. As we move to a 1:1 world with new tools, the ability to create journeys…5 min read5 min read
Aug 18, 2022SFMC and AWS S3 (Cloud Storage Triggers Beta)For awhile SFMC has had the ability to ingest data from AWS S3 buckets into Data Extensions, however, there were limitations that SFMC end users and consultants alike would need to solution around to get the most out of the 2 platforms. The main limitation of S3 as a file location…3 min read3 min read
May 17, 2022SFMC SQL & AWS — A Query Studio Alternative.I heard whispers that the much loved SFMC Labs package “Query Studio” is nearing its end of life. This article explores an alternative, high performance solution leveraging some AWS products with little to no code (set and forget for .zip files). Previously I wrote about doing a similar activity with GCP which…4 min read4 min read
Jan 13, 2022Simplifying data warehousing for marketing analytics using GCP Big QueryFor many SFMC users like myself, dealing with reporting and data analysis is painful at the best of times. We’re typically constrained to the platforms at hand and their capabilities, which a lot of the time don’t actually allow us to solve our immediate problems with ease. In this article…5 min read5 min read
Sep 25, 2021Find & Replace in SFMC using GCPThis Article explains an API led approach to find and replace values across a SFMC Instance for Content Builder assets. This solution will use the same architecture pattern (and GCS Buckets) as my previous posts but rather than create entities within SFMC we are merely searching for values and replacing…Sfmc3 min readSfmc3 min read
Sep 6, 2021GCP — SFMC Data Pipeline pt2 (extended)A while back a colleague of mine asked if there was a way to get data into SFMC from a csv file without creating a Data Extension. My immediate response was “No”. I then took and long pause and said “Maybe….”. previously I’d been able to post data into an…Sfmc3 min readSfmc3 min read
Sep 6, 2021GCP — SFMC Data Pipeline pt2In this post I’ll explain & share the approach and code to creating your own Data Extension pipeline in GCP to move data from a csv file into SFMC with very low effort. Setting up your Cloud Function: 1. Go through the process to create a CF, you’ll want to set the trigger to ‘Cloud…Sfmc2 min readSfmc2 min read
