0

Does anyone know if it's possible to export Marketing Cloud Data Extensions to Email, not FTP?

In addition, if this could be scheduled to happen automatically?

We have automations in place that populate/update our Data Extensions which is why we want to track these changes.

  • How big is the data extension? – Samuel Dare May 25 '17 at 7:30
  • They will vary in size. Some will definitely over 50MB / few hundred thousand records with 50+ fields. – Rain May 25 '17 at 7:32
4

Short Answer:

No

Explanation:

The two methods of exporting data from a data extension are :

  1. If the file is less than 20 MB it can be downloaded to your pc.
  2. Files larger than this will have to be collected from the FTP location.

Reference: Exporting Data Extensions

NB:

For security reasons, your administrator might have set the export to the FTP regardless of size.

Caveat:

As with most things, it is possible to hack this. You would need to create an email and use the Attach Ampscript function to send it yourself.

| improve this answer | |
  • Hey, thanks a lot for this! Based on that AMPscript link, in theory - would the flow go about this : Automation studio to first create the Export file from Data Extension, then send email with that AMPscript function with the exported file being attached? What I'm wondering is how will it know to pick the correct file every day. – Rain May 25 '17 at 10:06
  • The best way to avoid this out be not to set wild cards on the export definition i.e. File.csv. This way it overwrites the file in the ftp, but you would have it saved in emails and the data extension – Samuel Dare May 25 '17 at 10:10
  • You could also write another Ampscript function that calculates the wildcard for the export job I.e timestamp and append it to the variables in Attach file call – Samuel Dare May 25 '17 at 10:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.