0

I need to export tracking data (sent, opens, bounces, etc.) in CSV file from Marketing Cloud to a Data warehouse through sFTP folder. I would use the system data extension as explained here and retrieve email's names and Job's names. Do you have any suggestions how can i do this?

Improve this question
1
  • Please go through your questions, and mark answers as accepted - I see you have so far only done this on few of your questions, and mostly where the answer was provided by yourself. As a community, everyone here appreciates to know if they have been helpful to you or not.
    – Lukas Lunow
    Commented Mar 21, 2019 at 11:29

2 Answers 2

Reset to default
1

You'll probably find the Tracking Extract more useful for your purposes, than Data Views, if what you'd like to do is push this data to SFTP for your DWH. These are somewhat more comprehensive than Data Views and would give you the name of the email from the Job extract.

See Tracking Extract Output for details of what's available. If you do not have Tracking Extracts available as an Extract Type in Email -> Interactions -> Data Extracts or in Automation Studio Activities when you're defining a Data Extract, create a case with Support to have them provisioned to your account.

Improve this answer
0

If tracking data of the last 30 days is sufficient for your needs, you could just use an automation with a data extract activity.

Further information:

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .