New answers tagged marketing-cloud
1
vote
Gmail one click unsubscribe 2024
Marketing Cloud has been providing one click unsubscribe for several years, by using List-Unsubscribe header: https://help.salesforce.com/s/articleView?id=sf.mc_es_one_click_header_unsubscribe.htm&...
- 20.5k
0
votes
Cloud Page - Security Headers
The code from the documentation is just an example of header, if images or CSS are on your page then you need to update this header to accept it.
So the issue is with this header :
Platform.Response....
0
votes
When using Cloud Page referencing an HTML Content Block to run SSJS
MC Cloudpage isn't designed to build a full website, but the most common use case is to build a landing page.
So what you can do is:
Copy directly the HTML content block that you want to use for your ...
- 2,588
0
votes
Dropdown List In CloudPage
I have used following above script and trying to display the value in a new cloud page.It is directing to a new page but value is not being displayed.Once I get the selected value from drop down I ...
0
votes
Accepted
SQL CASE Statement is not working in SFMC Query
You could replace the sub-query in your case statement with a left join, assuming it's a 1:1 match:
Select
B.Pd
, P.AB
, P.GR
, P.Pc
, P.Ac
, B.bt
, CASE
When B.bt IN ('1a','1b') THEN 'YES'
...
- 30.2k
1
vote
Accepted
SQL Query Issue to get last 12 Months data from a DE in SFMC
Your query is only getting the data for November 2022 because you are using the = operator to compare the month and year parts of the date. This means that you are only selecting the records that ...
- 968
0
votes
Import File Activity Automation - Change field data type to match Data Extension
There are only two ways of doing this:
Update the value in the system exporting the data to the CSV
Import into a data extension with field type Text, and use SQL to process the value into the right ...
- 20.5k
2
votes
Accepted
Marketing Cloud : Text Response works for the first time while issuing error messages afterwards
Each message would need a next keyword configured to handle conversations like this.
You could also create ampscript in your default keyword message to handle comments not assigned to a keyword
- 8,295
1
vote
Accepted
How can I get the delivery details of a email sended by /interaction/v1/events
The "key" using here is the triggered send external key in the triggered send definition/ the Event Definition Key in the transactional journey.
After you determined the correct key, you can ...
- 2,588
2
votes
Unsubscribe user with one subscriber key but many email addresses
Only one email address can be bound with a subscriber key.
When you send an email with setting the field "Use email attribute from Entry Source" in journey builder, this will update the All ...
- 2,588
3
votes
Accepted
Marketing Cloud : CreateSalesforceObject not working
Based on your latest update, it seems to be a visibility issue between the CRM integrated user (the connected user) and the object.
I would go to Salesforce CRM to check that user's profile and make ...
- 2,588
2
votes
Accepted
Get complete URL with parameters in SSJS/Ampscript
I'm moving my comment here as you asked.
You can combine the use of two functions:
ReferrerURL to get the base referrer's URL
QueryString to get the full query string (and yes it works even if one of ...
- 4,529
-1
votes
Resend an email from SFMC using SF-CRM- IER data
We have built a custom app that will allow the Salesforce user to (1) preview a send-time personalized email in the IER object and (2) resend the individual email with send time personalization to the ...
- 158
0
votes
Resend an email from SFMC using SF-CRM- IER data
I don't think you can resend the email just based on the Individual Email Result record you have.
The biggest problem with this is that the IER record doesn't provide data source attributes for the ...
- 2,588
1
vote
SFMC Device ID(s) by Contact Key - REST API
You can do that with the /contacts/v1/attributes/search endpoint. Example payload:
{
"request": {
"attributes": [
{
"key": "...
- 148
3
votes
Is there a way to generate the "Push Message Detailed Report" or "Mobile Push Data Extract Report" for all BU?
I would make a workaround that there is automation in each of my BU, it will pull and push the data into one place. This is due to Push data, you pull from a BU that belongs to that BU, so you need to ...
- 2,588
0
votes
How to use DE suppression list in the journey builder?
You cannot use suppression list in journey builder send, use Exclusion Script in the journey email activity instead.
In your journey, click on the Email Activity and select the Email
Select the ...
- 2,588
0
votes
Accepted
File drop is being picked by the wrong automation due to similar names
Thanks both for providing your inputs. To summarise we have 2 options to resolve this issue -
Follow proper naming conventions for file drops say starting with campaign name first and avoid using ...
- 19
0
votes
Accepted
Custom From Name SMS in Journey Builder
I think the best way to know is that you can try and experience it yourself. To me, I have no problems with using multiple From Names for the same short/long code in my MC account.
Additionally, you ...
- 2,588
0
votes
Salesforce Marketing Cloud - Not Opted in with error "Missing or invalid device token"
Please check the environment in which the app is built (ie) either production or sandbox environment and point the same in the MC UI.
You can check the environment using the script in send a test push ...
1
vote
I'm having trouble with mail merge field showing in Gmail or Yahoo from Salesforce Marketing Cloud. Do I need to format the data extension different?
Mail merge (Ampscript based personalisation) is done server side, hence this is not depend on recipient’s email client. I can imagine two potential issues:
Less likely: your CSS causes the first name ...
- 20.5k
1
vote
Delivery Window timing
A throttle window wouldn't happen after the end time, An email wouldn't be sent after 3 in this case.
Inversely emails won't send before the window is open
Caveats is to ensure no one one is in the ...
- 8,295
4
votes
Accepted
Get MID from CloudpagesURL()
You could pass a custom attribute in the cloudpagesurl() function and leverage that
%%=CloudPagesURL(ID, 'MID', memberid)=%%
Then on your cloudpage:
SET@VAR= QUERYPARAMETER('MID')
- 8,295
0
votes
Access shared data extension from child BU using SSJS
This works and filters on Email.
var deObj = DataExtension.Init('ENT.Contact_Salesforce');
var filteredRows = deObj.Rows.Lookup(["Email"], [emailAddr]);
2
votes
Accepted
Is there a way to process SQL queries in Salesforce Marketing Cloud based on criteria in another unrelated table?
Here's a pattern that I use for referencing a "parameter" data extension.
You can reference the results of the join in a case statement or in the where-clause, depending on the specifics of ...
- 30.2k
2
votes
Accepted
Do I need to have a random split before my email activity?
200k is not a big audience. You should be fine without a random split. If you want to delay your send throughput for some reason (e.g. you have a link in the email to your site, and you're afraid it ...
- 20.5k
2
votes
Accepted
Do I need to warm my IP Address again?
Based on the little information you are sharing, it is impossible to provide you with a good answer. But, few points to consider:
Are you on a shared or private IP? If shared IP, you should not need ...
- 20.5k
0
votes
Accepted
AMPScript Lookup row function
Yes, you can use an AMPscript variable as the Data Extension name.
Perhaps the email is coded to work in multiple business units when using the Multi-Org Connector, where the sync'd Contact DE name ...
- 30.2k
0
votes
Accepted
Deleting Subscribers from Hidden Triggered Send Managed Lists in Marketing Cloud
Actually, you don't need to have the Subscriber Id in your data source to perform the contact deletion.
As long as, the data source is a sendable DE and have the "Subscriber key relates to ...
- 2,588
1
vote
Export view details from Journey Builder
In your current SQL, you are searching for subscribers in the journey that received an email. However, on the screenshot, you have Update Contact Activity, which is not anyhow related to the email ...
- 2,650
0
votes
Encrypt in Marketing Cloud - Decrypt in Salesforce
Thank you for your answer @Jaume Bonet. Here's my code.
import crypto from 'crypto';
let password = 'anypasswordvalue';
let initVector = crypto.randomBytes(16); // 16 bytes (128 bits)
let salt = ...
0
votes
Can a connected org be inherited by child bu in multi connector
This is not a bug, but a known limitation.
Salesforce created a knowledge article on it last year.
In short, if you want to have a different setup per BU, it is mandatory to utilize different SF org ...
- 5,680
0
votes
EncryptSymmetric AMPScript AES
this code in JS does return the same result as SFMC
const password = 'PASSWORD';
const salt = CryptoJS.enc.Hex.parse('0000000000000000');
const iv = CryptoJS.enc.Hex.parse('...
1
vote
How do you use Salesforce Data Cloud data for personalization in SFMC?
I'm no SDC expert but I have the same problem with a client.
Currently I've created a combination of ssjs and ampscript to parse the json string and loop through it to set the variables as ampscript ...
1
vote
Marketing Cloud - Journey Builder - Engagement Split
Couple of things you could check here:
Is the analytics showing any opens? The chances are less yet worth checking whether anyone did open your emails, at all? Check the email deliverability and ...
- 29
1
vote
How to use Journey Exit Condition as Trigger to Execute Activity
You could potentially look at using the undocumented /interaction/v1/interactions/journeyhistory/search REST API route in conjuntion with scripting from an Automation Studio program. @Gortonington did ...
- 8,156
0
votes
Extract from Data Extension using Webservice
You're probably looking for this route:
{{hostEndpoint}}data/v1/customobjectdata/key/{{DEKey}}/rowset
I'd also suggest checking out the official SFMC Postman collection. It's more helpful than the ...
- 30.2k
1
vote
How to create an alert when blank AMPScript data and cancel send
Here’s what you need:
RaiseError
This function enables the suppression or cancellation of an email
send. It is useful for exception handling in your code, if an
unexpected result occurs.
Examplefrom ...
- 14.3k
0
votes
0
votes
Need details on the "reason" data found in Tracking Extract NotSent file
Here is another good list of email send error codes. It gives the error code, reason, and a brief description. You should be able to cross reference the not sent reason from the Not Sent extract with ...
- 1
0
votes
Device Id never show to new contacts and don't receive notifications
After a long time racking my brain over this... I discovered that a character in my "acessToken" was wrong, instead of a "j" there was an "i" and I hadn't noticed because ...
1
vote
Accepted
Exclusion script in Marketing Cloud is getting an error
Did you copy paste the exclusion script from a Microsoft Word document or similar?
If you look very carefully, you will find your quotation marks around Email being of a different type than standard: “...
- 20.5k
0
votes
How to assign multiple coupons at the time of email sending
The only way I could figure out how to assign multiple coupons per subscriber was to pre-assign the coupons before sending the email. This works for our use case. We used a cloud page to process.
&...
- 93
0
votes
Accepted
Can we pass email body in API payload for sending email in salesforce marketing cloud?
As far as I know, there is no standard API that could be used to achieve this.
Here is an idea, but it's not been tested and I don't recommend it even if it works.
You can try to create a template in ...
- 158
0
votes
Retrieve a list of all JobID done in Marketing cloud
I've been looking in to this and think it can be accomplished with 2x REST API routes.
STEP 1
First, you **retrieve a collection of send instances:
GET https://{{et_subdomain}}.rest.marketingcloudapis....
- 195
0
votes
How to assign multiple coupons at the time of email sending
Your first attempt should be fine. I think you were seeing some previous coupons due to the preview mode in Content Builder.
However, I would recommend using the ClaimRow function in your second ...
- 2,588
-2
votes
Can we pass email body in API payload for sending email in salesforce marketing cloud?
YES you can!
To ensure proper functionality, utilize 'httpgetwrap|' for each link within the email body. Please note that this method exclusively applies to the first 100 links. Be mindful of the ...
- 140
1
vote
Accepted
How to assign multiple coupons at the time of email sending
Hello fellow campaigner,
one coupon is being assigned to multiple email addresses as the the actual database update happens after all emails are personalized. Basically you can see the data extension ...
- 140
0
votes
Marketing Cloud data & configuration backup
I know this is very old but want to leave a note for anyone looking.
Take a look at stashr.io for SFMC backup and recovery.
0
votes
Refresh Email template -Transactional Journey
Hello I had to overcome similar issue lately. Apart from the content block you can simply go into the transactional journey
open the email activity
select in drop down "Activity summary"
&...
- 140
Top 50 recent answers are included