30 minutes is the standard timeout limit for queries in an Automation. If you have Proactive Monitoring Service from SF, they can increase that limit upon request after all efforts of tuning your queries/redesigning can't remedy the situation.
After failing all efforts on our end to tune the query, we raised a Case for Developer Support. Salesforce tried ...
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 ...
Presumably you have the birthday date in Marketing Cloud somewhere? If so, I think you can simplify this by just having your SQL query look for everyone with a birthday +14 days from today and use the resulting data extension (configured as overwrite) as your journey entry source. As long as your journey settings allow re-entry, there should be no need to do ...
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 ...
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 ...
I would suggest going trough those pages and using APEX to help you here :
Date dateForSoql = Today().addDays(-30);
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 ...
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 ...
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("...
If you need to limit the results to only those that have a single order in a day, you could do something like this:
From orderDE o
o.productcode in (203, 211, 502)
AND o.purchaseddate > convert(date, getdate()-1)
and exists (