Select * from accounts where profile. primaryEmail = 'someuseremail@emaildomain.com'

select * from profile where profile.email = 'someuseremail@emaildomain.com'

select * from contextualProfile where primaryEmail = 'someuseremail@emaildomain.com'

select * from profile where attribute.primaryEmail = 'someuseremail@emaildomain.com'

By accessing the Event Listener tab after configuring the event

By configuring the connector in the Connector Studio

By creating an application user in the Administration dashboard

By creating a server application from the application library

Segments

Group attributes

Profile attributes

Activity attributes

Activity indicators

select * from profile where having(segments, (segments.name = andsegments.value = ))

select * from profile where attributes.

select * from profile where having (segments, (attributes.segment= and attributes.value=))

select * from profile where segments.