Bookmark this - it will become your best friend
Marketing Cloud uses Data Views to store information about events that have to do with email. These views are kept for a soft 90-ish days before the tracking is archived on their side (depends on how much you send and to how many users = amount of data they have to keep available etc)
You can access these data views in a query by referencing them as a table like as follows:
From this it sounds like you are looking for a particular email name and user it was sent to - you can do this by inner joining the _Job, _sent, _click, _open, and _subscribers data views:
t2.EventDate as 'SentDt',
t4.EventDate as 'OpenDt',
t5.EventDate as 'ClickDt'
t1.JobID = t2.JobID
t2.SubscriberID = t3.SubscriberID
t2.SubscriberID = t4.SubscriberID AND t2.ListID = t4.ListID AND t2.BatchID = t4.BatchID AND t2.JobID = t4.JobID
t2.SubscriberID = t5.SubscriberID AND t2.ListID = t5.ListID AND t2.BatchID = t5.BatchID AND t2.JobID = t5.JobID
WHERE t1.EmailName = 'Your Exact Email Creative Name' AND
t2.EventDate BETWEEN '10/01/2019' AND '10/02/2019'
Write it to a data extension with JobID NUMBER, EmailName Text(250), SubscriberKey Text(250),EmailAddress as Text(250), SentDt DATE, OpenDt DATE Nullable, ClickDt Date Nullable.
This query should give you a list of the contacts that were sent a certain email within a certain time frame.
Keep in mind - you might get duplicates if the contact was sent the email more than once, opened more than once, or clicked more than once. If you want specifics or don't care as long as they were sent and either opened or clicked, you should:
- add a MAX() around your EventDates and add a Group By t1.JobID,
- Remove JobID from the Select query all together and remove from your destination data extension.
Be careful to read notes about the enterprise-level accounts and the timestamps being in different time zones.
Hope this helps!