Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.
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. ...
user avatar
  • 2,304
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 ...
user avatar
  • 2,304
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 ...
user avatar
  • 27.9k
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>...
user avatar
  • 27.9k
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 ...
user avatar
  • 7,367
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 ...
user avatar
  • 2,304
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 ...
user avatar
  • 16.9k
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 ...
user avatar
  • 16.9k

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