2

Perhaps you can set a common value in each sending data extension -- like a field named Campaign with a default value of Newsletter. Then configure send-logging and add a sentDate and Campaign field. The sentDate column should default to today's date. Then you could have a query that pulls an audience from the send log where there are no opens or clicks for ...


2

They should still be available as their own activity called Salesforce Email Send. You might need to get that enabled in your account because I see it in some accounts but not others.


1

I would highlight two points on your solution. Time Zones: In which time zone is your birthday data coming in? And the time zone, in which the automation is running. Ideally, both should be same. Filter Criteria: You should put a safety check as a filter criteria in your journey that only records where BirthdayJourney = 1, or use Antonio's method above, to ...


1

In your code, you are not looping over the result set return by InvokeRetrieve. Also if you are filtering your result based on the triggered send customer key, it will give you the single triggered send name matching the filter criteria. Below is the code that I modified for you. %%[var @ret, @filter, @status, @rr Set @ret = CreateObject("...


1

If you need to limit the results to only those that have a single order in a day, you could do something like this: select o.subscriberID , o.phonenumber , o.productpurchased , o.purchaseddate , o.productcode From orderDE o where o.productcode in (203, 211, 502) AND o.purchaseddate > convert(date, getdate()-1) and exists ( select o1.subscriberid ...


1

There are no Cloud Page API endpoints. You can interact to a degree via the Content Builder Asset REST API, but not beyond just the content part (raw with AMPscript/SSJS - not rendered). There are 'internal' endpoints that are used in the UI, but we, as end users, do not have token authorization to use these endpoints. What you can do instead is do an HTTP ...


1

As Johannes correctly states, you will need to purchase file attachments, to be able to work with CSV files in emails. Also, I will not recommend attaching such files to emails, as they might grow quite huge. AttachFile is more suited for PDFs and alike. What about utilising a TXT Code Resource in Cloud Pages? Using Ampscript, you will be able to fetch the ...


1

This comes standard with Marketing Cloud Connect, but you need to be logged in as an integrated user to see this. In other words, there needs to be a "user level connection" together with the "account level connection" that the connector sets up by default, so that the sendout can be attributed to an owner. Typically, when following the ...


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