I would like to create a query that would join on the data extension that was used in the job.
- Create a new data extension with the following fields: Email, Marketing_ID
- Send Email using above data extension.
- Create a report that will run daily. Which would find all open emails in the last 24 hours. It will also join on the data extension used for sending the Job to get get the Marketing_ID. (note: because the report will run daily, it has to be completely automated).
Is this possible?