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
2answers
32 views

Pushing data from one data extension to another

In Marketing Cloud, I have two data extensions. Both Data Extensions are being populated via entries in a journey. One runs off of the contact object and the other runs off the opportunity object. The ...
-4
votes
1answer
40 views

What is cast and convert in SFMC? [closed]

What is cast and convert in SFMC eg- SELECT Count(*) as Count, CAST(GETUTCDATE() as date) AS Day, GETUTCDATE() AS [Updated Date] FROM ENT.[Demo4 Contact__IQ] WHERE [Status Code] = 'Active'
0
votes
2answers
58 views

How would I retrieve data from one data extension and add it to another Data Extension? [closed]

SourceCodes are fields we assign to each email. They correspond to the email name. I need to retrieve the SourceCodes from Data Extension One (our source DE used for sending) and append them to the ...
0
votes
0answers
21 views

How can I get the contactID related to a contactKey in Marketing Cloud via SQL [closed]

We are using the users email address to set the contactKey in MC from our app for the purposes of using it for Mobile Push. For our backend systems, we need to feed back the deviceID to the external ...
0
votes
0answers
17 views

SQL query to find the name of the Sendable Data extension that was used to send a email

I am checking if there is a way to fetch the name of Sendable Data Extension to which the Email was being sent to using query. I have used Data Views to find the ListName. But I want get Data ...
1
vote
1answer
31 views

Marketing Cloud Query Activity SQL Syntax Error [closed]

New to SQL so be nice! :) I'm trying to run a simple SQL query in Automation studio, unfortunately I am getting this error - "An error occurred while checking the query syntax. Errors: Incorrect ...
0
votes
1answer
15 views

Stopping a journey while an email send is taking place (throttled)

Bit of an edge case here but in a live journey, a stakeholder wants to limit the number of emails sent via an engagement split as it's for a survey and they have a cap on the number of responses they ...
0
votes
1answer
23 views

Email Notification needs to be sent to internal team after every form submission

I have a landing page built in cloud page in SMFC with the smart capture form. The form is submitting the data to a DE table just fine. Currently right now I am exporting this data manually to sftp ...
0
votes
1answer
26 views

Trouble Creating Custom AMP Script Message

I am trying to create a custom email message using IF THEN statement that reads an Attribute through our DE. The message should pertain to what "card tier" the client is. Salesforce keeps ...
-1
votes
1answer
22 views

SQL query to find Job ID and email name for triggered & scheduled email sends

I was trying to implement this answer given in StackExchange - Query for Emails sent in the past month, unsubscribes opens, clicks for each If you look at, “III-C. SQL Query”, Paragraph in the answer, ...
2
votes
1answer
31 views

Journey Builder Transactional API with SFDE not Creating IER

Title says it all. I have a Transactional API Journey Builder with a DE located in Salesforce Data Extension. I moved it from DE to SFDE as you cannot assign a SFDE directly from Journey Builder. I ...
0
votes
0answers
14 views

Push Notifications sent to iOS always fail

I am integrating the MarketingCloudSDK v7.5.0 in a iOS app. I configured the SDK for receiving push notifications and I also configured the APNs key p8 in Salesforce page. When I send a push from ...
0
votes
0answers
23 views

Marketing Cloud File Convert Data Extract Type adding empty rows

Does anyone experience the following using the file convert extract type? When i use this, the file convert to UTF8 extract will add empty rows between each valid rows, even when I use the Line Feed ...
0
votes
1answer
51 views

Struggling to authorize a web app integration via Postman [closed]

I have created a web app component in Salesforce Marketing Cloud, and now I'm trying to get the OAuth2.0 flow to work in Postman. First, I use the Authorization tab in Postman to request a token. ...
1
vote
0answers
23 views

How to prevent Duplicate Mobile Contacts

My client is syncing Sales cloud data into Marketing using Connect. Obviously, it instantly creates contact with mobile and email addresses associated with one contact. At the same time, we are ...
0
votes
1answer
36 views

Find the ‘total sent’ for each JOB IDs in last 1 month along with ‘list name’ it was sent to [closed]

Currently by using this query, I get the number of total_sends for a particular JOB id. But I want to modify the Query so that it shows total_sends , ListName , Date for that each job ID within a ...
0
votes
1answer
20 views

Can we get the current logged in user's id in Marketing cloud script activity? [closed]

I want to run the script based on the logged in user. So can i get the logged in user's id inside my script activity? If yes, what is the syntax to be used?
0
votes
0answers
25 views

RetrieveSalesforceObjects from child BU

I am trying to use the RetrieveSalesforceObjects() function to look-up an object from child BU but the sync is to Parent BU (and we have sync de in shared de). Is there anything different I have to do ...
0
votes
1answer
31 views

AMPscript <= not working correctly past a certain number

I'm new to ampscript and generally only write it in line, so that might be my problem. However, when I use the code below in my SFMC email, OrderTotal values of 100+ are getting the "OrderTotal &...
0
votes
1answer
30 views

Extracting Monthly Report using SQL for the email templates that have similar name [closed]

We send a number of Newsletter everyday. We follow the naming convention for the email templates. For example : NL_US_OutfitDress_23032021 NL_US_OutfitDress_22032021 NL_US_OutfitDress_21032021 Last ...
1
vote
0answers
29 views

Uploading Image from Cloud Page

I'm trying to uploading an image from the marketing cloud page using the below code and update the published image path in the DE. I'm able to upload image successfully into the content builder but ...
0
votes
1answer
101 views

How to use SQL LEFT JOIN in Salesforce Marketing Cloud

I have questions around SQL join. I have 2 tables customer and events One customer can have optin/attend/Cancel multiple events. One customer can have Confirmed/planning/Cancel multiple Orders. now I ...
0
votes
1answer
20 views

Two MobilePush apps connected to the same mobile app

What are the impacts of connecting the same mobile app to two different MobilePush apps on Marketing Cloud? The same contact can log in to different accounts through the mobile app, and hence the ...
0
votes
1answer
30 views

SFMC Reference Block vs. Ampscript code

Quick Question: Is there a difference between a Salesforce Marketing Cloud Reference Block versus an ampscript code like "ContentBlockbyID"? And if you make an update to the source content ...
1
vote
0answers
6 views

Can Marketing Cloud In-App Messages be exposed in non-mobile web experiences? [closed]

I understand that In-App Messaging helps deliver messages to iOS and Android devices...but can it also deliver and display messages for traditional browser experiences? Is it intended for those use ...
1
vote
1answer
32 views

multiple lookup rows in a statement

I am looking up rows from a data extension to grab the Product (@Product) and Status (@Status) using App_number as the lookup value. I want to then add a conditional statement in my html to the values ...
0
votes
1answer
33 views

Campaign Member Status VS Campaign Member Activity

what is the difference between Campaign Member Status and Campaign Member Activity fields? They seem quite the same and i cannot understand their difference. Campaign Member status indicates the ...
0
votes
1answer
48 views

Is it possible to automate reports in Marketing Cloud?

I need an automated solution for generating an account send summary. It would be ideal to send this data to a data extension. I tried to accomplish this using a tracking extract but it doesn't provide ...
0
votes
1answer
25 views

RMM Save to Data Extension

Can we set up a script in RMM to save email responses into a data extension? My original idea was to set up an inbox parse content and then ship it to an SFTP, but, that is less than ideal if there is ...
0
votes
1answer
25 views

MobilePush Fence Entry & Fence Exit information

We need to send push notifications when a user enters/exits a location based on some conditions. I have stumbled upon this MobilePush products faq, where it is stated: What kind of data are captured ...
0
votes
1answer
54 views

SFMC - Journey Builder - custom activity - Content Builder Templates

I am trying to replicate the standard feature i.e I want to show the Content Builder Templates dynamically inside Custom Activity based on the Folder Selected. Requirement: On the Custom Activity UI, ...
0
votes
1answer
28 views

Extracting ObjectID of an Automation

I am not sure what I have done wrong but I am not able to extract the ObjectID of an Automation. Here is my code var prox1 = new Script.Util.WSProxy(); var cols = [ "Name", "ObjectID&...
0
votes
0answers
11 views

Dynamic Text in Mobile Push cloud page for Outbound sends

I am trying to send dynamic text inside the Mobile push Cloud page. I am able to send if the attribute value has no spaces in between, but if there are spaces I am unable to load the Mobile push cloud ...
1
vote
1answer
28 views

DateTime is stored in SFDC as UTC, then sent over to SFMC via Connector and is converted to Central Time - need to reconvert back to UTC

I have implemented Connector between SFMC and Sales Cloud. The date/time values that are brought over with various objects, when they arrive in SFMC, they seem to be converted to CST (SFMC servers ...
0
votes
0answers
15 views

Unable to Capture RMM_ReplyBodyText personalized string in Triggered Send Data Extension

I am trying to capture various RMM personalized string in triggered Send data extension when Forward using triggered send is enabled in Custom Reply Mail Management Settings of Sender Profile. I can ...
1
vote
0answers
14 views

Emphasize purchased products & wishlisted products in Einstein Recommendation

We now have a use case where we need to get Einstein recommendation to emphasize products the customer has added to wishlist & previously purchased, before logics that personalize based on product ...
1
vote
1answer
45 views

New behavioral triggers Abandoned Cart block showing one product twice with regular and sales price

We are using the new Behavioral triggers block and we are having an issue... Most of the time, the product is showing twice. It appears to be showing the Master and Variant from the catalog. But I ...
0
votes
1answer
35 views

Marketing Cloud: AMPscript redirect not working

When trying to use 'redirect', my 'starting' page will no longer load (returning the 500 error). Not sure what I'm doing wrong here. FYI: If I remove the redirect code, the page loads just fine. ...
0
votes
0answers
9 views

Desktop/Mobile value with Data Extract Activity

I want to use the Data Extract Activity to evaluate who has opened mobile. For this I would like to get the calculated value "mobile or desktop" like in the Analytics Builder. Currently I ...
0
votes
1answer
16 views

Unable to create Campaign Hierarchy in Marketing Cloud

I have created a Campaign in marketing cloud but I am not able to find any way to create child campaign for it. Can we create Campaign Hierarchy in Marketing cloud just like we do in Sales Cloud?
0
votes
1answer
19 views

Salesforce Marketing Cloud Sending Data Extracts to Another (non-SFMC) SFMC Site

Is it possible for Salesforce Marketing Cloud to send a data extract (from a data extension) from SFMC Safehouse location at the business unit's sFTP to a completely different sFTP site located on ...
0
votes
1answer
31 views

How Push notification syncs between different device id for a contact

We are in the implementation phase of mobile push notifications. I want to understand how push notifications sync between different device id's. Lets say a contact have three device id: one for iPhone,...
1
vote
1answer
29 views

SFMC SSL certificate in Third Party API request

I want to call a Third Party API that requires a SSL certificate. How can i use a SSL certificate for these request using SSJS or Ampscript?
1
vote
1answer
28 views

iOS sfmc_refreshMessages() always returns false

After updating the MarketingCloudSDK from 7.1.0 to 7.4.0, sfmc_refreshMessages() always return false. Until V7.1.0 sfmc_refreshMessages() use to return true if cloud server had new messages or when ...
0
votes
0answers
21 views

Android resource linking failed on jetified Android MarketingCloudSDK version 7.3.1

compileSdkVersion = 30 targetSdkVersion = 29 gradle plugin version 6.5 android.enableJetifier=true android.useAndroidX=true Android MarketingCloudSDK 7.3.1 Using the jetified version of the Android ...
0
votes
0answers
41 views

Mobile Push message is not being Received

We have recently implemented Mobile Push SDK for our Android App and we were able to see that the attributes are getting injected successfully on Contact Builder. However, on performing a Mobile Push ...
-1
votes
0answers
46 views

How to pull data from salesforce to Marketing cloud Data extension using the access token through cloud page

I need help with how to pull records in to Marketing cloud Data Extension using SSJS and API.I have successfully got the access token through OAuth Access token. <script runat="server">...
0
votes
0answers
22 views

SSJS Execute SQL and Retrieve Result

Within SSJS, i want to execute SQL to retrieve a filtered data set from data extensions and views. Then i want to insert that data as a payload into a destination DE. I got the second part working ...
0
votes
0answers
25 views

How to retrieve value from KeyStore with AMPScript

I created a salt key in the SF KeyStore; how do i retrieve the key and use it in AMPScript? Thanks.
1
vote
1answer
66 views

Connect SMFC to Github

Has anyone had any success connecting things like content builder or cloud pages to GitHub? I have been searching far and wide and have come across this amazing repository that almost does what I need ...