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
0answers
23 views

Einstein Web Recommedation reporting buggy for clicks and purchases

We are using web & email recommendations out of Salesforce Marketing Cloud and have trouble with the reporting tab on the web recommendations. It shows weird values for Influenced % and ...
1
vote
1answer
44 views

SQL query to find unengaged subscriber confusion

I want to exclude subscribers who have not ‘opened’ or ‘clicked’ email in last 6 months. I have the below sql query. Is this SQL query correct? Does the final results of this sql query results have ...
0
votes
2answers
33 views

How to hide Interactive Email Form based on condition?

I am using the Interactive Email Form feature to allow submitting user data straight from the inbox and enable design configuration by non-technical Marketing people. I would like to enable a way to ...
1
vote
2answers
62 views

Einstein Engagement Frequency understanding

I am having issues understanding how the Einstein Engagement Frequency dashboard work. I see we have a high % of consumers who are oversaturated but I cannot see the reason why (apart from the number ...
1
vote
1answer
31 views

Using SSJS filter NotContains

Has anyone have success of using SSJS filters to exclude data that contains a particular string? I am trying to get a list of Marketing Cloud users that the AccountUser.Name doesn't contain the word '...
0
votes
0answers
17 views

Filter based on RecordTypeId (RecordTypeId not showing in fields) - Marketing cCloud

Our objective is simply to have a filter in the Root Parent BU based on RecordTypeId to copy (filter) records from the Salesforce Synced DEs to a another DE. The result of that filtered DE will be ...
0
votes
0answers
15 views

SQL Query Activity into FLE Data Extension

SQL Query activities will insert the literal string into a data extension field, even if Field Level Encryption is enabled. I want to select data from a view and insert it into a data extension, while ...
0
votes
0answers
19 views

Looking to Populate Hidden Field with Concatenated Date and Email in a Cloud Page / Smart Capture

I'm looking to populate a hidden field within my Smart Capture form with a concatenated value. I'm not sure if I'm setting up the Ampscript properly. I've tried to insert the AMPscript in a standalone ...
0
votes
1answer
23 views

Automation to prevent duplicate emails from sending a week apart

I have marketing cloud automation set up that puts our end users into one of 6 groups based on last character of their ID. Every month we send out an NPS Survey on the first Tuesday of every month and ...
1
vote
0answers
34 views

Any way to use the SFMC integrated Bitly link shortner within a Transactional SMS API JSON payload? [duplicate]

I created a Transactional SMS Send Definition via REST API (Transactional API), and am able to send SMS via API just fine. Is there any way to shorten a dynamic link that is passed in to the API via ...
0
votes
1answer
35 views

How do you deal with Non GSM Characters in API driven SMS?

We are sending API driven SMS for things like product out of stock and order confirmation. The data being sent into our endpoint sometimes includes non GSM characters (like registered trademark), ...
0
votes
1answer
23 views

How do I find the SubscriptionDefinitionID for each of my keywords in Mobile Connect

I added two new keywords today - a JOIN and Opt Out keyword. I need to find the SubscriptionDefinitionID that matches each of these new keywords. Does anyone know the easiest way to do this?
0
votes
1answer
60 views

Email Address As SubscriberKey in SFMC [closed]

Can you please tell me what are the main arguments against using Email Address as Subscriber Key in SFMC? I have been getting requests from our internal stakeholders to use the email as Subscriber Key ...
0
votes
0answers
14 views

Notifications push marketing cloud- failed-IOS

Good everyone, we are having problems with push notifications with IOS devices. The contact registration process is created correctly on the platform with the device id indicated and with the opted-in ...
0
votes
0answers
11 views

Extracting the data from GA Audience in SFMC

We've GA-360 enabled in SFMC. The GA audiences are coming through and can be used as a journey source. Can we also extract the information into a data extension the way we do it for synchronized ...
0
votes
1answer
24 views

Help with IF ELSE Statement in AMPScript

I am trying to add another piece of logic to this working code below to check if there guess is correct for those who fall after the else statement only. %%[ SET @sid = QueryParameter('sid') SET @...
0
votes
0answers
39 views

Get Campaign name from _Sent dataview [duplicate]

I downloaded the _Sent dataview to my server. Now I need to join the _Sent data with the campaign names to filter. How can I get from the _Sent dataview to the campaign name?
1
vote
1answer
24 views

Data Extension or Data Export log

I would like to see who has been exporting data from our data extensions in the past year but I am not sure if this functionality is available in Marketing Cloud. I have tried with Audit Trail (I have ...
0
votes
1answer
56 views

How to store Journey Report into a Data Extension

I have a Journey through which I am sending emails. I can extract the journey report from Analytics Builder (as a Excel file). Where is this report data stored in SFMC ? Can I access this data in a ...
0
votes
1answer
39 views

Unable to get percentage value in SQL Marketing cloud

Everyone The below query is working fine without bounce_rate condition. When I am adding the bounce_rate it is throwing an error. Anyone please suggest on this. SELECT j.emailname, j.emailsubject, s....
0
votes
1answer
30 views

Using landing page to receive data from a callback

I am using MC Event notification Service and I created a callback (using a 3rd party site) to receive data posted back from Marketing Cloud. I want to see if I can utilize a landing page to receive ...
0
votes
1answer
23 views

How to find out under which Attribute Group the 2 data extensions are mapped?

I am inside the Journey and DE is the entry source. There is a filter applied in Decision split known as ‘double_opt_in’ (can be true or false). This ‘double_opt_in’ field is not in Entry source DE, ...
0
votes
3answers
66 views

ClaimRowValue In SSJS alternative [closed]

Is there an alternative to the ClaimRowValue function in SSJS? this code in AMPScript %%[ var @couponRow var @couponCode var @CustomerID set @CustomerID = AttributeValue("CustomerID") set @...
0
votes
1answer
23 views

Get Version of Journey Builder in Custom Activity

Is it possible to get the version of Journey builder (inside Custom Activity) from which the execute method got triggered?? or Any other identifier to decide if its a new journey/ a version of same ...
0
votes
2answers
27 views

How to remove records which only have a street number and not a street name in the field of a data extension

Thank you in advance! Wanting to know the best way in Marketing Cloud to remove records in a data extension that only have a number under the street address field rather than a number and the actual ...
0
votes
0answers
33 views

Marketing Cloud Custom Activity Journey Builder Timeout

I have a Journey Builder which runs at particular instance with Sync DE. I want to fetch the journey builder entered contacts as an array inside Custom Activity JS in a single payload. Reason being, ...
1
vote
1answer
28 views

ContentBlockByName not resolving within AMP mime-type

We're very excited about using the new AMP mime-type available within SFMC, but are experiencing some troubles with the AMPscript Functional Reference ContentBlockbyName not resolving within the code. ...
0
votes
1answer
31 views

Does the Collect Tracking Code work across multiple websites?

The use case: I want to push website activity via the Collect Tracking Code into Marketing Cloud. I want to push data from multiple websites into a single Marketing Cloud business unit. Each website ...
0
votes
0answers
31 views

Outputting a variable via TreatAsContent(@QR_Code) into email doesn't render the image due to the image's src attribute changing during email send

I have a transactional email that is triggered via API - and one of the data points being passed in is a QR Code link. The data for this is simply an <img> tag that hits up Google's API to ...
0
votes
1answer
26 views

How to make Interactive Form in SFMC to accept only one response?

I have an email with interactive form that sends the result to a Data Extension. However, I notice that when a subscriber has responded more than once, it records all the responses in my DE. I want to ...
1
vote
1answer
28 views

Can we use React Native version of the SDK for Mobilepush?

We're using an iOS and Android app with Mobilepush. The Engineering team has already built the app code in React native version. If they use the react native version of the sdk would they get same ...
1
vote
0answers
13 views

Python FuelSDK 1.3.0 no longer working?

I had to revert from python FuelSDK 1.3 to 0.9, because as of around 2pm Eastern on 3-Mar-2021, the code was failing on authentication, the server response was failing the JSON parser. Anyone else ...
1
vote
1answer
35 views

SQL to not insert line if RecordTypeID = “123” or “123”

I have the below SQL in Marketing Cloud. I want to stop a new line being entered into my data extension if it contains one of two RecordTypeId's. Thanks in advanced! SELECT Contacts.Id, Accounts....
1
vote
1answer
50 views

Marketing cloud page to update data extension

Tracking data are collected in javascript while browsing the website. I'd like to save them into a data extension sitting in marketing cloud. These are non-identifiable personal data. I was thinking ...
0
votes
1answer
16 views

'IDFA' is used as a contact key for some contacts and 'unique keys' for other contacts

When I go to 'All Contacts'> 'Mobile Push' I noticed that some contacts have IDFA(advertiser ID) as Contact Keys. While other contacts have unique numbers as Contact Keys. Do you know why this is ...
0
votes
1answer
28 views

Individual Email Results not appearing for shared data extensions

We have been using different BU and so shared data extensions that comes from the Mother BU. We would like to use only shared data extensions (because we want to send from Email Studio and Journey ...
0
votes
0answers
21 views

Marketing Cloud Synchronized Data Source shows no Entities or Attributes

I try to sync some Sales Cloud objects into Marketing Cloud with the Marketing Cloud Connect Data Stream. So, when I go to Synchronised Data Sources, the Connection to my Sales Cloud is there, but the ...
0
votes
1answer
38 views

Question about Marketing Cloud open tracking pixel behaviour

I'm reading this documentation about MC and how it manages open tracking behaviour: https://help.salesforce.com/articleView?id=sf.mc_es_tracking_overview.htm&type=5 Essentially there is 1x1 ...
1
vote
2answers
54 views

API for Einstein Content Selection

I want to automate pushing new assets to Einstein Content Selection. Is there a way to do that like an API? Also I’m wondering if there is a way to mark assets that are already in SFMC Content Builder,...
1
vote
1answer
43 views

Marketing Cloud SQL using CHARINDEX and LEFT / RIGHT

im trying to grab the value of a text field in a Data extension. It has a specifix syntax: example_IWantToGrabThis_example I want to grab the value between the underscores. I think i need to use ...
1
vote
1answer
45 views

RMM configuration with SAP, dynamic Sender Profiles and Email to Case?

For our SFMC configuration we are using multiple Sender Profiles which should allow for the customers to reply, and have all their replies result in a case created in SF. One of the Sender Profiles is ...
1
vote
1answer
32 views

Exclusion List field in Mobile Connect

I have a customer's requirement to get the value of Exclusion List field in MobileConnect send, to do an automatic extraction of control group. Does anyone know if it's possible? I've been talking ...
0
votes
1answer
40 views

Convert date to month day using AMPscript

I have a DE with a date column in this format I desire to change this in the email to read 23 March and i am using FormatDate but it doesn't work Below is my code set @Outagedate = field(@row,&...
0
votes
1answer
75 views

Append a value to a Data Extension Field using SQL

I tried to follow the example used in this link, but I'm having trouble getting it to work. I get an err msg (Error saving the Query field.An unmatched parenthesis occurs in the query.). for ...
1
vote
1answer
39 views

Marketing Cloud SQL issue, Retrieving Latest six entries in Sent Data view with a minimum of 6

I want a data extension which has the latest six e-mail sent events from the Sent data view based on Eventdate, only when the subscriber has a minimum of six records in the Sent Data view I want to ...
0
votes
1answer
22 views

Is it possible with Import Activity to clear data extension if salesforce report is empty?

Hi I have created an automation to import data from saleforce report to overwrite data in a data extension. This is working fine when salesforce report is not empty, however, if the report is empty it ...
2
votes
1answer
23 views

Get ModifiedBy user ID that most recently modified a DataExtention

I'm making this SOAP API call to get info about data extensions in a targeted business unit. The only real piece of information I need is: who last modified the data extension. In looking at the ...
0
votes
1answer
30 views

How to get category (folder) Id of SSJS activities

I tries to create SSJS activity using REST API. Body of request looks like this: { "name": "ActivityName", "key": "ActivityKey", "...
0
votes
0answers
26 views

Blank email preview text

I am trying to follow this post to create a template that hide preview text. I created a template, added the following code in the <body> after <custom type="header">. <div ...
0
votes
2answers
47 views

Email Domain Segments Data Extension for IP Warm UP

We are starting our IP warm up process and have never done this before. Since we are transitioning from Pardot to Marketing Cloud, we are building lists of our most engaged subscribers in Pardot, ...