Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Troubleshooting Data Extensions

Salesforce Marketing Cloud Tips

There are other aspects that I find rather unknown; while there is likely a rational explanation, the platform doesn’t provide straightforward answers. Here are some learnings of mine while working with data extensions:

  • You can only increase the character lenght for strings and numbers.
  • You can get error updating filter. That is very mindblowing what is the actual cause.
  • Exporting rows from a data extension doesn’t guarantee their successful import. For instance, I exported rows from Contact Builder, modified a single flag, and attempted to re-import the same data. However, an error occurred indicating that the date format was incorrect. When I tried to import same file in email studio it worked.

Importing in Contact Builder throws a validation error on the date field. The same file has been successfully imported via Email Studio.

Results:

	Inserted: 0
	Updated: 0

ValidationErrors:

	Invalid Date: 16

Validation results have been logged to a delimited text file and attached to this message.
  • You can only utilize the quick search functionality for fields that are designated as primary keys.
  • You can refresh table records by changing pagination to another setting. Pagination is only available in contact builder.
  • You can change data retention only when records are below 100M but even then I could not see that working (maybe there is lag). Best is to set everything when creating the data extension.
  • Email studio is sorting folders and data extensions differently than contact builder. I can assume only that email studio is sorting alphabetically and contact builder by crated date.
  • To change / see data extensions structure sometimes it is faster by accessing it via email studio.
  • Retention settings only can be changed in Contact builder.
  • Tracking tab is only accessible in the Email studio.

Oh hi there 👋
I have a FREE e-book for you.

Sign up now to get an in-depth analysis of Adobe and Salesforce Marketing Clouds!

We don’t spam! Read our privacy policy for more info.

#data extension
Marcel Szimonisz
Marcel Szimonisz
MarTech consultant As a marketing automation consultant, I specialize in solving problems, automating processes, and driving innovation in my clients' marketing platforms.

I hold certifications in Adobe Campaign v6 (3x certified) and Salesforce Marketing Cloud (5x certified).

Additionally, I serve as a community advisor for Adobe Campaign, offering expert insights and guidance.

In addition to my professional pursuits, I also enjoy exploring various programming languages, CMSs, and frameworks, further enhancing my technical expertise and staying at the forefront of industry advancements.
Take a look at our subscription offering in case you are looking for a Marketing Automation Consultant.

Leave a comment

Your email address will not be published. Required fields are marked *

Similar posts that you may find useful

Adobe Campaign Classic tips
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC TIPS | How to aggregate data in workflow

1 minute read

Every now and then, you may receive a request to aggregate data within an Adobe Campaign Classic workflow. However, if you group by something other than the targeting dimension, you may encounter an error such as “‘w0.iid’ must appear in the GROUP BY clause or be used as an aggregate function. The reason behind Adobe … Read more

Continue reading
Adobe Campaign Classic REST over SOAP
Adobe Campaign, Marketing Automation

ACC TIP | Build REST over SOAP API

4 minutes read

If you’re familiar with Adobe Campaign Classic, you may have noticed that it utilizes the SOAP (Simple Object Access Protocol) API. We live in an age where REST is taking over, and the good old XML SOAP is slowly being forgotten. To me, as an old-timer, I can confidently say that it doesn’t make any … Read more

Continue reading
Adobe Campaign post
Adobe Campaign, Marketing Automation

ACC | Complete guide to schemas

4 minutes read

I want to gather as much information I have and have it at one place for my future reference and for others to learn what can be possible with the custom schemas in the Adobe Campaign Classic – ACC If you work with adobe campaign for some time you might figured out that almost any … Read more

Continue reading
Salesforce Marketing Cloud Tips
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Add html variation to proof subejct

1 minute read

Issues arise when an email’s HTML contains personalization that includes multiple different variants, that is altering the appearance of the personalized email. Quality assurance (QA) of such proofs can become exceptionally challenging, particularly in cases where there are minor changes across variants or a substantial number of variants present. You can devide your variants by … Read more

Continue reading
Adobe Campaign Classic tips
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC TIP | How to copy query conditions

1 minute read

Perhaps you’ve encountered an unusual occurrence while attempting to copy complex query conditions to your clipboard. In some instances, only a portion of the content was copied, while in others, nothing was copied at all. I’ve personally faced similar situations over the years but never delved deeper into the matter. However, one day, I reached … Read more

Continue reading