6
You need to match the sends more precisely than just on JobID, and use a LEFT JOIN instead of INNER JOIN, like in this example form SQL Reference: Query: Find Subscribers with No Opens or Clicks
So your SQL should look more like this:
SELECT s.SubscriberKey, s.TriggererSendDefinitionObjectID, s.JobID, s.BatchID, s.EventDate, j.EmailName, j.DeliveredTime, b....
5
You can’t do this directly between SFMC and S3. However, AWS has launched their fully managed SFTP service for S3 last year. If you have management access to the AWS environment and can configure this service, establishing a connection between S3 and SFMC should be straightforward.
5
Instead of using HTML, you should use newline and carriage return:
Concat("Example: ", @field1, "\r\n", "Example: ", @field2, "\r\n")
5
Are you sure you just want to delete all subscribers? There are few reasons why I will recommend you using the Contact Deletion Framework:
Deleting from All Subscribers will not necessarily remove the subscriber from billable contacts. And it will still count towards your utilisation.
Sendable data extensions might also contain traces of these contacts, ...
4
Why not just use inline AMPscript to output the @ImageURL value? Removing the double-quotes to make the concat function work is likely the issue:
<!--[if mso | IE]>
<td style="vertical-align:middle;width:150px">
<![endif]-->
<div class="mj-column-per-25 outlook-group-fix" style="font-size:0;text-align:center;direction:ltr;display:...
4
There are two functions in AMPscript that let you retrieve the parameters sent by the request message.
QueryParameter - Only usable for GET-parameters (suitable for your use case)
RequestParameter - Usable for GET- and POST-parameters (also suitable for your use case)
So your code would look like this:
%%=Lookup('DealerDE','Name','ID', RequestParameter('...
4
You're not checking if the variables have been populated, your code is missing if not empty rules. I suggest trying with the following script in the original version, as it was posted by Adam on his blog:
%%[
var @debug
var @jid
var @listid
var @batchid
var @email
var @skey
var @reason
var @unsubscribeAll
set @debug = 0
set @jid = AttributeValue("jobid")
...
4
BatchID is the 'grouping' of the email inside the batches sent to the Mail Transfer Agent for sending.
In a Bulk send environment, this means the following: (numbers are all arbitrary)
Assume that the MTA has a max of 100 emails per batch
You have an audience size of 1000 emails
You would have 10 batches inside your send, meaning for this jobid, you would ...
3
Both options are valid, it depends on how your DNS services and records are configured. This works:
; Root
$ORIGIN example.com.
@ IN NS ns1
@ IN NS ns2
; delegate sub.example.com to ACME nameservers
sub IN NS ns1.cdn.acme.com.
sub IN NS ns2.cdn.acme.com.
...
3
The closest you can get to this is by using the FormatDate AMPscript function with ISO pattern:
set @dateString = "9/14/2019 4:37:57 PM"
set @dateISO = FormatDate(@dateString,"iso")
%%=v(@dateISO)=%% outputs: 2019-09-14T16:37:57.0000000
You can then format this further using Replace and Substring functions:
set @dateString = "9/14/2019 4:37:57 PM"
set @...
3
Journey Builder does not detect updates to existing rows in a Data Extension.
This means the scenario described - with the Contact Update activity would not be enough for the second or third Journey to notice that some subscriber attributes have changed in order to inject it to the corresponding follow-up Journey.
There are couple of ways to do what you'...
2
Give margin:auto; to body in your CSS file.
2
It looks like you body CSS code is being overwritten with "normalize.css" that contains a "margin: 0px;" value.
Look around line 12 of you page code for the body{} CSS style. Find the part where it declares "margin: 0px auto;" and replace it with:
margin: auto !important;
You can also try this on line 35 on your Body tag:
<body style="margin: auto !...
2
Changes in your config will not help you debug your code. You need to add logging statements to the code of your endpoints. How this is done depends on the programming language you use. Maybe there is even the possibility to add breakpoints and debug through the code using debugging software.
Without supplying your code and environment details this general ...
2
You could try the FormatDate() function:
%%=v(Concat(FormatDate(AppointmentDateTime__c,"M/dd/yy","", "en-US")," at ",FormatDate(AppointmentDateTime__c,"","HH:mmtt", "en-US")))=%%
Also Adam and Eliot have some great info on AMPScript that you can follow here: https://ampscript.guide/
2
You can get exactly your desired output using the following:
%%[
SET @time = "9/14/2019 4:37:57 PM"
SET @formatted = Replace(FormatDate(@time, "YYYYMMDDT","HHMMSS"),' ','')
]%%
%%=v(@formatted)=%%
Output: 20190914T163757
2
The simple query version is a GET, but you need to use POST for the Advanced Query version.
Using HTTP.POST instead will likely get you the expected results.
1
Every time the VAWP link is clicked, the AMPscript inside the email is rerun making any 'current date' to be updated.
So if you sent it on 9/16 the date in the email would be 9/15. But if you open the VAWP on 9/20, it would show 9/19.
To get around this, would be to store this info inside a 'log' of some sort that you can then have the VAWP context look up ...
1
Recently I had this problem, So I wrote AmpScript code inside the content Block and started calling the content block with "ContentBlockByID". You can also use other functions from the AmpScript documentation
Code Snippet
1
As far as I'm aware, this was part of a beta program from sometime in 2016(?). There was documentation about it out there, potential in the release notes, but I just did a quick search and that looks to have been purged.
The system does still keep the related lists, creates workflows relating to SMS, and some accounts have it listed as a send option in ...
1
To extend Rachid's answer, you can use the following in case you anticipate that both Leads and Contacts might enter your CloudPage. In that case, both will be processed correctly:
%%[
SET @subscriberID = _subscriberkey
SET @CampaignID = ""
IF NOT EMPTY(@subscriberID) THEN
IF Substring(@subscriberID, 1,3) == "00Q" THEN
/* Lead */
...
1
As I said in the comment, Measures are a disaster! I've been told recently by the support that it will be deprecated in the next release after I had a lot of nonsense results using them.
I think one alternative would be an automation that queries the _Open data view and store it in a Data Extension that can be used by Data Filter. But be careful about data ...
1
Instead of using checkboxes, use two buttons for the submit, and then some AMPscript to get the form data and update your Data Extension.
Something like this should work.
%%[
var @EmailAddress, @FirstName, @LastName, @Company, @Status, @UpateDeRow
set @Status = RequestParameter('EmailAddress')
set @Status = RequestParameter('FirstName')
...
1
I'm not aware of a way to model your output in this fashion. Extract output formatting is pretty limited.
For some reason you even need to raise a support ticket to enable UTF8 encoding.
However, there are quite some "hidden features" not documented anywhere that can be activated through support.
As DMP integrations don't come very often this might ...
1
You need to create a list in your parent Business Unit: Email Studio > Subscribers > Lists
Then import the subscribers you want to delete into this list.
Then, delete this list and check the box to delete the Subscribers from All Subscribers.
1
If you want to trigger an SMS and use a data extension and don't want to use the Smart Capture approach as described by fromero, you need to use the REST API. You can do this with use of QueueMO method you're referring to: QueueMO REST API. This can be done with HTTP request SSJS function, see this post for further information: REST API Methods in AMPScript ...
1
The query you posted in the comment will work:
SELECT COUNT (s.JobID) AS Send_Count FROM _Sent s INNER JOIN _Job j ON s.JobID = j.JobID
WHERE j.EmailID = '221125'
I wanted to propose something similar, which will give the same result:
SELECT COUNT (SubscriberKey) AS SENT_COUNT FROM _Sent
WHERE JobID IN (SELECT JobID FROM _Job WHERE EmailID = '221125')
...
1
There are a couple of examples of parsing and looping through an RSS feed floating around SFSE. The example in the official docs is super-fragile and confusing, IMHO.
Here's one that includes a count and date limit:
<html>
<head>
<style>
body, a, input {font-family:sans-serif;}
</style>
</head>
<body style="font-...
1
From past experience, support will not be able to change this setting. We raised it through Account Executives who raised it through their internal contacts, but we were told it's not possible. Never hurts to try on your side though.
We explored the path of having the current Parent 'transformed' into a child business unit and replaced with a new clean ...
1
This is what I would do in your case. Not knowing if your system of record (SOR) for consent data is within SFMC itself (e.g. in a Consent data extension) or outside, this solution will differ slightly.
Firstly, a job needs to be set up in Automation Studio (in parent BU) to query your Complaint and Bounce data views. Once a day you (or more frequent, ...
Only top voted, non community-wiki answers of a minimum length are eligible
