2
votes
Accepted
Can you populate SendLog DE with a different value than the one in target DE matching field?
First of all, there are four ways of populating a custom field in the Email SendLog:
1.1 Matching field name in the Sendable DE
1.2 Matching attribute name passed in the API's Payload (e.g. ...
2
votes
Accepted
How to optimize the email AMPscript code that has a lot of lookups?
You can create one central Content Data Extension and then pull from it all the needed 30 fields based on the email name using LookupRows AMPScript function. That would be definitely more efficient ...
2
votes
Accepted
Data retention policy doesn't apply to existing records in data extension?
All existing records will have the start time be when you set the retention. This is because the entry time of a record to a DE (hidden field _CreatedDate) does not exist until you set a data ...
2
votes
ampscript lookup to limit number of rows to display if there are more than 5 records
You'll need to check the rowCount of your lookup first.
If there are less than 5 rows it won't compile.
<table border="1">
<tr>
<th>Order Number</th>
<th>...
1
vote
How to create a data extension from a Mobile List?
This is covered in this KA article
Use a SQL Query Activity to query from this list into a new Data Extension (DE).
i. Within the Query, select the "Overwrite" Data Action. If either of the ...
1
vote
Missing records after Marketing Cloud FTP Export in my local file
As long as the export was executed correctly (if there is a file - yes), the file will contain all the records the Data Extension has. You can verify that by importing the exact same file back to ...
1
vote
Accepted
Pass the value from email to a content block using AMPscript
Ampscript gets evaluated top to bottom. So any declaration of variable further down in your code (whether it is within the email itself, or in a referenced content block) will always overwrite any ...
1
vote
Accepted
Want to perform Website tracking (only Website visits) through Collect tracking code
The catalogue data extensions (PI_CONTENT and PI_CONTENTATTRIBS) are not dependent on the behaviour tracking, as the data is originating from the uploaded catalogue.
When trying to enable data ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
dataextensions × 1392marketing-cloud × 1288
ampscript × 247
journeybuilder × 175
sql × 158
query × 134
automationstudio × 127
ssjs × 88
email × 70
soap-api × 66
contactbuilder × 59
data × 56
marketing-cloud-connect × 52
rest-api × 47
cloudpage × 34
api × 33
filters × 33
import × 32
fuel-sdk × 30
automation × 29
triggered-send × 28
data-views × 27
javascript × 23
lookup × 23
send-email × 23