New answers tagged

2

SELECT DISTINCT works on the entire row, not a single field. I like to use a partition to pick one of the duplicate rows: select top 1 with ties d.contactID , d.emailAddress , d.insertedDate from YOURDATAEXTENSION d order by row_number() over (partition by d.emailAddress order by d.insertedDate desc) The row_number() over (partition by will number rows ...


1

The order is first determined by the order in which the Data extensions are added to the send. THEN ordered by subscriberid ASC within each DE So DE1 Subscribers 8 2 4 6 DE 2 subscribers 1 9 7 3 5 Would send in this order 2/4/6/8/1/3/5/7/9


0

You won't be able to do this through the native Salesforce Activity History. You will need to write a custom Lightning Component that recreates the native Activity History and not just queries on the standard Email field but also the two custom email fields. A custom Activity History Lightning Component would be pretty complex project if wanted to match ...


0

Like Derek says, you should really give this a go. But here's an answer if you don't have the time: Create a new formula field on the Contact object that is of type Checkbox Use the following formula, substituting the abc.com etc with the domains you want to flag: IF(OR(CONTAINS(Email,'@xyz.com'),CONTAINS(Email,'@abc.com'),CONTAINS(Email,'@123.com')),true,...


0

So, there are a couple of approaches here: Write a Scheduled Flow that queries for all the past Tasks and then invokes the same flow used by your Process Builder to send the emails. The scheduled flow would be defined to execute once. Initiate some DML action (such as via Data Loader) on all past Task objects that are still Open such that the Process ...


1

Uploaded files go into the ContentVersion object. (isn't that obvious! just kidding). They are connected to an object via the ContentVersionLink object. The ContentVersion has an attribute called Title, and that should be where you can update the filename. https://developer.salesforce.com/docs/atlas.en-us.230.0.object_reference.meta/object_reference/...


6

This is the order of operations: Order of Operations AMPscript processes functions in this order: 1 HTML Body 2 Text Body 3 Subject Line Any preheader values reside at the beginning of the body and process accordingly. Source: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/...


2

It looks as though replacing the shorthand opening/closing tags (%%[ ]%%) with the longform does fix the issue for some strange reason. This is within the context of a Code Snippet block in the email editor. <script runat=server language=ampscript> SET @i = 0 SET @text = "You are <0>amazing</0>." SET @closeTag = concat("</...


1

I took your code that "doesn't work", and it does indeed work. copy / pasted example two (yes, I made sure) onto a cloudpage, added the AMPscript tags and wrote the output: %%[ SET @i = 0 SET @text = "You are <0>amazing</0>." SET @closeTag = concat("</", @i, ">") SET @tag = @closeTag SET @tagLen = ...


0

The contacts you import or sync via Salesforce will look like completely new subscribers in the All Subscribers list as they'll have different subscriber keys. Unsubscribes etc are processed at the subscriber key level - not the email address level, so you will need to do some work to sync the status values. This is something you can control. When ...


1

If you really need a real time notification, once a link has been clicked in an email, you can utilise the ENS which is a part of the new-ish Transactional Email feature of SFMC. The reason why I assume this is suitable for you, is the fact of you mentioning Triggered Sends: The reason I want this functionality is to ensure that a user receives the ...


0

This is not possible directly, however some workarounds are available. If you don't want subscribers to end up on a cloudpage, you can trigger the send from the cloudpage and redirect the subscriber to an external page right after the trigger. You can also create an automation that checks the _click data view. After a click, the send can be triggered. With ...


0

I didn't realize it was formatted JSON! I used Datasource and it worked like a charm.


0

This is resolved, the incorrect field was being passed to the Email Alert from the loop


0

Check out this trailhead module (specifically Contacts & Subscribers section): - A contact is a person you send messages to through any marketing channel. A contact typically appears in the All Contacts section, but a contact record can also appear in other locations. - A subscriber is a person who opted to receive communications or belongs to a ...


1

I think you may be misunderstanding the purpose of the AttributeValue function. It's meant to retrieve and validate contextual variables. You're also missing an opening block tag (%%[) before the first condition. Assuming that @action should be @CardTierDesc, you could do something like this: %%[ var @CardTierDesc set @CardTierDesc = AttributeValue("...


Top 50 recent answers are included