There are two SQL queries in Automation
Studio
1. Find
SubscriberKey from
Email: To obtain the
subscriber's
details, email address, and
Subscriberkey.
2. Get
Subscriber Send History
& Engagement: This will
return the
subscriber's send history for the last 6
months.
STEP 1:
Navigate to Journey Builder >
Automation Studio > Activities > SQL
QUERY folder
Click on the "Find
SubscriberKey from
Email" query and
edit
the query.
Update the WHERE clause email
address to the subscriber's email
address.
SELECT
SubscriberKey,
EmailAddress
FROM ENT._Subscribers
WHERE EmailAddress IN ('Subscribersemail@email.com')
Click through the steps
without making additional edits
and click 'Finish'.
Click 'Run Once'.
Find the destination data extension
in Email Studio > Subscribers
> Data
Extensions > Subscriber
History
> Find_Subscriber_Key
View Records to get the query results
and copy the subscriberkey.
STEP 2:
Navigate to Journey Builder >
Automation Studio > Activities > SQL
QUERY folder
Click on the "Get
Subscriber Send History &
Engagement" query
and edit the query.
Update the WHERE clause to the
subscriberkey that
was the result of the first
query.
SELECT Distinct
a.SubscriberKey,
a.JobID,
a.EventDate,
b.EmailSubject,
b.EmailName,
c.EventDate as OpenDate
FROM _Sent a Inner Join _JOB b on a.JobID = b.JobId Left Join _Open c on a.SubscriberKey = c.SubscriberKey
Where a.SubscriberKey IN ('enterthesubscriberkey or subscriberid')
Click through the steps without
making additional edits and click
'Finish'.
Click 'Run Once'.
Go to Email Studio >
Subscribers > Data
Extensions > Subscriber
History
> Subscriber_Send_History
Select the Subscriber Send Histor
data extension, and click "Records".
Click 'Export'
Select 'Browser Download' if smaller
than 20 MG. If file exceeds 20 MB, you must
select the FTP Export option.
