New answers tagged

0 votes

Distributed Marketing displays error during email preview

When previewing the Distributed Marketing email from Experience Cloud, the _MessageContext AMPscript personalization contains a value of 'PREVIEW'. Since the Destributed Marketing email preview does ...
user avatar
  • 2,585
0 votes

Violation of primary key constraint

Assuming you want just ClientID as the primary key and the most recent date only, I would recommend going with a ROW_NUMBER() and Partition instead of GROUP BY and DISTINCT. Something like below ...
user avatar
  • 27.9k
1 vote

Next-gen Migration from MarketingCloudSDK 7.6 to 8.0.x

Not sure if the dependencies have been cleared properly. If cocoapods is being used, please do pod deintegrate and then add 8.0.6 version of MarketingCloudSDK and 1.0.4 version of SFMCSDK. If the ...
user avatar
1 vote

Unable to Insert Date into Data Extension via SSJS

As you noticed the date field needs to be in ISO 8601; however your example has it statically coded, so I am assuming that you got the date-time from a data extension or as a result of a SOAP API call....
user avatar
  • 164
0 votes

FB Leads integration to SFMC

Just use this official app from AppExchange, and follow the steps described there. Once it is installed, you should log in to Facebook with a user who has access to the Facebook Page where the lead ...
user avatar
  • 16.9k
0 votes

Marketing Cloud SQL ORDER BY not working

Your question is very interesting, I confirm ORDER BY can only work with TOP NUMBER not TOP PERCENT. I guess the reason for this is that SFMC wants to control SQL performance with ORDER BY, that's why ...
user avatar
1 vote

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

I'd suggest mirroring Send SOAP object data into a DE and comparing those send jobs to your two sets. This aggregated data is for sends from account inception. I suspect the discrepancy is related to ...
user avatar
  • 27.8k
2 votes

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

This is not the full answer - generally, there are things that I would be cautious of, like risking too many open sessions which could invalidate the one for the connector, but I have never been able ...
user avatar
1 vote

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

So, it is not something simple you can do via JobID - but if you have the name or customerkey you can. You would need to utilize the SOAP API for this. You would need to access the EmailSendDefinition ...
user avatar
  • 27.9k
1 vote
Accepted

Getting a random crash on iOS MarketingCloud/SFMC SDK

[[SFMCSdk mp] setURLHandlingDelegate:self]; The above line has a direct reference to self which is accessed inside the block which holds the reference and may cause the bad access issues. Request to ...
user avatar
1 vote

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

Your CASE statement is incorrect, the WHEN goes first. SELECT Statut__pc as 'Statut', COUNT( CASE WHEN OptinInvitationsVente__pc = 'true' then 1 ELSE NULL END ) as "CountOptinVentes&...
user avatar
  • 181
2 votes

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

I would use a combination of AMP Script and SSJS to handle this. I would setup the workflow as follows: Step 1) Get the Value %%[ SET @accountname = AttributeValue("Opportunity:Account:Name&...
user avatar
  • 181
2 votes

Authentication to SalesForce Marketing Cloud API through Springboot

Setting the authentication scheme to form seems to do the trick: @Bean OAuth2ProtectedResourceDetails oAuth2ProtectedResourceDetails() { final BaseOAuth2ProtectedResourceDetails resourceDetails = ...
user avatar
  • 121
0 votes

How to manage Lead generation in Marketing Cloud?

You basically have two options: Create the lead in Sales Cloud immediately upon the initial form submission in SFMC, utilising ampscript Use contact deletion to remove the record with email address ...
user avatar
  • 16.9k
1 vote

The datediff function requires 3 argument(s)

I think you have a misplaced closing parenthesis If you break out your NOT IN statement, it looks like: SELECT Id FROM nihrm__Booking__c_Salesforce WHERE Date > dateadd( day, datediff( ...
user avatar
  • 27.9k
0 votes

Contact count is much higher than number of emailable contacts

Contacts are created in a variety of ways. One of them is Synchronization of User / Lead / Contact through MC Connect. Other ways exist and it's impossible from the outside to determine the root cause....
user avatar
2 votes
Accepted

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

The issue is your utm_term parameter which appears to be the linkname personalization string. If you add an alias to the <a tag such as: <a href="%%redirectto(@url1)%%" alias='CTALink'&...
user avatar
  • 7,367
0 votes

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

Honestly there is no simple solution here so it is gonna be a mess and far from efficient in AMPscript. Would be better to manipulate prior to send. Below is partial example on approach: %%[ set @...
user avatar
  • 27.9k
1 vote
Accepted

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

You can use regular expression in Ampscript. This will isolate the link from within the a tag in your ampscript variable. You can then use the link within RedirectTo function, allowing you to have it ...
user avatar
  • 16.9k
1 vote
Accepted

Avoid break line when the field is empty breakline

Judging from your comment: The line breaks that were physically entered between your variables are the problem. Since you previewed as text - pure text emails understand and display them as line ...
user avatar
1 vote
Accepted

Retrieve info from another DE in Ampscript

You simply need to have a fallback scenario in your script, which is triggered in case no matching records are found in your vol_Newsletter data extension. Keep in mind, that LookupRows function ...
user avatar
  • 16.9k
0 votes
Accepted

Ad Studio Audience Size Minumim?

Yes, there are different minimum Advertising Audience sizes for all networks. According to the documentation the numbers are: Facebook: minimum 20 (recommended 100) Google AdWords: minimum 1000 ...
user avatar
  • 5,302
2 votes

.vtt file formats be hosted on SFMC - Content

No. List of supported file types can be found here.
user avatar
  • 5,302
0 votes

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

Your question is really unclear, but I will do my best giving it a shot. I assume you want to replace Test in the HTML contained in your @URL1 variable with a proper LastName taken from somewhere else....
user avatar
  • 16.9k
2 votes
Accepted

Data Extension Caching when doing Lookups

SFMC has some caching settings/business rules for small Data Extensions. I'd suggest opening a support case to see if it can be adjusted. There's a hint about it in this knowledge base article. ...
user avatar
  • 27.8k
2 votes

Error MarketingCloudSDK 8.0.6 IOS Swift

Starting 8.X, SDK initialization should be done as SFMCSdk.initializeSdk(ConfigBuilder().setPush(config: mobilePushConfiguration, onCompletion: completionHandler).build()) Please follow the link ...
user avatar
0 votes
Accepted

Pass a variable from AMPscript block to Client side JS?

You can just print the ampscript variable where you normally set a client-side javascript variable. In the below example, I set the cid to the contactId ampscript you already declare in the top: %%[ ...
user avatar
  • 16.9k
1 vote

No such module "SFMCSDK" after migrating to v8

Please use MarketingCloudSDK 8.0.6 version and SFMCSDK 1.0.4. Before upgrading the versions, please remove the SPM cache which usually be in ~/Library/Caches/org.swift.swiftpm/ and also remove the ...
user avatar
1 vote

Initialisation of SFMCSDK is not compatible with Objective-C

First you need to create pushConfigBuilder and build the PushConfig. Then initialize the sdk as shown below: PushConfigBuilder *pushConfigBuilder = [[PushConfigBuilder alloc] initWithAppId:@"&...
user avatar
0 votes
Accepted

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

Answered my own question - Finally figured out. Here is my code: <script runat=server> Platform.Load("Core","1"); var prox = new Script.Util.WSProxy(); // Sets the Proxy ...
user avatar
2 votes
Accepted

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

All existing records will have the start time be when you set the retention. This is because the entry time of a record to a DE (hidden field _CreatedDate) does not exist until you set a data ...
user avatar
  • 27.9k
0 votes

Salesforce Marketing Cloud JB Split based on date - specific time

the below example from salesforcefan.com to send out email hourly by leveraging on wait by attribute activity could be the alternative solution to your question. [https://www.salesforcefan.com/post/...
user avatar
  • 29
2 votes
Accepted

Retrieving subscriber keys via SQL query

So there were a few syntax issues in your Query (also next time please put the code in a codeblock and not an image as images can be misleading in char as well as it makes it hard for us to copy/paste ...
user avatar
  • 27.9k
2 votes
Accepted

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

Subdomains are not included. Note: Don’t just make up sub-domain names. If company-email.com is the SAP domain, and you want to add “order.company-email.com” -- it must be set up as private domain. ...
user avatar
0 votes

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

The only thing that can make the icon not display correctly is it being invalid with regards to Google's requirements. See Google's notification icon requirements. Also, search for Android Asset ...
user avatar
  • 4,139
0 votes

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

I've been able to figure out what was wrong. Please check the code right below that might help others. %%[ var @Rows, @Row, @ContactId, @TeamID, @Name set @ContactId= ContactId set @Rows = ...
user avatar
  • 1
2 votes

Getting error when upserting data extension with SSJS

Seems like the version of JavaScript running in MC, does not support negative parameters in the slice() method: var result = dataConcatList.slice(0, -1); Replace it with something like this: if(...
user avatar
1 vote

Email thumbnail could not be retrieved under Individual Email results

The problem was that the remote site was not configured for cloud marketing.
user avatar
1 vote

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

You might want to check this question: How to correctly convert Unix Timestamp to datetime in SQL A plain convert is not enough - you need to add the number from your string to epoch start date ('1970/...
user avatar
2 votes

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

You'll need to check the rowCount of your lookup first. If there are less than 5 rows it won't compile. <table border="1"> <tr> <th>Order Number</th> <th>...
user avatar
  • 27.8k
1 vote

Why does my publication list array return undefined in Vuejs?

I figured it out that I had to stringify the subLists first: subLists = Stringify(subLists)
user avatar
  • 13
0 votes

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

You have to identify how a record in DE A is same as the one in DE B. Then you can use LookupRows function. I would combine it with Iif function. Here is a sample in email: %%[ set @value = ...
user avatar
  • 136
0 votes

AMPscript: Using date in LookupOrderedRows is not working

When you do the Lookup with just the "Date" value (MM/dd/yyyy), the SFMC assumes the time to be "12 AM". Hence it will look for the same exact date with time as 12AM.
user avatar
0 votes

Is there any AMPscript live editor available?

Yes there is! You can use ampscript.so, we have an AMPscript live editor and preview tool with syntax highlighting and autocomplete. It is perfect if you just want to learn AMPscript or host your ...
user avatar
0 votes

Filter Synchronized Data coming into Marketing Cloud

very useful. The filter criteria on our Marekting Cloud platform is greyed out, not able to use it. Any idea why is that?
user avatar
0 votes

Salesforce Marketing cloud - Object - Which attribute can be queried in soap API

You are looking for the "IsRetrievable": true part when doing Describe method. If it is "true" then you can retrieve a value for the specified property. Unfortunately, you cannot ...
user avatar
  • 2,306
1 vote

How to create a data extension from a Mobile List?

This is covered in this KA article Use a SQL Query Activity to query from this list into a new Data Extension (DE). i. Within the Query, select the "Overwrite" Data Action. If either of the ...
user avatar
  • 7,367
2 votes
Accepted

How to get Send Classification ID, Delivery Profile ID and Sender profile ID in SFMC?

SendClassification & SenderProfile >> Retrieve them through a standard SOAP API RetrieveRequest; You are looking for the ObjectId. DeliveryProfile is known to not be possible at this stage (...
user avatar
0 votes
Accepted

CDP not visible in Sandbox

Change! Official Salesforce support stated that there is NO sandbox version of Salesforce CDP.
user avatar
  • 1
1 vote

Multi-org integration steps: do I need multiple integration users?

Definitely! We had 1 Salesforce instance connecting to a Multi-Org Marketing Cloud instances. After a lot of tests and asking support, the only way to get stable sync was having 1 integration user in ...
user avatar

Top 50 recent answers are included