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.
12,693
questions
2
votes
0
answers
38
views
How to create Test record in _Complaint Data view for Outlook?
I have a use case where I need to create a test record in the Complaint data view to test the extract. I have created an automation that extracts data from the complaint data view, due to our company'...
- 111
-1
votes
1
answer
53
views
Query Error - Timeout
my query had an error "QUERY FAILED - TIMEOUT".
The query is:
SELECT DISTINCT
S.JobID,
S.ListID,
S.BatchID,
S.SubscriberID,
I.ActivityName,
I.JourneyName,
I.JourneyId,
I.VersionId,
S....
0
votes
1
answer
64
views
SmartCapture Form Not Submitting Values
I'm trying to have the "Otro" option display a text-field so someone can provide more details.
I have a SmartCapture form on a CloudPage that has a checkbox field with several options, and ...
- 45
0
votes
2
answers
74
views
Change value value of field using AMPscript
In my Data Extension there is a field, Age, with a value of 100.
I want to change this value from 100 to something completely different like Red or One-Hundred.
Can this be done with AMPscript?
Note: ...
- 136
0
votes
1
answer
94
views
Send push notification to only one device when a user's logged in multiple devices
I'm looking for some ways to send push messages to only one device when a contact is logged in multiple devices.(ipad, iphone..etc), and I'd like to specifically target the last logged-in one.
I found ...
0
votes
2
answers
98
views
Mobile Push test message
I'm trying to send mobile push test messages through marketing cloud.
How can I add my device ID to mobile push so I can send a test message to only "me", not all of the subscribers? Please ...
- 21
0
votes
1
answer
70
views
Marketing Cloud : Attach and send PDF file from SFTP based on Salesforce CRM data
Our existing CRM is Salesforce and we have purchased Marketing Cloud and would like to whether the following usecase is feasible.
We have a unique Id (CusId__c) for our customers (Contact Object) and ...
- 75
1
vote
0
answers
54
views
Journey Builder Re-Entry Only After Exiting for One Product Only?
I want to send a dynamic email to customers that expressed interest to a product. And I want to accomplish the below:
If a contact shows interest in Product A, he will receive the journey email, then ...
- 15
0
votes
0
answers
30
views
Mobile Push received but links not working in Journey Builder
Has anyone run into the problem of receiving mobile pushes from Journey Builder but with hardcoded links that simply don't work?
I am working on migrating our mobile pushes from the manual Mobile ...
- 1
0
votes
1
answer
44
views
SFMC Ampscript failing validation using a lookup for a synced Data Extension
Salesforce MC error:
Error 1: Script SET Statement InvalidAn error occurred when
attempting to resolve a script expression. See inner exception for
detail. Script Expression:
Lookup("...
- 13
0
votes
0
answers
22
views
If/Then Conditional Code for Salesforce Cloudpage [duplicate]
I am creating a preference center using a smartcapture form in salesforce. I am trying to code it that if someone clicks "Option 1" from the first drop down in the form, then only certain ...
- 1
-1
votes
1
answer
41
views
Subscription Method of a Subscriber in SFMC
I'm in need of Subscriber source details. As I'm going through each report, I found List demographics give Subscription method details but not at the subscriber level. Do we have any feature in the ...
-1
votes
1
answer
57
views
Collect tracking code implemented on the pages but data is not returned on the reporting tab in the web recommendation
Good morning team!
I am assisting the customer in the implementation of the tracking collection code for travel data usage
according to him, the code has already been implemented in the pages but when ...
0
votes
0
answers
48
views
Update the record of DE in the cloud page with Ampscript
The problem is that I need to click a button to update the recommendation code field of DE's record to determine whether the user has a recommendation code. If not, update it, and the recommendation ...
- 3
0
votes
1
answer
55
views
Combining Data from Two Synchronized Data Extensions into One New DE
I've just created two synchronized data extensions in Contact Builder and then discovered that both data extension have fields the other does not have. The first synced DE is Account_Salesforce and ...
0
votes
0
answers
48
views
Marketing cloud error while calling a journey through API call : 401 : "Not Authorized"
I have installed a package and added API Integration component, While authenticating through postman am getting the access token with success code 200 OK.
When i tried to do the api call am getting ...
- 3
0
votes
0
answers
46
views
Update rows in Data Extension
I need to update multiple rows in my Data Extension as a part of automation, however I receive an error with no specific information what is wrong.
<script runat="server" language="...
- 1
0
votes
1
answer
39
views
SFMC MobilePUSH SDK error setKeychainAccessibleAttribute
I implement mobile application which plug with SFMC SDK, according to SF guild from this link sf ref: https://github.com/salesforce-marketingcloud/MarketingCloudSDK-iOS/blob/v8.0.10/LearningApp/...
1
vote
1
answer
107
views
Junk Characters || SSJS Fire Entry || The Japanese characters show Junk when stored in DataExtension
I am using a simple SSJS code from here.
I have updated the Fire Entry API end point as below.
/*=== SFMC REST API === */
var payload = { "ContactKey": Account_ID,
...
- 1,829
0
votes
2
answers
126
views
JSON Parsing in marketing cloud email AMPScript
I have a JSON string which contains a 'body' key as a string, which is an escaped JSON that has keys and arrays. I want to read the JSON and extract the 'body' key and then extract the arrays inside ...
- 3
0
votes
1
answer
42
views
Troubleshooting SSJS
<script runat="server">
var email = Attribute.GetValue("email");
var entityKey;
var emailMatch;
var contactRows = Platform.Function.LookupRows("Contacts", &...
- 3
0
votes
1
answer
41
views
Script to change Publication List status works in CloudPages but not Automation Studio
The following code is supposed to change someone's status in a Publication List to "Active". It works very well when I run it via a CloudPage, but when I put it in an Automation Studio ...
- 185
-1
votes
1
answer
46
views
Marketing Cloud Automation Studio - Select the same column multiple times using aliases
I'm trying to create a SQL query in Marketing Cloud Automation Studio, where I use the same column EventName from multiple tables _Sent, _Open, etc but I get an error message "The column '...
- 1
0
votes
1
answer
57
views
New "From Name" causes an undelivered SMS status in Journey Builder?
We have set up a new journey to do test sends from a Data Extension.
The journey is quite straight that it will trigger all records in the DE with SMS messages once the journey is activated.
We have ...
- 1,266
0
votes
1
answer
47
views
How to use if statement in Marketing Cloud SQL activity?
In the syncronized data extensions Account__c i have the following fields:
KPIUltimoSoggiornoTipo__c that is mapped with a list of products name (it is a text field)
KPIClusterFrequenza__c indecates ...
0
votes
1
answer
49
views
QR Codes from a third party - what are the most scalable options
Until recently we were using the BarcodeURL ampscript function to generate readable barcodes for a ticketed event. The business now want to switch to a QR code instead.
As Marketing Cloud does not ...
- 822
0
votes
1
answer
46
views
Can I retrieve non shared DE rows from Parent BU using WS Proxy?
I would like to retrieve rows from a non shared DE which is present in Child BU. This has to be from Parent BU. Is this feasible?
Is it possible to retrieve non Shared DE rows with impersonation from ...
0
votes
2
answers
56
views
AMPScript: Is there an easy way to have dynamic date format based on Same Month vs Different Months?
I want to create a list of events that will show event start dates and end dates. I have a data extension that stores the StartDate and EndDates. Is there an easy way to make the date format dynamic ...
- 15
0
votes
0
answers
54
views
SSJS - Split Data Extension by column data
I have a Data Extension, All_campaigns, that contais:
cod_id
name
status
city
campaign
1472
Anna
Ok
Paris
Perfum_01
1472
Anna
Ok
Paris
Perfum_02
1472
Anna
Ok
Paris
Perfum_03
1473
Rob
Ok
New York
...
- 1
0
votes
1
answer
37
views
Ampscript LookupOrderedRows filtering by dates and raiseerror
I want to send an email to subscribers that will provide a list of courses where the Courses' end dates are before the subscriber's subscription expiration date. And if the there's no courses ...
- 15
0
votes
1
answer
124
views
API for Data extension update in sfmc salesforce marketing cloud
I need to push some data on daily basis from ERP to SFMC
The package is already created on marketing cloud (read, write on Data extension).
I created a first POST request :
Body :
{
"...
-1
votes
1
answer
41
views
Query on Wait until API Event in Journey Builder
I am trying to use the Wait until event feature on journey builder. As per your recommendation, I am not using a primary key. I am trying to update the Data extension with another record with the same ...
- 1
0
votes
1
answer
42
views
Marketing Cloud: Permission Denied for API Endpoints / Objects
Within Salesforce Marketing Cloud (ExactTarget), when accessing the BusinessRule object via the SOAP API, I am getting a permission denied error. I possess the unmodified and original roles for: Admin,...
0
votes
1
answer
40
views
Transactional API Journeys - Split decisions - Marketing Cloud
I would ask about the proper design and approach for Transactional Api Journeys with localized content. Imagine status Emails for 6 different countries. Right now it is done using a multistep Journey ...
0
votes
2
answers
100
views
sfmc sql query to update a data extension field using using like function in the same data extension
I am working on a slightly complex scenario and need your help figuring out the correct approach. I have data extension contains 3 columns (product family, product code, product description) each ...
- 1
-3
votes
1
answer
35
views
is there an smsMessageTracking to capture email information?
good afternoon team!
I'm building dataviews to get shipping information through automation for a DE
I managed to create the smsMessageTracking but I would like a model that does the same but to ...
0
votes
0
answers
57
views
Salesforce Marketing Cloud Journey Builder Campaign Member Activity sometimes allows both Contact and Lead ID but sometimes not
Sometimes I am able to enter both LeadID and ContactID in the Campaign Member Activity in Journey Builder but sometimes I can only select one of them.
I wonder if this is a local issue or global issue ...
- 21
0
votes
0
answers
31
views
Not receiving custom response email configured in Automated Response Email for Remaining Replies - SFMC RMM
While configuring RMM, I selected custom response email and updated the template. Now when users reply to the email, they are not receiving the custom response email.
I looked at other post regarding ...
- 5
0
votes
1
answer
54
views
execute an automation with an html button
I have the following code that executes an automation.
<script runat="server">
var api = new Script.Util.WSProxy();
var request = api.performItem("Automation", { ObjectID: &...
0
votes
0
answers
16
views
Retrieve more than 2500 records in ssjs [duplicate]
in ssjs data extensions how do I retrieve more than 2500 records?
-1
votes
1
answer
39
views
Marketing Cloud - Select MAX value from multiple columns [closed]
for each row I need to select highest value from 3 columns, somethings like below. However, for some reason I can't do this. Please help.
SELECT
SubscriberKey,
MAX(VALUE(Clicks_Syria),
VALUE(...
- 1
0
votes
1
answer
40
views
For loop in ssjs not working
why this code is not working?
<script runat="server" language="JavaScript">
Platform.Load("Core", "1");
var couponsDE = DataExtension.Init("...
0
votes
1
answer
40
views
Marketing cloud SSJS, where to see debug
Hello guys I have this code:
<script runat="server" language="JavaScript">
Platform.Load("Core", "1");
try{
var couponsDE = DataExtension.Init("...
0
votes
1
answer
55
views
How to link push send log to journey activity?
Is there a way to link push send log or the mobile push detailed report back to _journeyactivity?
- 273
0
votes
0
answers
47
views
Marketing cloud Mobile Push app connection
I'm currently connecting my client's app into MobilePush to send push notifications.
I've added APNs.p8 Auth Key, Key ID, Team ID, Bundle ID. For both IOS & Android, it seems enabled as below.
...
- 21
0
votes
0
answers
75
views
Postman cURL to SSJS, Getting Errors
I'm having trouble with converting Postman cURL to SSJS. My goal is to build a cloudpage to make an API call to an external platform to create records, but somehow my SSJS code does not work. Here is ...
- 71
0
votes
2
answers
66
views
Data Extension Default Value Length
appears to be 100 characters, is there a way either through Admin/Setup or Support to increase that?
- 19
0
votes
0
answers
21
views
Click tracking for links inside a SSJS Script
I are currently having issues with click tracking for certain links in emails. In my email I have a SSJS script that parses the JSON data it get from an MC Personalization triggered campaign and saves ...
- 13
0
votes
1
answer
40
views
Uploading an exclusion list of only email addresses
I have a list of only emails that i would like to exclude from a single send. Issue:
Since these emails may or may not be in our system, i do not have a unique id/subscriber key for them. Since it is ...
- 3
1
vote
1
answer
91
views
Journey Builder status report
I think the answer is no but wanted to throw this question out to the community to cover my bases.
Is there a report or other functionality that will give me the status of Journey Builder journeys?
In ...
- 19