0

I'm going to start by saying this forum has been nothing but helpful and appreciate everyone taking the time to respond to others. This is my first post so I apologize if this is not following the format. Looking to have a SFMC query ran so that we can identify these records with mismatched emails but the problem is the information only exists in the all subscribers information. How can I add the AddMethod, and additonal data views into the query?

SELECT Distinct subs.EmailAddress
, subs.SubscriberKey
FROM _Subscribers subs 
WHERE
subs.EmailAddress != subs.SubscriberKey

UNION ALL

SELECT Distinct subs.EmailAddress
, subs.SubscriberKey
FROM _ListSubscribers subs 
WHERE
subs.EmailAddress != subs.SubscriberKey
3
  • It's not clear what the issue is, or what you are trying to accomplish, also listsubscribers and subscribers pull from the same root source
    – EazyE
    Jun 22 at 15:20
  • Apologies for not being clear. I want to know all the subscribers where the email address does not match the subscriber key with the data about how they were added. Jun 22 at 15:28
  • AddMethod is available in the _ListSubscribers data view, so why don’t you start with adding that to the query? And not sure what is the purpose of the union in your query - if you are looking to pull data from various data views, you should use a join instead
    – zuzannamj
    Jun 22 at 16:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.