0

Some Subscribers are not showing up when I create a simple SQL Query activity? I have tried the query with no 'Where' and no Joins. Some subscribers are not showing up. They are active in the All Subscribers List.

  • Can you find those subscribers in your source data extension after exporting it to FTP? Can you find them there with a filtered data extension? – Rafał Wolsztyniak Jan 28 at 16:21
  • Just tried a filtered data extension and the records were there... Why wouldn't they show up in my SQL Query Activity? – Becky AllturnaOD Jan 28 at 16:24
  • 1
    Do you have a different primary key in the resulting data extension? Keep in mind all we can do is take shots in the dark until you provide a sample of the query and data extensions you're working with. – AnonWonderer Jan 28 at 18:22
  • Thank you! I am going to look at my Primary keys - it may have something to do with that. My SELECT statement is very simple (SELECT profile_ID, Last_Name, First_Name, Registration_Date FROM [Data_Extension_1]) – Becky AllturnaOD Jan 28 at 19:09
1

Are you performing this query in a child BU?

If yes, try to query using the ent prefix

select
  SubscriberKey
from ent._Subscribers
| improve this answer | |
  • Good thought but the data is coming from another data extension that I created within the BU that gets overwritten daily. I am basically trying to get a portion of that data extension to target for an email send. – Becky AllturnaOD Jan 28 at 17:41
  • Please can you post the query and Target Data Extension field names? It's a good thing to check, if the field name is wrong in your query (in the select to the target Data Extension), you don't receive erro message, the data is simply "ignored" – Leto Jan 28 at 17:56
  • Also a good idea - Thanks for your response. I know the target data extension is correct because I am getting data inserted into it - just not all of the data that I expect. For some reason, it is excluding records. I have also tried the query with no where clause and there is no join in the SQL Statement. – Becky AllturnaOD Jan 28 at 18:00

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.