We are trying to setup a query that will return all associated emails that received the email based on the email name. We cannot use the JobID because we want to add this to a program and not have to update the JobID for each time the email is sent. We are currently using the query below and nothing is returning. I've referenced just about every table on the ET side, but wasn't sure if you guys could point me in another direction. Thanks
We sent 'Email_Name' to a subscriber on [Data_Extension_Name] and want to pull that back based off the criteria below.
Select A.EmailName, C.SubscriberKey, C.EmailAddress FROM _Job A INNER JOIN _Sent B ON A.AccountID = B.AccountID INNER JOIN [Data_Extension_Name] C ON B.SubscriberKey = C.SubscriberKey WHERE A.EmailName = 'Email_Name'
We receive this error when we run the query: Error 245 at line 2 of (NULL): Conversion failed when converting the nvarchar value 'Touch 1- Intro to KS' to data type int.