Thank you, that worked. Sorry for being slow on that one.
Can you help me with one more thing please?
I went to add an extra filter item, I only want people with an Event date of 3 days ago. The Event date field is date & time though, so when I select "today minus 3 days" nothing is selected. What is the syntax to trim the date & time so that Campaign only looks at the date portion of the field?
In general, the broadLogRcp table stores the delivery logs and trackingLogRcp stores the tracking logs. This however can be changed from the target mapping used in a delivery.
You can verify this by clicking on "To" in the email editor and check the target mapping. In this target mapping , you can find the details where logs are stored for this delivery . So you should query on these tables for the delivery you have sent.