Skip to main content
6 votes

sms send count more than population

This is because this is a count of # of messages sent. If the text message exceeds the 160/70 character count it sent as multiple-message You can review this in the _smsmessagetracking data view
EazyE's user avatar
  • 8,537
4 votes
Accepted

Encrypt in Marketing Cloud - Decrypt in Salesforce

Finally I found a solution. MKCloud AMPScript's default AES implementation is based on a 256 bit key size, CBC with 16 byte block size, and PKCS7 with 1000 iterations. The derived Key generation is ...
Jaume Bonet's user avatar
4 votes
Accepted

BuildRowsetFromJson not returning anything

First, you've got curly quotes in your JSON sample and in your code block. The new BuildRowsetFromJSON function returns a rowset, which you must interrogate for the specific row and field. %%[ set @...
Adam Spriggs's user avatar
  • 30.8k
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')
EazyE's user avatar
  • 8,537
3 votes

ClaimRow function within an "If statement" is claiming 1 additional row from a different data extension

**** EDIT **** I found your issue, you are missing a end quote on your first elseif statement. You never closed the quote to set the data extension in your ClaimRow in the ELSEIF for B. Current: ...
Gortonington's user avatar
  • 30.7k
3 votes
Accepted

Is JobID same for daily running journeys in SFMC?

JobIDs for any triggered emails (including Journey Builder sends) persist until a publish event. To answer you questions specifically: Does JobID stays the same throughout the life of the journey? ...
Adam Spriggs's user avatar
  • 30.8k
3 votes

How do we update subscribers email address in all subscribers list when contact change their email?

I have added a step by step implementation guide on this below as this. Hope this answers your question or can give you and idea of fixing your issue. The automation solves the following This is my ...
Erlend Hansen's user avatar
3 votes

Dynamic SQL Top() clause in SFMC

You could do use the row_number() window function to assign a sequential number to each row (in random order) and then only select rows that less than or equal to your volume value. Something like ...
Adam Spriggs's user avatar
  • 30.8k
3 votes
Accepted

Sending Push Notifications Within Journeys Triggered By An API Event Without DeviceID

As long as the contact in your API event is already tied to a device ID in the Mobile Push channel, journey builder can send the Push Notification message to that contact without needing the Device ID ...
Duc Le's user avatar
  • 3,418
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 ...
Duc Le's user avatar
  • 3,418
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 ...
Duc Le's user avatar
  • 3,418
3 votes
Accepted

How to view Transactional Send Definitions in the Salesforce UI?

options.createJourney boolean A value of true updates the send definition to make it available in Journey Builder as a Transactional Send Journey. After the definition is tied to a Transactional ...
EazyE's user avatar
  • 8,537
3 votes

I am looking for a SFMC Data Dictionary template

The data views reference Subscribers, Lists and Publication Lists that have a standard schema, but the other views are for send and post-send activity. I use dataviews.io for reference, as well as ...
Adam Spriggs's user avatar
  • 30.8k
3 votes
Accepted

Pre Header in Salesforce

You need to set the value of your dynamic preheader in HTML before your opening tag, like this: Preheader : %%=v(@preheader)=%% HTML: <html> %%[ SET @firstname='Alex' SET @preheader = ...
Lukas Lunow's user avatar
  • 21.7k
3 votes

AMPscript Current Sunday

Here's how I'd do it -- with a little trick using indexOf and a string array of week days: %%[ /*SET @currentDate = dateparse('2024-04-06')*/ set @currentDate = Now(1) set @daysOfWeek = "...
Adam Spriggs's user avatar
  • 30.8k
3 votes
Accepted

Why is the total delivery count decreasing day by day in Journey Builder email tracking?

You should not rely on "delivered" count the first 72 hours after a send was initiated from SFMC. The reason is, SFMC assumes the email delivered unless a bounce is detected. Since SFMC will ...
Lukas Lunow's user avatar
  • 21.7k
3 votes

Why isn't my link getting populated when using AMPscript

You should use the Concat function along with RedirectTo, to implement this properly. Resulting in following code: <a href="%%=RedirectTo(Concat("https://website.com/",@variable1,&...
Lukas Lunow's user avatar
  • 21.7k
2 votes
Accepted

AMPScript AES Encrypted and Decrypt with Crypto Apex Class

Finally I found a solution. MKCloud AMPScript's default AES implementation is based on a 256 bit key size, CBC with 16 byte block size, and PKCS7 with 1000 iterations. The derived Key generation is ...
Jaume Bonet's user avatar
2 votes
Accepted

AMP script LookUpOrderedRows with deduplication

Here you go. This should answer your requirements. What I changed: I've set the second parameter of LookupOrderedRows to 0 to return all matching rows Added a variable called @place Added a condition ...
Rachid Mamai's user avatar
  • 4,711
2 votes

SSJS to send data to API

I see the following: a) Wrap a try/ catch around the HTTP.POST for debugging / to get rid of generic 500s. b) contentType needs to be the second argument, not sent as header c) headernames and values ...
Jonas Lamberty's user avatar
2 votes
Accepted

Integrate Google Analytics with SFMC

First of all, the ability to receive audiences requires GA360: Google Analytics Free users get access to sampled data reporting about their customer interactions. Marketing Cloud adheres to Google’s ...
Lukas Lunow's user avatar
  • 21.7k
2 votes

How do i resolve 'Error while processing square brackets' when there are no square brackets in the query?

The error might not have anything to do with Square Brackets. You might also get it because of syntax error, or even a SQL comment block (in between /* SQL COMMENT */). Try eliminating all comments in ...
LimeWeb's user avatar
  • 348
2 votes
Accepted

Bulk API in Journey Builder

As per winter '24 release, it is now possible to inject multiple contacts into a journey with a single API call: https://help.salesforce.com/s/articleView?id=sf....
Lukas Lunow's user avatar
  • 21.7k
2 votes

How many Automation will Create & Run In marketing cloud For standard success plan?

This has nothing to do with the success plan (which is defining the level of support received by you from Salesforce). You should instead look at the edition. Here you can see how many automation runs ...
Lukas Lunow's user avatar
  • 21.7k
2 votes
Accepted

Can Einstein STO delay subsequent email activities sent event in a journey?

STO is a wait step so they will not continue in the journey till they exit the wait step so if they exit at 4pm they will go to the next activity at that time. So in your example STO > Email 1 > ...
EazyE's user avatar
  • 8,537
2 votes
Accepted

How STO works with the settings "Send at Einstein's optimal default time" in journeys if optimal time falls outside the STO configured window?

Each configured window has an optimal time for that window and that's when the email will be sent Subscribers will also have an optimal time for each window. For example, if you have a 4 hr window and ...
EazyE's user avatar
  • 8,537
2 votes

Does anyone knows how to use Mobile App Events?

The most common issue is related to how you created your events in the UI with: All, Some, or None. The event is configured in the Marketing Cloud to accept the event's attributes, right? So, if all ...
Bill Mote's user avatar
  • 5,286
2 votes
Accepted

AMPScript does not format the time properly

Reference note from FormatDate function. The format patterns are not case-sensitive, but they must be used in the correct pattern argument (for example, both mm and MM are date and time formats). ...
Duc Le's user avatar
  • 3,418
2 votes
Accepted

Can you pass encoded url parameter strings in a cloudpages url?

I guess you're talking about the values not being decoded by ics.js, right? You can call decodeURIComponent either from SFMC side (that's a SSJS function, though, so you'll need to change some things ...
Vinícius's user avatar
2 votes
Accepted

What's the best Primary Key for a model with PersonAccounts?

PersonContactId as Subscriber Key ("relating to subscribers on...") PersonContactId as Primary Key. The reasons are outlined below. Using AccountId instead, and injecting into Journey ...
Jonas Lamberty's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible