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
12 views

How can I avoid having my behavioral trigger content block show “undefined” for blank/null values in my product catalog?

I’m using a behavioral trigger content block to show product link, price, and size. Certain products don’t have a size in the product catalog, when they show in abandoned cart email an “undefined” ...
user avatar
0 votes
1 answer
34 views

Violation of primary key constraint

I have two data extensions. The first data extension called ClientDE has two primary keys - ClientID and LastPurchaseDate. The second data extension called LastPurchaseDE has one primary key - ...
user avatar
0 votes
0 answers
44 views

How to redirect Thank you cloud page to URL based on response

What I'm looking to achieve: (done)User selects item from list of items either a)within email form OR b)from fallback cloudpage smart capture form. (done)user then gets directed to thank you cloud ...
user avatar
  • 1
2 votes
1 answer
39 views

Utilize the same user for both MC Connect integration and admin/dev activities

Our client has run out of Salesforce licenses and he's asking us to install the MC Connector in order to integrate their marketing cloud instance with their org. So we only have one user to utilize ...
user avatar
  • 305
3 votes
0 answers
33 views

Guidance on using validation endpoint of salesforce journey builder custom activity [closed]

We are building an SFMC journey builder custom activity where configuration includes 3 screens in a wizard-like structure (Back / Next / Finish). On each screen, we would like to validate the ...
user avatar
  • 131
1 vote
0 answers
33 views

Debug push error using SFMC SDK

I'm testing to send push notification from SFMC to mobile app using the app configured in MobilePush with FCM server key and APNS p8 Auth Key set. I sent a test push notification using Mobile Push: ...
user avatar
  • 11
0 votes
1 answer
34 views

Retriving Data Extension that WILL BE used as Send Target in a Scheduled Email by User Interface

when scheduling a "One Shot" email, we have to choose the data extensions that will be used as Target Send and The Exclusions Datas if need. Is there a way to retrieve the data extension of ...
user avatar
4 votes
1 answer
57 views

There is a record count difference between the Job Data View and the SendJobs Tracking Extract

My Configurations: Job Data View SQL Query to select the last 90 Days of records from the _Job Data View (here) based on SchedTime. Send Jobs Tracking Extract (here) Setup to generate a CSV with the ...
user avatar
  • 228
0 votes
1 answer
27 views

Authentication to SalesForce Marketing Cloud API through Springboot

We are trying to authenticate to SalesForce Marketing Cloud through springboot security oauth2. By postman we can get an authorization token, but not from spring where we are receiving the error: { ...
user avatar
  • 121
1 vote
1 answer
53 views

Getting a random crash on iOS MarketingCloud/SFMC SDK

I recently updated to the Marketing Cloud v8.0.6 and SFMC v1.0.4. I am able to receive pushes but every once in a while will get a crash when setting the URLHandlingDelegate. Here is my current ...
user avatar
0 votes
1 answer
30 views

You have sent us an Illegal URL or an improperly formatted request. error in marketing cloud for <a> tag using AMP Script

I have added tag link in email template link below, link working in preview and test while sending actual send not working. <a href="%%=RedirectTo(@link)=%%" target="_blank">...
user avatar
  • 59
1 vote
2 answers
38 views

Remove spaces and accents from a value field to put it in a From Email Adress field - dynamic sender profile

I need to remove spaces and accents (special characters) and capital letters from the 'From Email Address' field in the sender profile. Indeed, I would like to compose a dynamic From Email Address in ...
user avatar
0 votes
1 answer
41 views

How to get only href value from link using AMP script?

I have one URL field coming from salesforce and i need only href instead of complete URL using amp script. <a href='https://www.google.com/?hl=en-GB&authuser=1' target='_blank'>Test</a>...
user avatar
  • 59
0 votes
0 answers
38 views

SFMC: Error when activation Journey with Whatsapp Activity

We are getting below error on Whatsapp activity while activating the journey Invalid object name 'C******._MobileOttJBActivitySendRequest'.The 'MobileOttJBActivitySendRequestInsert' procedure ...
user avatar
0 votes
1 answer
33 views

Retrieve info from another DE in Ampscript [closed]

I have 3 Data Extensions: one used as target which is the audience to contact one which stores products and email addresses. Here the email addresses match the ones present in the previous DE one ...
user avatar
  • 11
-1 votes
1 answer
73 views

How to manage Lead generation in Marketing Cloud?

We are migrating from Salesforce Pardot to Marketing Cloud . Currently in Pardot they have lead nurture form where a user sign ups in form and when they qualify , signed up user get converted as lead ....
user avatar
0 votes
1 answer
60 views

Contact count is much higher than number of emailable contacts

Our contact count in SFMC is being reported at twice the number of actual contacts we are syncing over two sendable synchronized data extensions (contact and lead). I've checked everywhere I can (...
user avatar
0 votes
1 answer
69 views

The datediff function requires 3 argument(s) [closed]

We have been working on this query for a while and can't understand what the error means that we are getting. The error is "The datediff function requires 3 argument(s)" SELECT a....
user avatar
  • 1
0 votes
0 answers
49 views

SQL _Click data for part of a URL string

I'm trying to query the last 6 months of clicks for a URL in SFMC. Because we add UTMs and parameter strings to the base URL, it changes in each email. I'm not having much luck using 'LIKE' but I am ...
user avatar
0 votes
0 answers
45 views

Marketing Cloud Email Template Global Styles not sticking to emails

We've built our email templates using the drag-drop visual editor in Content Builder. Within the template, we've made the links to be our brand colour (e.g. purple). When adding links to a text box in ...
user avatar
  • 3
0 votes
1 answer
25 views

.vtt file formats be hosted on SFMC - Content

Can .vtt file formats be hosted on SFMC? We are facing an issue hosting this file type. We want to add this to our Interactive CloudPage
user avatar
-1 votes
1 answer
38 views

Exclusion script for Journey Builder send

I have two emails with identical content - one is used in one journey, the other in a second journey. However, I want to be sure that if a person happens to enter both journeys within a short ...
user avatar
  • 1
0 votes
0 answers
25 views

Can we use wait until chat response activity after a template message?

I cannot send sessional message after a wait until chat response activity which is capturing response from a template message.
user avatar
0 votes
1 answer
33 views

How change label in <a> tag in email template?

I am trying to add tag in email template like <a conversion="false" data-linkto="other" href="%%=v(@URL1)=%%" style="color:#0A4A8E;text-decoration:underline;&...
user avatar
  • 59
1 vote
1 answer
70 views

Data Extension Caching when doing Lookups

Script description: There is a script that aims to retrieve up to 200 records from the Data Extension, perform some manipulation with retrieved values and lastly delete processed records from the ...
user avatar
  • 2,384
0 votes
1 answer
40 views

Error MarketingCloudSDK 8.0.6 IOS Swift

good afternoon, I am working with the latest version of marketingcloudsdk 8.0.6. I have followed the documentation correctly, however, my configuration code throws me this error and it is the one in ...
user avatar
0 votes
1 answer
23 views

Pass a variable from AMPscript block to Client side JS?

I have an index.html file with the following structure: %%[ SET @contactId = AttributeValue("_subscriberkey") ]%% <!DOCTYPE html> <html lang="en"> <head> &...
user avatar
  • 13
1 vote
1 answer
32 views

Ad Studio Audience Size Minumim?

We are wanting to serve truly 1 to 1 social and search ads. I wasn't sure if it would be possible to do that via Ad Studio or Journey Builder. Are there minimum audience size requirements to load ...
user avatar
  • 13
0 votes
0 answers
18 views

Count in Email send doesn't tally with the count in Journey builder canvas or Sent view DE or count in sendable DE

In my DE (i.e. kp_de_1record) has 2 records, and I used simple journey to send out a simple email. The count in journey builder canvas correctly display 2 count. However, the count in Email send ...
user avatar
  • 29
0 votes
1 answer
68 views

Data retention policy doesn't apply to existing records in data extension?

I have a data extension which includes a few records. It was not set up a data retention policy in the first place. I have reconfigured the data retention through Contact builder so that individual ...
user avatar
  • 146
-1 votes
1 answer
25 views

Retrieving subscriber keys via SQL query

I'm trying to retrieve subscriber keys for a batch of email addresses I compiled after running the subscriber engagement report. We're aiming to target more engaged customers for our upcoming Memorial ...
user avatar
0 votes
1 answer
25 views

Are subdomains included in a Private Domain for Marketing Cloud without SAP?

Based on this article: https://help.salesforce.com/s/articleView?id=000318538&type=1 When I get a private domain out of SAP, are subdomains like campaign.company.com or mail.company.com included? ...
user avatar
0 votes
1 answer
45 views

Getting error when upserting data extension with SSJS

I am trying to query the contact and another data extension and then upsert a third data extension called customerETL. Everything works if I hardcode values into the function but when I pass values ...
user avatar
  • 382
0 votes
0 answers
32 views

How to retrieve lists that a subscriber resides on with AMPscript only?

I successfully retrieved the Subscriber Object for a subscriber that I manually created for testing purposes. This subscriber is active on All Subscribers list and also on 4 publication lists. %%[ ...
user avatar
  • 13
-1 votes
1 answer
35 views

Marketing Cloud SQL To Convert Epoch (string) to Date Time? [closed]

I am trying to convert from Epoch Date to Regular date. I tried the below SQL but it didn't work. SELECT epdate, convert(varchar, convert(date, epdate, 105), 101) AS epdate FROM tablea Any idea ...
user avatar
  • 525
0 votes
1 answer
24 views

how to use child standard object data in the personalized mail while your journey salesforce data entry event is on parent object

I am creating a journey for which the entry event is a salesforce data event on a contact object. But I have to use child object field data in the mail to personalize the mail. For example Parent ...
user avatar
  • 1
0 votes
1 answer
38 views

ampscript lookup to limit number of rows to display if there are more than 5 records

hello currently working on an email that has table and the records are coming from another DE so im using LookupRows using contactId, I want to limit the number of records to be displayed to 5 however ...
user avatar
0 votes
0 answers
53 views

Data Extension Entry Source Filter Doesn't Work

Journey is having a super simple filter i.e.CREATED_DTE is not null. Somehow the journey doesn't admit any record. EMAIL_ADDR_TXT relates to subscriber on Subscriber key. Any thought/help is ...
user avatar
  • 6,161
0 votes
0 answers
16 views

How to prevent retrieving Private Lists in Marketing Cloud?

I'm trying to retrieve Subscriber's public lists only, but it keeps returning public lists + a private list called "All Subscribers". I've tried both following methods but neither worked, ...
user avatar
  • 13
0 votes
1 answer
54 views

Moving over 2000+ old Data Extensions to new folder for review/delete

I am trying to move multiple old DEs into a new folder. And, with my limited experience with SFMC Objects & WSProxy/SSJS, I dug deep into multiple resources & samples codes like (Zuzanna - ...
user avatar
0 votes
1 answer
29 views

Email thumbnail could not be retrieved under Individual Email results

We have Marketing Cloud connected to Sales Cloud connected with MC Connect. Now these emails are shown as Individual Email Results in Sales Cloud. All works well but the problem is its not showing ...
user avatar
1 vote
1 answer
82 views

No such module "SFMCSDK" after migrating to v8

I've followed the migration instructions for updating to v8 of the Marketing Cloud SDK. Docs here: https://salesforce-marketingcloud.github.io/MarketingCloudSDK-iOS/get-started/get-started-migration....
user avatar
0 votes
0 answers
30 views

Einstein Product Catalog duplicate issue

For Einstein, I have a product catalog import on SFTP where the product code is mapped to catalog import data product code which would contain one or more similar records with the same product codes ...
user avatar
-3 votes
1 answer
44 views

An error occurred while checking the query syntax. Errors: Incorrect syntax near ')' [closed]

Hello i want to count with condition but i got syntax error , i don't where the issue is this is my query : SELECT Statut__pc as 'Statut', Count(CASE OptinInvitationsVente__pc when 'true' THEN 1 ELSE ...
user avatar
2 votes
1 answer
42 views

Avoid break line when the field is empty breakline

I am using AMSCRIPT to personnalize some sender details in an email block at the end of the email. This block contains several lines : name of the account first name, last name, phone email adress ...
user avatar
1 vote
2 answers
86 views

Notification icon configured for MobilePush on Android, yet it's not displayed

We can't seem to get Marketing Cloud (MobilePush) to display the icon we've configured it to display on Android. As far as I can tell, we've followed the documentation correctly, but the system ...
user avatar
  • 131
0 votes
0 answers
24 views

API Interactions not being entered into Journey

I am using the Journey Builder's "Fire Entry Event" REST API to enter contacts into my Journey in Marketing Cloud. When firing the event using a payload similar to this: { "...
user avatar
-1 votes
1 answer
33 views

IF Ampscript - if a record from one data extension exists in another

Is there a way to write an IF ampscript to say: If records from Data extension A, exist in Data extension B, then display 'Welcome Back' ELSE display 'welcome'?
user avatar
0 votes
1 answer
39 views

How to create a data extension from a Mobile List?

We have created a filtered list in Contact Builder: Contact Key not null AND Email Address null AND Mobile Number null AND Device ID null AND CUSTOMER_ID null This lit identifies the subscribers that ...
user avatar
0 votes
1 answer
36 views

Why does my publication list array return undefined in Vuejs?

I'm learning to build a custom preference centre and trying to display all the lists for a subscriber. I retrieved all the lists like below: <script runat='server' type="text/javascript"&...
user avatar
  • 13