New answers tagged

0 votes

Mobile Connect Import

to resub via QUEUEMO, so long as the sub count is not massive, (If you do this for more then 25k records you will likely get a reverse escalation) you can toss and IF/ELSE ampscript argument in the ...
1 vote

Subscribers Segmentation restrictions

Not knowing more context, I will recommend you either of these two options: You should not allow access to the Enterprise BU to anyone but few admins, and all campaign operations should happen from ...
  • 17.6k
0 votes

Journey Builder Sends folder not visible in Email Studio > Tracking Page

Just finding this question. If the issue is a permissions issue, then the permission you need to allow is in: Transactional Sending > Messages > Tracking. This is outside of the 'Email' ...
  • 373
1 vote
Accepted

Select * in SQL within Marketing Cloud does not update the records in a Data Extension

Since it solved the problem, I'll post my comment here: You can drag and drop your source data extension from the left to enter all columns simultaneously. I don't know your use case, but if you try ...
  • 3,711
2 votes

How to find the domains which never open the emails in marketing cloud

You can get this information by comparing the _Sent data view with the _Open data view (although note, that since the iOS 15 update came out, tracking opens is not a reliable metric anymore). Once you ...
  • 11.7k
0 votes

Einstein Email Recommendations - Default Values

Ensure in the Scenarios for the recommendations logic that there are one or two Site Data Scenarios down towards the bottom of the scenarios being used, like "Top Sellers", "Most Viewed&...
  • 7,826
1 vote

Removing cl.s10.exct.net from links in Marketing Cloud Content

That is your click tracking mask. You would need to remove click tracking to stop that from wrapping this URL. You could obfuscate that it is a link via some hacky AMPscript tricks and have it so only ...
  • 28.7k
0 votes

Can I use an attribute as a link on a button in Email Content?

I was able to figure this one out myself, but then I ran into another problem. You have to change the Email Content, save the content, and then update the email content in the journey as well. I ...
1 vote

MarketingCloud SDK Crash When Migrating to Android 12 - Xamarin Android

Android 12 support is included in v7.4.3 or greater of the SDKs. A binding for a version earlier than that will not work, and I'm sure you're aware, Xamarin is not officially supported.
  • 4,268
1 vote

Preventing Free Domains from Submitting Marketing Cloud Forms

Unfortunately nothing like that is available OOTB, but if you build your own forms on CloudPages, you could use the Domain function to prevent a list of domains from being able to submit data. Here's ...
  • 11.7k
3 votes

How to make the code resource URL private for SFMC use only

The other answer is the correct one, and well explained. I just feel this is a nice addition: After setting your page to private / authenticated, you could also make it show up in the appExchange Menu ...
2 votes

Storing JSON API payload in triggered send data extension field

There are may be better ways to achieve your requirement, this is how I would tackle. Key Challenges and solution Fields which needs to store JSON require more than 4000 chars which you can overcome ...
6 votes

How to make the code resource URL private for SFMC use only

You can use the authorization code flow to check if the user accessing the CloudPage/Code Resource url is logged in, and if not, the user will be asked to log in to Marketing Cloud using their ...
  • 11.7k
4 votes
Accepted

Send an email to subscriber and to manager via Triggered Data Extension

Although it's technically possible to create a sendable Data Extension (including a Triggered Send Data Extension) with two email address fields, using this DE for a send will result in an error and ...
  • 11.7k
4 votes

Send an email to subscriber and to manager via Triggered Data Extension

You can't use a sendable data extension with multiple emailaddress fields. This is why: If a subscriber exists in All Subscribers list, your email will be sent to the email address which sits in All ...
  • 17.6k
1 vote
Accepted

Encryption Key with Puttygen - AUtomation Extracts

I believe it is zipped and not encrypted. If you generate a tracking extract and name the exported file something.csv, opening it will fail, as Tracking Extracts will always be one zip file with ...
  • 17.6k
1 vote
Accepted

Add subscribers to a publication list without sending an email (Marketing Cloud)

So, after giving it some thought, I've come to this solution: I created an automation with three steps: An SQL activity that will query the leads directly from our Sales cloud Org, and store the ...
2 votes

Changing AMPscript dynamic links after send

Nope, you cannot. AMPscript is a server-side language, meaning that it’s interpreted at send time on the server and the value used as the link is taken from the DE at that time and rendered in the ...
  • 11.7k
3 votes
Accepted

How can a Shared Data Extension be accessed by API using DE's External key?

Even though they are visible with in the UI of the BU you are integrating with, Shared Data Extensions always “belong” to the Enterprise BU. Hence your API call needs to authenticated using a token ...
  • 17.6k
2 votes
Accepted

Concatenate ordered CampaignMembers in SQL

Updated query as per your requirement to SORT based on CampaignMemberCreatedDate You change the ORDER by ASC or DESC SELECT OutTab.contactid, campaignname = Stuff ((SELECT ',' + InrTab....
3 votes
Accepted

Will contacts currently in my journey go through a decision split added after starting the journey?

You can only edit the flow by creating a new version of the journey. This will allow you to add a decision split in your flow. You do need to observe, that by editing a new version, you will not ...
  • 17.6k
2 votes
Accepted

Retrieve QR CODE from Marketing Cloud

You can either use the Content Builder API to upload the image directly to Content Builder: Marketing developers, service providers, and third-party developers can create and manipulate marketing ...
  • 11.7k
0 votes

Trying to add a new row to a "Shared Data Extension" using SSJS

To expand on the WHY. Shared data extensions are owned by the enterprise regardless of what BU made them.
  • 1
2 votes
Accepted

SFMC: Can the HTML exceeded notification be omitted when previewing and testing emails?

Unfortunately this is built into the back end of SFMC and is not available to be turned off/on by users. You could talk to your Account Executive about it, but I get the feeling that it is not ...
  • 28.7k
1 vote

On IOS when the app is closed, when clicking on a received notification it won't go through the sfmc_handle method and it always open the app instead

FYI: I have tested official SFMC learning app and looks like sfmc_handleURL callback won't be called when iOS app is not running (killed) and user taps on push notifications (It only opens the app) ...
  • 11
4 votes

Multiple OR for one variable and with AND CONDITION

This question is honestly pretty bad and likely should be closed due to lack of details/efforts displayed, but as its a fairly simple answer, I thought I would put something up for those that face the ...
  • 28.7k
3 votes
Accepted

How to hide a logging error in a Marketing Cloud Cloud Page?

The error you are seeing means that an insert to a Data Extension in Marketing Cloud is failing. The data extension is called “SubscriptionCenter_Log” and the script seems to be failing to insert a ...
  • 11.7k
1 vote

Marketing Cloud AMPScript - Condition to check if a prospect is or is not in SF

You could do it like this: Check if the person is in SF, if yes, unsubscribe them from there On top of that, always unsubscribe them from Marketing Cloud, regardless if they exist in SF or not %%[ ...
  • 11.7k
1 vote

Where can I find the cause for 'Soft Error' when MC fails to create a Task?

Ask SF support - they can review the backend error logs, but it might be a lot data for them to sift through. I have heard about errors like this and at times it was due to CPU overload of the ...
0 votes

Marketing Cloud MobilePush SDK React Native Push notification integration

No form needed. Initialize the SDK and the device will automatically be registered.
  • 4,268
1 vote

Where can I find the cause for 'Soft Error' when MC fails to create a Task?

I don't think it's possible to look up the exact error message anywhere, but according to the documentation, you can try troubleshooting using this information: Runtime Errors Runtime errors occur ...
  • 11.7k
1 vote

Import file every hour

There is nothing wrong with keeping the %%Year%%%%Month%%%%Day%%nameoffile.csv naming convention. What will happen is, the files will be overwritten for each hourly upload, but the import into ...
  • 17.6k
0 votes

Marketing Cloud: Overwriting AllContacts

As has been said, what you are proposing isn't possible. I think your best option for the issue is to have a daily automation that uses SQL to return contacts that now have a valid Salesforce CRM ID, ...
1 vote
Accepted

Update DateTime Field in Data Extension to Current DateTime Via REST API

After very long back and forths with SFMC; there is NO way of persisting this functionality from the FTP process to the API process. You can either: Pass a timestamp via the API request or Use a ...
  • 51
0 votes

Solved: Email apparently sent in Journey Builder but in error in Tracking Sends

If it can help: I searched a solution during hours, but what solved the issue had been to duplicate the email (in Email Studio) and assign the copied email to the Journey. Without any change. So I can'...
  • 113
2 votes
Accepted

When adding the AMPSCRIPT "InsetData" function in my Cloud Page, it get an error 500

I suspect this is due to lack of proper data validation prior to firing your insertData() function. It expects a value in @subkey variable. This is set in this statement in the top of your code: set @...
  • 17.6k
2 votes

Einstein product recommendation(SFMC) need training time? If it is what will be the minimum time

Best practice is to observe website behavior for at least 30 days before launching any predictive content logic. This 30-day monitoring period allows the engine to dynamically build profiles and ...
  • 11.7k
2 votes

SFMC Connector or Data Extension

This is a broad question and there is no 100% right or wrong answer here. I wouldn't be surprised if this gets closed. What can be generalized: If you already have a system storing personal data in ...
0 votes

Data extensions and folders not visible in marketing cloud when I created them via SOAP api

The typical error I run into with this is that I have created a token for another BU by mistake, and am looking in the wrong BU. You can always try to retrieve the Data extension through SOAP API to ...
2 votes

lookuporderedrows with additional IF condition

If I'm understanding your case correctly, I think you just need to keep track of the previous product and check when it changes. Here's how I'd approach it: %%[ set @debug = 1 set @cid = ...
  • 28.4k
0 votes

Mobile push does not return feedback from push operations when sending a notification

Try the running the MobilePush Detail Extract Report. There is a similarly named report in Analytics Builder > Reports, but it does not contain the ServiceResponse column - the values stored here ...
2 votes
Accepted

SQL Activity Query - return subscribers from publication list if they don't exist in another publication list

You’re using two and operators in your filter which is probably why it’s failing. I’d approach it slightly differently and instead of a join, use a condition to return subscribers from one list if ...
  • 11.7k
3 votes

Find the most represented value in a Data Extension

You would just need to create a subquery to grab those values and then query that to get just the max count from that sub query. See below for example: SELECT TOP 1 a.type_c FROM ( SELECT TOP ...
  • 28.7k
4 votes

Enforce Message Expiration - MobileConnect

Enforce Message Expiration cancels all SMS sends that are in progress once the blockout window starts. Usually, sends do not pause at the send blockout: For example, if your send starts at 9 PM and ...
  • 11.7k
2 votes
Accepted

AMPscript round a number unless it's 'round'

This is a usecase for the modulus function (mod()) - essentially you want to test if something is a whole number. references: https://ampscript.guide/mod/ https://exceljet.net/formula/number-is-whole-...
2 votes
Accepted

SQL Coalesce Function Not working for Text Attribute Fields

So empty and null are two different things. If the field contains an empty string, this will not be read as NULL by Coalesce and it will display that value instead of moving to the next one. To get ...
  • 28.7k
1 vote

AMPscript round a number unless it's 'round'

Not sure if this would be the best solution, but you could "cut" the .00 from the string in case it's there using the Substring function: %%[ ... if indexOf(@regularprice, ".00") ...
  • 11.7k
1 vote
Accepted

Linking a DE to all contact records within an attribute group

This might not be a very elegant solution, but what you COULD do, is either create a WeatherDescription field on your main contact data extension, or a replica of it, with only the ContactKey and ...
  • 17.6k
1 vote

Using the same DE, but contacts entered Journeys were different

So, nothing was wrong in this case. I've checked all the data belonging to the journey themselves and found out that these two journeys have been using the same DE, which was the destination DE of an ...
3 votes
Accepted

Get SQL Function for AppropriateTimezone

You can use the AT TIME ZONE in SQL to convert the time zone to UTC to match what is in Salesforce Health Cloud. SELECT starttime AT TIME ZONE ‘UTC’ Here is more information on Using AT TIME ZONE in ...
  • 4,498

Top 50 recent answers are included