Image for post
Image for post
Photo by Caspar Camille Rubin on Unsplash

What we have below is an edited response from a WSProxy api retrieve call to the SubscriberStatusEvent SOAP object. Within the “Results” array, we can see that the “Properties” array is an array of objects, with each object having two attributes, Name and Value.

....
var res = prox.retrieve("SubscriberStatusEvent", cols, filter);
Write("Output:<br><br>" + Stringify(res));****************
Output:
{
"Status": "OK",
"RequestID": "3558ebd5-4cb2-4cfb-83e6-5cc9b0f29774",
"Results": [
{
"ObjectID": "39a0d2c7-752e-e911-80d8-1402ec74dd75",
"CreatedDate": "2019-02-11T21:25:04.640", …

Image for post
Image for post
Photo by Philipp Katzenberger on Unsplash

This post comes off the back of a webinar hosted by Eliot Harper and Ivan Razine in which the very important topic of secure development practices was covered. One of the key learnings was how to protect your API credentials (clientID and clientSecret) on CloudPages. I’d encourage you to watch the webinar recording for some excellent nuggets of information. This blog post is my takeaway from the presentation, with the aim of helping to spread good development practices.

All AMPscript and Server Side JavaScript (SSJS) is processed on the Marketing Cloud’s server side instead of the client-side computer. Thus any…


Many times during troubleshooting and working remotely have I needed to share the setup of data extension within Salesforce Marketing Cloud with colleagues or clients. And you know what they say; a picture is worth a thousand words. Having said that, its actually quite difficult to get a screenshot of your Data Extension setup and have all the fields included in the picture. So what are you to do?

If you’ve ever been in a similar situation I have the perfect solution….

Step 0: Open SFMC inside Google Chrome browser.

Step 1: Load your Data Extension on the properties on…


Image for post
Image for post
Photo by noor Younis on Unsplash

Date fields in Marketing Cloud can be challenging. They are stored in a specific format that includes a time component, and you may have to deal with different time zones.

  • ExactTarget/Marketing Cloud system time is hard coded to UTC-6 (UTC minus six hours) and the system time does not change with standard versus daylight savings time.

(Unless your account is on Stack 4, which is in US Mountain time — UTC minus 7 hours).

  • In SQL, it’s equivalent to AT TIME ZONE ‘Central America Standard Time' UTC-06. This is NOT to be confused with Central Standard Time which often does


The _Subscribers and _ListSubscribersData Views in Salesforce Marketing Cloud have a wealth of information that can be used to uncover when a subscriber was added to the system, when they unsubscribe and their current status (active, unsubscribed, bounced or held).

Amongst the most valuable information nested in these views is the subscriber status which signifies whether a subscriber can be contacted or not.


Image for post
Image for post
Photo by Jonathan Bowers on Unsplash

Where do you go to learn about Salesforce Marketing Cloud APIs? Here’s a list of my favourite resources, in no particular order. Credit and thanks goes to each of the authors.

Introduction to making API calls to SFMC from POSTman

https://gortonington.com/introduction-to-making-api-calls-to-sfmc-from-postman/

Step by Step Guide to Trigger emails and Journeys via Rest API in Salesforce Marketing Cloud (SFMC) with Postman

https://medium.com/@alessiamastroianni/step-by-step-guide-to-trigger-emails-and-journeys-via-rest-api-in-salesforce-marketing-cloud-a3dba0215d68

sfmarketing.cloud

https://sfmarketing.cloud/marketing-cloud-apis/

A Newbie’s Guide to API…from a newbie.
https://www.linkedin.com/pulse/newbies-guide-apifrom-newbie-kaleem-mcgill/

Help! Where can I find information on Salesforce Marketing Cloud REST and SOAP API’s?
https://www.linkedin.com/pulse/help-where-can-i-find-information-salesforce-cloud-rest-hilaire-1e/

Salesforce Marketing Cloud Enhanced API Collection

https://api.mcexperts.ninja/?version=latest

Salesforce API Explorer

https://developer.salesforce.com/docs/api-explorer/sfmc

Salesforce Developer Documentation

https://developer.salesforce.com/docs/atlas.en-us.mc-apis.meta/mc-apis/index-api.htm


The CloudPagesURL() function provides a secure and efficient way to link out to CloudPages from email messages.

<a href="%%=RedirectTo(CloudPagesURL(4132))=%%">Click HERE</a>

It generates a URL link to the landing page with an encrypted query string appended —meaning no subscriber information is passed in clear text.

https://pub.s10.exacttarget.com/1qVt23cf?qs=92fcbe6d03c54df75b03c7d674f2e836

This encrypted query string (?qs=______) references the email and allows standard system personalisation strings to be used on a landing page.

When using the RedirectTo(CloudPagesURL(1234)) function, I was curious if it was required to use requestParameter, queryParameter, or possiblyAttributeValue().

In fact, it is A LOT simpler than that. As you would in an email, you…


The March 2020 Release provides ability to get delivery receipts for individual SMS sends using the _SMSMessageTracking data view.

Full detail on the data view can be obtained here:

If you want to filter your query results to a particular send you need to get the MessageID.

To get the MessageID, we need to click on the message name and look at the last part of the page URL. The last characters preceding the last forward slash is your Base64 encoded text version of the MessageID.

Copy the Base64 encoded text and use an online Base64 decoder to decode…


Image for post
Image for post
Photo by Christian Wiediger on Unsplash

Deliverability is a way to measure the success at which an email marketer gets a campaign into subscribers’ inboxes. It is impacted by things like ISPs (internet service providers), MTAs (mail transfer agents), throttling, spam, bounces and bulking. In this post, I want to touch on bounces.

A subscriber is marked as “bounced” when their receiving email server rejects an email that you send. This rejection can mean that the email address is invalid or their inbox is inaccessible at the time of send.

ISPs send messages back to Salesforce Marketing Cloud reflecting the response provided by the recipient’s server…


Image for post
Image for post
Photo by Rob Curran on Unsplash

There is a lot of confusion surrounding how to access subscriber opt-in status for specific business units within Salesforce Marketing Cloud enterprise accounts. The situation is made complex by the fact that the _Subscribers data view holds Parent BU information which often causes discrepancies for marketers trying to discern the opt-in count for their BU or Brand.

This article will discuss first the background of subscriber management within the platform, and then point you towards some solutions for retrieving the business level status of a subscriber.

All Subscribers

The All Subscribers list is considered the master list of records for…

Charlie Fay

I am a certified Salesforce Marketing Cloud Consultant at Bower House Digital in Melbourne, Australia.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store