Questions tagged [marketing-cloud]

The Salesforce Marketing Cloud is the leading 1:1 digital marketing platform, connecting companies with customers in entirely new ways. Platform APIs and SDKs enable developers to manage and automate marketing campaigns and extend the Marketing Cloud with integrated apps and app extensions.

Filter by
Sorted by
Tagged with
0 votes
0 answers
37 views

Can I use a publication list to honor opt-outs to guided sends, or must I use a suppression list?

Official documentation wasn't clear to me, and my Salesforce support case didn't give me the level of clarification I needed. I'm trying to transition from using publication lists for internal use ...
user avatar
  • 9
0 votes
0 answers
9 views

How to create journey exit timestamp in SQL Query [duplicate]

I would like to write a query that populates an "exit_journey_date" field for a data extension in Marketing Cloud. I would like this query to run via Automation Studio, so that even though ...
user avatar
1 vote
1 answer
45 views

Extract Text Version of the email body with no html tags using REST API from SFMC

I was trying to extract the email body (text version) with no html tags from SFMC. But I had some hard timing on how to filter out the nodes in the email content to get the expected result, I couldn't ...
user avatar
  • 31
0 votes
0 answers
33 views

Identify Query Activities within Automation using ssjs

I am trying to identify all the activity queries within an automation using ssjs. I came up with the following code but it seems not working rightnow. Have you guys ever had this problem? Did you ...
user avatar
0 votes
1 answer
26 views

Firing triggered send via rest API - erring

I am trying to fire a triggered send REST API via postman, I have successfully created a package with all the permissions ticked, including email send,write. After generating the access token in the ...
user avatar
  • 643
0 votes
1 answer
50 views

How to update salesforce custom object (Customer__c) OptIn field value from Marketing cloud (Customer DE) OptIn attribute value using AMP script

I have a scenario, 1 DE (Customer DE with SubscriberKey, OptIn, Status, OptInDate attributes) with some records. I want to update the salesforce Customer__c object records OptIn (Yes/No) if ...
user avatar
  • 3
0 votes
1 answer
28 views

SQL to see records if their value in one column has changed

I have the following four columns: DATE_OF_FIRST_SUB_AEST (the first time a person purchase a subscription, eg: 2008) Subscription_ID (Can have multiple subscriptions in the past, so multiple ...
user avatar
0 votes
1 answer
33 views

Query to retrieve portion of a date

I have date values that are stored in the following format: Thursday, December 19, 2019 12:00 AM I need to retrieve just the month and day however I have been unsuccesful as I keep getting the time as ...
user avatar
  • 5
0 votes
1 answer
51 views

Retrieve fields from dynamic data extention in Custom activity?

I am having little issue : in my js script I am trying to push some data dynamically : /** * Save settings */ function save() { //if($form.valid()) { payload['metaData'].isConfigured = ...
user avatar
  • 160
0 votes
1 answer
37 views

Marketing Cloud App SOAP API "Error: API Permission Failed." on every call

Overview: I am using SSO to login to my marketing cloud app, and trying to then hit the API to load a list of DataExtensions. However it seems no matter the call I make, I get the same error: <?xml ...
user avatar
0 votes
1 answer
25 views

SSJS date time retrieval error

I am trying to retrieve the date-time in SSJS. I have created the below code on the cloud page, to retrieve the locale date time. <script runat="server"> Platform.Load("Core&...
user avatar
  • 643
1 vote
1 answer
29 views

Bulk delete records in Data extension [continue]

I am unable to put the comment in the original thread where Adam has put up the answer. I have modified the code suit to my scenario and it's able to delete 50 records, but I am unable to delete bulks ...
user avatar
  • 27
0 votes
0 answers
25 views

Triggered send links redirecting to incorrect URL after DNS change

My client have several Triggered send which pulls the URL data using AMPScript 'RedirectTo' function from data extension attribute. This works fine and the links redirect correctly to the desired page....
user avatar
-1 votes
1 answer
34 views

Getting error message "Violation of PRIMARY KEY constraint. Cannot insert duplicate key "

Getting error while running this query in automation, customer key is set to be the Primary key. Below is the code : Select A.ContactKey, A.AccountId , A.ContactId , A.CreatedById , A.Email, A....
user avatar
  • 1
0 votes
0 answers
38 views

SSJS Try/Catch Behaving Different in Different MIDs

For context, I have two different Marketing Cloud orgs, one that we will call PROD and one that we will call UAT. They are completely separate. They are each connected to a Salesforce instance, PROD ...
user avatar
  • 97
2 votes
1 answer
58 views

how to get the owner name of a data extension in marketing cloud [closed]

Is there any way to get the owner of a DE through API or Query?, Currently we have a SOAP API but this is not bringing us the Owner, this would be the only attribute that does not call
user avatar
0 votes
0 answers
25 views

Marketing Cloud Page not updating Salescloud record

I have a cloud page in marketing cloud this i need to update a salescloud record when they click through to the page via a button. Its not currently doing that even though to me the code looks right. ...
user avatar
-1 votes
1 answer
28 views

Can I restrict rights to an API user in Marketing Cloud?

The devs working with me are asking if we can give only Read access to some developpers, and full access to others ? I know only, in Setup, the Apps> Installed Package > Instance API values. But ...
user avatar
  • 89
0 votes
1 answer
18 views

Populating multiple tables in a Email using AMP script [closed]

I've got 3 DE's say (DE1,DE2,DE3) which different attributes and a sendable-DE (master-DE) with Email column I have to create an email which contains 3 tables (T1,T2,T3) and Insert the values in the ...
user avatar
  • 3
1 vote
1 answer
24 views

Journey Builder - Ad Audience - Create Exclusion Audience so I don't advertise to certain customers or customers who have seen the ad

I'm trying to understand how to build a suppression audience for ad studio in journey builder. 'Customers that exit journeys aren’t automatically removed from that Advertising Audience, so it’s ...
user avatar
  • 495
-2 votes
1 answer
34 views

How to retrieve the last 15 mins SMSSubscriptionLog records based on OptInDate using SQL Query?

I have a scenario that i need to retrieve the last 15 mins SMSSubscriptionLog (data view) created/updated records based on OptInDate using SQL Query. I will store the results in the created DE. If we ...
user avatar
  • 3
0 votes
0 answers
54 views

Parse Json, retrieve and add to DE

I want to retrieve the subscribers from my list and then add to my DE, but the code it's not retrieving the subscribers and I believe that there is a error in Parse Json DE Columns - email (primary ...
user avatar
0 votes
1 answer
65 views

App Crashes when calling SFMCSdk.mp.setNotificationUserInfo(info) with an _od field in the info

When handling a deeplink when the app is closed, we are having to temporarily store the userInfo from didReceiveRemoteNotification and wait until the SDK is fully initialized before calling ...
user avatar
  • 1
2 votes
0 answers
18 views

Capturing Filter Data on Interaction Studio

We are trying to capture the filters a user clicks on in the website and use those filters to build some form of affinity towards certain products. We tried making it a user attribute and a product ...
user avatar
  • 21
1 vote
1 answer
65 views

How can I combine the _SMSMessagetracking data view with another DE without having duplicates in Salesforce Markteting Cloud?

Great feedback. How ever, I still don't get the result I want. This is what I have with the outcome and what I expect: SMS Tracking view I created the SMS tracking DE with all the fields from the SMS ...
user avatar
  • 103
0 votes
0 answers
31 views

Send email from a Journey when record data was changed

I have a Data Extension that has multiple boolean fields. Records get into this Data Extension through api requests, and the data in them can also change through api requests. If the first field is ...
user avatar
  • 11
2 votes
1 answer
58 views

Assigning values to variables in a loop

In the full code pasted below I'd like to avoid the if statement within the if statement. I'd like to assign the values stored in @rows into the @Voucher1 and @Voucher2 variables using the incrementor ...
user avatar
0 votes
2 answers
30 views

Store logs separately generated by logunsub event in a Data Extension. The Response Returned is in HTML and not in JSON format

UnsublogEvent is working as expected. the only thing is I have to pass the response back to the data extension. Response = Platform.Function.InvokeExecute(lue, statusAndRequest); above row gets the ...
user avatar
0 votes
1 answer
45 views

Is it possible automatically to save content builder published urls into a DE?

I have 3 images (imagine: logo, img1, img2) uploaded and published in Content Builder. I want to add thos published URLs to a DE, so in logo's line I add url from logo image. If there a just 3, its ...
user avatar
0 votes
1 answer
33 views

To get data of all automations created in BU with their status

I tried below code to run in my BU to retrieve records, but it does not publish anything. <head> <style> body, a, input, td, th {font-family:sans-serif; font-size:12px;} </style&...
user avatar
2 votes
1 answer
114 views

Marketing Cloud SDK 8.0.4 crashes

I’m using com.salesforce.marketingcloud:marketingcloudsdk:8.0.4 and I have noticed that two crashes are increased since February 15th, these crashes are not new but they have increased a lot since ...
user avatar
  • 23
0 votes
1 answer
55 views

Can Marketing Cloud be used for B2B? [closed]

I always heard that for B2B Pardot is more suitable than Marketing Cloud, which is preferred for a B2C model. Is there any reason other than the license price?
user avatar
  • 271
0 votes
1 answer
51 views

SFMC-Query the All Subscribers count on a specific date?

I need a query to count the number of active subscribers on specific dates, January 31, February 28, etc. throughout the year into a data extension. I know this will be using the _subscribers data ...
user avatar
  • 1
1 vote
1 answer
27 views

How to track app version of device for MobilePush

For MobilePush is there a way (e.g. a standard field that I could discriminate) to see the version of the app the user logs in with? The reason is to be able to know on the marketing platform whether ...
user avatar
  • 71
0 votes
0 answers
19 views

Way to reflect count in Journey builder after factoring the Exclusion Script

this is a simplified journey which leveraging on exclusion script to filter customers meant to be excluded (e.g. to be updated daily). Yes, it has achieved the purpose to filter excluded customers by ...
user avatar
  • 27
0 votes
1 answer
45 views

I have no clue how to use Datorama with Contacts Counts

Good morning, So we use Discover Report for Account send Summary, deliverability, and contacts counts, my main problem is I can't get the information of CONTACTS COUNTS on Datorama, and I would like ...
user avatar
  • 3
2 votes
2 answers
42 views

Pass arguments to Execute method in Custom Activity?

Hello I am having a little issue, I am using a template I found online, this, I have hosted it and it is working properly when it comes to ethds executiion and so on : The issue is That I am trying to ...
user avatar
  • 160
0 votes
1 answer
62 views

Are there any features for developing HTML emails locally and using version control?

So far my work with Salesforce is for HTML emails in Content Builder. I don't see any obvious features that would allow our team to do various things that would help streamline development, such as: ...
user avatar
0 votes
0 answers
19 views

UTM tags being removed in Community URL when accessed from SFMC email

ISSUE: I have UTM tags set up in Marketing Cloud. In my email template there is a button linked to a SF Community portal page. When the button is clicked, the user is getting navigated to the SF ...
user avatar
  • 66
0 votes
1 answer
45 views

_Open.IsUnique is TRUE for two records with the same JobId and SubscriberKey - Why?

From my understanding, the first "open" that's recorded for a particular JobId will have their IsUnique attribute as TRUE. Any subsequent opens AFTER that will still be recorded, but with ...
user avatar
0 votes
0 answers
44 views

SSJS Array.prototype throws jintException when used with DataExtension.Retrieve value of test

I have stumbled across another interesting case with SSJS and Salesforce Marketing Cloud and hope for some ideas on why this occur and furthermore, how I may can prevent this from happening. On a ...
user avatar
  • 466
0 votes
0 answers
35 views

Exclusion script syntax in Journey Builder

I am using below exclusion script in journey, (TreatAsContent(ContentBlockByKey("12345")) > 0) Will this lead to an error because of the '(' used in the starting? I have already ...
user avatar
0 votes
1 answer
31 views

Is there always a segmentation engine feeding SFMC

In profiling a dozen or so companies that have implemented SFMC for orchestrating marketing campaigns or other communications, there seems to be a pattern in that SFMC seems to be using pre-segmented ...
user avatar
1 vote
2 answers
56 views

Query Studio SQL statement to pull data date range function syntax

I'm using Query Studio in SFMC - Is there a better way to write this query? I checked the DE - I 99% sure there are records to see but doubting myself if I'm writing this correctly. I'm just trying ...
user avatar
  • 13
0 votes
0 answers
45 views

Break ampscript resultset when spaces are found and store them in separate variables

Currently I have script to fetch values from a DE SET @retrieveRequest = CreateObject("RetrieveRequest") SetObjectProperty (@retrieveRequest, "ObjectType", "...
user avatar
0 votes
0 answers
29 views

RMM - Only certain email address can reply to the email sender

I have set up an RMM feature and it was working at the stage of sending emails to the test recipients. However, when I tried to reply to the recipients, only a few email addresses reached the ...
user avatar
0 votes
2 answers
86 views

Convert a datetime to date in SFMC

I have an issue converting a date/time to a string format date. Indeed, I would like to change the following date format : 'mardi 15 mars 2022 4:24 PM' to this format '15/03/2022' without the timedate....
user avatar
  • 27
0 votes
1 answer
65 views

How to sync the real time SMS data from Marketing cloud to Salesforce? [closed]

I know that Email's tracking data syncing from MC to Salesforce. Is there any way to sync the real time SMS data from Marketing cloud to Salesforce? If yes, kindly provide the required steps with ...
user avatar
  • 3
0 votes
1 answer
48 views

Delegated domain and RMM

So, the issue is that I have configured the Reply Mail Management (RMM). However, when I tried to send a reply email, it showed this error. Questions: I believe it's the MX records that haven't been ...
user avatar
0 votes
1 answer
65 views

Select Distinct only one column, when there are multiple columns

I have the following query in SFMC: SELECT b.SubscriberKey, b.BounceType, b.BounceCategory, b.EventDate, s.EmailAddress, b.JobID FROM _bounce b LEFT JOIN _Subscribers s ON b....
user avatar

1
3 4
5
6 7
238